Hey guys, I'm new to this list, I had a quick look over the archives but
couldn't really find any solution to my problem.
From what I can tell this is the thread that really relates closely to
what I wanna do;
http://www.exim.org/mailman/htdig/exim-users/Week-of-Mon-20030113/048361.html
Which this email hitting the nail on the head for what I wanna achieve;
http://www.exim.org/mailman/htdig/exim-users/Week-of-Mon-20030113/048446.html
I have this command working perfectly currently;
transport_filter = /usr/bin/spamc -u "${lookup mysql{select unix_user from domain left join domain_alias on domain_alias.domain_name = domain.domain_name where domain.domain_name = '${quote_mysql:$domain}' or domain_alias.alias = '${quote_mysql:$domain}'}{$value}fail}"
(That'll wrap really badly :)
Basically it pulls the unix_user outta mysql and applys spam preferences
for the domain on a global sense. Herein lies my problem.
When 2 domains on the system get an email: eg: info@??? and
sales@??? that line returns with a fail. This only happens
rarely so I would basically like that if my transport_filter fails, it
just skips spanning the mail for spam (because almost 9 times outta 10 its
not spam anyway), and contines on.
Error from exim
== brad@??? T=spamcheck defer (-1): Expansion of "${lookup
mysql{select unix_user from domain left join domain_alias on
domain_alias.domain_name = domain.domain_name where domain.domain_name =
'${quote_mysql:$domain}' or domain_alias.alias =
'${quote_mysql:$domain}'}{$value}fail}" from command "/usr/bin/spamc -u
"${lookup mysql{select unix_user from domain left join domain_alias on
domain_alias.domain_name = domain.domain_name where domain.domain_name =
'${quote_mysql:$domain}' or domain_alias.alias =
'${quote_mysql:$domain}'}{$value}fail}"" in transport filter failed:
"lookup" failed and "fail" requested: MYSQL: no data found
If there is a way I could improve it to query both domains preferences for
both domains that would be even better! But I suspect that I wont have any
luck.
Thanks in advance.
Regards,
Brad Lay (brad@???)
P) (07) 55 311177
W)
http://coombabah.net/
