[mapserver-users] Problem with Variable Substitution for EXPRESSION

[Jeff McKenna]

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
>
>