How to get LOAD DATA INFILE to worked on my Linux server and/or Matomo Diagnostic System Check setting?
Posted: September 8th, 2022, 5:34 am
When you are running a Shell "Top" command and saw the Load average and the %Cpu(s) is dynamically continuous high,
while description of command-line is "php-cgi" within one of your websites (inline PID user) and mail queue is currently not running,
that's mean your LOAD DATA INFILE not working.
And Or
If the LOAD DATA INFILE related to Database abilities is still not working with your Matomo version: 4.11.0 to Diagnostic System Check setting, try the following configuration:
check within your configuration for MultiPHP.ini,
Currently I'm using the latest stable LTS tier released WHM version 11.102.0.21 using PHP 7.4.30 (cli) with Zend Engine v3.4.0
from ea-php74 and not using alt-php74,
in WHM menu: Home /Software /MultiPHP INI Editor >> Editor Mode
Edit the INI settings of current PHP version of your domain name server.
and...
change the settings that you should not have:
(Before PHP 7.2.16 and 7.3.3 the default was "1")
If you see this line in the file, just delete it!
or change it with:
or
and/or
if you are using PHP-Mysqli,
you must enable the PHP INI setting with:
The system saves PHP sessions in the /var/cpanel/php/sessions directory by default. This allows PHP to write session files, but users will not possess permissions to delete those sessions in the directory. Because PHP writes setting files, PHP cannot clean its own sessions. Therefore, the root user must run a cron job to delete the expired session files.
This is WHM server Con job example:
Located at /var/spool/cron/root
within root shell terminal I'm using:
and Run for every 30 minutes at minute: 09 and minute: 39.
To make sure your database running correctly, add this too:
and your server will be better and running faster and more stable.
while description of command-line is "php-cgi" within one of your websites (inline PID user) and mail queue is currently not running,
that's mean your LOAD DATA INFILE not working.
And Or
If the LOAD DATA INFILE related to Database abilities is still not working with your Matomo version: 4.11.0 to Diagnostic System Check setting, try the following configuration:
check within your configuration for MultiPHP.ini,
Currently I'm using the latest stable LTS tier released WHM version 11.102.0.21 using PHP 7.4.30 (cli) with Zend Engine v3.4.0
from ea-php74 and not using alt-php74,
in WHM menu: Home /Software /MultiPHP INI Editor >> Editor Mode
Edit the INI settings of current PHP version of your domain name server.
and...
change the settings that you should not have:
(Before PHP 7.2.16 and 7.3.3 the default was "1")
Code: Select all
enable_load_data_infile=0
or change it with:
Code: Select all
#enable_load_data_infile=0
Code: Select all
;enable_load_data_infile=0
if you are using PHP-Mysqli,
you must enable the PHP INI setting with:
Code: Select all
mysqli.allow_local_infile = On
This is WHM server Con job example:
Located at /var/spool/cron/root
within root shell terminal I'm using:
Code: Select all
nano /var/spool/cron/root
Code: Select all
09,39 * * * * /usr/local/cpanel/scripts/clean_user_php_sessions > /dev/null 2>&1
Code: Select all
15 0 * * * mysqlcheck --auto-repair --optimize --all-databases > /dev/null 2>&1