Jakob Hirsch wrote on 9/03/2006 12:14 AM:
you don't need to fiddle in ACLs (and it wouldn't work with that, anyway).
LIKE '$sender_address'
if acl_m9 contains "1" then
That would be $acl_m9. But as said, it's not needed. Just use
if ${lookup mysql {SELECT COUNT(*)...}} is above 1
...
Untested, I never used lookups in a filter.
Oh, and use '${quote_mysql:$sender_address}'.
headers add "New-Subject: [foo] ${escape:$h_subject:}"
probably better use ${rfc2047 than ${escape here.
put the "if ... endif" stuff into a file (e.g. /etc/exim/system-filter)
and the following lines at the top of your exim.conf:
system_filter = /etc/exim/system-filter
system_filter_user = your_exim_user
But you should really read (at least) the documentation of Exim's
filtering facilities.
Thanks, I've read a document on Exim's filtering features, and have
decided on the following in my system_filter;
--
if ${lookup mysql {SELECT COUNT(*) FROM addresses WHERE email LIKE
'${quote_mysql:$sender_address}'}} is above 1
then
headers add "New-Subject: [foo] ${rfc2047:$h_subject:}"
headers remove Subject
headers add "Subject: $h_new-subject:"
headers remove New-Subject
endif
--
However, it merely returns
Filter error: unrecognized condition word "mysql" near line 10 of
filter file
I'm using Debian testing with v4.60-4 of exim4 (exim4-daemon-heavy).
What might be wrong? MySQL lookups work elsewhere in my exim4 config..
cheers
Michael
--
## List details at http://www.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://www.exim.org/eximwiki/
