On Jul 1, 2009, at 12:20, Shawn McKenzie wrote:
Shawn McKenzie wrote:
Mari Masuda wrote:
Hello,
This is probably a dumb newbie question. I am running PHP
5.2.5 and
Apache 2.2.8 on my Mac Book Pro OS X 10.4.11. I compiled PHP and
Apache
from source a while ago (as opposed to using the built-in web
server
that is included w/ Mac OS X). I have written the below PHP whose
purpose is to read an existing comma separated (CSV) file and
save the
data into a text file that I can later copy and paste from into my
website content management system. The problem is that on my
Mac, I
cannot seem to figure out what permissions I need to set in
order to
make the input CSV and the initially non-existant output text file
readable and writable by Apache/PHP. I have Googled and come
across
many pages about different ways to set permissions and different
permissions to set but none of the ways suggested that I tried
seemed to
work for me. As a temporary solution, I uploaded my PHP file to a
Windows 2003 server running Apache and PHP and it worked
flawlessly
(and
makes me suspicious that there is some huge security hole with the
Windows box since it was able to execute with no permissions
modifications). Any tips would be greatly appreciated. Thanks!
Mari
--- start my code ---
<?php
$in = fopen("/Applications/apache/htdocs/wp-php/wp.csv", "r");
$out =
fopen("/Applications/apache/htdocs/wp-php/tableToCutAndPaste.txt",
"w");
$counter = 0;
fwrite($out, "<table>\n");
while(($data = fgetcsv($in)) !== FALSE) {
$paperNumber = $data[0];
$authors = $data[1];
$title = $data[2];
$filename = $paperNumber . ".pdf";
if(($counter % 2) == 0) {
fwrite($out, "<tr>\n");
} else {
fwrite($out, "<tr style=\"background: #cccccc;\">\n");
}
fwrite($out, "<td><a
href=\"http://www.example.com/workingpapers/getWorkingPaper.php?
filename=$filename\">$paperNumber</a></td>\n");
fwrite($out, "<td>$authors</td>\n");
fwrite($out, "<td>$title</td>\n");
fwrite($out, "</tr>\n");
$counter++;
}
fwrite($out, "</table>\n");
fclose($in);
fclose($out);
?>
--- end my code ---
What are the permissions on /Applications/apache/htdocs/wp-php/ ?
Apache needs write permissions on that dir in order to create
the file
tableToCutAndPaste.txt.
It's probably not a secure idea to give write permissions to
that dir,
so maybe create a subdir of tmp and change those permissions
(one way):
mkdir /Applications/apache/htdocs/wp-php/tmp
chmod a+w /Applications/apache/htdocs/wp-php/tmp
Also, turn on error reporting so that you can see the exact
problem. It
may not be what you think.
--
Thanks!
-Shawn
http://www.spidean.com
Thanks for the suggestions. I added the following lines to the
very top
of my code:
error_reporting(E_ALL);
mkdir("/Applications/apache/htdocs/wp-php/tmp", 0777, true);
chmod("/Applications/apache/htdocs/wp-php/tmp", "a+w");
and I also changed the line where it tries to open the file to
write to
to go to the new directory:
$out =
fopen("/Applications/apache/htdocs/wp-php/tmp/
tableToCutAndPaste.txt",
"w");
Below are the errors I got:
--- start errors ---
Warning: mkdir() [function.mkdir]: Permission denied in
/Applications/apache/htdocs/wp-php/generateTable.php on line 5
Warning: chmod() [function.chmod]: No such file or directory in
/Applications/apache/htdocs/wp-php/generateTable.php on line 6
Warning:
fopen(/Applications/apache/htdocs/wp-php/tmp/tableToCutAndPaste.txt)
[function.fopen]: failed to open stream: No such file or directory in
/Applications/apache/htdocs/wp-php/generateTable.php on line 9
Warning: fwrite(): supplied argument is not a valid stream
resource in
/Applications/apache/htdocs/wp-php/generateTable.php on line 13
Warning: fwrite(): supplied argument is not a valid stream
resource in
/Applications/apache/htdocs/wp-php/generateTable.php on line 22
Warning: fwrite(): supplied argument is not a valid stream
resource in
/Applications/apache/htdocs/wp-php/generateTable.php on line 27
Warning: fwrite(): supplied argument is not a valid stream
resource in
/Applications/apache/htdocs/wp-php/generateTable.php on line 28
Warning: fwrite(): supplied argument is not a valid stream
resource in
/Applications/apache/htdocs/wp-php/generateTable.php on line 29
Warning: fwrite(): supplied argument is not a valid stream
resource in
/Applications/apache/htdocs/wp-php/generateTable.php on line 30
Warning: fwrite(): supplied argument is not a valid stream
resource in
/Applications/apache/htdocs/wp-php/generateTable.php on line 35
Warning: fclose(): supplied argument is not a valid stream
resource in
/Applications/apache/htdocs/wp-php/generateTable.php on line 39
--- end errors ---
The permissions are as follows (sorry I didn't think to include
them in
my original message):
[Wed Jul 01 12:28:29] ~: ls -la /Applications/apache/htdocs/wp-php/
total 64
drwxr-xr-x 5 mari admin 170 Jun 29 16:47 .
drwxr-xr-x 24 mari admin 816 Jun 29 16:47 ..
-rw-r--r-- 1 mari admin 6148 Jun 28 21:11 .DS_Store
-rwxr--r-- 1 mari admin 827 Jul 1 12:26 generateTable.php
-rwxr--r-- 1 mari admin 17532 Jun 28 20:53 wp.csv
[Wed Jul 01 12:29:01] ~:
Thank you,
Mari
