<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
I have had success in displaying my layers from a shapefile folder, but can't re-create from the POSTGIS database.<br> <br>I changed my pg_hba.conf file to this...<br>host DATABASE USER CIDR-ADDRESS METHOD<br>host all all 0.0.0.0/0 md5<br><br>and this:<br> <br>host all all 142.232.0.1/16 md5<br><br>both postgresql.conf file are set to listen to '*' and<br> <br>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...<br> <br>I constantly get this:<br> <br>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? <br> <br>Ideas? Very challenging!!<br> <br>Sean<br><BR> </div></body>
</html>