[Dovecot] Dovecot has no understandable configuration any more

forum forum at decotrain.de
Tue Apr 30 12:49:59 EEST 2013


for many years i used an mailserver with dovecot V1 very satisfied!
One of the reasons to use dovecot was a simply configuration.
Dovecot was the best choice for IMAP for me!

Now i updated the server to Debian testing with dovecot 2.1.7.
It's not possible for me to get a running authentication for virtual 
mail users!

I recently found this mailing and have the same problem:

The documentation says *nothing* about my problem how to authenticate 
with mysql!

I can solve the problem only with try and error without a chance in 
this complex system.
It's nice to have all this possibilites but they are not useful if not 
There should be some clear examples for different scenarios to be found 
in your wiki.

My problem at this time:

I don't know how to configure the userdb to work with mysql 
All mail is running under the special user mail.


disable_plaintext_auth = yes

passdb {
   driver = sql
   # Path for SQL configuration file, see 
   args = /etc/dovecot/dovecot-sql.conf


userdb {
   driver = prefetch

first_valid_uid = 8
last_valid_uid = 8

first_valid_gid = 8
last_valid_gid = 8

mail_location = maildir:/srv/mail/%d/%n


driver = mysql

connect = host=/var/run/mysqld/mysqld.sock dbname=... => WORKS!

default_pass_scheme = SHA1

password_query = SELECT password, '/srv/mail/%d/%n' AS home, 'mail' AS 
uid, 'mail' AS gid FROM user WHERE username = '%n' AND domain = '%d' AND 
IMAP_allowed = 'YES'


Apr 30 10:28:22 auth: Debug: client out: OK     1       user=xxxx at yyyy  
     home=/srv/mail/yyyy/xxxx      uid=mail
Apr 30 10:28:22 auth: Debug: master in: REQUEST 3163291649      5347    
1       87066c907eef8f4e5ed71319b560dd2a
Apr 30 10:28:22 auth: Error: 
prefetch(xxxx at yyyy,::1,<doTKyI/brgAAAAAAAAAAAAAAAAAAAAAB>): userdb 
lookup not possible with only userdb prefetch
Apr 30 10:28:22 auth: Error: 
userdb(xxxx at yyyy,::1,<doTKyI/brgAAAAAAAAAAAAAAAAAAAAAB>): user not found 
from userdb prefetch
Apr 30 10:28:22 auth: Debug: master out: NOTFOUND       3163291649
Apr 30 10:28:22 imap: Error: Authenticated user not found from userdb, 
auth lookup id=3163291649 (client-pid=5347 client-id=1)
Apr 30 10:28:22 imap-login: Info: Internal login failure (pid=5347 
id=1) (internal failure, 1 succesful auths): user=<karsten at dct.mine.nu>, 
method=PLAIN, rip=::1, lip=::1, mpid=5352, secured, 

I have no idea how to solve the problem and up to know i could not find 
an example with google.
Please help.

Best regards

More information about the dovecot mailing list