Thread: PostgreSQL JDBC error: Missing or erroneous pg_hba.conf file
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
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
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