Help Setting up FCGI for Oracle Connection pooling

[Frank Warmerdam]

Stephen Woodbridge wrote:
> Frank,
> 
> I add the DEBUG ON to the MAP and the LAYER and get as output:
> 
> [Tue Jan 23 16:16:57 2007] [warn] FastCGI: (dynamic) server 
> "/usr/lib/cgi-bin/mapserv410.fcgi" restarted (pid 19181)
> [Tue Jan 23 16:16:57 2007] [error] [client 129.44.191.48] FastCGI: 
> server "/usr/lib/cgi-bin/mapserv410.fcgi" stderr: CGI Request 1 on 
> process 19179
> [Tue Jan 23 16:16:57 2007] [error] [client 129.44.191.48] FastCGI: 
> server "/usr/lib/cgi-bin/mapserv410.fcgi" stderr: msDrawMap(): Layer 0 
> (color_symbol), 0.000s
> [Tue Jan 23 16:16:57 2007] [error] [client 129.44.191.48] FastCGI: 
> server "/usr/lib/cgi-bin/mapserv410.fcgi" stderr: 
> msOracleSpatialLayerOpen called with: GEOMETRY FROM MEXSTATES USING SRID 
> 4326 FILTER VERSION 10g
> [Tue Jan 23 16:16:57 2007] [error] [client 129.44.191.48] FastCGI: 
> server "/usr/lib/cgi-bin/mapserv410.fcgi" stderr: 
> msOracleSpatialLayerClose was called. Layer connection: 
> mapserver1/w2gi at test
> [Tue Jan 23 16:16:57 2007] [warn] FastCGI: (dynamic) server 
> "/usr/lib/cgi-bin/mapserv410.fcgi" (pid 19179) terminated by calling 
> exit with status '0'
> 
> Does this tell you anything?

Steve,

I find it odd that the layer is being closed if the open never
actually succeeded.  If it did succeed then ... well that would be
interesting.

> Is there anyway to get more debug output, short of adding more print 
> statements to the executable?

I am not aware of a way to get more debug information short of adding
extra debug statements yourself.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org