Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Perl-Oracle-Apache userid problem

Perl-Oracle-Apache userid problem

From: BB <brennanb_at_houston.rr.com>
Date: Mon, 25 Feb 2002 03:35:35 GMT
Message-ID: <biie8.23062$6j2.1216027@typhoon.austin.rr.com>


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 Received on Sun Feb 24 2002 - 21:35:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US