Hello experts,

i think i will get no answer at the users mailing list.
So i will ask here.


I am running a mailsystem on Debian jessie with Exim version 4.84_2 #1 built 
25-Jul-2016.

In my configuration i am trying to use some values fetching from an mysql 
database.
This is working in the router section for identifying the users without problem.

But when i try to get the user values for spam it fails!


Here is my configuration:

That's what is working now - but it is static and not per user:
       condition = ${if >{$spam_score_int}{50}{1}{0}}


That's what i want to do:

       condition = ${if >{$spam_score_int}{${eval:10*{${lookup mysql{ SELECT 
DISTINCT spam_threshold FROM user WHERE
username='${quote_mysql:$local_part}' AND domain='${quote_mysql:$domain}' AND 
SMTP_allowed='YES'}}}}}{true}{false}}


This will result in:

temporarily rejected after DATA: failed to expand ACL string
"${if >{$spam_score_int}{${eval:10*{${lookup mysql{ SELECT DISTINCT 
spam_threshold FROM user WHERE
username='${quote_mysql:$local_part}' AND domain='${quote_mysql:$domain}' AND 
SMTP_allowed='YES'}}}}}{true}{false}}":
error in expression evaluation: expecting number or opening parenthesis (after 
processing "10*")


From my point of view the syntax is correct.
Can you help me to solve the error?

Thanks a lot.

-- 
## List details at https://lists.exim.org/mailman/listinfo/exim-dev Exim 
details at http://www.exim.org/ ##

Reply via email to