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[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.orgDoes 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?
--
Dustin Dauncey
www.d19.ca -
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.orgDoes 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 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=0Right 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.
--
Dustin Dauncey
www.d19.ca -
@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=0Right 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.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login