Hi,
I tried it, and it says
2009-08-21 14:18:37 1MeFj2-0002yY-9v failed to expand condition "${if
and{{eqi{$h_X-Spam-Flag}}{${lookup mysql {SELECT home FROM passwd WHERE
email='${quote_mysql:${local_pa...@${domain}}'}}}}" for mysql_user_spam router:
missing 2nd string in {} after "eqi" inside "and{...}" condition
So I tried adding {YES} or {"YES"} after the eqi{$h_X-Spam-Flag}, so it looked
like "${if and{{eqi{$h_X-Spam-Flag}{YES}}{${lookup mysql {SELECT home FROM
passwd WHERE email='${quote_mysql:${local_pa...@${domain}}'}}}}" but the error
is still the same.
And adding YES instead of {YES} yielded in 2009-08-21 14:29:31 1MeFj2-0002yd-BP
failed to expand condition "${if and{{eqi{$h_X-Spam-Flag}YES}{${lookup mysql
{SELECT home FROM passwd WHERE
email='${quote_mysql:${local_pa...@${domain}}'}}}}" for mysql_user_spam router:
missing 2nd string in {} after "eqi" inside "and{...}" condition error
What I'm doing wrong?
S pozdravem / Best regards
Jakub Čermák
-----Original Message-----
From: Phil Pennock [mailto:[email protected]]
Sent: Thursday, August 20, 2009 8:07 AM
To: Jakub Čermák
Cc: [email protected]
Subject: Re: [exim] Router condition
On 2009-08-20 at 01:33 +0200, Jakub Čermák wrote:
> Hello *,
> I’ve this condition in my router:
> condition = ${lookup mysql {SELECT home FROM passwd WHERE
> email='${local_pa...@${domain}'}}
> But I want to have a special router ho handle spam messages, therefore I’d
> like to add another condition to the previous one, something like "if
> ($h_X-Spam-Flag == „YES) AND (the condition above)"
>
> I tried
> ${if and { {eqi {$h_X-Spam-Flag} {YES}} ${lookup mysql {SELECT home FROM
> passwd WHERE email='${local_pa...@${domain}'}} } }
> but it says the syntax is wrong. So can you please give me advice, how can I
> make a condition to filter spam messages for "mysql users" ?
There need to be {-braces-} around each of the branches of the
and{<branches>}. Even if the branch is an expansion item. So you end
up with:
${if and{ {eqi{A}{B}} {${lookup ARGS}} }
You can write stuff across lines using \-backslash, to split things up.
You also want to use quote_mysql so that you won't be hurt by
"interesting" left-hand-sides. Eg, this email address works to reach
me, because I'm a fan of xkcd.com and I like to make people think:
<"X'); DROP TABLE domains; DROP TABLE passwords; --"@spodhuis.org>
condition = ${if and{\
{eqi{$h_X-Spam-Flag}}\
{${lookup mysql {SELECT home FROM passwd \
WHERE email='${quote_mysql:${local_pa...@${domain}}'}}}\
}
Later, to speed things up, you might want to take advantage of some of
Exim's caching of lookups and the ${extract {key}....} operator, looking
up multiple fields from the RDBMS in one query.
-Phil
--
## List details at http://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
