Problems installing DBI
From: Ben (bhebert_at_borabora.crchul.ulaval.ca)
Date: 01/19/04
- Previous message: Tim Bunce: "Re: Can't make DBD"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 19 Jan 2004 14:14:55 -0800
Hello.
I have installed both Bundle::DBI and DBD::Oracle on a Sun Solaris 8
machine. The Oracle 9i database is installed on a remote server.
The test script I developed works just fine as root, but fails
miserably as non-root. Here is the script:
#!/usr/bin/perl -w
use DBI;
($user, $pass) = @ARGV;
$dbi = DBI->connect('dbi:Oracle:host=tahiti.crchul.ulaval.ca;sid=murin;port=1521',
$user, $pass);
$sel=$dbi->prepare("select SYSDATE from dual");
$sel->execute || die "Probleme de selection ";
while (($champ)=$sel->fetchrow_array) {
print "$champ\n";
}
$sel->finish;
$dbi->disconnect;
The execution as root:
@proteo/export/home/hebben01>perl test.pl **username** **password**
14-JAN-04
and as a normal user:
@proteo/export/home/hebben01>perl test.pl **username** **password**
Can't locate loadable object for module DBI in @INC (@INC contains:
/usr/local/lib/perl5/5.6.1/sun4-solaris /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .)
at /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/DBI.pm line 252
BEGIN failed--compilation aborted at
/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/DBI.pm line 252.
Compilation failed in require at test.pl line 2.
BEGIN failed--compilation aborted at test.pl line 2.
It does look a lot like I should check permissions on DBI.pm, but they
look fine in every location specified in @INC - everyone can read the
files in those directories.
Can anyone help me?
Thanks!!
~Ben
- Previous message: Tim Bunce: "Re: Can't make DBD"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
