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

Tomasz Suchodolski suchodolski.tomasz at gmail.com
Wed May 28 00:32:10 EEST 2008


> 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



More information about the dovecot mailing list