[Fwd: Re: [Mapserver-users] connection string]

[Keith Campbell]

-------- Original Message --------
Subject: 	Re: [Mapserver-users] connection string
Date: 	Thu, 01 Apr 2004 20:56:58 +0100
From: 	Keith Campbell <scoota at supanet.com>
Reply-To: 	scoota at supanet.com
To: 	Johan Duflost <jduflost at ben.vub.ac.be>
References: 	<002c01c417cb$2ac01d90$0200000a at orion>



Johan,

Could be that the host you are on, i.e. your windows box with MapServer, 
is not included in the pg_hba.conf file on the Postgres server you are 
trying to connect to. The pg_hba.conf file controls authentication to 
postgres. Your user name will also need to be included in it, either 
specifically, through a group, or by allowing all users access.

Hope this helps,

Keith

Johan Duflost wrote:

>  
> Hi all,
>  
> I installed mapserver in tomcat under windows and I need to connect to 
> a postgis db on another host but the following error message is returned :
>  
> msPOSTGISLayerOpen(): Query error. couldnt make connection to DB with 
> connect string 'user=pgmap password=pgmap dbname=gis host=canis 
> port=5432'.
> Error reported was 'unknown host name: canis '.
> This error occured when trying to make a connection to the specified 
> postgresql server.
> Most commonly this is caused by
> (1) incorrect connection string
> (2) you didnt specify a 'user=...' in your connection string
> (3) the postmaster (postgresql server) isnt running
> (4) you are not allowing TCP/IP connection to the postmaster
> (5) your postmaster is not running on the correct port - if its not on 
> 5432 you must specify a 'port=...'
> (6) the security on your system does not allow the webserver (usually 
> user 'nobody') to make socket connections to the postmaster
> (7) you forgot to specify a 'host=...' if the postmaster is on a 
> different machine
> (8) you made a typo
>  
> I checked all these possibilities but all of them seem to be right. Is 
> this a bug of mapserver on windows ?
>  
> Does anybody have an idea ?
>  
> Thanks in advance,
>  
> Johan Duflost
>  
> Johan Duflost
> Analyst Programmer
> Belgian Biodiversity Information Facility (BeBIF)
> Universite Libre de Bruxelles (ULB)
> Boulevard du Triomphe - campus de la plaine
> B-1050 Bruxelles
> http://gis.bebif.be