PHP MySQL library version 5.1.54 differs from your MySQL ser

Issues related to applications and software problems
User avatar
TrevorH
Site Admin
Posts: 33202
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: PHP MySQL library version 5.1.54 differs from your MySQL

Post by TrevorH » 2015/03/26 22:52:52

You have a large mess of conflicting yum repositories defined and they will blow up and bite you one day! Of the ones there that supply php and mysql packages you have remi, rpmforge, webtatic. I have no idea what isv_ownCloud_community or mod-pagespeed are.

Your current package seems to come from the remi repository. He also supplies phpMyAdmin afaik and you should probably be using his version if you are using his other packages. However with all your current repos it is difficult to tell what comes from where. If you don't have yum-plugin-priorities defined and set up for all your repos then which one is used in preference to another is probably a matter of chance!
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

gerald_clark
Posts: 10642
Joined: 2005/08/05 15:19:54
Location: Northern Illinois, USA

Re: PHP MySQL library version 5.1.54 differs from your MySQL

Post by gerald_clark » 2015/03/26 22:56:15

You have multiple incompatible repos installed.
Some of these replace base packagfes.
You also have CentOS 5 repos installed.

Your mysql server is from remi, so you should also use remi's mysql libraries.

Why not just start over from scratch and stick to the stock repos?

czarekplpl
Posts: 53
Joined: 2014/08/23 07:57:52

Re: PHP MySQL library version 5.1.54 differs from your MySQL

Post by czarekplpl » 2015/03/27 13:56:11

Hello.
I have not experience. I used many different tutorials and this is probably case of the repos mess.
Could you please tell me how to change the mysql libraries and phpMyAdmin for remi repo?

czarekplpl
Posts: 53
Joined: 2014/08/23 07:57:52

Re: PHP MySQL library version 5.1.54 differs from your MySQL

Post by czarekplpl » 2015/03/28 02:45:40

Hello.
Is the possible to clean this mess by using yum-plugin-priorities?
How should I set priorities?
Any suggestions??

Code: Select all

[root@kukuniek ~]# yum repolist all
Loaded plugins: fastestmirror, priorities, replace
Loading mirror speeds from cached hostfile
Could not get metalink https://mirrors.fedoraproject.org/metalink?repo=epel-6&arch=x86_64 error was
14: PYCURL ERROR 6 - "Couldn't resolve host 'mirrors.fedoraproject.org'"
 * base: mirrors.zju.edu.cn
 * epel: mirrors.zju.edu.cn
 * extras: mirrors.skyshe.cn
 * remi: rpms.famillecollet.com
 * rpmforge: ftp.neowiz.com
 * updates: mirrors.zju.edu.cn
 * webtatic: uk.repo.webtatic.com
 * webtatic-debuginfo: uk.repo.webtatic.com
 * webtatic-source: uk.repo.webtatic.com
base                                                     | 3.7 kB     00:00
extras                                                   | 3.4 kB     00:00
isv_ownCloud_community                                   | 1.2 kB     00:00
mod-pagespeed                                            |  951 B     00:00
remi                                                     | 2.9 kB     00:00
remi/primary_db                                          | 1.1 MB     00:04
rpmforge                                                 | 1.9 kB     00:00
http://mirror.centos.org/centos/6/SCL/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 6 - "Couldn't resolve host 'mirror.centos.org'"
Trying other mirror.
updates                                                  | 3.4 kB     00:00
http://uk.repo.webtatic.com/yum/el6/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 7 - "Failed to connect to 2a03:b0c0:1:d0::2aa:6001: Network is unreachable"
Trying other mirror.
webtatic                                                 | 3.6 kB     00:00
webtatic-archive                                         | 2.9 kB     00:00
webtatic-archive-debuginfo                               | 2.9 kB     00:00
webtatic-archive-source                                  | 2.9 kB     00:00
webtatic-debuginfo                                       | 3.6 kB     00:00
webtatic-source                                          | 2.9 kB     00:00
repo id                                  repo name          status
C6.0-base                                CentOS-6.0 - Base  disabled
C6.0-centosplus                          CentOS-6.0 - CentO disabled
C6.0-contrib                             CentOS-6.0 - Contr disabled
C6.0-extras                              CentOS-6.0 - Extra disabled
C6.0-updates                             CentOS-6.0 - Updat disabled
C6.1-base                                CentOS-6.1 - Base  disabled
C6.1-centosplus                          CentOS-6.1 - CentO disabled
C6.1-contrib                             CentOS-6.1 - Contr disabled
C6.1-extras                              CentOS-6.1 - Extra disabled
C6.1-updates                             CentOS-6.1 - Updat disabled
C6.2-base                                CentOS-6.2 - Base  disabled
C6.2-centosplus                          CentOS-6.2 - CentO disabled
C6.2-contrib                             CentOS-6.2 - Contr disabled
C6.2-extras                              CentOS-6.2 - Extra disabled
C6.2-updates                             CentOS-6.2 - Updat disabled
C6.3-base                                CentOS-6.3 - Base  disabled
C6.3-centosplus                          CentOS-6.3 - CentO disabled
C6.3-contrib                             CentOS-6.3 - Contr disabled
C6.3-extras                              CentOS-6.3 - Extra disabled
C6.3-updates                             CentOS-6.3 - Updat disabled
C6.4-base                                CentOS-6.4 - Base  disabled
C6.4-centosplus                          CentOS-6.4 - CentO disabled
C6.4-contrib                             CentOS-6.4 - Contr disabled
C6.4-extras                              CentOS-6.4 - Extra disabled
C6.4-updates                             CentOS-6.4 - Updat disabled
C6.5-base                                CentOS-6.5 - Base  disabled
C6.5-centosplus                          CentOS-6.5 - CentO disabled
C6.5-contrib                             CentOS-6.5 - Contr disabled
C6.5-extras                              CentOS-6.5 - Extra disabled
C6.5-updates                             CentOS-6.5 - Updat disabled
atomic                                   CentOS / Red Hat E disabled
atomic-testing                           CentOS / Red Hat E disabled
base                                     CentOS-6 - Base    enabled: 4,992+1,526
base-debuginfo                           CentOS-6 - Debugin disabled
c5-testing                               CentOS-5 Testing   disabled
c6-media                                 CentOS-6 - Media   disabled
centosplus                               CentOS-6 - Plus    disabled
contrib                                  CentOS-6 - Contrib disabled
epel                                     Extra Packages for enabled: 9,307+2,034
epel-debuginfo                           Extra Packages for disabled
epel-source                              Extra Packages for disabled
epel-testing                             Extra Packages for disabled
epel-testing-debuginfo                   Extra Packages for disabled
epel-testing-source                      Extra Packages for disabled
extras                                   CentOS-6 - Extras  enabled:          37
fasttrack                                CentOS-6 - fasttra disabled
isv_ownCloud_community                   Latest stable comm enabled:        25+1
mod-pagespeed                            mod-pagespeed      enabled:          43
mondorescue                              rhel 6 x86_64 - mo disabled
remi                                     Les RPM de remi po enabled:       2,464
remi-debuginfo                           Les RPM de remi po disabled
remi-php55                               Les RPM de remi de disabled
remi-php55-debuginfo                     Les RPM de remi de disabled
remi-php56                               Les RPM de remi de disabled
remi-php56-debuginfo                     Les RPM de remi de disabled
remi-test                                Les RPM de remi en disabled
remi-test-debuginfo                      Les RPM de remi en disabled
rpmforge                                 RHEL 6 - RPMforge. enabled:       4,718
rpmforge-extras                          RHEL 6 - RPMforge. disabled
rpmforge-testing                         RHEL 6 - RPMforge. disabled
rpmfusion-free-updates                   RPM Fusion for EL  disabled
rpmfusion-free-updates-debuginfo         RPM Fusion for EL  disabled
rpmfusion-free-updates-source            RPM Fusion for EL  disabled
rpmfusion-free-updates-testing           RPM Fusion for EL  disabled
rpmfusion-free-updates-testing-debuginfo RPM Fusion for EL  disabled
rpmfusion-free-updates-testing-source    RPM Fusion for EL  disabled
scl                                      CentOS-6 - SCL     enabled:         676
updates                                  CentOS-6 - Updates enabled:     700+201
webtatic                                 Webtatic Repositor enabled:         372
webtatic-archive                         Webtatic Repositor enabled:       2,194
webtatic-archive-debuginfo               Webtatic Repositor enabled:         129
webtatic-archive-source                  Webtatic Repositor enabled:           0
webtatic-debuginfo                       Webtatic Repositor enabled:          54
webtatic-source                          Webtatic Repositor enabled:           0
webtatic-testing                         Webtatic Repositor disabled
webtatic-testing-debuginfo               Webtatic Repositor disabled
webtatic-testing-source                  Webtatic Repositor disabled
repolist: 25,711
[root@kukuniek ~]#

User avatar
remirepo
Posts: 447
Joined: 2014/09/21 09:07:12
Location: France
Contact:

Re: PHP MySQL library version 5.1.54 differs from your MySQL

Post by remirepo » 2015/03/28 06:03:36

About the initial question, (PHP MySQL library version xxx differs from your MySQL server yyyy)

This is only a warning and AFAIK have never raised any issue.
It is very common to use phpMyAdmin on a server to manage various MySQL servers running various versions.

I think you should replace php-mysql (which is deprecated, and have be dropped in php 5.5+ packages) with php-mysqnld (which provides the same extensions). This will also make this warning disappear.

Remi.
Last edited by remirepo on 2015/03/28 11:47:11, edited 1 time in total.
Remi's Repository - Forum - Blog

czarekplpl
Posts: 53
Joined: 2014/08/23 07:57:52

Re: PHP MySQL library version 5.1.54 differs from your MySQL

Post by czarekplpl » 2015/03/28 09:17:29

I have no idea what isv_ownCloud_community or mod-pagespeed are
Owncloud is same as Dropbox but on my own server. Btw. works very well.
Mod-pagespeed improving a web page’s loading speed.

Another problem is this in phpMyAdmin:

Code: Select all

$cfg['Servers'][$i]['central_columns'] ... 
not OK 
Managing Central list of columns: Disabled 
What can I do with this??

I found this tutorial: http://blog.keepmind.eu/aktualizacja-ph ... tos-6.html

Code: Select all

wget http://dl.iuscommunity.org/pub/ius/stable/CentOS/6/x86_64/epel-release-6-5.noarch.rpm
wget http://dl.iuscommunity.org/pub/ius/stable/CentOS/6/x86_64/ius-release-1.0-13.ius.centos6.noarch.rpm
rpm -Uvh epel-release-6-5.noarch.rpm
rpm -Uvh ius-release-1.0-13.ius.centos6.noarch.rpm
yum clean all
yum update


yum list | grep -w \.ius\.


yum install yum-plugin-replace #niezbędne do podmienienia paczek z innych repozytoriów
rpm -qa | grep php
yum replace php --replace-with php55u
rpm -qa | grep mysql
yum replace mysql --replace-with mysql56u
Restart server httpd/PHP and MySQL

service httpd restart
service mysqld restart
Could it help with my issues???

Post Reply