[Geomoose-users] Trouble with PostGis layer on GM 2.2
Bistrais, Bob
Bob.Bistrais at maine.gov
Thu Feb 16 09:52:59 EST 2012
Yes, as it turns out, that's what I had to do and it's working now.
________________________________
From: Brent Fraser [mailto:bfraser at geoanalytic.com]
Sent: Thursday, February 16, 2012 9:37 AM
To: Bistrais, Bob
Cc: Geomoose-users at lists.osgeo.org
Subject: Re: [Geomoose-users] Trouble with PostGis layer on GM 2.2
If your PostGIS server and mapserver are on different computers, make
sure you've enabled Postgres to accept remote connects (edit
pg_hba.conf).
Best Regards,
Brent Fraser
On 2/15/2012 12:50 PM, Bistrais, Bob wrote:
Trying to implement some layers through PostGIS, and I'm a PG newbie
(some of you have seen my struggles on the other lists). But now I am
having trouble displaying a layer in GeoMoose 2.2. I think this may be
related to the MapServer version, as this same layer works fine with
MapServer 6.0.1
The error message is as follows:
msPOSTGISLayerOpen(): Query error. Couldn't make connection to DB with
connect string
The connection strings:
DATA "the_geom from bb_connectme_rds USING SRID=26919 USING Unique
gid"
CONNECTION "user=myusername password=mypassword dbname=postgistest
host=mymachinename port=5432"
CONNECTIONTYPE postgis
PROCESSING "CLOSE_CONNECTION=DEFER"
As I mentioned, this all works fine on another service using MapServer
6.0.1. Does PostGis work with GM 2.2? If so, does it look like my
connection strings are incorrect?
_______________________________________________
Geomoose-users mailing list
Geomoose-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/geomoose-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20120216/63fef8b7/attachment.html
More information about the Geomoose-users
mailing list