I am setting in place an Apache Web server and I want to get access to a
remote Oracle 8 database.
Here are the step I did
1) I set up Linux RedHat 7.3 (Kernel 2.4.18-3
2) I updated OS through RHN (Kernel 2.4.18-17.7.x)
3) I installed Oracle Client 8.1.5 for Linux in /home/oracle (user:
oracle, group: oracle)
4) I Installed Apache 2.0.43
5) I Installed Perl 5.8.0
6) I updated CPAN (v.1.63)
7) I installed DBI from cpan and run the test successfully
8) I Installed DBD::Oracle from cpan and run test successfully
9) I ran tests (DBI and DBD) successfully with perl command as root
10) I wrote down a little perl to connect Database, select a row and
print a field
11) I ran this perl as root [perl ora_check.pl] and everything run fine
12) I ran this perl as user apache (And I get this kind of messages)
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: libclntsh.so.8.0: cannot open shared object
file: No such file or directory at
/usr/local/lib/perl5/5.8.0/i686-linux/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /var/www/cgi-bin/ora_check.pl line 13
13) Did i missed something????? why does it work when run as root and
not as Apache ?
14) I have the same messages while running this perl script from APACHE
web server
15) Did i need to change some parameter for the compiler when I compile
perl 5.8.0?
Thank you for helping me
Armand Brisson,
Newbie in PERL, APACHE, DBI, DBD
--------------080600070308090608020703
Content-Type: text/html; charset=ISO-8859-15
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
</head>
<body>
<title></title>
<title></title>
<title></title>
I am setting in place an Apache Web server and I want to get
access
to a remote Oracle 8 database.<br>
<br>
<font color="#ff0000">1)</font> I set up Linux RedHat 7.3 (Kernel
2.4.18-3<br>
<font color="#ff0000">2</font>) I updated OS through RHN (Kernel
2.4.18-17.7.x)<br>
<font color="#ff0000">3)</font> I installed Oracle Client 8.1.5 for Linux
in /home/oracle (user: oracle, group: oracle)<br>
<font color="#ff0000">4) </font>I Installed Apache 2.0.43<br>
<font color="#ff0000">5) </font>I Installed Perl 5.8.0<br>
<font color="#ff0000">6)</font> I updateed CPAN (v.1.63)<br>
<font color="#ff0000">7)</font> I installed DBI from cpan and run the
test
successfully<br>
<font color="#ff0000">8)</font> I Installed DBD::Oracle from cpan and run
test successfully<br>
<font color="#ff0000">9)</font> I ran tests (DBI and DBD) successfully
with
perl command as root<br>
<font color="#ff0000">10)</font> I wrote down a little perl to connect
Database,
select a row and print a field<br>
<font color="#ff0000">11)</font> I ran this perl as root [perl
ora_check.pl]
and everything run fine<br>
<font color="#ff0000">12)</font> I ran this perl as user apache (And I
get
this kind of messages)<br>
<br>
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: libclntsh.so.8.0: cannot open shared object file:
No such file or directory at
/usr/local/lib/perl5/5.8.0/i686-linux/DynaLoader.pm
line 229.<br>
?at (eval 1) line 3<br>
Compilation failed in require at (eval 1) line 3.<br>
Perhaps a required shared library or dll isn't installed where
expected<br>
?at /var/www/cgi-bin/ora_check.pl line 13<br>
<font color="#ff0000"><br>
13)</font> Did i missed something????? why does it work when run as root
and not as Apache ?<br>
<font color="#ff0000">14)</font> I have the same messages while running
this perl script from APACHE web server<br>
<font color="#ff0000">15)</font> Did i need to change some parameter for
the compiler?<br>
<br>
<br>
<br>
<br>
Thank you for helping me<br>
<br>
Armand Brisson,<br>
Newbie in PERL, APACHE, DBI, DBD<br>
<br>
</body>
</html>
--------------080600070308090608020703--
