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