[Dovecot] Dovecot 2 fails after correct login

[Tim Smith]

Sorry - seem to have missed the crucial part of my email!! I meant to say:

Do u not need a separate user_query in your dovecot-sql.conf to return 
the userdb data?

Sorry!

On 20/05/12 12:25, Tim Smith wrote:
> Do u not need a seperate user_query in your dovecot-sql.conf to return 
> the. Dovecot is complaining that it can't find the entries that should 
> be returned from this query (I believe!)
>
> On 20/05/12 12:12, Frank Walter wrote:
>> Hello
>>
>> I installed dovecot 2.0.9 (and dovecot-mysql!) on my Ubuntu 12.04 LTS 
>> root-server to work together with Postfix 2.9.1-4
>> After some struggle, I got Postfix's auth working, using dovecot for 
>> smtp-authentification with mysql.
>>
>> But dovecot himself is not working properly. When I connect, after 
>> giving plaintext password I read the error in the client (I connect 
>> for debug reasons with a dos-box on windows):
>>
>> telnet example.org 110
>> +OK Dovecot ready.
>> USER me at example.org
>> +OK
>> PASS myplainpassword
>> -ERR [IN-USE] Internal error occurred. Refer to server log for more 
>> information.
>>
>> If I do:
>>
>> ...
>> PASS thisisthewrongpassword
>>
>> I get:
>>
>> -ERR Authentication failed.
>>
>> And this is the debug-log (I changed IP and names, server to 1.2.3.4 
>> me to 5.6.7.8 server-name to example.org, my email to me at example.org):
>>
>> May 20 12:14:54 auth: Debug: Loading modules from directory: 
>> /usr/lib/dovecot/modules/auth
>> May 20 12:14:54 auth: Debug: Module loaded: 
>> /usr/lib/dovecot/modules/auth/libdriver_mysql.so
>> May 20 12:14:54 auth: Debug: auth client connected (pid=25337)
>> May 20 12:14:57 auth: Debug: client in: AUTH    1    PLAIN    
>> service=pop3    lip=1.2.3.4    rip=5.6.7.8    lport=110    
>> rport=1731    resp=AGZyYW5jQGV3Ni5vcmcAMzE0MTU=
>> May 20 12:14:57 auth-worker: Debug: Loading modules from directory: 
>> /usr/lib/dovecot/modules/auth
>> May 20 12:14:57 auth-worker: Debug: Module loaded: 
>> /usr/lib/dovecot/modules/auth/libdriver_mysql.so
>> May 20 12:14:57 auth-worker: Debug: pam(me at example.org,5.6.7.8): 
>> lookup service=dovecot
>> May 20 12:14:57 auth-worker: Debug: pam(me at example.org,5.6.7.8): #1/1 
>> style=1 msg=Password:
>> May 20 12:15:00 auth-worker: Debug: sql(me at example.org,5.6.7.8): 
>> query: SELECT email as user, password FROM view_users WHERE 
>> email='me at example.org';
>> May 20 12:15:00 auth: Debug: client out: OK    1    user=me at example.org
>> May 20 12:15:00 auth: Debug: master in: REQUEST    4018667521    
>> 25337    1    ccd274c0359454ad3beae53ccb1cc03b
>> May 20 12:15:00 auth: Debug: passwd(me at example.org,5.6.7.8): lookup
>> May 20 12:15:00 auth: Debug: prefetch(me at example.org,5.6.7.8): passdb 
>> didn't return userdb entries, trying the next userdb
>> May 20 12:15:00 auth-worker: Debug: sql(me at example.org,5.6.7.8): 
>> SELECT home, uid, gid FROM users WHERE username = 'me' AND domain = 
>> 'example.org'
>> May 20 12:15:00 auth: Debug: master out: FAIL    4018667521
>>
>> And with wrong password:
>> ...
>> May 20 12:42:51 auth-worker: Debug: sql(me at example.org,5.6.7.8): 
>> query: SELECT email as user, password FROM view_users WHERE 
>> email='me at example.org';
>> May 20 12:42:51 auth-worker: Debug: sql(me at example.org,5.6.7.8): 
>> PLAIN-MD5(thisisthewrongpassword) != '7d7ba8201b765ffd4b212268b8c34d1c'
>> May 20 12:42:53 auth: Debug: client out: FAIL    1    
>> user=me at example.org
>>
>> I don't understand the error messages (yet), could somebody please 
>> give me a hint?
>>
>> My dovecot.conf:
>>
>> passdb {
>>    driver = sql
>>    args = /etc/dovecot/dovecot-sql.conf
>> }
>> userdb {
>>    driver = prefetch
>> }
>> userdb {
>>    driver = sql
>>    args = /etc/dovecot/dovecot-sql.conf
>> }
>>
>>
>> dovecot-sql.conf:
>>
>> driver = mysql
>> connect = host=127.0.0.1 dbname=maildb user=mailuser 
>> password=mailpassword
>> default_pass_scheme = PLAIN-MD5
>> password_query = SELECT email as user, password FROM view_users WHERE 
>> email='%u';
>>
>>
>> 10-auth.conf:
>>
>> disable_plaintext_auth = no
>> auth_mechanisms = plain
>> !include auth-system.conf.ext
>>
>>
>> and in my 10-master.conf I have:
>>
>> service imap-login {
>>    inet_listener imap {
>>    }
>>    inet_listener imaps {
>>    }
>> }
>> service pop3-login {
>>    inet_listener pop3 {
>>    }
>>    inet_listener pop3s {
>>    }
>> }
>> service lmtp {
>>    unix_listener lmtp {
>>    }
>> }
>> service imap {
>> }
>> service pop3 {
>> }
>> service auth {
>>    unix_listener auth-userdb {
>>      mode = 0660
>>    }
>>    unix_listener /var/spool/postfix/private/auth {
>>      mode = 0666
>>      user = postfix
>>      group = postfix
>>    }
>> }
>> service auth-worker {
>> }
>> service dict {
>>    unix_listener dict {
>>    }
>> }
>>
>> I enabled logging in 10-logging.conf, enabled ssl in 10-ssl.conf and 
>> put the path in 10-mail.conf. Beside this I didn't change the defaults.
>>
>>
>> Thank you for help!
>>
>> frank
>>
>>
>

-- 
Tim Smith
Tel: 01423 564 078
Mob: 07984 398 299
Email: info at titan21.co.uk
Web: www.titan21.co.uk