Moin zusammen,
ich bin gerade dabei den Systembericht zu überprüfen, sodass ich für unsere Matomo Instanz (hoher Traffic) eine ideale Performance erzielen kann.
Dabei wurde ich dann darauf hingewiesen einen Crobjob einzurichten.
Dies habe ich auch über EasyCron gemacht und spiele die folgende URL an:
https://xxx.xxx.com/misc/cron/archive.php?token_auth=250xxx5f4
Der Cron läuft erfolgreich durch.
Dieses Ergebnis wird dabei generiert (EasyCron output):
X-Powered-By: PHP/8.1.20
X-Matomo-Request-Id: 59404
Content-Type: text/plain;charset=UTF-8
Vary: Accept-Encoding
Server: nginx
Date: Wed, 28 Jun 2023 13:00:04 GMT
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] ---------------------------
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] INIT
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] Running Matomo 4.14.2 as Super User
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] ---------------------------
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] NOTES
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] - If you execute this script at least once per hour (or more often) in a crontab, you may disable 'Browser trigger archiving' in Matomo UI > Settings > General Settings.
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] See the doc at: https://matomo.org/docs/setup-auto-archiving/
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] - Async process archiving supported, using CliMulti.
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] - Reports for today will be processed at most every 900 seconds. You can change this value in Matomo UI > Settings > General Settings.
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] - Archiving was last executed without error 9 Minuten 57s ago.
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] ---------------------------
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] START
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] Starting Matomo reports archiving...
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] Start processing archives for site 1.
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] Will invalidate archived reports for today in site ID = 1's timezone (2023-06-28 00:00:00).
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] Will invalidate archived reports for yesterday in site ID = 1's timezone (2023-06-27 00:00:00).
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] Finished archiving for site 1, 0 API requests, Time elapsed: 0.013s [1 / 3 done]
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] Start processing archives for site 2.
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] Will invalidate archived reports for today in site ID = 2's timezone (2023-06-28 00:00:00).
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] LOAD DATA INFILE failed... Error was:
Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'matomo'@'%' (using password: YES)[28000],
Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 3948 Loading local data is disabled; this must be enabled on both the client and server sides[42000]
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] LOAD DATA INFILE failed... Error was:
Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'matomo'@'%' (using password: YES)[28000],
Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 3948 Loading local data is disabled; this must be enabled on both the client and server sides[42000]
INFO CoreAdminHome[2023-06-28 13:00:04 UTC] [59404] Will invalidate archived reports for yesterday in site ID = 2's timezone (2023-06-27 00:00:00).
INFO CoreAdminHome[2023-06-28 13:00:06 UTC] [59404] Archived website id 2, period = day, date = 2023-06-28, segment = '', 547 visits found. Time elapsed: 1.073s
INFO CoreAdminHome[2023-06-28 13:00:07 UTC] [59404] Archived website id 2, period = week, date = 2023-06-26, segment = '', 2224 visits found. Time elapsed: 1.231s
INFO CoreAdminHome[2023-06-28 13:00:09 UTC] [59404] Archived website id 2, period = month, date = 2023-06-01, segment = '', 9706 visits found. Time elapsed: 1.979s
INFO CoreAdminHome[2023-06-28 13:00:10 UTC] [59404] Archived website id 2, period = year, date = 2023-01-01, segment = '', 9706 visits found. Time elapsed: 1.222s
INFO CoreAdminHome[2023-06-28 13:00:10 UTC] [59404] Finished archiving for site 2, 4 API requests, Time elapsed: 5.725s [2 / 3 done]
INFO CoreAdminHome[2023-06-28 13:00:10 UTC] [59404] Start processing archives for site 3.
INFO CoreAdminHome[2023-06-28 13:00:10 UTC] [59404] Will invalidate archived reports for today in site ID = 3's timezone (2023-06-28 00:00:00).
INFO CoreAdminHome[2023-06-28 13:00:10 UTC] [59404] LOAD DATA INFILE failed... Error was:
Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'matomo'@'%' (using password: YES)[28000],
Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 3948 Loading local data is disabled; this must be enabled on both the client and server sides[42000]
INFO CoreAdminHome[2023-06-28 13:00:10 UTC] [59404] LOAD DATA INFILE failed... Error was:
Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'matomo'@'%' (using password: YES)[28000],
Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 3948 Loading local data is disabled; this must be enabled on both the client and server sides[42000]
INFO CoreAdminHome[2023-06-28 13:00:10 UTC] [59404] Will invalidate archived reports for yesterday in site ID = 3's timezone (2023-06-27 00:00:00).
INFO CoreAdminHome[2023-06-28 13:00:11 UTC] [59404] Archived website id 3, period = day, date = 2023-06-28, segment = '', 19 visits found. Time elapsed: 0.691s
INFO CoreAdminHome[2023-06-28 13:00:12 UTC] [59404] Archived website id 3, period = week, date = 2023-06-26, segment = '', 52 visits found. Time elapsed: 0.935s
INFO CoreAdminHome[2023-06-28 13:00:13 UTC] [59404] Archived website id 3, period = month, date = 2023-06-01, segment = '', 52 visits found. Time elapsed: 1.016s
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] Archived website id 3, period = year, date = 2023-01-01, segment = '', 52 visits found. Time elapsed: 0.868s
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] Finished archiving for site 3, 4 API requests, Time elapsed: 3.726s [3 / 3 done]
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] Done archiving!
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] ---------------------------
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] SUMMARY
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] Processed 8 archives.
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] Total API requests: 8
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] done: 8 req, 9522 ms, no error
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] Time elapsed: 9.522s
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] ---------------------------
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] SCHEDULED TASKS
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] Starting Scheduled tasks...
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] Scheduler: executing task Piwik\Plugins\CustomJsTracker\Tasks.updateTracker...
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] Scheduler: finished. Time elapsed: 0.001s
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] Scheduler: executing task Piwik\Plugins\PrivacyManager\Tasks.deleteLogData...
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] Scheduler: finished. Time elapsed: 0.000s
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] Scheduler: executing task Piwik\Plugins\PrivacyManager\Tasks.anonymizePastData...
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] Scheduler: finished. Time elapsed: 0.000s
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] done
INFO CoreAdminHome[2023-06-28 13:00:14 UTC] [59404] ---------------------------
Success:ok
Das folgende einfache Setup wurde hierzu angewandt:
So sieht der Beitrag hierzu im Systembericht aus:
Für eine optimale Leistung und ein schnelles Matomo wird dringend empfohlen, einen Crontab einzurichten, um Ihre Berichte automatisch zu archivieren und das Auslösen durch den Browser in den Matomo-Einstellungen zu deaktivieren. Erfahren Sie mehr.
Meinen Frage an die Community:
Hat jemand einen solchen Fehler schon mal gehabt?
Erkennt ihr, wo der Fehler liegt?
Wie gelingt es mir, dass die Meldung im Systembericht korrigiert wird?
Ich freue mich auf Eure Rückmeldungen!