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,
Hi Frank,
Good call, I should have thought of that! Yes, if I change the mapfile
to a shapefile only mapfile it runs just fine in fastcgi.
Yesterday, when I was setting up the Oracle connection I got the same
error message and resolved it by fixing the file permission on the
/home2/oracle directory tree. So I guess there are still some issues
there. I'll go back over that again maybe I missed something.
Does the fastcgi version need access to different oracle client files
that the CGI does not need?
Thanks for the quick response,
-Steve W