PHP MySQL library version

Support for webhosts that use CentOS

PHP MySQL library version

Postby 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
khaled_jamal
 
Posts: 12
Joined: 2011/09/30 12:59:53

Re: PHP MySQL library version

Postby 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.
User avatar
TrevorH
Forum Moderator
 
Posts: 9082
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: PHP MySQL library version

Postby 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 ?
khaled_jamal
 
Posts: 12
Joined: 2011/09/30 12:59:53

PHP MySQL library version

Postby 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 provide more information about your system by running "./getinfo.sh package" and showing us the output file. Also, what does
Code: Select all
rpm -qa php\*
show?
pschaff
Retired Moderator
 
Posts: 18277
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America

Re: PHP MySQL library version

Postby 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: Select all
== 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' ==

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

Re: PHP MySQL library version

Postby pschaff » 2011/10/01 19:26:28

Well, that's a superset of the "./getinfo.sh package" 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 yum priorities plugin 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: Select all
yum --showduplicates --disablerepo \* --enablerepo atomic\* list \*mysql\*


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.
pschaff
Retired Moderator
 
Posts: 18277
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America

Re: PHP MySQL library version

Postby 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

Postby 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 :/
khaled_jamal
 
Posts: 12
Joined: 2011/09/30 12:59:53

Re: PHP MySQL library version

Postby TrevorH » 2011/10/03 15:01:02

Post the output from

Code: Select all
rpm -qa --qf '%{name}-%{version}.%{release}.%{arch}\n' php\* mysql\* | sort
User avatar
TrevorH
Forum Moderator
 
Posts: 9082
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: PHP MySQL library version

Postby 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
khaled_jamal
 
Posts: 12
Joined: 2011/09/30 12:59:53

Next

Return to CentOS 5 - Webhosting Support

Who is online

Users browsing this forum: No registered users and 0 guests