PHP CGI and ORACLE (urgent)

andres_garcia

Hi!!!

I was working with php 4.2.2 as a module of apache, and connecting to oracle just fine. But now, i need to work with mapserver (a gis program that only works with php as CGI).

So I compiled PHP to work as cgi and is working, but the connection with oracle is not working any more!! I get the ORA-12154 error.

I think that the error is because PHP (or Apache) is not accessing the environment variables (where i set ORACLE_HOME and ORACLE_SID). I know this becuase when i do a simple "phpinfo", the ORACLE variables aren`t in the environment section, but when i run PHP as a module, that variables are there (in the environment section).

If you know how to solve the problem please reply. How can i tell to Apache or PHP that read the envornment variables???

I really need to connect to oracle as CGI!

matto

yes I had that problem with a cronjob regarding php-cgi and oracle (a daily db import).

an easy remedy for unix/linux:
edit your .bashrc, copy the oracle sid etc. variable settings.

put this section into your crontab file (when using cronjobs), or have it executed at the beginning of the script; this should work, too.

I have done it with cronjobs only so far but I think you should be able to set these environment variables from within the script as well ... perhaps another reader knows more details on this.

svnfightsvn

Try this:

Before you make your database call in your script, check for the existence of the variables. If not found, set them - like this:

if (! getenv("ORACLE_HOME"))
{
	putenv("ORACLE_HOME=your_home");
}
if (! getenv("ORACLE_SID"))
{
	putenv("ORACLE_SID=your_sid");
}

andres_garcia

I solved the problem by myself:

Reading the apache http documentation i found that i can set enviroment variables in the httpd.conf using the instrucion SetEnv [name] [value]

Now everithing is working just fine.

an easy remedy for unix/linux:
edit your .bashrc, copy the oracle sid etc. variable settings.

put this section into your crontab file (when using cronjobs), or have it executed at the beginning of the script; this should work, too.

That didn't work for some reason!!!, but thanks anyway