Re: Example file works on command line but not in browser

ykiran — Fri Feb 20, 2009 6:51 am

Author: ykiran

Posted: Fri Feb 20, 2009 6:51 am

mark wrote:

You need to add /var/www/html/ to the open_basedir setting.

Mark, thanks for the reply.
But, as soon as i did that i got the following error:

Quote:

Warning: require_once(Spreadsheet/Excel/Writer.php) [function.require-once]: failed to open stream: No such file or directory in /var/www/html/excel.php on line 10

Fatal error: require_once() [function.require]: Failed opening required 'Spreadsheet/Excel/Writer.php' (include_path='.:/home/kiran/PEAR') in /var/www/html/excel.php on line 10

This is how my open_basedir looks:

Code:

open_basedir = /usr/lib/php:/home/kiran/PEAR:/home/kiran/PEAR/temp:/var/www/html/

Re: Example file works on command line but not in browser

mark — Thu Feb 19, 2009 6:07 pm

Author: mark

Posted: Thu Feb 19, 2009 6:07 pm

You need to add /var/www/html/ to the open_basedir setting.

Example file works on command line but not in browser

ykiran — Thu Feb 19, 2009 2:10 pm

Author: ykiran

Posted: Thu Feb 19, 2009 2:10 pm

Hi,
i have an example file containing the following code:

Code:

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
# echo " including component...";
require_once 'Spreadsheet/Excel/Writer.php';
#echo " Finished including.";

#echo " Creating a workbook";
$workbook = new Spreadsheet_Excel_Writer();
#echo " sending HTTP headers...";
$workbook->send('test.xls');
// Creating a worksheet
$worksheet =& $workbook->addWorksheet('My first worksheet');

// The actual data
$worksheet->write(0, 0, 'Name');
$worksheet->write(0, 1, 'Age');
$worksheet->write(1, 0, 'John Smith');
$worksheet->write(1, 1, 30);
$worksheet->write(2, 0, 'Johann Schmidt');
$worksheet->write(2, 1, 31);
$worksheet->write(3, 0, 'Juan Herrera');
$worksheet->write(3, 1, 32);

$tempdir = "/home/kiran/PEAR/temp";

echo " $tempdir ";

if (!empty($tempdir)) {
$workbook->setTempDir($tempdir);
}
// Let's send the file
$workbook->close();
?>

The thing is it runs without any error when running from the command line:

Quote:

php /path/to/file/excel.php

But, when i do the same using a browser: http://127.0.0.1/excel.php

There were errors in the Apache log:

Quote:

[Fri Feb 20 00:49:53 2009] [error] [client 127.0.0.1] PHP Warning: Unknown: open_basedir restriction in effect. File(/var/www/html/excel.php) is not within the allowed path(s): (/usr/lib/php:/home/kiran/PEAR:/home/kiran/PEAR/temp) in Unknown on line 0
[Fri Feb 20 00:49:53 2009] [error] [client 127.0.0.1] PHP Warning: Unknown: failed to open stream: Operation not permitted in Unknown on line 0
[Fri Feb 20 00:49:53 2009] [error] [client 127.0.0.1] PHP Warning: Unknown: Failed opening '/var/www/html/excel.php' for inclusion (include_path='.:/home/kiran/PEAR') in Unknown on line 0

What am i doing wrong here?

I am running PHP 5.2 and PEAR with Excel-Spreadsheet writer on Redhat.

PEAR Forum

Re: Example file works on command line but not in browser

Re: Example file works on command line but not in browser

Example file works on command line but not in browser