Re: [Exim] Basic Exim+SQL

Páxina inicial
Borrar esta mensaxe
Responder a esta mensaxe
Autor: Steve
Data:  
Para: Nico Erfurth
CC: exim-users
Asunto: 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