Not working on Ubuntu 24.04 LTS

Support & Bugs
1

Hi!
Matomo is not working anymore after updating Ubuntu server from 22 to 24.
PHP is 8.3
MySQL is 8.0.39-0ubuntu0.24.04.2 (Ubuntu)

It’s pretty urgent as I’m providing statistics for the popular non profit organization in Croatia.

Please help!

Thanks!

2024/09/18 15:25:52 [error] 10921#10921: *57 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Undefined constant "Piwik\Db\Adapter\MYSQLI_OPT_LOCAL_INFILE" in /var/www/matomo/core/Db/Adapter/Mysqli.php:36
Stack trace:
#0 /var/www/matomo/core/Db/Adapter.php(50): Piwik\Db\Adapter\Mysqli->__construct()
#1 /var/www/matomo/core/Db.php(158): Piwik\Db\Adapter::factory()
#2 /var/www/matomo/core/Db.php(57): Piwik\Db::createDatabaseObject()
#3 /var/www/matomo/core/Db.php(346): Piwik\Db::get()
#4 /var/www/matomo/core/Option.php(290): Piwik\Db::fetchAll()
#5 /var/www/matomo/core/Option.php(180): Piwik\Option->autoload()
#6 /var/www/matomo/core/Option.php(50): Piwik\Option->getValue()
#7 /var/www/matomo/plugins/CoreAdminHome/CustomLogo.php(54): Piwik\Option::get()
#8 /var/www/matomo/plugins/CoreAdminHome/CustomLogo.php(69): Piwik\Plugins\CoreAdminHome\CustomLogo->isEnabled()
#9 /var/www/matomo/core/ExceptionHandler.php(135): Piwik\Plugins\CoreAdminHome\CustomLogo->hasSVGLogo()
#10 /var/www/matomo/core/ExceptionHandler.php(101): Piwik\ExceptionHandler::getE...; PHP message: PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 118784 bytes) in /var/www/matomo/core/FrontController.php on line 131" while reading response header from upstream, client: 78.0.87.243, server: matomo.thevegcat.com, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/run/php/php8.3-fpm.sock:", host: "matomo.thevegcat.com"
2

Feckit, I did PHP downgrade to 8.1.
It would be nice to avoid situations such as this one.

3

Another thing I had to do is to manually install PHP with GMP extension:

$ sudo apt-get install php8.1-gmp
4

That is odd. I just double checked my install of Matomo on Ubuntu Mate 24.04.1 LTS and php -v returns

PHP 8.3.6 (cli) (built: Sep 30 2024 15:17:17) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.3.6, Copyright (c) Zend Technologies
    with Zend OPcache v8.3.6, Copyright (c), by Zend Technologies

Perhaps increasing memory_limit in php.ini to 512M or 1024M will help.