MySQL "LOAD DATA INFILE" broken since PLESK 11.5.30

[muelli75]

Hi!

We are using Debian 6.0.7, Plesk was running wonderful for months. Yesterday we updated to "Plesk 11.5.30 - Update 15", the update installed without errormessages.

If we upload a CSV-file on our internetsite to the webserver through a php-script, the following process fails. The MySQL-Server (5.1.66-0+squeeze1) cant get rights to process the file. We use the command "LOAD DATA INFILE".
Before we installed the last PLESK-update, the command was working well.

Now we get a mysql-permission-error (1085 or 13).

What we tried:
Copied the file after upload insead of move - fail
Setting the rights of the csv-file to 777 - fail
Setting the rights of directory containing the csv-file to 777 - fail
Rewrite the "LOAD DATE INFILE"-Command to use the relative path instead of absolute - fail
Used PhpMyAdmin to do "LOAD DATE INFILE" - fail
Used the commandline of the MySQL-Server to do the command - fail
Copied the CSV manually to /var/lib/mysql/OurSite/ and do "LOAD DATA INFILE" with this - worked

To use "LOAD DATA LOCAL INFILE" is no option, because of securityconcerns.

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

Martin

 

[abdi]

Can this help ..

http://kb.parallels.com/en/2507

 

[muelli75]

Hi!

Thanks for this hint, but as written "LOCAL" isnt an option because of securityrisks.

Any other ideas out there?

Martin