Re: [Exim] Basic Exim+SQL

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Nico Erfurth
Ημερομηνία:  
Προς: exim-users@exim.org
Αντικείμενο: Re: [Exim] Basic Exim+SQL
On Fri, 25 Oct 2002, Steve wrote:

> > 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}'}}


You should use the mysql;-style for this ;)

> 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}'}}


$sender_address (IIRC)

but you should use mysql; here too ;)

ciao