Thread: JDBC access with md5 password
Can anyone help me on how to connect to the database via JDBC if I'm using md5 passwords? Do I need to create the MD5 hash and send that as the password, or is there something I do with the driver before hand? -- Timothy A. DeWees 330/493-9700 http://www.hcd.net Himebaugh Consulting, Inc.
On Fri, 24 Jan 2003, Timothy A. DeWees wrote: > Can anyone help me on how to connect to the database via JDBC if I'm using > md5 passwords? Do I need to create the MD5 hash and send that as the > password, or is there something I do with the driver before hand? Yeah, there's something you need to do with the driver. Upgrade it to the one from 7.3. :-) Then just send your usual password. (The 7.2 JDBC drivers had a bug that, depending on localization settings, could mess up the MD5 hashing.) cjs -- Curt Sampson <cjs@cynic.net> +81 90 7737 2974 http://www.netbsd.org Don't you know, in this new Dark Age, we're all light. --XTC
Thanks for the reply. I am using the driver that came with 7.3.1. I did a --with-java and am using the postgresql.jar file that got built. The driver was build with JDK 1.4.1 if that makes a difference. -- Timothy A. DeWees 330/493-9700 http://www.hcd.net Himebaugh Consulting, Inc. -----Original Message----- From: Curt Sampson [mailto:cjs@cynic.net] Sent: Wednesday, January 29, 2003 1:44 AM To: Timothy A. DeWees Cc: pgsql-jdbc@postgresql.org Subject: Re: [JDBC] JDBC access with md5 password On Fri, 24 Jan 2003, Timothy A. DeWees wrote: > Can anyone help me on how to connect to the database via JDBC if I'm using > md5 passwords? Do I need to create the MD5 hash and send that as the > password, or is there something I do with the driver before hand? Yeah, there's something you need to do with the driver. Upgrade it to the one from 7.3. :-) Then just send your usual password. (The 7.2 JDBC drivers had a bug that, depending on localization settings, could mess up the MD5 hashing.) cjs -- Curt Sampson <cjs@cynic.net> +81 90 7737 2974 http://www.netbsd.org Don't you know, in this new Dark Age, we're all light. --XTC
Timothy, I can't reproduce. This works fine for me with both the 7.3 and development versions of the driver. What is the exact error message you are getting? thanks, --Barry Timothy A. DeWees wrote: > Thanks for the reply. I am using the driver that came with 7.3.1. I did > a --with-java and am using the postgresql.jar file that got built. > > The driver was build with JDK 1.4.1 if that makes a difference. > > -- > Timothy A. DeWees > 330/493-9700 > http://www.hcd.net > Himebaugh Consulting, Inc. > > > -----Original Message----- > From: Curt Sampson [mailto:cjs@cynic.net] > Sent: Wednesday, January 29, 2003 1:44 AM > To: Timothy A. DeWees > Cc: pgsql-jdbc@postgresql.org > Subject: Re: [JDBC] JDBC access with md5 password > > > On Fri, 24 Jan 2003, Timothy A. DeWees wrote: > > >>Can anyone help me on how to connect to the database via JDBC if I'm using >>md5 passwords? Do I need to create the MD5 hash and send that as the >>password, or is there something I do with the driver before hand? > > > Yeah, there's something you need to do with the driver. Upgrade it to > the one from 7.3. :-) Then just send your usual password. > > (The 7.2 JDBC drivers had a bug that, depending on localization settings, > could mess up the MD5 hashing.) > > cjs > -- > Curt Sampson <cjs@cynic.net> +81 90 7737 2974 http://www.netbsd.org > Don't you know, in this new Dark Age, we're all light. --XTC > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >