I hate using the LD_LIBRARY_PATH trick. I think this is a work around for software developer to not take in to account different Linux software distribution.
If you have a Lenny, add a file into /etc/ld.so.conf.d with the list of directory where special oracle library resides. Run ldconfig -v and check if library are correctly cached. Now run ldd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so and check if all needed library are available. If a library is missing, run "updatedb; locate <library>" and add the directory to the file in ld.so.conf.d directory. Repeat until all library are correctly defined. Leandro > -----Messaggio originale----- > Da: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Per conto di > Umberto Nicoletti > Inviato: martedì 16 settembre 2008 11.55 > A: [EMAIL PROTECTED] > Cc: [email protected] > Oggetto: Re: [MAPSERVER-USERS] Debian Oracle10g OCI > > I'm at a complete loss here. I assume there is a problem with > your oracle install. > did you run /etc/init.d/oracle-xe configure? > > Umberto > > 2008/9/16 <[EMAIL PROTECTED]>: > > 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/bi > > n PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin > > LOGNAME=root > > > > > > -- > > Michał > > > > > > 2008/9/16 Umberto Nicoletti <[EMAIL PROTECTED]> > >> > >> 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 <[EMAIL PROTECTED]>: > >> > 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 <[EMAIL PROTECTED]> > >> >> > >> >> try: > >> >> > >> >> -with-oraclespatial=/usr/lib/oracle/xe/app/oracle/product/10.2.0 > >> >> > >> >> otherwise post the config.log file. > >> >> > >> >> Umberto > >> >> > >> >> 2008/9/16 <[EMAIL PROTECTED]>: > >> >> > 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/libclnts > >> >> > h.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 <[EMAIL PROTECTED]> > >> >> >> > >> >> >> 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 <[EMAIL PROTECTED]>: > >> >> >> > 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 > >> >> >> > <[EMAIL PROTECTED]> > >> >> >> > 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 <[EMAIL PROTECTED]> > >> >> >> >> > To: dzizes <[EMAIL PROTECTED]> > >> >> >> >> > Cc: [email protected] > >> >> >> >> > 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-tp19491636p1949 > >> >> >> >> > 1636.html > >> >> >> >> > > Sent from the Mapserver - User mailing list > archive at > >> >> >> >> > > Nabble.com. > >> >> >> >> > > > >> >> >> >> > > _______________________________________________ > >> >> >> >> > > mapserver-users mailing list > >> >> >> >> > > [email protected] > >> >> >> >> > > > http://lists.osgeo.org/mailman/listinfo/mapserver-users > >> >> >> >> > > > >> >> >> >> > _______________________________________________ > >> >> >> >> > mapserver-users mailing list > >> >> >> >> > [email protected] > >> >> >> >> > http://lists.osgeo.org/mailman/listinfo/mapserver-users > >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> > > >> >> >> > > >> >> >> > _______________________________________________ > >> >> >> > mapserver-users mailing list > >> >> >> > [email protected] > >> >> >> > http://lists.osgeo.org/mailman/listinfo/mapserver-users > >> >> >> > > >> >> >> > > >> >> > > >> >> > > >> > > >> > > > > > >
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
