pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMissing or erroneus pg_hba.conf file
3+ messages / 3 participants
[nested] [flat]
* Missing or erroneus pg_hba.conf file
@ 2004-06-16 16:41 Sandro Ribeiro - Claro RS - <Sandro.Ribeiro@claro.com.br>
2004-06-20 12:04 ` Re: Missing or erroneus pg_hba.conf file Jim Seymour <jseymour@linxnet.com>
2004-06-20 13:04 ` Re: Missing or erroneus pg_hba.conf file Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 3+ messages in thread
From: Sandro Ribeiro - Claro RS - @ 2004-06-16 16:41 UTC (permalink / raw)
To: pgsql-admin
Hello!
My server is working with pgsql 7.4.2 and Unix Solaris 8. Well, when a try a
connection from my PC to the server, using pgAdminIII, I get the message
above. This is my pg_hba.conf file:
local all all trust
# IPv4-style local connections:
host all all 127.0.0.1 255.255.255.255 trust
host all all 172.17.0.0 255.255.0.0 trust
My PC IP address is something like 172.17.9.9 and local connections ("psql
template1") are working fine. But if I comment the line below I can connect
using pgAIII and locally too. After change pg_hba.conf I've used "pg_ctl
reload".
#host all all 127.0.0.1 255.255.255.255 trust
My major problem is that in this last situation (with the line above
commented) I can't use the pg73jdbc3.jar driver to connect to database
(locally). The message is "no pg_hba.conf entry for host "127.0.0.1", user
"postgres", database "ppcdr_db", SSL off". If I remove the comment, the
"Missing or erroneus pg_hba.conf file" returns.
Can you help me?
Thank you!
SANDRO
--------------------------------------------------------------------------------------------------
O conteúdo desta mensagem é de uso restrito e confidencial, sendo o seu sigilo protegido por lei.
Estas informações não podem ser divulgadas sem prévia autorização escrita. Se você não é o
destinatário desta mensagem, ou o responsável pela sua entrega, apague-a imediatamente e avise
ao remetente, respondendo a esta mensagem. Alertamos que esta mensagem transitou por rede pública
de comunicação,estando, portanto, sujeita aos riscos inerentes a essa forma de comunicação.
A CLARO não se responsabiliza por conclusões, opiniões, ou outras informações
nesta mensagem que não se relacionem com sua linha de negócios.
--------------------------------------------------------------------------------------------------
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Missing or erroneus pg_hba.conf file
2004-06-16 16:41 Missing or erroneus pg_hba.conf file Sandro Ribeiro - Claro RS - <Sandro.Ribeiro@claro.com.br>
@ 2004-06-20 12:04 ` Jim Seymour <jseymour@linxnet.com>
1 sibling, 0 replies; 3+ messages in thread
From: jseymour@linxnet.com @ 2004-06-20 12:04 UTC (permalink / raw)
To: pgsql-admin
Sandro Ribeiro - Claro RS - <Sandro.Ribeiro@claro.com.br> wrote:
>
>
> Hello!
>
> My server is working with pgsql 7.4.2 and Unix Solaris 8. Well, when a try a
> connection from my PC to the server, using pgAdminIII, I get the message
> above. This is my pg_hba.conf file:
>
> local all all trust
> # IPv4-style local connections:
> host all all 127.0.0.1 255.255.255.255 trust
> host all all 172.17.0.0 255.255.0.0 trust
[snip]
There is an issue, as yet not understood (last I knew), with some
versions of (?) Solaris and IP-address-with-netmask configuration
entries in pg_hba.conf. Try changing your two "host" lines to:
# IPv4-style local connections:
host all all 127.0.0.1/32 trust
host all all 172.17.0.0/16 trust
and see if that doesn't resolve your problem.
Jim
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Missing or erroneus pg_hba.conf file
2004-06-16 16:41 Missing or erroneus pg_hba.conf file Sandro Ribeiro - Claro RS - <Sandro.Ribeiro@claro.com.br>
@ 2004-06-20 13:04 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2004-06-20 13:04 UTC (permalink / raw)
To: Sandro Ribeiro - Claro RS - <Sandro.Ribeiro@claro.com.br>; +Cc: pgsql-admin
Sandro Ribeiro - Claro RS - <Sandro.Ribeiro@claro.com.br> writes:
> My server is working with pgsql 7.4.2 and Unix Solaris 8.
> [ this pg_hba.conf line doesn't work: ]
> host all all 127.0.0.1 255.255.255.255 trust
We've seen some reports suggesting that Solaris has a problem with the
all-ones netmask. You could probably get it to work either by
loosening the netmask a little:
host all all 127.0.0.1 255.255.255.0 trust
or by using CIDR style:
host all all 127.0.0.1/32 trust
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-06-20 13:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-16 16:41 Missing or erroneus pg_hba.conf file Sandro Ribeiro - Claro RS - <Sandro.Ribeiro@claro.com.br>
2004-06-20 12:04 ` Jim Seymour <jseymour@linxnet.com>
2004-06-20 13:04 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox