[postgis-users] connecting to postgis form mapserver

Wed Aug 17 13:09:26 PDT 2011

Hi all,

I am testing out mapserver-postgis and a simple test is returning an empty map. Here is my  map file

MAP
  IMAGETYPE   PNG
  EXTENT 77.5 12.95 77.7 13.01
  SIZE        550 450
  IMAGECOLOR  255 255 255
  SHAPEPATH   "../data"
    # Start of LAYER DEFINITIONS-------------------------------
  LAYER
    CONNECTIONTYPE POSTGIS
                NAME "wards"
    # Connect to a remote spatial database
                CONNECTION "host=localhost port=5432 dbname=empty user=postgres password=xxx"
                  # Get the lines from the 'geom' column of the 'wards' table
                  DATA 'geom from "myschema.wards198" using srid=4326 using unique gid'
                  STATUS ON
                  TYPE POLYGON

    CLASS
      NAME "wards"
      STYLE
        OUTLINECOLOR 255 0 0
      END
    END
  END

  # End of LAYER DEFINITIONS -------------------------------
END
-------------------
And the html that calls it
--------------
<html>
<head>
<title>my postgis map</title>
</head>
<body bgcolor=white>
<center>
<br>
<table width=570>
<tr>
   <td>
     <br>
     <img width=550 height=450
     src=/cgi-bin/mapserv.exe?map=C:\OSGeo4W/apps/mapserver-tutorial/mytests/example.map&mode=map
     border=1>
   </td>
</tr>
</table>
<br>
</body>
</html>
----------------------------------------------------
Other info:
Platform:

-          Windows 7, postgresql9 , postgis 2.0

-          I installed Mapserver separately through the OSGEO4 installer.

-          I can connect to the same database through php

-          I can create simple mapserver apps using shapefiles etc alright (e.g. same map file above, calling a shapefile, works fine)

-          Mapserv.exe -v shows that it was installed with postgis support.

-          Also can Mapserver handle postgis Mulipolygon geometry ok?

I did check most of the points here which seemed ok ( i did not check those in this list that I don't really know how to in Windows ).
http://trac.osgeo.org/mapserver/wiki/PostGIS

I realize this might be a mapserver mailing list qn, but thought that some of you might know the answer...it might be a simple syntax problem that I've missed...

Thanks,
Vishal

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110817/b1ca33a9/attachment.html>