OK so tws me being a complete utter n00b ... always check that the
database you are connecting to IS the one you think it is AND failing
that the replication is working ...
sigh .. been a long week ..
rgds
Matt B.
On 23/02/2015 5:17 pm, Matt Bryant wrote:
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/
