Facebook
TwitterHi,
I was long looking for a suitable script how to prevent our customers to overuse their mailbox quota. The problem is that many of the clients don't pay attention to quota limit mentioned on the webmail and/or are using other e-mail clients like Outlook or Thunderbird and won't see the quota limit at all, thus resulting full used quota and blocked e-mail and "mail quota exceeded" notifications.
To prevent this, many of our clients have requested a some kind of notification to mailbox users when mailbox quota is about to reach it's limit.
I remember that there were certain bash shell scripts provided, that would check every mailbox on Plesk server and in case the certain percentage of the quota is overused, the script would notify the mailbox user to delete some messages before the quota limit is exceeded and mailbox gets stucked and won't receive any more e-mails.
One of this kind of script was provided here couple of years ago: http://forum.parallels.com/showthread.php?t=71666
However, the problem with this old scripts is that they're designed for olded Plesk's / Qmails where mailbox quota was measured with different method than on the current branch of Plesk 9.3+/Plesk 10+ & Qmail. (Also some other older script required to include admin login & password inside the script, which I felt really risky.)
I decided to modify this first script (provided by azur99) to make it work with newer Plesk/Qmail. I needed to find a way to read quota from maildirsize file located in Maildir folder. I found from the some other thread that the first set of numbers in the first line should be the whole quota for the mailbox - and the sum of the other lines (first set of numbers per every line) should total the used quota. (This should not be read with "du" command, like in the original script, as it does not give exact result of the used quota, but instead the used disk space on the disk system of the same folder, which can be a lot different.) Comparing these two values calculated from the maildirsize file should give the percentage close enough.
In this case I also noticed that mailbox quota value is missing 4096 bytes, that is being added to the hardquota parametre - but the used quota values are missing some variating amount of bytes. This is why the percentage is some small fraction smaller than the percentage shown by Horde IMP webmail. However the difference is so small that it doesn't matter.
DISCLAIMER! Please notify that using this script is solely on your own responsibility. If it works, be happy. If it doesn't or causes any damage to your server, clients or your businesses, it's on your own problem. I won't take any responsibility for the possible problems caused. Using this happens on your own risk!
The script has been briefly tested to work with Debian Lenny 5.0 / Plesk 9.5.3 and Qmail, but it may work also on other configurations of Plesk 9.3+/10+ with Qmail. Also please notify that this script has not been tested on the long rung, so I cannot quarantee does it work with all cases (as it seems that maildirsize seems to grow lines with every received/deleted e-mail and all of these lines must be read with tail command and sum with paste/bc commands. I have no experience whatsover of this script in the long run, however it seems to work with our servers having 600+ domains / 1500+ mailboxes per server.)
Anyways here's the script and the instructions how to set it:
1. Copy and paste the followin script to notepad/pico or any other favorite editor of your's and save the file with name "mailboxquota.sh". (You may need to modify the Plesk installation path MAILROOT=/var/qmail/mailnames):
2. Transfer the file to path /usr/local/psa/bin/ in your server (or whatever the psa installation path is) and chmod the file to executable 0755.
3. Add following root crontab (crontab -e) to run the script once in every day on midnight (make sure the code is on single line only):
So the script should be automatically ran every midnight and send notification to every mailbox that is using at least 95% of it's mail quota. In case you want to modify that value, feel free to do so in the line SOFTQUOTA=$((95 * $HARDQUOTA / 100))
Also the values are modified to megabytes for the notification. If you want to use kilobytes instead, modify the two instances of $HARDQUOTA/1048576 to $HARDQUOTA/1024 and all MB's to kB's in the email template.
In my Debian system I was unable to change the sender mail address with setenv QMAILUSER 'do-not-reply' line, which why it's commented. In case it work's with you, you can uncomment it and modify mail -s to mail -r do-not-reply@$DIR -s.
Also a word about Plesk 9/10 mail quota calculation bug: We have noticed that from some version on the Plesk 9 branch mailbox quota calculation changed and deleted messages weren't no longer counted in the total used mailbox quota. IMHO this behaviour is wrong as it allows users to mark mail as deleted freeing the mailbox quota, withouth purging any deleted mails. This how the customers can continue filling the mailbox dir as the marking some mail as deleted is enough to free the quota. We have requested a fix for this issue (so that also mails that are deleted but not purged are also calculated in the mailbox used quota, and we received the fixed imapd and deliverquota files for 32-bit/64-bit Debian to fix this issue.) However, it seems that issue is still persisting in Plesk 9.5.3/10.0.1 so I hope Parallels will fix it in the future versions of Plesk.
Feel free to give me any feedback and comments about the script. Also any bugs found and reported to here are appreciated, however I won't promise to fix anything. I just felt I wanted to share this script to other Plesk admins and hope that they would benefit from it. Have a nice day!
I was long looking for a suitable script how to prevent our customers to overuse their mailbox quota. The problem is that many of the clients don't pay attention to quota limit mentioned on the webmail and/or are using other e-mail clients like Outlook or Thunderbird and won't see the quota limit at all, thus resulting full used quota and blocked e-mail and "mail quota exceeded" notifications.
To prevent this, many of our clients have requested a some kind of notification to mailbox users when mailbox quota is about to reach it's limit.
I remember that there were certain bash shell scripts provided, that would check every mailbox on Plesk server and in case the certain percentage of the quota is overused, the script would notify the mailbox user to delete some messages before the quota limit is exceeded and mailbox gets stucked and won't receive any more e-mails.
One of this kind of script was provided here couple of years ago: http://forum.parallels.com/showthread.php?t=71666
However, the problem with this old scripts is that they're designed for olded Plesk's / Qmails where mailbox quota was measured with different method than on the current branch of Plesk 9.3+/Plesk 10+ & Qmail. (Also some other older script required to include admin login & password inside the script, which I felt really risky.)
I decided to modify this first script (provided by azur99) to make it work with newer Plesk/Qmail. I needed to find a way to read quota from maildirsize file located in Maildir folder. I found from the some other thread that the first set of numbers in the first line should be the whole quota for the mailbox - and the sum of the other lines (first set of numbers per every line) should total the used quota. (This should not be read with "du" command, like in the original script, as it does not give exact result of the used quota, but instead the used disk space on the disk system of the same folder, which can be a lot different.) Comparing these two values calculated from the maildirsize file should give the percentage close enough.
In this case I also noticed that mailbox quota value is missing 4096 bytes, that is being added to the hardquota parametre - but the used quota values are missing some variating amount of bytes. This is why the percentage is some small fraction smaller than the percentage shown by Horde IMP webmail. However the difference is so small that it doesn't matter.
DISCLAIMER! Please notify that using this script is solely on your own responsibility. If it works, be happy. If it doesn't or causes any damage to your server, clients or your businesses, it's on your own problem. I won't take any responsibility for the possible problems caused. Using this happens on your own risk!
The script has been briefly tested to work with Debian Lenny 5.0 / Plesk 9.5.3 and Qmail, but it may work also on other configurations of Plesk 9.3+/10+ with Qmail. Also please notify that this script has not been tested on the long rung, so I cannot quarantee does it work with all cases (as it seems that maildirsize seems to grow lines with every received/deleted e-mail and all of these lines must be read with tail command and sum with paste/bc commands. I have no experience whatsover of this script in the long run, however it seems to work with our servers having 600+ domains / 1500+ mailboxes per server.)
Anyways here's the script and the instructions how to set it:
1. Copy and paste the followin script to notepad/pico or any other favorite editor of your's and save the file with name "mailboxquota.sh". (You may need to modify the Plesk installation path MAILROOT=/var/qmail/mailnames):
Code:
#! /bin/sh
# Mail quota reaching it's limit e-mail notification
# script for Plesk 9.3+ / Plesk 10 & Qmail
# Modified by "Scy" from the original script
# provided by "azur99" in Plesk forum:
# http://forum.parallels.com/showthread.php?t=71666
#setenv QMAILUSER 'do-not-reply'
MAILROOT=/var/qmail/mailnames
cd $MAILROOT > /dev/null
for DIR in *.*;do
cd $MAILROOT/$DIR
for MAILBOX in * ;do
if [ -d $MAILBOX ]
then
# look for specific mailbox quota file and set mailbox softquota
QUOTAFILE=$MAILROOT/$DIR/$MAILBOX/Maildir/maildirsize
# Fetching mailbox quota size in bytes
HARDQUOTA=$((`head -1 $QUOTAFILE | cut -d S -f1`))
HARDQUOTA=$(($HARDQUOTA+4096))
# Fetching space used by mailbox in bytes
MBOXSPACE=$((`tail -n +2 $QUOTAFILE | cut -c1-12 | paste -sd+|bc`))
# Calculate the quota limit required for mail warning (95% for default)
SOFTQUOTA=$((95 * $HARDQUOTA / 100))
# Calculate mailbox usage percentage (with two decimals)
MBOXPERCENT=$(echo "scale=2; $MBOXSPACE*100/$HARDQUOTA" | bc)
# Check if the mailbox is full enough for warning, and if, send the warning mail
if [ $HARDQUOTA -gt 0 -a $MBOXSPACE -gt $SOFTQUOTA ]; then
# Let's generate the values in megabytes (with two decimals)
HARDQUOTA=$(echo "scale=2; $HARDQUOTA/1048576" | bc)
if [ "$(echo $HARDQUOTA | cut -c1)" = "." ] ; then HARDQUOTA="0"$HARDQUOTA
fi
MBOXSPACE=$(echo "scale=2; $MBOXSPACE/1048576" | bc)
if [ "$(echo $MBOXSPACE | cut -c1)" = "." ] ; then MBOXSPACE="0"$MBOXSPACE
fi
mail -s "E-mail quota warning!" $MAILBOX@$DIR -a "Content-Type: text/plain; charset=ISO-8859-1" << EOF
Dear mailbox user,
Your e-mail '$MAILBOX@$DIR' is about to reach its maximum quota and is already using $MBOXSPACE MB ($MBOXPERCENT%) out of the maximum quota $HARDQUOTA MB.
We would kindly suggest you to delete some older messages and purge them to free some disk space for mailbox. In case the quota limit is reached, you won't be able to receive any new messages and the sender will receive 'mail quota exceeded' notifications.
The other option is to configure POP3 mail client (e.g. Microsoft Outlook, Mozilla Thunderbird or Mac Mail) that would empty the server mailbox every time the mail account is read and move the old mail to local disk of your own computer.
PS. This is an automated message and should not be replied. If you require any assistance, please contact to your mail server provider.
EOF
fi
fi
done;
done;2. Transfer the file to path /usr/local/psa/bin/ in your server (or whatever the psa installation path is) and chmod the file to executable 0755.
3. Add following root crontab (crontab -e) to run the script once in every day on midnight (make sure the code is on single line only):
Code:
00 0 * * * /usr/local/psa/bin/mailboxquota.sh > /dev/null 2>&1So the script should be automatically ran every midnight and send notification to every mailbox that is using at least 95% of it's mail quota. In case you want to modify that value, feel free to do so in the line SOFTQUOTA=$((95 * $HARDQUOTA / 100))
Also the values are modified to megabytes for the notification. If you want to use kilobytes instead, modify the two instances of $HARDQUOTA/1048576 to $HARDQUOTA/1024 and all MB's to kB's in the email template.
In my Debian system I was unable to change the sender mail address with setenv QMAILUSER 'do-not-reply' line, which why it's commented. In case it work's with you, you can uncomment it and modify mail -s to mail -r do-not-reply@$DIR -s.
Also a word about Plesk 9/10 mail quota calculation bug: We have noticed that from some version on the Plesk 9 branch mailbox quota calculation changed and deleted messages weren't no longer counted in the total used mailbox quota. IMHO this behaviour is wrong as it allows users to mark mail as deleted freeing the mailbox quota, withouth purging any deleted mails. This how the customers can continue filling the mailbox dir as the marking some mail as deleted is enough to free the quota. We have requested a fix for this issue (so that also mails that are deleted but not purged are also calculated in the mailbox used quota, and we received the fixed imapd and deliverquota files for 32-bit/64-bit Debian to fix this issue.) However, it seems that issue is still persisting in Plesk 9.5.3/10.0.1 so I hope Parallels will fix it in the future versions of Plesk.
Feel free to give me any feedback and comments about the script. Also any bugs found and reported to here are appreciated, however I won't promise to fix anything. I just felt I wanted to share this script to other Plesk admins and hope that they would benefit from it. Have a nice day!
