I run a linux webserver with Apache and PHP5. Does anyone out there know why a php script would work from the command line but fail when running it through a web browser? In particular, I'm trying to get a connection to an MSSQL server but PHP fails to connect when I run the script with a web browser. My regular scripts (i.e. ones without any mssql functions) work fine from the browser. When I run the script from the command line, the connection succeeds. Any idea if this is a PHP error or an apache error. If this is an apache error, does anyone know what I need to search for to find an answer? I run the command script as the apache user. Also, when I run the script from the browser, I see no data traffic going to the sql server.

Hi

CLI PHP and Apache's PHP are different. Apache uses mod_php, while your CLI scripts are getting executed with /usr/bin/php, probably.

They _can_ (and quite often do) use different php.ini files. For example, on my Gentoo server:

$ ls /etc/php/*
/etc/php/apache2-php4:
lib php.ini

/etc/php/cli-php4:
php.ini

One thing you might want to try is:

$ diff /etc/php/*/php.ini
495,497c495
< ; allow_url_fopen = On
< ; Closed for security - <[email protected]>
< allow_url_fopen = Off
---
> allow_url_fopen = On

This shows you the difference between the two different php.ini files. On your webserver, the paths are no doubt going to be different. Try:

$ locate php.ini

Hope this helps

--
Please contact me at:
Colin (dot) Horne (at) gmail (dot) com
My blog: http://colinhorne.blogspot.com