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

> -----Original Message-----
> From: Peter Mount [SMTP:peter(at)retep(dot)org(dot)uk]
> Sent: Monday, 05 June, 2000 11:47
> To: Ira Waxberg
> Cc: pgsql-interfaces(at)postgresql(dot)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 trust
host all client-ipaddress 255.255.255.255
trust
host all server-ipaddress 255.255.255.255 trust

Roelof

> Peter
>
> --
> Peter T Mount peter(at)retep(dot)org(dot)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