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
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