Marc Sherman wrote:
> Craig Jackson wrote:
>
>> Can someone tell me why the mysql lookup fails in acl_smtp_data?
>>
>> acl_exiscan:
>> warn message = X-Cheetah-Spam: True
>> condition = ${if ! def:h_X-Spam:}
>> condition = ${if <{$message_size}{200k}{1}{0}}
>> set acl_m4 = ${lookup mysql{DELIVER}{$value}{0}}
>> spam = mail/defer_ok
>
>
> Without the macro definition of DELIVER, we can't really say, can we?
>
> You're probably using some expansion variable that isn't defined in the
> DATA acl.
>
> - Marc
>
Sorry, here's the macro.
DELIVER = SELECT use_spam_filter FROM users \
WHERE recipient = '${quote_mysql:$local_part}'
It looks a variable (-1 or 0) to determine whether to deliver mail to a
user IMAP junk folder or to deliver the spam to the bit bucket.
