[Dovecot] Dovecot and MySQL auth - initial setup issues
James Bowling
james at jamesbowling.com
Tue Jul 11 18:10:07 EEST 2006
Are you using a password encryption scheme for your user passwords in
the mysql db? You might want to enable the following to help debug the
issue more in your dovecot.conf:
auth_verbose = yes
auth_debug = yes
auth_debug_passwords = yes
Restart Dovecot and then try logging in. This will spit out alot more
information about the process and might give us a better look into your
issue.
--
James Bowling
<james at jamesbowling.com>
Andrew Hearn wrote:
> 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.
>
>
>
More information about the dovecot
mailing list