[Dovecot] Problem with quota recreation
Hi,
I'm migrating from cyrus to dovecot 1.2.10 with cyrus2dovecot. I've setup quota with mysql dict and while testing delivery quota is working fine. The 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.
Best regards
Uros
-----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-----
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@gruber.si' gives me
uros@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@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-----
participants (2)
-
Steffen Kaiser
-
Uroš Gruber