[Dovecot] Quota BUG ?

[Adrian Minta]

On 11/09/11 20:46, Timo Sirainen wrote:
> On Wed, 2011-11-09 at 20:44 +0200, Adrian Minta wrote:
>>> Is the quota in the database 1096 or>2GB? i.e. is the problem with
>>> reading it, or updating it? In general the quota code uses 64bit
>>> integers everywhere so this shouldn't be happening.
>>>
>>>
>> In the database quota field is 2048000000.
> In the dict quota value? That looks more like the quota limit, not the
> current quota usage.
In the mailbox table.


The 2000000 value commes from:

user_query = SELECT '/home/%d/%n' as home, 'maildir:/home/%d/%n' as
mail, 150 AS uid, 8 AS gid, CONCAT('*:bytes=', CAST(quota AS CHAR)) AS
quota_rule FROM mailbox WHERE username = '%u' AND active = '1'

This value is easy to change by modifying the above mysql query, but the 
1096 value I don't know how to change. Maybe to "instruct" dovecot to 
work  internal with Kilobytes ?

For instance by altering the query like this:

user_query = SELECT '/home/%d/%n' as home, 'maildir:/home/%d/%n' as
mail, 150 AS uid, 8 AS gid, CONCAT('*:bytes=', quota, 'K') AS
quota_rule FROM mailbox WHERE username = '%u' AND active = '1'

... I get ...
* QUOTA "user" (STORAGE 1096 2048000000)

-- 
Best regards,
Adrian Minta    MA3173-RIPE, www.minta.ro