It works very fine when we specify the database in the query (SELECT fields
FROM database.table)! It was very simple in fact.
Thank you very much !
Olivier
-----Message d'origine-----
De : exim-users-bounces@??? [
mailto:exim-users-bounces@exim.org] De la
part de Peter Bowyer
Envoyé : dimanche 7 novembre 2004 22:44
À : exim-users@???
Objet : Re: [exim] multiple mysql databases
Olivier <oricard@???> wrote:
> Hello,
>
> I setup exim4 with mysql support. It works fine with 1 database. But
> it doens't work with 2 databases.
>
> Here my conf in main/01_exim4-config_listmacrosdefs
>
> hide mysql_servers =
>
localhost/databasename1/databaseuser1/databasepwd1:localhost/databasename2/d
> atabaseuser2/databasepwd2
>
> I setup 2 routers for each database. Each database is linked to a
> domain.
>
> virtual_domain1_mysql_aliases:
> driver = accept
> transport = domain1_mysql_delivery
> condition = ${lookup mysql{ SELECT email_recipient FROM emails WHERE
> email_recipient='${quote_mysql:${local_part}@${domain}}'
> <mailto:${local_part}@${domain}}'> }}
> user = mail
> group = mail
> domains = domain1
>
> virtual_domain2_mysql_aliases:
> driver = accept
> transport = domain2_mysql_delivery
> condition = ${lookup mysql{ SELECT blog_recipient FROM emails WHERE
> email_recipient='${quote_mysql:${local_part}@${domain}}'
> <mailto:${local_part}@${domain}}'> }}
> user = mail
> group = mail
> domains = domain2
>
> The router 1 works fine with the first database but with the second
> database the router doens't work. Exim4 doesn't seem to lookup the 2nd
> database.
Exim will use the first listed connection which doesn't error on the query.
Since both your tables are named 'emails', then neither query will ever
error (note 'error', contrast with 'return no rows'). So exim will always
use the first listed connection.
Test this by renaming the table in the second database and adjusting the
query accordingly. Or try '... FROM database2.emails' in the second query.
Peter
--
## List details at
http://www.exim.org/mailman/listinfo/exim-users Exim
details at
http://www.exim.org/ ##
