Re: [Exim] Basic Exim+SQL

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Steve
Ημερομηνία:  
Προς: Nico Erfurth
Υ/ο: exim-users
Αντικείμενο: Re: [Exim] Basic Exim+SQL
> domainlist local_domains @:localhost:mysql;select 1 from local_domains \
> where domain='${quote_mysql:$domain}'



Ah... the following works fine!

domainlist local_domains = @:localhost:${lookup mysql{select domain from
local_domains where domain='${quote_mysql:$domain}'}}

ok... another question, I have a table of E-Mail addresses that I need to
bounce (Which also does not work).

In my acl_check_rcpt: section I have the following line...

deny senders = ${lookup mysql {SELECT target FROM bounce}}

I assume here that I will also need to change the query so that only one
item is returned?
Sort of like (Only I'm not sure what to use for $sender)...

deny senders = ${lookup mysql {SELECT target FROM bounce WHERE
target='${quote_mysql:$sender}'}}

Steve