[MAPSERVER-USERS] Debian Oracle10g OCI
dzizes451 at gmail.com
dzizes451 at gmail.com
Tue Sep 16 05:42:39 EDT 2008
Makefile generates without any problems, but when executing make command I
receive:
/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)
/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'
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so:
undefined reference to `nzosgpc_GetProtocolVer'
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so:
undefined reference to `nzos_DisableClientAuthentication'
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so:
undefined reference to `nzduui2_destroy_ui'
--------
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
LOGNAME=root
--
Michał
2008/9/16 Umberto Nicoletti <umberto.nicoletti at gmail.com>
> Revert configure to the previous oraclespatial setting and try:
>
> export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
>
> before configure.
>
> Umberto
>
>
> 2008/9/16 <dzizes451 at gmail.com>:
> > Now I get:
> >
> > checking if OracleSpatial support requested... yes, user supplied
> > ORACLE_HOME
> > configure: error: Oracle Spatial: libclntsh.so not found.
> >
> > I enclose the config.log.
> >
> > --
> > Michał
> >
> >
> > 2008/9/16 Umberto Nicoletti <umberto.nicoletti at gmail.com>
> >>
> >> 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
> >> >> >
> >> >> >
> >> >
> >> >
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080916/6651896a/attachment-0001.html
More information about the mapserver-users
mailing list