RE: PostgreSQL JDBC error: Missing or erroneous pg_h ba.conf file

> -----Original Message-----
> From:    Peter Mount [SMTP:peter@retep.org.uk]
> Sent:    Monday, 05 June, 2000 11:47
> To:    Ira Waxberg
> Cc:    pgsql-interfaces@postgresql.org
> Subject:    Re: [INTERFACES] PostgreSQL JDBC error: Missing or erroneous
> pg_hba.conf file
> 
> 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.[Sondaar, Roelof]  If you can connect from your client (=
203.216.99.58 ?) and you use the same url in the program running on the
server it could also mean that have to add the IP-address of your server to
this file.Which it would like something like this:host    all    127.0.0.1    255.255.255.255 trusthost    all
client-ipaddress255.255.255.255
 
trusthost    all    server-ipaddress    255.255.255.255    trust
Roelof


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