8 messages in net.sourceforge.lists.courier-users[courier-users] MD5 passwords
FromSent OnAttachments
Mark BucciarelliJan 27, 2006 4:35 am 
Sergiy ZhukJan 27, 2006 9:43 am 
Mark BucciarelliJan 27, 2006 11:10 am 
Sam VarshavchikJan 27, 2006 3:19 pm 
Mark BucciarelliJan 29, 2006 9:24 am 
Jerry AmundsonJan 29, 2006 11:10 am 
Mark BucciarelliJan 30, 2006 2:21 pm 
Mark BucciarelliJan 30, 2006 6:34 pm 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:[courier-users] MD5 passwordsActions...
From:Mark Bucciarelli (ma@gaiahost.coop)
Date:Jan 27, 2006 4:35:41 am
List:net.sourceforge.lists.courier-users

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