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
> that variable using both SetEnv and PerlSetEnv. Any help would be
> appreciated! Thanks.
If you're using DBD::Oracle 1.06, you can find the steps to follow on the
DBI users archive (links on http://www.symbolstone.org/technology/perl/DBI/)
and look for ldconfig or something similar - the question has turned to a
FAQ on that list, so there is no shortage of help on how to set
LD_LIBRARY_PATH properly...
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
HTH
--Geoff
>
> Daniel Hutchison
> Target Analysis Group
> mailto:[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>
> 617.583.8411
>
