> On Sat, 03 Aug 2002 10:50:07 -0700, Aditya <aditya=CsvYf0RXmS4@public.gmane.org> said:
> On a Solaris8 machine, with pgjdbc2.jar (downloaded yesterday from
> jdbc.postgresql.org) I can get a simple test program to work fine
> with a 1.2.2 JDK:
> however, running the exact same program with 1.4.1-beta:
> produces the following error (I'm using md5 passwords on the
> postgresql server):
>
> Could not connect to db:Something unusual has occured to cause the
> driver to fail. Please report this exception: Exception:
> java.sql.SQLException: FATAL 1: Password authentication failed for
> user "jndi"
I changed the authentication type from md5 to trust in pg_hba.conf for
that host, ie. was:
host all 192.168.1.0 255.255.255.0 md5
and I prepended:
host all 192.168.1.60 255.255.255.255 trust
and it now works fine under 1.4.1-beta. So it looks like md5 auth
isn't working for some reason...I've tried specifying digest=MD5 in
the database URL like:
jdbc:postgresql://192.168.1.103:5433/mydb?digest=MD5
to no avail. And adding user=foo;password=bar to the url in addition
to specifying username and password as part of getConnection didn't
work either...
db = DriverManager.getConnection(url, username, password);
Thanks,
Adi
