libmysqlclient18 and PHP 5.3.6 mysqli extension undefined version

[zigi]

- system:
CentOS 5.6 Final
Linux 2.6.18-238.9.1.el5 #1 SMP Tue Apr 12 18:10:13 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux

- installed:
Percona-Server-client-55.x86_64 - 5.5.11-rel20.2.115.rhel5
Percona-Server-server-55.x86_64 - 5.5.11-rel20.2.115.rhel5
Percona-Server-shared-55.x86_64 - 5.5.11-rel20.2.115.rhel5

php.x86_64 - 5.3.6-3.el5.remi
php-mysql.x86_64- 5.3.6-3.el5.remi

PHP 5.3.6 is installed from "Les RPM de remi pour Enterprise Linux 5" reposity and it is linked against MySQL 5.5 libraries.

[root@egroup etc]# php -v
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/mysqli.so' - /usr/lib64/php/modules/mysqli.so: symbol mysql_client_errors, version libmysqlclient_18 not defined in file libmysqlclient.so.18 with link time reference in Unknown on line 0
PHP 5.3.6 (cli) (built: Apr 15 2011 18:11:25)
Copyright (c) 1997-2011 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2011 Zend Technologies

[Raghavendra D Prabhu (raghavendra-prabhu)]

I am not able to reproduce this anymore. Can you more details?

rpm -qf /usr/lib64/php/modules/mysqli.so
    php-mysql-5.3.3-14.el6_3.x86_64

raghu archie:~ [172]% php -v
    PHP 5.3.3 (cli) (built: Jul 3 2012 16:53:21)
    Copyright (c) 1997-2010 The PHP Group
    Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
    raghu archie:~ [173]% rpm -qa | grep -iE 'percona|mysql'
    Percona-Server-shared-compat-5.5.27-rel28.1.296.rhel6.x86_64
    php-mysql-5.3.3-14.el6_3.x86_64
    Percona-Server-shared-55-5.5.27-rel28.1.296.rhel6.x86_64

[Oleg (ok-k)]

I can reproduce this bug all the time.
I wasn't able to install php-mysql with Percona server so had to install from rpm:
rpm -iv --nodeps http://rpms.famillecollet.com/enterprise/5/remi/x86_64/php-mysql-5.3.17-1.el5.remi.x86_64.rpm

In the previous version of Percona i didn't see such problems but in the lates version i notice this:

[root@platform ~]# php -v
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/mysqli.so' - /usr/lib64/php/modules/mysqli.so: symbol mysql_client_errors, version libmysqlclient_18 not defined in file libmysqlclient.so.18 with link time reference in Unknown on line 0
PHP 5.3.17 (cli) (built: Sep 18 2012 13:12:48)
Copyright (c) 1997-2012 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies

[root@platform ~]# rpm -qa |grep -i percona
Percona-Server-client-55-5.5.27-rel28.1.296.rhel5
Percona-Server-shared-compat-5.5.27-rel28.1.296.rhel5
percona-release-0.0-1
Percona-Server-devel-55-5.5.27-rel28.1.296.rhel5
Percona-Server-shared-55-5.5.27-rel28.1.296.rhel5
Percona-Server-server-55-5.5.27-rel28.1.296.rhel5

[root@platform ~]# cat /etc/redhat-release
CentOS release 5.8 (Final)

I think this topic is related somehow: https://bugs.launchpad.net/percona-server/+bug/722404

[Alexey Bychko (abychko)]

[root@centos-6 ~]# php -v
PHP 5.4.11 (cli) (built: Jan 16 2013 16:51:38)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies

[root@centos-6 ~]# rpm -qa | egrep 'Percona|php' | sort
Percona-Server-55-debuginfo-5.5.28-rel29.3.412.rhel6.x86_64
Percona-Server-client-55-5.5.28-rel29.3.412.rhel6.x86_64
Percona-Server-devel-55-5.5.28-rel29.3.412.rhel6.x86_64
Percona-Server-server-55-5.5.28-rel29.3.412.rhel6.x86_64
Percona-Server-shared-55-5.5.28-rel29.3.412.rhel6.x86_64
Percona-Server-test-55-5.5.28-rel29.3.412.rhel6.x86_64
php-cli-5.4.11-1.el6.remi.x86_64
php-common-5.4.11-1.el6.remi.x86_64
php-mysql-5.4.11-1.el6.remi.x86_64
php-pdo-5.4.11-1.el6.remi.x86_64

seems autofixed by bug #1050654

[Tomislav Plavcic (tplavcic)]

I can't reproduce this now so I'll close it as it was probably fixed by some other ticket:
[vagrant@t-centos5-64 ~]$ php -v
PHP 5.5.33 (cli) (built: Mar 2 2016 14:50:32)
Copyright (c) 1997-2015 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2015 Zend Technologies

[vagrant@t-centos5-64 ~]$ rpm -qa | egrep 'Percona|php' | sort
Percona-Server-client-55-5.5.48-rel37.8.el5
Percona-Server-server-55-5.5.48-rel37.8.el5
Percona-Server-shared-55-5.5.48-rel37.8.el5
php-5.5.33-1.el5.remi
php-cli-5.5.33-1.el5.remi
php-common-5.5.33-1.el5.remi
php-mysqlnd-5.5.33-1.el5.remi
php-pdo-5.5.33-1.el5.remi
php-pecl-jsonc-1.3.9-1.el5.remi.5.5
php-pecl-zip-1.13.2-1.el5.remi.5.5

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-475