Can you tell postgres *NOT* to use a salt when calculating the MD5 digest? I found that it prepends the username to the password before making the calculation.
-- Robert Abernethy IV Dynamic Edge, Inc. 734.975.0460 > Perl also came up with the same digest as Java. > > -- > Robert Abernethy IV > Dynamic Edge, Inc. > 734.975.0460 > > > How does postgres calculate the MD5 version of a password to store > > in the database during user creation? I am trying to set up a > > postgres JDBCRealm to work with Tomcat. The problem is that the > > resulting digest from Java is different then the digest stored in > > the database for the same word. > > > > clear-text: tomcat > > java: 1b359d8753858b55befa0441067aaed3 > > postgres: md5efcc1c51a80be13b59cdb96d758a0184 > > > > -- > > Robert Abernethy IV > > Dynamic Edge, Inc. > > 734.975.0460 > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
