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


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
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
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Matomo
  3. Matomo system check report showing a warning for "LOAD DATA INFILE" with "access denied" as the root cause

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 1.9k Views 2 Watching
  • 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
      • d19dotcaD 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?

        girishG Offline
        girishG Offline
        girish
        Staff
        wrote 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
          • girishG girish

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

            d19dotcaD Offline
            d19dotcaD Offline
            d19dotca
            wrote 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
            • girishG girish

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

              d19dotcaD Offline
              d19dotcaD Offline
              d19dotca
              wrote 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
              • d19dotcaD 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.

                girishG Offline
                girishG Offline
                girish
                Staff
                wrote on last edited by
                #6

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

                d19dotcaD 1 Reply Last reply
                1
                • girishG girish

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

                  d19dotcaD Offline
                  d19dotcaD Offline
                  d19dotca
                  wrote 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
                  Reply
                  • Reply as topic
                  Log in to reply
                  • Oldest to Newest
                  • Newest to Oldest
                  • Most Votes


                    • Login

                    • Don't have an account? Register

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