[courier-users] mysql md5 authentication

Hi,
Im trying to authenticate a combination of courier-imap/postfix/maildrop
against mysql. The passwords should be md5-encrypted.
I set up my authmysqlrc, and created a testing row in the corrensponding
mysql table.
Output of a "authtest r.fuchs-sursee@bluewin.ch":

Authentication succeeded.

Authenticated: r.fuchs-sursee@bluewin.ch (uid 1000, gid 1000)
Home Directory: /data/mail/rfuchssursee/
Maildir: Maildir/
Quota: (none)
Encrypted Password: df5ea29924d39c3be8785734f13169c6
Cleartext Password: (none)
Options: (none)

So far so good. Now authentication with the password 'blabla' (df5ea29924d39c3be8785734f13169c6
after MD5)
Here's the log:
----
Aug 2 14:52:01 blackout authdaemond: received userid lookup request: r.fuchs-sursee@bluewin.ch
Aug 2 14:52:01 blackout authdaemond: authmysql: trying this module
Aug 2 14:52:01 blackout authdaemond: SQL query: SELECT id, crypt, clear,
uid, gid, home, maildir, "", name, "" FROM users WHERE id = "r.fuchs-sursee@bluewin.ch"
Aug 2 14:52:01 blackout authdaemond: Authenticated: sysusername=<null>,
sysuserid=1000, sysgroupid=1000, homedir=/data/mail/rfuchssursee/, address=r.fuchs-sursee@bluewin.ch,
fullname=Raphael Fuchs, maildir=Maildir/, quota=<null>, options=<null>
Aug 2 14:52:01 blackout authdaemond: Authenticated: clearpasswd=<null>,
passwd=df5ea29924d39c3be8785734f13169c6
Aug 2 14:52:04 blackout authdaemond: received auth request, service=login,
authtype=login
Aug 2 14:52:04 blackout authdaemond: authmysql: trying this module
Aug 2 14:52:04 blackout authdaemond: SQL query: SELECT id, crypt, clear,
uid, gid, home, maildir, "", name, "" FROM users WHERE id = "r.fuchs-sursee@bluewin.ch"
Aug 2 14:52:04 blackout authdaemond: supplied password 'blabla' does not
match encrypted password 'df5ea29924d39c3be8785734f13169c6'

Why does the password not match?!

Thank you,
Raphael
-------------
Linux is like a wigwam: no Windows, no Gates and Apache inside.



-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
courier-users mailing list
courier-users@lists.sourceforge.net
Unsubscribe: https://lists.sourceforge.net/lists/.../courier-users