I already had set variables in my hhtpd.conf (Virtual hosts directive) without any success and this is why i am trying to debug as typing script from a Unix users.
I can loog as Root and run my script that connect to remote Oracle smoothly and properly
I can log as Oracle and run my script that connect to remote Oracle smoothly and properly
But i cannot run the scritp as any other users.
I have created another user and copy the .bashrc and .bash_profile from Oracle to set same kind of environment
I logged as this user but still cannot run the script.... Losing my hairs now....
Armand Brisson
Jeff Urlwin wrote:
It seems to be you using two different versions of perl. It isI didn't see that issue, but read the FAQ. Hint: Environment
standard on a
huge of linux platforms. Try to change the usere probertys ( hm, somewhere
in the $HOME I think ). To find out the versions try a 'whereis perl'.
Take a look in the /etc/httpd/conf ( or where apache.conf /
httpd.conf is on
your system ) and teach it to use /usr/bin/perl and not perl_mod or else.
See the DBI FAQ at www.xmlproj.com/cgi/fom.cgi
Hope this helps.
Best regards,
Kris wolff
Www.intra-team.de
On 04.11.2002 8:25 Uhr, "Armand Brisson" <[EMAIL PROTECTED]>
wrote:
I am setting in place an Apache Web server and I want to get access to a'/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/Oracle/O
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
racle.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?
