How to disable LOAD DATA INFILE

[progger]

My hoster does not allow LOAD DATA INFILE or LOAD DATA LOCAL INFILE due to security concerns and Matomo seems to run fine without it.

But I’d like to disable the warning about missing database abilities in the System Check. According to the FAQ I put the setting enable_load_data_infile=0 in the config.ini.php but the warning still appears.

Is there another step necessary to remove this warning from the System Check?

[d19dotca (Dustin Dauncey)]

I’m in a similar boat. Would love the ability to disable this warning from the System Check report.

[Lukas (Lukas Winkler)]

Hi,

It is possible to ignore/hide system check entries:

sgiehl

How to ignore system integrity warnings?

Hey there. I’m running a Docker container of the Matomo image and do not want to create a custom image for Matomo where I have to check for updates and stuff. But I’m getting annoyed about the cron warning which is only achievable with a custom Dockerfile. I don’t want to use a crontab because it’s a small website and I’m fine. I want to ignore this warning but how can I do this? Like this it is always misleading me that there is a real problem.

The check responsible for LOAD DATA INFILE is Piwik\Plugins\Diagnostics\Diagnostic\DatabaseAbilitiesCheck. But keep in mind that this also removes the check for Utf8mb4, TemporaryLabels and Transaction check.

Also I just noticed that the check is already hidden if you set enable_load_data_infile=0 (this was added in Matomo 4 after @progger commented above)

matomo-org/matomo/blob/b6ace0e06c2ef3f8f98ac55feb934ebe0d304107/plugins/Diagnostics/Diagnostic/DatabaseAbilitiesCheck.php#L43-L45