IRedMail/FAQ/Recalculate.Mailbox.Quota

From iRedMail

(Difference between revisions)
Jump to: navigation, search
(Created page with 'iRedMail enables dict quota since v0.7.0, dict quota is recalculated only if the quota goes below zero. For example: {{cmd|<pre> mysql> UPDATE mailbox SET bytes=-1,messages=-1 W…')
 
(4 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 example:
+
* 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> 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>}}
 +
 +
* For OpenLDAP backend:
 +
{{cmd|<pre>
 +
mysql> USE iredadmin;
 +
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: 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://www.iredmail.org/wiki/index.php?title=IRedMail/FAQ/Recalculate.Mailbox.Quota"
Personal tools