[Mapserver-users] Mapserver - Oracle through OGR

[Zak James]

Bart:

What result do you get if you try to run your ovf file through ogrinfo, 
instead of accessing the OCI driver directly?

Vladimir:

When you run ogrinfo, it has access to any environment variables you 
have set for the current user, including some relating to oracle. In 
order for Mapserver to have access to these variables, they need to be 
set for the web server user. For apache, you can edit httpd.conf to 
enable and set environment variables.

zak
--
Zak James
Applications and Software Development
DM Solutions Group Inc.
http://www.dmsolutions.ca


On Feb 16, 2004, at 6:21 PM, Vladimir Guzmán wrote:

> I have the same problem.
> So I tried with the mapserver's built-in oracle spatial support, but I 
> have the following error:
>
> [MapServer Error]: msOCIConnect() in msOracleSpatialLayerOpen(): 
> ORA-07217: sltln: environment variable cannot be evaluated.
>
> It is an Oracle error, which seems to be related with the environment 
> variable ORACLE_SID.
> But it seems to be ok, because the ogrinfo works ok.
>
> Any help will be greatly appreciated.
>
> Thanks a lot,
>
> --------------------
> Vladimir Guzmán
>
> bartvde at xs4all.nl wrote:
>
>> Hi list,
>>
>> I am trying to connect Mapserver to Oracle through OGR but I am 
>> running
>> into a problem. Error message, output from ogrinfo and excerpt from 
>> MAP
>> file at the bottom of this e-mail. We can connect through the native
>> Oracle Spatial interface of Mapserver on the same machine.
>>
>> Anybody have an idea what could be the problem?
>>
>> Thanks in advance,
>> Bart
>>
>> ------
>> msDrawMap(): Image handling error. Failed to draw layer named 
>> 'straten'.
>> msOGRFileOpen(): OGR error. Open failed for OGR connection
>> `OCI:laura/laura at laura'.  File not found or unsupported format.
>> ------
>>
>> When I connect through ogrinfo there are no problems, this is part of 
>> the
>> output generated by ogrinfo:
>>
>> ------
>> INFO: Open of `OCI:laura/laura at laura'
>> using driver `OCI' successful.
>>
>> Layer name: SELECT * from straten where name='Kerkstraat'
>> Geometry: Unknown (any)
>> Feature Count: 809
>> Extent: (19361.400000, 309014.500000) - (276658.600000, 603186.200000)
>> Layer SRS WKT:
>> (unknown)
>> ID: Integer (20.0)
>> FRC: Integer (9.0)
>> NAME: String (70.0)
>> NAMELC: String (3.0)
>> ROUTENUM: String (50.0)
>> MI_SYMBOLOGY: String (254.0)
>> MI_PRINX: Integer (11.0)
>> OGRFeature(SELECT * from straten where name='Kerkstraat'):0
>>  ID (Integer) = 2079166603
>>  FRC (Integer) = 7
>>  NAME (String) = Kerkstraat
>>  NAMELC (String) = DUT
>>  ROUTENUM (String) = (null)
>>  MI_SYMBOLOGY (String) = (null)
>>  MI_PRINX (Integer) = 312
>>  LINESTRING (268161.900 566095.100,268074.900 566072.700)
>> ------
>>
>> This is the relevant part of my MAP file:
>> ------
>> NAME "STRATEN"
>> CONNECTIONTYPE OGR
>> CONNECTION "OCI:laura/laura at laura"
>> DATA "SELECT * FROM STRATEN where name='Kerkstraat'"
>> TYPE LINE
>> ------
>>
>> No errors in the Apache error log.
>>
>> _______________________________________________
>> Mapserver-users mailing list
>> Mapserver-users at lists.gis.umn.edu
>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>
>>
>>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>