Res: Re: Res: Re: [UMN_MAPSERVER-USERS] Res: Re: [UMN_MAPSERVER-USERS] Res: Re: Res: Re: [UMN_MAPSERVER-USERS] Fw: Postgis Connection
Benjamin Thelen
bt at CCGIS.DE
Fri Jul 1 06:18:32 PDT 2005
Ezequias Rodrigues da Rocha wrote:
> lets be clear.
>
> The postgresl user postgres have the pass=post
> The linux postgres user have the pass=' ' (blank)
>
> I only can access the postgres user by linux exiting the root sesstion
> (su - postgres)
>
> Some other person set the passwords for me.
>
> This make any suggestion ?
>
> Best regards
> Ezequias
>
>
> /-------Mensagem original-------/
>
> /*De:*/ Benjamin Thelen <mailto:bt at ccgis.de>
> /*Data:*/ 07/01/05 09:29:44
> /*Para:*/ Ezequias Rodrigues da Rocha <mailto:ezequias at recife.pe.gov.br>
> /*Cc:*/ MAPSERVER-USERS at LISTS.UMN.EDU <mailto:MAPSERVER-USERS at LISTS.UMN.EDU>
> /*Assunto:*/ Re: Res: Re: [UMN_MAPSERVER-USERS] Res: Re:
> [UMN_MAPSERVER-USERS] Res: Re: Res: Re: [UMN_MAPSERVER-USERS] Fw:
> Postgis Connection
>
> Ezequias Rodrigues da Rocha wrote:
> > Some other thing.
> >
> > The server doesn't have the "postgres" user (linux system).
> >
> > The user "postgres" is from the postgresql.
> >
> > I hope you understands what I means.
> >
> > Best regards
> > Ezequias
> >
> > /-------Mensagem original-------/
> >
> > /*De:*/ Benjamin Thelen <mailto:bt at CCGIS.DE>
> > /*Data:*/ 07/01/05 09:02:12
> > /*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] Res: Re: [UMN_MAPSERVER-USERS]
> > Res: Re: Res: Re: [UMN_MAPSERVER-USERS] Fw: Postgis Connection
> >
> > Ezequias Rodrigues da Rocha wrote:
> > > All looks to be correct. I am becoming to be worried.
> > >
> > > ps: Your e-mails are comming twice. Some times three times. Check
> it out.
> > >
> > > Thank you for your attention
> > >
> > > Sincerely
> > > ezequias
> > >
> > > /-------Mensagem original-------/
> > >
> > > /*De:*/ Benjamin Thelen <mailto:bt at CCGIS.DE>
> > > /*Data:*/ 07/01/05 08:16:01
> > > /*Para:*/ MAPSERVER-USERS at LISTS.UMN.EDU
> <mailto: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] Res: Re: Res: Re:
> > > [UMN_MAPSERVER-USERS] Fw: Postgis Connection
> > >
> > > 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>
> > > <mailto: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>
> > > > <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>
> > > > <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>
> > >
> > >
> > > Add FUN to your email - CLICK HERE!
> > > <http://www.incredimail.com/index.asp?id=54760>
> >
> >
> >
> > Ezequias,
> >
> > Please always reply to the list!
> >
> > Of course you receive the mails twice. One Mail goes to the list and the
> > other to you directly. Some list-members only reply to the list, but
> > most reply to both.
> >
> >
> >
> > Another point, please do not top post!
> >
> >
> > I'm afraid, that I have no more ideas! Your problem needs hard debugging
> > ;-).
> >
> > Install pgadmin-III and/or phppgadmin and try to connect to your
> > pgsql-server from your mapserver-server, also you could try to connect
> > from your remote machine from command-line with "psql -Upostgres
> > -hlab1.recife -ddbpostgis".
> >
> >
> > As your machines are on different network segments, it is quite likely,
> > that port 5432 is blocked by a firewall - you have to ask your IT to
> > unlock this port.
> >
> >
> >
> > Ben
> >
> >
> > Add FUN to your email - CLICK HERE!
> > <http://www.incredimail.com/index.asp?id=54760>
>
> Ezequias,
>
> 1. Reply to the list, please.
> 2. Don't top post, please.
> 3. Do not change the subject line, please.
>
>
>
>
> You need to have two accounts, one for the system, to start the
> postmaster and of course on as the database super user, which we are
> talking about.
>
> Did you explicitely change the password for the database super user
> "postgres"?
>
> Ben
>
>
> Add FUN to your email - CLICK HERE!
> <http://www.incredimail.com/index.asp?id=54760>
Ezequias,
If you engage the help of a user list, then the conversation has to be
_over_ _the_ _list_, so that somebody else could take advantage of this
technical support. So please Ezequias, push the "Reply all" button and
post _all_ your answers to list.
Second, you're adviced to continue any conversation at the _end_ of the
mail you are replying to, so that it is much easier for others to follow
the conversation.
Can you access postgres via "psql -Upostgres -ddbpostgis" if you are
logged in as root or some other user - _not_ postgres!? If not, the
pg_hba.conf you sent is likely not the one, your pgsql-Server is using.
If you "psql" into your database, psql "takes" the credentials with
which you are logged into your linux shell. So, either you provide
-U<username> to psql or you type "su - postgres", then you don't need a
"-U".
Ben
More information about the MapServer-users
mailing list