Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

Cloudron Forum

Apps | Demo | Docs | Install

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

Scheduled Pinned Locked Moved Solved Matomo
7 Posts 2 Posters 655 Views
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • d19dotcaD Offline
    d19dotcaD Offline
    d19dotca
    wrote on last edited by
    #1

    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?

    --
    Dustin Dauncey
    www.d19.ca

    girishG 1 Reply Last reply
    0
  • girishG Offline
    girishG Offline
    girish Staff
    replied to d19dotca on last edited by
    #2

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

    1 Reply Last reply
    1
  • girishG Offline
    girishG Offline
    girish Staff
    wrote on last edited by
    #3

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

    d19dotcaD 2 Replies Last reply
    0
  • d19dotcaD Offline
    d19dotcaD Offline
    d19dotca
    replied to girish on last edited by
    #4

    @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! 🙂

    --
    Dustin Dauncey
    www.d19.ca

    1 Reply Last reply
    0
  • d19dotcaD Offline
    d19dotcaD Offline
    d19dotca
    replied to girish on last edited by d19dotca
    #5

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

    --
    Dustin Dauncey
    www.d19.ca

    girishG 1 Reply Last reply
    1
  • girishG Offline
    girishG Offline
    girish Staff
    replied to d19dotca on last edited by
    #6

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

    d19dotcaD 1 Reply Last reply
    1
  • d19dotcaD Offline
    d19dotcaD Offline
    d19dotca
    replied to girish on last edited by
    #7

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

    --
    Dustin Dauncey
    www.d19.ca

    1 Reply Last reply
    1

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Login

  • Don't have an account? Register

  • Login or register to search.