httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pete Nelson" <>
Subject Re: [users@httpd] CGI problem running Oracle sqlplus
Date Wed, 08 Jan 2003 15:07:53 GMT
Some shell-based applications do not like being called from a CGI /
server process.  I'm not sure if that's what's happening here, but I
know I have run into that issue with other executable shells.  Some
shells require certain terminal information, which is not available from
a CGI.  Some simply require a lot of overhead and memory, which might
(not 100% sure here) cause the CGI to give up.

But what I'm more curious about is why you're using sqlplus, instead of
one of the Oracle drivers in perl, php, java, etc.  Depending on what
you are trying to achieve, there may be an easier, more efficent way of
doing it that would completely avoid the problem you're seeing.  What
language are you using for your CGI?

Pete Nelson, Web Developer

>>> 01/08/03 08:52AM >>>
I have a cgi script which calls Oracle's sqlplus to run a sql script. 
I run the cgi script from the command prompt (logged in as the apache
the sqlplus call gets executed properly; when I run it from a web page,
sql script never gets errors, no anything.  I'm thinking
this is a permission issue.

Here is what I've tried:  I created a new user named "apache" and I set
user variable in the httpd.conf to this new user.  I created a profile
this new user that has the path point to sqlplus.  I then restarted
but the problem still exists.

Any ideas on what I'm doing wrong?  Thanks,

The official User-To-User support forum of the Apache HTTP Server
See <URL:> for more info.
To unsubscribe, e-mail:
   "   from the digest:
For additional commands, e-mail:

View raw message