Upgrade Trixbox to MySQL5

In future versions of A2Billing, MySQL versions earlier than MySQL5 will not be supported, and currently, MySQL4.x is not supported when downloading the A2Billing application from the SVN Trunk.

Removing MySQL4 and PHP

The first job is to remove MySQL4 and PHP by running the following commands: -

yum -y remove mysql mysql-server
yum -y remove php

Install MySQL5

Install MySQL with the following commands: -

yum -y --enablerepo=centosplus install mysql mysql-server

Install Dependencies

We need to install MySQL-sharedcompat-5.x. This can be downloaded by typing:

wget http://ftp.plusline.de/mysql/Downloads/MySQL-5.0/MySQL-shared-compat-5.0.41-0.rhel4.i386.rpm

and then installed with: -

rpm -iv MySQL-shared-compat-5.0.41-0.rhel4.i386.rpm

Then we need to re-install php 4.11 from the Trixbox repositories: -

yum -y install php-mysql php-gd php-mbstring php-imap

and then final piece of PHP, php-pcntl

wget http://dfn.dl.sourceforge.net/sourceforge/phprpms/php-pcntl-4.3.11-2.5.1.i386.rpm

rpm -iv php-pcntl-4.3.11-2.5.1.i386.rpm 

Then finally, there is some renaming to be done. In /etc find the file called php.ini, rename it to php.ini.old and rename php.ini.rpmsave to php.ini

mv php.ini php.ini.old

mv php.ini.rpmsave php.ini

and thats it, you can now go ahead and install A2Billing on Trixbox with A2billing and MySQL5