On Thu, 28 Jun 2007, Derrick wrote:
> On Thu, 28 Jun 2007, David S. Madole wrote:
>
>>> From Derrick on Thursday, June 28, 2007 9:27 AM
>>> I have a need to bypass the exim quota for messages coming from
>>> the company mailing lists, staff members (determined by a field
>>> in mysql) and from certain machines (different host naming, internal
>>> domain); what would i be looking to do for this? Any examples?
>>
>> If the quota is implemented by the "quota =" option in Exim, the simply make the argument of the option an expansion that expands to the correct quota value normally, and to zero (which means no quota) for the particular messages that you want to have bybass the quota.
>>
>> For a more specific answer, you would need to supply more information on your configuration.
>
> Thank you David. Here's more info on the config relating to quota:
>
>
> quota = ${lookup mysql{SELECT userEmailQuota FROM vfs.tb_user LEFT JOIN infotech.tb_emailaddress \
> ON (tb_emailaddress.emailUnixUID = vfs.tb_user.userUnixUID) \
> LEFT JOIN infotech.tb_domain ON (tb_domain.domainID = tb_emailaddress.emailDomainID) \
> WHERE emailLocalPart = '${quote_mysql:${local_part}}' \
> AND domainName='${quote_mysql:${domain}}'}}
>
> in vfs.tb_user there is a staffID and a studentID column. One or the
> other will be filled with their student or staff ID number
Sorry I missed this part from the start of the local_delivery:
local_delivery:
driver = appendfile
directory = ${lookup mysql{SELECT CONCAT( "/home/", userName, "/Maildir/" ) \
FROM tb_emailaddress LEFT JOIN vfs.tb_user ON \
(userUnixUID = emailUnixUID) \
LEFT JOIN tb_domain ON (domainID = emailDomainID)\
WHERE emailLocalPart = '${quote_mysql:${local_part}}' \
AND emailStatus = "1" AND domainName='${quote_mysql:${domain}}' AND tb_user.active = "1"}}
