[exim] White list for list email doesn't white list

Top Page
Delete this message
Reply to this message
Author: David Daniels
Date:  
To: exim-users
Old-Topics: Re: [exim] Greylisting without SQL db
Subject: [exim] White list for list email doesn't white list
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.