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


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

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

    Matomo
    2
    7
    586
    Loading More Posts
    • 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.
    • d19dotca
      d19dotca last edited by

      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

      girish 1 Reply Last reply Reply Quote 0
      • girish
        girish Staff @d19dotca last edited by

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

        1 Reply Last reply Reply Quote 1
        • girish
          girish Staff last edited by

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

          d19dotca 2 Replies Last reply Reply Quote 0
          • d19dotca
            d19dotca @girish last edited by

            @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 Reply Quote 0
            • d19dotca
              d19dotca @girish 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: 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

              girish 1 Reply Last reply Reply Quote 1
              • girish
                girish Staff @d19dotca last edited by

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

                d19dotca 1 Reply Last reply Reply Quote 1
                • d19dotca
                  d19dotca @girish last edited by

                  @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 Reply Quote 1
                  • First post
                    Last post
                  Powered by NodeBB