Diagnostics error
Solved
Matomo
-
A freshly installed Matomo app gives this error (Diagnostic / Error):
Database abilities UTF8mb4 charset LOAD DATA INFILE Using LOAD DATA INFILE will greatly speed Matomo's archiving process up. To make it available to Matomo, try updating your PHP & MySQL software and make sure your database user has the FILE privilege. If your Matomo server tracks high traffic websites (eg. > 100,000 pages per month), we recommend trying to fix this problem. Error: LOAD DATA INFILE failed... Error was: Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user '***USERNAME***' (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] Troubleshooting: FAQ on matomo.org
Same error BTW in an older version, I'm very sure it wasn't there before.
-
To be clearer, we can't ever support this, since this flag requires mysql addon and matomo to share the same file system. That seems too much of a security risk. I don't know why matomo thinks this is a undismissable error/warning. It's worth reporting upstream.
-
For reference only (I accidentally duplicated this in a new post, didn't see this one until later): https://forum.cloudron.io/topic/4924/matomo-system-check-report-showing-a-warning-for-load-data-infile-with-access-denied-as-the-root-cause/
Edit: Latest app package update fixes the issue.