[Dovecot] migrating sql virtual 1 to 2, namespace configuration error: inbox=yes namespace missing

[Voytek Eymont]

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 at tld>, method=PLAIN,
rip=111.22.33.5, lip=111.22.33.4, mpid=26892, TLS
dovecot: imap(name at tld): Error: user name at tld: Initialization failed:
namespace configuration error: inbox=yes namespace missing
dovecot: imap(name at 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 = </etc/pki/dovecot/certs/dovecot.pem
ssl_key = </etc/pki/dovecot/private/dovecot.pem
userdb {
  driver = passwd
}
userdb {
  args = /etc/dovecot/dovecot-sql.conf
  driver = sql
}
protocol pop3 {
  pop3_uidl_format = %08Xu%08Xv
}


*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