[Dovecot] Problem with quota recreation

[Uroš Gruber]

Hi,

I'm refering to current usage not limits. Here is my quota-sql config

user_query = \
  SELECT '/var/vmail/%d/%n' as home, 'dict:user::proxy::quota' AS quota,
concat('*:storage=', quotaLimit,'M') AS quota_rule \
  FROM mailAccount WHERE username = '%u' AND domain = '%d' AND isLocked =
FALSE

and actual quota config

map {
  pattern = priv/quota/storage
  table = mailAccount
  username_field = username
  value_field = usageBytes
}
map {
  pattern = priv/quota/messages
  table = mailAccount
  username_field = username
  value_field = usageMessages
}

Select from mysql select username, usageBytes, usageMessages from
mailAccount where username='uros at gruber.si' gives me

uros at gruber.si NULL NULL

actual usageBytes and usageMessages only change on moving messages between
folders or on delivery. But I need recalculate after migration from cyrus to
dovecote via cyrus2dovecote. I tried with GETQUOTAROOT but without any luck.

Best regards

Uros

On Fri, Mar 19, 2010 at 3:16 PM, Steffen Kaiser <
skdovecot at smail.inf.fh-brs.de> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> On Fri, 19 Mar 2010, Uroš Gruber wrote:
>
>  only problem is when i migrate mailbox from cyrus to dovecot and when
>> bytes
>> and messages is set to 0. I tried with x GETQUOTAROOT Inbox but  the quota
>> usage is not recalculated and when a new message is delivered quota is
>> calculated only on the new message. Any help would be greatly appreciated.
>>
>
> Hmm, what does "0" means for cyrus, unlimited too?
> see http://wiki.dovecot.org/Quota/1.1
> "bytes: Quota limit in bytes, 0 means unlimited."
>
> Or do you refer to the actual (current) quota and not the limits?
> In that case, just remove the entries.
>
> Regards,
>
> - -- Steffen Kaiser
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iQEVAwUBS6OHMr+Vh58GPL/cAQLGKQf+Mh7fAs02ydVfsqUTOiiSNAtfu6IGTH9V
> FYSZ1sPvxfybTZOzcf8oViaI2bhtkYd2VblLU+0+w9FlPwvSY5oOfhr5r70EyhB+
> NN42/RfXo91oVM2rK9+tg71HdnsBNJVj+a2I+PTPW5lP7KzHnCV9cDTlHV0845L1
> vMuZTUBsaiPM4k4RRR7l7LzN6gvhLSVLl123SojgMX61G6smmP5jZlIqffb0kY4v
> MDFEbuwr0S04HBKPzTwoUFanRnBvwI9byUmJfEQswqbUzFvgRnSUT2L0Vcq4V6SB
> zGDmq9FPRQCGzbcupPOe1EPV/jqSthI/mzRC1+4yLe4IPDIio4fQ6g==
> =Bn6e
> -----END PGP SIGNATURE-----