I'm going to try a copy of the mapfile here and see what happens... Will report back later today.
Steve -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jeff McKenna Sent: Tuesday, November 22, 2011 8:36 AM To: [email protected] Subject: Re: [mapserver-users] Problem with Variable Substitution for EXPRESSION Hello, If I was in your situation, I would follow Steve's advice and test it through the commandline (mapserv -nh QUERY_STRING="blah") to test your request in normal CGI mode. Then if all else fails, create a very small one layer mapfile with a tiny data file and package that with a requests.txt file, and submit that to the MapServer Issue Tracker, or event point to it here on the list. -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ On 11-11-22 5:25 AM, Prabu Raja wrote: > Hi Steve / Daniel, > > I am using ms4w from http://maptools.org/ms4w/index.phtml in Windows 7. > > Following is my map file content. > > MAP > NAME ms_sql > IMAGECOLOR 255 255 255 > # default output image dimensions > SIZE 256 256 > # Is the map active? Sometimes you may wish to turn this off to > # use only the reference map or scale bar. > STATUS ON > CONFIG "MS_ERRORFILE" "\var\Map\error.txt" > DEBUG 0 > # set top level projection > PROJECTION > "init=epsg:4326" > END > # image format options > OUTPUTFORMAT > NAME "png" > DRIVER AGG/PNG > MIMETYPE "image/png" > IMAGEMODE RGBA > EXTENSION "png" > TRANSPARENT ON > FORMATOPTION "GAMMA=0.75" > END > EXTENT -180 -90 180 90 # World > > LAYER > VALIDATION > 'V1' '^[-+]?[0-9]*\.?[0-9]+$' > 'V2' '^[-+]?[0-9]*\.?[0-9]+$' > 'V3' '^[-+]?[0-9]*\.?[0-9]+$' > 'V4' '^[-+]?[0-9]*\.?[0-9]+$' > 'V5' '^[-+]?[0-9]*\.?[0-9]+$' > 'V6' '^[-+]?[0-9]*\.?[0-9]+$' > END > NAME "state" > TYPE polygon > STATUS ON > CONNECTIONTYPE POSTGIS > CONNECTION "host=localhost dbname=pollutionmap user=*** > password=*** port=5432" > DATA "wkb_geometry FROM (SELECT ogc_fid AS > oid, wkb_geometry, totpop1 FROM state_tst) AS SUBQUERY using unique oid" > PROCESSING "CLOSE_CONNECTION=DEFER" > CLASSITEM "totpop1" > OPACITY 100 > CLASS > EXPRESSION ([TOTPOP1] >= %V1% AND [TOTPOP1] < %V2%) > STYLE > COLOR 255 108 118 > OUTLINECOLOR 255 255 255 > END > END > CLASS > EXPRESSION ([TOTPOP1] >= %V2% AND [TOTPOP1] < %V3%) > STYLE > COLOR 254 189 75 > OUTLINECOLOR 255 255 255 > END > END > CLASS > EXPRESSION ([TOTPOP1] >= %V3% AND [TOTPOP1] < %V4%) > STYLE > COLOR 254 247 46 > OUTLINECOLOR 255 255 255 > END > END > CLASS > EXPRESSION ([TOTPOP1] >= %V4% AND [TOTPOP1] < %V5%) > STYLE > COLOR 39 251 114 > OUTLINECOLOR 255 255 255 > END > END > CLASS > EXPRESSION ([TOTPOP1] >= %V5% AND [TOTPOP1] <= %V6%) > STYLE > COLOR 108 111 205 > OUTLINECOLOR 255 255 255 > END > END > END > END > > Below are the url's through I am trying to generate map > > http://localhost/fcgi-bin/mapserv.exe?map=/var/Map/State.map&layers=state&mode=map&V1=60650.45&V2=33288104.54&V3=66515558.222&V4=99743012.123&V5=132970466.455&V6=166197921.245 > <http://localhost/fcgi-bin/mapserv.exe?map=/var/Map/State.map&layers=state&mode=map&V1=60650.45&V2=33288104.54&V3=66515558.222&V4=99743012.123&V5=132970466.455&V6=166197921.245> > > http://localhost/fcgi-bin/mapserv.exe?map=/var/Map/State.map&layers=state&mode=map&V1=60650&V2=33288104&V3=66515558&V4=99743012&V5=132970466&V6=166197921 > <http://localhost/fcgi-bin/mapserv.exe?map=/var/Map/State.map&layers=state&mode=map&V1=60650&V2=33288104&V3=66515558&V4=99743012&V5=132970466&V6=166197921> > > > Accessing through above 2 url gives '500 Internal Server Error'. > No error message in mapserver log. > > Following error message logged in apache error log. > [warn] [client 127.0.0.1] (OS 109)The pipe has been ended. : mod_fcgid: > get overlap result error > [error] [client 127.0.0.1] Premature end of script headers: mapserv.exe > > And following was logged in appache access log > > GET > /fcgi-bin/mapserv.exe?map=/var/Map/State.map&layers=state&mode=map&V1=60650.45&V2=33288104.54&V3=66515558.222&V4=99743012.123&V5=132970466.455&V6=166197921.245 > HTTP/1.1" 500 533 > > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
