Solved Matomo system check report showing a warning for "LOAD DATA INFILE" with "access denied" as the root cause

[d19dotca]

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[28000]: Invalid authorization specification: 1045 Access denied for user '<randomUserID>'@'%' (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 

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?

[girish]

@d19dotca Same as https://forum.cloudron.io/topic/4746/diagnostics-error . Funnily enough, you upvoted my reply there

[girish]

also see https://docs.cloudron.io/apps/matomo/#load-data-infile

[d19dotca]

@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]

@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: enable_load_data_infile=0

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.

[girish]

@d19dotca Ah, great find! Let me add that to the package.

[d19dotca]

@girish Seems the latest app package update fixes it. Thanks for the quick turnaround as always!