PHP MySQL library version

Support for webhosts that use CentOS
khaled_jamal
Posts: 12
Joined: 2011/09/30 12:59:53

PHP MySQL library version

Post by khaled_jamal » 2011/09/30 13:04:37

Hello,

I updated to php 5.3.8 but after updating the phpmyadmin shows this error msg "Your PHP MySQL library version 5.0.90 differs from your MySQL server version 5.1.59. This may cause unpredictable behavior."

how can i update PHP MySQL library to version 5.1.59 ?


Thanks in advance

User avatar
TrevorH
Forum Moderator
Posts: 27384
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: PHP MySQL library version

Post by TrevorH » 2011/09/30 19:04:19

This is what happens when you mix'n'match different RPMs from different repositories. You need to install all packages that depend on each other from the same repo. It also indicates that you do not have yum-protectbase and/or yum-priorities installed and correctly configured to prevent problems like this from happening.

khaled_jamal
Posts: 12
Joined: 2011/09/30 12:59:53

Re: PHP MySQL library version

Post by khaled_jamal » 2011/09/30 19:07:42

well yeah that was what i did and i did it using putty. where can i get repo with the same versions so i don't mix it like this ?

pschaff
Retired Moderator
Posts: 18276
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America
Contact:

PHP MySQL library version

Post by pschaff » 2011/10/01 14:18:57

Welcome to the CentOS fora. Please see the recommended reading for new users linked in my signature.

Hard to say when you have not revealed what repo[s] you are using. Please [url=http://www.centos.org/modules/newbb/viewtopic.php?topic_id=28723&forum=54]provide more information about your system[/url] by running "./getinfo.sh package" and showing us the output file. Also, what does[code]rpm -qa php\*[/code]show?

khaled_jamal
Posts: 12
Joined: 2011/09/30 12:59:53

Re: PHP MySQL library version

Post by khaled_jamal » 2011/10/01 16:41:29

Here is what i get:


# rpm -qa php\*
php-pdo-5.3.8-1.el5.art
php-mbstring-5.3.8-1.el5.art
php-devel-5.3.8-1.el5.art
php-mysql-5.3.8-1.el5.art
php-common-5.3.8-1.el5.art
php-cli-5.3.8-1.el5.art
php-xml-5.3.8-1.el5.art
php-imap-5.3.8-1.el5.art
php-5.3.8-1.el5.art
php-gd-5.3.8-1.el5.art
php-ioncube-loader-4.0.5-1.el5.art




Information for general problems.
[code]
== BEGIN uname -rmi ==
2.6.18-274.3.1.el5 i686 i386
== END uname -rmi ==

== BEGIN rpm -qa \*-release\* ==
remi-release-5-8.el5.remi
atomic-release-1.0-13.el5.art
webtatic-release-5-2
epel-release-5-4
centos-release-notes-5.7-0
centos-release-5-7.el5.centos
== END rpm -qa \*-release\* ==

== BEGIN cat /etc/redhat-release ==
CentOS release 5.7 (Final)
== END cat /etc/redhat-release ==

== BEGIN getenforce ==
Disabled
== END getenforce ==

== BEGIN free -m ==
total used free shared buffers cached
Mem: 3032 549 2483 0 8 323
-/+ buffers/cache: 216 2816
Swap: 8189 0 8189
== END free -m ==

== BEGIN rpm -q yum rpm python ==
yum-3.2.22-37.el5.centos
rpm-4.4.2.3-22.el5
python-2.4.3-44.el5_7.1
== END rpm -q yum rpm python ==

== BEGIN ls /etc/yum.repos.d ==
atomic.repo
CentOS-Base.repo
CentOS-Debuginfo.repo
CentOS-Media.repo
CentOS-Vault.repo
epel.repo
epel-testing.repo
remi.repo
webtatic.repo
== END ls /etc/yum.repos.d ==

== BEGIN cat /etc/yum.conf ==
[main]
cachedir=/var/cache/yum
keepcache=0
debuglevel=2
logfile=/var/log/yum.log
distroverpkg=redhat-release
tolerant=1
exactarch=1
obsoletes=1
gpgcheck=1
plugins=1
bugtracker_url=http://bugs.centos.org/set_project.php?project_id=16&ref=http://bugs.centos.org/bug_report_page.php?category=yum

# Note: yum-RHN-plugin doesn't honor this.
metadata_expire=1h

installonly_limit = 5

# PUT YOUR REPOS HERE OR IN separate files named file.repo
# in /etc/yum.repos.d
== END cat /etc/yum.conf ==

== BEGIN yum repolist all ==
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* atomic: www7.atomicorp.com
* base: ftp.uni-bayreuth.de
* epel: ftp.uni-koeln.de
* extras: ftp.uni-bayreuth.de
* updates: ftp.uni-bayreuth.de
repo id repo name status
C5.0-base CentOS-5.0 - Base disabled
C5.0-centosplus CentOS-5.0 - Plus disabled
C5.0-extras CentOS-5.0 - Extras disabled
C5.0-updates CentOS-5.0 - Updates disabled
C5.1-base CentOS-5.1 - Base disabled
C5.1-centosplus CentOS-5.1 - Plus disabled
C5.1-extras CentOS-5.1 - Extras disabled
C5.1-updates CentOS-5.1 - Updates disabled
C5.2-base CentOS-5.2 - Base disabled
C5.2-centosplus CentOS-5.2 - Plus disabled
C5.2-extras CentOS-5.2 - Extras disabled
C5.2-updates CentOS-5.2 - Updates disabled
C5.3-base CentOS-5.3 - Base disabled
C5.3-centosplus CentOS-5.3 - Plus disabled
C5.3-extras CentOS-5.3 - Extras disabled
C5.3-updates CentOS-5.3 - Updates disabled
C5.4-base CentOS-5.4 - Base disabled
C5.4-centosplus CentOS-5.4 - Plus disabled
C5.4-extras CentOS-5.4 - Extras disabled
C5.4-updates CentOS-5.4 - Updates disabled
C5.5-base CentOS-5.5 - Base disabled
C5.5-centosplus CentOS-5.5 - Plus disabled
C5.5-extras CentOS-5.5 - Extras disabled
C5.5-updates CentOS-5.5 - Updates disabled
C5.6-base CentOS-5.6 - Base disabled
C5.6-centosplus CentOS-5.6 - Plus disabled
C5.6-extras CentOS-5.6 - Extras disabled
C5.6-updates CentOS-5.6 - Updates disabled
atomic CentOS / Red Hat Enterprise Linux 5 - atom enabled: 991
atomic-testing CentOS / Red Hat Enterprise Linux 5 - atom disabled
base CentOS-5 - Base enabled: 2,705
c5-media CentOS-5 - Media disabled
centosplus CentOS-5 - Plus disabled
contrib CentOS-5 - Contrib disabled
debug CentOS-5 - Debuginfo disabled
epel Extra Packages for Enterprise Linux 5 - i3 enabled: 5,458
epel-debuginfo Extra Packages for Enterprise Linux 5 - i3 disabled
epel-source Extra Packages for Enterprise Linux 5 - i3 disabled
epel-testing Extra Packages for Enterprise Linux 5 - Te disabled
epel-testing-debuginfo Extra Packages for Enterprise Linux 5 - Te disabled
epel-testing-source Extra Packages for Enterprise Linux 5 - Te disabled
extras CentOS-5 - Extras enabled: 251
remi Les RPM de remi pour Enterprise Linux 5 - disabled
remi-test Les RPM de remi en test pour Enterprise Li disabled
updates CentOS-5 - Updates enabled: 164
webtatic Webtatic Repository 5 - i386 disabled
webtatic-debuginfo Webtatic Repository 5 - i386 - Debug disabled
webtatic-source Webtatic Repository 5 - i386 disabled
repolist: 9,569
== END yum repolist all ==

== BEGIN egrep 'include|exclude' /etc/yum.repos.d/*.repo ==
== END egrep 'include|exclude' /etc/yum.repos.d/*.repo ==

== BEGIN sed -n -e "/^\[/h; /priority *=/{ G; s/\n/ /; s/ity=/ity = /; p }" /etc/yum.repos.d/*.repo | sort -k3n ==
priority = 1 [atomic]
#priority = 1 [atomic-testing]
priority = 1 [atomic-testing]
== END sed -n -e "/^\[/h; /priority *=/{ G; s/\n/ /; s/ity=/ity = /; p }" /etc/yum.repos.d/*.repo | sort -k3n ==

== BEGIN cat /etc/fstab ==
LABEL=/ / ext3 defaults 1 1
LABEL=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
LABEL=SWAP-sda2 swap swap defaults 0 0
== END cat /etc/fstab ==

== BEGIN df -h ==
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 444G 239G 182G 57% /
/dev/sda1 99M 22M 72M 24% /boot
tmpfs 1.5G 0 1.5G 0% /dev/shm
tmpfs 1.5G 0 1.5G 0% /usr/local/psa/handlers/before-local
tmpfs 1.5G 0 1.5G 0% /usr/local/psa/handlers/before-queue
tmpfs 1.5G 0 1.5G 0% /usr/local/psa/handlers/before-remote
tmpfs 1.5G 156K 1.5G 1% /usr/local/psa/handlers/info
tmpfs 1.5G 0 1.5G 0% /usr/local/psa/handlers/spool
== END df -h ==

== BEGIN fdisk -l ==

Disk /dev/sda: 500.1 GB, 500107862016 bytes
255 heads, 63 sectors/track, 60801 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sda1 * 1 13 104391 83 Linux
/dev/sda2 14 1057 8385930 82 Linux swap / Solaris
/dev/sda3 1058 60801 479893680 83 Linux
== END fdisk -l ==

== BEGIN blkid ==
/dev/sda3: LABEL="/" UUID="55316087-6d68-4427-9324-1a7cb5e4cb74" TYPE="ext3"
/dev/sda2: LABEL="SWAP-sda2" TYPE="swap"
/dev/sda1: LABEL="/boot" UUID="de8b691e-1085-429a-963e-faa1e00ce0a5" TYPE="ext3"
== END blkid ==

== BEGIN cat /proc/mdstat ==
Personalities :
unused devices: <none>
== END cat /proc/mdstat ==

== BEGIN pvs ==
== END pvs ==

== BEGIN vgs ==
No volume groups found
== END vgs ==

== BEGIN lvs ==
No volume groups found
== END lvs ==

== BEGIN rpm -qa kernel\* | sort ==
kernel-2.6.18-128.1.16.el5
kernel-2.6.18-194.26.1.el5
kernel-2.6.18-274.3.1.el5
== END rpm -qa kernel\* | sort ==

== BEGIN lspci ==
00:00.0 Host bridge: Intel Corporation 82G33/G31/P35/P31 Express DRAM Controller (rev 02)
00:02.0 VGA compatible controller: Intel Corporation 82G33/G31 Express Integrated Graphics Controller (rev 02)
00:1a.0 USB Controller: Intel Corporation 82801I (ICH9 Family) USB UHCI Controller #4 (rev 02)
00:1a.1 USB Controller: Intel Corporation 82801I (ICH9 Family) USB UHCI Controller #5 (rev 02)
00:1a.2 USB Controller: Intel Corporation 82801I (ICH9 Family) USB UHCI Controller #6 (rev 02)
00:1a.7 USB Controller: Intel Corporation 82801I (ICH9 Family) USB2 EHCI Controller #2 (rev 02)
00:1c.0 PCI bridge: Intel Corporation 82801I (ICH9 Family) PCI Express Port 1 (rev 02)
00:1c.4 PCI bridge: Intel Corporation 82801I (ICH9 Family) PCI Express Port 5 (rev 02)
00:1d.0 USB Controller: Intel Corporation 82801I (ICH9 Family) USB UHCI Controller #1 (rev 02)
00:1d.1 USB Controller: Intel Corporation 82801I (ICH9 Family) USB UHCI Controller #2 (rev 02)
00:1d.2 USB Controller: Intel Corporation 82801I (ICH9 Family) USB UHCI Controller #3 (rev 02)
00:1d.7 USB Controller: Intel Corporation 82801I (ICH9 Family) USB2 EHCI Controller #1 (rev 02)
00:1e.0 PCI bridge: Intel Corporation 82801 PCI Bridge (rev 92)
00:1f.0 ISA bridge: Intel Corporation 82801IB (ICH9) LPC Interface Controller (rev 02)
00:1f.2 SATA controller: Intel Corporation 82801IB (ICH9) 4 port SATA AHCI Controller (rev 02)
00:1f.3 SMBus: Intel Corporation 82801I (ICH9 Family) SMBus Controller (rev 02)
03:00.0 Ethernet controller: Intel Corporation 82557/8/9/0/1 Ethernet Pro 100 (rev 08)
== END lspci ==

== BEGIN lspci -n ==
00:00.0 0600: 8086:29c0 (rev 02)
00:02.0 0300: 8086:29c2 (rev 02)
00:1a.0 0c03: 8086:2937 (rev 02)
00:1a.1 0c03: 8086:2938 (rev 02)
00:1a.2 0c03: 8086:2939 (rev 02)
00:1a.7 0c03: 8086:293c (rev 02)
00:1c.0 0604: 8086:2940 (rev 02)
00:1c.4 0604: 8086:2948 (rev 02)
00:1d.0 0c03: 8086:2934 (rev 02)
00:1d.1 0c03: 8086:2935 (rev 02)
00:1d.2 0c03: 8086:2936 (rev 02)
00:1d.7 0c03: 8086:293a (rev 02)
00:1e.0 0604: 8086:244e (rev 92)
00:1f.0 0601: 8086:2918 (rev 02)
00:1f.2 0106: 8086:2923 (rev 02)
00:1f.3 0c05: 8086:2930 (rev 02)
03:00.0 0200: 8086:1229 (rev 08)
== END lspci -n ==

== BEGIN lsusb ==
Bus 001 Device 001: ID 0000:0000
Bus 008 Device 001: ID 0000:0000
Bus 006 Device 001: ID 0000:0000
Bus 003 Device 001: ID 0000:0000
Bus 002 Device 001: ID 0000:0000
Bus 004 Device 001: ID 0000:0000
Bus 005 Device 001: ID 0000:0000
Bus 007 Device 001: ID 0000:0000
== END lsusb ==



== BEGIN grep net /etc/nsswitch.conf ==
#networks: nisplus [NOTFOUND=return] files
#netmasks: nisplus [NOTFOUND=return] files
netmasks: files
networks: files
netgroup: nisplus
== END grep net /etc/nsswitch.conf ==

== BEGIN chkconfig --list | grep -Ei 'network|wpa' ==
NetworkManager 0:off 1:off 2:off 3:off 4:off 5:off 6:off
network 0:off 1:off 2:on 3:on 4:on 5:on 6:off
wpa_supplicant 0:off 1:off 2:off 3:off 4:off 5:off 6:off
== END chkconfig --list | grep -Ei 'network|wpa' ==

[/code]

pschaff
Retired Moderator
Posts: 18276
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America
Contact:

Re: PHP MySQL library version

Post by pschaff » 2011/10/01 19:26:28

Well, that's a superset of the "./getinfo.sh [b]package[/b]" output requested.

You have multiple conflicting 3rd party repos configured and are using php packages from the aggressive Atomic repo that overwrites many core packages and wants to keep enabling itself. You have [atomic] and [atomic-testing] defined at priority=1 so that if the [url=http://wiki.centos.org/PackageManagement/Yum/Priorities]yum priorities plugin[/url] were actually installed (which it is not) it would override anything else.

The good news is that Atomic has php-mysql-5.3.8-1.el5.art that will presumably work with their mysql packages, as you can see by[code]yum --showduplicates --disablerepo \* --enablerepo atomic\* list \*mysql\*[/code]

As you have already gone with Atomic you may just want to go along further and "yum install yum-priorities" to allow them to dominate your package world.

Any other approach could probably best be achieved by a fresh install and careful consideration of 3rd party repo configuration.

khaled_jamal
Posts: 12
Joined: 2011/09/30 12:59:53

Re: PHP MySQL library version

Post by khaled_jamal » 2011/10/02 14:09:14

I will try it out and see if the server gets more stable! thanks for ur help ! i will let u know if it works :D

khaled_jamal
Posts: 12
Joined: 2011/09/30 12:59:53

Re: PHP MySQL library version

Post by khaled_jamal » 2011/10/03 14:04:18

i still get this error "Your PHP MySQL library version 5.0.90 differs from your MySQL server version 5.1.59" and the "too Many connections " error and the apache CPU usage is very high :/

User avatar
TrevorH
Forum Moderator
Posts: 27384
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: PHP MySQL library version

Post by TrevorH » 2011/10/03 15:01:02

Post the output from

[code]
rpm -qa --qf '%{name}-%{version}.%{release}.%{arch}\n' php\* mysql\* | sort
[/code]

khaled_jamal
Posts: 12
Joined: 2011/09/30 12:59:53

Re: PHP MySQL library version

Post by khaled_jamal » 2011/10/03 15:02:13

mysql-5.1.59.1.el5.art.i386
mysqlclient15-5.0.90.1.el5.art.i386
mysql-connector-odbc-3.51.26r1127.1.el5.i386
mysql-libs-5.1.59.1.el5.art.i386
mysql-server-5.1.59.1.el5.art.i386
php-5.3.8.1.el5.art.i386
php-cli-5.3.8.1.el5.art.i386
php-common-5.3.8.1.el5.art.i386
php-devel-5.3.8.1.el5.art.i386
php-gd-5.3.8.1.el5.art.i386
php-imap-5.3.8.1.el5.art.i386
php-ioncube-loader-4.0.5.1.el5.art.i386
php-mbstring-5.3.8.1.el5.art.i386
php-mysql-5.3.8.1.el5.art.i386
php-pdo-5.3.8.1.el5.art.i386
php-xml-5.3.8.1.el5.art.i386

Post Reply

Return to “CentOS 5 - Webhosting Support”