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: [email protected] Subject: Re: [mapserver-users] help - mapserver and postgis connection To: [email protected] What happens if you use the IP address instead of the hostname? --- On Sun, 4/29/12, Sean Twomey <[email protected]> wrote: From: Sean Twomey <[email protected]> Subject: [mapserver-users] help - mapserver and postgis connection To: [email protected] 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
