If you setup is in a virtual mailbox setup then your query should look something like this:

user_query = SELECT maildir, 500 AS uid, 500 AS gid FROM users WHERE id = '%u'

Try that out, replacing the 500's with the appropriate uid and gid and let me know what you see then.

Regards, James Bowling

On Tue, 11 Jul 2006 17:01:41 +0100, Andrew Hearn andrew@aa.nu wrote:

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@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 17:01:21 Info: auth(default): client out: OK 1 user=andrew@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@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 17:01:21 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 17:01:21 Info: auth(default): passwd(andrew@mail-test.aaisp.net.uk,::ffff:81.187.11.8): unknown user dovecot: Jul 11 17:01:21 Error: auth(default): userdb(andrew@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@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