Topic: PHP Update, error conflicts w MySQL

Happy to pay / donate for solution smile keith(at)kwstudios.biz
I have a site, www.mulabula.com hosted by 1&1 – that is trying to go live… a few pesky bugs remain…  – my software team is having an issue on my server, not their testing servers (2) …
appears to be related to me having older version of PHP than they do.
so, 1&1 has great instructions on how to update PHP:  updatePHP_FAQ
And “everything works great” – EXCEPT – the bottom of the error log shows many conflicts that prevent the install.


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

Short summary:
Currently installed PHP version      5.1.6-24.el5_4.5    Release: 24.el5_4.5
The update SW team attempted on PHP
FROM:
Name       : php
Arch       : x86_64
Version    : 5.1.6
Release    : 24.el5_4.5

TO:
Name       : php
Arch       : i386
Version    : 5.2.14
Release    : 1.el5.art

As a small aside - Currently the mulabula.com site has   mysql version  5.0.77-4.el5_4.1 the new version is 5.1.49 http://www.mysql.com/downloads/mysql/#downloads
Question – Can you take a look at the log below, particularly the error / conflicts at the end to see what may be wrong?
Can you or someone you recommend resolve this for me – I can pay …

Subject: the steps / LOG:

[root@u15408693 ~]# wget -q -O - www.atomicorp.com/installers/atomic | sh

Atomic Archive installer, version 1.2
Configuring the [atomic] yum archive for this system

Installing the Atomic GPG key: OK
Downloading atomic-release-1.0-12.el5.art.noarch.rpm: OK


The Atomic Rocket Turtle archive has now been installed and configured for your system
The following channels are available:
  atomic          - [ACTIVATED] - contains the stable tree of ART packages
  atomic-testing  - [DISABLED]  - contains the testing tree of ART packages
  atomic-bleeding - [DISABLED]  - contains the development tree of ART packages

[root@u15408693 ~]# yum info php
Loaded plugins: fastestmirror
Determining fastest mirrors
* atomic: www2.atomicorp.com
addons                                                   |  951 B     00:00     
addons/primary                                           |  204 B     00:00     
atomic                                                   | 1.9 kB     00:00     
atomic/primary_db                                        | 448 kB     00:00     
base                                                     | 2.1 kB     00:00     
base/primary_db                                          | 2.1 MB     00:00     
extras                                                   | 2.1 kB     00:00     
extras/primary_db                                        | 226 kB     00:00     
updates                                                  | 1.9 kB     00:00     
updates/primary_db                                       | 494 kB     00:00     
Installed Packages
Name       : php
Arch       : x86_64
Version    : 5.1.6
Release    : 24.el5_4.5
Size       : 3.0 M
Repo       : installed
Summary    : The PHP HTML-embedded scripting language. (PHP: Hypertext
           : Preprocessor)
URL        : http://www.php.net/
License    : The PHP License v3.01
Description: PHP is an HTML-embedded scripting language. PHP attempts to make it
           : easy for developers to write dynamically generated webpages. PHP
           : also offers built-in database integration for several commercial
           : and non-commercial database management systems, so writing a
           : database-enabled webpage with PHP is fairly simple. The most common
           : use of PHP coding is probably as a replacement for CGI scripts.
           :
           : The php package contains the module which adds support for the PHP
           : language to Apache HTTP Server.

Available Packages
Name       : php
Arch       : i386
Version    : 5.2.14
Release    : 1.el5.art
Size       : 1.2 M
Repo       : atomic
Summary    : PHP scripting language for creating dynamic web sites
URL        : http://www.php.net/
License    : PHP
Description: PHP is an HTML-embedded scripting language. PHP attempts to make it
           : easy for developers to write dynamically generated webpages. PHP
           : also offers built-in database integration for several commercial
           : and non-commercial database management systems, so writing a
           : database-enabled webpage with PHP is fairly simple. The most common
           : use of PHP coding is probably as a replacement for CGI scripts.
           :
           : The php package contains the module which adds support for the PHP
           : language to Apache HTTP Server.

Name       : php
Arch       : x86_64
Version    : 5.2.14
Release    : 1.el5.art
Size       : 1.3 M
Repo       : atomic
Summary    : PHP scripting language for creating dynamic web sites
URL        : http://www.php.net/
License    : PHP
Description: PHP is an HTML-embedded scripting language. PHP attempts to make it
           : easy for developers to write dynamically generated webpages. PHP
           : also offers built-in database integration for several commercial
           : and non-commercial database management systems, so writing a
           : database-enabled webpage with PHP is fairly simple. The most common
           : use of PHP coding is probably as a replacement for CGI scripts.
           :
           : The php package contains the module which adds support for the PHP
           : language to Apache HTTP Server.

[root@u15408693 ~]# yum update php
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* atomic: www2.atomicorp.com
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package php.x86_64 0:5.2.14-1.el5.art set to be updated
--> Processing Dependency: php-cli = 5.2.14-1.el5.art for package: php
--> Processing Dependency: php-common = 5.2.14-1.el5.art for package: php
--> Running transaction check
---> Package php-cli.x86_64 0:5.2.14-1.el5.art set to be updated
--> Processing Dependency: php-common = 5.1.6-24.el5_4.5 for package: php-mysql
--> Processing Dependency: php-common = 5.1.6-24.el5_4.5 for package: php-pdo
--> Processing Dependency: php-common = 5.1.6-24.el5_4.5 for package: php-mbstring
--> Processing Dependency: php-common = 5.1.6-24.el5_4.5 for package: php-xml
--> Processing Dependency: php-common = 5.1.6-24.el5_4.5 for package: php-imap
--> Processing Dependency: php-common = 5.1.6-24.el5_4.5 for package: php-gd
---> Package php-common.x86_64 0:5.2.14-1.el5.art set to be updated
--> Running transaction check
---> Package php-gd.x86_64 0:5.2.14-1.el5.art set to be updated
--> Processing Dependency: libt1.so.5()(64bit) for package: php-gd
---> Package php-imap.x86_64 0:5.2.14-1.el5.art set to be updated
---> Package php-mbstring.x86_64 0:5.2.14-1.el5.art set to be updated
---> Package php-mysql.x86_64 0:5.2.14-1.el5.art set to be updated
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: php-mysql
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: php-mysql
---> Package php-pdo.x86_64 0:5.2.14-1.el5.art set to be updated
---> Package php-xml.x86_64 0:5.2.14-1.el5.art set to be updated
--> Running transaction check
---> Package mysql-libs.x86_64 0:5.1.48-1.el5.art set to be updated
---> Package t1lib.x86_64 0:5.1.2-2.el5.art set to be updated
--> Processing Dependency: libXaw.so.7()(64bit) for package: t1lib
--> Processing Dependency: libXt.so.6()(64bit) for package: t1lib
--> Running transaction check
---> Package libXaw.x86_64 0:1.0.2-8.1 set to be updated
--> Processing Dependency: libXext.so.6()(64bit) for package: libXaw
--> Processing Dependency: libXmu.so.6()(64bit) for package: libXaw
---> Package libXt.x86_64 0:1.0.2-3.2.el5 set to be updated
--> Processing Dependency: libICE.so.6()(64bit) for package: libXt
--> Processing Dependency: libSM.so.6()(64bit) for package: libXt
--> Running transaction check
---> Package libICE.x86_64 0:1.0.1-2.1 set to be updated
---> Package libSM.x86_64 0:1.0.1-3.1 set to be updated
---> Package libXext.x86_64 0:1.0.1-2.1 set to be updated
---> Package libXmu.x86_64 0:1.0.2-5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================================================================================================================
Package                                          Arch                                       Version                                                Repository                                  Size
=====================================================================================================================================================================================================
Updating:
php                                              x86_64                                     5.2.14-1.el5.art                                       atomic                                     1.3 M
Installing for dependencies:
libICE                                           x86_64                                     1.0.1-2.1                                              base                                        54 k
libSM                                            x86_64                                     1.0.1-3.1                                              base                                        28 k
libXaw                                           x86_64                                     1.0.2-8.1                                              base                                       329 k
libXext                                          x86_64                                     1.0.1-2.1                                              base                                        37 k
libXmu                                           x86_64                                     1.0.2-5                                                base                                        63 k
libXt                                            x86_64                                     1.0.2-3.2.el5                                          base                                       181 k
mysql-libs                                       x86_64                                     5.1.48-1.el5.art                                       atomic                                     2.1 M
t1lib                                            x86_64                                     5.1.2-2.el5.art                                        atomic                                     208 k
Updating for dependencies:
php-cli                                          x86_64                                     5.2.14-1.el5.art                                       atomic                                     2.4 M
php-common                                       x86_64                                     5.2.14-1.el5.art                                       atomic                                     280 k
php-gd                                           x86_64                                     5.2.14-1.el5.art                                       atomic                                     123 k
php-imap                                         x86_64                                     5.2.14-1.el5.art                                       atomic                                      52 k
php-mbstring                                     x86_64                                     5.2.14-1.el5.art                                       atomic                                     1.1 M
php-mysql                                        x86_64                                     5.2.14-1.el5.art                                       atomic                                      85 k
php-pdo                                          x86_64                                     5.2.14-1.el5.art                                       atomic                                      65 k
php-xml                                          x86_64                                     5.2.14-1.el5.art                                       atomic                                     118 k

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

Total download size: 8.4 M
Is this ok [y/N]: y
Downloading Packages:
(1/17): libSM-1.0.1-3.1.x86_64.rpm                                                                                                                                            |  28 kB     00:00     
(2/17): libXext-1.0.1-2.1.x86_64.rpm                                                                                                                                          |  37 kB     00:00     
(3/17): php-imap-5.2.14-1.el5.art.x86_64.rpm                                                                                                                                  |  52 kB     00:00     
(4/17): libICE-1.0.1-2.1.x86_64.rpm                                                                                                                                           |  54 kB     00:00     
(5/17): libXmu-1.0.2-5.x86_64.rpm                                                                                                                                             |  63 kB     00:00     
(6/17): php-pdo-5.2.14-1.el5.art.x86_64.rpm                                                                                                                                   |  65 kB     00:00     
(7/17): php-mysql-5.2.14-1.el5.art.x86_64.rpm                                                                                                                                 |  85 kB     00:00     
(8/17): php-xml-5.2.14-1.el5.art.x86_64.rpm                                                                                                                                   | 118 kB     00:00     
(9/17): php-gd-5.2.14-1.el5.art.x86_64.rpm                                                                                                                                    | 123 kB     00:00     
(10/17): libXt-1.0.2-3.2.el5.x86_64.rpm                                                                                                                                       | 181 kB     00:00     
(11/17): t1lib-5.1.2-2.el5.art.x86_64.rpm                                                                                                                                     | 208 kB     00:00     
(12/17): php-common-5.2.14-1.el5.art.x86_64.rpm                                                                                                                               | 280 kB     00:00     
(13/17): libXaw-1.0.2-8.1.x86_64.rpm                                                                                                                                          | 329 kB     00:00     
(14/17): php-mbstring-5.2.14-1.el5.art.x86_64.rpm                                                                                                                             | 1.1 MB     00:00     
(15/17): php-5.2.14-1.el5.art.x86_64.rpm                                                                                                                                      | 1.3 MB     00:00     
(16/17): mysql-libs-5.1.48-1.el5.art.x86_64.rpm                                                                                                                               | 2.1 MB     00:00     
(17/17): php-cli-5.2.14-1.el5.art.x86_64.rpm                                                                                                                                  | 2.4 MB     00:00     
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                4.9 MB/s | 8.4 MB     00:01     
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test

Re: PHP Update, error conflicts w MySQL

If you use "atomic" repo, ask them.

I can only help users of "remi" repo.

+

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: PHP Update, error conflicts w MySQL

Thanks - you are impressive - sounds like I need to steer my software team over to your product smile  All the best, and thanks for the quick reply.  I'll post my best guess so far below in case it helps any of your users too.
Looks like It’s definitely MySQL conflicts.  It appears I have MySQL 5.0.77 server installed and the PHP MySQL libs need 5.1.   If this is the case, the best course of action would be to dump the data from the MySQL server, remove and reinstall the latest version of the server, libraries and headers.