topic Re: Perl DBD::Oracle - Got it working except... in Operating System - HP-UX

Perl DBD::Oracle - Got it working except...

JR Kirkwood — Thu, 19 Dec 2002 17:55:31 GMT

Ok. I've read through the many excerpts and finally got DBD::Oracle 1.12 installed on my system. At least I think so...

I created a test script to verify that I could connect, etc. It works great when I run it for the 'root' account, but gives me the following error when I run from any other user (mainly testing from web user www).

install_driver(Oracle) failed: Can't locate loadable object for module DBD::Oracle in @INC (@INC con
tains: /opt/perl/lib/5.8.0/PA-RISC2.0 /opt/perl/lib/5.8.0 /opt/perl/lib/site_perl/5.8.0/PA-RISC2.0 /
opt/perl/lib/site_perl/5.8.0 /opt/perl/lib/site_perl .) at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a module that DBD::Oracle requires hasn't been fully installed
at ./test.pl line 10
###############################################
Line 10 is the following connect:

$dbh = DBI->connect('dbi:Oracle:QUEPLIX','username','password');

I am running Perl 5.8.0 (installed from https://www.beepz.com/personal/merijn/), DBI 1.30 and DBD:Oracle 1.12.

This system is running HPUX 11i 64bit.

Has anyone seen this before? I've looked to see if it is a file permission problem somewhere, but can't find anything obvious.

Thanks in advance,

JR

Re: Perl DBD::Oracle - Got it working except...

Vincent Stedema — Thu, 19 Dec 2002 20:07:32 GMT

Hi,

Is the PERL5LIB environment variable the same for users root and www?

Regards,

Vincent

Re: Perl DBD::Oracle - Got it working except...

JR Kirkwood — Thu, 19 Dec 2002 20:16:35 GMT

Vincent,

Thanks but I just found the problem. It was a file permission. Apparently the DBD::Oracle install didn't set all of the permissions correctly.

After changing them manually it is now working for all users.

Thanks for the response!

JR

Re: Perl DBD::Oracle - Got it working except...

Steven Yaskin — Sun, 02 Feb 2003 03:22:53 GMT

I understand this has been resolved? JR, youc an direct any kinds of questions relating to the QueWeb system to Queplix. Thanks. Just wanted to make sure this was resolved.

Steve Yaskin.

Re: Perl DBD::Oracle - Got it working except...

michal_7 — Wed, 19 Feb 2003 10:42:12 GMT

Hi JR

I HAVE THE SAME PROBLEM U HAD.
PLS LET ME KNOW WHAT DID U DO??
WHAT PERMISSION DID U CHANGE?? OF WHICH FILE???

THANKS
MICHAL
michaly@adit-tec.com

Re: Perl DBD::Oracle - Got it working except...

Jo Davis — Wed, 26 Nov 2003 10:24:08 GMT

I had this same problem but fixed it by setting the SHLIB_PATH and the LD_LIBRARY_PATH environment variables.