[Dovecot] Password auth with Postfixadmin & MySQL

[James Dehnert]

On Sep 25, 2007, at 11:56 AM, Gregory Mokhin wrote:

>>  From dovecot.conf..
>>
>>   # Space separated list of wanted authentication mechanisms:
>>    #   plain login digest-md5 cram-md5 ntlm rpa apop anonymous gssapi
>>    # NOTE: See also disable_plaintext_auth setting.
>>    mechanisms = cram-md5 plain login
>>    #
>>
>
> What is your setting in dovecot-sql.conf?
>
> #default_pass_scheme = MD5
> default_pass_scheme = PLAIN
>
> As a side note, if you plan to use TLS, then your setup will be much
> easier if you keep passwords in MySQL non-encrypted, no matter what
> postfixadmin thinks of it.
>
> Regards,
> Gregory

Blast!  I switched all my pw's to plain in mysql.  Postfixadmin  
works, but...

dovecot: Sep 25 13:40:46 Info: auth-worker(default): mysql: Connected  
to localhost (postfix)
dovecot: Sep 25 13:41:05 Info: auth(default): client in: AUTH    
1       PLAIN   service=POP3    secured lip=127.0.0.1    
rip=127.0.0.1   resp=<hidden>
dovecot: Sep 25 13:41:05 Info: auth-worker(default): sql 
(jdehnert at dehnert.com,127.0.0.1): query: SELECT username as user,  
password, concat('/var/vmail/',domain,'/',maildir) as userdb_home,  
concat('maildir:/var/vmail/',domain,'/',maildir) as userdb_mail, 101  
as userdb_uid, 101 as userdb_gid FROM mailbox WHERE username =  
'jdehnert at dehnert.com' AND active = '1'
dovecot: Sep 25 13:41:05 Error: auth-worker(default): plain_md5_verify 
(jdehnert at dehnert.com): Invalid password encoding
dovecot: Sep 25 13:41:05 Info: auth-worker(default): sql 
(jdehnert at dehnert.com,127.0.0.1): Password mismatch
dovecot: Sep 25 13:41:06 Info: auth(default): client out: FAIL   
1       user=jdehnert at dehnert.com

So, where is this auth-worker? I need to talk with him.


Thanks,
     Zeke

--
James "Zeke" Dehnert
mailto:jdehnert at norcalnetworks.com
Phone: +1 707.546.6620 x602 Fax: +1 707.324.8043
"Life is racing, everything else is just waiting"