ID: 19602 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Bogus Bug Type: *Directory/Filesystem functions Operating System: RH Linux 7.1 PHP Version: 4.2.3 New Comment:
Sorry, but the bug system is not the appropriate forum for asking support questions. Your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php Thank you for your interest in PHP. Previous Comments: ------------------------------------------------------------------------ [2002-09-25 14:19:11] [EMAIL PROTECTED] We just upgraded our PHP from 4.0.6 to 4.2.3. I use phpMyAdmin to manage our MySQL database. Since the upgrade, when I try to upload a data file to be inserted into the database, I get the following error: ~~~~~~~~~~~~~~~~~~~~~~~~~ Error SQL-query : LOAD DATA LOCAL INFILE '/tmp/phpgAIpye' REPLACE INTO TABLE `customers` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' MySQL said: The file '/tmp/phpgAIpye' must be in the database directory or be readable by all Back ~~~~~~~~~~~~~~~~~~~~~~~~~~~ Has PHP changed its file upload permissions? Mysql server runs as the user 'mysql' and PHP under 'apache'. Apparently the file upload is creating the temporary file with sole access rights (only owner has any access). I need to make it set permissions so that either (1) the 'mysql' owner or the 'apache' group can access these files or (2) that everyone as read access. This only seems to happen with a direct MySQL data file upload. (LOAD DATA INFILE...) Is this possible? ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=19602&edit=1
