Debian + MySQL 4.1 +PHP 5

For the CMS app I am trying to get up and running I have decided to get plump for PHP 5 for the added functionality of Exceptions, and EasyXML, which makes life that bit easier for me to get the job done. I also need the transaction properties given by MySQL from version 4.1 onwards.I have already built my PHP from source code as I outlined in a previous post, now I need to get MySQL 4.1 installed. Fortunately I don’t have to go down the source code route as I can get a package from adding the following repositories to my sources.list file:

deb http://packages.dotdeb.org stable all

deb-src http://packages.dotdeb.org stable all

Then its a simple case of: apt-get install mysql-server-4.1

This installs the new server and client binaries and all the required dependencies as well as removing the old 4.0 installation. It keeps all the users, databases and config from the existing installation. So I was able to immediately check the server was working by using phpMyAdmin. Everything loaded up correctly except there was a message at the bottom of the screen telling me:

“The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.”

This meant a new compilation of PHP was required, so the config string is now:

./configure –with-apxs –with-mysql –with-ffmpeg=YES –with-gd –with-zlib-dir –enable-mbstring

Then:

make & make install

Restart apache to use the new PHP and away you go.