Upgrade/iRedAdmin-Pro/MySQL/1.0-1.1.0

From iRedMail
Jump to: navigation, search

Contents



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.

Personal tools