pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL JDBC error: Missing or erroneous pg_hba.conf file
4+ messages / 4 participants
[nested] [flat]
* PostgreSQL JDBC error: Missing or erroneous pg_hba.conf file
@ 2000-05-31 05:13 Ira Waxberg <i-waxberg@exodus.co.jp>
0 siblings, 2 replies; 4+ messages in thread
From: Ira Waxberg @ 2000-05-31 05:13 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: Waxberg, Ira <i-waxberg@exodus.co.jp>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL JDBC error: Missing or erroneous pg_hba.conf file
@ 2000-06-02 10:27 Patrick Welche <prlw1@newn.cam.ac.uk>
parent: Ira Waxberg <i-waxberg@exodus.co.jp>
1 sibling, 0 replies; 4+ messages in thread
From: Patrick Welche @ 2000-06-02 10:27 UTC (permalink / raw)
To: Ira Waxberg <i-waxberg@exodus.co.jp>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL JDBC error: Missing or erroneous pg_hba.conf file
@ 2000-06-05 09:47 Peter Mount <peter@retep.org.uk>
parent: Ira Waxberg <i-waxberg@exodus.co.jp>
1 sibling, 0 replies; 4+ messages in thread
From: Peter Mount @ 2000-06-05 09:47 UTC (permalink / raw)
To: Ira Waxberg <i-waxberg@exodus.co.jp>; +Cc: pgsql-interfaces
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/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: PostgreSQL JDBC error: Missing or erroneous pg_h ba.conf file
@ 2000-06-05 11:45 Sondaar, Roelof <roelof.sondaar@scania.com>
0 siblings, 0 replies; 4+ messages in thread
From: Sondaar, Roelof @ 2000-06-05 11:45 UTC (permalink / raw)
To: Ira Waxberg <i-waxberg@exodus.co.jp>; +Cc: pgsql-interfaces
> -----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 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@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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2000-06-05 11:45 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-31 05:13 PostgreSQL JDBC error: Missing or erroneous pg_hba.conf file Ira Waxberg <i-waxberg@exodus.co.jp>
2000-06-02 10:27 ` Patrick Welche <prlw1@newn.cam.ac.uk>
2000-06-05 09:47 ` Peter Mount <peter@retep.org.uk>
2000-06-05 11:45 RE: PostgreSQL JDBC error: Missing or erroneous pg_h ba.conf file Sondaar, Roelof <roelof.sondaar@scania.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox