Date: Fri, 13 Mar 1998 15:04:32 -0800 (PST)
From: "Stephan B. Doliov" <doliov@statsol.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: [QUESTIONS] postgresql-6.3 and jdbc - grief
In-Reply-To: <Pine.LNX.3.95.980313200053.10979A-100000@maidast>
Message-ID: <Pine.GSO.3.96.980313145456.18448A-100000@shell>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Pter Mount wrote:
> On Fri, 13 Mar 1998, Stephan B. Doliov wrote:
> > I know i must be doing something inanely stupid but the jdbc driver that
> > 
> > in pg_hba.conf i have
> > local      all  password password
> > host       all  198.11.51.133 255.255.255.224   password password
> This is your problem, the IP address & mask don't match (for postgresql's
> purposes).
> If you are trying to say: only 198.11.51.133 is to have access, then it
> should read:
> host       all  198.11.51.133 255.255.255.255   password password
> but, if you are saying that the network that 198.11.51.133 resides is to
> have access, and 255.255.255.224 is the netmask, then this should read:

thanks for clarifying my consfusion regarding netmasks (i just did an
ifconfig -a on my le0 (ethernet) interface and saw the netmask ws
ffffffe0) and so thought that is what i should put in the pg_hba.conf
file.

however - the mystery i still have not yet been able to solve is why do i
have to speccify the host in the url in order to get the jdbc driver to
work.
jdbc:postgresql:funnystuff fails
jdbc:postgresql://198.11.51.133/funnystuff works.

pg_hba.conf reads:
local   all    password      password
host    all    198.11.51.133 255.255.255.225   password   password

is it because poastmaster is running with the -i option?  if i let the
pg_hba.conf file for local read
local   all   trust
i don't need to specify the hostname in the url.

by and large, i can live with this no problem, it's just that my curiosity
has been greatly aroused by the observed behavior.

cheers,
steve