I was running matomo on my old joomla directory - this was also a different sub domain (www.old.berndjung.com) as my website (www.berndjung.com).
Everything is happening on the same hosted server!
As this is causing another SSL Handshake and DNS lookup (takes sometimes 0.6 seconds) i wanted to move matomo to the same directory and same domain to speed things up for my visitors and pagespeed.
So I installed the same matomo version in the web directory of berndjung.com. In the installation process i pointed to the same (old) MYSQL Database.
I added www.berndjung.com as trusted host. i changed the tracking code in the joomla plugin to track …
But it is not working.
I can log in matomo - but i get error messages …
“Oops… there was a problem during the request. Maybe the server had a temporary issue, or maybe you requested a report with too much data…”
when trying to make system check in settings i get
" Mysqli prepare error: MySQL server has gone away"
Visits in real time are shown …
No problems when trying to reach the (same) database from the old installation though …
config.ini.php
; <?php exit; ?> DO NOT REMOVE THIS LINE
; file automatically generated or modified by Matomo; you can manually override the default values in global.ini.php by redefining them in this file.
[database]
host = “localhost”
username = “xxxx”
password = “xxxx”
dbname = “xxx”
tables_prefix = “piwik_”
adapter = “MYSQLI”
[General]
salt = “xxx”
trusted_hosts[] = “www.berndjung.com”
…
config.ini.php of the old installation shows different “salt”, no adapter settings, force SSL …
Any help and explanation is welcome.