> Michael E Mercer <mmercer@lboard.com> wrote in message
news:<3C960A14.B45611B@lboard.com>...
> > Hello,
> >
> > I have a java program running as root and tries to connect to database
> > as user
> > 'A' with password 'A'.
> >
> > The pg_hba.conf is set to allow users to connect from any host with md5
> > authentication.
> >
> > The java program uses the same method to connect to the database,
> > however
> > sometimes authentication
> > succeeds and sometimes it fails. The user and password are hard coded,
> > so there
> > is no probable error there.
> >
I have the very same problem here - Postgres 7.2 on RH 7.2, JDBC driver is
[PostgreSQL 7.2b5 JDBC2] from the official site
getConnection seems to fail when called after some period of inactivity, but
if a subsequent attempt is made then it is successful
a sample code would look like:
Connection conn =
DriverManager.getConnection("jdbc:postgresql://192.168.128.208:5432/gate09?u
ser=gateadmin&password=gate");
the pg_hba.conf contains:
=============
host all 192.168.128.42 255.255.255.255 md5
host all 212.50.14.155 255.255.255.255 md5
=============
...where the above are the two IPs of my machine (the JDBC client)
the log file contains:
==========
FATAL 1: Password authentication failed for user "gateadmin"
DEBUG: pq_recvbuf: recv() failed: Connection reset by peer
==========
any hints?
thanx,
Marin
----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "