PHP file works from command line but not from web

pablogosse

Hi all. I've got a PHP file which is accessing an Oracle database.

If I run the file from the command line ( [gossep@dyn105 html]$ php ora_test.php ) it works fine, and all the html code that is generated is printed to my terminal.

However, if I try to access it via the web (http://pablo.unbc.ca/ora_test.php) all I get is the following, which is output by the ADOdb debugging:
code: select table_name from cat where table_type in ('TABLE','VIEW')[/code]The output that I expect to receive (and which I do receive when it's executed from the command line) is this:

http://pablo.unbc.ca/results.html

Does anyone have any idea why it works from the command line, but all I get when I access it via a browser is the info about the first query executed? A page which simply echos phpinfo() works fine either through the command line or a browser.

Thoughts?

Thanks in advance,
Pablo

Bunkermaster

are ORACLE environment variables set in user used to run PHP?

pablogosse

Hmmmmm, that's a very good question. I know Tom, my sysadmin, had me set some oracle environment variables for my user, but I'm pretty sure that php will be running under user apache, not gossep (where oracle is installed) so that might well be it.

Thanks for the tip. I'll have Tom give it a whirl tomorrow (I have root access but I don't think I can set the variables for another user without that password) and see if it works.

Thanks.

pablogosse

Actually, I just had a thought. If the Oracle environment vars weren't set to run under php, then the script wouldn't work from the command line either, would it?

Right now it works from the command line but not the web.

Thanks again.

Bunkermaster

when u run something from command line, it runs under your current user with all it's current info (on windows environment variables and the registry are always a tricky one when u setup something under your account and run it as a service or under a service)
You might want to check your environment variables through a PHP script and check if you've got the same value set.

Oh and you also might want to delete your first unanswered post if it refers to the same issue 😃

pablogosse

Heh heh. It sort of referred to the first issue, but when I realized that it worked from the command line but not from the web, that changed what I thought was causing it.

How do I delete old posts?

Thanks,
Pablo.

Bunkermaster

Originally posted by pablogosse
How do I delete old posts?

Good question. Thanks for asking.

😕

LOL

Btw did it work with env vars change?

pablogosse

Bunkermaster, you rock!

I checked the environment variables and ORACLE_HOME had been set to /home/gossep/, but the permissions on said directory did not allow the user PHP runs as to access it.

chmod 755 /home/gossep/ and everything works fine.

'Course, this kind of pissed Tom off as he'd spend the better part of two days trying to figure this out ;o)

Thanks again. If you're ever in Prince George I'll buy you a beer (or two).