[mapserver-users] Trouble connecting to PostGIS

[pcreso at pcreso.com]

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 <Bob.Bistrais at maine.gov> wrote:

From: Bistrais, Bob <Bob.Bistrais at maine.gov>
Subject: [mapserver-users] Trouble connecting to PostGIS
To: mapserver-users at lists.osgeo.org
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
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120213/fcff9c64/attachment.htm>