#19602 [Opn->Bgs]: File Upload file permissions problem

ID: 19602 Updated by: sander@php.net Reported By: kakins@wmsco.com -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] kakins@wmsco.com 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