I'm not sure if is just the email doing it or if your CONNECTION string is entirely on one line or not. You might try having a single line if it is wrapped.
You can enable DEBUG in the mapfile & see any error messages. http://mapserver.org/optimization/debugging.html eg: MAP ... CONFIG "MS_ERRORFILE" "/tmp/ms_error.txt" DEBUG 5 ... LAYER ... END END This might have a bit of a learning curve, but is very useful to allow you to view & interact in an onscreen map context with both the source data and the mapserver output. Install QGIS (or uDIG/JUMP/gvSIG/etc) and open the Postgis table directly in that to make sure you see what you expect to. Then modify the mapfile to create a WMS service from the layer (pretty straightforward, as long as you have Apache installed) and then open this at the same time in QGIS, so you can see the native Postgis data & the mapserver WMS version are identical (aligned when they overlay each other) http://mapserver.org/ogc/wms_server.html HTH Brent Wood --- On Wed, 4/27/11, Graham Walker <[email protected]> wrote: From: Graham Walker <[email protected]> Subject: [postgis-users] Postgis -> Mapserver white background To: [email protected] Date: Wednesday, April 27, 2011, 7:26 PM Hi all, fairly new to all this. I was wondering if you could help me with the following issue. I can't seem to display my postgis table in mapserver. I can display shapefiles and html templates fine, but when I try to connect to my postgis table I simply get a white background (or whatever colour I set it as). I have managed to display postgis tables before in mapserver, but I am having no luck in this one and cannot see any differences. Both the shapefile and postgis table can display in qgis. My map file is listed below. I have intentionally tried to simplify this down to the basics so it has no projection details, etc at present. Any help would be greatly appreciated. Thanks MAP NAME "test" IMAGETYPE PNG SIZE 400 500 STATUS ON EXTENT 200949 883531 347001 979508 SHAPEPATH "C:\ms4w\Apache\htdocs\test" UNITS METERS END WEB IMAGEPATH "c:\ms4w\tmp\ms_tmp\" IMAGEURL "/ms_tmp/" END #Region Polygons LAYER NAME "North" CONNECTIONTYPE postgis CONNECTION "user=postgres password=1 dbname=test host=localhost port=5432" DATA "the_geom from North" TYPE POLYGON STATUS DEFAULT CLASS STYLE COLOR 1 1 1 OUTLINECOLOR 1 1 1 END END END _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
