Can't install Piwik stats

[Xencaye]

Hello, guys!

I'm having some troubles installing Piwik stats straight from the Applications page in Plesk. The error below pops up, happens to all domains. Any ideas? I'm a little lost.

Error: The following error has occurred during the installation of application: Installation of Piwik at **** failed. Non-zero exit status returned by script. Output stream: 'PHP Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /usr/local/psa/var/apspackages/apscatalogTpVJ8L.zip9101b01b-036e-ed/cache/scripts/db-util.php:66 Stack trace: #0 /usr/local/psa/var/apspackages/apscatalogTpVJ8L.zip9101b01b-036e-ed/cache/scripts/app-util.php(39): mysql_db_connect('localhost:3306', 'piwik_2', '***', 'piwik_9') #1 /usr/local/psa/var/apspackages/apscatalogTpVJ8L.zip9101b01b-036e-ed/cache/scripts/app-util.php(13): import_sql_scripts_to_databases(Array, Array, Array, Array, Array, Array, Array, Array) #2 /usr/local/psa/var/apspackages/apscatalogTpVJ8L.zip9101b01b-036e-ed/cache/scripts/configure(100): configure(Array, Array, Array, Array, Array, Array, Array, Array, Array) #3 {main} thrown in /usr/local/psa/var/apspackages/apscatalogTpVJ8L.zip9101b01b-036e-ed/cache/scripts/db-util.php on line 66 '. Error stream: 'PHP Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /usr/local/psa/var/apspackages/apscatalogTpVJ8L.zip9101b01b-036e-ed/cache/scripts/db-util.php:66 Stack trace: #0 /usr/local/psa/var/apspackages/apscatalogTpVJ8L.zip9101b01b-036e-ed/cache/scripts/app-util.php(39): mysql_db_connect('localhost:3306', 'piwik_2', '***', 'piwik_9') #1 /usr/local/psa/var/apspackages/apscatalogTpVJ8L.zip9101b01b-036e-ed/cache/scripts/app-util.php(13): import_sql_scripts_to_databases(Array, Array, Array, Array, Array, Array, Array, Array) #2 /usr/local/psa/var/apspackages/apscatalogTpVJ8L.zip9101b01b-036e-ed/cache/scripts/configure(100): configure(Array, Array, Array, Array, Array, Array, Array, Array, Array) #3 {main} thrown in /usr/local/psa/var/apspackages/apscatalogTpVJ8L.zip9101b01b-036e-ed/cache/scripts/db-util.php on line 66 '.

Thanks in advance.

 

[IgorG]

Call to undefined function mysql_connect

Make sure that you have installed corresponding plesk-phpXX-mysql package with something like

# rpm -qa | grep mysql

 

[Xencaye]

Thanks for the input! When I run the command I get the following:

plesk-mysql-server-12.5.30-cos7.build1205150826.19.x86_64
plesk-php56-mysql-5.6.20-centos7.16040512.x86_64
php-mysql-5.4.16-36.el7_1.x86_64
plesk-php70-mysql-7.0.5-centos7.16040516.x86_64
plesk-mysql-connector-odbc-5.2.7-centos7.15072015.x86_64

According to the Piwik requirements, I need MySQL 4.1 or higher, which seems to be so in my case.

I haven't had issues with installing latest WordPress and whatnot, if that matters.

 

[IgorG]

What version of PHP is used for this site?

 

[Xencaye]

It's using 7.0.5!

 

[UFHH01]

Hi Xencaye,

I recommend the piwik installation on a subdomain, with PHP 5.6 - usage, because there are still PHP7 incompatibility issues with the latest Piwik release ( see as well: https://github.com/piwik/piwik/issues/8689 )