Re: [Exim] Basic Exim+SQL

Kezdőlap
Üzenet törlése
Válasz az üzenetre
Szerző: Torsten Mueller
Dátum:  
Címzett: exim-users@exim.org
Tárgy: Re: [Exim] Basic Exim+SQL

Steve Sherwood schrieb:
>
> Just getting into Exim+SQL. I've scanned the web + mailing lists and
> what I seem to be doing is correct.
>
> hide mysql_servers = localhost/db/user/pass
> domainlist local_domains = @:localhost:mydomain.com:mydomain2.com
>
> The config file works perfectly with this... (xyz@???) is
> delivered locally.
>
> If I swap it to say
>
> domainlist local_domains = @:localhost:${lookup mysql{SELECT domain FROM
> local_domains}}


Try to use this instead as the query

SELECT DISTINCT domain FROM local_domains WHERE
domain='${quote_mysql:$domain}'

If you want to see my completely mySQL based exim4 config, take a look
at
http://www.xtremeweb.de/exim/configure-4.10.txt

However my setup is in time a little bit more complex: It handles
smtp auth, pop before smtp, "mx backup", ...

Possibly it's a starting point for you.

Torsten