ZhangHuangbin at 11:33, 5 May 2011

ZhangHuangbin — Thu, 05 May 2011 11:33:05 GMT

← Older revision		Revision as of 11:33, 5 May 2011
Line 4:		Line 4:
	* Any questions please post in our forum: http://www.iredmail.org/forum/forum6.html		* Any questions please post in our forum: http://www.iredmail.org/forum/forum6.html

-	~~----~~	+
-	~~'''TO BE CONTINUED, DO NOT APPLY THEM.~~	+
-	~~----~~	+
	= Summary =		= Summary =
	This tutorial is used to upgrade iRedAdmin-Pro-MySQL from 1.0 to 1.1.0.		This tutorial is used to upgrade iRedAdmin-Pro-MySQL from 1.0 to 1.1.0.

ZhangHuangbin: /* Summary */

ZhangHuangbin — Tue, 19 Apr 2011 08:21:06 GMT

Summary

← Older revision		Revision as of 08:21, 19 April 2011
Line 9:		Line 9:
	= Summary =		= Summary =
	This tutorial is used to upgrade iRedAdmin-Pro-MySQL from 1.0 to 1.1.0.		This tutorial is used to upgrade iRedAdmin-Pro-MySQL from 1.0 to 1.1.0.
		+
	'''Note''': [[Upgrade/iRedMail/0.6.1-0.7.0#Update_SQL_structure_of_vmail_database \|Upgrade your iRedMail to the latest v0.7.0]] is highly recommended, but it's not required to use iRedAdmin-Pro-MySQL-1.1.0.		'''Note''': [[Upgrade/iRedMail/0.6.1-0.7.0#Update_SQL_structure_of_vmail_database \|Upgrade your iRedMail to the latest v0.7.0]] is highly recommended, but it's not required to use iRedAdmin-Pro-MySQL-1.1.0.

ZhangHuangbin: Created page with 'TOC * Release notes of iRedAdmin-Pro-MySQL-1.1.0 * Any questions please post in our forum: http://www.iredmail.org/forum/forum6.…'

ZhangHuangbin — Sun, 10 Apr 2011 12:44:41 GMT

Created page with '__TOC__ * Release notes of iRedAdmin-Pro-MySQL-1.1.0 * Any questions please post in our forum: http://www.iredmail.org/forum/forum6.…'

New page

__TOC__

* [[Release.Notes/iRedAdmin-Pro/MySQL/1.1.0 |Release notes of iRedAdmin-Pro-MySQL-1.1.0]]
* Any questions please post in our forum: http://www.iredmail.org/forum/forum6.html

----
'''TO BE CONTINUED, DO NOT APPLY THEM.
----
= Summary =
This tutorial is used to upgrade iRedAdmin-Pro-MySQL from 1.0 to 1.1.0.
'''Note''': [[Upgrade/iRedMail/0.6.1-0.7.0#Update_SQL_structure_of_vmail_database |Upgrade your iRedMail to the latest v0.7.0]] is highly recommended, but it's not required to use iRedAdmin-Pro-MySQL-1.1.0.

All you need to upgrade from v1.0 to 1.1.0 are:

* Update SQL structure of database '''"vmail"'''.
* Execute one SQL command to sync alias accounts.
* Extract v1.1.0 source tarball.
* Copy config file from '''v1.0'''.
* Set correct file permission.
* Restart Apache.

= Update SQL structure of database '''"vmail"''' =

We add some more columns in database '''"vmail"''', and create necessary INDEXes for them.

Please follow this section to update SQL structure:

* [[Upgrade/iRedMail/0.6.1-0.7.0#Update_SQL_structure_of_vmail_database |Update SQL structure of vmail database]]

= Sync accounts =
There's a bug in iRedAdmin-Pro-MySQL-1.0, it won't create required records in table "vmail.alias", this causes catch-all account doesn't work as expected. Below SQL command can fix it.

{{cmd|<pre>
$ mysql -uroot -p
mysql> USE vmail;
mysql> INSERT INTO alias (address, goto, domain, active) SELECT username,username,domain,active FROM mailbox ON DUPLICATE KEY UPDATE modified=NOW();
</pre>}}

= Upgrade iRedAdmin-Pro-MySQL =
Here are steps used to upgrade iRedAdmin-Pro-MySQL from 1.0 to v1.1.0:

* Download iRedAdmin-Pro-MySQL-1.1.0 source tarball. (You should already received an email with download link, if you didn't get one, please mail to "support@ iredmail.org" directly.)
* Copy or upload iRedAdmin-Pro-MySQL-1.1.0 to your server which has iRedAdmin-Pro-MySQL-'''1.0''' running. We assume you copy it to '''/root/iRedAdmin-Pro-MySQL-1.1.0.tar.bz2'''.

* Exact v1.1.0 source tarball, copy config file from old version '''v1.0''' directly, and set correct file permission:
{{cmd|<pre>
#
# ---- For RHEL/CentOS ----
#
# tar xjf /root/iRedAdmin-Pro-MySQL-1.1.0.tar.bz2 -C /var/www/
# cd /var/www/
# cp iRedAdmin-Pro-MySQL-1.0/settings.ini iRedAdmin-Pro-MySQL-1.1.0/
# rm -i iredadmin # <- This is a symbol link.
# ln -s iRedAdmin-Pro-MySQL-1.1.0 iredadmin # <- Create new symbol link.
# chown -R iredadmin iRedAdmin-Pro-MySQL-1.1.0/
# chmod -R 0755 iRedAdmin-Pro-MySQL-1.1.0/
# chmod 0700 iRedAdmin-Pro-MySQL-1.1.0/settings.ini

#
# ---- For Debian/Ubuntu ----
#
# tar xjf /root/iRedAdmin-Pro-MySQL-1.1.0.tar.bz2 -C /usr/share/apache2/
# cd /usr/share/apache2/
# cp iRedAdmin-Pro-MySQL-1.0/settings.ini iRedAdmin-Pro-MySQL-1.1.0/
# rm -i iredadmin # <- This is a symbol link.
# ln -s iRedAdmin-Pro-MySQL-1.1.0 iredadmin # <- Create new symbol link.
# chown -R iredadmin iRedAdmin-Pro-MySQL-1.1.0/
# chmod -R 0755 iRedAdmin-Pro-MySQL-1.1.0/
# chmod 0700 iRedAdmin-Pro-MySQL-1.1.0/settings.ini

#
# ---- For OpenSuSE ----
#
# tar xjf /root/iRedAdmin-Pro-MySQL-1.1.0.tar.bz2 -C /srv/www/
# cd /srv/www/
# cp iRedAdmin-Pro-MySQL-1.0/settings.ini iRedAdmin-Pro-MySQL-1.1.0/
# rm -i iredadmin # <- This is a symbol link.
# ln -s iRedAdmin-Pro-MySQL-1.1.0 iredadmin # <- Create new symbol link.
# chown -R iredadmin iRedAdmin-Pro-MySQL-1.1.0/
# chmod -R 0755 iRedAdmin-Pro-MySQL-1.1.0/
# chmod 0700 iRedAdmin-Pro-MySQL-1.1.0/settings.ini

#
# ---- For FreeBSD ----
#
# tar xjf /root/iRedAdmin-Pro-MySQL-1.1.0.tar.bz2 -C /usr/local/www/
# cd /usr/local/www/
# cp iRedAdmin-Pro-MySQL-1.0/settings.ini iRedAdmin-Pro-MySQL-1.1.0/
# rm -i iredadmin # <- This is a symbol link.
# ln -s iRedAdmin-Pro-MySQL-1.1.0 iredadmin # <- Create new symbol link.
# chown -R iredadmin iRedAdmin-Pro-MySQL-1.1.0/
# chmod -R 0755 iRedAdmin-Pro-MySQL-1.1.0/
# chmod 0700 iRedAdmin-Pro-MySQL-1.1.0/settings.ini
</pre>}}

* Restart Apache web server.
{{cmd|<pre>
#
# ---- For RHEL/CentOS ----
#
# /etc/init.d/httpd restart

#
# ---- For Debian/Ubuntu ----
#
# /etc/init.d/apache2 restart

#
# ---- For OpenSuSE ----
#
# /etc/init.d/apache2 restart

#
# ---- For FreeBSD ----
#
# /usr/local/etc/rc.d/apache22 restart
</pre>}}

That's all, you can now access iRedAdmin-Pro-MySQL-1.1.0 with your favorite web browser.

Upgrade/iRedAdmin-Pro/MySQL/1.0-1.1.0 - Revision history

ZhangHuangbin at 11:33, 5 May 2011

ZhangHuangbin: /* Summary */

ZhangHuangbin: Created page with '__TOC__ * Release notes of iRedAdmin-Pro-MySQL-1.1.0 * Any questions please post in our forum: http://www.iredmail.org/forum/forum6.…'

ZhangHuangbin: Created page with 'TOC * Release notes of iRedAdmin-Pro-MySQL-1.1.0 * Any questions please post in our forum: http://www.iredmail.org/forum/forum6.…'