I've setup dovecot to authenticate against postgresql.

But I consistently get a "No INBOX for user" error when I try to do pop requests.

Any pointers would be helpful.

Postfix deposits mails in maildirs in the format /var/spool/virtual_mailboxes/{domain}/{username}/

below is the result of a telnet test (altered slightly of course, but gives the idea)

telnet localhost 110 Trying 127.0.0.1... Connected to localhost.localdomain (127.0.0.1). Escape character is '^]'. +OK dovecot ready. USER personx@myxdomxain.net +OK PASS herexxxx +OK Logged in. -ERR No INBOX for user. Connection closed by foreign host.

here is my dovecot.conf file

/etc/dovecot-pgsql.conf

## Dovecot 1.0 configuration file protocols = imap imaps pop3

# "host:port". imap_listen = * pop3_listen = *

login = imap

login = pop3 # to make sure that users ca here is my dovecot-pgsql.conf file

default_mail_env = maildir:/var/spool/virtual_mailboxes/%lu/%u/Maildir

# Authentication process name. auth = default

auth_user = root auth_userdb = pgsql /etc/dovecot-pgsql.conf auth_passdb = pgsql /etc/dovecot-pgsql.conf

/etc/dovecot-pgsql.conf

connect = host=localhost dbname=mails user=xxxxxxname password=xxxxxxx default_pass_scheme = PLAIN password_query = SELECT password FROM users WHERE userid = '%u' user_query = SELECT '/var/spool/virtual_mailboxes/'||home AS home, uid, gid FROM users WHERE userid = '%u' #user_query = SELECT '/%n' as home,uid, gid FROM users WHERE userid = '%u'