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

[Brent Fraser]

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/a4cbad69/attachment.html