Topic: mysql conflict when trying to update PHP from 5.1.6 to 5.2.10

Hi,

We currently run a CentOS 5.3 server that is running PHP v5.1.6 and MySQL 5.0.45:

# rpm -qa | grep -i php
php-pear-1.4.9-4.el5.1
php-mhash-5.1.6-15.el5.centos.1
php-pdo-5.1.6-23.2.el5_3
php-mysql-5.1.6-23.2.el5_3
php-devel-5.1.6-23.2.el5_3
php-common-5.1.6-23.2.el5_3
php-5.1.6-23.2.el5_3
php-cli-5.1.6-23.2.el5_3
php-gd-5.1.6-23.2.el5_3
php-mbstring-5.1.6-23.2.el5_3



# rpm -qa | grep -i mysql
mysql-devel-5.0.45-7.el5
mysql-5.0.45-7.el5
php-mysql-5.1.6-23.2.el5_3
mysql-server-5.0.45-7.el5


I am trying to use the EPEL and Remi repositories to update PHP to 5.2.10.

I have enabled=0 set in /etc/yum.repos.d/epel.repo and /etc/yum.repos.d/remi.repo, and tried to update PHP using:

# yum --enablerepo=remi --enablerepo=epel update  php-\*

This says the following will be updated:

============================================================================================================================================================================
 Package                                     Arch                                Version                                          Repository                           Size
============================================================================================================================================================================
Updating:
 php                                         i386                                5.2.10-1.el5.remi                                remi                                1.2 M
 php-cli                                     i386                                5.2.10-1.el5.remi                                remi                                2.4 M
 php-common                                  i386                                5.2.10-1.el5.remi                                remi                                267 k
 php-devel                                   i386                                5.2.10-1.el5.remi                                remi                                582 k
 php-gd                                      i386                                5.2.10-1.el5.remi                                remi                                124 k
 php-mbstring                                i386                                5.2.10-1.el5.remi                                remi                                1.1 M
 php-mysql                                   i386                                5.2.10-1.el5.remi                                remi                                 84 k
 php-pdo                                     i386                                5.2.10-1.el5.remi                                remi                                 91 k
Installing for dependencies:
 libXaw                                      i386                                1.0.2-8.1                                        base                                324 k
 libXmu                                      i386                                1.0.2-5                                          base                                 62 k
 mysql-libs                                  i386                                5.1.35-1.el5.remi                                remi                                2.1 M
 sqlite2                                     i386                                2.8.17-2.el5.remi                                remi                                170 k
 t1lib                                       i386                                5.1.1-7.el5                                      epel                                194 k

Transaction Summary
============================================================================================================================================================================
Install      5 Package(s)
Update       8 Package(s)
Remove       0 Package(s)

However continuing gives me this error:

Transaction Check Error:
  file /etc/my.cnf from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/charsets/Index.xml from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/charsets/README from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/charsets/ascii.xml from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/charsets/cp1250.xml from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/czech/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/danish/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/dutch/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/english/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/estonian/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/french/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/german/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/greek/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/hungarian/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/italian/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/japanese/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/korean/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/norwegian-ny/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/norwegian/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/polish/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/portuguese/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/romanian/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/russian/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/serbian/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/slovak/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/spanish/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/swedish/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386
  file /usr/share/mysql/ukrainian/errmsg.sys from install of mysql-libs-5.1.35-1.el5.remi.i386 conflicts with file from package mysql-5.0.45-7.el5.i386

Do I have to upgrade MySQL to v5.1 in order to get PHP 5.2.10?

We have 3 servers using MySQL replication (v5.0.45) so I don't want to update MySQL if I can help it.

Thanks very much.

Re: mysql conflict when trying to update PHP from 5.1.6 to 5.2.10

No, you don't have to upgrade mysql.

You can install the compatibility library before updating PHP:

yum --enablerepo=remi-test install mysqlclient16
yum --enablerepo=remi --enablerepo=epel update  php-\*

+

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: mysql conflict when trying to update PHP from 5.1.6 to 5.2.10

Thanks very much Remi.

That seems to have worked perfectly.

Keep up the good work!

Re: mysql conflict when trying to update PHP from 5.1.6 to 5.2.10

I really like that this community is getting more and more united. Though we have work to do, this is a great start.