IRedMail/FAQ/Recalculate.Mailbox.Quota
From iRedMail
(Difference between revisions)
| (One intermediate revision not shown) | |||
| Line 1: | Line 1: | ||
iRedMail enables dict quota since v0.7.0, dict quota is recalculated only if the quota goes below zero. | iRedMail enables dict quota since v0.7.0, dict quota is recalculated only if the quota goes below zero. | ||
| - | For MySQL backend: | + | * For MySQL and PostgreSQL backend: |
{{cmd|<pre> | {{cmd|<pre> | ||
# | # | ||
| Line 16: | Line 16: | ||
</pre>}} | </pre>}} | ||
| - | For OpenLDAP backend: | + | * For OpenLDAP backend: |
{{cmd|<pre> | {{cmd|<pre> | ||
mysql> USE iredadmin; | mysql> USE iredadmin; | ||
| - | mysql> | + | mysql> DELETE FROM used_quota WHERE username='user@domain.ltd'; |
</pre>}} | </pre>}} | ||
Re-login to webmail will get correct quota size. | Re-login to webmail will get correct quota size. | ||
| + | |||
| + | If there're records for non-exist mail users in table '''used_quota''', please delete them. | ||
[[Category: iRedMail/FAQ]] | [[Category: iRedMail/FAQ]] | ||
[[Category: FAQ]] | [[Category: FAQ]] | ||
Current revision as of 06:58, 8 June 2012
iRedMail enables dict quota since v0.7.0, dict quota is recalculated only if the quota goes below zero.
- For MySQL and PostgreSQL backend:
| Terminal: |
# # ---- For iRedMail-0.7.4 and later versions ---- # mysql> USE vmail; mysql> DELETE FROM used_quota WHERE username='user@domain.ltd'; # # ---- For iRedMail-0.7.3 and earlier versions ---- # mysql> USE vmail; mysql> UPDATE mailbox SET bytes=-1,messages=-1 WHERE username='user@domain.ltd'; |
- For OpenLDAP backend:
| Terminal: |
mysql> USE iredadmin; mysql> DELETE FROM used_quota WHERE username='user@domain.ltd'; |
Re-login to webmail will get correct quota size.
If there're records for non-exist mail users in table used_quota, please delete them.
