So am trying to create an acl that will reject mail for recipients who have the sender on a user level blacklist. What ever I do just can't seem to get it to work right. I assume the ACL for rcpt is run multiple time for each RCPT line received. If so can anyone shed any light as to what I could be doing wrong ...

mysql table
recipientAddress, senderAddress, listType (1 = white/2= black)


acl_smtp_rcpt:

    deny
recipients = ${lookup mysql {select recipientAddress from senderLists where senderAddress = ${quote_mysql:$sender_address}' and recipient = '${quote_mysql:$local_part@$domain}' logwrite = 'LOG: Reject - recipient $local_part@$domain has blacklisted $sender_address

 have tried using

condition = ${ if > {lookup mysql {select count(senderAddress) from senderList where senderAddress = ${quote_mysql:$sender_address}' and recipient = '${quote_mysql:$local_part@$domain}'}{0}{yes}{no}}

and even

senders = ${lookup mysql {select senderAddress from from senderLists where senderAddress = ${quote_mysql:$sender_address}' and recipient = '${quote_mysql:$local_part@$domain}'}


but no luck .. am i doing something blindingly stupidly obviously wrong ?????

rgds

Matt Bryant

--
## List details at https://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/

Reply via email to