LOAD DATA INFILE issue


(Herby Olschewski) #1

I’m having difficulty in clearing the diagnostic warning as per below.

We are 100% sure that local-infile=1 is enabled and the database is able to load local infile. Confirmed.

The database user definitely has the FILE privilege. Confirmed.

However, the System Check diagnostic is still not happy.

Note: We are using MariaDB instead of Mysql, however I don’t see that being a problem?

Is there something I am missing and/or another way to satisfy this diagnostic check?

Many thanks!

Herby

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 to try fix this problem.


(Lukas Winkler) #2

Hi,

While I have no idea why it isn’t working for you (I am using MariaDB and it works), this is the exact check Matomo is doing, so this might help to troubleshoot: