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.
-- Andrew Hearn, Senior Support Engineer Andrews & Arnold Ltd 01344 400999
For efficient support, please email: support@aaisp.net.uk