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