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 majordomo@postgresql.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly