I use dovecot-0.99.11 from RHEL4.

dovecot-mysql.conf:

db_host = dbhost db_port = 3306 db = db db_user = dovecot db_passwd = pass default_pass_scheme = PLAIN password_query = SELECT password FROM users WHERE username = '%u' user_query = select maildir AS home,u_id AS uid,g_id AS gid from users WHERE username = '%u'

When I try "telnet localhost 110" and enter test login, I get in errorlog:

dovecot-auth: Jun 06 07:21:49 Info: MySQL: Performing query: SELECT password FROM users WHERE username = 'andy@domain' dovecot-auth: Jun 06 07:21:49 Info: MySQL: Performing query: select maildir AS home,u_id AS uid,g_id AS gid from users WHERE username = 'andy@domain' pop3-login: Jun 06 07:21:49 Info: Login: andy@domain [::ffff:127.0.0.1] dovecot-auth: Jun 06 07:21:49 Info: Login process 9 disconnected dovecot: Jun 06 07:21:49 Fatal: chdir(/var/mail-domain/andy@domain) failed with uid 506: Not a directory dovecot: Jun 06 07:21:49 Error: child 19446 (pop3) returned error 89

I think, dovecot use "/var/mail-domain/andy@domain" as maildir - not as mailbox.

What need set in dovecot config for work with mailbox?

Thanks.

-- Best regards, Andrew Velikoredchanin