[exim] exim quotas with MySQL backend

Top Page
Delete this message
Reply to this message
Author: xyon
Date:  
To: exim-users
Subject: [exim] exim quotas with MySQL backend
Hey Everyone!

I'm working on setting up exim per-user quotas and all is going well
except that no warning message is sent when the 'warn_threshold' value is
met or exceeded. When email is sent after the quota limit is exceeded, the
mail is dropped (I don't have a bounce rule in place yet), so I know it's
recognizing the quota, it's just not apparently recognizing the
threshold... Here is my relevant exim config:

Code:

virtual_delivery:
driver = appendfile
envelope_to_add
return_path_add
mode = 0600
maildir_format = true
maildir_tag = ,S=$message_size
quota_size_regex = S=(\d+):
quota = ${lookup mysql{QUOTA_SIZE}}
quota_warn_threshold = ${lookup mysql{QUOTA_WARN}}
quota_warn_message ="\
To: $local_part@$domain,postmaster@???\n\
Subject: Warning - Almost out of email space\n\
This is an automated email.\n\
\n\
The storage space used by your email has \
almost exceeded the allowed limit.\n\
Please delete some emails, especially those \
with attachments, to free up space.\n\
Otherwise email will stop being delivered \
until you do so.\n"
directory = /var/spool/mail/$domain/$local_part/${lookup
mysql{FILTER_FOLDER}}


When running the MySQL statements manually from QUOTA_SIZE and QUOTA_WARN,
these values are returned respectively: 5M and 75%

Is there some option I'm missing? I've tried having the QUOTA_WARN return
a size value instead of percentage (ie, 3M instead of 75%), but with the
same results.