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

[JR Kirkwood]

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

[Vincent Stedema]

Hi,

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

Regards,

Vincent

[JR Kirkwood]

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

[Steven Yaskin]

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.

[michal_7]

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

[Jo Davis]

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