| From: | owenn panng <trilogy(at)gmail(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | converting to MD5 |
| Date: | 2004-10-19 18:00:54 |
| Message-ID: | c1158fd10410191100261728eb@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Hi there, I was wondering what is needed to done on both the postgres
& client side to connect via MD5. Right now, we are connecting fine
by just specifying password in pg_hba.conf:
host database user xxx.xxx.xxx.xxx xxx.xxx.xxx.xxx password
But I would like to change this to use:
host database user xxx.xxx.xxx.xxx xxx.xxx.xxx.xxx md5
I have the user stored in pg_shadow (note: the passwd listed is not
the real one):
usename | usesysid | usecreatedb | usesuper | usecatupd |
passwd | valuntil | useconfig
user | 100 | t | f | f |
md59033f409a99f207fa816b990467a9999 | |
On the client side, we are using pg74.215.jdbc2.jar with code based on
the example given on
http://jdbc.postgresql.org/documentation/pgjdbc.html
String url = "jdbc:postgresql://" + host + "/" + database;
try {
Class.forName("org.postgresql.Driver");
con =
DriverManager.getConnection(url, userID, password);
}
I can generate the same password that matches the one stored in
pg_shadow. So how do I specify that the password I am sending is in
MD5? Any help would be appreciated.
Thanks, O.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2004-10-19 18:10:06 | Re: converting to MD5 |
| Previous Message | Kris Jurka | 2004-10-19 17:02:38 | Re: Encoding porblem in JDBC |