oracle spatial and mapserver problem

[Stephen Woodbridge]

Hi,

I have gotten it to wor with a small sh script:

cat /usr/lib/cgi-bin/mapserv410a
#!/bin/sh
export TNS_ADMIN=/home/swoodbridge/.oracle/
export ORACLE_HOME=/home2/oracle/cl10/
export LD_LIBRARY_PATH=/home2/oracle/cl10/lib/
/usr/lib/cgi-bin/mapserv410 $*

I believe apache does not pass the LD_LIBRARY_PATH to the child process 
so you migh try setting it explicitly or using a shell script like the 
above.

-Steve W

joydip wrote:
> I am also getting the same error under RedHat. Any help. Regards, JS
> 
>     Jochem Prins wrote:
>     Dear all, for some time i have been playing with UMN mapserver on a
>     Fedora Core 4 i386 computer and manage to compile both ogr/gdal and
>     UMN mapserver from source without Oracle Spatial. However for an
>     assignment I got to make use of Oracle Spatial and shapefiles in
>     combination with the mapserver. So far I manage to get everything I
>     need to compile correctly without any weird errors. After
>     installation of gdal/ogr and mapserver I attempt to test the
>     mapserver by trying to query the mapserver by going to
>     http://192.168.1.179/cgi-bin/mapserv. This gives me the 500 internal
>     server error. When I view Apache's error log it says:
>     /var/www/cgi-bin/mapserv: error while loading shared libraries:
>     libclntsh.so.10.1: cannot open shared object file: No such file or
>     directory Now I do know that this is related to some of the
>     libraries that Oracle uses. I attempted several things to resolve
>     this problem: - added the $ORACLE_HOME/lib to /etc/ld.so.conf and
>     tried reloading by issueing ldconfig - added $ORACLE_HOME and
>     $LD_LIBRARY_PATH to Apache's configuration file http.conf - I also
>     checked if the problem was user rights related, but that doesn't
>     seem to be the problem. Currently I am stuck and would really
>     appreciate any help on this matter. Jochem Prins -- GMX Produkte
>     empfehlen und ganz einfach Geld verdienen! Satte Provisionen für GMX
>     Partner: http://www.gmx.net/de/go/partner
> 
> 
> View this message in context: Re: oracle spatial and mapserver problem 
> <http://www.nabble.com/oracle-spatial-and-mapserver-problem-tf1449985.html#a9883537>
> Sent from the Mapserver - User mailing list archive 
> <http://www.nabble.com/Mapserver---User-f1215.html> at Nabble.com.