pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [QUESTION] JDBC and pg_hba on 6.2
3+ messages / 3 participants
[nested] [flat]
* Re: [QUESTION] JDBC and pg_hba on 6.2
@ 1998-03-10 00:44 The Hermit Hacker <scrappy@hub.org>
1998-03-10 20:13 ` Re: [INTERFACES] Re: [QUESTION] JDBC and pg_hba on 6.2 Peter T Mount <pgint@maidast.demon.co.uk>
0 siblings, 1 reply; 3+ messages in thread
From: The Hermit Hacker @ 1998-03-10 00:44 UTC (permalink / raw)
To: Bryan Basham <basham@bhi.com>; +Cc: pgsql-interfaces
Forwarded to pgsql-interfaces@postgresql.org
On Mon, 9 Mar 1998, Bryan Basham wrote:
> Hello,
>
> I have been using PostgreSQL 6.2 and JDBC for a few months now, but
> only accessing the DB from my local host. I am now attempting to
> connect to my DB server host remotely (the remote server is gru.org
> and my local host is bela.basham.bhi.com).
>
> I tried the JDBC_Test program, but it fails:
>
> > java JDBC_Test jdbc:postgresql://gru.org:5432/gru
> Connecting to Database URL = jdbc:postgresql://gru.org:5432/gru
> Exception: java.sql.SQLException: Failed to authenticate client as Postgres
> user 'basham' using the default authentication type: be_recvauth: host-based authentication failed
>
> I have the following entry in the servers pg_hba.conf file:
>
> # All any connection from Bela.Basham.BHI.COM
> host all 10.237.124.1 255.255.255.255 trust
>
> I restarted the postmaster after changing the pg_hba.conf file
> and it still fails (message above). Any ideas?
>
> Thanks,
> Bryan Basham
>
Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Re: [QUESTION] JDBC and pg_hba on 6.2
1998-03-10 00:44 Re: [QUESTION] JDBC and pg_hba on 6.2 The Hermit Hacker <scrappy@hub.org>
@ 1998-03-10 20:13 ` Peter T Mount <pgint@maidast.demon.co.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Peter T Mount @ 1998-03-10 20:13 UTC (permalink / raw)
To: Bryan Basham <basham@bhi.com>; +Cc: pgsql-interfaces
On Mon, 9 Mar 1998, The Hermit Hacker wrote:
> Forwarded to pgsql-interfaces@postgresql.org
[ thanks marc - I keep forgetting to do this ;-) ]
> On Mon, 9 Mar 1998, Bryan Basham wrote:
>
> > Hello,
> >
> > I have been using PostgreSQL 6.2 and JDBC for a few months now, but
> > only accessing the DB from my local host. I am now attempting to
> > connect to my DB server host remotely (the remote server is gru.org
> > and my local host is bela.basham.bhi.com).
> >
> > I tried the JDBC_Test program, but it fails:
> >
> > > java JDBC_Test jdbc:postgresql://gru.org:5432/gru
> > Connecting to Database URL = jdbc:postgresql://gru.org:5432/gru
> > Exception: java.sql.SQLException: Failed to authenticate client as Postgres
> > user 'basham' using the default authentication type: be_recvauth: host-based authentication failed
> >
> > I have the following entry in the servers pg_hba.conf file:
> >
> > # All any connection from Bela.Basham.BHI.COM
> > host all 10.237.124..1 255.255.255.255 trust
This looks ok, and I can't remember 6.2 giving any problems of this kind
before.
Does gru.org or bela have multiple ip addresses? What platform is the
gru.org running on?
> > I restarted the postmaster after changing the pg_hba.conf file
> > and it still fails (message above). Any ideas?
--
Peter T Mount petermount@earthling.net or pmount@maidast.demon.co.uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk
^ permalink raw reply [nested|flat] 3+ messages in thread
* FWD: [QUESTION] JDBC and pg_hba on 6.2
@ 1998-03-10 16:55 Bryan Basham <basham@bhi.com>
0 siblings, 0 replies; 3+ messages in thread
From: Bryan Basham @ 1998-03-10 16:55 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: basham@bhi.com
Hello PG interface gurus,
Sorry for the redundant message... Scrappy forwarded this to your list
but I am not active on this list. Could you please CC me (basham@bhi.com)
with answers.
-Bryan Basham
On Mon, 9 Mar 1998, Bryan Basham wrote:
> Hello,
>
> I have been using PostgreSQL 6.2 and JDBC for a few months now, but
> only accessing the DB from my local host. I am now attempting to
> connect to my DB server host remotely (the remote server is gru.org
> and my local host is bela.basham.bhi.com).
>
> I tried the JDBC_Test program, but it fails:
>
> > java JDBC_Test jdbc:postgresql://gru.org:5432/gru
> Connecting to Database URL = jdbc:postgresql://gru.org:5432/gru
> Exception: java.sql.SQLException: Failed to authenticate client as Postgres
> user 'basham' using the default authentication type: be_recvauth: host-based authentication failed
>
> I have the following entry in the servers pg_hba.conf file:
>
> # All any connection from Bela.Basham.BHI.COM
> host all 10.237.124.1 255.255.255.255 trust
>
> I restarted the postmaster after changing the pg_hba.conf file
> and it still fails (message above). Any ideas?
>
> Thanks,
> Bryan Basham
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1998-03-10 20:13 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-03-10 00:44 Re: [QUESTION] JDBC and pg_hba on 6.2 The Hermit Hacker <scrappy@hub.org>
1998-03-10 20:13 ` Peter T Mount <pgint@maidast.demon.co.uk>
1998-03-10 16:55 FWD: [QUESTION] JDBC and pg_hba on 6.2 Bryan Basham <basham@bhi.com>
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