A few guesses/hints...
Perhaps enable DEBUG in your postgis layer, and compare the SQL query
that is generated by shp2img and by the WMS request. What are the
differences? What if you try to run the same SQL query at the psql
prompt or in pgadmin?
Which version of MapServer are you upgrading from? Did the same WMS
request work in that older version?
Daniel
On 11-05-20 01:35 PM, Rob McCulley wrote:
I’m trying to upgrade to Mapserver 6, but I’m having some difficulty
with my PostGIS layers. I’ve made all of the style / symbology changes
required by Version 6, as well as adding the “wms_enable_request” “*”
line to the WEB section. My raster and shapefile layers work fine. Any
mapfile that has a postgis layer won’t work at all. On a GetCapabilities
request, the cgi executable just churns away at 100% CPU usage, but
never produces a result. A GetMap request produces the same result. I
running on windows 7, and I’ve tried the binaries from both MS4W as well
as the ones available from Tamas. I also tried to roll my own, but all
returned the same results.
It doesn’t appear to be a problem with the mapfile or the postgis
access, because shp2img produces images just fine. It’s only WMS
requests that don’t work.
An example mapfile is below. It works fine with shp2img, but hangs on
any WMS request.
Thanks in advance,
Rob McCulley
Mapfile:
MAP
NAME "WMS-test"
STATUS ON
SIZE 800 800
SYMBOLSET symbol.sym
EXTENT 497444 5856659 566947 5971683
UNITS METERS
WEB
IMAGEPATH "/Program Files (x86)/Apache Software
Foundation/Apache2.2/htdocs/tmp/"
IMAGEURL "/tmp/"
METADATA
"ows_enable_request" "*"
"wms_title" "WMS Demo Server"
"wms_onlintresource" "http://localhost/cgi-bin/mapserv.exe?map=wmstest.map&";
"wms_srs" "EPSG:26912"
END
END
CONFIG "PROJ_LIB" "C:/proj/nad/"
PROJECTION
"init=epsg:26912"
END
LAYER
NAME "parcels"
METADATA
"wms_title" "Parcels"
END
TYPE POLYGON
STATUS OFF
CONNECTION "host=gpsserver dbname=CVR user=***** password=*****"
CONNECTIONTYPE postgis
DATA "shape FROM (SELECT id AS oid, geom AS shape FROM titles WHERE
county = 1) AS foo USING UNIQUE oid USING SRID=26912"
PROJECTION
"init=epsg:26912"
END
CLASS
NAME "Parcels"
STYLE
OUTLINECOLOR 0 0 0
END
END
END
END
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
--
Daniel Morissette
http://www.mapgears.com/
Provider of Professional MapServer Support since 2000
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
