[Dovecot] domain quota dictionary

[alex]

On 07/14/2010 05:20 PM, Timo Sirainen wrote:
> On Wed, 2010-07-14 at 13:38 +0300, alex wrote:
>
>> and the dovecot-quota-domain.conf looks like this :
>
> Looks ok.
>
>> The problem is that the dictionary table gets updated only with the
>> first mailbox informations (quota and messages for the first mailbox
>> within domain that is accessed).
>
> What exactly do you mean by this? That the initial quota is calculated
> only from the first user that accesses it? Yes, that's expected. The
> domain quota support is somewhat of a hack right now, and initial quota
> calculation or quota recalculation isn't possible easily.
>
> Or do you mean that even when other users later do changes, the domain
> quota won't be updated?
>
That exact : other users don't trigger domain quota modification.
This is how I reproduce this behavior :

- clear both tables :
delete from domain_quota where domain like '%example.com';
delete from quota where email like '%example.com';

- login with the first user

select * from quota where email like '%example.com';
+-------------------+------------+----------+---------------------+
| email             | used_quota | messages | last_update         |
+-------------------+------------+----------+---------------------+
| me at example.com    |  123996992 |    21820 | 2010-07-14 17:33:26 |
+-------------------+------------+----------+---------------------+

select * from domain_quota where domain like '%example.com';
+----------------+------------+----------+---------------------+
| domain         | used_quota | messages | last_update         |
+----------------+------------+----------+---------------------+
| example.com 	 |  123996992 |    21820 | 2010-07-14 17:33:03 |
+----------------+------------+----------+---------------------+

..so far so good

- login with the second user

select * from quota where email like '%example.com';
+---------------------+------------+----------+---------------------+
| email               | used_quota | messages | last_update         |
+---------------------+------------+----------+---------------------+
| me at example.com      |  123996992 |    21820 | 2010-07-14 17:33:26 |
| radu at example.com    |    1798426 |        2 | 2010-07-14 17:33:58 |
+---------------------+------------+----------+---------------------+

select * from domain_quota where domain like '%example.com';
+----------------+------------+----------+---------------------+
| domain         | used_quota | messages | last_update         |
+----------------+------------+----------+---------------------+
| example.com 	 |  123996992 |    21820 | 2010-07-14 17:33:03 |
+----------------+------------+----------+---------------------+

..domain quota usage is unchange and messages the same.