MapServer and Oracle Spatial
Fernando Simon
fsimon at UNIVALI.BR
Thu Oct 13 14:05:30 PDT 2005
Hi Bart and Jukka,
I updated the Oracle Spatial howto in Mapserver site
(http://ms.gis.umn.edu/docs/howto/oracle_spatial_howto) with the last
information about the Oracle Spatial connection.
Regards.
------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://www.univali.br/g10 - UNIVALI/CTTMAR
------------------------------------------------------------------------
Bart van den Eijnden wrote:
>Hi Jukka,
>
>the Wiki is read-only because of spam so no new content can be added there.
>
>Please add the comments on the new Plone site, you can do it yourself there:
>
>http://ms.gis.umn.edu/docs/howto/oracle_spatial_howto/view?searchterm=oracle%20spatial
>
>First join the site, then you can add comments. Thanks in advance.
>
>Best regards,
>Bart
>
>Bart van den Eijnden
>Syncera IT Solutions
>Postbus 270
>2600 AG DELFT
>
>tel.nr.: 015-7512436
>email: BEN at Syncera-ITSolutions.nl
>
>
>
>>>>Jukka Sirviö <Jukka.Sirvio at ARBONAUT.COM> 13-10-2005 15:03:16 >>>
>>>>
>>>>
>Ok, thank you for help,
>MapServer native support for oracle spatial seems to be working now.
>
>Could you (or probaply the author: Bart van den Eijnden, The Netherlands,
>bartvde at xs4all.nl) add following comments to Oracle Spatial
>MaopServerWiki:
>
>=========
>For Windows users:
>Add following enviroment variables (under System) pointing to your actual
>oracle client home directory, these variables tell the MapServer where the
>oracle client binaries and tnsnames.ora information can be found. If you
>receive errormessage like "Error: .". It's related with access to Oracle
>files and you should check these enviroment variables!
>ORACLE_SID "database sid from tnsnames.ora"
>TNS_ADMIN "folder where the tnsnames.ora exist"
>ORACLE_HOME "oracle client home directory"
>=========
>
>
>Yours:
>Jukka
>
>
>
>
>
>
>Fernando Simon <fsimon at univali.br>
>13/10/2005 08:48
>
> To: Jukka Sirviö <Jukka.Sirvio at arbonaut.com>
> cc: MAPSERVER-USERS at LISTS.UMN.EDU
> Subject: Re: [UMN_MAPSERVER-USERS] MapServer and Oracle
>Spatial
>
>
>Hi Jukka,
> This error occur when the Mapserver can't access the ORACLE_HOME
>directory.
> When the Oracle Spatial connection return an empty error: "Error:
>.". It's relate with access to Oracle files.
> In your case I believe that if you set the same enviroments in
>console this error disappear.
> Can you set the Oracle enviroments in console (as System variables
>in Windows) instead of httpd env?
> Here, for Windows, I use the Hobu Mapserver binaries
>(http://hobu.stat.iastate.edu/mapserver/) with Oracle Spatial support.
> Thanks again.
>
>------------------------------------------------------------------------
>Fernando Simon
>Mapserver and Oracle Spatial developer
>G10 - Laboratorio de Computacao Aplicada - Brazil
>http://www.univali.br/g10 - UNIVALI/CTTMAR
>------------------------------------------------------------------------
>
>
>
>
>Jukka Sirviö wrote:
>
>
>
>>Hello Fernando!
>>Sorry for not including the information from original threads to my
>>message, Below is the headers of earlier discussions, I face exatly same
>>kind of problems even after the proposed solutions.Wiki for MapServer +
>>Ora Spatial does not give any additional information
>>(http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?OracleSpatial).
>>
>>Mapserver error is :
>>msDrawMap(): Image handling error. Failed to draw layer named 'xxxx'.
>>msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI
>>Handlers. Connection failure. Check the connection string. Error: .
>>
>>My httpd.conf contains following:
>>SetEnv MS_ERRORFILE "D:\Apache2\logs\stderr_mapserver.log"
>>SetEnv ORACLE_SID UDIGTEST
>>SetEnv ORACLE_BASE "C:\Oracle\"
>>SetEnv ORACLE_HOME "C:\Oracle\10.1.0Client_1\"
>>SetEnv TNS_ADMIN "C:\Oracle\10.1.0Client_1\network\admin\"
>>
>>And my mapfile have following entry:
>>CONNECTIONTYPE oraclespatial
>>CONNECTION "xxx/xxx at UDIGTEST"
>>DATA "GEOLOC FROM METSIKKOKUVIOT"
>>TYPE POLYGON
>>
>>And my tnsnames.ora have following entry (works with sqlplus and
>>
>>
>tnsping):
>
>
>>UDIGTEST =
>> (DESCRIPTION =
>> (ADDRESS_LIST =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = jukka)(PORT = 1521))
>> )
>> (CONNECT_DATA =
>> (SERVICE_NAME = udigtest)
>> )
>> )
>>
>>I tried several mapserver binaries which include oracle support. Next I
>>will try different mapserver binaries against 10g database (currently
>>testing against 9.2.0.6 -release)
>>
>>-Jukka
>>::::::::::::::::::::::::::::::::::::
>>:::::: THREAD1 ::::::
>>::::::::::::::::::::::::::::::::::::
>>Date: Thu, 11 Aug 2005 08:49:31 +0200
>>Reply-To: François Prunayre <fx.prunayre at OIEAU.FR>
>>Sender: UMN MapServer Users List <MAPSERVER-USERS at LISTS.UMN.EDU>
>>From: François Prunayre <fx.prunayre at OIEAU.FR>
>>Organization: Office International de l'Eau
>>Subject: Re: Oracle / OCI error
>>In-Reply-To: <42F7581A.4050505 at univali.br>
>>Content-Type: text/plain; charset="iso-8859-1"
>>
>>::::::::::::::::::::::::::::::::::::
>>:::::: THREAD2 ::::::
>>::::::::::::::::::::::::::::::::::::
>>Date: Wed, 26 Jan 2005 08:41:48 +0000
>>Reply-To: "Fernando S." <fsimon at UNIVALI.BR>
>>Sender: UMN MapServer Users List <MAPSERVER-USERS at LISTS.UMN.EDU>
>>From: "Fernando S." <fsimon at UNIVALI.BR>
>>Subject: Re: MapServer and Oracle Spatial
>>In-Reply-To: <41F6DEDC.4070009 at alumni.sfu.ca>
>>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>
>>
>>
>>
>>
>>
>>Fernando Simon <fsimon at univali.br>
>>12/10/2005 14:57
>>
>> To: Jukka Sirviö <jukka.sirvio at ARBONAUT.COM>,
>>MAPSERVER-USERS at LISTS.UMN.EDU
>> cc:
>> Subject: Re: [UMN_MAPSERVER-USERS] MapServer and Oracle
>>Spatial
>>
>>
>>Hi Jukka,
>> I didn't understand the situation that you described, can you sent
>>the error message that Mapserver returned?
>> Thanks again.
>>
>>------------------------------------------------------------------------
>>Fernando Simon
>>Mapserver and Oracle Spatial developer
>>G10 - Laboratorio de Computacao Aplicada - Brazil
>>http://www.univali.br/g10 - UNIVALI/CTTMAR
>>------------------------------------------------------------------------
>>
>>
>>Jukka Sirviö wrote:
>>
>>
>>
>>
>>
>>>Hello!
>>>I have exatly same situation, but I'm receiving the same errormessage
>>>
>>>
>>>
>>>
>>even
>>
>>
>>
>>
>>>after setting the apache enviroment variables. MapServer is running on
>>>
>>>
>>>
>>>
>>Win
>>
>>
>>
>>
>>>XP sp1 with Apache 2.0.54 (tested also on win NT 4.0 with apache 1.3.33)
>>>
>>>There is read / write access to oracle_home for anyone -user.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>>
>
>
>
More information about the MapServer-users
mailing list