[mapserver-users] help - mapserver and postgis connection
Sean Twomey
stwomey at hotmail.com
Sat Apr 28 12:39:23 PDT 2012
Ha! First timer here... I put my database name into the host= part, and didn't even have dbname= now that I do, it works!!! Wow! Fantastic!!
Date: Sat, 28 Apr 2012 12:33:39 -0700
From: pcreso at yahoo.com
Subject: Re: [mapserver-users] help - mapserver and postgis connection
To: stwomey at hotmail.com
What happens if you use the IP address instead of the hostname?
--- On Sun, 4/29/12, Sean Twomey <stwomey at hotmail.com> wrote:
From: Sean Twomey <stwomey at hotmail.com>
Subject: [mapserver-users] help - mapserver and postgis connection
To: mapserver-users at lists.osgeo.org
Date: Sunday, April 29, 2012, 7:15 AM
I have had success in displaying my layers from a shapefile folder, but can't re-create from the POSTGIS database.
I changed my pg_hba.conf file to this...
host DATABASE USER CIDR-ADDRESS METHOD
host all all 0.0.0.0/0 md5
and this:
host all all 142.232.0.1/16 md5
both postgresql.conf file are set to listen to '*' and
I have flopped from port 5432 (v. 9.1) to 5433 (v. 8.4), I apparently have both postgresql 8.4 and 9.1 running...
I constantly get this:
msDrawMap(): Image handling error. Failed to draw layer named 'en_grantedonly_soionly'. msPostGISLayerOpen(): Query error. Database connection failed (could not translate host name "htgProject" to address: Name or service not known ) with connect string 'host=htgProject port=5432 user=stwomey password=*********' Is the database running? Is it allowing connections? Does the specified user exist? Is the password valid? Is
the database on the standard port?
Ideas? Very challenging!!
Sean
-----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/20120428/5e8a2054/attachment.htm>
More information about the MapServer-users
mailing list