Scripts fail when trying to update under centos 7

Submitted by doggy101 on Sun, 10/26/2014 - 05:51

This is the error i get when trying to update roundcube ( some other php5 related I get when updating Owncloud)

PHP module mysql is required ..

Installing package php5-mysql ..
Installing package(s) with command yum -y install php5-mysql ..

Loaded plugins: fastestmirror, replace
Loading mirror speeds from cached hostfile
 * base: mirror.nl.leaseweb.net
 * epel: mirror.nl.leaseweb.net
 * extras: mirror.nl.leaseweb.net
 * updates: mirror.nl.leaseweb.net
 * webtatic: uk.repo.webtatic.com
No package php5-mysql available.
Error: Nothing to do

.. install failed!

php is installed PHP 5.4.16 (cli) (built: Sep 30 2014 09:44:39)

can the scripts be fixes for centos7? or is the another way around this?

Status: 
Closed (fixed)

Comments

Submitted by JamieCameron on Sun, 10/26/2014 - 12:08

Did it not try to install the php-mysql package as well? On CentOS 7, that's the one that contains the PHP mysql module.

Submitted by doggy101 on Mon, 10/27/2014 - 07:06

Yes I did, but it keeps asking for the php5-mysql also... the same on the owncloud script there it is the php5-gd

Submitted by JamieCameron on Mon, 10/27/2014 - 16:18

Did it actually install php-mysql successfully? You can check with the command rpm -q php-mysql

Submitted by JamieCameron on Tue, 10/28/2014 - 15:41

Ok, so the real issue is that Virtualmin isn't detecting that the PHP mysql module is enabled.

If you select the domain from the left menu and go to Server Configuration -> Website Options, does it show any PHP modules available?

Submitted by doggy101 on Wed, 10/29/2014 - 03:58

yes it says:

Pear modules for PHP 5
Archive_Tar Console_Getopt PEAR Structures_Graph XML_Util

and on server level => PHP version:

Your system only has PHP version 5 installed, so selecting a different version for each directory is not possible.

removing and reinstalling PHP dit not solve the issues...

Submitted by JamieCameron on Wed, 10/29/2014 - 21:19

Ok, so it sounds like it is detecting Pear modules, but not PHP modules.

Try SSHing into your system as the domain owner, and running the following commands :

PHPRC=$HOME/etc/php5
php -m

and let me know what it outputs.

Submitted by doggy101 on Sun, 11/02/2014 - 11:08

Hi Jamie,

Sorry for the late response:

here's the output...

[PHP Modules] bz2 calendar Core ctype curl date dom ereg exif fileinfo filter ftp gd gettext gmp hash iconv json ldap libxml mbstring mhash mysql mysqli odbc openssl pcntl pcre PDO pdo_mysql PDO_ODBC pdo_sqlite Phar posix readline Reflection session shmop SimpleXML snmp soap sockets SPL sqlite3 standard sysvmsg sysvsem sysvshm tokenizer wddx xml xmlreader xmlrpc xmlwriter xsl zip zlib

[Zend Modules]

Submitted by JamieCameron on Sun, 11/02/2014 - 16:38

Sorry, I gave those commands wrong. They should be :

export PHPRC=$HOME/etc/php5
php -m

Submitted by doggy101 on Mon, 11/03/2014 - 02:08

Hi Jamie output is the same:

XXXX@webserver ~]$ php -m [PHP Modules] bz2 calendar Core ctype curl date dom ereg exif fileinfo filter ftp gd gettext gmp hash iconv json ldap libxml mbstring mhash mysql mysqli odbc openssl pcntl pcre PDO pdo_mysql PDO_ODBC pdo_sqlite Phar posix readline Reflection session shmop SimpleXML snmp soap sockets SPL sqlite3 standard sysvmsg sysvsem sysvshm tokenizer wddx xml xmlreader xmlrpc xmlwriter xsl zip zlib

[Zend Modules]

Submitted by doggy101 on Sat, 11/08/2014 - 05:21

Hi Jamie,

Any new suggestions?

Submitted by JamieCameron on Sat, 11/08/2014 - 17:58

That actually looks fine - the mysql module is clearly listed.

I think to debug this further I would need to login to your system myself.

Submitted by doggy101 on Sun, 11/09/2014 - 01:45

Hi Jamie,

I sent you an email with the login with the same topic as this issue.

Submitted by JamieCameron on Sun, 11/09/2014 - 23:50

Ok, I see the error now. There were actually two problems :

  1. The ~/etc and ~/etc/php directories didn't have the right permissions, and so weren't listable on your system.

  2. The ~/etc/php5/php.ini file contained the directive allow_call_time_pass_reference which is no longer allowed in newer PHP versions. This is probably because the domains were migrated from another system?

The next Virtualmin release will be better able to detect and diagnose these problems.

Submitted by doggy101 on Mon, 11/10/2014 - 03:55

thanks,

Scripts are running now, allthough there are new issues now but I wil look into them myself

Submitted by Issues on Mon, 11/24/2014 - 04:00

Automatically closed -- issue fixed for 2 weeks with no activity.