Matomo Cronjob "ERROR CoreAdminHome"

General questions
1

Hello,

my newly installed motomo still has problems with the cronjob.

The cronjob reports the error:

Got invalid response from API request:
?module=API&method=API.get&idSite=1&period=day&date=last4&format=php&trigger=archivephp.

Response was
‘a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:3056:"The mysql driver is not currently installed #0 /var/www/vhosts/stat.xxx.de/httpdocs/libs/Zend/Db/Adapter/Pdo/Mysql.php(109):
Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /var/www/vhosts/stat.xxx.de/httpdocs/core/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /var/www/vhosts/stat.xxx.de/httpdocs/core/Db/Adapter/Pdo/Mysql.php(74): Piwik\Db\Adapter\Pdo\Mysql->_connect()
#3 /var/www/vhosts/stat.xxx.de/httpdocs/core/Db/Adapter.php(51): Piwik\Db\Adapter\Pdo\Mysql->getConnection()
#4 /var/www/vhosts/stat.xxx.de/httpdocs/core/Db.php(156): Piwik\Db\Adapter::factory(‘PDO\MYSQL’, Array)
#5 /var/www/vhosts/stat.xxx.de/httpdocs/core/FrontController.php(318): Piwik\Db::createDatabaseObject()
#6 /var/www/vhosts/stat.xxx.de/httpdocs/core/dispatch.php(33): Piwik\FrontController->init()
#7 /var/www/vhosts/stat.xxx.de/httpdocs/index.php(27): require_once(’/var/www/vhosts…‘)
#8 /var/www/vhosts/stat.xxx.de/httpdocs/core/CliMulti/RequestCommand.php(79): require_once(’/var/www/vhosts…‘)
#9 /var/www/vhosts/stat.xxx.de/httpdocs/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Piwik\CliMulti\RequestCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#10 /var/www/vhosts/stat.xxx.de/httpdocs/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#11 /var/www/vhosts/stat.xxx.de/httpdocs/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(Piwik\CliMulti\RequestCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 [internal function]: Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 /var/www/vhosts/stat.xxx.de/httpdocs/core/Console.php(140): call_user_func(Array, Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#14 /var/www/vhosts/stat.xxx.de/httpdocs/core/Access.php(644): Piwik\Console->Piwik{closure}()
#15 /var/www/vhosts/stat.xxx.de/httpdocs/core/Console.php(141): Piwik\Access::doAsSuperUser(Object(Closure))
#16 /var/www/vhosts/stat.xxx.de/httpdocs/core/Console.php(93): Piwik\Console->doRunImpl(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#17 /var/www/vhosts/stat.xxx.de/httpdocs/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#18 /var/www/vhosts/stat.xxx.de/httpdocs/console(32): Symfony\Component\Console\Application->run()
#19 {main}";}’
ERROR CoreAdminHome[2020-07-20 18:10:24 UTC] [5c685] Empty or invalid response ‘’ for website id 1, Time elapsed: 0.415s, skipping

Before someone asks for memory. Mysql has 3GB and PHP 1GB. The Matomo system check is completely green [incl. Load Data infile]. Exception of course the error message during archiving.

Thanks Gerald

2

Hi,

This is the error. During archiving the php-cli calls the web API. And it seems like the PHP that is used to handle this request doesn’t have the proper php module for mysql set up.

1 Like
3

Hi Lukas,

thank you for your quick response. Does the API execution have its own config file? The Matomo can be called and I see how new records are created / read in Mysql.

Thanks Gerald

4

Hello, lucas,

our hoster has checked the configuration of the server, and discovered a missing Mysql module in the PHP-CLI version.

Thanks to all.

1 Like