Hello,

I'm just setting up a new server and wanting to use MySQL for user authentication.

Here is what I have:

Fedora Core 5: 2.6.17-1.2145_FC5 Dovecot v1.0.rc2 (RPM install from atrpms.net) MySQL v5.0.22 SquirrelMail v 1.4.6-7.fc5 ...Running on a Dual XEON machine

I've added the following to dovecot.conf:

auth default {

           passdb sql {
    args = /etc/dovecot-mysql.conf
}
userdb sql {
    args = /etc/dovecot-mysql.conf
}

The rest of dovecot.conf is standard.

/etc/dovecot-mysql.conf has:

driver=mysql connect = host=127.0.0.1 port=3306 dbname=maildb user=root client_flags=0 password_query = SELECT password FROM users WHERE id = '%u' user_query = SELECT maildir FROM users WHERE id = '%u'

(I've run the SQL queries within mysql and they give the right results)

When I start Dovecot the log shows: dovecot: Jul 11 12:47:25 Info: Dovecot v1.0.rc2 starting up dovecot: Jul 11 12:47:27 Info: auth-worker(default): mysql: Connected to 127.0.0.1 (maildb)

When I try to log in using SquirrelMail, it takes about 3 seconds, then I get

dovecot: Jul 11 12:48:00 Info: imap-login: Aborted login: user=andrew@mail-test.aaisp.net.uk, method=PLAIN, rip=::ffff:127.0.0.1, lip=::ffff:127.0.0.1, secured

...So, no log of it trying MySQL...

And SquirrelMail then says: Unknown user or password incorrect

Any ideas of what I'm missing?

Thanks!

Andrew.