php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #18338 LOAD DATA LOCAL problem leads to "...command is not allowed..."
Submitted: 2002-07-14 12:11 UTC Modified: 2002-08-24 04:29 UTC
From: manuel at manitu dot de Assigned:
Status: No Feedback Package: MySQL related
PHP Version: 4.2.1 OS: Linux / RedHat 7.3
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please — but make sure to vote on the bug!
Your email address:
MUST BE VALID
Solve the problem:
27 - 20 = ?
Subscribe to this entry?

 
 [2002-07-14 12:11 UTC] manuel at manitu dot de
When upgrading to MySQL 3.23.49 or higher, many people did encounter a problem when using "LOAD DATA LOCAL" with MySQL and PHP. This was caused because MySQL authors did alter some configuration of MySQL. Starting with MySQL 3.23.49 there is another option ("local-infile") which has to be passed to the MySQL server and clients in order to have LOAD DATA LOCAL to work again.

The problem: Passing this ("local-infile[=1]") does not affect PHP. Many people still have problems to get LOAD DATA LOCAL to work.

Background: If you have passed the parameter to MySQL (in my.cnf or via the startup script) and the command LOAD DATA LOCAL still leads to "...command not allowed..." then your PHP was not compiled correctly.

When compiling PHP with "--enable-safe-mode" the problem still occurs independent on what your MySQL server settings or what php.ini says (attentions: even if you deactivate safe mode in php.ini the error is there).

The solutions: The only way to solve the problem is not to use "--enable-safe-mode" when configuring PHP and then set it manually in php.ini. Then LOAD DATA LOCAL works again.


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-07-14 17:58 UTC] sniper@php.net
I think this is fixed in the HEAD (php 4.3.0-dev).
Please test this snapshot:

http://snaps.php.net/php4-latest.tar.gz
 
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Wed Oct 27 05:03:35 2021 UTC