1 Topic by hata_ph (edited by hata_ph 2012-02-22 13:44:59)

  • hata_ph
  • Member
  • Offline
  • Registered: 2010-01-13
  • Posts: 226

Topic: Upgrade roundcubemail, phpmyadmin & phpldapadmin

I just upgrade iRedMail-0.7.3 to 0.7.4 and it work fine...but it did not provide tutorial to upgrade roundcubemail, phpmyadmin and phpldapadmin...so I will make a small guide on how to do it... smile
http://www.iredmail.org/forum/topic2816 … eased.html
http://iredmail.org/wiki/index.php?titl … .7.3-0.7.4

You can download the tarball at http://iredmail.org/yum/misc/

RoundcubeMail
# tar xvf roundcubemail-0.7.tar.gz -C /var/www
# cd /var/www/
# cp roundcubemail/config/db.inc.php roundcubemail-0.7/config/
# cp roundcubemail/config/main.inc.php roundcubemail-0.7/config/
# cp roundcubemail/plugins/password/config.inc.php roundcubemail-0.7/plugins/password/config.inc.php
# cp roundcubemail/plugins/managesieve/config.inc.php roundcubemail-0.7/plugins/managesieve/config.inc.php
# chown -R root:root roundcubemail-0.7 # <- optional
# rm -i roundcubemail              # <- Remove old symbol link
# ln -s roundcubemail-0.7 roundcubemail          # Create a new symbol link
# /etc/init.d/httpd restart
# mysql -uroot -p                          # upgrade roundcubemail SQL structure
# mysql> USE roundcubemail;
# mysql> SOURCE /var/www/roundcubemail/SQL/mysql.update.sql;

I read from http://trac.roundcube.net/wiki/Howto_Upgrade about updating the SQL. Do iRedMail need to do that too?

Database Setup

While you're uploading (or after you're done) you have one final step to do before you can start using your new version of RoundCube. You need to check to see if any database changes are needed. Look in the SQL directory in RoundCube, and find a file that is named: "*.update.sql" where * is your database backend type (MySQL, PostgreSQL, SQLite). You only need to execute the commands listed that happened after the version you had previously installed (i.e. anything listed as "Updates from 0.1-beta2").

If desired, you could also drop all of the tables and use the *.initial.sql file to fully recreate the database.

phpMyAdmin
# tar xjf phpMyAdmin-3.4.8-all-languages.tar.bz2 -C /var/www
# cd /var/www/
# cp phpmyadmin/config.inc.php phpMyAdmin-3.4.8-all-languages/
# rm -i phpmyadmin             # <- Remove old symbol link
# ln -s phpMyAdmin-3.4.8-all-languages phpmyadmin          # Create a new symbol link
# /etc/init.d/httpd restart

phpLDAPAdmin
# tar xvf phpldapadmin-1.2.2.tgz -C /var/www
# cd /var/www/
# cp phpldapadmin/config/config.php phpldapadmin-1.2.2/config/
# rm -i phpldapadmin            # <- Remove old symbol link
# ln -s phpldapadmin-1.2.2 phpldapadmin          # Create a new symbol link
# /etc/init.d/httpd restart

PS: This tutorial is based on CentOS but it should work on other Linux distro...

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,785

Re: Upgrade roundcubemail, phpmyadmin & phpldapadmin

hata_ph wrote:

I read from http://trac.roundcube.net/wiki/Howto_Upgrade about updating the SQL. Do iRedMail need to do that too?

Yes, iRedMail needs this too.

3 Reply by hata_ph

  • hata_ph
  • Member
  • Offline
  • Registered: 2010-01-13
  • Posts: 226

Re: Upgrade roundcubemail, phpmyadmin & phpldapadmin

May i know how to do it?

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,785

Re: Upgrade roundcubemail, phpmyadmin & phpldapadmin

You already paste steps in previous post:

Database Setup
While you're uploading (or after you're done) you have one final step to do before you can start using your new version of RoundCube. You need to check to see if any database changes are needed. Look in the SQL directory in RoundCube, and find a file that is named: "*.update.sql" where * is your database backend type (MySQL, PostgreSQL, SQLite). You only need to execute the commands listed that happened after the version you had previously installed (i.e. anything listed as "Updates from 0.1-beta2").
If desired, you could also drop all of the tables and use the *.initial.sql file to fully recreate the database.

iRedMail itself doesn't require addition steps to upgrade Roundcube, so please just do the steps mentioned in Roundcube official tutorial.

5 Reply by hata_ph

  • hata_ph
  • Member
  • Offline
  • Registered: 2010-01-13
  • Posts: 226

Re: Upgrade roundcubemail, phpmyadmin & phpldapadmin

Sorry I don't quite get you. Does it mean no need to do the update/upgrade SQL part?

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,785

Re: Upgrade roundcubemail, phpmyadmin & phpldapadmin

Sorry about the confusion. You MUST upgrade SQL part by following Roundcube official tutorial.

Upgrading Roundcube SQL structure is pretty easy. For example:

# mysql -uroot -p
mysql> USE roundcubemail;
mysql> SOURCE /path/to/roundcubemail-0.7.0/SQL/mysql.update.sql;

That's all.

7 Reply by hata_ph

  • hata_ph
  • Member
  • Offline
  • Registered: 2010-01-13
  • Posts: 226

Re: Upgrade roundcubemail, phpmyadmin & phpldapadmin

Ok...thanks smile