PHP 5.3 requires MySQL 5.1?

Support/Development for PHP
breun
Long Time Forum Regular
Long Time Forum Regular
Posts: 2813
Joined: Sat Aug 20, 2005 9:30 am
Location: The Netherlands

PHP 5.3 requires MySQL 5.1?

Unread post by breun »

The situation: a CentOS 5.6 x86_64 server with stock MySQL server 5.0.77 installed and MySQL packages excluded in /etc/yum.repos.d/atomic.repo. PHP is currently 5.2.17. Trying to upgrade to PHP 5.3.6 yum can't resolve php-mysql's dependency on libmysqlclient.so.16:
--> Running transaction check
---> Package php.x86_64 0:5.3.6-3.el5.art set to be updated
---> Package php-cli.x86_64 0:5.3.6-3.el5.art set to be updated
--> Processing Dependency: libedit.so.0()(64bit) for package: php-cli
---> Package php-common.x86_64 0:5.3.6-3.el5.art set to be updated
---> Package php-devel.x86_64 0:5.3.6-3.el5.art set to be updated
---> Package php-eaccelerator.x86_64 1:5.3.6_0.9.6.1-1.el5.art set to be updated
---> Package php-gd.x86_64 0:5.3.6-3.el5.art set to be updated
---> Package php-imap.x86_64 0:5.3.6-3.el5.art set to be updated
---> Package php-mbstring.x86_64 0:5.3.6-3.el5.art set to be updated
---> Package php-mcrypt.x86_64 0:5.3.6-3.el5.art set to be updated
---> Package php-mysql.x86_64 0:5.3.6-3.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.3.6-3.el5.art set to be updated
---> Package php-soap.x86_64 0:5.3.6-3.el5.art set to be updated
---> Package php-xml.x86_64 0:5.3.6-3.el5.art set to be updated
--> Running transaction check
---> Package libedit.x86_64 0:3.0-2.20090923cvs.el5.art set to be updated
---> Package php-mysql.x86_64 0:5.3.6-3.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
--> Finished Dependency Resolution
php-mysql-5.3.6-3.el5.art.x86_64 from atomic has depsolving problems
--> Missing Dependency: libmysqlclient.so.16()(64bit) is needed by package php-mysql-5.3.6-3.el5.art.x86_64 (atomic)
php-mysql-5.3.6-3.el5.art.x86_64 from atomic has depsolving problems
--> Missing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by package php-mysql-5.3.6-3.el5.art.x86_64 (atomic)
Error: Missing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by package php-mysql-5.3.6-3.el5.art.x86_64 (atomic)
Error: Missing Dependency: libmysqlclient.so.16()(64bit) is needed by package php-mysql-5.3.6-3.el5.art.x86_64 (atomic)
AFAIK libmysqlclient.so.16 is part MySQL 5.1. Does PHP 5.3.6 really require libmysqlclient.so.16 and thus MySQL 5.1 or could php-mysql be built to work with MySQL 5.0's libmysqlclient.so.15?
Lemonbit Internet Dedicated Server Management
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Re: PHP 5.3 requires MySQL 5.1?

Unread post by scott »

Yes, there is a mysqlclient16 package that would resolve that. The problem is your exclude is blocking it.
breun
Long Time Forum Regular
Long Time Forum Regular
Posts: 2813
Joined: Sat Aug 20, 2005 9:30 am
Location: The Netherlands

Re: PHP 5.3 requires MySQL 5.1?

Unread post by breun »

Ah, got it, thanks.
Lemonbit Internet Dedicated Server Management
roadrash
New Forum User
New Forum User
Posts: 3
Joined: Wed Oct 12, 2011 4:06 pm
Location: Netherlands

Re: PHP 5.3 requires MySQL 5.1?

Unread post by roadrash »

Can you please pop-up a quick little howto what to do in this case?

I have MySQL 5.0.77 with PHP 5.1.6 on a stock CentOS / Plesk 9.5 installation.

And I need only PHP to upgrade to 5.2.17 or 5.3.*

I also have mysql* excluded in the atomic.repo

What do I need to do ??
breun
Long Time Forum Regular
Long Time Forum Regular
Posts: 2813
Joined: Sat Aug 20, 2005 9:30 am
Location: The Netherlands

Re: PHP 5.3 requires MySQL 5.1?

Unread post by breun »

Don't exclude mysql*, because that also excludes the mysqlclient16 package that you need. You might want to do something like exclude=mysql mysql-libs mysql-server instead.
Lemonbit Internet Dedicated Server Management
roadrash
New Forum User
New Forum User
Posts: 3
Joined: Wed Oct 12, 2011 4:06 pm
Location: Netherlands

Re: PHP 5.3 requires MySQL 5.1?

Unread post by roadrash »

Many thanks.
All works now. PHP upgraded to 5.3.8 and MySQL still 5.0.77
I only needed to replace exclude=mysql* with: exclude=mysql-*
to make sure that mysqlclient16 was not excluded.
lfenison
Forum User
Forum User
Posts: 29
Joined: Mon Jun 14, 2010 8:39 pm

Re: PHP 5.3 requires MySQL 5.1?

Unread post by lfenison »

I am having a similar problem and I do not have any excludes. I just want to update to the latest but, this error is stopping me. Any ideas?

Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.5.17-2.el5.art set to be updated
--> Processing Dependency: libmysqlclient.so.16 for package: php-mysql
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: php-mysql
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: ossec-hids-server
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: php-mysql
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: ossec-hids-server
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: php-mysql
---> Package mysql-libs.i386 0:5.5.17-2.el5.art set to be updated
---> Package mysql-libs.x86_64 0:5.5.17-2.el5.art set to be updated
---> Package mysql-server.x86_64 0:5.5.17-2.el5.art set to be updated
--> Running transaction check
--> Processing Dependency: libmysqlclient.so.16 for package: php-mysql
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: php-mysql
---> Package mysqlclient16.x86_64 0:5.1.59-1.el5.art set to be updated
--> Finished Dependency Resolution
php-mysql-5.3.8-1.el5.art.i386 from installed has depsolving problems
--> Missing Dependency: libmysqlclient.so.16(libmysqlclient_16) is needed by package php-mysql-5.3.8-1.el5.art.i386 (installed)
php-mysql-5.3.8-1.el5.art.i386 from installed has depsolving problems
--> Missing Dependency: libmysqlclient.so.16 is needed by package php-mysql-5.3.8-1.el5.art.i386 (installed)
Error: Missing Dependency: libmysqlclient.so.16(libmysqlclient_16) is needed by package php-mysql-5.3.8-1.el5.art.i386 (installed)
Error: Missing Dependency: libmysqlclient.so.16 is needed by package php-mysql-5.3.8-1.el5.art.i386 (installed)
Post Reply