Re: Perl-Oracle-Apache userid problem

BB wrote:
>
> I'm having a problem trying to access a perl script that is connecting to an
> Oracle 8.1.7 database through Apache. I'm on an AIX UNIX machine, and I
> don't know a whole lot about Oracle (ok, pretty much nothing) but I've
> successfully written Perl scripts to access DB2 and MySQL through a web
> interface on both Apache and IIS.
>
> Here's the problem: I can run the script under my userid from the UNIX
> shell and it access a test table that I setup, but when I try to access the
> page through the browser it doesn't hit the database. I've tried specifying
> my userid explictly through the connect statement but it doesn't work - it
> gives me an invalid userid/password All of the apache httpd daemons are
> started under the oracle userid on the system...the reason I mention that is
> because I'm thinking maybe it has something to do with a user visiting the
> web site and not having the proper authority to access the page, but it
> executes the other general print statements in the perl script.
>
> Thanks,
> BB

What is your environment when executing from Apache? Do you have (minimum)?

1. ORACLE_HOME
2. ORACLE_SID -- Ron Reidy Oracle DBA