Upgrade Roundcube On Squeeze From 0.7.2 To 0.9.5

First of all, I recommend to install Roundcube like described in this Tutorial: https://www.howtoforge.com/easy-roundcube-over-ssl-and-webmin-with-fail2ban-for-ispconfig-3-on-debian-squeeze

Installation of Roundcube with apt is painless easy, but the Problem is that the version is really outdated. So after Installation, you'll have version 0.7.2.

The current Version is 0.9.5. So we will see, how to easily upgrade your Roundcube installation.

Backup

First of all make a backup of your installation. So if something went wrong, you have a way back. 

Upgrade Roundcube with own created Debian package

I recommend to NOT do these steps on your live server. Better create a copy of your server (maybe as a virtual machine [openVZ]) to create those packeges, cause the "build-essential" are not right placed at a LIVE server.

First download the Sources as TAR-File from http://www.roundcube.net/download to /usr/src and extract the Package:

In the command-line execute this:

cd /usr/src
apt-get install devscripts build-essential
apt-get source roundcube
apt-get build-dep roundcube
cd roundcube-0.9.5
uupdate ../roundcubemail-0.9.5.tar.gz
cd ../roundcube-0.9.5
vim debian/rules
#comment a few 'rm' statements
dpkg-buildpackage -b -us -uc -nc

Now you will find your new Packages in /usr/src. They are named like roundcube-core … roundcube-mysql and so on.

Feel free to install those packages now.

Last thing you've to do is to upgrade your old Roundcube mysql installation. Depending on how old your previous Roundcube installation was, you will have to disable a few SQL in the mysql.upgrade.sql file.

Change in the SQL-Folder and execute the sql-Statement:

cd /usr/src/roundcube-0.9.5/SQL
mysql -uroundcube -p roundcube < mysql.update.sql