[Dovecot] Dovecot and MySQL auth - initial setup issues

[James Bowling]

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