<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'>
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!!<br><br><div><div dir="ltr"><div> </div><br> <p><br><div><div id="ecxSkyDrivePlaceholder"></div><hr id="ecxstopSpelling">Date: Sat, 28 Apr 2012 12:33:39 -0700<br>From: pcreso@yahoo.com<br>Subject: Re: [mapserver-users] help - mapserver and postgis connection<br>To: stwomey@hotmail.com<br><br><table border="0" cellSpacing="0" cellPadding="0"><tbody><tr><td style="font: inherit; font-size-adjust: inherit; font-stretch: inherit;" vAlign="top">What happens if you use the IP address instead of the hostname?<br><br>--- On <b>Sun, 4/29/12, Sean Twomey <i><stwomey@hotmail.com></i></b> wrote:<br><blockquote style="padding-left: 5px; margin-left: 5px;"><br>From: Sean Twomey <stwomey@hotmail.com><br>Subject: [mapserver-users] help - mapserver and postgis connection<br>To: mapserver-users@lists.osgeo.org<br>Date: Sunday, April 29, 2012, 7:15 AM<br><br><div id="ecxyiv537006542">
<style><!--
.ExternalClass #ecxyiv537006542 .ecxyiv537006542hmmessage P
{padding:0px;}
.ExternalClass #ecxyiv537006542 body.ecxyiv537006542hmmessage
{font-size:10pt;font-family:Tahoma;}
--></style>
<div><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></div>
</div><br>-----Inline Attachment Follows-----<br><br><div class="ecxplainMail">_______________________________________________<br>mapserver-users mailing list<br><a href="http:///mc/compose?to=mapserver-users%40lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></div></blockquote></td></tr></tbody></table></div> </div></div> </div></body>
</html>