VPS upgrade php/mysql 'libmysqlclient_14' not found'

[jamesbond]

On a CentOS 4.3 VPS (RELEASE 119) I upgraded PHP from 4.4.4 to 5.1.5, and MySQL from 4.1 to 5.0.24.
Everything works fine, but I noticed /scripts/mysqlup gives this error now:

MySQL Setup Script Version 7.0
Loaded cPPkgs::MySQL ok!
This is the cPPkgs::MySQL 5.0.24 installer for Linux.
MySQL 5.0.24 is up to date
/usr/local/apache/libexec/libphp4.so: /usr/lib/libmysqlclient.so.14: version `libmysqlclient_14' not found (required by /usr/local/apache/libexec/libphp4.so)

I recompiced apache & php twice after upgrading to MySQL 5, but somehow there is a link to /usr/local/apache/libexec/libphp4.so somewhere, that doesn't get updated to /usr/local/apache/libexec/libphp5.so

Has anyone else come across this?

[jamesbond]

Well, I'm going to answer this myself

I removed /usr/local/apache/libexec/libphp4.so, since it is not needed anymore after upgrading to PHP 5. This took care of the libmysqlclient14 error:

MySQL Setup Script Version 7.0
Loaded cPPkgs::MySQL ok!
This is the cPPkgs::MySQL 5.0.24 installer for Linux.
MySQL 5.0.24 is up to date

I guess this function in /scripts/mysqlup is causing the problem:

sub checkphplinkage {
    my ( @LIBS, @LIBS4, @LIBS5, %REQS );

    if ( -e '/usr/local/apache/libexec/libphp4.so' ) {
        @LIBS4 = split( /\n/, `ldd /usr/local/apache/libexec/libphp4.so` );
    }
    if ( -e '/usr/local/apache/libexec/libphp5.so' ) {
        @LIBS5 = split( /\n/, `ldd /usr/local/apache/libexec/libphp5.so` );
    }
    @LIBS = grep( /libmysqlclient/,  @LIBS4, @LIBS5 );
    @LIBS = grep( /not\s+found/, @LIBS4, @LIBS5 );
    foreach my $lib (@LIBS) {
        chomp $lib;
        if ( $lib =~ /(libmysqlclient.so.\S+)/ ) {
            $REQS{ $1 } = 1;
        }
    }

[touma]

I had to remove /usr/local/apache/libexec/libphp4.so and recompile apache. This created libphp5.so in /usr/local/apache/libexec/.

After that I had to comment line
LoadModule php4_module libexec/libphp4.so

and uncomment/add line
LoadModule php5_module libexec/libphp5.so

Thanks for the tip!

[equens]

I have the same problem, do I need to uncomment the LoadModule php5_module libexec/libphp5.so?

Why cannot Cpanel does it?

[erick_paper]

Same problem. Could you people please not assume that everyone who comes here knows what "apache recompile" means, and please include the steps for doing this? I am not sure why PHP 5.2 is not included within WHM, it works very well.

Please advise how I can move forward. How should I install PHP 5.2 and MySQL 5.0.27 and get Apache to restart again? My entire website is down. Thanks!!

[jorj1]

Since the last post there were some changes in the scripts and into the apache configuration file which does not fit under certain circumstances.

Specifically, mysqlup script uses findmysqlversion now to get the mysql version. however, this fails because it looks into httpd.conf for lines containing:

LoadModule php5_module modules/libphp5.so

The problem is that the line above was moved into /usr/local/apache/conf/php.conf and so findmysqlversion will fail when scanning httpd.conf and will try to get the version by running /usr/local/bin/php which will also fail if the library above is not found.

my solution was to replace httpd.conf with php.conf into findphpversion and update the apache after


my $sl = cPScript::SafeFile::safeopen( \*APC, '/usr/local/apache/conf/php.conf' );

hope this helps