Hi Bob,
I suggest you try testing with QGIS. Easy to open the native postgis table & a mapserver WFS/WMS layer concurrently to ensure it is all working as it should. Also ensure you have configured your Postgis (Postgres) database to allow applications such as mapserver to connect. For testing purposes, set access to the database to trusted for all in pb_hba.conf, & enable external connections in postgresql.conf, then restart the server to ensure the changes are activated. You can also enable mapserver debugging & specify a log file to see what error is reported. http://mapserver.org/optimization/debugging.html You may also need to specify the unique ID column name & the SRID you are using in your DATA string, much like this one: DATA "track_line from (select * from trip_track where trip_code = 'ind0701') as foo using unique id using srid 4326" HTH, Brent Wood --- On Tue, 2/14/12, Bistrais, Bob <[email protected]> wrote: From: Bistrais, Bob <[email protected]> Subject: [mapserver-users] Trouble connecting to PostGIS To: [email protected] Date: Tuesday, February 14, 2012, 10:11 AM First of all, let me state that I am brand new to PostGIS and don’t know much about what I’m doing with it. That being said, I am having trouble displaying a PostGIS layer through MapServer. Right now I’m just experimenting with PostGIS and simply trying to get a layer to display. I installed the Postgre and PostGIS 1.5. I used the shapefile loader to convert a couple shapefiles to PostGIS data. Looking in pgAdmin, I see the tables do indeed exist for these layers. So I built a MapServer map file. Here is my connection strings: DATA "the_geom from MylayerPoly" CONNECTION "user=postgisuser password=MyPassword! dbname=postgistest host=localhost port=5432" CONNECTIONTYPE postgis But the layer does not display. Incidentally, I’m using GeoMoose as a front end for testing, but that shouldn’t matter here. I did a mapserv –v at commandline, and I see the parameter INPUT=POSTGIS. So as far as I know it should work. Can anyone offer suggestions as to what I’m doing wrong? Thanks, Bob -----Inline Attachment Follows----- _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
