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.
