Res: Re: [UMN_MAPSERVER-USERS] Fw: Postgis Connection

[Benjamin Thelen]

Ezequias Rodrigues da Rocha wrote:
> I didn't find the tcpip_socket parameter and put it in sume point on my 
> postgresql.conf.
>  
> But now I can't start my postgresql 8.0 (# ./postmaster -D 
> /usr/local/pgsql/data)
>  
> Please see what is wrong
>  
> The error reported was:
>  
> [postgres at mangueira bin]$ FATAL:  unrecognized configuration parameter 
> "tcpip_socket"
>  
> My pg_hba.conf is:
>  
> [postgres at mangueira data]$ more pg_hba.conf
> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
>  
> # "local" is for Unix domain socket connections only
> local   all         all                               trust
> # IPv4 local connections:
> host    all         all         10.0.0.0 255.0.0.0    password
> host    all         all         192.168.0.0 255.0.0.0 password
> host    all         all         127.0.0.1/32          trust
> host    all         all         200.249.133.135 255.255.255.255       
> password
> # IPv6 local connections:
> host    all         all         ::1/128               trust
> I believe there is no problem because I am on the network 10 and the 
> server on the 192
>  
> Some more advices ?
>  
> Best regards
> Ezequias
>  
> /-------Mensagem original-------/
>  
> /*De:*/ Benjamin Thelen <mailto:bt at CCGIS.DE>
> /*Data:*/ 06/30/05 12:43:52
> /*Para:*/ MAPSERVER-USERS at LISTS.UMN.EDU 
> <mailto:MAPSERVER-USERS at LISTS.UMN.EDU>
> /*Assunto:*/ Re: [UMN_MAPSERVER-USERS] Fw: Postgis Connection
>  
> Ezequias Rodrigues da Rocha wrote:
>  > I am trying to load a mapserver service with a postgis connection but
>  > the MS reported this message below:
>  >
>  >
>  > msDrawMap(): Image handling error. Failed to draw layer named 'bairros'.
>  > msPOSTGISLayerOpen(): Query error. couldnt make connection to DB with
>  > connect string 'user=postgres password=post dbname=dbpotgis
>  > host=lab1.recife port=5432'.
>  > Error reported was 'could not create socket: Permission denied '.
>  > 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
>  > Does anyone can tell me what to do  ?
>  >
>  >
>  > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  >                                   Atenciosamente (Sincerely)
>  >                         *Ezequias Rodrigues da Rocha*
>  >                                 *** *www.recife.pe.gov.br 
> <http://www.recife.pe.gov.br>*
>  > <http://www.recife.pe.gov.br/>
>  > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  > A pior das democracias ainda é melhor do que a melhor das ditaduras
>  > The worst of democracies is still better than the better of dictatorships
>  >   MSN Messenger: ezequias at hotmail.com <mailto:ezequias at hotmail.com> 
> <mailto:ezequias at hotmail.com>
>  >
>  >
>  > Add FUN to your email - CLICK HERE!
>  > <http://www.incredimail.com/index.asp?id=54760>
>  
>  
> Ezequias,
>  
> Well, I think one cannot make more suggestions you already got from the
> error messages!
>  
> I assume your postgres is running and your connection string is correct,
> but you should send it to the list, too.
>  
> A common error is, that the postgresql-server does not accept tcp/ip
> connections. Check your postgresql.conf: "tcpip_socket = true" must be
> there.
> Second, check your pg_hba.conf: There has to be an entry that allows
> your "mapserver-host" to connect to the server, such as
>  
> for remote access of the network 192.168.100.0:
> host    all         all         192.168.100.0       255.255.255.0     trust
>  
> or for local access, if mapserver and pgsql are on the same host:
> host    all         all         127.0.0.1         255.255.255.255   trust
>  
>  
> Hope, that helps!
>  
> Ben
> 		
> 
> Add FUN to your email - CLICK HERE! 
> <http://www.incredimail.com/index.asp?id=54760>

Ezequias,

As you're using postgresql 8, you must remove the tcpip_socket
parameter, because it's a paramater used in earlier postgresql versions.
Look again into your posgresql.conf. You'll need to have the following
at the beginning of the file:

listen_addresses = '*'	# what IP interface(s) to listen on;
				# defaults to localhost, '*' = any

Restart pgsql.

Ben