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
@girish So I was looking at this a bit more and found this: https://matomo.org/faq/troubleshooting/faq_194/
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!