Comment 43 for bug 1169505

Revision history for this message
Roman Vynar (roman-vynar) wrote :

Actually, the problem is not mysql server (mysqld or mysql binaries) but with libmysqlclient.so.16.
According to my steps Percona-Server-shared-compat vs compat-mysql51, both have libmysqlclient.so.16 and it does not depend from libssl at all.

To test, simply take any tool (it can be my php script that uses mysqli, mysqli.so depends on .so.16 and libssl.so) that depends on .so.16, try with compat-mysql51's .so.16 and with Percona-Server-shared-compat's one.

Test #2:

Works:
[root@centos6 ~]# rpm -qa|grep compat-mysql51
compat-mysql51-5.1.54-1.el6.remi.x86_64
[root@centos6 ~]# rpm -ql compat-mysql51-5.1.54-1.el6.remi.x86_64|grep libmysqlclient.so.16
/usr/lib64/mysql/libmysqlclient.so.16
/usr/lib64/mysql/libmysqlclient.so.16.0.0
[root@centos6 ~]# ldd /usr/lib64/php/modules/mysqli.so|grep libmysqlclient.so.16
 libmysqlclient.so.16 => /usr/lib64/mysql/libmysqlclient.so.16 (0x00007fbba0af4000)
[root@centos6 ~]# php mysqli-ssl.php
Array
(
    [0] => Ssl_cipher
    [1] => DHE-RSA-AES256-SHA
)

Does not:
[root@centos6 ~]# rpm -e compat-mysql51 --nodeps
[root@centos6 ~]# yum -y install Percona-Server-shared-compat
[root@centos6 ~]# rpm -ql Percona-Server-shared-compat|grep libmysqlclient.so.16
/usr/lib64/libmysqlclient.so.16
/usr/lib64/libmysqlclient.so.16.0.0
[root@centos6 ~]# ldd /usr/lib64/php/modules/mysqli.so|grep libmysqlclient.so.16
 libmysqlclient.so.16 => /usr/lib64/libmysqlclient.so.16 (0x00007f3c831a6000)
[root@centos6 ~]# php mysqli-ssl.php
PHP Warning: mysqli_real_connect(): (28000/1045): Access denied for user 'percona_ssl'@'192.168.56.101' (using password: YES) in /root/mysqli-ssl.php on line 7
[root@centos6 ~]#