[Dovecot] Dovecot and MySQL auth - initial setup issues
Andrew Hearn
andrew.hearn at aaisp.net.uk
Tue Jul 11 18:55:38 EEST 2006
James Bowling wrote:
> 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.
>
Thanks James,
I'm using plain at the moment, the database has a plain password, and
under auth default { I've now set:
mechanisms = plain
The log I now get is:
> dovecot: Jul 11 16:38:48 Info: auth(default): client in: AUTH 1 PLAIN service=IMAP lip=::ffff:81.187.11.54 rip=::ffff:81.187.11.8 resp=AGFuZHJld0BtYWlsLXRlc3QuYWFpc3AubmV0LnVrADIzNzQyNg==
> dovecot: Jul 11 16:38:48 Info: auth-worker(default): sql(andrew at mail-test.aaisp.net.uk,::ffff:81.187.11.8): query: SELECT password FROM users WHERE id = 'andrew at mail-test.aaisp.net.uk'
> dovecot: Jul 11 16:38:48 Info: auth(default): client out: OK 1 user=andrew at mail-test.aaisp.net.uk
> dovecot: Jul 11 16:38:48 Info: auth(default): master in: REQUEST 2 17639 1
> dovecot: Jul 11 16:38:48 Info: auth-worker(default): sql(andrew at mail-test.aaisp.net.uk,::ffff:81.187.11.8): SELECT maildir FROM users WHERE id = 'andrew at mail-test.aaisp.net.uk'
> dovecot: Jul 11 16:38:48 Error: auth-worker(default): sql(andrew at mail-test.aaisp.net.uk,::ffff:81.187.11.8): Password query didn't return uid, or it was NULL
> dovecot: Jul 11 16:38:48 Info: auth(default): passwd(andrew at mail-test.aaisp.net.uk,::ffff:81.187.11.8): unknown user
> dovecot: Jul 11 16:38:48 Error: auth(default): userdb(andrew at mail-test.aaisp.net.uk,::ffff:81.187.11.8): user not found from userdb
> dovecot: Jul 11 16:38:48 Info: auth(default): master out: NOTFOUND 2
> dovecot: Jul 11 16:38:48 Info: imap-login: Internal login failure: user=<andrew at mail-test.aaisp.net.uk>, method=PLAIN, rip=::ffff:81.187.11.8, lip=::ffff:81.187.11.54
I'm not sure why it's saying "Password query didn't return uid", that
that seems the issue.
More information about the dovecot
mailing list