[Dovecot] Password Encryption

[Dave Morrow]

-----Original Message-----
From: Geert Hendrickx [mailto:ghen at telenet.be] 
Sent: Friday, August 03, 2007 9:07 AM
To: Dave Morrow
Cc: dovecot at dovecot.org
Subject: Re: [Dovecot] Password Encryption

On Fri, Aug 03, 2007 at 08:35:59AM -0400, Dave Morrow wrote:
> While everything seems to have gone right, I have been unable to
> successfully login to the IMAP server using Outlook Express.  
> 
> It seems that the problem may relate to PostfixAdmin storing passwords
in
> the mysql database md5 encrypted, and Dovecot is not able to read
them, but
> I am not certain.

>>This wiki page may help you:
http://wiki.dovecot.org/Debugging/Authentication
>>
>>	Geert

Thanks Geert.

My logs are showing this.  I suspect the md5 format that PostfixAdmin is
inserting the password to the database with is not the same as the
Dovecot md5 encryption....... :(

Aug  3 11:43:51 mymailserver dovecot: auth-worker(default):
sql(testuser1 at mydomain.com,::ffff:172.16.140.105): query: SELECT
username as user, password, concat('/var/vmail/', maildir) as
userdb_home, concat('maildir:/var/vmail/', maildir) as userdb_mail, 101
as userdb_uid, 12 as userdb_gid FROM mailbox WHERE username =
'testuser1 at mydomain.com' AND active = '1'
Aug  3 11:43:51 mymailserver dovecot: auth(default): client in: AUTH 1
PLAIN   service=IMAP    lip=::ffff:172.16.140.118
rip=::ffff:172.16.140.105
resp=AHRlc3R1c2VyMUBxYS1qYWdtYWlsLmF1dG9kYXRhLm5ldABwYXNzd29yZA==
Aug  3 11:43:51 mymailserver dovecot: auth-worker(default):
plain_md5_verify(testuser1 at mydomain.com): Invalid password encoding
Aug  3 11:43:51 mymailserver dovecot: auth-worker(default):
sql(testuser1 at mydomain.com,::ffff:172.16.140.105): Password mismatch
Aug  3 11:43:51 mymailserver dovecot: auth-worker(default):
sql(testuser1 at mydomain.com,::ffff:172.16.140.105): PLAIN-MD5(password)
!= '$1$06c431fd$5eVxbTleXD2.Zo9sDXX2Z0'
Aug  3 11:43:51 mymailserver dovecot: auth(default): client out: FAIL
1       user=testuser1 at mydomain.com
Aug  3 11:43:53 mymailserver dovecot: imap-login: Disconnected:
user=<testuser1 at mydomain.com>, method=PLAIN, rip=::ffff:172.16.140.105,
lip=::ffff:172.16.140.118