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 Diagnostics error

    Matomo
    4
    5
    222
    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.
    • imc67
      imc67 translator last edited by

      A freshly installed Matomo app gives this error (Diagnostic / Error):

      Database abilities 	UTF8mb4 charset
      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 '***USERNAME***' (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
      

      Same error BTW in an older version, I'm very sure it wasn't there before.

      1 Reply Last reply Reply Quote 0
      • nebulon
        nebulon Staff last edited by

        This is known, but is not working with the mysql addon yet. This is just a new feature in the latest Matomo release, which can speed up the app, but is not yet supported. You can treat it as a warning or info, but not an error as such.

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

          To be clearer, we can't ever support this, since this flag requires mysql addon and matomo to share the same file system. That seems too much of a security risk. I don't know why matomo thinks this is a undismissable error/warning. It's worth reporting upstream.

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

            https://forum.matomo.org/t/how-to-disable-load-data-infile/36328 is one such post.

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

              For reference only (I accidentally duplicated this in a new post, didn't see this one until later): https://forum.cloudron.io/topic/4924/matomo-system-check-report-showing-a-warning-for-load-data-infile-with-access-denied-as-the-root-cause/

              Edit: Latest app package update fixes the issue.

              --
              Dustin Dauncey
              www.d19.ca

              1 Reply Last reply Reply Quote 1
              • First post
                Last post
              Powered by NodeBB