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
>
