LP #1050654: Add libmysqlclient.so.18(libmysqlclient_16) and libmysqlclient.so.18(libmysqlclient_18) to Provides of Percona-Server-shared-55 and Percona-XtraDB-Cluster-shared

**Reported in Launchpad by Raghavendra D Prabhu last update 18-01-2018 08:15:53

> yum install percona-toolkit

Loaded plugins: changelog, fastestmirror, langpacks, presto, refresh-packagekit, security, yum-fast-downloader
Loading mirror speeds from cached hostfile

• fedora: fedora.iitm.ac.in

• livna: rpm.livna.org

• rpmfusion-free: mirror.bjtu.edu.cn

• rpmfusion-free-updates: mirror.bjtu.edu.cn

• rpmfusion-nonfree: mirror.bjtu.edu.cn

• rpmfusion-nonfree-updates: mirror.bjtu.edu.cn

• updates: fedora.iitm.ac.in
  Resolving Dependencies
  --> Running transaction check
  ---> Package percona-toolkit.noarch 0:2.1.3-2 will be installed
  --> Processing Dependency: perl(DBD::mysql) >= 1.0 for package: percona-toolkit-2.1.3-2.noarch
  --> Running transaction check
  ---> Package perl-DBD-MySQL.x86_64 0:4.020-2.fc17 will be installed
  --> Processing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.020-2.fc17.x86_64
  Package mysql-libs is obsoleted by Percona-Server-shared-51, but obsoleting package does not provide for requirements
  --> Finished Dependency Resolution
  Error: Package: perl-DBD-MySQL-4.020-2.fc17.x86_64 (fedora)
  Requires: libmysqlclient.so.18(libmysqlclient_16)(64bit)
  Available: mysql-libs-5.5.23-1.fc17.x86_64 (fedora)
  libmysqlclient.so.18(libmysqlclient_16)(64bit)
  Available: mysql-libs-5.5.27-1.fc17.x86_64 (updates)
  libmysqlclient.so.18(libmysqlclient_16)(64bit)
  You could try using --skip-broken to work around the problem
  You could try running: rpm -Va --nofiles --nodigest

======================

This is because:

rpm -q --provides Percona-Server-shared-55-5.5.27-rel28.1.296.rhel6.x86_64

libmysqlclient.so.18()(64bit)
libtool(/usr/lib64/mysql/plugin/libfnv1a_udf.la)
libtool(/usr/lib64/mysql/plugin/libfnv_udf.la)
libtool(/usr/lib64/mysql/plugin/libmurmur_udf.la)
mysql-shared
Percona-Server-shared-55 = 5.5.27-rel28.1.296.rhel6
Percona-Server-shared-55(x86-64) = 5.5.27-rel28.1.296.rhel6

So, Percona-Server-shared doesn't provide libmysqlclient.so.18(libmysqlclient_16)(64bit) which is why the build fails.

In contrast, mysql-libs (the upstream counterpart) provides following:

config(mysql-libs) = 5.5.27-1.fc17
libmysqlclient.so.18
libmysqlclient.so.18(libmysqlclient_16)
libmysqlclient.so.18(libmysqlclient_18)
mysql-libs = 5.5.27-1.fc17
mysql-libs(x86-32) = 5.5.27-1.fc17

from http://pkgs.org/fedora-17/fedora-updates-i386/mysql-libs-5.5.27-1.fc17.i686.rpm.html#provides

1. So, we need to update the spec file for Percona-Server-shared with

libmysqlclient.so.18(libmysqlclient_16)
libmysqlclient.so.18(libmysqlclient_18)

2. Alternatively, we can also put mysql-libs in provides. There is no mysql-shared. This also causes problems elsewhere.

Note, that this problem will arise in CentOS too once perl-DBD-MySQL is updated in its repos.