[MAPSERVER-USERS] Debian Oracle10g OCI

[Umberto Nicoletti]

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
>
>