• Registered: 2009-12-07
  • Posts: 4

Topic: Conflicts between MySQL libraries and MySQL client 16

Hello,

I'm running CentOS 5.3 and I've tried to intall mysqlclient16 from the remi-test repository, but I got the following errors:

Transaction Check Error:
  file /usr/lib/mysql/libmysqlclient.so.16.0.0 from install of mysqlclient16-5.1.30-1.el5.remi.i386 conflicts with file from package mysql-libs-5.1.41-1.el5.remi.i386
  file /usr/lib/mysql/libmysqlclient_r.so.16.0.0 from install of mysqlclient16-5.1.30-1.el5.remi.i386 conflicts with file from package mysql-libs-5.1.41-1.el5.remi.i386

Error Summary
-------------

The new version of the MySQL client was needed because phpMyAdmin warned me that library version 5.0.67 is not equal than the server's version (5.1.41).

How can I fix this?

Thanks in advance

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,834

Re: Conflicts between MySQL libraries and MySQL client 16

mysqlclient16 provides client library 5.1 when you want to stay with mysql 5.0 (server)

If you have upgrade to 5.1, you already have the 5.1 client.

phpMyAdmin warn you (and it's only a warning, I never encounter any issue with this) because the PHP version (and php-mysql) is not build against the 5.1 client library : and old php 5.1 or 5.2. Just update your PHP.

To be clear, you could use :

  • php-5.1 + mysqlclient15 + mysql-5.1

  • php-5.3 + mysqlclient16 + mysql-5.0

  • php-5.3 + mysql-5.1

+

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

Remi's Website

  • Registered: 2009-12-07
  • Posts: 4

Re: Conflicts between MySQL libraries and MySQL client 16

Hi,

Thanks for your reply, but I don't understand it.

I have installed the following:

PHP 5.2.11, MySQL libraries 5.1.41 and MySQL client 5.0.67. What's wrong? How can I avoid the warning message in phpMyAdmin (version 3.2.4)? How can I have the MySQL client 5.1.41 (compatible with MySQL libraries)?

Thanks and and excuse for my ignorance.

  • Registered: 2009-12-07
  • Posts: 4

Re: Conflicts between MySQL libraries and MySQL client 16

Remi, can you reply to my last post, please? sad

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,834

Re: Conflicts between MySQL libraries and MySQL client 16

Don't know where your PHP comes from, but not from my repo.

If phpMyAdmin reports this warning, it's because php-mysql don't use le 5.1 lib.

+

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

Remi's Website

  • Registered: 2009-12-07
  • Posts: 4

Re: Conflicts between MySQL libraries and MySQL client 16

Ok, PHP came from another repository, Webtatic. What do you advice me? I think it's wrong to have the MySQL lib version different from the client version. If I uninstall the client version (mysqlclient15), will the client program (MySQL command line) continue to be installed?

Thanks again

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,834

Re: Conflicts between MySQL libraries and MySQL client 16

If you use PHP RPM from webtatic, please ask webtatic.

+

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

Remi's Website