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

[Lucas Carlessi]

Didn't work... 

Download this Version -> 1:1.0.13-1~bpo40+1  ?

can you help me to update my dovecot? I have
postfix+amavisd+clamav+spamassassin and dovecot using sieve plugin to
redirect spam e-mails to a spam folder... Will I have to update my
configuration files?

thank you


On Tue, 27 May 2008 23:32:10 +0200, Tomasz Suchodolski
<suchodolski.tomasz at gmail.com> wrote:
> 
>> 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