SOLVED Diagnostics error
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: Invalid authorization specification: 1045 Access denied for user '***USERNAME***' (using password: YES), Try #2: LOAD DATA LOCAL INFILE : SQLSTATE: Syntax error or access violation: 3948 Loading local data is disabled; this must be enabled on both the client and server sides Troubleshooting: FAQ on matomo.org
Same error BTW in an older version, I'm very sure it wasn't there before.
This is known, but is not working with the mysql addon yet. This is just a new feature in the latest Matomo release, which can speed up the app, but is not yet supported. You can treat it as a warning or info, but not an error as such.
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.
https://forum.matomo.org/t/how-to-disable-load-data-infile/36328 is one such post.
d19dotca last edited by d19dotca
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.