Re: [exim] Whitelist using mySQL

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Danil V. Gerun
Ημερομηνία:  
Προς: exim-users
Αντικείμενο: Re: [exim] Whitelist using mySQL
>> > !domains = mysql;SELECT domainname FROM exim_whitelist WHERE \
>> > domainname='${quote_mysql:@$domain}'
>> >
>> > This does not work. Any help would be appreciated.


> The database contains a simple domainname filed with the domain.com without
> the @.


Hello.
That's how I use auto-whitelisting in Exim:

domainlist      white_domains = ${lookup mysql{SELECT sender \
                        FROM whitelist \
                        WHERE type=1 AND sender='${quote_mysql:$sender_address_domain}'}{$value}fail}


(I have type=1 for domains and type=2 for addresses)


And in ACL section:

# Accept whitelist domains
accept sender_domains = +white_domains






--
Best regards, Danil V. Gerun.