[mapserver-users] help - mapserver and postgis connection

[Sean Twomey]

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>