Resolved Plesk Upgrade to 17.5.3 fails due to php-mysql

[Alexander Liebrecht]

Hello Community and Pleskians!

I have an upgrade problem from Plesk Onyx to the new version 17.5.3. It is on the psa-php5-configruator and related to php-mysql.

When upgrading from Plesk I have these lines that are displayed.

Installation started in background
Loaded plugins: fastestmirror, product-id
PHP53_17 | 2.9 kB 00:00
PHP_5_3-thirdparty | 2.9 kB 00:00
PHP_5_4-thirdparty | 2.9 kB 00:00
PHP_5_5-thirdparty | 2.9 kB 00:00
PHP_5_6-thirdparty | 2.9 kB 00:00
PHP_7_0-thirdparty | 2.9 kB 00:00
PHP_7_1-thirdparty | 2.9 kB 00:00
PLESK_17_5_3-dist | 2.9 kB 00:00
PLESK_17_5_3-extras | 2.9 kB 00:00
PLESK_17_5_3-thirdparty | 2.9 kB 00:00
PLESK_17_PHP54 | 2.9 kB 00:00
PLESK_17_PHP55 | 2.9 kB 00:00
PLESK_17_PHP56 | 2.9 kB 00:00
PLESK_17_PHP70 | 2.9 kB 00:00
PLESK_17_PHP71 | 2.9 kB 00:00
PMM_0.1.10-dist | 2.9 kB 00:00
PMM_0.1.10-thirdparty | 2.9 kB 00:00
SITEBUILDER_17_0_15-dist | 2.9 kB 00:00
SITEBUILDER_17_0_15-thirdparty | 2.9 kB 00:00
Loading mirror speeds from cached hostfile
* base: mirror.wiuwiu.de
* epel: mirror.wiuwiu.de
* extras: mirror.wiuwiu.de
* ius: mirror.amsiohosting.net
* remi-php56: remi.schlundtech.de
* remi-php70: remi.schlundtech.de
* remi-php71: remi.schlundtech.de
* remi-safe: remi.schlundtech.de
* updates: mirror.wiuwiu.de
Package php-mysql-5.4.16-42.el7.x86_64 is obsoleted by php-mysqlnd-7.1.7-1.el7.remi.x86_64 which is already installed
Package php-mysql-5.4.16-42.el7.x86_64 is obsoleted by php-mysqlnd-7.1.7-1.el7.remi.x86_64 which is already installed
Package php-mysql-5.4.16-42.el7.x86_64 is obsoleted by php-mysqlnd-7.1.7-1.el7.remi.x86_64 which is already installed
Package php-mysql-5.4.16-42.el7.x86_64 is obsoleted by php-mysqlnd-7.1.7-1.el7.remi.x86_64 which is already installed
Package php-mysql-5.4.16-42.el7.x86_64 is obsoleted by php-mysqlnd-7.1.7-1.el7.remi.x86_64 which is already installed
Package php-mysql-5.4.16-42.el7.x86_64 is obsoleted by php-mysqlnd-7.1.7-1.el7.remi.x86_64 which is already installed
Package php-mysql-5.4.16-42.el7.x86_64 is obsoleted by php-mysqlnd-7.1.7-1.el7.remi.x86_64 which is already installed
Exception: Failed to solve dependencies:
psa-php5-configurator-1.7.0-cos7.build1705170314.17.x86_64 requires php-mysql
Error: Das Dienstprogramm Yum konnte nicht die erforderlichen Pakete installieren.
Achtung! Ihre Software ist vielleicht nicht betriebsbereit.
Bitte kontaktieren Sie den technischen Produktsupport.

What can I do, because apparently php-mysql is needed. I use this however no more, since I'm on PHP 7.1. I have Centos 7.3, the last Centos version and Plesk 17.x.x

Currently mysqlnd is installed on the server and no php-mysql.

If I remove old PHP5.2-5.6 versions, the upgrade still can not go through and it comes to the same error.

Maybe you can help me?

Thanks in advance.

 

[mizar]

Hello,

The easiest workaround for this problem is create empty php-mysql package (to make php5-configurator happy) with version >= 7.1.7. Unfortunately i cannot attach binary package here, so I provide instructions:
1. Install rpm-build package via yum install rpm-build
2. Create a file php-mysql.spec with following content:

Summary: The empty php-mysql package
Name: php-mysql
Version: 8.0.0
Release: 1
License: Public
Group: Applications/System
%description
The empty php-mysql package
%files

3. Build the package: rpmbuild -bb php-mysql.spec
4. Install the empty package rpm -Uvh /root/rpmbuild/RPMS/x86_64/php-mysql-8.0.0-1.x86_64.rpm
5. Run upgrade again

 

[Alexander Liebrecht]

Hello and big thanks to you. It did not take very long and after instruction I can work quite well. It all worked out with success.

This forum helped me now with 2 serious problems with Plesk and I come back again and again when I need help.

My webmaster's life is thus saved

 

[tkalfaoglu]

For me that was not enough.. I recently upgraded to Mariadb..
I already did the rpmbuild and install..

Now I have:

# yum install php-mysqlnd
Resolving Dependencies
--> Running transaction check
---> Package php-mysqlnd.x86_64 0:5.4.16-46.el7 will be installed
--> Processing Dependency: php-pdo(x86-64) = 5.4.16-46.el7 for package: php-mysqlnd-5.4.16-46.el7.x86_64
--> Running transaction check
---> Package php-pdo.x86_64 0:5.4.16-46.el7 will be installed
--> Processing Dependency: php-common(x86-64) = 5.4.16-46.el7 for package: php-pdo-5.4.16-46.el7.x86_64
--> Finished Dependency Resolution
Error: Package: php-pdo-5.4.16-46.el7.x86_64 (base)
Requires: php-common(x86-64) = 5.4.16-46.el7
Installed: php-common-5.4.45-56.el7.art.x86_64 (@atomic)
php-common(x86-64) = 5.4.45-56.el7.art
Available: php-common-5.4.16-46.el7.x86_64 (base)
php-common(x86-64) = 5.4.16-46.el7
You could try using --skip-broken to work around the problem
** Found 1 pre-existing rpmdb problem(s), 'yum check' output follows:
psa-php5-configurator-1.7.0-cos7.build1708180212.17.x86_64 has missing requires of php-pdo

 

[tkalfaoglu]

Followup. I am scared at this point.. production server...

rpm -e php-common --nodeps
warning: /etc/php.ini saved as /etc/php.ini.rpmsave
[root@jedi ~]# yum install php-mysqlnd
Resolving Dependencies
--> Running transaction check
---> Package php-mysqlnd.x86_64 0:5.4.16-46.el7 will be installed
--> Processing Dependency: php-pdo(x86-64) = 5.4.16-46.el7 for package: php-mysqlnd-5.4.16-46.el7.x86_64
--> Running transaction check
---> Package php-pdo.x86_64 0:5.4.16-46.el7 will be installed
--> Processing Dependency: php-common(x86-64) = 5.4.16-46.el7 for package: php-pdo-5.4.16-46.el7.x86_64
--> Running transaction check
---> Package php-common.x86_64 0:5.4.16-46.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===============================================================================================================================================================
Package Arch Version Repository Size
===============================================================================================================================================================
Installing:
php-mysqlnd x86_64 5.4.16-46.el7 base 174 k
Installing for dependencies:
php-common x86_64 5.4.16-46.el7 base 565 k
php-pdo x86_64 5.4.16-46.el7 base 99 k

Transaction Summary
===============================================================================================================================================================
Install 1 Package (+2 Dependent packages)

Total download size: 838 k
Installed size: 4.4 M
Downloading packages:
(1/3): php-common-5.4.16-46.el7.x86_64.rpm | 565 kB 00:00:00
(2/3): php-pdo-5.4.16-46.el7.x86_64.rpm | 99 kB 00:00:00
(3/3): php-mysqlnd-5.4.16-46.el7.x86_64.rpm | 174 kB 00:00:00
---------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 3.0 MB/s | 838 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
** Found 8 pre-existing rpmdb problem(s), 'yum check' output follows:
php-5.4.45-56.el7.art.x86_64 has missing requires of php-common(x86-64) = ('0', '5.4.45', '56.el7.art')
php-cli-5.4.45-56.el7.art.x86_64 has missing requires of php-common(x86-64) = ('0', '5.4.45', '56.el7.art')
php-fpm-5.4.45-56.el7.art.x86_64 has missing requires of php-common(x86-64) = ('0', '5.4.45', '56.el7.art')
php-gd-5.4.45-56.el7.art.x86_64 has missing requires of php-common(x86-64) = ('0', '5.4.45', '56.el7.art')
php-imap-5.4.45-56.el7.art.x86_64 has missing requires of php-common(x86-64) = ('0', '5.4.45', '56.el7.art')
php-mbstring-5.4.45-56.el7.art.x86_64 has missing requires of php-common(x86-64) = ('0', '5.4.45', '56.el7.art')
php-xml-5.4.45-56.el7.art.x86_64 has missing requires of php-common(x86-64) = ('0', '5.4.45', '56.el7.art')
psa-php5-configurator-1.7.0-cos7.build1708180212.17.x86_64 has missing requires of php-pdo
Installing : php-common-5.4.16-46.el7.x86_64 1/3
Installing : php-pdo-5.4.16-46.el7.x86_64 2/3
Installing : php-mysqlnd-5.4.16-46.el7.x86_64 3/3
Verifying : php-common-5.4.16-46.el7.x86_64 1/3
Verifying : php-mysqlnd-5.4.16-46.el7.x86_64 2/3
Verifying : php-pdo-5.4.16-46.el7.x86_64 3/3

Installed:
php-mysqlnd.x86_64 0:5.4.16-46.el7

Dependency Installed:
php-common.x86_64 0:5.4.16-46.el7 php-pdo.x86_64 0:5.4.16-46.el7

Complete!