It worked for me, I'm having same problem changing to:
/etc/dovecot/conf.d/auth-sql.conf.ext:
userdb {
driver = sql
args = /etc/dovecot/dovecot-sql.conf.ext
}
&
/etc/dovecot/dovecot-sql.conf.ext:
user_query = SELECT CONCAT('/home/vmail/mailbox/vhosts/',maildir) AS home,
CONCAT('maildir:/home/vmail/mailbox/vhosts/',maildir) AS mail, 5000 AS uid,
5000 AS gid, CONCAT('*:bytes=', IF(mailbox.quota = 0,
domain.maxquota*1048576, mailbox.quota)) AS quota_rule FROM mailbox, domain
WHERE username = '%u' AND mailbox.active = '1' AND domain.domain = '%d' AND
domain.active = '1'
Done the trick!!!
A very very thank you to you <3
--
Sent from: http://dovecot.2317879.n4.nabble.com/
