Mari Masuda wrote:
> 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
That's because the apache user doesn't have permissions to create the
dir or change the permissions. The commands I gave you need to be run
from the command line.
--
Thanks!
-Shawn
http://www.spidean.com
|