Upgrade/iRedMail/0.7.3-0.7.4 - Revision history

ZhangHuangbin: /* Fix incorrect calculation of mailbox quota */

ZhangHuangbin — Mon, 09 Jan 2012 03:00:57 GMT

Fix incorrect calculation of mailbox quota

← Older revision		Revision as of 03:00, 9 January 2012
Line 43:		Line 43:
	There's a bug in iRedMail-0.7.3 and all earlier versions: Mailbox quota gets calculated per user and per user alias account, so both email addresses get their own mailbox quota usage. Here's the solution to fix it.		There's a bug in iRedMail-0.7.3 and all earlier versions: Mailbox quota gets calculated per user and per user alias account, so both email addresses get their own mailbox quota usage. Here's the solution to fix it.

-	* Open /etc/dovecot-ldap.conf (RHEL/CentOS/Scientific Linux) or /etc/dovecot/dovecot.conf (Debian/Ubuntu/openSUSE) or /usr/local/etc/dovecot-ldap.conf (FreeBSD), prepend '''mail=user,''' in both '''user_attrs =''' and '''pass_attrs =''' like below:	+	* Open /etc/dovecot-ldap.conf (RHEL/CentOS/Scientific Linux) or /etc/dovecot/dovecot-ldap.conf (Debian/Ubuntu/openSUSE) or /usr/local/etc/dovecot-ldap.conf (FreeBSD), prepend '''mail=user,''' in both '''user_attrs =''' and '''pass_attrs =''' like below:
	{{cfg\|dovecot-ldap.conf\|<pre>		{{cfg\|dovecot-ldap.conf\|<pre>
	# Original settings:		# Original settings:

ZhangHuangbin: /* [Debian and Ubuntu special] Assign Apache daemon user to group "adm" */

ZhangHuangbin — Sun, 08 Jan 2012 16:44:45 GMT

[Debian and Ubuntu special] Assign Apache daemon user to group "adm"

← Older revision		Revision as of 16:44, 8 January 2012
Line 31:		Line 31:
	== [Debian and Ubuntu special] Assign Apache daemon user to group "adm" ==		== [Debian and Ubuntu special] Assign Apache daemon user to group "adm" ==

-	Note: This fix is applicable to only Debian and Ubuntu.	+	'''Note''': This fix is applicable to only Debian and Ubuntu.

	Assign Apache daemon user to group "adm" to avoid Awstats cron job issue.		Assign Apache daemon user to group "adm" to avoid Awstats cron job issue.

ZhangHuangbin: Typo.

ZhangHuangbin — Sun, 08 Jan 2012 16:43:57 GMT

Typo.

← Older revision		Revision as of 16:43, 8 January 2012
Line 5:		Line 5:

	== Fix incorrect per-user sieve_dir setting in Dovecot ==		== Fix incorrect per-user sieve_dir setting in Dovecot ==
-	Note: This fix ~~only works for~~ Dovecot-1.x.	+	'''Note''': This fix is applicable to Dovecot-1.x, you can check Dovecot version with command "dovecot -n".

	In /etc/dovecot.conf or /etc/dovecot/dovecot.conf, remove the last slash (/) in setting '''sieve_dir =''' like below:		In /etc/dovecot.conf or /etc/dovecot/dovecot.conf, remove the last slash (/) in setting '''sieve_dir =''' like below:

ZhangHuangbin at 16:34, 8 January 2012

ZhangHuangbin — Sun, 08 Jan 2012 16:34:15 GMT

← Older revision		Revision as of 16:34, 8 January 2012
Line 1:		Line 1:
	__TOC__		__TOC__

-	~~-------~~
-	~~'''WORKING IN PROGRESS, DO NOT APPLY IT.'''~~
-	~~-------~~

	= General =		= General =

ZhangHuangbin: /* Store mailbox quota in seperate SQL table */

ZhangHuangbin — Thu, 08 Dec 2011 14:52:35 GMT

Store mailbox quota in seperate SQL table

← Older revision		Revision as of 14:52, 8 December 2011
Line 59:		Line 59:
	= MySQL backend special =		= MySQL backend special =

-	== Store mailbox quota in seperate SQL table ==	+	== Store realtime mailbox quota usage in seperate SQL table ==
	'''Summary''':		'''Summary''':

-	In iRedMail-0.7.3 and some earlier versions, Dovecot stores mailbox quota in MySQL database in two columns: '''mailbox.bytes''', '''mailbox.messages''', if they have invalid values (e.g. empty value, non-integer value), Dovecot will update them with two SQL commands:	+	In iRedMail-0.7.3 and some earlier versions, Dovecot stores realtime mailbox quota usage in MySQL database in two columns: '''mailbox.bytes''', '''mailbox.messages''', if they have invalid values (e.g. empty value, non-integer value), Dovecot will update them with two SQL commands:

	# First one: delete record. (DELETE FROM mailbox WHERE username='xxx@yyy.com')		# First one: delete record. (DELETE FROM mailbox WHERE username='xxx@yyy.com')
Line 69:		Line 69:
	First one will delete iRedMail mail user, that's the problem. User [http://www.iredmail.org/forum/topic2641-user-suddenly-gone-from-iredmail.html OviVan reports this issue] after migrated user mailboxes to iRedMail-0.7.3.		First one will delete iRedMail mail user, that's the problem. User [http://www.iredmail.org/forum/topic2641-user-suddenly-gone-from-iredmail.html OviVan reports this issue] after migrated user mailboxes to iRedMail-0.7.3.

-	So we have to store mailbox quota in a separate MySQL table to avoid similar issues.	+	So we have to store realtime mailbox quota usage in a separate MySQL table to avoid similar issues.

-	'''Below are steps to store mailbox quota in a separate SQL table:'''	+	'''Below are steps to store realtime mailbox quota usage in a separate SQL table:'''

	* Create new SQL table '''vmail.used_quota''' to store mailbox quota:		* Create new SQL table '''vmail.used_quota''' to store mailbox quota:

ZhangHuangbin: /* Store mailbox quota in seperate SQL table */

ZhangHuangbin — Thu, 08 Dec 2011 14:42:16 GMT

Store mailbox quota in seperate SQL table

← Older revision		Revision as of 14:42, 8 December 2011
Line 60:		Line 60:

	== Store mailbox quota in seperate SQL table ==		== Store mailbox quota in seperate SQL table ==
		+	'''Summary''':
		+
	In iRedMail-0.7.3 and some earlier versions, Dovecot stores mailbox quota in MySQL database in two columns: '''mailbox.bytes''', '''mailbox.messages''', if they have invalid values (e.g. empty value, non-integer value), Dovecot will update them with two SQL commands:		In iRedMail-0.7.3 and some earlier versions, Dovecot stores mailbox quota in MySQL database in two columns: '''mailbox.bytes''', '''mailbox.messages''', if they have invalid values (e.g. empty value, non-integer value), Dovecot will update them with two SQL commands:

Line 69:		Line 71:
	So we have to store mailbox quota in a separate MySQL table to avoid similar issues.		So we have to store mailbox quota in a separate MySQL table to avoid similar issues.

-	Below are steps to store mailbox quota in a separate SQL table:	+	'''Below are steps to store mailbox quota in a separate SQL table:'''

	* Create new SQL table '''vmail.used_quota''' to store mailbox quota:		* Create new SQL table '''vmail.used_quota''' to store mailbox quota:

ZhangHuangbin: /* Fix incorrect calculation of mailbox quota */

ZhangHuangbin — Wed, 07 Dec 2011 16:43:43 GMT

Fix incorrect calculation of mailbox quota

← Older revision		Revision as of 16:43, 7 December 2011
Line 44:		Line 44:
	= OpenLDAP backend special =		= OpenLDAP backend special =
	== Fix incorrect calculation of mailbox quota ==		== Fix incorrect calculation of mailbox quota ==
-	There's a bug in iRedMail-0.7.3 and all earlier versions: Mailbox quota gets calculated per user and per user alias ~~(shadowAddress)~~, so both ~~emails gets~~ their own quota. Here's solution to fix it.	+	There's a bug in iRedMail-0.7.3 and all earlier versions: Mailbox quota gets calculated per user and per user alias account, so both email addresses get their own mailbox quota usage. Here's the solution to fix it.

	* Open /etc/dovecot-ldap.conf (RHEL/CentOS/Scientific Linux) or /etc/dovecot/dovecot.conf (Debian/Ubuntu/openSUSE) or /usr/local/etc/dovecot-ldap.conf (FreeBSD), prepend '''mail=user,''' in both '''user_attrs =''' and '''pass_attrs =''' like below:		* Open /etc/dovecot-ldap.conf (RHEL/CentOS/Scientific Linux) or /etc/dovecot/dovecot.conf (Debian/Ubuntu/openSUSE) or /usr/local/etc/dovecot-ldap.conf (FreeBSD), prepend '''mail=user,''' in both '''user_attrs =''' and '''pass_attrs =''' like below:

ZhangHuangbin: /* Store mailbox quota in seperate SQL table */

ZhangHuangbin — Fri, 02 Dec 2011 03:43:58 GMT

Store mailbox quota in seperate SQL table

← Older revision		Revision as of 03:43, 2 December 2011
Line 90:		Line 90:

	* Restarting Dovecot service is required.		* Restarting Dovecot service is required.
-	* Drop unused SQL columns: '''mailbox.bytes''', '''mailbox.messages''':
-	~~{{cmd\|<pre>~~
-	~~mysql> USE vmail;~~
-	~~mysql> ALTER TABLE mailbox DROP COLUMN bytes;~~
-	~~mysql> ALTER TABLE mailbox DROP COLUMN messages;~~
-	~~</pre>}}~~

ZhangHuangbin: /* Store mailbox quota in seperate SQL table */

ZhangHuangbin — Wed, 23 Nov 2011 13:48:12 GMT

Store mailbox quota in seperate SQL table

← Older revision		Revision as of 13:48, 23 November 2011
Line 83:		Line 83:
	</pre>}}		</pre>}}

-	* ~~Update Dovecot config file to store mailbox quota in new SQL table.~~ Replace '''table = mailbox''' with '''table = used_quota''' in below config file:	+	* Replace '''table = mailbox''' with '''table = used_quota''' in below config file, so that Dovecot will store mailbox quota in new SQL table.
	** On RHEL/CentOS/Scientific Linux 5.x, please update '''/etc/dovecot-used-quota.conf''', on 6.x, please update '''/etc/dovecot/used-quota.conf'''.		** On RHEL/CentOS/Scientific Linux 5.x, please update '''/etc/dovecot-used-quota.conf''', on 6.x, please update '''/etc/dovecot/used-quota.conf'''.
	** On Debian/Ubuntu, please update '''/etc/dovecot/dovecot-used-quota.conf'''.		** On Debian/Ubuntu, please update '''/etc/dovecot/dovecot-used-quota.conf'''.
Line 90:		Line 90:

	* Restarting Dovecot service is required.		* Restarting Dovecot service is required.
		+	* Drop unused SQL columns: '''mailbox.bytes''', '''mailbox.messages''':
		+	{{cmd\|<pre>
		+	mysql> USE vmail;
		+	mysql> ALTER TABLE mailbox DROP COLUMN bytes;
		+	mysql> ALTER TABLE mailbox DROP COLUMN messages;
		+	</pre>}}

ZhangHuangbin: /* Store mailbox quota in seperate SQL table */

ZhangHuangbin — Wed, 23 Nov 2011 13:41:50 GMT

Store mailbox quota in seperate SQL table

← Older revision		Revision as of 13:41, 23 November 2011
Line 60:		Line 60:

	== Store mailbox quota in seperate SQL table ==		== Store mailbox quota in seperate SQL table ==
-	In iRedMail-0.7.3 and some earlier versions, Dovecot stores mailbox quota in MySQL database in two columns: '''mailbox.bytes''', '''mailbox.messages''', it they have invalid values (e.g. empty value), Dovecot will update them with two SQL commands:	+	In iRedMail-0.7.3 and some earlier versions, Dovecot stores mailbox quota in MySQL database in two columns: '''mailbox.bytes''', '''mailbox.messages''', if they have invalid values (e.g. empty value, non-integer value), Dovecot will update them with two SQL commands:

	# First one: delete record. (DELETE FROM mailbox WHERE username='xxx@yyy.com')		# First one: delete record. (DELETE FROM mailbox WHERE username='xxx@yyy.com')