Resolved CentOS “Error: php-mysql conflicts with php-mysqlnd” updating with PHP 5.6

[stevemartin]

i moved from php 5.4 to php 5.6 everhting is ok but i have small issues in website we things are not working after research i got to know that i need to install php-mysqlnd it tried to install php-mysqlnd i got error

[root@server ~]# yum install php-mysqlnd
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: centos.mirrors.ovh.net
 * extras: fr.mirror.babylon.network
 * updates: mirrors.ircam.fr
Resolving Dependencies
--> Running transaction check
---> Package php-mysqlnd.x86_64 0:5.4.16-43.el7_4 will be installed
--> Processing Conflict: php-mysql-5.4.16-43.el7_4.x86_64 conflicts php-mysqlnd
--> Finished Dependency Resolution
Error: php-mysql conflicts with php-mysqlnd-5.4.16-43.el7_4.x86_64
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
[root@server ~]#

so i tried to removed php-mysql

[root@server ~]# yum remove php-mysql
Loaded plugins: fastestmirror
Resolving Dependencies
--> Running transaction check
---> Package php-mysql.x86_64 0:5.4.16-43.el7_4 will be erased
--> Processing Dependency: php-mysql for package: psa-php5-configurator-1.7.0-cos7.build1705170314.17.x86_64
--> Running transaction check
---> Package psa-php5-configurator.x86_64 0:1.7.0-cos7.build1705170314.17 will be erased
--> Processing Dependency: psa-php5-configurator for package: psa-phpfpm-configurator-1.0.0-cos7.build1705170314.17.x86_64
--> Running transaction check
---> Package psa-phpfpm-configurator.x86_64 0:1.0.0-cos7.build1705170314.17 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package          Arch   Version                       Repository          Size
================================================================================
Removing:
 php-mysql        x86_64 5.4.16-43.el7_4               @updates           232 k
Removing for dependencies:
 psa-php5-configurator
                  x86_64 1.7.0-cos7.build1705170314.17 @PLESK_17_5_3-dist  62 k
 psa-phpfpm-configurator
                  x86_64 1.0.0-cos7.build1705170314.17 @PLESK_17_5_3-dist 138

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

Installed size: 294 k
Is this ok [y/N]: n

i feel if i remove php-sql it may crash plesk panel how to fix this

 

[trialotto]

@stevemartin

You should not remove php-mysql, otherwise you will have (other) problems with the problematic site(s).

I am pretty sure that the issues in the website are code related, in the sense that you should do a search for bad or deprecated code.

And this bad or deprecated code is certain to cause new problems in the near future, so the problematic site(s) should be updated to support PHP versions 5.6 or higher.

It is not recommended to update to PHP version 5.6.x, due to the fact that this version is deprecated to a (very) large degree.

It is highly recommended to update to PHP version 7.x, to allow for future PHP version upgrade compatibility.

Hope the above helps.....

Regards...

PS Note that all Plesk packages and PHP sources are already containing the MySQL Native Driver (as a replacement for the original MySQL Client Library), as of PHP 5.3.0.