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='u...@gruber.si' gives me u...@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 < skdove...@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-----