[MAPSERVER-USERS] Debian Oracle10g OCI

[dzizes451 at gmail.com]

Since I can establish connection to my Oracle via sqlplus I guess I need to
do the last point from your list:
3) Try and re-compile Mapserver with Oracle Spatial.

Is there a tutorial how to do that?
Why mapserver is not compiled against Oracle Spatial from start (I think
there is a lot of users using Oracle Spatial)?

--
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
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080915/c777afdb/attachment.html