Skip site navigation (1) Skip section navigation (2)

Re: No pg_hba.conf entry

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: George Koras <gkoras(at)cres(dot)gr>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: No pg_hba.conf entry
Date: 2001-02-22 08:51:18
Message-ID: 982831878.3a94d30648862@webmail.retep.org.uk (view raw or flat)
Thread:
Lists: pgsql-jdbc
Quoting George Koras <gkoras(at)cres(dot)gr>:

> Hello,
> 
> When I try to connect via JDBC to PostgreSQL I get the following error
> message:
> 
> Error -- Something unusual has occured to cause the driver to fail.
> Please report this exception:
> java.sql.SQLException: No pg_hba.conf entry for host 143.233.73.254,
> user aaa, database bbb
> 
> However, the only lines in pg_hba.conf that are not commented out are:
> 
> local        all                                         trust
> host         all         127.0.0.1     255.255.255.255   trust
> host         all         143.233.73.0  255.255.255.0     trust

Hmmm, that should work...

> 
> Isn't this strange? I tried this with both jdbc6.5-1.2.jar and
> jdbc7_0-1_2.jar from 143.233.73.254 which runs Linux and from my WinNT
> 4.0 (sp6) machine and for different databases.
> 
> I use PostgreSQL 6.5.2 and before you ask, yes postmaster runs with the
> -i option set.

If you missed -i out you would have got "Connection Refused" not this 
Exception. The postmaster is listening, but is refusing the connection for some 
reason.

Can you use psql or another interface from 143.233.73.254?

Peter

-- 
Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

In response to

pgsql-jdbc by date

Next:From: George KorasDate: 2001-02-22 10:12:56
Subject: Re: No pg_hba.conf entry
Previous:From: Shankar GowdaDate: 2001-02-22 06:49:52
Subject: unable to find postgresql.jar

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group