I'm having trouble getting the mysql authdaemond module to work with MD5
password hashes.

After "authtest myuser mypass", the log says:

    authdaemond: supplied password 'mypass' does not match encrypted password '
    {MD5}a029d0df84eb5549c641e04a9ef389e5

but 

    # md5 -s mypass
    MD5 ("mypass") = a029d0df84eb5549c641e04a9ef389e5

This is the what I have in authmysqlrc.  "authtest myuser" works fine.

MYSQL_SELECT_CLAUSE     SELECT CONCAT('$(local_part)', '@me.com'),        \
                        CONCAT('{MD5}', pass),                            \
                        '',                                               \
                        465,                                              \
                        465,                                              \
                        CONCAT('/var/mail/virtual/', '$(local_part)'),    \
                        '',                                               \
                        '104857600S',                                     \
                        '',                                               \
                        
'disableimap=0,disablepop3=0,disablewebmail=0,sharedgroup=0'    \
                        FROM users                                        \
                        WHERE name = '$(local_part)'

I suspected the CONCAT('{MD5}', pass ) field, but I got the same result 
when I tried it without the {MD5} prefix.  

Does this method require the clear password?

Is the mysql statement correct?  

Anything else to check?

m


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
courier-users mailing list
[email protected]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users

Reply via email to