what I understand is that the LD_LIBRARY_PATH must be set within the profile
of the user under which the web server is running, and not in the perl %ENV
hash. I think you can edit the .profile of whatever user is running the web
server to add or export that ENV variable.
That is the next issue I need to deal with in my endeavours and I will
certainly let you know the outcome ;)
Hugh J. Hitchcock
Programmer / Developer
> -----Original Message-----
> From: Modi Ketan-G17361 [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 25, 2001 8:49 PM
> To: '[EMAIL PROTECTED]'
> Subject: Can't run Oracle from cgi script from Browser using DBI
>
>
> Hi
>
> This is the first time I am using the dbi users group.
>
> Before reporting this problem I surf the web a lot and understand
> that so many users has similar problems.
>
> I tried to use the suggestions mentioned and still I am stuck.
>
> My problem is I use BEGIN block in .cgi script to setup
> ORACLE_HOME,LD_LIBRARY_PATH & PATH env. variables.
>
> Now I am trying to use dbi module and it is not working from browser.
>
> I also head .pl version of script which is working fine from
> Solaris 2.6 command prompt.
>
> My web server is Netscape Enterprise.
>
> I also learned about "nobody" webserver user when you start the
> webserver. I also learnt that we can specify the LD_LIBRARY_PATH
> in the shell of webserver. Frankly speaking I don't know how to
> do that and neither do I get web expertise within my department.
>
> I attached herewith the cgi script.
>
>
> I appreciate your help.
>
>
> Thanks
>
> Ketan
> <<hello_1.cgi>>
>