<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="IncrediMail 1.0" name=GENERATOR></HEAD>
<BODY style="BACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px 10px 10px; FONT-FAMILY: Arial" bgColor=#ffffff background="" scroll=yes ORGYPOS="0">
<TABLE id=INCREDIMAINTABLE cellSpacing=0 cellPadding=2 width="100%" border=0>
<TBODY>
<TR>
<TD id=INCREDITEXTREGION style="FONT-SIZE: 12pt; CURSOR: auto; FONT-FAMILY: Arial" width="100%">
<DIV> </DIV>
<DIV> </DIV>
<DIV id=IncrediOriginalMessage><I>-------Mensagem original-------</I></DIV>
<DIV> </DIV>
<DIV id=receivestrings>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>De:</B></I> <A href="mailto:bt@ccgis.de">Benjamin Thelen</A></DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Data:</B></I> 07/01/05 10:02:54</DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Para:</B></I> <A href="mailto:ezequias@recife.pe.gov.br">Ezequias Rodrigues da Rocha</A></DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Cc:</B></I> <A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</A></DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Assunto:</B></I> Re: Res: Re: Res: Re: [UMN_MAPSERVER-USERS] Res: Re: [UMN_MAPSERVER-USERS] Res: Re: Res: Re: [UMN_MAPSERVER-USERS] Fw: Postgis Connection</DIV></DIV>
<DIV> </DIV>
<DIV>Ezequias Rodrigues da Rocha wrote:</DIV>
<DIV>> lets be clear.</DIV>
<DIV>></DIV>
<DIV>> The postgresl user postgres have the pass=post</DIV>
<DIV>> The linux postgres user have the pass=' ' (blank)</DIV>
<DIV>></DIV>
<DIV>> I only can access the postgres user by linux exiting the root sesstion</DIV>
<DIV>> (su - postgres)</DIV>
<DIV>></DIV>
<DIV>> Some other person set the passwords for me.</DIV>
<DIV>></DIV>
<DIV>> This make any suggestion ?</DIV>
<DIV>></DIV>
<DIV>> Best regards</DIV>
<DIV>> Ezequias</DIV>
<DIV>></DIV>
<DIV>></DIV>
<DIV>> /-------Mensagem original-------/</DIV>
<DIV>></DIV>
<DIV>> /*De:*/ Benjamin Thelen <<A href="mailto:bt@ccgis.de">mailto:bt@ccgis.de</A>></DIV>
<DIV>> /*Data:*/ 07/01/05 09:29:44</DIV>
<DIV>> /*Para:*/ Ezequias Rodrigues da Rocha <<A href="mailto:ezequias@recife.pe.gov.br">mailto:ezequias@recife.pe.gov.br</A>></DIV>
<DIV>> /*Cc:*/ <A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</A> <<A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">mailto:MAPSERVER-USERS@LISTS.UMN.EDU</A>></DIV>
<DIV>> /*Assunto:*/ Re: Res: Re: [UMN_MAPSERVER-USERS] Res: Re:</DIV>
<DIV>> [UMN_MAPSERVER-USERS] Res: Re: Res: Re: [UMN_MAPSERVER-USERS] Fw:</DIV>
<DIV>> Postgis Connection</DIV>
<DIV>></DIV>
<DIV>> Ezequias Rodrigues da Rocha wrote:</DIV>
<DIV>> > Some other thing.</DIV>
<DIV>> ></DIV>
<DIV>> > The server doesn't have the "postgres" user (linux system).</DIV>
<DIV>> ></DIV>
<DIV>> > The user "postgres" is from the postgresql.</DIV>
<DIV>> ></DIV>
<DIV>> > I hope you understands what I means.</DIV>
<DIV>> ></DIV>
<DIV>> > Best regards</DIV>
<DIV>> > Ezequias</DIV>
<DIV>> ></DIV>
<DIV>> > /-------Mensagem original-------/</DIV>
<DIV>> ></DIV>
<DIV>> > /*De:*/ Benjamin Thelen <<A href="mailto:bt@CCGIS.DE">mailto:bt@CCGIS.DE</A>></DIV>
<DIV>> > /*Data:*/ 07/01/05 09:02:12</DIV>
<DIV>> > /*Para:*/ <A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</A></DIV>
<DIV>> <<A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">mailto:MAPSERVER-USERS@LISTS.UMN.EDU</A>></DIV>
<DIV>> > <<A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">mailto:MAPSERVER-USERS@LISTS.UMN.EDU</A>></DIV>
<DIV>> > /*Assunto:*/ Re: [UMN_MAPSERVER-USERS] Res: Re: [UMN_MAPSERVER-USERS]</DIV>
<DIV>> > Res: Re: Res: Re: [UMN_MAPSERVER-USERS] Fw: Postgis Connection</DIV>
<DIV>> ></DIV>
<DIV>> > Ezequias Rodrigues da Rocha wrote:</DIV>
<DIV>> > > All looks to be correct. I am becoming to be worried.</DIV>
<DIV>> > ></DIV>
<DIV>> > > ps: Your e-mails are comming twice. Some times three times. Check</DIV>
<DIV>> it out.</DIV>
<DIV>> > ></DIV>
<DIV>> > > Thank you for your attention</DIV>
<DIV>> > ></DIV>
<DIV>> > > Sincerely</DIV>
<DIV>> > > ezequias</DIV>
<DIV>> > ></DIV>
<DIV>> > > /-------Mensagem original-------/</DIV>
<DIV>> > ></DIV>
<DIV>> > > /*De:*/ Benjamin Thelen <<A href="mailto:bt@CCGIS.DE">mailto:bt@CCGIS.DE</A>></DIV>
<DIV>> > > /*Data:*/ 07/01/05 08:16:01</DIV>
<DIV>> > > /*Para:*/ <A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</A></DIV>
<DIV>> <<A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">mailto:MAPSERVER-USERS@LISTS.UMN.EDU</A>></DIV>
<DIV>> > <<A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">mailto:MAPSERVER-USERS@LISTS.UMN.EDU</A>></DIV>
<DIV>> > > <<A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">mailto:MAPSERVER-USERS@LISTS.UMN.EDU</A>></DIV>
<DIV>> > > /*Assunto:*/ Re: [UMN_MAPSERVER-USERS] Res: Re: Res: Re:</DIV>
<DIV>> > > [UMN_MAPSERVER-USERS] Fw: Postgis Connection</DIV>
<DIV>> > ></DIV>
<DIV>> > > Ezequias Rodrigues da Rocha wrote:</DIV>
<DIV>> > > > I do heve this line. See below:</DIV>
<DIV>> > > ></DIV>
<DIV>> > > ></DIV>
<DIV>> > > ></DIV>
<DIV>> > > ></DIV>
<DIV>> > ></DIV>
<DIV>> ></DIV>
<DIV>> #---------------------------------------------------------------------------</DIV>
<DIV>> > > > # CONNECTIONS AND AUTHENTICATION</DIV>
<DIV>> > > ></DIV>
<DIV>> > ></DIV>
<DIV>> ></DIV>
<DIV>> #---------------------------------------------------------------------------</DIV>
<DIV>> > > ></DIV>
<DIV>> > > > # - Connection Settings -</DIV>
<DIV>> > > ></DIV>
<DIV>> > > > listen_addresses = '*' # what IP interface(s) to listen on;</DIV>
<DIV>> > > > # defaults to localhost, '*' = any</DIV>
<DIV>> > > > port = 5432</DIV>
<DIV>> > > > max_connections = 100</DIV>
<DIV>> > > ></DIV>
<DIV>> > > > Still waitting</DIV>
<DIV>> > > > Ezequias</DIV>
<DIV>> > > ></DIV>
<DIV>> > > > /-------Mensagem original-------/</DIV>
<DIV>> > > ></DIV>
<DIV>> > > > /*De:*/ Benjamin Thelen <<A href="mailto:bt@ccgis.de">mailto:bt@ccgis.de</A>></DIV>
<DIV>> > > > /*Data:*/ 07/01/05 05:55:31</DIV>
<DIV>> > > > /*Para:*/ Ezequias Rodrigues da Rocha</DIV>
<DIV>> > <<A href="mailto:ezequias@recife.pe.gov.br">mailto:ezequias@recife.pe.gov.br</A>></DIV>
<DIV>> > > > /*Cc:*/ Benjamin Thelen <<A href="mailto:bt@ccgis.de">mailto:bt@ccgis.de</A>></DIV>
<DIV>> > > > /*Assunto:*/ Re: Res: Re: [UMN_MAPSERVER-USERS] Fw: Postgis</DIV>
<DIV>> Connection</DIV>
<DIV>> > > ></DIV>
<DIV>> > > > Ezequias Rodrigues da Rocha wrote:</DIV>
<DIV>> > > > > I didn't find the tcpip_socket parameter and put it in sume</DIV>
<DIV>> point</DIV>
<DIV>> > > on my</DIV>
<DIV>> > > > > postgresql.conf.</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > But now I can't start my postgresql 8.0 (# ./postmaster -D</DIV>
<DIV>> > > > > /usr/local/pgsql/data)</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > Please see what is wrong</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > The error reported was:</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > [postgres@mangueira bin]$ FATAL: unrecognized configuration</DIV>
<DIV>> > parameter</DIV>
<DIV>> > > > > "tcpip_socket"</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > My pg_hba.conf is:</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > [postgres@mangueira data]$ more pg_hba.conf</DIV>
<DIV>> > > > > # TYPE DATABASE USER CIDR-ADDRESS METHOD</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > # "local" is for Unix domain socket connections only</DIV>
<DIV>> > > > > local all all trust</DIV>
<DIV>> > > > > # IPv4 local connections:</DIV>
<DIV>> > > > > host all all 10.0.0.0 255.0.0.0 password</DIV>
<DIV>> > > > > host all all 192.168.0.0 255.0.0.0 password</DIV>
<DIV>> > > > > host all all 127.0.0.1/32 trust</DIV>
<DIV>> > > > > host all all 200.249.133.135 255.255.255.255</DIV>
<DIV>> > > > > password</DIV>
<DIV>> > > > > # IPv6 local connections:</DIV>
<DIV>> > > > > host all all ::1/128 trust</DIV>
<DIV>> > > > > I believe there is no problem because I am on the network 10</DIV>
<DIV>> > and the</DIV>
<DIV>> > > > > server on the 192</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > Some more advices ?</DIV>
<DIV>> > ></DIV>
<DIV>> > ></DIV>
<DIV>> > > Ezequias,</DIV>
<DIV>> > ></DIV>
<DIV>> > > You can ping the pgsql-server from your mapserver-server?</DIV>
<DIV>> > > # ping lab1.recife</DIV>
<DIV>> > ></DIV>
<DIV>> > > The pgsql-server listens on port 5432? Check with:</DIV>
<DIV>> > > # netstat -tan -ptcp.</DIV>
<DIV>> > ></DIV>
<DIV>> > > You corrected the typo "dbname=dbpotgis"?</DIV>
<DIV>> > > You are sure about the password for the dbuser? Can you log into the</DIV>
<DIV>> > > database from the command line and access the tables?</DIV>
<DIV>> > > # psql -Upostgres -ddbpostgis</DIV>
<DIV>> > ></DIV>
<DIV>> > > If you are not sure about the password, change "password" to</DIV>
<DIV>> "trust" in</DIV>
<DIV>> > > pg_hba.conf. Also, I would recommend to change "password" to "md5" for</DIV>
<DIV>> > > encrypted passwords.</DIV>
<DIV>> > ></DIV>
<DIV>> > ></DIV>
<DIV>> > > Well, at the moment, I have no more ideas, sorry!</DIV>
<DIV>> > ></DIV>
<DIV>> > > Ben</DIV>
<DIV>> > ></DIV>
<DIV>> > ></DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > Best regards</DIV>
<DIV>> > > > > Ezequias</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > /-------Mensagem original-------/</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > /*De:*/ Benjamin Thelen <<A href="mailto:bt@CCGIS.DE">mailto:bt@CCGIS.DE</A>></DIV>
<DIV>> > > > > /*Data:*/ 06/30/05 12:43:52</DIV>
<DIV>> > > > > /*Para:*/ <A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</A></DIV>
<DIV>> <<A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">mailto:MAPSERVER-USERS@LISTS.UMN.EDU</A>></DIV>
<DIV>> > <<A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">mailto:MAPSERVER-USERS@LISTS.UMN.EDU</A>></DIV>
<DIV>> > > <<A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">mailto:MAPSERVER-USERS@LISTS.UMN.EDU</A>></DIV>
<DIV>> > > > <<A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">mailto:MAPSERVER-USERS@LISTS.UMN.EDU</A>></DIV>
<DIV>> > > > > <<A href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">mailto:MAPSERVER-USERS@LISTS.UMN.EDU</A>></DIV>
<DIV>> > > > > /*Assunto:*/ Re: [UMN_MAPSERVER-USERS] Fw: Postgis Connection</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > Ezequias Rodrigues da Rocha wrote:</DIV>
<DIV>> > > > > > I am trying to load a mapserver service with a postgis</DIV>
<DIV>> > > connection but</DIV>
<DIV>> > > > > > the MS reported this message below:</DIV>
<DIV>> > > > > ></DIV>
<DIV>> > > > > ></DIV>
<DIV>> > > > > > msDrawMap(): Image handling error. Failed to draw layer named</DIV>
<DIV>> > > > 'bairros'.</DIV>
<DIV>> > > > > > msPOSTGISLayerOpen(): Query error. couldnt make connection to</DIV>
<DIV>> > > DB with</DIV>
<DIV>> > > > > > connect string 'user=postgres password=post dbname=dbpotgis</DIV>
<DIV>> > > > > > host=lab1.recife port=5432'.</DIV>
<DIV>> > > > > > Error reported was 'could not create socket: Permission</DIV>
<DIV>> > denied '.</DIV>
<DIV>> > > > > > This error occured when trying to make a connection to the</DIV>
<DIV>> > > specified</DIV>
<DIV>> > > > > > postgresql server.</DIV>
<DIV>> > > > > > Most commonly this is caused by</DIV>
<DIV>> > > > > > (1) incorrect connection string</DIV>
<DIV>> > > > > > (2) you didnt specify a 'user=...' in your connection string</DIV>
<DIV>> > > > > > (3) the postmaster (postgresql server) isnt running</DIV>
<DIV>> > > > > > (4) you are not allowing TCP/IP connection to the postmaster</DIV>
<DIV>> > > > > > (5) your postmaster is not running on the correct port -</DIV>
<DIV>> if its</DIV>
<DIV>> > > not on</DIV>
<DIV>> > > > > > 5432 you must specify a 'port=...'</DIV>
<DIV>> > > > > > (6) the security on your system does not allow the webserver</DIV>
<DIV>> > > (usually</DIV>
<DIV>> > > > > > user 'nobody') to make socket connections to the postmaster</DIV>
<DIV>> > > > > > (7) you forgot to specify a 'host=...' if the postmaster</DIV>
<DIV>> is on a</DIV>
<DIV>> > > > > > different machine</DIV>
<DIV>> > > > > > (8) you made a typo</DIV>
<DIV>> > > > > > Does anyone can tell me what to do ?</DIV>
<DIV>> > > > > ></DIV>
<DIV>> > > > > ></DIV>
<DIV>> > > > > ></DIV>
<DIV>> > > ></DIV>
<DIV>> > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-</DIV>
<DIV>> > > > > > Atenciosamente (Sincerely)</DIV>
<DIV>> > > > > > *Ezequias Rodrigues da Rocha*</DIV>
<DIV>> > > > > > *** *<A href="http://www.recife.pe.gov.br">www.recife.pe.gov.br</A></DIV>
<DIV>> <<A href="http://www.recife.pe.gov.br">http://www.recife.pe.gov.br</A>></DIV>
<DIV>> > <<A href="http://www.recife.pe.gov.br">http://www.recife.pe.gov.br</A>></DIV>
<DIV>> > > <<A href="http://www.recife.pe.gov.br">http://www.recife.pe.gov.br</A>></DIV>
<DIV>> > > > <<A href="http://www.recife.pe.gov.br">http://www.recife.pe.gov.br</A>></DIV>
<DIV>> > > > > <<A href="http://www.recife.pe.gov.br">http://www.recife.pe.gov.br</A>>*</DIV>
<DIV>> > > > > > <<A href="http://www.recife.pe.gov.br/">http://www.recife.pe.gov.br/</A>></DIV>
<DIV>> > > > > ></DIV>
<DIV>> > > ></DIV>
<DIV>> > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-</DIV>
<DIV>> > > > > > A pior das democracias ainda é melhor do que a melhor das</DIV>
<DIV>> > ditaduras</DIV>
<DIV>> > > > > > The worst of democracies is still better than the better of</DIV>
<DIV>> > > > dictatorships</DIV>
<DIV>> > > > > > MSN Messenger: <A href="mailto:ezequias@hotmail.com">ezequias@hotmail.com</A></DIV>
<DIV>> <<A href="mailto:ezequias@hotmail.com">mailto:ezequias@hotmail.com</A>></DIV>
<DIV>> > <<A href="mailto:ezequias@hotmail.com">mailto:ezequias@hotmail.com</A>> <<A href="mailto:ezequias@hotmail.com">mailto:ezequias@hotmail.com</A>></DIV>
<DIV>> > > > <<A href="mailto:ezequias@hotmail.com">mailto:ezequias@hotmail.com</A>> <<A href="mailto:ezequias@hotmail.com">mailto:ezequias@hotmail.com</A>></DIV>
<DIV>> > > > > <<A href="mailto:ezequias@hotmail.com">mailto:ezequias@hotmail.com</A>></DIV>
<DIV>> > > > > ></DIV>
<DIV>> > > > > ></DIV>
<DIV>> > > > > > Add FUN to your email - CLICK HERE!</DIV>
<DIV>> > > > > > <<A href="http://www.incredimail.com/index.asp?id=54760">http://www.incredimail.com/index.asp?id=54760</A>></DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > Ezequias,</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > Well, I think one cannot make more suggestions you already got</DIV>
<DIV>> > > from the</DIV>
<DIV>> > > > > error messages!</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > I assume your postgres is running and your connection string is</DIV>
<DIV>> > > correct,</DIV>
<DIV>> > > > > but you should send it to the list, too.</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > A common error is, that the postgresql-server does not accept</DIV>
<DIV>> > tcp/ip</DIV>
<DIV>> > > > > connections. Check your postgresql.conf: "tcpip_socket = true"</DIV>
<DIV>> > must be</DIV>
<DIV>> > > > > there.</DIV>
<DIV>> > > > > Second, check your pg_hba.conf: There has to be an entry that</DIV>
<DIV>> > allows</DIV>
<DIV>> > > > > your "mapserver-host" to connect to the server, such as</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > for remote access of the network 192.168.100.0:</DIV>
<DIV>> > > > > host all all 192.168.100.0</DIV>
<DIV>> 255.255.255.0</DIV>
<DIV>> > > > trust</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > or for local access, if mapserver and pgsql are on the same</DIV>
<DIV>> host:</DIV>
<DIV>> > > > > host all all 127.0.0.1</DIV>
<DIV>> > > 255.255.255.255 trust</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > Hope, that helps!</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > Ben</DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > ></DIV>
<DIV>> > > > > Add FUN to your email - CLICK HERE!</DIV>
<DIV>> > > > > <<A href="http://www.incredimail.com/index.asp?id=54760">http://www.incredimail.com/index.asp?id=54760</A>></DIV>
<DIV>> > > ></DIV>
<DIV>> > > > Ezequias,</DIV>
<DIV>> > > ></DIV>
<DIV>> > > > As you're using postgresql 8, you must remove the tcpip_socket</DIV>
<DIV>> > > > parameter, because it's a paramater used in earlier postgresql</DIV>
<DIV>> > versions.</DIV>
<DIV>> > > > Look again into your posgresql.conf. You'll need to have the</DIV>
<DIV>> following</DIV>
<DIV>> > > > at the beginning of the file:</DIV>
<DIV>> > > ></DIV>
<DIV>> > > > listen_addresses = '*' # what IP interface(s) to listen on;</DIV>
<DIV>> > > > # defaults to localhost, '*' = any</DIV>
<DIV>> > > ></DIV>
<DIV>> > > > Restart pgsql.</DIV>
<DIV>> > > ></DIV>
<DIV>> > > > Ben</DIV>
<DIV>> > > ></DIV>
<DIV>> > > ></DIV>
<DIV>> > > ></DIV>
<DIV>> > > ></DIV>
<DIV>> > > ></DIV>
<DIV>> > > > Add FUN to your email - CLICK HERE!</DIV>
<DIV>> > > > <<A href="http://www.incredimail.com/index.asp?id=54760">http://www.incredimail.com/index.asp?id=54760</A>></DIV>
<DIV>> > ></DIV>
<DIV>> > ></DIV>
<DIV>> > > Add FUN to your email - CLICK HERE!</DIV>
<DIV>> > > <<A href="http://www.incredimail.com/index.asp?id=54760">http://www.incredimail.com/index.asp?id=54760</A>></DIV>
<DIV>> ></DIV>
<DIV>> ></DIV>
<DIV>> ></DIV>
<DIV>> > Ezequias,</DIV>
<DIV>> ></DIV>
<DIV>> > Please always reply to the list!</DIV>
<DIV>> ></DIV>
<DIV>> > Of course you receive the mails twice. One Mail goes to the list and the</DIV>
<DIV>> > other to you directly. Some list-members only reply to the list, but</DIV>
<DIV>> > most reply to both.</DIV>
<DIV>> ></DIV>
<DIV>> ></DIV>
<DIV>> ></DIV>
<DIV>> > Another point, please do not top post!</DIV>
<DIV>> ></DIV>
<DIV>> ></DIV>
<DIV>> > I'm afraid, that I have no more ideas! Your problem needs hard debugging</DIV>
<DIV>> > ;-).</DIV>
<DIV>> ></DIV>
<DIV>> > Install pgadmin-III and/or phppgadmin and try to connect to your</DIV>
<DIV>> > pgsql-server from your mapserver-server, also you could try to connect</DIV>
<DIV>> > from your remote machine from command-line with "psql -Upostgres</DIV>
<DIV>> > -hlab1.recife -ddbpostgis".</DIV>
<DIV>> ></DIV>
<DIV>> ></DIV>
<DIV>> > As your machines are on different network segments, it is quite likely,</DIV>
<DIV>> > that port 5432 is blocked by a firewall - you have to ask your IT to</DIV>
<DIV>> > unlock this port.</DIV>
<DIV>> ></DIV>
<DIV>> ></DIV>
<DIV>> ></DIV>
<DIV>> > Ben</DIV>
<DIV>> ></DIV>
<DIV>> ></DIV>
<DIV>> > Add FUN to your email - CLICK HERE!</DIV>
<DIV>> > <<A href="http://www.incredimail.com/index.asp?id=54760">http://www.incredimail.com/index.asp?id=54760</A>></DIV>
<DIV>></DIV>
<DIV>> Ezequias,</DIV>
<DIV>></DIV>
<DIV>> 1. Reply to the list, please.</DIV>
<DIV>> 2. Don't top post, please.</DIV>
<DIV>> 3. Do not change the subject line, please.</DIV>
<DIV>></DIV>
<DIV>></DIV>
<DIV>></DIV>
<DIV>></DIV>
<DIV>> You need to have two accounts, one for the system, to start the</DIV>
<DIV>> postmaster and of course on as the database super user, which we are</DIV>
<DIV>> talking about.</DIV>
<DIV>></DIV>
<DIV>> Did you explicitely change the password for the database super user</DIV>
<DIV>> "postgres"?</DIV>
<DIV>></DIV>
<DIV>> Ben</DIV>
<DIV>></DIV>
<DIV>></DIV>
<DIV>> Add FUN to your email - CLICK HERE!</DIV>
<DIV>> <<A href="http://www.incredimail.com/index.asp?id=54760">http://www.incredimail.com/index.asp?id=54760</A>></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Ezequias,</DIV>
<DIV> </DIV>
<DIV>If you engage the help of a user list, then the conversation has to be</DIV>
<DIV>_over_ _the_ _list_, so that somebody else could take advantage of this</DIV>
<DIV>technical support. So please Ezequias, push the "Reply all" button and</DIV>
<DIV>post _all_ your answers to list.</DIV>
<DIV> </DIV>
<DIV>Second, you're adviced to continue any conversation at the _end_ of the</DIV>
<DIV>mail you are replying to, so that it is much easier for others to follow</DIV>
<DIV>the conversation.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Can you access postgres via "psql -Upostgres -ddbpostgis" if you are</DIV>
<DIV>logged in as root or some other user - _not_ postgres!? If not, the</DIV>
<DIV>pg_hba.conf you sent is likely not the one, your pgsql-Server is using.</DIV>
<DIV> </DIV>
<DIV>If you "psql" into your database, psql "takes" the credentials with</DIV>
<DIV>which you are logged into your linux shell. So, either you provide</DIV>
<DIV>-U<username> to psql or you type "su - postgres", then you don't need a</DIV>
<DIV>"-U".</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Ben</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> Ben,</DIV>
<DIV> </DIV>
<DIV>I never recieve any post about the way I send my messages (at begin or at end) but if you are not fine with it, I will send now at the End of the e-mail.</DIV>
<DIV> </DIV>
<DIV>I just can access postgresql via postgres user (linux user):</DIV>
<DIV> </DIV>
<DIV>[postgres@machine ~]$ psql -D /usr/local/pgsql/data</DIV>
<DIV> </DIV>
<DIV>The connection occours with no problem.</DIV>
<DIV> </DIV>
<DIV>Ezequias</DIV></TD></TR>
<TR>
<TD id=INCREDIFOOTER width="100%">
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD width="100%"></TD>
<TD id=INCREDISOUND vAlign=bottom align=middle></TD>
<TD id=INCREDIANIM vAlign=bottom align=middle></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><SPAN id=IncrediStamp><SPAN dir=ltr><A href="http://www.incredimail.com/index.asp?id=54760"><IMG alt="Add FUN to your email - CLICK HERE!" hspace=0 src="http://www2.incredimail.com/contents/stamps/imstp_emo_pt.gif" align=baseline border=0></A></SPAN></SPAN></BODY></HTML>