Application and Database in different servers


For some strange reasons, my default installation of Piwik refuses to show any data collected. It is a default installation with app and database running on the same server (Windows+Apache+MySql) and the domains (as far I know) are sending the data, but the dashboards never show the numbers.

To try to prove my point, I’ve created one AWS instance running Ubuntu+nginx+MySql and restored a database backup. And the reports and dashboards are now full of numbers. Now my questions are:

  1. Can I use this instance to get the reports from the “oficial” database?
  2. Do I have to change the tracking code to point to this second server or its ok to have this server as a “report server”?



Maybe you can find your solution in: Troubleshooting - Analytics Platform - Matomo

Try setup: How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo

and check server error logs which may contain some error messages ?

Matt, the error log is:

PHP Fatal error:  2 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: Response was 'curl_exec: Failure when receiving data from the peer' in D:\\analytics\misc\cron\archive.php on line 573

Check the server error logs (eg. apache error log)