From: Stephan B. Doliov <doliov@statsol.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: [QUESTIONS] postgresql-6.3 and jdbc - grief
Date: Fri, 13 Mar 1998 15:04:32 -0800 (PST)
Message-ID: <Pine.GSO.3.96.980313145456.18448A-100000@shell> (raw)
In-Reply-To: <Pine.LNX.3.95.980313200053.10979A-100000@maidast>
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
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: doliov@statsol.com
Subject: Re: [QUESTIONS] postgresql-6.3 and jdbc - grief
In-Reply-To: <Pine.GSO.3.96.980313145456.18448A-100000@shell>
* 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