Hi, Phil
> Insufficient data to know what's happening with the schema and what
> exactly you're trying to achieve. Seeing the current configurations
> might help with that.
Attached a file with the two routers I use in this case.
Thank you
Luca Bertoncello
(lucabert@???)
localWrite_gw:
driver = redirect
allow_filter
domains = +local_domains
user = ${lookup mysql {select case count(*) when 0 then DEFAULT_UID else case uid when 0 then DEFAULT_UID else uid end end from aliases left outer join account using (accountname) join (select case when main_domain is null then domainname else main_domain end as domainname from domain where lower(domainname) = lower('$domain') or lower(main_domain) = lower('$domain') limit 1) dom using (domainname) where (lower(aliasname) = lower('${quote_mysql:$local_part}') or lower(aliasname) = '<catchall>') AND account.active = 1 order by aliasname != '<catchall>' desc, aliasname limit 1}}
group = exim
data = ${lookup mysql {select concat('# EXIM Filter\n\n', case when extra_forward is not null then extra_forward else '' end, replace(concat(concat(case hasAutoresponder when 0 then '' else replace(replace('if not error_message and \$message_headers does not contain "\\\\nX-SPAM:" and \$message_headers does not contain "\\\\nX-Infected:" then if personal then mail text "%%TEXT%%" from "$local_part@$domain" subject "%%SUBJ%%" extra_headers "MIME-Version: 1.0\\\\nContent-Type: text/plain; charset=ISO-8859-15" endif endif', '%%SUBJ%%', autoresponderSubject), '%%TEXT%%', replace(replace(autoresponderText, '\r', ''), '\n', '\\\\n')) end, '\n\n'), case when filters is not null then concat(filters, "\n", dataHam) else dataHam end), '%%FINALDEST%%', finaldest)) from aliases left join account using (accountname) join (select case when main_domain is null then domainname else main_domain end as domainname from domain where lower(domainname) = lower('$domain') or lower(main_domain) = lower('$domain') limit 1) dom using (domainname) where (lower(aliasname) = lower('${quote_mysql:$local_part}') or lower(aliasname) = '<catchall>') AND account.active = 1 order by aliasname != '<catchall>' desc, aliasname limit 1}}
redirect_router = loopbackRouter
reply_transport = autoresponder
pipe_transport = address_pipe
file_transport = address_file
directory_transport = address_file
headers_remove = ${if def:h_X-DefSubject {Subject}}:X-DefSubject:
headers_add = ${if def:h_X-DefSubject {Subject: $h_X-DefSubject:}}
srs = forward
srs_condition = ${if match {${lookup mysql {SELECT CONCAT(dataHam, CASE WHEN extra_forward IS NOT NULL THEN extra_forward ELSE '' END) FROM aliases join account using (accountname) join (select case when main_domain is null then domainname else main_domain end as domainname from domain where lower(domainname) = lower('$domain') or lower(main_domain) = lower('$domain') limit 1) dom using (domainname) where (lower(aliasname) = lower('${quote_mysql:$local_part}') or lower(aliasname) = '<catchall>') AND account.active = 1 order by aliasname != '<catchall>' desc, aliasname limit 1}}} {.*deliver.*} {yes}{no}}
no_more
