Consider the following in Exim 4.10
virtual_forward:
driver = redirect
allow_filter
check_ancestor
check_local_user
directory_transport = address_file
no_expn
file = /etc/xams/filters/${lookup mysql{SELECT s.Name FROM pm_domains d,
pm_sites s, pm_users u WHERE s.ID = d.SiteID AND d.Name = '$domain' and
u.Name = '$local_part' and u.SiteID = s.ID AND s.SiteState !=
'locked_bounce' AND u.AccountState !=
'locked_bounce'}{${value}}}/$local_part.filt
file_transport = address_file
pipe_transport = address_pipe
reply_transport = address_reply
retry_use_local_part
no_verify
Lets assume that the sql statement comes back with "New Wave Logistics"
(minus the quotes), and $localpart is jan.johansson. Yet it never executes
/etc/xams/filters/New Wave Logistics/jan.johansson.filt
but hapily passes the message on to the next handler.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.423 / Virus Database: 238 - Release Date: 2002-11-25
