IRedMail/FAQ/Recalculate.Mailbox.Quota

From iRedMail

(Difference between revisions)
Jump to: navigation, search
 
(2 intermediate revisions 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>
 +
#
 +
# ---- 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> USE vmail;
mysql> UPDATE mailbox SET bytes=-1,messages=-1 WHERE username='user@domain.ltd';
mysql> UPDATE mailbox SET bytes=-1,messages=-1 WHERE username='user@domain.ltd';
</pre>}}
</pre>}}
-
For OpenLDAP backend:
+
* For OpenLDAP backend:
{{cmd|<pre>
{{cmd|<pre>
mysql> USE iredadmin;
mysql> USE iredadmin;
-
mysql> UPDATE used_quota SET bytes=-1,messages=-1 WHERE username='user@domain.ltd';
+
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.

Retrieved from "http://iredmail.org/wiki/index.php?title=IRedMail/FAQ/Recalculate.Mailbox.Quota"
Personal tools