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.