[EMAIL PROTECTED] wrote:
> Hi all. I think I have some sort of permissions problem here i'm
> hoping to get help for.
>
> I'm running apache on HP-UX. I have a perl script that accesses a
> database (local) and displays the results in a HTML table format.
> Pretty simple. I've done lots of database scripting before so i
> figured this should be nothing new. Well, when I run it from the
> command line it runs fine, displaying the html output with the
> database records like it should. HOWEVER, when i put said script in
> my cgi-bin and access it with a web browser I get a database connect
> error. Basically the DBI->connect() is failing.
What's the error?
>
> Since it runs fine from the command line and fails when run through
> apache i figure it's got to be some sort of permissions thing. Or
> something else fairly simple (hopefully). What user does apache run
> scripts as?
>
> Any other ideas?
Set ORACLE_HOME (and possibly ORACLE_SID) in your script:
BEGIN {
$ENV{ORACLE_HOME} = '/path/to/oracle/home';
$ENV{ORACLE_SID} = 'mydb';
}
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
