[Dovecot] Quota question.

[Timo Sirainen]

On Aug 28, 2009, at 6:00 PM, Benny Pedersen wrote:

> On Fri, August 28, 2009 23:46, Timo Sirainen wrote:
>> On Fri, 2009-08-28 at 23:43 +0200, Benny Pedersen wrote:
>>> On Fri 14 Aug 2009 02:51:33 AM CEST, Timo Sirainen wrote
>>> in 1.1.16 i have also a problem with quotas, maildirsize file is not
>>> created with new size when mailbox is maked, and if qoutas in sql
>>> changes, then the maildirsize file does not follow
>> That's a completely different problem, you should have just started a
>> new thread instead of replying. Anyway, post your dovecot -n output  
>> and
>> dovecot-sql.conf contents.
>
> okay, did not know that, attached is my dovecot n and sql conf

The problem is

> user_query = SELECT concat('/home/vmail/', maildir) AS home,  
> concat('/home/vmail/', maildir) AS maildir, 125 AS uid, 125 AS gid,  
> concat('maildir:storage=', floor(quota/1024)) AS quota FROM mailbox  
> WHERE username = '%u'

that you're trying to use v1.0 quota configuration with v1.1. You'll  
need in dovecot.conf:

plugin {
   quota = maildir
}

and in user_query:

.., concat('*:bytes=', quota) AS quota_rule FROM ..