<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.3790.2817" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>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?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> - Installed Apache version 2.0.59, this
appears to be the latest version to work with mod_fastcgi.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> - I downloaded mod_fastcgi </FONT><FONT
color=#800080><A
href="http://www.fastcgi.com/dist/mod_fastcgi-2.4.2-AP20.dll">http://www.fastcgi.com/dist/</FONT>mod_fastcgi-2.4.2-AP20.dll</A><FONT
face=Arial color=#000000 size=2> and placed it in the cgi-bin
directory.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> - Placed my compiled (FastCGI enabled)
mapserver in the cgi-bin directory.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> - Added the following lines to conf.httpd in
Apache.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> - LoadModule fastcgi_module
cgi-bin/mod_fastcgi-2.4.2-AP20.dll</FONT></DIV>
<DIV><FONT face=Arial size=2> - AddHandler fastcgi-script
.fcgi</FONT></DIV>
<DIV><FONT face=Arial size=2> - FastCgiServer cgi-bin/mapserv.exe
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> - added the following to each layer in the
map file: PROCESSING "CLOSE_CONNECTION=DEFER"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2>Chad</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=chad@AGRIDATAINC.COM href="mailto:chad@AGRIDATAINC.COM">Chad
Ringenberg</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=MAPSERVER-USERS@LISTS.UMN.EDU
href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, January 11, 2007 2:21
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [UMN_MAPSERVER-USERS] Apache,
SDE</DIV>
<DIV><BR></DIV>Hi,<BR><BR>I have Windows 2003 server with the latest release
of Apache and Mapserver<BR>compiled with SDE(9.1) support. I am able to
generate a map with the SDE<BR>layers but the following errors are showing up
in the Apache error.log.<BR><BR>[error] [client 127.0.0.1] msSDELayerOpen():
Layer seclayer opened from<BR>scratch.\r<BR>[error] [client
127.0.0.1]<BR>msConnPoolRegister(seclayer,192.168.5.5,port:5153,abc,user,***,01A12CA8)\r<BR>[error]
[client 127.0.0.1] msSDELayerOpen(): Layer seclayer specified<BR>version
SDE.DEFAULT.\r<BR>......<BR><BR>Ultimately I'm trying to get FastCGI working
but have been unable to and I'm<BR>wondering if this may be
why.<BR><BR>Thanks,<BR>Chad</BLOCKQUOTE></BODY></HTML>