Addition/Migrate.to.New.iRedMail.Server - Revision history

ZhangHuangbin: /* Migrate mailboxes (in maildir format) */

ZhangHuangbin — Wed, 20 Jun 2012 00:07:02 GMT

Migrate mailboxes (in maildir format)

← Older revision		Revision as of 00:07, 20 June 2012
Line 32:		Line 32:
	== Migrate mailboxes (in maildir format) ==		== Migrate mailboxes (in maildir format) ==
	* Simply copy all mailboxes (in maildir format) to new iRedMail server.		* Simply copy all mailboxes (in maildir format) to new iRedMail server.
		+	* Set correct file owner of mailboxes. Default is owned by user '''vmail''', group '''vmail'''.
		+	* Set correct file permission of mailboxes. Default is 0700.

	WARNING: please make sure maildir path which stored/configured in LDAP		WARNING: please make sure maildir path which stored/configured in LDAP

ZhangHuangbin at 15:33, 25 May 2012

ZhangHuangbin — Fri, 25 May 2012 15:33:04 GMT

← Older revision		Revision as of 15:33, 25 May 2012
Line 26:		Line 26:

	All mail accounts are stored in database '''vmail''' by default, to migrate mail accounts, just simply export this database on old server, then import it on new server.		All mail accounts are stored in database '''vmail''' by default, to migrate mail accounts, just simply export this database on old server, then import it on new server.
		+
		+	'''Note''': There might be some changes in SQL structure, please read all upgrade tutorials for your running iRedMail version, then apply SQL structure related upgradings. For example:
		+	* http://www.iredmail.org/wiki/index.php?title=Upgrade/iRedMail/0.7.4-0.8.0#Add_internal_service_required_by_Doveadm_2

	== Migrate mailboxes (in maildir format) ==		== Migrate mailboxes (in maildir format) ==

ZhangHuangbin: /* LDAP: migrate mail accounts */

ZhangHuangbin — Sat, 14 Apr 2012 12:48:19 GMT

LDAP: migrate mail accounts

← Older revision		Revision as of 12:48, 14 April 2012
Line 15:		Line 15:
	* Export mail accounts from LDAP on OLD mail server.		* Export mail accounts from LDAP on OLD mail server.

-	Normally, LDAP data can be exported into LDIF format. Here's backup/export script:	+	Normally, LDAP data can be exported into LDIF format. Here's backup/export script: http://www.iredmail.org/wiki/index.php?title=IRedMail/FAQ/Backup
-	http://www.iredmail.org/wiki/index.php?title=IRedMail/FAQ/Backup	+

-	~~After exported from old server, you will get a plain text file which has~~	+	'''Note''':
-	~~LDIF data. You should remove top some items, includes~~:	+	* There might be some changes in LDAP schema, please read all upgrade tutorials for your running iRedMail version, then apply LDAP data related upgradings. For example:
-	* dc=xxx,dc=xxx	+
-	* cn=vmail,dc=xxx,dc=xxx	+
-	* cn=vmailadmin,dc=xxx,dc=xxx	+
-	* o=domains,dc=xxx,dc=xxx	+
-		+
-	~~Because we will use these ldap objects on new server, so remove them from~~	+
-	~~exported data.~~	+
-		+
-	~~Assume the exported backup data is saved in file /root/old.ldif~~	+
-		+
-	* Now, log into phpLDAPadmin with cn=Manager,dc=xxx,dc=xxx on NEW server, remove object of your mail domain. it should be:	+
-	** domainName=your_domain.com,o=domains,dc=xxx,dc=xxx	+
-		+
-	* Remove all sub-objects under this object.	+
-	* Import /root/old.ldif with phpLDAPadmin.	+
-	~~You can find a button named "Import" in phpLDAPadmin left panel.~~	+
-		+
-	* There might be some changes to LDAP schema, please read all upgrade tutorials for your running iRedMail version, then apply LDAP data related upgradings. For example:	+
	** http://iredmail.org/wiki/index.php?title=Upgrade/iRedMail/0.5.1-0.6.0#Add_missing_values		** http://iredmail.org/wiki/index.php?title=Upgrade/iRedMail/0.5.1-0.6.0#Add_missing_values
	** http://iredmail.org/wiki/index.php?title=Upgrade/iRedMail/0.6.1-0.7.0#Add_missing_value_for_mail_users		** http://iredmail.org/wiki/index.php?title=Upgrade/iRedMail/0.6.1-0.7.0#Add_missing_value_for_mail_users
-		+	* You can find all upgrade tutorials of iRedMail here: http://www.iredmail.org/doc.html#upgrade_tutorial
-	~~Note:~~ You can find all upgrade tutorials here: http://www.iredmail.org/doc.html#upgrade_tutorial	+

	== MySQL: Migrate mail accounts ==		== MySQL: Migrate mail accounts ==

ZhangHuangbin at 16:36, 3 February 2012

ZhangHuangbin — Fri, 03 Feb 2012 16:36:07 GMT

← Older revision		Revision as of 16:36, 3 February 2012
Line 6:		Line 6:

	Since new iRedMail server will install same components as old server, you		Since new iRedMail server will install same components as old server, you
-	can choose what data you want to migrate. The major data are mail accounts,	+	can choose what data you want to migrate. The major data are mail accounts, user mailboxes, roundcube webmail database, Policyd database, Amavisd database.
-	roundcube webmail database, ~~mailboxes~~.	+


Line 45:		Line 44:

	== MySQL: Migrate mail accounts ==		== MySQL: Migrate mail accounts ==
		+
		+	All mail accounts are stored in database '''vmail''' by default, to migrate mail accounts, just simply export this database on old server, then import it on new server.

	== Migrate mailboxes (in maildir format) ==		== Migrate mailboxes (in maildir format) ==
Line 62:		Line 63:
	* Export/import roundcube webmail database, and upgrade database to work with new version of Roundcube.		* Export/import roundcube webmail database, and upgrade database to work with new version of Roundcube.
	http://trac.roundcube.net/wiki/Howto_Upgrade		http://trac.roundcube.net/wiki/Howto_Upgrade
		+
		+	== Migrate Policyd database ==
		+
		+	Policyd database stores blacklist/whitelist, throttling, etc. To migrate its data, simply export this database on old server, then import it on new server.

ZhangHuangbin: /* Important Notes for MySQL backend */

ZhangHuangbin — Fri, 16 Dec 2011 12:33:30 GMT

Important Notes for MySQL backend

← Older revision		Revision as of 12:33, 16 December 2011
Line 56:		Line 56:
	'''This section is applicable to iRedMail-0.7.3 and earlier versions, with MySQL backend. Not required in iRedMail-0.7.4 and later versions.'''		'''This section is applicable to iRedMail-0.7.3 and earlier versions, with MySQL backend. Not required in iRedMail-0.7.4 and later versions.'''

-	Please refer to this section for more details: http://iredmail.org/wiki/index.php?title=Upgrade/iRedMail/0.7.3-0.7.4#Store_realtime_mailbox_quota_usage_in_seperate_SQL_table	+	Please refer to this section for more details: [http://iredmail.org/wiki/index.php?title=Upgrade/iRedMail/0.7.3-0.7.4#Store_realtime_mailbox_quota_usage_in_seperate_SQL_table Store realtime mailbox quota usage in seperate SQL table]

	== Migrate Roundcube webmail data ==		== Migrate Roundcube webmail data ==

ZhangHuangbin: /* Important Notes for MySQL backend */

ZhangHuangbin — Fri, 16 Dec 2011 12:32:31 GMT

Important Notes for MySQL backend

← Older revision		Revision as of 12:32, 16 December 2011
Line 56:		Line 56:
	'''This section is applicable to iRedMail-0.7.3 and earlier versions, with MySQL backend. Not required in iRedMail-0.7.4 and later versions.'''		'''This section is applicable to iRedMail-0.7.3 and earlier versions, with MySQL backend. Not required in iRedMail-0.7.4 and later versions.'''

-	Please ~~force Dovecot~~ to ~~recalculate migrated users' mailbox quota after you copied/migrated mailboxes. Here's tutorial: [[IRedMail/FAQ/Recalculate.Mailbox.Quota \|How to force Dovecot to re-calculate mailbox quota]]~~	+	Please refer to this section for more details: http://iredmail.org/wiki/index.php?title=Upgrade/iRedMail/0.7.3-0.7.4#Store_realtime_mailbox_quota_usage_in_seperate_SQL_table
-		+
-	~~This step is REQUIRED if you migrated mailboxes with iRedMail '''MySQL backend'''. Otherwise Dovecot will delete records in table '''vmail.mailbox''' to re-calculate mailbox quota.~~	+
-		+
-		+
-	~~Here's simple tutorial~~ for ~~your reference~~:	+
-		+
-	~~1) List all migrated users' email address in a plain text file, one address per line. Assume this file is~~ /~~root~~/~~all_migrated_users~~.~~list.~~	+
-		+
-	~~2) Execute below shell command, it will create a file named "result.sql" under directory~~ /~~root.~~	+
-	~~{{cmd\|<pre>~~	+
-	~~# for email in $(cat /root~~/~~all_migrated_users~~.~~list ); do echo "UPDATE mailbox SET bytes~~=~~-1,messages=-1 WHERE username='${email}';"; done >~~ /~~root~~/~~result~~.~~sql~~	+
-	~~</pre>}}~~	+
-		+
-	3~~) Import this SQL file to update SQL table, it will force Dovecot to re~~-~~calculate migrated users' mailbox quota when user first login to Roundcube webmail (or access mailbox via other IMAP clients)~~.	+
-	~~{{cmd\|<pre>~~	+
-	# ~~mysql -uroot -p~~	+
-	~~mysql> USE vmail;~~	+
-	~~mysql> SOURCE /root/result.sql;~~	+
-	~~</pre>}}~~	+

	== Migrate Roundcube webmail data ==		== Migrate Roundcube webmail data ==

ZhangHuangbin: /* Migrate mailboxes (in maildir format) */

ZhangHuangbin — Fri, 02 Dec 2011 03:50:53 GMT

Migrate mailboxes (in maildir format)

← Older revision		Revision as of 03:50, 2 December 2011
Line 53:		Line 53:
	them.		them.

		+	=== Important Notes for MySQL backend ===
		+	'''This section is applicable to iRedMail-0.7.3 and earlier versions, with MySQL backend. Not required in iRedMail-0.7.4 and later versions.'''

-	* '''IMPORTANT NOTE FOR MYSQL BACKEND''': Please force Dovecot to recalculate migrated users' mailbox quota after you copied/migrated mailboxes. Here's tutorial: [[IRedMail/FAQ/Recalculate.Mailbox.Quota \|How to force Dovecot to re-calculate mailbox quota]]	+	Please force Dovecot to recalculate migrated users' mailbox quota after you copied/migrated mailboxes. Here's tutorial: [[IRedMail/FAQ/Recalculate.Mailbox.Quota \|How to force Dovecot to re-calculate mailbox quota]]

	This step is REQUIRED if you migrated mailboxes with iRedMail '''MySQL backend'''. Otherwise Dovecot will delete records in table '''vmail.mailbox''' to re-calculate mailbox quota.		This step is REQUIRED if you migrated mailboxes with iRedMail '''MySQL backend'''. Otherwise Dovecot will delete records in table '''vmail.mailbox''' to re-calculate mailbox quota.

ZhangHuangbin: /* Migrate mailboxes (in maildir format) */

ZhangHuangbin — Thu, 24 Nov 2011 01:38:48 GMT

Migrate mailboxes (in maildir format)

← Older revision		Revision as of 01:38, 24 November 2011
Line 63:		Line 63:
	1) List all migrated users' email address in a plain text file, one address per line. Assume this file is /root/all_migrated_users.list.		1) List all migrated users' email address in a plain text file, one address per line. Assume this file is /root/all_migrated_users.list.

-	2) ~~Create~~ shell ~~script '''~~/root~~/get_sql_commands.sh''' with below content~~.	+	2) Execute below shell command, it will create a file named "result.sql" under directory /root.
	{{cmd\|<pre>		{{cmd\|<pre>
-	~~echo '' >~~ /root/~~result~~.~~sql;~~	+	# for email in $(cat /root/all_migrated_users.list ); do echo "UPDATE mailbox SET bytes=-1,messages=-1 WHERE username='${email}';"; done > /root/result.sql
-	~~while read email~~; do echo "UPDATE mailbox SET bytes=-1,messages=-1 WHERE username='${email}';" >> /root/result.sql~~; done < /root/all_migrated_users.list~~	+
	</pre>}}		</pre>}}

-	3~~) Execute this shell script. As shown in shell code, it will create a file named "result.sql" under directory /root.~~	+	3) Import this SQL file to update SQL table, it will force Dovecot to re-calculate migrated users' mailbox quota when user first login to Roundcube webmail (or access mailbox via other IMAP clients).
-	~~{{cmd\|<pre>~~	+
-	~~# bash /root/get_sql_commands.sh~~	+
-	~~</pre>}}~~	+
-		+
-	4) Import this SQL file to update SQL table, it will force Dovecot to re-calculate migrated users' mailbox quota when user first login to Roundcube webmail (or access mailbox via other IMAP clients).	+
	{{cmd\|<pre>		{{cmd\|<pre>
	# mysql -uroot -p		# mysql -uroot -p

ZhangHuangbin: /* Migrate mailboxes (in maildir format) */

ZhangHuangbin — Wed, 23 Nov 2011 15:41:38 GMT

Migrate mailboxes (in maildir format)

← Older revision		Revision as of 15:41, 23 November 2011
Line 65:		Line 65:
	2) Create shell script '''/root/get_sql_commands.sh''' with below content.		2) Create shell script '''/root/get_sql_commands.sh''' with below content.
	{{cmd\|<pre>		{{cmd\|<pre>
-	~~while read email; do~~	+	echo '' > /root/result.sql;
-	~~cat >~~> /root/result.sql ~~<<EOF~~	+	while read email; do echo "UPDATE mailbox SET bytes=-1,messages=-1 WHERE username='${email}';" >> /root/result.sql; done < /root/all_migrated_users.list
-	UPDATE mailbox SET bytes=-1,messages=-1 WHERE username="${email}";	+
-	~~EOF~~	+
-	done < /root/all_migrated_users.list	+
	</pre>}}		</pre>}}

ZhangHuangbin at 14:43, 23 November 2011

ZhangHuangbin — Wed, 23 Nov 2011 14:43:51 GMT

← Older revision		Revision as of 14:43, 23 November 2011
Line 43:		Line 43:

	Note: You can find all upgrade tutorials here: http://www.iredmail.org/doc.html#upgrade_tutorial		Note: You can find all upgrade tutorials here: http://www.iredmail.org/doc.html#upgrade_tutorial
		+
		+	== MySQL: Migrate mail accounts ==

	== Migrate mailboxes (in maildir format) ==		== Migrate mailboxes (in maildir format) ==