[UMN_MAPSERVER-USERS] CGI Error - 4.4 Windows Binaries (Oracle, SDE, and others)

[Fernando S.]

Hi Nicolas,
    I tried to reproduce your system here, but the mapserver ran without
problems. I tried call mapserver to draw one raster layer and one oracle
layer. In both cases draw correctly.
   This is the mapserver log for cgi requests:
For raster layer:
CGI Request 1 on process 24964
msDrawRasterLayerLow(raster): entering.
msDrawGDAL(): src=1236,745,133,133, dst=0,0,555,555
msDrawMap(): Layer 1 (raster), 0.078s
msDrawMap(): Drawing Label Cache, 0.000s
msDrawMap() total time: 0.079s

For Oracle Spatial Layer:
CGI Request 1 on process 24965
msOracleSpatialLayerOpen called with: geom from bairros
msOracleSpatialLayerOpen. Shared connection not available. Creating one.
msConnPoolRegister(Bairros,XXXXXXXX/XXXXXXXXXXX at XXXXX,0x8313210)
msOracleSpatialLayerFreeItemInfo was called.
msOracleSpatialLayerInitItemInfo was called.
msOracleSpatialLayerWhichShapes was called.
msOracleSpatialLayerFreeItemInfo was called.
msOracleSpatialLayerClose was called. Layer connection: themis/themis at lca
msOracleSpatialLayerClose. Cleaning Oracle handlers.
msConnPoolRelease(Bairros,XXXXXXXX/XXXXXXXXXXX at XXXXX,0x8313210)
msConnPoolClose(XXXXXXXX/XXXXXXXXXXX at XXXXX,0x8313210)
msOracleSpatialLayerClose. Cleaning layerinfo handlers.
msDrawMap(): Layer 19 (Bairros), 0.149s
msDrawMap(): Drawing Label Cache, 0.000s
msDrawMap() total time: 0.151s

For both in the same map:
CGI Request 1 on process 24966
msDrawRasterLayerLow(raster): entering.
msDrawGDAL(): src=1236,745,133,133, dst=0,0,555,555
msDrawMap(): Layer 1 (raster), 0.087s
msOracleSpatialLayerOpen called with: geom from bairros
msOracleSpatialLayerOpen. Shared connection not available. Creating one.
msConnPoolRegister(Bairros,XXXXXXXX/XXXXXXXXXXX at XXXXX,0x8313210)
msOracleSpatialLayerFreeItemInfo was called.
msOracleSpatialLayerInitItemInfo was called.
msOracleSpatialLayerWhichShapes was called.
msOracleSpatialLayerFreeItemInfo was called.
msOracleSpatialLayerClose was called. Layer connection: themis/themis at lca
msOracleSpatialLayerClose. Cleaning Oracle handlers.
msConnPoolRelease(Bairros,XXXXXXXX/XXXXXXXXXXX at XXXXX,0x8313210)
msConnPoolClose(XXXXXXXX/XXXXXXXXXXX at XXXXX,0x8313210)
msOracleSpatialLayerClose. Cleaning layerinfo handlers.
msDrawMap(): Layer 19 (Bairros), 0.231s
msDrawMap(): Drawing Label Cache, 0.000s
msDrawMap() total time: 0.320s

    Here I'm using mapserver running in my desktop Linux (Slackware) and
this is my version: MapServer version 4.4.0 OUTPUT=GIF OUTPUT=PNG
OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF SUPPORTS=PROJ SUPPORTS=FREETYPE
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
SUPPORTS=WFS_CLIENT SUPPORTS=FASTCGI INPUT=TIFF INPUT=EPPL7
INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE DEBUG=MSDEBUG
    So, what occur when you draw layers separately? I will try to
reproduce the same in my windows, but where you download your mapserver
version?
    Thanks

---------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
LCA - http://g10.cttmar.univali.br
---------------------------------------------




Fortin,Nicolas [SteFoy] wrote:

>Hi Fernando and List,
>
>I use an ASP page that call mapserver CGI with the correct mapfile.  I use mapserver html template to test my services. It's not query mode but simple GetMap requests.
>
>One weird thing I saw with some testing :
>If I ask for two layers, a raster and an oracle spatial one by example, all work fine and I get an image!
>If I ask ONLY for oracle spatial layers (1 or more), I get the CGI error message...
>
>So I think the problem is not really the connection cause the layer(s) appear when it's not alone and with another type of Data.
>
>Calling mapserver directly with the usual parameter gives the same result.
>
>What's wrong with this? If anybody could help me solve this...
>
>What's FastCGI ?
>
>Nicolas
>
>
>