[BlueOnyx:10061] Re: PHP 5.3 and mysql on BO 5106R

[Michael Stauber]

Hi Robert,

> I found the PHP 5.3 package from Solarspeed only has PDO MySQL support
> and does not seem to work with existing mysql libs. Is there a way to
> get the mysql libs necessary to work with PHP 5.3 or is that part of
> what will need to be updated in the sites code?

The Solarspeed PHP comes with MySQL, MySQLi, PDO_MySQL, MSSQL and PGSQL 
support.

However, the MySQL and MySQLi support is only enabled during the late stages 
of PKG installation by copying ...

/home/solarspeed/php/etc/php.d.unused/mysql5.ini 
/home/solarspeed/php/etc/php.d.unused/mysqli.ini

.... over to these locations:

/home/solarspeed/php/etc/php.d/mysql5.ini 
/home/solarspeed/php/etc/php.d/mysqli.ini

So perhaps something went wrong during PKG installation. For example: The 
copying is only triggered if the MySQL version you have installed matches the 
version of MySQL that the PHP was compiled against. If you somehow manually 
upgraded MySQL, then the files will not be copied to prevent Apache from dying 
when PHP tries to load the MySQL extension for an unsupported MySQL version.

So please do the following:

Check if this file exists:

/usr/lib/mysql/libmysqlclient.so.15.0.0

If it does, your MySQL version is OK. In that case run these three commands:

cp /home/solarspeed/php/etc/php.d.unused/mysql5.ini 
/home/solarspeed/php/etc/php.d/mysql5.ini

cp /home/solarspeed/php/etc/php.d.unused/mysqli.ini 
/home/solarspeed/php/etc/php.d/mysqli.ini

/etc/init.d/httpd restart

That should fix it.

-- 
With best regards

Michael Stauber