[MAPSERVER-USERS] Debian Oracle10g OCI

Umberto Nicoletti umberto.nicoletti at gmail.com
Tue Sep 16 02:14:22 PDT 2008 

try:

-with-oraclespatial=/usr/lib/oracle/xe/app/oracle/product/10.2.0

otherwise post the config.log file.

Umberto

2008/9/16  <dzizes451 at gmail.com>:
> Thanks for the tip!
> The Makefile looks like:
>  -------------- Compiler Info -------------
>   C compiler:                gcc -O2 -fPIC -Wall
>   C++ compiler:              g++ -O2 -fPIC -Wall
>   Debug:
>   Generic NINT:
>
>  -------------- Renderer Settings ---------
>   zlib support:              -DUSE_ZLIB
>   png support:
>   palette rgba png support:
>   jpeg support:
>   iconv support:             -DUSE_ICONV
>   AGG support:
>   AGG Freetype support:
>   Ming(flash) support:
>   PDFLib support:
>
>  -------------- Support Libraries ---------
>   Proj.4 support:            -DUSE_PROJ
>   Libxml2 support:
>   FriBidi support:
>   Curl support:              -DUSE_CURL
>   FastCGI support:
>   Threading support:         -DUSE_THREAD
>   GEOS support:
>
>  -------------- Data Format Drivers -------
>   native tiff support:
>   PostGIS support:
>   EPPL7 support:             -DUSE_EPPL
>   ArcSDE support:
>   OGR support:               -DUSE_OGR
>   GDAL support:              -DUSE_GDAL
>   Oracle Spatial support:    -DUSE_ORACLESPATIAL
>
>  -------------- OGC Services --------------
>   WMS Server:                -DUSE_WMS_SVR
>   WMS Client:                -DUSE_WMS_LYR
>   WFS Server:
>   WFS Client:                -DUSE_WMS_LYR
>   WCS Server:
>   SOS Server:
>
>  -------------- MapScript -----------------
>   PHP MapScript:             no
>
> the make command throws the following error:
>
>  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)
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so:
> undefined reference to `nztSearchNZDefault'
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so:
> undefined reference to `nzosCipherSpecToStr'
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so:
> undefined reference to `nztwOpenWallet'
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so:
> undefined reference to `A_X931RandomInit'
> ....
> ends with
> collect2: ld returned 1 exit status
> make: *** [shp2img] Error 1
>
> any ideas!
>
> --
> Michał
>
>
> 2008/9/16 Umberto Nicoletti <umberto.nicoletti at gmail.com>
>>
>> Usign tiff AND gdal is not recommended, you'd better try these options:
>>
>> ./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  -without-tiff -with-FastCGI
>>
>> as for the expat error:
>>
>> sudo apt-get install libexpat1 libexpat1-dev
>>
>> Umberto
>>
>> 2008/9/16  <dzizes451 at gmail.com>:
>> > Hi again,
>> >
>> > I've tried to compile mapserv executable with:
>> >
>> > ./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
>> >
>> > and I receive this error:
>> >
>> > /usr/bin/ld: cannot find -lexpat
>> > collect2: ld returned 1 exit status
>> > make: *** [shp2img] Error 1
>> >
>> > Does anyone know what is wrong?
>> >
>> > --
>> > Michał
>> >
>> >
>> > On Mon, Sep 15, 2008 at 3:16 PM, Dan Little <danlittle at yahoo.com> wrote:
>> >>
>> >> 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.
>> >>
>> >> Also, if you cannot connect to Oracle via SQL*Plus (assuming the binary
>> >> is
>> >> installed) you have other problems including but not limited to:
>> >> - 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.
>> >> - needing to configure your TNSNAMES file.
>> >> - check firewall setting in order to make sure you can connect on 1521
>> >> (or
>> >> whatever port you are using for Oracle).
>> >>
>> >> Generally, when running an Oracle layer, you want to try the following
>> >> diagnostic steps:
>> >> 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.
>> >> 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.
>> >> 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.
>> >>
>> >>
>> >>
>> >> ----- Original Message ----
>> >> > From: Umberto Nicoletti <umberto.nicoletti at gmail.com>
>> >> > To: dzizes <dzizes451 at gmail.com>
>> >> > Cc: mapserver-users at lists.osgeo.org
>> >> > Sent: Monday, September 15, 2008 7:45:48 AM
>> >> > Subject: Re: [MAPSERVER-USERS] Debian Oracle10g OCI
>> >> >
>> >> > You have to recompile mapserver with the:
>> >> >
>> >> > --with-oraclespatial=[path to oracle home]
>> >> >
>> >> > option. That's all that is needed to enable oracle spatial support in
>> >> > mapserver.
>> >> >
>> >> > HTH,
>> >> > Umberto
>> >> >
>> >> > On Mon, Sep 15, 2008 at 2:05 PM, dzizes wrote:
>> >> > >
>> >> > > Hi,
>> >> > >
>> >> > > I've installed mapserver on Debian (lenny distribution). I've
>> >> > > managed
>> >> > > to
>> >> > > create mapfile based on shp data and successfully send a wms
>> >> > > request
>> >> > > to get
>> >> > > a map. I seems that mapserver works fine.
>> >> > >
>> >> > > I've also installed oracle-ex and I can connect to my Oracle via
>> >> > > sqlplus.
>> >> > > However, when I request wms (to a map file pointing to Oracle10g) I
>> >> > > receive
>> >> > > the following:
>> >> > >
>> >> > > msDrawMap(): Image handling error. Failed to draw layer named
>> >> > > 'test'.
>> >> > > msOracleSpatialLayerOpen(): OracleSpatial error. OracleSpatial is
>> >> > > not
>> >> > > supported
>> >> > >
>> >> > > I've found that I need OCI installed and configured properly, but
>> >> > > there is
>> >> > > no clear tutorial.
>> >> > > Please provide me a some step by step guide.
>> >> > >
>> >> > > Greets,
>> >> > > Michal
>> >> > >
>> >> > > --
>> >> > > View this message in context:
>> >> > http://www.nabble.com/Debian-Oracle10g-OCI-tp19491636p19491636.html
>> >> > > Sent from the Mapserver - User mailing list archive at Nabble.com.
>> >> > >
>> >> > > _______________________________________________
>> >> > > mapserver-users mailing list
>> >> > > mapserver-users at lists.osgeo.org
>> >> > > http://lists.osgeo.org/mailman/listinfo/mapserver-users
>> >> > >
>> >> > _______________________________________________
>> >> > mapserver-users mailing list
>> >> > mapserver-users at lists.osgeo.org
>> >> > http://lists.osgeo.org/mailman/listinfo/mapserver-users
>> >>
>> >>
>> >>
>> >>
>> >
>> >
>> > _______________________________________________
>> > mapserver-users mailing list
>> > mapserver-users at lists.osgeo.org
>> > http://lists.osgeo.org/mailman/listinfo/mapserver-users
>> >
>> >
>
>

More information about the MapServer-users mailing list