Re: [exim] Exim, Vexim, Sieve and Spamassassin

On Tue, 1 Jul 2008, Sascha Schmidt wrote:
>
> I thought about a mysql-clause which is used within the condition part.
> The problem I have is that I'm not knowing the correct syntax to create
> the part correctly; missing curely brackets etc... :-)
>
> My first thought was the following one:
> ---
> warn message = X-Spam-Flag: YES
> spam = vmail:true
> condition = ${if >{$spam_score_int}{${lookup mysql{select \
> users.sa_tag * 10 from users,domains \
> where localpart = '${quote_mysql:$local_part}' \
> and domain = '${quote_mysql:$domain}' \
> and users.on_spamassassin = '1' \
> and users.domain_id=domains.domain_id}
> ---
>
> Perhaps someone can look at this code and tell me what's wrong with it.
> Any hint is welcome;)

The problem is that $local_part and $domain are only defined in the RCPT
ACL. A message may have multiple recipients so there's no simple way to
use per-recipient settings in the post-DATA ACL.

What you can do is look up each recipient's setting in a RCPT ACL and
store it in an $acl_mXXXX variable, with some logic to combine multiple
recipients' choices. For example, if you set the variable to 1 if a user
wants messages tagged and do nothing otherwise, then the message will be
tagged if any one of multiple recipients wants it tagged.

# in the RCPT ACL

  warn
    condition = ${lookup mysql \
      { select users.sa_tag * 10 from users,domains \
        where localpart = '${quote_mysql:$local_part}' \
        and domain = '${quote_mysql:$domain}' \
        and users.on_spamassassin = '1' \
        and users.domain_id=domains.domain_id \
      } {1} {0} }
  set acl_mTAG = 1

# in the DATA ACL

  warn
    condition = $acl_mTAG
    spam = vmail:true
    add_header = X-Spam-Flag: YES

Tony.
--
<fanf@???> <dot@???> http://dotat.at/ ${sg{\N${sg{\
N\}{([^N]*)(.)(.)(.*)}{\$1\$3\$2\$1\$3\n\$2\$3\$4\$3\n\$3\$2\$4}}\
\N}{([^N]*)(.)(.)(.*)}{\$1\$3\$2\$1\$3\n\$2\$3\$4\$3\n\$3\$2\$4}}