Res: Re: Res: Re: [UMN_MAPSERVER-USERS] Fw: Postgis Connection
Benjamin Thelen
bt at CCGIS.DE
Fri Jul 1 04:30:40 PDT 2005
Ezequias Rodrigues da Rocha wrote:
> I do heve this line. See below:
>
>
>
> #---------------------------------------------------------------------------
> # CONNECTIONS AND AUTHENTICATION
> #---------------------------------------------------------------------------
>
> # - Connection Settings -
>
> listen_addresses = '*' # what IP interface(s) to listen on;
> # defaults to localhost, '*' = any
> port = 5432
> max_connections = 100
>
> Still waitting
> Ezequias
>
> /-------Mensagem original-------/
>
> /*De:*/ Benjamin Thelen <mailto:bt at ccgis.de>
> /*Data:*/ 07/01/05 05:55:31
> /*Para:*/ Ezequias Rodrigues da Rocha <mailto:ezequias at recife.pe.gov.br>
> /*Cc:*/ Benjamin Thelen <mailto:bt at ccgis.de>
> /*Assunto:*/ Re: Res: Re: [UMN_MAPSERVER-USERS] Fw: Postgis Connection
>
> 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 ?
Ezequias,
You can ping the pgsql-server from your mapserver-server?
# ping lab1.recife
The pgsql-server listens on port 5432? Check with:
# netstat -tan -ptcp.
You corrected the typo "dbname=dbpotgis"?
You are sure about the password for the dbuser? Can you log into the
database from the command line and access the tables?
# psql -Upostgres -ddbpostgis
If you are not sure about the password, change "password" to "trust" in
pg_hba.conf. Also, I would recommend to change "password" to "md5" for
encrypted passwords.
Well, at the moment, I have no more ideas, sorry!
Ben
> >
> > 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>
> > <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>*
> > > <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>
> > <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
>
>
>
>
>
> Add FUN to your email - CLICK HERE!
> <http://www.incredimail.com/index.asp?id=54760>
More information about the MapServer-users
mailing list