[mapserver-users] ms4w (fastcgi) and oracle 10?

[zach cruise]

troubleshooting info on 4.8 box with /ignored-libmap/oracle10g/libmap.dll:
shp2img -m oracle.map -o oracle.png -all_debug 10
msOracleSpatialLayerOpen called with: GEOMETRY from STATES using
unique srid 90112
msOracleSpatialLayerOpen. Shared connection not available. Creating one.
msConnPoolRegister(layername,username/password at databasename,019A68E8)
msOracleSpatialLayerFreeItemInfo was called.
msOracleSpatialLayerWhichShapes was called.
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error parsing
OracleSpatial DATA variable. Must be:'geometry_column FROM table_name
[USING UNIQUE <column> SRID srid# FUNCTION]' or 'geometry_column FROM
(SELECT stmt) [USING UNIQUE <column> SRID srid# FUNCTION]'. If want to
set the FUNCTION statement you can use: FILTER, RELATE, GEOMRELATE or
NONE. Your data statement: GEOM from STATES using unique srid 90112

On Mon, Nov 17, 2008 at 7:34 PM, zach cruise <zachc1980 at gmail.com> wrote:
> btw i got oracle 10 client (with tnsnames.ora) on 4.8 box. other than
> returning multiple ora-xxxx errors, 4.8 also returns "web template
> error" if i use /ignored-libmap/oracle10g/libmap.dll. this error is
> even for only shapefile maps. error goes away when i switch back to
> normal libmap.dll.
>
> On Mon, Nov 17, 2008 at 5:56 PM, zach cruise <zachc1980 at gmail.com> wrote:
>> looks like mod_fastcgi is not an option with ms4w and oracle 10.
>> anyway it had little benefits.
>>
>> i now got mapserver 5.2 and 4.8:
>> i thought 5.2 had native built-in support for oracle 10, but it is
>> giving me "OracleSpatial is not supported" error. i also thought 4.8
>> could get ogr support for oracle 10 by following the steps on
>> http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#oracle-10g.
>> 4.8 connects, but returns multiple ORA-xxxx errors.
>>
>> so:
>> do i have to install oracle 10 client locally and make changes to
>> httpd.conf for 5.2 to work?
>> how do i find correct srid for 4.8 to work? (DATA "GEOMETRY from
>> (select GEOMETRY from STATES where NAME = 'New York')")
>> any performance difference between native built-in and ogr supports?
>>
>> On Fri, Nov 14, 2008 at 6:22 PM, Jeff McKenna
>> <jmckenna at gatewaygeomatics.com> wrote:
>>> zach cruise wrote:
>>>>
>>>> does current ms4w with fastcgi work with oracle 10?
>>>>
>>>> here're warnings
>>>> http://www.maptools.org/ms4w/?page=README_INSTALL.html#f-fastcgi
>>>>
>>>> http://www.nabble.com/fastcgi-connections-to-Oracle-and-SDE-on-Windows-to18394152.html
>>>> in testing this was successful with PostgreSQL 8.3.1 / PostGIS 1.3.3,
>>>> but unsuccessful with Oracle 10.2.0.1.0 (Apache logs: "mod_fcgid: get
>>>> overlap result error")
>>>>
>>>> if not, any workarounds?
>>>
>>> I tested and wrote that note...and am not aware of a workaround yet. You
>>> should also send this question to the MS4W mailing list (subscribe at:
>>> http://lists.maptools.org/mailman/listinfo/ms4w-users)
>>>
>>>
>>> --
>>> Jeff McKenna
>>> FOSS4G Consulting and Training Services
>>> http://www.gatewaygeomatics.com/
>>>
>>>
>>> _______________________________________________
>>> mapserver-users mailing list
>>> mapserver-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>>
>>
>