Percona-Server 5.5.35-rel33.0.611.rhel6 dependency failure

[Jon Villarreal]

The latest release of Percona-Server on the 5.5 branch requires:

libcrypto.so.10(libcrypto.so.10)(64bit)
libssl.so.10(libssl.so.10)(64bit)

These versions of the libraries were not introduced until RHEL 6.5, therefore installation / upgrades fail on any older point release.

Here's how I duplicated this on a fresh CentOS 6.4 VM:

[root@percona ~]# rpm -qa | grep -i release
centos-release-6-4.el6.centos.10.x86_64
[root@percona ~]# rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
Retrieving http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
Preparing... ########################################### [100%]
   1:percona-release ########################################### [100%]
[root@percona ~]# rpm -qa | grep -i percona
percona-release-0.0-1.x86_64
[root@percona ~]# yum install Percona-Server-server-55
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package Percona-Server-server-55.x86_64 0:5.5.35-rel33.0.611.rhel6 will be installed
--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: Percona-Server-server-55-5.5.35-rel33.0.611.rhel6.x86_64
--> Processing Dependency: Percona-Server-client-55 for package: Percona-Server-server-55-5.5.35-rel33.0.611.rhel6.x86_64
--> Processing Dependency: Percona-Server-shared-55 for package: Percona-Server-server-55-5.5.35-rel33.0.611.rhel6.x86_64
--> Processing Dependency: libssl.so.10(libssl.so.10)(64bit) for package: Percona-Server-server-55-5.5.35-rel33.0.611.rhel6.x86_64
--> Processing Dependency: libcrypto.so.10(libcrypto.so.10)(64bit) for package: Percona-Server-server-55-5.5.35-rel33.0.611.rhel6.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: Percona-Server-server-55-5.5.35-rel33.0.611.rhel6.x86_64
--> Processing Dependency: libaio.so.1()(64bit) for package: Percona-Server-server-55-5.5.35-rel33.0.611.rhel6.x86_64
--> Running transaction check
---> Package Percona-Server-client-55.x86_64 0:5.5.35-rel33.0.611.rhel6 will be installed
--> Processing Dependency: libssl.so.10(libssl.so.10)(64bit) for package: Percona-Server-client-55-5.5.35-rel33.0.611.rhel6.x86_64
--> Processing Dependency: libcrypto.so.10(libcrypto.so.10)(64bit) for package: Percona-Server-client-55-5.5.35-rel33.0.611.rhel6.x86_64
---> Package Percona-Server-server-55.x86_64 0:5.5.35-rel33.0.611.rhel6 will be installed
--> Processing Dependency: libssl.so.10(libssl.so.10)(64bit) for package: Percona-Server-server-55-5.5.35-rel33.0.611.rhel6.x86_64
--> Processing Dependency: libcrypto.so.10(libcrypto.so.10)(64bit) for package: Percona-Server-server-55-5.5.35-rel33.0.611.rhel6.x86_64
---> Package Percona-Server-shared-55.x86_64 0:5.5.35-rel33.0.611.rhel6 will be installed
--> Processing Dependency: libcrypto.so.10(libcrypto.so.10)(64bit) for package: Percona-Server-shared-55-5.5.35-rel33.0.611.rhel6.x86_64
--> Processing Dependency: libssl.so.10(libssl.so.10)(64bit) for package: Percona-Server-shared-55-5.5.35-rel33.0.611.rhel6.x86_64
---> Package libaio.x86_64 0:0.3.107-10.el6 will be installed
--> Finished Dependency Resolution
Error: Package: Percona-Server-server-55-5.5.35-rel33.0.611.rhel6.x86_64 (percona)
           Requires: libcrypto.so.10(libcrypto.so.10)(64bit)
Error: Package: Percona-Server-client-55-5.5.35-rel33.0.611.rhel6.x86_64 (percona)
           Requires: libssl.so.10(libssl.so.10)(64bit)
Error: Package: Percona-Server-client-55-5.5.35-rel33.0.611.rhel6.x86_64 (percona)
           Requires: libcrypto.so.10(libcrypto.so.10)(64bit)
Error: Package: Percona-Server-server-55-5.5.35-rel33.0.611.rhel6.x86_64 (percona)
           Requires: libssl.so.10(libssl.so.10)(64bit)
Error: Package: Percona-Server-shared-55-5.5.35-rel33.0.611.rhel6.x86_64 (percona)
           Requires: libssl.so.10(libssl.so.10)(64bit)
Error: Package: Percona-Server-shared-55-5.5.35-rel33.0.611.rhel6.x86_64 (percona)
           Requires: libcrypto.so.10(libcrypto.so.10)(64bit)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

Reference: https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Linux/6/html-single/6.5_Release_Notes/

[Jericho Rivera (jericho-rivera)]

Verified this on Percona Server 5.6 as well.

I have tested this using openssl-1.0.0-27.el6_4.2.x86_64 and I did get the same dependency error:

[root@localhost vagrant]# rpm -Uvh Percona-Server-shared-56-5.6.15-rel63.0.519.rhel6.x86_64.rpm
error: Failed dependencies:
libcrypto.so.10(libcrypto.so.10)(64bit) is needed by Percona-Server-shared-56-5.6.15-rel63.0.519.rhel6.x86_64
libssl.so.10(libssl.so.10)(64bit) is needed by Percona-Server-shared-56-5.6.15-rel63.0.519.rhel6.x86_64

Upgrading to openssl.x86_64 0:1.0.1e-16.el6_5, fixed the dependency error:

[root@localhost vagrant]# yum update openssl
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: mirror.umd.edu
* epel: mirror.symnds.com
* extras: mirror.symnds.com
* updates: centos.mirror.nac.net
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package openssl.x86_64 0:1.0.0-27.el6_4.2 will be updated
---> Package openssl.x86_64 0:1.0.1e-16.el6_5 will be an update
--> Finished Dependency Resolution

...

Updated:
openssl.x86_64 0:1.0.1e-16.el6_5

Complete!
[root@localhost vagrant]# rpm -Uvh Percona-Server-shared-56-5.6.15-rel63.0.519.rhel6.x86_64.rpm
Preparing... ########################################### [100%]
1:Percona-Server-shared-5########################################### [100%]

[Jericho Rivera (jericho-rivera)]

Confirmed on PS 5.1.73 as well.

[root@localhost vagrant]# rpm -Uvh Percona-Server-shared-51-5.1.73-rel14.11.603.rhel6.x86_64.rpm
error: Failed dependencies:
        libcrypto.so.10(libcrypto.so.10)(64bit) is needed by Percona-Server-shared-51-5.1.73-rel14.11.603.rhel6.x86_64
        libssl.so.10(libssl.so.10)(64bit) is needed by Percona-Server-shared-51-5.1.73-rel14.11.603.rhel6.x86_64
[root@localhost vagrant]# rpm -qa|grep -i openssl
openssl-1.0.0-27.el6_4.2.x86_64
openssl-devel-1.0.0-27.el6_4.2.x86_64

[Nilnandan Joshi (nilnandan-joshi)]

Custom build for Percona Server 5.5.35 (for centos 6.4) is built and uploaded for resolving this issue.

http://www.percona.com/downloads/Percona-Server-5.5-centos-6.4/

[Nilnandan Joshi (nilnandan-joshi)]

Verified with PS 5.6.15

[root@percona1 ~]# rpm -ivh Percona-Server-client-56-5.6.15-rel63.0.519.rhel6.x86_64.rpm Percona-Server-devel-56-5.6.15-rel63.0.519.rhel6.x86_64.rpm Percona-Server-server-56-5.6.15-rel63.0.519.rhel6.x86_64.rpm Percona-Server-shared-56-5.6.15-rel63.0.519.rhel6.x86_64.rpm
error: Failed dependencies:
 libcrypto.so.10(libcrypto.so.10)(64bit) is needed by Percona-Server-client-56-5.6.15-rel63.0.519.rhel6.x86_64
 libssl.so.10(libssl.so.10)(64bit) is needed by Percona-Server-client-56-5.6.15-rel63.0.519.rhel6.x86_64
 libcrypto.so.10(libcrypto.so.10)(64bit) is needed by Percona-Server-server-56-5.6.15-rel63.0.519.rhel6.x86_64
 libssl.so.10(libssl.so.10)(64bit) is needed by Percona-Server-server-56-5.6.15-rel63.0.519.rhel6.x86_64
 libcrypto.so.10(libcrypto.so.10)(64bit) is needed by Percona-Server-shared-56-5.6.15-rel63.0.519.rhel6.x86_64
 libssl.so.10(libssl.so.10)(64bit) is needed by Percona-Server-shared-56-5.6.15-rel63.0.519.rhel6.x86_64
[root@percona1 ~]#

[Raghavendra D Prabhu (raghavendra-prabhu)]

A)
I tested this on my centos 6.3 and it seems to work fine there:

=================================
sudo yum install Percona-Server-server-55
Loaded plugins: auto-update-debuginfo, fastestmirror, presto, security, upgrade-helper
Loading mirror speeds from cached hostfile
 * base: mirror.dhakacom.com
 * centosplus: mirror.dhakacom.com
 * contrib: mirror.dhakacom.com
 * elrepo: ftp.nluug.nl
 * elrepo-extras: ftp.nluug.nl
 * elrepo-kernel: ftp.nluug.nl
 * epel: mirrors.hustunique.com
 * epel-source: mirrors.hustunique.com
 * extras: mirror.dhakacom.com
 * fasttrack: mirror.dhakacom.com
 * updates: mirror.dhakacom.com
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package Percona-Server-server-55.x86_64 0:5.5.35-rel33.0.611.rhel6 will be installed
--> Processing Dependency: Percona-Server-client-55 for package: Percona-Server-server-55-5.5.35-rel33.0.611.rhel6.x86_64
--> Processing Dependency: Percona-Server-shared-55 for package: Percona-Server-server-55-5.5.35-rel33.0.611.rhel6.x86_64
--> Processing Dependency: libssl.so.10(libssl.so.10)(64bit) for package: Percona-Server-server-55-5.5.35-rel33.0.611.rhel6.x86_64
--> Processing Dependency: libcrypto.so.10(libcrypto.so.10)(64bit) for package: Percona-Server-server-55-5.5.35-rel33.0.611.rhel6.x86_64
--> Running transaction check
---> Package Percona-Server-client-55.x86_64 0:5.5.35-rel33.0.611.rhel6 will be installed
---> Package Percona-Server-shared-55.x86_64 0:5.5.35-rel33.0.611.rhel6 will be installed
---> Package openssl.x86_64 0:1.0.0-25.el6_3.1 will be updated
---> Package openssl.x86_64 0:1.0.1e-16.el6_5.4 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================================================================================================================================
 Package Arch Version Repository Size
=====================================================================================================================================================================================================================
Installing:
 Percona-Server-server-55 x86_64 5.5.35-rel33.0.611.rhel6 percona 15 M
Installing for dependencies:
 Percona-Server-client-55 x86_64 5.5.35-rel33.0.611.rhel6 percona 6.2 M
 Percona-Server-shared-55 x86_64 5.5.35-rel33.0.611.rhel6 percona 644 k
Updating for dependencies:
 openssl x86_64 1.0.1e-16.el6_5.4 ...

[Raghavendra D Prabhu (raghavendra-prabhu)]

For PS 5.6

raghu archie:~ [112]% sudo yum clean metadata
Loaded plugins: auto-update-debuginfo, fastestmirror, presto, security, upgrade-
              : helper
Cleaning repos: base centosplus contrib cr debug elrepo elrepo-extras elrepo-kernel
              : epel epel-source extras fasttrack percona updates
43 metadata files removed
27 sqlite files removed
0 metadata files removed

sudo rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
Retrieving http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
Preparing... ########################################### [100%]
   1:percona-release ########################################### [100%]
raghu archie:~ [119]% rpm -qa | grep -i perconapercona-release-0.0-1.x86_64
raghu archie:~ [120]% rpm -qa | grep -i openssl
pyOpenSSL-0.10-2.el6.x86_64
openssl-1.0.0-25.el6_3.1.x86_64
raghu archie:~ [121]% sudo yum install 'Percona-Server-server-56'Loaded plugins: auto-update-debuginfo, fastestmirror, presto, security, upgrade-
              : helper
Loading mirror speeds from cached hostfile
 * base: centos.excellmedia.net
 * centosplus: centos.excellmedia.net
 * contrib: centos.excellmedia.net
 * elrepo: mirror.smartmedia.net.id
 * elrepo-extras: mirror.smartmedia.net.id
 * elrepo-kernel: mirror.smartmedia.net.id
 * epel: epel.mirror.net.in
 * epel-source: epel.mirror.net.in
 * extras: centos.excellmedia.net
 * fasttrack: centos.excellmedia.net
 * updates: centos.excellmedia.net
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package Percona-Server-server-56.x86_64 0:5.6.15-rel63.0.519.rhel6 will be installed
--> Processing Dependency: libssl.so.10(libssl.so.10)(64bit) for package: Percona-Server-server-56-5.6.15-rel63.0.519.rhel6.x86_64
--> Processing Dependency: Percona-Server-client-56 for package: Percona-Server-server-56-5.6.15-rel63.0.519.rhel6.x86_64
--> Processing Dependency: libcrypto.so.10(libcrypto.so.10)(64bit) for package: Percona-Server-server-56-5.6.15-rel63.0.519.rhel6.x86_64
--> Processing Dependency: Percona-Server-shared-56 for package: Percona-Server-server-56-5.6.15-rel63.0.519.rhel6.x86_64
--> Running transaction check
---> Package Percona-Server-client-56.x86_64 0:5.6.15-rel63.0.519.rhel6 will be installed
---> Package Percona-Server-shared-56.x86_64 0:5.6.15-rel63.0.519.rhel6 will be installed
---> Package openssl.x86_64 0:1.0.0-25.el6_3.1 will be updated
---> Package openssl.x86_64 0:1.0.1e-16.el6_5.4 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================
 Package Arch Version Repository Size
=====================================================================================
Installing:
 Percona-Server-server-56 x86_64 5.6.15-rel63.0.519.rhel6 percona 18 M
Installing for dependencies:
 Percona-Server-client-56 x86_64 5.6.15-rel63.0.519.rhel6 percona 6.5 M
 Percona-Server-shared-56 x86_64 5.6.15-rel63.0.519.rhel6 percona 691 k
Updating for dependencies:
 openssl ...

[Jericho Rivera (jericho-rivera)]

So, I've tested installation of Percona Server via 'yum install' and it works across all latest PS releases 5.1/5.5/5.6.
It should be noted that dependencies will be updated as well, and in this case openssl.

After installation I get this:
[root@localhost vagrant]# rpm -qa|grep openssl
openssl-1.0.1e-16.el6_5.4.x86_64
openssl-devel-1.0.1e-16.el6_5.4.x86_64

Although not stated on the original description, based on i38162 as I understand it the client had no intentions of upgrading their openssl package to 1.0.1e.

Probably yum-plugin-versionlock was installed on the client's server and locked openssl from version updates. Disabling 'Updates' on CentOS-Base.repo will still update openssl.

[root@localhost vagrant]# yum install yum-plugin-versionlock
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
 * base: mirrors.advancedhosters.com
 * extras: centos.mirror.nac.net
 * updates: mirror.symnds.com
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package yum-plugin-versionlock.noarch 0:1.1.30-14.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
 Package Arch Version Repository Size
========================================================================================================================================================================
Installing:
 yum-plugin-versionlock noarch 1.1.30-14.el6 base 27 k

Transaction Summary
========================================================================================================================================================================
Install 1 Package(s)

Total download size: 27 k
Installed size: 43 k
Is this ok [y/N]: y
Downloading Packages:
yum-plugin-versionlock-1.1.30-14.el6.noarch.rpm | 27 kB 00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
  Installing : yum-plugin-versionlock-1.1.30-14.el6.noarch 1/1
  Verifying : yum-plugin-versionlock-1.1.30-14.el6.noarch 1/1

Installed:
  yum-plugin-versionlock.noarch 0:1.1.30-14.el6

Complete!

[root@localhost vagrant]# yum versionlock openssl
Loaded plugins: fastestmirror, security, versionlock
Adding versionlock on: 0:openssl-1.0.0-27.el6_4.2
versionlock added: 1

[root@localhost vagrant]# yum install Percona-Server-server-55
Loaded plugins: fastestmirror, security, versionlock
Loading mirror speeds from cached hostfile
 * base...

[Akshay Suryawanshi (akshay-suryawanshi)]

[root@xxxxx ~]# yum install Percona-Server-server-55
Loaded plugins: downloadonly, rhnplugin, security
This system is receiving updates from RHN Classic or RHN Satellite.
epel/metalink | 15 kB 00:00
epel | 4.2 kB 00:00
epel/primary_db | 5.9 MB 00:01
epel-debuginfo/metalink | 13 kB 00:00
epel-debuginfo | 3.0 kB 00:00
epel-debuginfo/primary_db | 585 kB 00:00
monitor | 2.9 kB 00:00
monitor/primary_db | 26 kB 00:00
monitor-contrib | 2.9 kB 00:00
monitor-contrib/primary_db | 2.8 kB 00:00
percona | 951 B 00:00
percona/primary | 59 kB 00:00
percona 200/200
rackspace-rhel-x86_64-server-6.4.z-common | 871 B 00:00
rackspace-rhel-x86_64-server-6.4.z-common/primary | 18 kB 00:00
rackspace-rhel-x86_64-server-6.4.z-common 79/79
rhel-x86_64-server-6.4.z | 1.5 kB 00:00
rhel-x86_64-server-6.4.z/primary | 16 MB 00:01
rhel-x86_64-server-6.4.z 11184/11184
rhel-x86_64-server-optional-6.4.z | 1.5 kB 00:00
rhel-x86_64-server-optional-6.4.z/primary | 1.6 MB 00:00
rhel-x86_64-server-optional-6.4.z 6343/6343
rhn-tools-rhel-x86_64-server-6.4.z | 1.3 kB 00:00
rhn-tools-rhel-x86_64-server-6.4.z/primary | 21 kB 00:00
rhn-tools-rhel-x86_64-server-6.4.z ...

[Joel Watson (joelwat)]

Same problem on openSUSE 31.1

hal-work:/home/jwatson/Desktop # zypper ve
Loading repository data...
Reading installed packages...
4 Problems:
Problem: nothing provides libcrypto.so.10()(64bit) needed by Percona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64
Problem: nothing provides libcrypto.so.10()(64bit) needed by Percona-Server-shared-56-5.6.15-rel63.0.519.rhel6.x86_64
Problem: nothing provides libcrypto.so.10()(64bit) needed by Percona-Server-server-56-5.6.15-rel63.0.519.rhel6.x86_64
Problem: nothing provides libcrypto.so.10()(64bit) needed by Percona-Server-client-56-5.6.15-rel63.0.519.rhel6.x86_64

Problem: nothing provides libcrypto.so.10()(64bit) needed by Percona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64
 Solution 1: downgrade of Percona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64 to Percona-Server-shared-compat-5.5.32-rel31.0.549.rhel6.x86_64
 Solution 2: break Percona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64 by ignoring some of its dependencies

Choose from above solutions by number or skip, retry or cancel [1/2/s/r/c] (c):

[Alexey Bychko (abychko)]

Joel, packages were built on Centos, so that requirement is for Centos library. We do not have SuSE packages at the moment

[Alexey Bychko (abychko)]

All our build servers with vulnerable OpenSSL (heartbleed issue) were upgraded, not only Centos 6.

Centos 6 has new incompatible OpenSSL dependency which prevents installing a lot of software on Centos < 6.5. so, Percona-server if built with newer OpenSSL is incompatible with old OpenSSL too.

for any officially unsupported system src.rpm may be used, to rebuild Percona-Server for any environment. it's not complicated and takes a few minutes on my machine

[Roel Van de Paar (roel11)]

Internal - DOC-89

[Roel Van de Paar (roel11)]

We will create a documentation page to clarify this in detail.

[Shahriyar Rzayev (rzayev-sehriyar)]

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