<div>I got it work...</div>
<div>It was a IIS 7.5 Mapping problem...</div>
<div>My bad...</div>
<div>Sorry</div>
<div> </div>
<div>Paul<br><br></div>
<div class="gmail_quote">On Thu, Oct 22, 2009 at 12:03 PM, Milo van der Linden <span dir="ltr"><<a href="mailto:mlinden@zeelandnet.nl">mlinden@zeelandnet.nl</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">I had my IIS crash so severe after a windows update once that it forced<br>me to switch to ms4w...<br><br>
Mostly, it has to do with rights/authentication. Are you sure your IIS<br>user is allowed to connect to your database?<br><br>Daniel Walton schreef:<br>
<div class="im">> Paul,<br>><br>> I got various errors with MapServer running in IIS 7.5 until I<br>> installed the latest build of PHP. Don't know if you've done that<br>> already, but I thought I would mention it.<br>
><br>> Regards,<br>><br>> Dan Walton<br></div>> <a href="http://gisfiretools.com/" target="_blank">gisfiretools.com</a> <<a href="http://gisfiretools.com/" target="_blank">http://gisfiretools.com</a>><br>
<div class="im">><br>><br>> On Thu, Oct 22, 2009 at 9:29 AM, Paul james <<a href="mailto:pauljame@gmail.com">pauljame@gmail.com</a><br></div>
<div class="im">> <mailto:<a href="mailto:pauljame@gmail.com">pauljame@gmail.com</a>>> wrote:<br>><br>> Hi Tamas!<br>> Thanks...<br>><br>> Yes, thats working on Windows 2003/XP...<br>
> The problem is happening only on Windows 7 (IIS 7.5) now...<br>><br>><br>><br>><br>><br>> HTTP Error 502.2 - Bad Gateway<br>><br>> Do you have any idea what is that? Its work fine with postgis...<br>
><br>> Paul<br>><br>><br>> On Wed, Oct 21, 2009 at 5:00 PM, Tamas Szekeres<br></div>
<div>
<div></div>
<div class="h5">> <<a href="mailto:szekerest@gmail.com">szekerest@gmail.com</a> <mailto:<a href="mailto:szekerest@gmail.com">szekerest@gmail.com</a>>> wrote:<br>><br>> Paul,<br>><br>> I've set up your data but it works for me:<br>
><br>> <a href="http://vbkto.dyndns.org/cgi-bin/mapserv.exe?mode=map&map=mssql2008.map" target="_blank">http://vbkto.dyndns.org/cgi-bin/mapserv.exe?mode=map&map=mssql2008.map</a><br>> <<a href="http://vbkto.dyndns.org/cgi-bin/mapserv.exe?mode=map&map=mssql2008.map" target="_blank">http://vbkto.dyndns.org/cgi-bin/mapserv.exe?mode=map&map=mssql2008.map</a>><br>
><br>> tried with the following binaries:<br>><br>> <a href="http://vbkto.dyndns.org/sdk/release-1500-gdal-1-6-mapserver-5-4.zip" target="_blank">http://vbkto.dyndns.org/sdk/release-1500-gdal-1-6-mapserver-5-4.zip</a><br>
> <a href="http://vbkto.dyndns.org/sdk/release-1500-gdal-mapserver.zip" target="_blank">http://vbkto.dyndns.org/sdk/release-1500-gdal-mapserver.zip</a><br>><br>> My mapfile:<br>><br>><br>> MAP<br>
> NAME "SQL2008"<br>> STATUS ON<br>> SIZE 500 500<br>> IMAGETYPE PNG<br>> IMAGECOLOR 254 254 254<br>><br>> EXTENT -79.7892 -44.2426 -24.9958 -9.11775<br>
><br>> LAYER<br>><br>> NAME "tblGeo_AmericaSul"<br>> TYPE POLYGON<br>><br>> CONNECTIONTYPE PLUGIN<br>> PLUGIN "msplugin_mssql2008.dll"<br>
> CONNECTION<br>> "server=.\MSSQLSERVER2008;database=Maps;Integrated Security=true"<br>> DATA "the_geom from tblGeo_AmericaSul USING<br>> UNIQUE CodigoAmericaSul USING SRID=0"<br>
> STATUS DEFAULT<br>><br>> CLASS<br>> STYLE<br>> COLOR 255 0 0<br>> END<br>><br>
> END<br>> END<br>> END<br>><br>><br>> Best regards,<br>><br>> Tamas<br>><br>><br>><br>><br>><br>> 2009/10/21 Paul james <<a href="mailto:pauljame@gmail.com">pauljame@gmail.com</a><br>
</div></div>> <mailto:<a href="mailto:pauljame@gmail.com">pauljame@gmail.com</a>>><br>
<div class="im">><br>> Tamas, the actual error generated is:<br>> HTTP Error 502.2 - Bad Gateway<br>><br>> The specified CGI application misbehaved by not returning<br>> a complete set of HTTP headers. The headers it did return<br>
> are "".<br>><br>> Using Windos 7 (IIS 7)<br>><br>> Testing on Windows 2003, I got just a Blank image (no<br>> error message)...<br>><br>> You can use the same mssql2008 data I sended you last time...<br>
><br>> Paul<br>><br>> On Tue, Oct 20, 2009 at 4:56 PM, Tamas Szekeres<br></div>
<div class="im">> <<a href="mailto:szekerest@gmail.com">szekerest@gmail.com</a> <mailto:<a href="mailto:szekerest@gmail.com">szekerest@gmail.com</a>>> wrote:<br>><br>> Paul,<br>
><br>> I couldn't reproduce your problem by using my data and<br>> the recent mapserv version.<br>> <a href="http://vbkto.dyndns.org/cgi-bin/mapserv.exe?mode=map&map=sql2008.map" target="_blank">http://vbkto.dyndns.org/cgi-bin/mapserv.exe?mode=map&map=sql2008.map</a><br>
> <<a href="http://vbkto.dyndns.org/cgi-bin/mapserv.exe?mode=map&map=sql2008.map" target="_blank">http://vbkto.dyndns.org/cgi-bin/mapserv.exe?mode=map&map=sql2008.map</a>><br>><br>> Could you provide your data for testing?<br>
><br>> Best regards,<br>><br>> Tamas<br>><br>><br>> 2009/10/20 Paul james <<a href="mailto:pauljame@gmail.com">pauljame@gmail.com</a><br></div>> <mailto:<a href="mailto:pauljame@gmail.com">pauljame@gmail.com</a>>><br>
<div class="im">><br>> Hello Tamas<br>> Did you test that?<br>> Paul<br>> On Mon, Oct 19, 2009 at 3:40 PM, Paul james<br></div>
> <<a href="mailto:pauljame@gmail.com">pauljame@gmail.com</a> <mailto:<a href="mailto:pauljame@gmail.com">pauljame@gmail.com</a>>><br>
<div>
<div></div>
<div class="h5">> wrote:<br>><br>> Testing :<br>> <a href="http://localhost/cgi-bin-54/mapserv.exe?map=C:/Mapserver/Mapfile/map.map&mode=map" target="_blank">http://localhost/cgi-bin-54/mapserv.exe?map=C:/Mapserver/Mapfile/map.map&mode=map</a><br>
> <<a href="http://localhost/cgi-bin-54/mapserv.exe?map=C:/Mapserver/Mapfile/map.map&mode=map" target="_blank">http://localhost/cgi-bin-54/mapserv.exe?map=C:/Mapserver/Mapfile/map.map&mode=map</a>><br>
><br>> Using Postgis connection works fine with same<br>> setup...<br>> Using that mapfile with MAPSCRIPT/C# works<br>> fine as well...<br>
><br>> The problem is CGI + MSSQL2008 Plugin<br>><br>><br>> Mapfile:<br>><br>> MAP<br>> EXTENT -79.7892 -34.2426 -24.9958 6.11775<br>
> FONTSET "..\Fontes\Fontes.txt"<br>> IMAGECOLOR 230 254 254<br>> IMAGETYPE png<br>> SIZE 400 200<br>
> STATUS ON<br>> UNITS dd<br>> NAME "Geral"<br>> OUTPUTFORMAT<br>> NAME "png"<br>
> MIMETYPE "image/png"<br>> DRIVER "GD/PNG"<br>> EXTENSION "png"<br>> IMAGEMODE "PC256"<br>
> TRANSPARENT TRUE<br>> END<br>><br>> PROJECTION<br>> 'proj=longlat'<br>> 'ellps=WGS84'<br>
> 'datum=WGS84'<br>> 'no_defs'<br>> END<br>><br>> WEB<br>> IMAGEPATH 'C:\map\temp'<br>
> IMAGEURL '/tmp/'<br>> QUERYFORMAT text/html<br>> LEGENDFORMAT text/html<br>> BROWSEFORMAT text/html<br>
> END<br>><br>> LEGEND<br>> STATUS ON<br>> KEYSIZE 18 12<br>> KEYSPACING 10 5<br>
> IMAGECOLOR 255 255 255<br>> LABEL<br>> TYPE BITMAP<br>> SIZE MEDIUM<br>> COLOR 0 0 89<br>
> END<br>> TEMPLATE "..\template.html"<br>> END<br>><br>> QUERYMAP<br>> COLOR 255 0 0<br>
> SIZE -1 -1<br>> STATUS ON<br>> STYLE hilite<br>> END<br>><br>> REFERENCE<br>
> EXTENT -79.7892 -34.2426 -24.9958 6.11775<br>> IMAGE "..\reference.png"<br>> STATUS on<br>> SIZE 221 150<br>
> MINBOXSIZE 5<br>> MAXBOXSIZE 150<br>> COLOR -1 -1 -1<br>> OUTLINECOLOR 255 0 0<br>> MARKERSIZE 8<br>
> END<br>><br>> LAYER<br>> NAME test<br>> GROUP "tests"<br>> TYPE POLYGON<br>
> STATUS ON<br>> CONNECTIONTYPE PLUGIN<br>> PLUGIN "msplugin_mssql2008.dll"<br>> CONNECTION "server=x;Integrated<br>
> Security=false;database=x;uid=x;pwd=x"<br>> DATA "the_geom from viwgeo_paisbrasil USING<br>> UNIQUE oid USING SRID=0"<br>
> CLASS<br>> COLOR 255 200 255<br>> END<br>> END<br>> END<br>><br>><br>
><br>><br>><br>><br>><br>> _______________________________________________<br>> mapserver-users mailing list<br>> <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
</div></div>> <mailto:<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br>
<div class="im">> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>><br>><br></div>> ------------------------------------------------------------------------<br>
<div>
<div></div>
<div class="h5">><br>> _______________________________________________<br>> mapserver-users mailing list<br>> <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
><br><br></div></div></blockquote></div><br>