RE: DBD module loading problem

---------------------------------------------------------------------
From: Kevin Moore [mailto:kmoore@xxxxxxxxxxx]
Sent: Sun 4/23/2006 12:15 AM
To: dbi-users@xxxxxxxx
Subject: DBD module loading problem


Objective - execute perl modules from apache that access an oracle
database

Oracle database - 10gr2, SUSE SLES9 linux
Apache server - RHAS 4.0, oracle 10gr2 instant client

Perl Version
perl -v
This is perl, v5.8.5 built for i386-linux-thread-multi

Apache Version
apachectl -v
Server version: Apache/2.0.55
Server built: Feb 28 2006 10:15:42

mod_perl, DBI, DBD versions

mod_perl -2.0.2
DBI-1.50
DBD-Oracle 1.17
Apache DBI-0.9901

Error when running perl module from apache error_log file

[Sat Apr 22 20:48:04 2006] emahni.pl: install_driver(Oracle) failed:
Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-
multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libnnz10.so:
cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-
multi/DynaLoader.pm line 230.

ORACLE_HOME, LD_LIBRARY_PATH ($ORACLE_HOME/lib), TWO_TASK, and
LD_RUN_PATH($ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib) set in httpd.conf

Have you added PassEnv and PerlPassEnv directives for all of these
variables?

You'll need them for things to work right. See:
http://tinyurl.com/kunxp [httpd.apache.org]
http://tinyurl.com/jr7dw [perl.apache.org]

hth,
Philip


Relevant Pages