Re: connecting to DBI::Oracle from web pages

From: Joe Edwards <cleanh2o_at_cleanh2o.com>
Date: 2000/07/26
Message-ID: <Pine.LNX.4.05.10007262236400.9457-100000@cleanh2o.com>#1/1

You could set your environment variables when you fire off a cgi as reported by another.
You could also set your environment for oracle in your apache httpd.conf fiele like so:

SetEnv ORACLE_SID <oradb_name>
SetEnv ORACLE_BASE /u01/app/oracle
SetEnv ORACLE_HOME /u01/app/oracle/product/8.1.6

SetEnv LD_LIBRARY_PATH /u01/app/oracle/product/8.1.6/lib

On Wed, 26 Jul 2000 kehleyr678_at_my-deja.com wrote:
> Hello,
> I have an Oracle 8 Enterprise server and an Apache Web serevr running or
> Red hat Linux. I have a script which connects to the database through
> DBI and performs a select. From the command line this works perfectly,
> but from the Web page it does not. It stops right after the
> $dbh->connect statement.
> I have cheched the logs and there is some strange message saying:
> "install_driver(Oracle) failed: Can't load
> '/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/Oracle/Oracle.so'
> for module DBD::Oracle: libclntsh.so.1.0: cannot open shared object
> file: No such file or directory at
> /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169, <CONFIG> chunk
> 3.
> at (eval 1) line 3
> Perhaps a required shared library or dll isn't installed where expected
> "
> I have no Dynaloader.pm file, and neither do I have a i386-linux flder
> under 5.00503.
> What should I do?? Thnx!

-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-

The keeper of the Wastewater Engineering Virtual Library (WWEVL) the WWEVL URL == http://www.cleanh2o.com/ -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*- Received on Wed Jul 26 2000 - 00:00:00 CDT