Upgrade/iRedAdmin-Pro/MySQL/1.0-1.1.0
From iRedMail
(Difference between revisions)
(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.…') |
|||
| (One intermediate revision not shown) | |||
| 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 | ||
| - | + | ||
| - | + | ||
| - | + | ||
= 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. | ||
Current revision as of 11:33, 5 May 2011
Contents |
- Release notes of iRedAdmin-Pro-MySQL-1.1.0
- Any questions please post in our forum: http://www.iredmail.org/forum/forum6.html
Summary
This tutorial is used to upgrade iRedAdmin-Pro-MySQL from 1.0 to 1.1.0.
Note: 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:
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.
| Terminal: |
$ 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(); |
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:
| Terminal: |
# # ---- 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 |
- Restart Apache web server.
| Terminal: |
# # ---- 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 |
That's all, you can now access iRedAdmin-Pro-MySQL-1.1.0 with your favorite web browser.
