Update database type

Support & Bugs
1

I am running Matomo vs 5.1.2. When I do the system check I get error "Your database version indicates you might be using a MariaDb server. "

Then advice to update " [database] schema = Mariadb in the “config/config.ini.php”".

If I update config/config.ini.php then the db error goes but I then get a file size mismatch error.

Any suggestions on how to get rid of both errors?

PS. My error, I was trying to update global.ini.php instead of config.ini.php.

Updating config.ini.php with “schema = Mariadb” under the database section got rid of all errors.

2

I think there’s a mismatch between actual files and the expected checksum or size of the files, that you modified through all the changes.

Try this:

Update your config.ini.php file to include this:

[database]
schema = Mariadb

Re-upload the affected files from a clean version of Matomo matching your current version.

Clear cache:

rm -rf /path/to/matomo/tmp/cache/*

Run File Integrity Check:

php /path/to/matomo/console core:archive

Check Permissions for files and directories:

sudo chown -R www-data:www-data /path/to/matomo
sudo find /path/to/matomo -type d -exec chmod 755 {} \;
sudo find /path/to/matomo -type f -exec chmod 644 {} \;

Let us know how you go : )

3

Thanks Easton for the suggestions. I added a PS to my post showing it was my error so working now as described above.

Thanks again for replying:)

4

OMG just saw it now heheh, sorry about that :smiley:

Glad you sorted it out ! yay!

You can mark your answer as solution then :smiley:

5

Interesting that you can’t mark the first post as a solution so marked my follow up comment.

6

yeah u are right : ) thx for that!