[exim] Connecting to mysql

I am doing a mysql lookup something like this:

    ${lookup mysql{SELECT home, uid, gid FROM users WHERE userid = '$local_part' and domain = '$domain'}}

It works -- in isolation. The problem is that I have more than one different database that
exim may play with (I am running the greylisting code that I put out a few weeks ago).

These are different databases with a different username/password. How to handle in exim:

    ${lookup mysql{servers=localhost(/var/lib/mysql/mysql.sock)/imap/exim_auth/YYYYY; SELECT home, uid, gid FROM users WHERE userid = '$local_part' and domain = '$domain'}}

this works, but it puts a username/password in the exim config file - that I want to avoid.

I have in a file included:

    hide mysql_servers = localhost/exim_db/exim_user/XXXXXX:\
                              localhost/imap/exim_auth/YYYYY

So I tried:

    ${lookup mysql{servers=localhost/imap; SELECT home, uid, gid FROM users WHERE userid = '$local_part' and domain = '$domain'}}

but that doesn't work since the argument to servers is either the name of the server, or all 4 parts.

    hide mysql_servers = localhost/exim_db/exim_user/XXXXXX:\
                              localhost2(/var/lib/mysql/mysql.sock)/imap/exim_auth/YYYYY

I need the socketname since localhost is recognised specially.

    ${lookup mysql{servers=localhost2; SELECT home, uid, gid FROM users WHERE userid = '$local_part' and domain = '$domain'}}

Doesn't work.

OK: how about a fix where the servers= could have a varying number of parameters, if it
has not got the full 4 it tries to fill them in from what it finds in mysql_servers
where the number of paramaters that it has got matches.
In short: my first attempt where I specify ''servers=localhost/imap;'' would work as I
had hoped.

The other way of doing it would be to give the generic exim user read access to the 'users' table and specify the table as imap.users:

    ${lookup mysql{SELECT home, uid, gid FROM imap.users WHERE userid = '$local_part' and domain = '$domain'}}

If this is thought a good idea I will do the coding work.

Regards

--
Alain Williams
Linux/GNU Consultant - Mail systems, Web sites, Networking, Programmer, IT Lecturer.
+44 (0) 787 668 0256 http://www.phcomp.co.uk/
Parliament Hill Computers Ltd. Registration Information: http://www.phcomp.co.uk/contact.php
Past chairman of UKUUG: http://www.ukuug.org/
#include <std_disclaimer.h>