Geoff / Daniel,
this is in ref. to your emails (as given below) in the "mod_perl" users group.
I am going through the same errors in my error_log ie
getting:
Use of inherited AUTOLOAD for non-method DBD::Oracle::ORA_OCI() is deprecated at
/oracle/product/9iAS/Apache/perl/lib/site_perl/5.005/PA-RISC2.0-thread/DBD/Oracle.pm
line 48.
when I try to connect to oracle from aperl program from the web using DBD::Oracle
(1.0.3 as wel as DBD 1.0.6)
and I have no problem connecting to oracle when I run the perl program from thw shell
(command line)
It looks like you are on linux platform, and in my case I am on hp-ux 11.0 box. I am
not sure if Daniel is also on linux box or some other box.
I have also tried as follows but that does not help in my case
the short answer/path is to edit DBD::Oracle Makefile.PL and build it again
-$::opt_b = 1; # try to use Oracle's own 'build' rule
+$::opt_b = 0; # try to use Oracle's own 'build' rule
Question:
I would appreciate to know if there is some thing I am missing or if this is some bug
in DBD:Oracle (1.03/1.0.6) on HP-UX or any other information that can help me
resolve/workaround this problem.
thanks
Arun
To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: DBD-Oracle and mod_perl
From: Geoffrey Young [EMAIL PROTECTED]
Date: Wed, 26 Jul 2000 08:27:06 -0400
Delivered-To: [EMAIL PROTECTED]
Delivered-To: mailing list [EMAIL PROTECTED]
list-help: mailto:[EMAIL PROTECTED]
list-post: mailto:[EMAIL PROTECTED]
list-unsubscribe: mailto:[EMAIL PROTECTED]
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
hi everyone...
I was just wondering if anyone has been able to get the newer releases of
DBD-Oracle to work under mod_perl?
that is, using DBD-Oracle 1.04, 1.05, and 1.06, under perl 5.005 (RH6.0
standard) and DBI-1.14 I get consistently non-working results, but only when
running under mod_perl. If I revert to 1.03, all is fine again...
I was getting these errors before the conference, but wanted to investigate
further. Yesterday I rolled my own perl 5.6 ( with -Dusethreads) and
rebuilt everything, mod_perl, DBI, DBD::Oracle, etc. Still the same
results...
basically, I get the following errors on a simple connect and 'select
sysdate from dual':
use DBD::Oracle;
# results in:
# Can't load
'/usr/local/lib/perl5/site_perl/5.6.0/i686-linux-thread-multi/auto/DBD/Oracl
e/Oracle.so' for module DBD::Oracle: libclntsh.so.1.0: cannot open shared
object file: No such file or directory at
/usr/local/lib/perl5/5.6.0/i686-linux-thread-multi/DynaLoader.pm line 200.
at /usr/local/apache/perl-bin/dbtest.pl line 9
letting DBI load DBD::Oracle itself, my trace looks like this:
DBI 1.14-nothread dispatch trace level set to 6
- DBI-connect(dbi:Oracle:HELM, www, , HASH(0x86e040c))
- DBI-install_driver(Oracle) for perl=5.006 pid=3393 ruid=99 euid=99
and that's all, but the script manages to release control of the phase,
because I use a cleanup handler to log to (a different) database, which then
gets:
- DBI-connect(dbi:Oracle:PORTAL, porter, , HASH(0x8480178))
- DBI-install_driver(Oracle) for perl=5.006 pid=3393 ruid=99 euid=99
install_driver: DBD::Oracle loaded (version 1.06)
Use of inherited AUTOLOAD for non-method DBD::Oracle::ORA_OCI() is
deprecated at
/usr/local/lib/perl5/site_perl/5.6.0/i686-linux-thread-multi/DBD/Oracle.pm
line 48.
Use of uninitialized value.
of course, the same script running from shell runs just fine (with the three
mod_perl related lines removed, of course), both use()ing DBD::Oracle and
without.
anyway, it's probably just me. I don't have a problem with DBD::Oracle 1.03
so it's no biggie but I wanted to point it out, just in case...
--Geoff
-Original Message
-
From: Daniel Hutchison [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 22, 2000 2:16 PM
To: [EMAIL PROTECTED]
Subject: DBD-Oracle
I just transplanted our website from a computer that had only Net8
installed, to a computer that has an entire Oracle Database
installed. As
far as I can tell I otherwise fully replicated the original
system on the
new machine.
These errors are appearing in error_log:
[Sun Oct 22 14:03:49 2000] Carp.pm: Use of uninitialized value at
/usr/local/lib/perl5/5.6.0/Carp.pm
line 119.
[Sun Oct 22 14:03:49 2000] Carp.pm: Use of inherited AUTOLOAD
for non-method
DBD::Oracle::ORA_OCI() is
deprecated at
/usr/local/lib/perl5/site_perl/5.6.0/i686-linux/DBD/Oracle.pm line 48.
I've done a search on the web that return this that seems to
indicate the
AUTOLOAD error has something to do with LD_LIBRARY_PATH, but
my I have set