On Sep 22, 2011, at 11:00 PM, Rahkonen Jukka wrote: > Hi, > > Is this really your DATA or did you just wipe our "AS" from "AS foo" when > editing your mail?
There is no difference between `(SELECT...) AS foo` and `(SELECT...) foo`. `AS` is optional in SQL when declaring aliases. > DATA "the_geom FROM (SELECT gid, a, b, the_geom FROM table) foo USING UNIQUE > gid USING srid=4326" > > It really looks like &service=WMS is not compulsory in WMS. Brave programmer > who makes a client to leave it out, though, because it would not cost > anything to include it and make thing for sure clear for a server. > > -Jukka Rahkonen- > > ________________________________________ > Lähettäjä: mapserver-users-boun...@lists.osgeo.org > [mapserver-users-boun...@lists.osgeo.org] käyttäjän Puneet > Kishor [punk.k...@gmail.com] puolesta > Lähetetty: 23. syyskuuta 2011 5:17 > Vastaanottaja: mapserver-users@lists.osgeo.org > Aihe: [mapserver-users] WMS layers get canceled > > I am unable to figure this out -- > > My app front is Google Maps API v3 with MapServer 6.0.1 > > $./mapserv -v > MapServer version 6.0.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG SUPPORTS=PROJ > SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=WMS_SERVER > SUPPORTS=WMS_CLIENT SUPPORTS=GEOS INPUT=POSTGIS INPUT=GDAL INPUT=SHAPEFILE > > The app fires WMS requests that look like so in Firebug and Safari Web > Inspector (one per tile) > > http://path/to/server/cgi-bin/app?version=1.1.1&request=GetMap&format=image/png&TRANSPARENT=TRUE&Styles=&SRS=EPSG:4326&Layers=lyr&width=256&height=256&BBOX=-135,40.97989806962013,-90,66.51326044311185 > > The status code in Firebug is "Aborted" ("Canceled" in Safari Web Inspector). > The ms_error file kicks in the following messages -- > > [Thu Sep 22 21:00:55 2011].347078 msWMSLoadGetMapParams(): enabling > non-square pixels. > [Thu Sep 22 21:00:55 2011].347608 msDrawMap(): kicking into non-square pixel > preserving mode. > [Thu Sep 22 21:00:55 2011].347615 msDrawMap(): rendering using outputformat > named png24 (AGG/PNG). > > My .map file has the following incantation -- > > #### in the MAP section ##### > PROJECTION > "init=epsg:4326" > END > WEB > METADATA > ows_enable_request "*" > wms_abstract "blah blah" > wms_accessconstraints "none" > wms_title "gpsvecs" > wms_onlineresource "http://path/to/server/cgi-bin/gpsvecs?" > wms_srs "EPSG:4326" > wms_keywordlist "foo,bar" > wms_enable_request "*" > END > END > > #### in the LAYER section #### > LAYER > NAME "lyr" > CONNECTION "host=localhost port=5432 dbname=db user=user > password=passwd" > CONNECTIONTYPE POSTGIS > PROCESSING "CLOSE_CONNECTION=DEFER" > DATA "the_geom FROM (SELECT gid, a, b, the_geom FROM table) foo > USING UNIQUE gid USING srid=4326" > > PROJECTION > "init=epsg:4326" > END > > METADATA > wms_srs "EPSG:4326" > wms_title "lyr" > wms_abstract "blah blah" > wms_keywordlist "foo,bar" > wms_enable_request "*" > wms_extent "-180 -90 180 90" > END > > > Suggestions?_______________________________________________ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users