Topic: Install php-mysql with mysql-commercial

Hi

Using RHEL 6.4. We have a server with mysql-commercial packages installed. When installing mysql-commercial-server, it removes mysql-libs with mysql-commercial-libs, but when I try to install php-mysql from remi, I get a conflict:

[root@xxxxxxxx ~]# rpm -qa | grep mysql
mysql-commercial-libs-5.5.40-2.1.el6.x86_64
mysql-commercial-server-5.5.40-2.1.el6.x86_64
mysql-commercial-common-5.5.40-2.1.el6.x86_64
mysql-commercial-client-5.5.40-2.1.el6.x86_64
mysql-commercial-libs-compat-5.5.40-2.1.el6.x86_64
[root@xxxxxxx ~]# yum --enablerepo remi,epel install php php-mysql php-pgsql php-bcmath php-mbstring php-pecl-mongoLoaded plugins: product-id, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php.x86_64 0:5.4.37-1.el6.remi will be installed
--> Processing Dependency: php-common(x86-64) = 5.4.37-1.el6.remi for package: php-5.4.37-1.el6.remi.x86_64
--> Processing Dependency: php-cli(x86-64) = 5.4.37-1.el6.remi for package: php-5.4.37-1.el6.remi.x86_64
---> Package php-bcmath.x86_64 0:5.4.37-1.el6.remi will be installed
---> Package php-mbstring.x86_64 0:5.4.37-1.el6.remi will be installed
---> Package php-mysql.x86_64 0:5.4.37-1.el6.remi will be installed
--> Processing Dependency: php-pdo(x86-64) = 5.4.37-1.el6.remi for package: php-mysql-5.4.37-1.el6.remi.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: php-mysql-5.4.37-1.el6.remi.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) for package: php-mysql-5.4.37-1.el6.remi.x86_64
---> Package php-pecl-mongo.x86_64 0:1.6.0-1.el6.remi.5.4 will be installed
---> Package php-pgsql.x86_64 0:5.4.37-1.el6.remi will be installed
--> Processing Dependency: libpq.so.5()(64bit) for package: php-pgsql-5.4.37-1.el6.remi.x86_64
--> Running transaction check
---> Package mysql-libs.x86_64 0:5.5.41-1.el6.remi will be installed
---> Package php-cli.x86_64 0:5.4.37-1.el6.remi will be installed
---> Package php-common.x86_64 0:5.4.37-1.el6.remi will be installed
---> Package php-pdo.x86_64 0:5.4.37-1.el6.remi will be installed
---> Package postgresql-libs.x86_64 0:8.4.13-1.el6_3 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================
 Package                          Arch                    Version                                 Repository                       Size
========================================================================================================================================
Installing:
 php                              x86_64                  5.4.37-1.el6.remi                       remi                            2.7 M
 php-bcmath                       x86_64                  5.4.37-1.el6.remi                       remi                             62 k
 php-mbstring                     x86_64                  5.4.37-1.el6.remi                       remi                            947 k
 php-mysql                        x86_64                  5.4.37-1.el6.remi                       remi                            138 k
 php-pecl-mongo                   x86_64                  1.6.0-1.el6.remi.5.4                    remi                            252 k
 php-pgsql                        x86_64                  5.4.37-1.el6.remi                       remi                            115 k
Installing for dependencies:
 mysql-libs                       x86_64                  5.5.41-1.el6.remi                       remi                            777 k
 php-cli                          x86_64                  5.4.37-1.el6.remi                       remi                            3.9 M
 php-common                       x86_64                  5.4.37-1.el6.remi                       remi                            957 k
 php-pdo                          x86_64                  5.4.37-1.el6.remi                       remi                            123 k
 postgresql-libs                  x86_64                  8.4.13-1.el6_3                          rhel_repo_http                  200 k

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

Total size: 10 M
Installed size: 37 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test


Transaction Check Error:
  file /usr/share/mysql/charsets/Index.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/armscii8.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/ascii.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/cp1250.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/cp1251.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/cp1256.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/cp1257.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/cp850.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/cp852.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/cp866.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/dec8.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/geostd8.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/greek.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/hebrew.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/hp8.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/keybcs2.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/koi8r.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/koi8u.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/latin1.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/latin2.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/latin5.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/latin7.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/macce.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/macroman.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/share/mysql/charsets/swe7.xml from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-common-5.5.40-2.1.el6.x86_64
  file /usr/lib64/mysql/libmysqlclient.so.18.0.0 from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-libs-5.5.40-2.1.el6.x86_64
  file /etc/my.cnf from install of mysql-libs-5.5.41-1.el6.remi.x86_64 conflicts with file from package mysql-commercial-server-5.5.40-2.1.el6.x86_64

Error Summary
-------------

Any ideas?

Re: Install php-mysql with mysql-commercial

Simple way, remove php-mysql (which requires libmysqlclient) and use php-mysqlnd instead (native driver), which provide the same extensions (mysql, mysqli and pdo_mysql).

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Re: Install php-mysql with mysql-commercial

Great! Thank you very much.

Re: Install php-mysql with mysql-commercial

smile

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi