[mapserver-users] help - mapserver and postgis connection

[Sean Twomey]

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
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120428/d8b39d23/attachment.htm>