My PHP MySQL library version differs from my MySQL server version

Issues related to applications and software problems
Post Reply
aegersz
Posts: 86
Joined: 2016/04/04 07:42:58

My PHP MySQL library version differs from my MySQL server version

Post by aegersz » 2017/07/07 07:26:57

I'm very recently running CentOS 6.9, MySQL 5.1.73 and PHP 5.6 ... unforunately phpmyadmin reports:

Your PHP MySQL library version mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ differs from your MySQL server version 5.1.73. This may cause unpredictable behavior.

I have been researching this and am not satisfied that i can solve this issue on my live site:

some diagnostics:

Code: Select all

[root@forum ~]# yum list installed | grep mysql
compat-mysql55.x86_64                   5.5.55-1.el6.remi            @remi-php54
dovecot-mysql.x86_64                    1:2.0.9-22.el6               @base
mysql.x86_64                            5.1.73-8.el6_8               @base
mysql-libs.x86_64                       5.1.73-8.el6_8               @base
mysql-server.x86_64                     5.1.73-8.el6_8               @base
php-mysqlnd.x86_64                      5.6.30-1.el6.remi            @remi-php56

Code: Select all

[root@dev ~]# rpm -qa mysql\*
mysql-5.1.73-8.el6_8.i686
mysql-libs-5.1.73-8.el6_8.i686
mysql-server-5.1.73-8.el6_8.i686

Code: Select all

[root@forum ~]# rpm -qa php\*
php-PsrLog-1.0.2-2.el6.noarch
php-pear-Log-1.12.7-1.el6.noarch
php-horde-Horde-Exception-2.0.8-1.el6.noarch
php-pear-Text-Figlet-1.0.2-1.el6.noarch
php-pear-XML-SVG-1.1.0-2.el6.noarch
php-pear-Net-IMAP-1.1.3-1.el6.noarch
php-horde-Horde-Http-2.1.7-1.el6.noarch
php-pear-HTTP-OAuth-0.2.2-1.el6.noarch
php-symfony-css-selector-2.3.42-1.el6.noarch
php-horde-Horde-Controller-2.0.3-1.el6.noarch
php-horde-Horde-Mime-2.10.3-1.el6.noarch
php-pecl-zip-1.14.0-1.el6.remi.5.6.x86_64
php-horde-Horde-JavascriptMinify-1.1.3-1.el6.noarch
php-devel-5.6.30-1.el6.remi.x86_64
php-horde-Horde-View-2.0.5-1.el6.noarch
php-mssql-5.6.30-1.el6.remi.x86_64
php-process-5.6.30-1.el6.remi.x86_64
php-pimple-lib-3.0.2-1.el6.remi.5.6.noarch
php-phpseclib-crypt-des-0.3.9-2.el6.noarch
php-horde-Horde-Pack-1.0.7-1.el6.noarch
php-horde-Horde-Token-2.0.9-1.el6.noarch
php-pear-Crypt-Blowfish-1.1.0-0.4.rc2.el6.noarch
php-pear-MDB2-2.5.0-0.9.b5.el6.noarch
php-horde-Horde-Notification-2.0.3-1.el6.noarch
php-phpseclib-crypt-base-0.3.9-1.el6.noarch
php-doctrine-cache-1.5.4-1.el6.noarch
php-fedora-autoloader-1.0.0-1.el6.noarch
php-pear-Net-URL2-0.3.1-2.el6.noarch
php-horde-Horde-Autoloader-2.1.2-1.el6.1.noarch
php-horde-Horde-Constraint-2.0.1-2.el6.noarch
php-pear-HTTP-Request-1.4.4-2.el6.noarch
php-doctrine-lexer-1.0.1-8.el6.noarch
php-phpseclib-crypt-blowfish-0.3.9-2.el6.noarch
php-horde-Horde-Mongo-1.0.2-1.el6.noarch
php-symfony-yaml-2.3.42-1.el6.noarch
php-horde-Horde-Ldap-2.4.0-1.el6.noarch
php-symfony-dependency-injection-2.3.42-1.el6.noarch
php-symfony-routing-2.3.42-1.el6.noarch
php-horde-Horde-Crypt-2.7.8-1.el6.noarch
php-cli-5.6.30-1.el6.remi.x86_64
php-horde-Horde-ElasticSearch-1.0.2-1.el6.noarch
php-xmlrpc-5.6.30-1.el6.remi.x86_64
php-horde-Horde-Stringprep-1.0.3-1.el6.noarch
php-pecl-lzf-1.6.6-1.el6.remi.5.6.x86_64
php-imap-5.6.30-1.el6.remi.x86_64
php-horde-Horde-Db-2.4.0-1.el6.noarch
php-horde-Horde-Kolab-Server-2.0.4-1.el6.noarch
php-channel-dropbox-php-1.3-3.el6.noarch
php-horde-Horde-Dav-1.1.4-1.el6.noarch
php-doctrine-collections-1.3.0-2.el6.noarch
php-phpass-0.3-2.el6.noarch
php-symfony-http-foundation-2.3.42-1.el6.noarch
php-pecl-jsonc-1.3.10-2.el6.remi.5.6.x86_64
php-xml-5.6.30-1.el6.remi.x86_64
php-mysqlnd-5.6.30-1.el6.remi.x86_64
php-PHPMailer-5.2.23-1.el6.noarch
php-5.6.30-1.el6.remi.x86_64
php-tidy-5.6.30-1.el6.remi.x86_64
php-gd-5.6.30-1.el6.remi.x86_64
php-mbstring-5.6.30-1.el6.remi.x86_64
php-ldap-5.6.30-1.el6.remi.x86_64
php-intl-5.6.30-1.el6.remi.x86_64
php-phpseclib-net-sftp-0.3.9-1.el6.noarch
php-phpseclib-math-biginteger-0.3.9-1.el6.noarch
php-phpseclib-crypt-twofish-0.3.9-2.el6.noarch
php-cloudfiles-1.7.11-2.el6.noarch
php-pear-Mail-Mime-1.8.4-1.el6.noarch
php-phpseclib-crypt-tripledes-0.3.9-2.el6.noarch
php-doctrine-annotations-1.2.7-4.el6.noarch
php-channel-horde-1.0-1.el6.noarch
php-pear-Net-DNS2-1.3.2-1.el6.noarch
php-horde-Horde-Injector-2.0.3-1.el6.noarch
php-horde-Horde-Socket-Client-2.1.0-1.el6.noarch
php-horde-Horde-Scribe-2.0.1-1.el6.noarch
php-pear-Net-URL-1.0.15-4.el6.noarch
php-pear-Numbers-Words-0.16.2-1.el6.noarch
php-nrk-Predis-0.8.6-1.el6.noarch
php-PHP-CSS-Parser-7.0.3-1.el6.noarch
php-horde-Horde-Util-2.5.8-1.el6.noarch
php-horde-Horde-Browser-2.0.13-1.el6.noarch
php-horde-Horde-Log-2.3.0-1.el6.noarch
php-symfony-finder-2.3.42-1.el6.noarch
php-horde-Horde-Nls-2.2.1-1.el6.noarch
php-symfony-process-2.3.42-1.el6.noarch
php-horde-Horde-ListHeaders-1.2.4-1.el6.noarch
php-symfony-http-kernel-2.3.42-1.el6.noarch
php-horde-Horde-Data-2.1.3-1.el6.noarch
php-ZendFramework-Search-Lucene-1.12.20-1.el6.noarch
php-horde-Horde-Compress-2.2.0-1.el6.noarch
php-horde-Horde-Oauth-2.0.3-1.el6.noarch
php-horde-Horde-Kolab-Format-2.0.7-1.el6.noarch
php-znerol-php-stringprep-0-0.4.20150618gitfe3f274.el6.noarch
php-horde-Horde-Cache-2.5.5-1.el6.noarch
php-horde-Horde-History-2.3.5-1.el6.noarch
php-horde-Horde-Auth-2.2.1-1.el6.noarch
php-horde-Horde-Share-2.1.2-1.el6.noarch
php-horde-Horde-Image-2.4.1-1.el6.noarch
php-channel-phpseclib-1.3-1.el6.noarch
php-doctrine-common-2.4.3-2.el6.noarch
php-phpseclib-crypt-aes-0.3.9-1.el6.noarch
php-phpseclib-net-ssh2-0.3.9-1.el6.noarch
php-symfony-class-loader-2.3.42-1.el6.noarch
php-ZendFramework-1.12.20-1.el6.noarch
php-pdo-5.6.30-1.el6.remi.x86_64
php-pecl-jsonc-devel-1.3.10-2.el6.remi.5.6.x86_64
php-horde-Horde-Cli-2.2.3-1.el6.noarch
php-odbc-5.6.30-1.el6.remi.x86_64
php-pecl-oauth-1.2.3-9.el6.remi.5.6.x86_64
php-snmp-5.6.30-1.el6.remi.x86_64
php-sabredav-Sabre-1.0.0-9.el6.noarch
php-pecl-apcu-4.0.11-2.el6.remi.5.6.x86_64
php-bcmath-5.6.30-1.el6.remi.x86_64
php-pecl-memcache-3.0.8-3.el6.remi.5.6.x86_64
php-phpseclib-crypt-rc4-0.3.9-2.el6.noarch
php-phpseclib-crypt-rijndael-0.3.9-2.el6.noarch
php-pear-Mail-1.2.0-1.el6.noarch
php-pear-XML-Parser-1.3.4-1.el6.noarch
php-pear-DB-1.7.13-3.el6.noarch
php-pear-Auth-SASL-1.0.6-1.el6.noarch
php-pear-1.10.4-2.el6.remi.noarch
php-horde-Horde-Url-2.2.3-1.el6.noarch
php-horde-Horde-Role-1.0.1-1.el6.noarch
php-horde-Horde-Thrift-2.0.1-2.el6.noarch
php-sabredav-Sabre_VObject-2.1.7-1.el6.noarch
php-horde-Horde-Memcache-2.1.1-1.el6.noarch
php-channel-nrk-1.3-1.el6.noarch
php-horde-Horde-Stream-1.6.2-1.el6.noarch
php-symfony-filesystem-2.3.42-1.el6.noarch
php-horde-Horde-Imsp-2.0.9-1.el6.noarch
php-symfony-browser-kit-2.3.42-1.el6.noarch
php-horde-Horde-Text-Filter-2.3.5-1.el6.noarch
php-symfony-event-dispatcher-2.3.42-1.el6.noarch
php-horde-Horde-Icalendar-2.1.6-1.el6.noarch
php-ZendFramework-Pdf-1.12.20-1.el6.noarch
php-horde-Horde-Mapi-1.0.8-1.el6.noarch
php-horde-Horde-CssMinify-1.0.3-1.el6.noarch
php-horde-Horde-Secret-2.0.5-1.el6.noarch
php-horde-Horde-Tree-2.0.4-1.el6.noarch
php-horde-Horde-SpellChecker-2.1.1-1.el6.noarch
php-horde-Horde-Editor-2.0.4-3.el6.noarch
php-horde-Horde-Compress-Fast-1.1.0-1.el6.noarch
php-horde-Horde-Perms-2.1.6-1.el6.noarch
php-horde-Horde-Imap-Client-2.29.12-1.el6.noarch
php-horde-Horde-Kolab-Storage-2.2.3-1.el6.noarch
php-horde-Horde-SessionHandler-2.2.9-1.el6.noarch
php-pear-Text-CAPTCHA-0.4.4-1.el6.noarch
php-horde-Horde-Stream-Filter-2.0.2-1.el6.noarch
php-horde-Horde-Template-2.0.1-3.el6.noarch
php-doctrine-dbal-2.4.5-1.el6.noarch
php-pear-Cache-Lite-1.7.12-1.el6.noarch
php-pear-Net-SMTP-1.6.1-1.el6.noarch
php-symfony-common-2.3.42-1.el6.noarch
php-horde-Horde-Text-Flowed-2.0.1-4.el6.noarch
php-symfony-config-2.3.42-1.el6.noarch
php-horde-Horde-Idna-1.1.0-1.el6.noarch
php-symfony-console-2.3.42-1.el6.noarch
php-horde-Horde-LoginTasks-2.0.7-1.el6.noarch
php-horde-Horde-Date-2.4.0-1.el6.noarch
php-horde-Horde-Crypt-Blowfish-1.1.0-1.el6.noarch
php-horde-Horde-Core-2.29.0-1.el6.noarch
php-pecl-mongo-1.6.14-1.el6.remi.5.6.x86_64
php-mcrypt-5.6.30-1.el6.remi.x86_64
php-horde-Horde-Serialize-2.0.2-1.el6.noarch
php-horde-Horde-Group-2.1.0-1.el6.noarch
php-horde-Horde-Kolab-Session-2.0.1-1.el6.noarch
php-dropbox-php-Dropbox-1.0.0-4.el6.noarch
php-irodsphp-3.3.0-0.4.beta1.el6.noarch
php-pear-Image-Text-0.6.1-1.el6.noarch
php-getid3-1.9.14-1.el6.noarch
php-pear-Net-Socket-1.0.10-1.el6.noarch
php-doctrine-inflector-1.1.0-4.el6.noarch
php-horde-Horde-Translation-2.2.2-1.el6.noarch
php-horde-Horde-Stream-Wrapper-2.1.2-1.el6.noarch
php-horde-Horde-Queue-1.1.4-1.el6.noarch
php-pear-Text-Password-1.1.1-1.el6.noarch
php-phpseclib-crypt-hash-0.3.9-1.el6.noarch
php-horde-Horde-Css-Parser-1.0.10-1.el6.noarch
php-horde-Horde-Support-2.2.0-1.el6.noarch
php-symfony-dom-crawler-2.3.42-1.el6.noarch
php-horde-Horde-HashTable-1.2.3-1.el6.noarch
php-symfony-debug-2.3.42-1.el6.noarch
php-horde-Horde-Mail-2.6.2-1.el6.noarch
php-common-5.6.30-1.el6.remi.x86_64
php-horde-Horde-Mime-Viewer-2.2.1-1.el6.noarch
php-horde-Horde-Alarm-2.2.10-1.el6.noarch
php-horde-Horde-Routes-2.0.4-1.el6.noarch
php-soap-5.6.30-1.el6.remi.x86_64
php-horde-horde-lz4-1.0.10-1.el6.remi.5.6.x86_64
php-pecl-geoip-1.1.1-1.el6.remi.5.6.x86_64
php-horde-Horde-Lock-2.1.4-1.el6.noarch
php-horde-Horde-Vfs-2.4.0-1.el6.noarch
php-pear-Net-Curl-1.2.5-4.el6.noarch
php-channel-sabredav-1.3-3.el6.noarch
php-phpseclib-crypt-random-0.3.9-1.el6.noarch
php-horde-Horde-Prefs-2.8.1-1.el6.noarch
phpmyadmin-2.11.11.3-2.el6.rf.noarch
php-pear-HTTP-Request2-0.5.2-2.el6.noarch

Code: Select all

repo id                                       repo name                                                                                           status
Webmin                                        Webmin Distribution Neutral                                                                                 273
base                                          CentOS-6 - Base                                                                                       6,571+135
base-debuginfo                                CentOS-6 - Debuginfo                                                                                      5,053
epel                                          Extra Packages for Enterprise Linux 6 - x86_64                                                        12,279+84
epel-debuginfo                                Extra Packages for Enterprise Linux 6 - x86_64 - Debug                                                    2,221
extras                                        CentOS-6 - Extras                                                                                         28+17
google-mod-pagespeed                          google-mod-pagespeed                                                                                          7
mod-pagespeed                                 mod-pagespeed                                                                                                 7
puias-client                                  PUIAS Client                                                                                            254+412
remi-php54                                    Remi's PHP 5.4 RPM repository for Enterprise Linux 6 - x86_64                                            11+359
remi-php56                                    Remi's PHP 5.6 RPM repository for Enterprise Linux 6 - x86_64                                               424
remi-php56-debuginfo                          Remi's PHP 5.6 RPM repository for Enterprise Linux 6 - x86_64 - debuginfo                                   300
remi-safe                                     Safe Remi's RPM repository for Enterprise Linux 6 - x86_64                                              1,793+2
remi-safe-debuginfo                           Remi's RPM repository for Enterprise Linux 6 - x86_64 - debuginfo                                         1,472
rpmforge                                      RHEL 6 - RPMforge.net - dag                                                                         3,228+1,490
updates                                       CentOS-6 - Updates                                                                                          395
Again, i don't know what i have done apart from having too many repositories (and not knowing enough about them) ... can you suggest a quick and easy way for me to sync my MySQL php components with my actual php ?

Many thanks in advance if anyone can help me ... it sounds a bit worrying and i can't figure out how mysqlnd 5.0.11 failed to get updated !
Top
User avatar
remirepo
Posts: 447
Joined: 2014/09/21 09:07:12
Location: France
Contact:
Contact remirepo

Re: My PHP MySQL library version differs from my MySQL server version

Post by remirepo » 2017/07/07 08:14:35

> phpmyadmin-2.11.11.3-2.el6.rf.noarch

Definitively a bad idea.

rpmforge a dead repo, which should be avoid, and this version is obviously outdated.

EPEL have version 4.0.x which is better

> php-5.6.30-1.el6.remi.x86_64

"remi" have latest version 4.7.x which is more suitable for recent PHP version
(I recommend you enable "remi" but filter what you need from it using includepkgs option)

BTW, this warning is only a warning and doesn't make sense (only exists in very old version)
Remi's Repository - Forum - Blog
Top
aegersz
Posts: 86
Joined: 2016/04/04 07:42:58

Re: My PHP MySQL library version differs from my MySQL server version

Post by aegersz » 2017/07/07 09:00:28

my rpm skills are not strong but I may give it a go.

my php based forum is rock steady so I may sit on it for a while.

thanks brother.
Top
Post Reply

Return to “CentOS 6 - Software Support”