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
