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@mail-test.aaisp.net.uk,::ffff:81.187.11.8): query: SELECT password FROM users WHERE id = 'andrew@mail-test.aaisp.net.uk' dovecot: Jul 11 16:38:48 Info: auth(default): client out: OK 1 user=andrew@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@mail-test.aaisp.net.uk,::ffff:81.187.11.8): SELECT maildir FROM users WHERE id = 'andrew@mail-test.aaisp.net.uk' dovecot: Jul 11 16:38:48 Error: auth-worker(default): sql(andrew@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@mail-test.aaisp.net.uk,::ffff:81.187.11.8): unknown user dovecot: Jul 11 16:38:48 Error: auth(default): userdb(andrew@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@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.