Tr: Mapserver and oracle instantclient

[Berend Veldkamp]

Hello Ludovic,

Thanks, this helped a lot. I manually edited Makefile to include:

ORACLESPATIAL_LIB=-L/usr/lib/oracle/10g/client -lclntsh
ORACLESPATIAL_INC=-I/usr/lib/oracle/10g/client/sdk/include

And mapscript/php3/Makefile:

MS_INC =    -I/usr/src/mapserver-4.6.1 
-I/usr/lib/oracle/10g/client/sdk/include -I/usr/local/pgsql/include 
-I/usr/local/include -I/usr/local/include     -I/usr/include
MS_LIBS =   $(RUNPATHS) -L/usr/src/mapserver-4.6.1 -lmap  -L/usr/lib 
-lcurl -L/usr/kerberos/lib -lssl -lcrypto -lgssapi_krb5 -lkrb5 -lcom_err 
-lk5crypto -lresolv -ldl -lz -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err 
-lresolv -L/usr/kerberos/lib -lidn -lssl -lcrypto -lssl -lcrypto 
-lgssapi_krb5 -lkrb5 -lcom_err -lk5crypto -lresolv -ldl -lz -lz 
-L/usr/lib/oracle/10g/client -lclntsh  -L/usr/local/pgsql/lib -lpq 
-ljpeg -lfreetype -lpng -lz   -L/usr/local/lib -lgdal -L/usr/local/lib 
-lgeos    -lproj  -L/usr/lib -lgd -ljpeg -lfreetype -lpng -lz   -lc -lz 
   -lm -lstdc++ $(MS_STATIC)


Now both the mapserv executable and php_mapscript.so compile fine. I 
still need to test, so I might be back soon. Thanks for now.


Berend



ludovic gnemmi wrote:

> I hope it can help you.
> 
> 
> --- ludovic gnemmi <l_gnemmi at yahoo.fr> a écrit :
> 
> 
>>Date: Wed, 8 Jun 2005 17:42:33 +0200 (CEST)
>>De: ludovic gnemmi <l_gnemmi at yahoo.fr>
>>Objet: Mapserver and oracle instantclient
>>À: MAPSERVER-USERS at LISTS.UMN.EDU
>>
>>Maybe it can help someone who
>>doesn't want install the standard Oracle Client to
>>have oraclespatial support. Here is the steps i
>>follow
>>to compile mapserver and php_mapscript on Linux
>>system
>>to have oraclespatial support with oracle
>>instantclient 10g.
>>
>>*Download and install oracle instantclient and
>>instantclient-devel packages.
>>
>>*Adjust LD_LIBRARY_PATH to the instantclient lib
>>directory.
>>
>>*Configure Mapserver with oraclespatial support.
>>
>>*Manually edit Makefiles before compiling to adjust
>>ORACLESPATIAL_INC and ORACLESPATIAL_LIB paths:
>>-adjust ORACLESPATIAL_INC to the oci.h file
>>installation directory.
>>-adjust the -L portion of ORACLESPATIAL_LIB to the
>>libclntsh.so.10.1 file installation directory.
>>
>>looks like this in my Makefile:
>>
> 
> ORACLESPATIAL_LIB=-L/usr/lib/oracle/10.1.0.3/client/lib
> 
>>-lclntsh
>>ORACLESPATIAL_INC=-I/etc/oracle/include
>>
>>*Compile  and install  
>>Mapserver and php_mapscript.
>>
>>*Configure tnsnames.ora
>>
>>*Declare oracle variables in httpd.conf:
>>SetEnv TNS_ADMIN "path/to/tnsnames.ora"
>>SetEnv LD_LIBRARY_PATH "path to the directory
>>containing    libclntsh.so.10.1"
>>
>>I did a lot of things but i think these steps are
>>the
>>main things.
>>
>>I'm on Linux Debian with Apache 1.4, php5 (cgi) with
>>mapserver 4.6.beta3
>>
>>Ludovic
>>



-- 
____________________________

Berend Veldkamp - ARIS
http://www.aris.nl/
____________________________