[Dovecot] mysql authentication

I've just managed to get dovecot to install on one of our FreeBSD 5.4 servers, using the ports collection.

I've set up dovecot to query the mysql database I'm using, and the query I'm using is:

SELECT clear AS password FROM users LEFT JOIN domains ON

domains.domain_id = users.domain_id WHERE domain="%d" AND username="%d" AND users.enabled = 1 AND domains.enabled = 1

If I perform this query by hand, I get a single row with the field 'password' which contains the password I'm using the perform my intial test. However, dovecot won't authenticate, and returns this error:

dovecot-auth: mysql(justin@redwiredesign.co.uk): Password mismatch

Is there a way that I can see how dovecot's doing the comparison? I have set the following in dovecot.conf:

auth_verbose = yes
auth_debug = yes

I've read the wiki on raw logging, but I don't know: (a) how to enable this through the port (b) whether this is even applicable as apparently all it logs is the imap traffic.

Any suggestions?

j.

Redwire Design Limited Studio 12 37 Tanner Street London SE1 3LF [ www.redwiredesign.com ] [ 020 7403 1444 ] - voice [ 020 7378 8711 ] - fax