<div dir="ltr">Now I get:<br><br>checking if OracleSpatial support requested... yes, user supplied ORACLE_HOME<br>configure: error: Oracle Spatial: libclntsh.so not found.<br><br>I enclose the config.log.<br clear="all"><br>
--<br>Micha³<br>
<br><br><div class="gmail_quote">2008/9/16 Umberto Nicoletti <span dir="ltr"><<a href="mailto:umberto.nicoletti@gmail.com">umberto.nicoletti@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
try:<br>
<div class="Ih2E3d"><br>
-with-oraclespatial=/usr/lib/oracle/xe/app/oracle/product/10.2.0<br>
<br>
</div>otherwise post the config.log file.<br>
<div><div></div><div class="Wj3C7c"><br>
Umberto<br>
<br>
2008/9/16 <<a href="mailto:dzizes451@gmail.com">dzizes451@gmail.com</a>>:<br>
> Thanks for the tip!<br>
> The Makefile looks like:<br>
> -------------- Compiler Info -------------<br>
> C compiler: gcc -O2 -fPIC -Wall<br>
> C++ compiler: g++ -O2 -fPIC -Wall<br>
> Debug:<br>
> Generic NINT:<br>
><br>
> -------------- Renderer Settings ---------<br>
> zlib support: -DUSE_ZLIB<br>
> png support:<br>
> palette rgba png support:<br>
> jpeg support:<br>
> iconv support: -DUSE_ICONV<br>
> AGG support:<br>
> AGG Freetype support:<br>
> Ming(flash) support:<br>
> PDFLib support:<br>
><br>
> -------------- Support Libraries ---------<br>
> Proj.4 support: -DUSE_PROJ<br>
> Libxml2 support:<br>
> FriBidi support:<br>
> Curl support: -DUSE_CURL<br>
> FastCGI support:<br>
> Threading support: -DUSE_THREAD<br>
> GEOS support:<br>
><br>
> -------------- Data Format Drivers -------<br>
> native tiff support:<br>
> PostGIS support:<br>
> EPPL7 support: -DUSE_EPPL<br>
> ArcSDE support:<br>
> OGR support: -DUSE_OGR<br>
> GDAL support: -DUSE_GDAL<br>
> Oracle Spatial support: -DUSE_ORACLESPATIAL<br>
><br>
> -------------- OGC Services --------------<br>
> WMS Server: -DUSE_WMS_SVR<br>
> WMS Client: -DUSE_WMS_LYR<br>
> WFS Server:<br>
> WFS Client: -DUSE_WMS_LYR<br>
> WCS Server:<br>
> SOS Server:<br>
><br>
> -------------- MapScript -----------------<br>
> PHP MapScript: no<br>
><br>
> the make command throws the following error:<br>
><br>
> warning: libnnz10.so, needed by<br>
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so, not<br>
> found (try using -rpath or -rpath-link)<br>
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so:<br>
> undefined reference to `nztSearchNZDefault'<br>
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so:<br>
> undefined reference to `nzosCipherSpecToStr'<br>
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so:<br>
> undefined reference to `nztwOpenWallet'<br>
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so:<br>
> undefined reference to `A_X931RandomInit'<br>
> ....<br>
> ends with<br>
> collect2: ld returned 1 exit status<br>
> make: *** [shp2img] Error 1<br>
><br>
> any ideas!<br>
><br>
> --<br>
> Micha³<br>
><br>
><br>
> 2008/9/16 Umberto Nicoletti <<a href="mailto:umberto.nicoletti@gmail.com">umberto.nicoletti@gmail.com</a>><br>
>><br>
>> Usign tiff AND gdal is not recommended, you'd better try these options:<br>
>><br>
>> ./configure<br>
>> -with-oraclespatial=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server<br>
>> -with-proj -with-wfsclient -with-wmsclient -with-gdal -with-ogr<br>
>> -with-threads -with-freetype -without-tiff -with-FastCGI<br>
>><br>
>> as for the expat error:<br>
>><br>
>> sudo apt-get install libexpat1 libexpat1-dev<br>
>><br>
>> Umberto<br>
>><br>
>> 2008/9/16 <<a href="mailto:dzizes451@gmail.com">dzizes451@gmail.com</a>>:<br>
>> > Hi again,<br>
>> ><br>
>> > I've tried to compile mapserv executable with:<br>
>> ><br>
>> > ./configure<br>
>> > -with-oraclespatial=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server<br>
>> > -with-proj -with-wfsclient -with-wmsclient -with-gdal -with-ogr<br>
>> > -with-threads -with-freetype -with-tiff -with-FastCGI<br>
>> ><br>
>> > and I receive this error:<br>
>> ><br>
>> > /usr/bin/ld: cannot find -lexpat<br>
>> > collect2: ld returned 1 exit status<br>
>> > make: *** [shp2img] Error 1<br>
>> ><br>
>> > Does anyone know what is wrong?<br>
>> ><br>
>> > --<br>
>> > Micha³<br>
>> ><br>
>> ><br>
>> > On Mon, Sep 15, 2008 at 3:16 PM, Dan Little <<a href="mailto:danlittle@yahoo.com">danlittle@yahoo.com</a>> wrote:<br>
>> >><br>
>> >> Umberto is right, for Mapserver to connect to Oracle you need to<br>
>> >> specify<br>
>> >> that capability at compile time. But for you ge tthat far I think you<br>
>> >> need<br>
>> >> to make sure that some of the basics work.<br>
>> >><br>
>> >> Also, if you cannot connect to Oracle via SQL*Plus (assuming the binary<br>
>> >> is<br>
>> >> installed) you have other problems including but not limited to:<br>
>> >> - needing to set the LD_LIBRARY_PATH to include all the libraries.<br>
>> >> This<br>
>> >> may also need to be done in Apache while running mapserver to access<br>
>> >> Oracle.<br>
>> >> - needing to configure your TNSNAMES file.<br>
>> >> - check firewall setting in order to make sure you can connect on 1521<br>
>> >> (or<br>
>> >> whatever port you are using for Oracle).<br>
>> >><br>
>> >> Generally, when running an Oracle layer, you want to try the following<br>
>> >> diagnostic steps:<br>
>> >> 1) Use SQL Developer to connect to the database (it has it's own<br>
>> >> drivers<br>
>> >> built in, so there's no software dependency issues). This will resolve<br>
>> >> whether or not the databas is working.<br>
>> >> 2) On the machine, try connecting with SQL Plus. This will determine<br>
>> >> whether or not you have your client configured correctly. Do not move<br>
>> >> on<br>
>> >> until this works.<br>
>> >> 3) Try and re-compile Mapserver with Oracle Spatial. At the end of the<br>
>> >> ./configure script there is an output screen, ensure that you see<br>
>> >> Oracle is<br>
>> >> turned on, otherwise scroll up in the screen and see what's missing.<br>
>> >><br>
>> >><br>
>> >><br>
>> >> ----- Original Message ----<br>
>> >> > From: Umberto Nicoletti <<a href="mailto:umberto.nicoletti@gmail.com">umberto.nicoletti@gmail.com</a>><br>
>> >> > To: dzizes <<a href="mailto:dzizes451@gmail.com">dzizes451@gmail.com</a>><br>
>> >> > Cc: <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
>> >> > Sent: Monday, September 15, 2008 7:45:48 AM<br>
>> >> > Subject: Re: [MAPSERVER-USERS] Debian Oracle10g OCI<br>
>> >> ><br>
>> >> > You have to recompile mapserver with the:<br>
>> >> ><br>
>> >> > --with-oraclespatial=[path to oracle home]<br>
>> >> ><br>
>> >> > option. That's all that is needed to enable oracle spatial support in<br>
>> >> > mapserver.<br>
>> >> ><br>
>> >> > HTH,<br>
>> >> > Umberto<br>
>> >> ><br>
>> >> > On Mon, Sep 15, 2008 at 2:05 PM, dzizes wrote:<br>
>> >> > ><br>
>> >> > > Hi,<br>
>> >> > ><br>
>> >> > > I've installed mapserver on Debian (lenny distribution). I've<br>
>> >> > > managed<br>
>> >> > > to<br>
>> >> > > create mapfile based on shp data and successfully send a wms<br>
>> >> > > request<br>
>> >> > > to get<br>
>> >> > > a map. I seems that mapserver works fine.<br>
>> >> > ><br>
>> >> > > I've also installed oracle-ex and I can connect to my Oracle via<br>
>> >> > > sqlplus.<br>
>> >> > > However, when I request wms (to a map file pointing to Oracle10g) I<br>
>> >> > > receive<br>
>> >> > > the following:<br>
>> >> > ><br>
>> >> > > msDrawMap(): Image handling error. Failed to draw layer named<br>
>> >> > > 'test'.<br>
>> >> > > msOracleSpatialLayerOpen(): OracleSpatial error. OracleSpatial is<br>
>> >> > > not<br>
>> >> > > supported<br>
>> >> > ><br>
>> >> > > I've found that I need OCI installed and configured properly, but<br>
>> >> > > there is<br>
>> >> > > no clear tutorial.<br>
>> >> > > Please provide me a some step by step guide.<br>
>> >> > ><br>
>> >> > > Greets,<br>
>> >> > > Michal<br>
>> >> > ><br>
>> >> > > --<br>
>> >> > > View this message in context:<br>
>> >> > <a href="http://www.nabble.com/Debian-Oracle10g-OCI-tp19491636p19491636.html" target="_blank">http://www.nabble.com/Debian-Oracle10g-OCI-tp19491636p19491636.html</a><br>
>> >> > > Sent from the Mapserver - User mailing list archive at Nabble.com.<br>
>> >> > ><br>
>> >> > > _______________________________________________<br>
>> >> > > mapserver-users mailing list<br>
>> >> > > <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
>> >> > > <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
>> >> > ><br>
>> >> > _______________________________________________<br>
>> >> > mapserver-users mailing list<br>
>> >> > <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
>> >> > <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
>> >><br>
>> >><br>
>> >><br>
>> >><br>
>> ><br>
>> ><br>
>> > _______________________________________________<br>
>> > mapserver-users mailing list<br>
>> > <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
>> > <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
>> ><br>
>> ><br>
><br>
><br>
</div></div></blockquote></div><br></div>