php5-mysql not on Centos6.4 New install and moved servers..

Submitted by DonPeek on Mon, 07/01/2013 - 13:13 Pro Licensee

I move 395 sites to a new server.. Most are working. But some are getting

http://www.transcendia.org/wordpress/ Your PHP installation appears to be missing the MySQL extension which is required by WordPress.

I found when I tried to install phpmyadmin on these sites I get the message below..

Tell me it looking for php5-mysql and with 6.4 the php 5.3.3 is just called php ...

Please Help..

-- INSTALL MESSAGE

Found http://prdownloads.sourceforge.net:80/sourceforge/phpmyadmin/phpMyAdmin-... in cache ..

PHP module mysql is required .. Enabling module in PHP configuration .. .. done Installing package php5-mysql .. Installing package(s) with command yum -y install php5-mysql ..

Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: mirror.steadfast.net * centosplus: mirror.anl.gov * contrib: mirror.dattobackup.com * extras: mirror.teklinks.com * updates: mirror.steadfast.net Setting up Install Process No package php5-mysql available. Error: Nothing to do .. install failed! Module is not available even after installation!

PS : I am opening the support cert for 209.235.165.194 so you look and see what I need to do .

Status: 
Active

Comments

Submitted by andreychek on Mon, 07/01/2013 - 13:27

It looks like Virtualmin may be trying to install php5-mysql rather than php-mysql -- I'm passing this to Jamie so he can correct that in the next release.

However, in the meantime, to correct your sites you can install the PHP MySQL module by running this command:

yum install php-mysql

Submitted by JamieCameron on Mon, 07/01/2013 - 15:08

Virtualmin should try to install both php5-mysql and then php-mysql , as it doesn't always know in advance what the correct package name is.

I would be interested to know if running yum install php-mysql fixes this problem.

Submitted by DonPeek on Mon, 07/01/2013 - 17:29 Pro Licensee

I worked myself around the issue..

I created a New blank site.. restored everything but the SQL files.. I then dropped the databases by hand and importing them from a command line and it is working...

I conclude...

On "some" site the restored databases, changed php version it was looking for .. It should not have.. It was trying to connect to php5-sql still when the new system used php-sql...... And as soon as I restored the database it make the site then look for php5 and die...

The backup and restore is not the best running programs.. about 400 moved and 40 sites had issues... missing this or that .. and this sql mess...

And Thanks... for all the work everyone there does.. It's good to know I have some place to go for help, when everyone I know looks at me to fix what ever can go wrong on these servers..

And keeping this post online helps too... I found I had to copy my /etc/pam.d/ssh to /etc/pam.d/proftpd to get proftpd working again.. I found in 2009 where Jamie fixed the same thing on my system back them..

Don

Submitted by DonPeek on Sun, 07/14/2013 - 19:45 Pro Licensee

There must be a way to fix this.. The site was moved from a server that had php5 installed.. the NEW server CentOs 6.4 has php 5.3.3. as default and is just called php-mysql..

I could find where this php5 information is keep I could fix it.. Any Clue ?

Thanks Don

When I try to update the site I get this.. ..

WordPress MU version 3.5.1 is installed and running..
***********************************
Upgrading WordPress MU to version 3.5.2 ..
PHP module mysql is required ..
Enabling module in PHP configuration ..
.. done
Installing package php5-mysql ..
Installing package(s) with command yum -y install php5-mysql ..

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: www.gtlib.gatech.edu
* centosplus: mirror.es.its.nyu.edu
* contrib: mirror.teklinks.com
* extras: dist1.800hosting.com
* updates: mirror.es.its.nyu.edu
Setting up Install Process
No package php5-mysql available.
Error: Nothing to do
.. install failed!
Module is not available even after installation!

Submitted by andreychek on Sun, 07/14/2013 - 21:08

What output do you receive if you run this command:

rpm -qa | grep php

Submitted by DonPeek on Sun, 07/14/2013 - 23:09 Pro Licensee

php-cli-5.3.3-23.el6_4.x86_64 php-odbc-5.3.3-23.el6_4.x86_64 php-imap-5.3.3-23.el6_4.x86_64 php-pdo-5.3.3-23.el6_4.x86_64 php-pear-1.9.4-4.el6.noarch php-5.3.3-23.el6_4.x86_64 php-pgsql-5.3.3-23.el6_4.x86_64 php-mbstring-5.3.3-23.el6_4.x86_64 php-gd-5.3.3-23.el6_4.x86_64 php-snmp-5.3.3-23.el6_4.x86_64 php-common-5.3.3-23.el6_4.x86_64 php-mysql-5.3.3-23.el6_4.x86_64 php-xml-5.3.3-23.el6_4.x86_64 php-xmlrpc-5.3.3-23.el6_4.x86_64 wbm-php-pear-1.5-1.noarch php-mcrypt-5.3.3-1.el6.x86_64

Submitted by DonPeek on Tue, 09/24/2013 - 17:59 Pro Licensee

PHP module mysql is required ..
Installing package php5-mysql ..
Installing package(s) with command yum -y install php5-mysql ..
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: centos.vipernetworksystems.com
* centosplus: mirror.team-cymru.org
* contrib: mirror.dattobackup.com
* extras: centos.netnitco.net
* updates: centos.aol.com
Setting up Install Process
No package php5-mysql available.
Error: Nothing to do
.. install failed!
Module is not available even after installation!

How to I fix this ?

Submitted by JamieCameron on Tue, 09/24/2013 - 21:12

It looks like the problem is that even though the MySQL PHP module is installed, it isn't being loaded by PHP.

Which PHP execution mode is selected for this domain?

Submitted by DonPeek on Tue, 09/24/2013 - 21:45 Pro Licensee

FCGId (run as virtual server owner) But I have tried CGI Wrapper.. same..

My wild guess.... I think it the template the server was made with is no longer my have something to do with it..

I have a lot like this.. I found, wipe the site, make a new install and put back in all the parts and it works.. but a full restore brings back the issues..

I have done 30 or more so far... I think I have them all and another one shows up...

Don

Submitted by andreychek on Tue, 09/24/2013 - 22:33

What output do you receive if you log into your server over SSH, and run this command:

PHPRC=/home/USERNAME/etc/php5 php -m

Where "USERNAME" is the username of one of the Virtual Server owners who is experiencing this problem in their domain?

Submitted by DonPeek on Wed, 09/25/2013 - 12:08 Pro Licensee

Well That gave some errors... What does this mean ?

PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mcrypt.so' - /usr/lib/php/modules/mcrypt.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mysql.so' - /usr/lib/php/modules/mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/curl.so' - /usr/lib/php/modules/curl.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/dom.so' - /usr/lib/php/modules/dom.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/fileinfo.so' - /usr/lib/php/modules/fileinfo.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/gd.so' - /usr/lib/php/modules/gd.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/imap.so' - /usr/lib/php/modules/imap.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/json.so' - /usr/lib/php/modules/json.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mbstring.so' - /usr/lib/php/modules/mbstring.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mcrypt.so' - /usr/lib/php/modules/mcrypt.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mysql.so' - /usr/lib/php/modules/mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mysqli.so' - /usr/lib/php/modules/mysqli.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/odbc.so' - /usr/lib/php/modules/odbc.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/pdo.so' - /usr/lib/php/modules/pdo.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/pdo_mysql.so' - /usr/lib/php/modules/pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/pdo_odbc.so' - /usr/lib/php/modules/pdo_odbc.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/pdo_pgsql.so' - /usr/lib/php/modules/pdo_pgsql.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/pdo_sqlite.so' - /usr/lib/php/modules/pdo_sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/pgsql.so' - /usr/lib/php/modules/pgsql.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/phar.so' - /usr/lib/php/modules/phar.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/snmp.so' - /usr/lib/php/modules/snmp.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/sqlite3.so' - /usr/lib/php/modules/sqlite3.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/wddx.so' - /usr/lib/php/modules/wddx.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/xmlreader.so' - /usr/lib/php/modules/xmlreader.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/xmlrpc.so' - /usr/lib/php/modules/xmlrpc.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/xmlwriter.so' - /usr/lib/php/modules/xmlwriter.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/xsl.so' - /usr/lib/php/modules/xsl.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/zip.so' - /usr/lib/php/modules/zip.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  Directive 'register_globals' is deprecated in PHP 5.3 and greater in Unknown on line 0
[PHP Modules]
bz2
calendar
Core
ctype
date
ereg
exif
filter
ftp
gettext
gmp
hash
iconv
ionCube Loader
libxml
openssl
pcntl
pcre
readline
Reflection
session
shmop
SimpleXML
sockets
SPL
standard
tokenizer
xml
zlib

[Zend Modules]
the ionCube PHP Loader

Submitted by andreychek on Wed, 09/25/2013 - 12:16

Those errors are showing that PHP is unable to load those particular modules for some reason.

My suspicion is that there may be an incorrect "include_path" setting in that user's php.ini file.

What output do you receive if you run this command:

grep include_path /home/USERNAME/etc/php.ini

Submitted by DonPeek on Wed, 09/25/2013 - 22:13 Pro Licensee

That was the answer.. I replace the /home/USER/etc/php5/php.ini with the server default fixed the session.save and upload_folder , restart httpd and YEA!!
I was sure I had tried that before.. Thanks..

Case closed, :-)