<div dir="ltr">Hi again,<br><br>I've tried to compile mapserv executable with:<br><br>./configure -with-oraclespatial=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server -with-proj -with-wfsclient -with-wmsclient -with-gdal -with-ogr -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 clear="all"><br>--<br>Micha³<br>
<br><br><div class="gmail_quote">On Mon, Sep 15, 2008 at 3:16 PM, Dan Little <span dir="ltr"><<a href="mailto:danlittle@yahoo.com">danlittle@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Umberto is right, for Mapserver to connect to Oracle you need to specify that capability at compile time. But for you ge tthat far I think you need to make sure that some of the basics work.<br>
<br>
Also, if you cannot connect to Oracle via SQL*Plus (assuming the binary is installed) you have other problems including but not limited to:<br>
- needing to set the LD_LIBRARY_PATH to include all the libraries. This may also need to be done in Apache while running mapserver to access Oracle.<br>
- needing to configure your TNSNAMES file.<br>
- check firewall setting in order to make sure you can connect on 1521 (or whatever port you are using for Oracle).<br>
<br>
Generally, when running an Oracle layer, you want to try the following diagnostic steps:<br>
1) Use SQL Developer to connect to the database (it has it's own drivers built in, so there's no software dependency issues). This will resolve whether or not the databas is working.<br>
2) On the machine, try connecting with SQL Plus. This will determine whether or not you have your client configured correctly. Do not move on until this works.<br>
3) Try and re-compile Mapserver with Oracle Spatial. At the end of the ./configure script there is an output screen, ensure that you see Oracle is turned on, otherwise scroll up in the screen and see what's missing.<br>
<div class="Ih2E3d"><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 mapserver.<br>
><br>
> HTH,<br>
> Umberto<br>
><br>
</div><div><div></div><div class="Wj3C7c">> 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 managed to<br>
> > create mapfile based on shp data and successfully send a wms request 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 sqlplus.<br>
> > However, when I request wms (to a map file pointing to Oracle10g) I receive<br>
> > the following:<br>
> ><br>
> > msDrawMap(): Image handling error. Failed to draw layer named 'test'.<br>
> > msOracleSpatialLayerOpen(): OracleSpatial error. OracleSpatial is not<br>
> > supported<br>
> ><br>
> > I've found that I need OCI installed and configured properly, but 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>
</div></div></blockquote></div><br></div>