[Geomoose-users] Trouble with PostGis layer on GM 2.2

[Bistrais, Bob]

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