<div dir="ltr">Makefile generates without any problems, but when executing make command I receive:<br><br>/usr/bin/ld: 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'<br>/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so: undefined reference to `nzosCipherSpecToStr'<br>
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so: undefined reference to `nztwOpenWallet'<br>/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so: undefined reference to `A_X931RandomInit'<br>
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so: undefined reference to `nzosgpc_GetProtocolVer'<br>/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so: undefined reference to `nzos_DisableClientAuthentication'<br>
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so: undefined reference to `nzduui2_destroy_ui'<br><br><br>--------<br>ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server<br>LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin<br>
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin<br>LOGNAME=root<br><br><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;">
Revert configure to the previous oraclespatial setting and try:<br>
<br>
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server<br>
<br>
before configure.<br>
<div><div></div><div class="Wj3C7c"><br>
Umberto<br>
<br>
<br>
2008/9/16 <<a href="mailto:dzizes451@gmail.com">dzizes451@gmail.com</a>>:<br>
> Now I get:<br>
><br>
> checking if OracleSpatial support requested... yes, user supplied<br>
> ORACLE_HOME<br>
> configure: error: Oracle Spatial: libclntsh.so not found.<br>
><br>
> I enclose the config.log.<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>
>> try:<br>
>><br>
>> -with-oraclespatial=/usr/lib/oracle/xe/app/oracle/product/10.2.0<br>
>><br>
>> otherwise post the config.log file.<br>
>><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,<br>
>> > 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>
>> >> ><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>><br>
>> >> > 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<br>
>> >> >> 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<br>
>> >> >> 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<br>
>> >> >> 1521<br>
>> >> >> (or<br>
>> >> >> whatever port you are using for Oracle).<br>
>> >> >><br>
>> >> >> Generally, when running an Oracle layer, you want to try the<br>
>> >> >> 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<br>
>> >> >> resolve<br>
>> >> >> whether or not the databas is working.<br>
>> >> >> 2) On the machine, try connecting with SQL Plus. This will<br>
>> >> >> determine<br>
>> >> >> whether or not you have your client configured correctly. Do not<br>
>> >> >> move<br>
>> >> >> on<br>
>> >> >> until this works.<br>
>> >> >> 3) Try and re-compile Mapserver with Oracle Spatial. At the end of<br>
>> >> >> 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<br>
>> >> >> > 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<br>
>> >> >> > > 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<br>
>> >> >> > > is<br>
>> >> >> > > not<br>
>> >> >> > > supported<br>
>> >> >> > ><br>
>> >> >> > > I've found that I need OCI installed and configured properly,<br>
>> >> >> > > 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>
>> >> >> ><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<br>
>> >> >> > > 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>
><br>
><br>
</div></div></blockquote></div><br></div>