IRedMail/FAQ/Recalculate.Mailbox.Quota - Revision history

ZhangHuangbin at 06:58, 8 June 2012

ZhangHuangbin — Fri, 08 Jun 2012 06:58:10 GMT

← Older revision		Revision as of 06:58, 8 June 2012
Line 23:		Line 23:

	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]]

ZhangHuangbin at 00:05, 29 May 2012

ZhangHuangbin — Tue, 29 May 2012 00:05:59 GMT

← Older revision		Revision as of 00:05, 29 May 2012
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> ~~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>}}

ZhangHuangbin at 04:44, 26 January 2012

ZhangHuangbin — Thu, 26 Jan 2012 04:44:06 GMT

← Older revision		Revision as of 04:44, 26 January 2012
Line 3:		Line 3:
	For MySQL backend:		For MySQL 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';

ZhangHuangbin at 16:47, 28 June 2011

ZhangHuangbin — Tue, 28 Jun 2011 16:47:23 GMT

← Older revision		Revision as of 16:47, 28 June 2011
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 backend:
	{{cmd\|<pre>		{{cmd\|<pre>
		+	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> UPDATE used_quota SET bytes=-1,messages=-1 WHERE username='user@domain.ltd';
	</pre>}}		</pre>}}

ZhangHuangbin at 06:22, 11 May 2011

ZhangHuangbin — Wed, 11 May 2011 06:22:19 GMT

← Older revision		Revision as of 06:22, 11 May 2011
Line 7:		Line 7:

	Re-login to webmail will get correct quota size.		Re-login to webmail will get correct quota size.
		+
		+	[[Category: iRedMail/FAQ]]
		+	[[Category: FAQ]]

ZhangHuangbin: 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|

 mysql> UPDATE mailbox SET bytes=-1,messages=-1 W…'

ZhangHuangbin — Wed, 11 May 2011 06:21:54 GMT

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…'

New page

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 WHERE username='user@domain.ltd';
</pre>}}

Re-login to webmail will get correct quota size.