[Dovecot] Dovecot and MySQL auth - initial setup issues

[Andrew Hearn]

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 whilst testing and getting this working,
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 17:01:21 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 17:01:21 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 17:01:21 Info: auth(default): client out: OK    1
user=andrew at mail-test.aaisp.net.uk
dovecot: Jul 11 17:01:21 Info: auth(default): master in: REQUEST
4       17643   1
dovecot: Jul 11 17:01:21 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 17:01:21 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 17:01:21 Info: auth(default):
passwd(andrew at mail-test.aaisp.net.uk,::ffff:81.187.11.8): unknown user
dovecot: Jul 11 17:01:21 Error: auth(default):
userdb(andrew at mail-test.aaisp.net.uk,::ffff:81.187.11.8): user not found
from userdb
dovecot: Jul 11 17:01:21 Info: auth(default): master out: NOTFOUND      4
dovecot: Jul 11 17:01:21 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.


I'll carry on playing... Andrew