I'm trying to setup a new server on centos 6, from old dovecot 1.x
I installed 'dovecot --version 2.1.1' from dovecot rpm I converted conf file as per migration specs, also, copied sql conf across
when I try to retrieve email, log has *1:
dovecot.conf -m *2 and sql conf *3 follows
*1------------------------------- dovecot: master: Dovecot v2.1.1 starting up (core dumps disabled) dovecot: auth-worker(26890): mysql(127.0.0.1): Connected to database zzz dovecot: imap-login: Login: user=name@tld, method=PLAIN, rip=111.22.33.5, lip=111.22.33.4, mpid=26892, TLS dovecot: imap(name@tld): Error: user name@tld: Initialization failed: namespace configuration error: inbox=yes namespace missing dovecot: imap(name@tld): Error: Invalid user settings. Refer to server log for more information.
*2----------------------------------- # doveconf -n # 2.1.1: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-220.17.1.el6.x86_64 x86_64 CentOS release 6.2 (Final) auth_cache_size = 1 k auth_mechanisms = plain login disable_plaintext_auth = no log_timestamp = "%Y-%m-%d %H:%M:%S " mail_location = maildir:~/Maildir mail_privileged_group = mail mbox_write_locks = fcntl namespace inbox { location = mailbox Drafts { special_use = \Drafts } mailbox Junk { special_use = \Junk } mailbox Sent { special_use = \Sent } mailbox "Sent Messages" { special_use = \Sent } mailbox Trash { special_use = \Trash } prefix = } passdb { args = /etc/dovecot/dovecot-sql.conf driver = sql } protocols = imap pop3 service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0666 user = postfix } user = root } ssl = required ssl_cert =
*3----------------------------------- cat dovecot-sql.conf
driver = mysql connect = host=127.0.0.1 dbname=zzz user=yyy password=xxx
user_query = SELECT concat('/var/mail/vhosts/', maildir) as home, concat('maildir:/var/mail/vhosts/', maildir) as mail, 5000 AS uid, 5000 AS gid, concat('maildir:storage=', quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1'
default_pass_scheme = MD5
user_query = SELECT '/var/mail/vhosts/%d/%n@%d' as home, 'maildir:/var/mail/vhosts/%d/%n@%d' as mail, 5000 AS uid, 5000 AS gid, concat('dirsize:storage=', quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1'
# Get the password password_query = SELECT username as user, password, '/var/mail/vhosts/%d/%n@%d' as userdb_home, 'maildir:/var/mail/vhosts/%d/%n@%d' as userdb_mail, 5000 as userdb_uid, 5000 as userdb_gid FROM mailbox WHERE username = '%u' AND active = '1'
-- Voytek