Exim, Vexim, Sieve and Spamassassin

Sascha Schmidt <[email protected]>
Newsgroups gmane.mail.exim.vexim.devel
Message-ID <[email protected]>
Hi *,

I've got problems tagging spam-mails with "X-Spam-Flag: YES". I'm using
vexim where users can define the value when their emails should be
tagged. The following code exists within vexim-acl-check-content.conf
that will add the Spam-Score and Report to all emails (globally defined):

---
     warn  message         = X-Spam-Score: $spam_score ($spam_bar)
           spam            = vmail:true
     warn  message         = X-Spam-Report: $spam_report
           spam            = vmail:true
---

The following code works and adds the X-Spam-Flag correctly but does not
use the userdefined values from the vexim webinterface. The global value
is used:

---
      warn message         = X-Spam-Flag: YES
           spam            = vmail
---

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;)

Greets and thanks
Sascha
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.