Trying to setup auto-archiving, problem with php_mysqli.so

Hello all, I am following the tutorial for auto-archiving, but even when I try to run a test, I have the following error:

PHP Warning:  PHP Startup: Unable to load dynamic library '/opt/rh/rh-php70/root/usr/lib64/php/modules/php_mysqli.so' - /opt/rh/rh-php70/root/usr/lib64/php/modules/php_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 '/opt/rh/rh-php70/root/usr/lib64/php/modules/pdo_mysql.so' - /opt/rh/rh-php70/root/usr/lib64/php/modules/pdo_mysql.so: undefined symbol: mysqlnd_allocator in Unknown on line 0
Error: Empty or invalid response 'PHP Warning:  Module 'PDO' already loaded in Unknown on line 0 a:52:{s:10:"2019-08-11";a:40:{s:16:"nb_uniq_visitors";d:2137;s:9:"nb_visits";d:2616;s:8:"nb_users";i:0;s:10:"nb_actions";d:6810;s:11:"max_actions";d:163;s:12:"bounce_count";d:1288;s:16:"sum_visit_length";d:573128;s:19:"nb_visits_returning";d:1759;s:20:"nb_actions_returning";d:4483;s:26:"nb_uniq_visitors_returning";d:1346;s:18:"nb_users_returning";i:0;s:21:"max_actions_returning";d:163;s:21:"bounce_rate_returning";s:3:"49%";s:30:"nb_actions_per_visit_returning";d:2.5;s:26:"avg_time_on_site_returning";d:228;s:14:"nb_conversions";i:0;s:19:"nb_visits_converted";i:0;s:7:"revenue";i:0;s:15:"conversion_rate";s:2:"0%";s:24:"nb_conversions_new_visit";i:0;s:29:"nb_visits_converted_new_visit";i:0;s:17:"revenue_new_visit";i:0;s:25:"conversion_rate_new_visit";s:2:"0%";s:30:"nb_conversions_returning_visit";i:0;s:35:"nb_visits_converted_returning_visit";i:0;s:23:"revenue_returning_visit";i:0;s:31:"conversion_rate_returning_visit";s:2:"0%";s:12:"nb_pageviews";d:6743;s:17:"nb_uniq_pageviews";d:4314;s:12:"nb_downloads";d:24;s:17:"nb_uniq_downloads";d:20;s:11:"nb_outlinks";d:41;s:16:"nb_uniq_outlinks";d:39;s:11:"nb_searches";d:2;s:11:"nb_keywords";d:1;s:28:"nb_hits_with_time_generation";d:6411;s:19:"avg_time_generation";d:1.0429999999999999;s:11:"bounce_rate";s:3:"49%";s:20:"nb_actions_per_visit";d:2.6000000000000001;s:16:"avg_time_on_site";d:219;}s:10:"2019-08-12";a:40:{s:16:"nb_uniq_visitors";d:6151;s:9:"nb_visits";d:8247;s:8:"nb_users";i:0;s:10:"nb_actions";d:24531;s:11:"max_actions";d:1157;s:12:"bounce_count";d:3804;s:16:"sum_visit_length";d:2303922;s:19:"nb_visits_returning";d:6129;s:20:"nb_actions_returning";d:18429;s:26:"nb_uniq_visitors_returning";d:4241;s:18:"nb_users_returning";i:0;s:21:"max_actions_returning";d:1157;s:21:"bounce_rate_returning";s:3:"46%";s:30:"nb_actions_per_visit_returning";d:3;s:26:"avg_time_on_site_returning";d:296;s:14:"nb_conversions";i:0;s:19:"nb_visits_converted";i:0;s:7:"revenue";i:0;s:15:"conversion_rate";s:2:"0%";s:24:"nb_conversions_new_visit";i:0;s:29:"nb_visits_converted_new_visit";i:0;s:17:"revenue_new_visit";i:0;s:25:"conversion_rate_new_visit";s:2:"0%";s:30:"nb_conversions_returning_visit";i:0;s:35:"nb_visits_converted_returning_visit";i:0;s:23:"revenue_returning_visit";i:0;s:31:"conversion_rate_returning_visit";s:2:"0%";s:12:"nb_pageviews";d:24262;s:17:"nb_uniq_pageviews";d:14966;s:12:"nb_downloads";d:104;s:17:"nb_uniq_downloads";d:82;s:11:"nb_outlinks";d:160;s:16:"nb_uniq_outlinks";d:76;s:11:"nb_searches";d:5;s:11:"nb_keywords";d:2;s:28:"nb_hits_with_time_generation";d:22834;s:19:"avg_time_generation";d:1.004;s:11:"bounce_rate";s:3:"46%";s:20:"nb_actions_per_visit";d:3;s:16:"avg_time_on_site";d:279;}s:10:"2019-08-13";a:40:{s:16:"nb_uniq_visitors";d:5739;s:9:"nb_visits";d:7717;s:8:"nb_users";i:0;s:10:"nb_actions";d:23040;s:11:"max_actions";d:873;s:12:"bounce_count";d:3577;s:16:"sum_visit_length";d:2161353;s:19:"nb_visits_returning";d:5761;s:20:"nb_actions_returning";d:17146;s:26:"nb_uniq_visitors_returning";d:3976;s:18:"nb_users_returning";i:0;s:21:"max_actions_returning";d:873;s:21:"bounce_rate_returning";s:3:"46%";s:30:"nb_actions_per_visit_returning";d:3;s:26:"avg_time_on_site_returning";d:289;s:14:"nb_conversions";i:0;s:19:"nb_visits_converted";i:0;s:7:"revenue";i:0;s:15:"conversion_rate";s:2:"0%";s:24:"nb_conversions_new_visit";i:0;s:29:"nb_visits_converted_new_visit";i:0;s:17:"revenue_new_visit";i:0;s:25:"conversion_rate_new_visit";s:2:"0%";s:30:"nb_conversions_returning_visit";i:0;s:35:"nb_visits_converted_returning_visit";i:0;s:23:"revenue_returning_visit";i:0;s:31:"conversion_rate_returning_visit";s:2:"0%";s:12:"nb_pageviews";d:22711;s:17:"nb_uniq_pageviews";d:14174;s:12:"nb_downloads";d:123;s:17:"nb_uniq_downloads";d:99;s:11:"nb_outlinks";d:206;s:16:"nb_uniq_outlinks";d:91;s:11:"nb_searches";i:0;s:11:"nb_keywords";i:0;s:28:"nb_hits_with_time_generation";d:21455;s:19:"avg_time_generation";d:1.0580000000000001;s:11:"bounce_rate";s:3:"46%";s:20:"nb_actions_per_visit";d:3;s:16:"avg_time_on_site";d:280;}s:10:"2019-08-14";a:40:{s:16:"nb_uniq_visitors";d:6092;s:9:"nb_visits";d:7760;s:8:"nb_users";i:0;s:10:"nb_actions";d:21419;s:11:"max_actions";d:756;s:12:"bounce_count";d:3733;s:16:"sum_visit_length";d:1903259;s:19:"nb_visits_returning";d:5089;s:20:"nb_actions_returning";d:14790;s:26:"nb_uniq_visitors_returning";d:3641;s:18:"nb_users_returning";i:0;s:21:"max_actions_returning";d:756;s:21:"bounce_rate_returning";s:3:"46%";s:30:"nb_actions_per_visit_returning";d:2.8999999999999999;s:26:"avg_time_on_site_returning";d:279;s:14:"nb_conversions";i:0;s:19:"nb_visits_converted";i:0;s:7:"revenue";i:0;s:15:"conversion_rate";s:2:"0%";s:24:"nb_conversions_new_visit";i:0;s:29:"nb_visits_converted_new_visit";i:0;s:17:"revenue_new_visit";i:0;s:25:"conversion_rate_new_visit";s:2:"0%";s:30:"nb_conversions_returning_visit";i:0;s:35:"nb_visits_converted_returning_visit";i:0;s:23:"revenue_returning_visit";i:0;s:31:"conversion_rate_returning_visit";s:2:"0%";s:12:"nb_pageviews";d:21167;s:17:"nb_uniq_pageviews";d:13464;s:12:"nb_downloads";d:88;s:17:"nb_uniq_downloads";d:76;s:11:"nb_outlinks";d:162;s:16:"nb_uniq_outlinks";d:90;s:11:"nb_searches";d:2;s:11:"nb_keywords";d:1;s:28:"nb_hits_with_time_generation";d:20149;s:19:"avg_time_generation";d:1.048;s:11:"bounce_rate";s:3:"48%";s:20:"nb_actions_per_visit";d:2.7999999999999998;s:16:"avg_time_on_site";d:245;}s:10:"2019-08-15";a:40:{s:16:"nb_uniq_visitors";d:3402;s:9:"nb_visits";d:4020;s:8:"nb_users";i:0;s:10:"nb_actions";d:9596;s:11:"max_actions";d:59;s:12:"bounce_count";d:2107;s:16:"sum_visit_length";d:781010;s:19:"nb_visits_returning";d:2323;s:20:"nb_actions_returning";d:5791;s:26:"nb_uniq_visitors_returning";d:1822;s:18:"nb_users_returning";i:0;s:21:"max_actions_returning";d:53;s:21:"bounce_rate_returning";s:3:"50%";s:30:"nb_actions_per_visit_returning";d:2.5;s:26:"avg_time_on_site_returning";d:228;s:14:"nb_conversions";i:0;s:19:"nb_visits_con
ERROR [2019-10-01 09:11:10] 30236  1 total errors during this script execution, please investigate and try and fix these errors.

Should I install php_mysqli.so even if Matomo seems to working? Thanks!

Hi,

Matomo obviously needs php-mysql to connect to the database. I guess you have it installed (otherwise how would you be using Matomo) for the webserver. But when you run php from from the commandline make sure that php-cli is also properly set up.

Hello Lukas, thanks for your reply. It was indeed a very stupid error from my part, since the extensions:

php_mysqli.so
pdo.so
pdo_mysql.so

were double-declared in php.ini and php.d/, I needed to just remove them.

1 Like