Solved Matomo system check report showing a warning for "LOAD DATA INFILE" with "access denied" as the root cause
I noticed today (not sure how long it's been present for though) the Matomo system report is showing the following:
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 '<randomUserID>'@'%' (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
Does anyone else see this too in their Matomo installs?
Now I don't have any websites serving up more than 100,000 pages a month so this isn't critical by any means, but I suppose it wouldn't hurt to follow its guidance anyways? It seems like it's enabled anyways and was more of a access issue, but how do I fix this?
@d19dotca Same as https://forum.cloudron.io/topic/4746/diagnostics-error . Funnily enough, you upvoted my reply there
@girish haha, damn, I didn't remember that and didn't see it when I did a quick search for some reason, haha. Thanks Girish!
d19dotca last edited by d19dotca
Judging by the link above, it seems this can actually be fixed in the app package by setting this in the default config:
Right now, the package seems to have this enabled (or rather it's default enabled in Matomo) when it should be disabled with the setting above.
@d19dotca Ah, great find! Let me add that to the package.
@girish Seems the latest app package update fixes it. Thanks for the quick turnaround as always!