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

Diagnostics error

Scheduled Pinned Locked Moved Solved Matomo
5 Posts 4 Posters 253 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.
  • imc67I Offline
    imc67I Offline
    imc67 translator
    wrote on last edited by
    #1

    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
    0
  • nebulonN Online
    nebulonN Online
    nebulon Staff
    wrote on last edited by
    #2

    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
    2
  • girishG Offline
    girishG Offline
    girish Staff
    wrote on last edited by
    #3

    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
    1
  • girishG Offline
    girishG Offline
    girish Staff
    wrote on last edited by
    #4

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

    1 Reply Last reply
    1
  • d19dotcaD Offline
    d19dotcaD Offline
    d19dotca
    wrote on last edited by d19dotca
    #5

    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
    1

  • Login

  • Don't have an account? Register

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