[mapserver-users] Trouble connecting to PostGIS

[Bistrais, Bob]

I think we're out of the woods, and special thanks to TC Haddad for the
solution...

 

TC suggested that I check the upper/lower case of the table name.  I had
this correct, but it gave me an idea of something to try- I created a
new table of the same shapefile, only this time the table name is all
lower case.  Using that in my map file, the map image appears correctly.

 

Thanks everyone for their input!  I'm sure it won't be the last ou hear
from me on PostGIS, but at least we're off and running!

 

BB

 

 

________________________________

From: pcreso at pcreso.com [mailto:pcreso at pcreso.com] 
Sent: Monday, February 13, 2012 5:01 PM
To: mapserver-users at lists.osgeo.org; Bistrais, Bob
Subject: Re: [mapserver-users] Trouble connecting to PostGIS

 

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/acc48869/attachment.htm>