Upgrade/iRedMail/0.6.1-0.7.0 - Revision history

ZhangHuangbin: /* Support alias domain in mail list/alias */

ZhangHuangbin — Thu, 09 Jun 2011 07:37:45 GMT

Support alias domain in mail list/alias

← Older revision		Revision as of 07:37, 9 June 2011
Line 29:		Line 29:

	* Edit /etc/postfix/ldap_catch_all_maps.cf, set '''query_filter''' to:		* Edit /etc/postfix/ldap_catch_all_maps.cf, set '''query_filter''' to:
-	{{cfg\|/etc/postfix/~~ldap_catchall_maps~~.cf\|<pre>	+	{{cfg\|/etc/postfix/ldap_catch_all_maps.cf\|<pre>
	# NEW SETTING		# NEW SETTING
	query_filter = (&(objectClass=mailUser)(accountStatus=active)(\|(mail=@%d)(shadowAddress=@%d)))		query_filter = (&(objectClass=mailUser)(accountStatus=active)(\|(mail=@%d)(shadowAddress=@%d)))

ZhangHuangbin — Mon, 11 Apr 2011 12:10:07 GMT

ChangeLog

← Older revision		Revision as of 12:10, 11 April 2011
Line 289:		Line 289:

	= ChangeLog =		= ChangeLog =
		+	* 2011-04-11: [MySQL backend special] Add command to create SQL column '''"storagenode"''' in table '''"vmail.mailbox"'''. Thanks insanadair@forum.
	* Initial public.		* Initial public.

	[[Category: iRedMail]]		[[Category: iRedMail]]
	[[Category: Upgrade]]		[[Category: Upgrade]]

ZhangHuangbin — Mon, 11 Apr 2011 12:08:18 GMT

Check domain status in postfix and dovecot

← Older revision		Revision as of 12:08, 11 April 2011
Line 103:		Line 103:
	</pre>}}		</pre>}}

-	'''"WARNING"''': If you don't have column '''"storagenode"''' present in table '''"vmail.mailbox"''', please add it with below SQL command:	+	'''WARNING''': If you don't have column '''"storagenode"''' present in table '''"vmail.mailbox"''', please add it with below SQL command:
	{{cmd\|<pre>		{{cmd\|<pre>
	$ mysql -uroot -p		$ mysql -uroot -p

ZhangHuangbin — Mon, 11 Apr 2011 12:06:57 GMT

Check domain status in postfix and dovecot

← Older revision		Revision as of 12:06, 11 April 2011
Line 101:		Line 101:
	{{cfg\|mysql_virtual_mailbox_maps.cf\|<pre>		{{cfg\|mysql_virtual_mailbox_maps.cf\|<pre>
	query = SELECT CONCAT(mailbox.storagenode, '/', mailbox.maildir) FROM mailbox,domain WHERE mailbox.username='%s' AND mailbox.active='1' AND mailbox.enabledeliver='1' AND domain.domain = mailbox.domain AND domain.active='1'		query = SELECT CONCAT(mailbox.storagenode, '/', mailbox.maildir) FROM mailbox,domain WHERE mailbox.username='%s' AND mailbox.active='1' AND mailbox.enabledeliver='1' AND domain.domain = mailbox.domain AND domain.active='1'
		+	</pre>}}
		+
		+	'''"WARNING"''': If you don't have column '''"storagenode"''' present in table '''"vmail.mailbox"''', please add it with below SQL command:
		+	{{cmd\|<pre>
		+	$ mysql -uroot -p
		+	mysql> USE vmail;
		+	mysql> ALTER TABLE mailbox ADD COLUMN storagenode VARCHAR(255) NOT NULL DEFAULT '';
	</pre>}}		</pre>}}

ZhangHuangbin — Tue, 05 Apr 2011 12:37:15 GMT

Add section 'ChangeLog' to help users understand what was changed.

← Older revision		Revision as of 12:37, 5 April 2011
Line 281:		Line 281:
	Note: If you want to force users to change their passwords in 90 days, please refer to this wiki tutorial: [[Addition/Force.Users.to.Change.Password.in.90.Days \|Force users to change password in 90 days]].		Note: If you want to force users to change their passwords in 90 days, please refer to this wiki tutorial: [[Addition/Force.Users.to.Change.Password.in.90.Days \|Force users to change password in 90 days]].

		+	= ChangeLog =
		+	* Initial public.

	[[Category: iRedMail]]		[[Category: iRedMail]]
	[[Category: Upgrade]]		[[Category: Upgrade]]

ZhangHuangbin — Sun, 03 Apr 2011 01:42:00 GMT

← Older revision		Revision as of 01:42, 3 April 2011
Line 1:		Line 1:
	__TOC__		__TOC__

-	* [[File:Donate.png]] We hope iRedMail users can donate us to make iRedMail continue active and exist. Donate now: http://www.iredmail.org/donate.html	+	----
-	* [[File:Btn_buynow.gif]] Get remote [http://iredmail.org/support.html#remote_installation_support Installation Support] and [http://iredmail.org/support.html#remote_upgrade_support Upgrade Support] from developers if you'~~re not familiar with Linux/BSD.~~	+	* '''Please report bugs in our forum:''' http://www.iredmail.org/forum/
-	* Please report bugs in our forum: http://www.iredmail.org/forum/	+	----
-		+

	= General Update, all backends should apply these changes =		= General Update, all backends should apply these changes =

ZhangHuangbin — Fri, 01 Apr 2011 00:58:27 GMT

Update SQL structure of vmail database

← Older revision		Revision as of 00:58, 1 April 2011
Line 225:		Line 225:

	-- Table: domain_admins		-- Table: domain_admins
-	ALTER TABLE ~~domain~~ ADD INDEX (username);	+	ALTER TABLE domain_admins ADD INDEX (username);
-	ALTER TABLE ~~domain~~ ADD INDEX (domain);	+	ALTER TABLE domain_admins ADD INDEX (domain);
-	ALTER TABLE ~~domain~~ ADD INDEX (active);	+	ALTER TABLE domain_admins ADD INDEX (active);

	-- Table: mailbox		-- Table: mailbox

ZhangHuangbin — Fri, 01 Apr 2011 00:57:18 GMT

Improve backup mx support

← Older revision		Revision as of 00:57, 1 April 2011
Line 95:		Line 95:
	* Edit '''/etc/postfix/mysql_domain_alias_maps.cf''', change '''query =''' to below new setting:		* Edit '''/etc/postfix/mysql_domain_alias_maps.cf''', change '''query =''' to below new setting:
	{{cfg\|/etc/postfix/mysql_domain_alias_maps.cf\|<pre>		{{cfg\|/etc/postfix/mysql_domain_alias_maps.cf\|<pre>
-	query = SELECT alias.goto FROM alias,alias_domain,domain WHERE alias_domain.alias_domain='%d' AND alias.address=CONCAT('%u', '@', alias_domain.target_domain) AND alias_domain.target_domain=domain.domain AND alias.active=1 AND alias_domain.active=1 AND domain.~~backu pmx~~=0	+	query = SELECT alias.goto FROM alias,alias_domain,domain WHERE alias_domain.alias_domain='%d' AND alias.address=CONCAT('%u', '@', alias_domain.target_domain) AND alias_domain.target_domain=domain.domain AND alias.active=1 AND alias_domain.active=1 AND domain.backupmx=0
	</pre>}}		</pre>}}

ZhangHuangbin — Thu, 31 Mar 2011 14:27:28 GMT

← Older revision		Revision as of 14:27, 31 March 2011
Line 5:		Line 5:
	* Please report bugs in our forum: http://www.iredmail.org/forum/		* Please report bugs in our forum: http://www.iredmail.org/forum/

-
-	~~----~~
-	~~'''To be continued, do NOT apply below steps.'''~~
-	~~----~~

	= General Update, all backends should apply these changes =		= General Update, all backends should apply these changes =

Shake.chen — Thu, 31 Mar 2011 05:57:18 GMT

Support alias domain in mail list/alias

← Older revision		Revision as of 05:57, 31 March 2011
Line 33:		Line 33:
	</pre>}}		</pre>}}

-	* Edit /etc/postfix/~~ldap_catchall_maps~~.cf, set '''query_filter''' to:	+	* Edit /etc/postfix/ldap_catch_all_maps.cf, set '''query_filter''' to:
	{{cfg\|/etc/postfix/ldap_catchall_maps.cf\|<pre>		{{cfg\|/etc/postfix/ldap_catchall_maps.cf\|<pre>
	# NEW SETTING		# NEW SETTING