First install getting errors

First error…
“Matomo requires either the mysqli extension or both the PDO and pdo_mysql extensions.”

It suggests…
" On a Windows server you can add the following lines to your php.ini:

extension=php_mysqli.dll extension=php_pdo.dll
extension=php_pdo_mysql.dll`
After making this change, restart your web server."

I did that and it still fails.
NOTE: I noticed the file “php_pdo.dll” does not exist in my php7.4.9

Second Error…
“The mbstring extension is required to handle multibyte characters in the User interface and API responses. Also, please check that mbstring.func_overload is set to “0” in php.ini.”

I confirmed the the setting “mbstring.func_overload is set to “0” in php.ini” is set to 0.

Any ideas?

Hi,

Check a phpinfo() file and see if your PHP setup has loaded the mbstrings PHP module and either the mysqli or the PDO php module.

If not, check your PHP config to make sure that those two modules are working correctly.

By “phpinfo()” you mean the php.ini file?
Or my https://localhost/phpinfo.php?

Not sure what to look for.
Just a reminder, I’m completely new to this so assume total ignorance on my part…….lol.

I mean a .php file that is accessible from your webserver that contains

<?php
phpinfo();

and that you should delete once you are done with setting up Matomo to not help attackers gathering information about the server-setup.

In the section called mysqlnd these are what comes up…

Version mysqlnd 7.4.9
Compression supported
core SSL supported
extended SSL supported
Command buffer size 4096
Read buffer size 32768
Read timeout 86400
Collecting statistics Yes
Collecting memory statistics Yes
Tracing n/a
Loaded plugins mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password
API Extensions no value

There is no section for mbstring.

Hi,

I don’t know for sure if this module contains the mysqli or PDO connector or just the old mysql_* connector, but as I am not too familiar with Windows setups I recommend to maybe double check this.

In this case you need to install this module.

How does one do that?
I’m a total noob on this so step bt step helps a bunch. :slight_smile:

Hi,

That totally depends on how you are using PHP and how you have set up your webserver.

I have not used Windows in years and never used it for server-things, so I am unfortunatly not the right person here.

Hi, for mbstring see:
https://docs.moodle.org/39/en/admin/environment/php_extension/mbstring

I got mbstring working my unremarking the below lines…
;extension=mbstring
;extension=exif

Fixed the MySQLi issue by unremarking these lines…
;extension_dir = “ext”
;extension=mysqli

Fixed the SSL warning by unremarking this line…
;extension=openssl
;extension=curl

Fixed the graphic warning on GD > 2.x + Freetype (graphics) by adding this line…
extension=php_gd2.dll

Now all my checks are green and no errors or warnings.

2 Likes