Apache, SDE

[Chad Ringenberg]

I struggled to get FastCGI working with mapserver but finally did using the steps below.  However I'm having memory exceptions when using SDE layers anywhere from 3 to 15 map requests.  I also tested against PostGIS and didn't receive any exceptions for the first 40 requests but the mapserv.exe did gradually consume more memory.  I'm not sure if the configuration I used below is the best, but it's all I have found so far.  Is there a different configuration I could use that would work more reliably on Windows 2003 server with SDE?


 - Installed Apache version 2.0.59, this appears to be the latest version to work with mod_fastcgi.

 - I downloaded mod_fastcgi http://www.fastcgi.com/dist/mod_fastcgi-2.4.2-AP20.dll and placed it in the cgi-bin directory.

 - Placed my compiled (FastCGI enabled) mapserver in the cgi-bin directory.

 - Added the following lines to conf.httpd in Apache.

 - LoadModule fastcgi_module cgi-bin/mod_fastcgi-2.4.2-AP20.dll
 - AddHandler fastcgi-script .fcgi
 - FastCgiServer cgi-bin/mapserv.exe 

 - added the following to each layer in the map file: PROCESSING "CLOSE_CONNECTION=DEFER"


Thanks,
Chad


  ----- Original Message ----- 
  From: Chad Ringenberg 
  To: MAPSERVER-USERS at LISTS.UMN.EDU 
  Sent: Thursday, January 11, 2007 2:21 PM
  Subject: [UMN_MAPSERVER-USERS] Apache, SDE


  Hi,

  I have Windows 2003 server with the latest release of Apache and Mapserver
  compiled with SDE(9.1) support.  I am able to generate a map with the SDE
  layers but the following errors are showing up in the Apache error.log.

  [error] [client 127.0.0.1] msSDELayerOpen(): Layer seclayer opened from
  scratch.\r
  [error] [client 127.0.0.1]
  msConnPoolRegister(seclayer,192.168.5.5,port:5153,abc,user,***,01A12CA8)\r
  [error] [client 127.0.0.1] msSDELayerOpen(): Layer seclayer specified
  version SDE.DEFAULT.\r
  ......

  Ultimately I'm trying to get FastCGI working but have been unable to and I'm
  wondering if this may be why.

  Thanks,
  Chad
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070116/5cbffacc/attachment.html