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"}}
--
## List details at http://www.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://www.exim.org/eximwiki/
