Re: [Dovecot] Dovecot 1.0 rc15 + Quota by user using mysql

Hi all, I installed the Dovecot on a Debian by apt-get, it's all working except quota by user.. I have a database with all quotas in bytes, and that lines in /etc/dovecot/dovecot-sql.conf :

driver = mysql connect = host=127.0.0.1 dbname=mailserver user=USER password=PASS default_pass_scheme = CRYPT password_query = SELECT email as user, password FROM view_users WHERE email='%u'; #Quota: user_query = SELECT home AS maildir, 5000 AS uid, 5000 AS gid, CONCAT('dirsize:storage=', ROUND( view_users.quota / 1024) ) AS quota FROM view_users WHERE email='%u';

Try this: ..,concat('maildir:storage=', quota) AS quota ..

PS. Take dovecot from backports. 1.0rc15 is a bit buggy..

Regards