Thread: PostgreSQL JDBC error: Missing or erroneous pg_hba.conf file

PostgreSQL JDBC error: Missing or erroneous pg_hba.conf file

From
"Ira Waxberg"
Date:
I get this error only when coming in from the local host! Remote clients,
oddly enough, don't have this problem.

Something unusual has occured to cause the driver to fail. Please report
this exception: java.sql.SQLException: Missing or erroneous pg_hba.conf
file, see postmaster log for details       at postgresql.Driver.connect(Driver.java:125)       at
java.sql.DriverManager.getConnection(DriverManager.java:453)      at
java.sql.DriverManager.getConnection(DriverManager.java:133)      at
com.exodus.change.util.DBTest.<init>(DBTest.java:28)      at com.exodus.change.util.DBTest.main(DBTest.java:44)
 

The pg_hba.conf file:

host         all         127.0.0.1     255.255.255.255   trust
host         all         203.216.99.58 255.255.255.255   trust
host         all         203.216.99.58                   trust
host         all         203.216.0.0   255.255.255.0     trust

Any ideas?

Ira Waxberg
Developer
Exodus Communications, K.K.
Imperial Nishi-Shinjuku Building
5-3-2 Nishi-Shinjuku, Shinjuku-ku
Tokyo 160-0023
03-5334-1433
03-5334-1771 (fax)
i-waxberg@exodus.co.jp
http://www.exodus.co.jp




Re: PostgreSQL JDBC error: Missing or erroneous pg_hba.conf file

From
Patrick Welche
Date:
On Wed, May 31, 2000 at 02:13:59PM +0900, Ira Waxberg wrote:
> I get this error only when coming in from the local host! Remote clients,
> oddly enough, don't have this problem.
> 
> Something unusual has occured to cause the driver to fail. Please report
> this exception: java.sql.SQLException: Missing or erroneous pg_hba.conf
...
> The pg_hba.conf file:
> 
> host         all         127.0.0.1     255.255.255.255   trust
> host         all         203.216.99.58 255.255.255.255   trust
> host         all         203.216.99.58                   trust
> host         all         203.216.0.0   255.255.255.0     trust
> 
> Any ideas?

Remove 3rd line? (Needs netmask?)

Cheers,

Patrick


Re: PostgreSQL JDBC error: Missing or erroneous pg_hba.conf file

From
Peter Mount
Date:
On Wed, 31 May 2000, Ira Waxberg wrote:

> I get this error only when coming in from the local host! Remote clients,
> oddly enough, don't have this problem.
> 
> Something unusual has occured to cause the driver to fail. Please report
> this exception: java.sql.SQLException: Missing or erroneous pg_hba.conf
> file, see postmaster log for details

This is being sent to the backend as it's seeing a corrupt pg_hba.conf
file.

This file could also be missing but as you include it next, it's not that.

> The pg_hba.conf file:
> 
> host         all         127.0.0.1     255.255.255.255   trust
> host         all         203.216.99.58 255.255.255.255   trust
> host         all         203.216.99.58                   trust

This line is corrupt as it's missing the subnet mask. delete it, as it's a
duplicate of the preciding line.

Peter

--      Peter T Mount peter@retep.org.uk     Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgresJava PDF Generator: http://www.retep.org.uk/pdf