[Dovecot] Dovecot and MySQL auth - initial setup issues

[Andrew Hearn]

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 at 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.


-- 
Andrew Hearn, Senior Support Engineer
Andrews & Arnold Ltd     01344 400999

For efficient support, please email:
support at aaisp.net.uk