Hi, all.
I have a white list routine that works great for email from individuals.
When email is from a list, it simply doesn't work. Heres what I have:
In the acl_rcpt section:
acl_smtp_rcpt = acl_check_rcpt
acl_check_rcpt
accept domains = +local_domains : +relay_to_domains
condition = ${lookup mysql
{MYSQL_Q_WHITELIST}{yes}{no}}
logwrite = "Whitelisted $sender_address by
$local_part@$domain"
set acl_c1 = 1
And in the sql definition:
MYSQL_Q_WHITELIST=SELECT DISTINCT 1 FROM wlist \
WHERE (email =
LOWER('${quote_mysql:$local_part}@${quote_mysql:$domain}') \
OR email IN (SELECT email FROM alias WHERE alias =
LOWER('${quote_mysql:$local_part}@${quote_mysql:$domain}'))) \
AND LOWER('${quote_mysql:$sender_address}') REGEXP address
Here are two entries in the wlist table:
email address used hits
david@??? exim-users-request@??? 2006-10-06 13:30:19 2
david@??? debbie@??? 2006-10-07 14:13:47 113
email from debbie@??? to david@??? is always whitelisted
email from the list to david@??? is never whitelisted
In the headers of an exim list email there is:
To: exim-users@???
From: first last <first.last@???>
and
Sender: exim-users-bounces@???
Errors-To: exim-users-bounces+david=tulsa.com@???
Is there a way to modify the acl to check the Sender: <ADDRESS> along
with the From:<ADDRESS>
Any help would be totally appreciated.