• Debian 11 is approaching its end-of-life (vendor EOL date - August 31, 2026). Plesk Obsidian 18.0.80 will be the last release to support it.
    If you are running Plesk Obsidian on Debian 11, we recommend you upgrade those servers to Debian 12 using our dist-upgrade tool.
  • We plan to deprecate and remove the support for XML RPC protocol versions earlier than 1.6.9.1 in Plesk Obsidian 18.0.82. We strongly recommend that you update all existing integrations using earlier versions of the XML RPC protocol to comply with the version 1.6.9.1 specification.

MySQL problem with my.cnf and "LOAD DATA LOCAL INFILE"

CriTrip

New Pleskian
Goodmorning,

I'm using on virtual machine the last version of PLESK 11.5.3 update #42 and UBUNTU 12.04.4 LTS provide by a main Italian ISP, the MySQL version is 5.5.35-0ubuntu0.12.04.2.
I'm trying to enable the local-infile option in the /etc/mysql/my.cnf file:

[client]
local-infile = 1

[mysqld]
local-infile = 1

When I'm restarting mysql service (with command "service mysql restart") the PHP script works correctly and "SHOW GLOBAL VARIABLES" results "ON", but when server reboot or some hours by the restart the PHP script return to not work correctly and appear the standard messagge:

"The used command is not allowed with this MySQL version"

Maybe the problem is the start of mysql on boot? I haven't any errors in the mysql or system log!!

Do you have any hints to solve this? Thanks in advance!
 
[UPDATE]

I had individuated a possible issue, every few second or minutes one service calls "/usr/bin/mysql_upgrade" that process ignores the settings defined in "/etc/mysql/my.cnf" and reset on the fly mysql to default value.

I think that a PSA procedure that create, update or delete the mysql databases.

I appreciated every possible solution, thank you.

Regards
 
Back
Top