[Mapserver-users] Mapserver - Oracle through OGR

[Vladimir Guzmán]

Thanks a lot for your help.
The problem was solved recompiling phpmapscript against the new gdal, 
but it was not enough.
In my httpd.conf I had set the environment variables, so I thought I 
didn't need anything else.
The last and succesful step, was put the environment variables via php's 
putenv() function.
Now it is working perfectly.

Thanks again.

--------------------
Vladimir Guzmán

Bart van den Eijnden wrote:

> Hi Zak,
>
> Frank Warmerdam already replied to me but off-list.
>
> The problem seems to be that I have to recompile Mapserver against the 
> modified GDAL/OGR with Oracle Spatial support. I thought I only had to 
> build a new gdal11.dll.
>
> Best regards,
> Bart
>
> On Mon, 16 Feb 2004 23:32:48 -0500, Zak James <zak-ms at hoppsan.org> wrote:
>
>> 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
>>>
>>
>>
>> _______________________________________________
>> Mapserver-users mailing list
>> Mapserver-users at lists.gis.umn.edu
>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>
>
>
>