pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bill Chandler <billybobc1210@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Missing or errooneous pg_hba.conf file
Date: Wed, 19 May 2004 13:28:34 -0700 (PDT)
Message-ID: <20040519202834.15105.qmail@web12903.mail.yahoo.com> (raw)

Hello,

Running 7.4.2 on Solaris 8 (binaries were built on
a different Solaris 8 box).

I keep getting the following message when trying to
connect to server:

FATAL: missing or erroneous pg_hba.conf file
HINT: see server log for details.

Server log contains message:

LOG: invalid entry in pg_hba.conf file at line 60,
token "255.255.255.255"

The only change I've made was to postgresql.conf to 
change "tcpip_socket = true".  I have not modified
pg_hba.conf at all.  Line 60 is the default 'host'
entry for 127.0.0.1.  The token in question is the
IP-MASK field.

I have found that if I change this value to anything 
other than "255.255.255.255" (e.g. "255.255.255.254") 
the message goes away.

I get the same message if I add other lines with 
IP-MASK=255.255.255.255 to the pg_hba.conf file.
It just doesn't seem to like '255.255.255.255' for
some reason.

I get the error using both the 'psql -h ...' command
and trying to connect via JDBC.  

Incidentally, I saw the same problem running in 7.4.1.
I ended up just commenting out line 60 to get around
it.  But now I need IP-MASK=255.255.255.255 so I 
need to get it resolved.  Interestingly the same 7.4.1
binary running on a different machine did not exhibit
the problem.  Could it be a Solaris patch level 
thing?

thanks in advance,

Bill
billybobc1210@yahoo.com


	
		
__________________________________
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/



view thread (6+ messages)  latest in thread

Message-ID: <20040519202834.15105.qmail@web12903.mail.yahoo.com>
Permalink:  ../20040519202834.15105.qmail@web12903.mail.yahoo.com/
Also on:    postgresql.org/message-id/20040519202834.15105.qmail@web12903.mail.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: billybobc1210@yahoo.com
  Subject: Re: Missing or errooneous pg_hba.conf file
  In-Reply-To: <20040519202834.15105.qmail@web12903.mail.yahoo.com>
  References: <20040519202834.15105.qmail@web12903.mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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