[exim] multiple mysql databases

Top Page
Delete this message
Reply to this message
Author: Olivier
Date:  
To: exim-users
Subject: [exim] multiple mysql databases
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. if I
write

hide mysql_servers
=localhost/databasename2/databaseuser2/databasepwd2:localhost/databasename1/
databaseuser1/databasepwd1

The 2nd router works fine but no the 1st.

I have no idea to fix my problem. I'm under Debian with the following
packages

exim4          4.34-4amwoody2 An MTA (Mail Transport Agent)
exim4-base     4.34-4amwoody2 EXperimental Internal Mailer -- a Mail Trans
exim4-config   4.34-4amwoody2 Debian configuration for exim4
exim4-daemon-h 4.34-4amwoody2 Exim (v4) with extended features, including



Thanks in advance

Olivier