Re: Postfixadmin/MySQL/Dovecot 2 and quota

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/