Help Setting up FCGI for Oracle Connection pooling

[Stephen Woodbridge]

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?
Is there anyway to get more debug output, short of adding more print 
statements to the executable?

-Steve

Frank Warmerdam wrote:
> Stephen Woodbridge wrote:
>> Hi,
>>
>> This is my first attempt to get FastCGI running with Mapserver to do 
>> Oracle connection pooling, and it is not working. Any help would be 
>> appreciated.
>>
>> I have the mapfile working for CGI so I know I have the system and 
>> environment set up correctly, but in fcgi mode I get:
>>
>> This is the error message:
>>
>> msDrawMap(): Image handling error. Failed to draw layer named 
>> 'Mexican_States'.
>> msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI 
>> Handlers. Connection failure. Check the connection string. Error: .
> 
> Steve,
> 
> It seems like you have done everything right.  Does the fastcgi
> mapserver work for other stuff (like shapefiles) if there is no
> oracle in the mix?
> 
> It looks like some sort of subtle environment type issue, but your
> efforts seem pretty comprehensive.
> 
> Best regards,
>