Re: Question on MD5 authentication

Wei Weng <wweng@kencast.com> writes:
> (As you can see, all 3 strings are different)
> Why the difference?  Is there something missing ??

Well, the password is actually supposed to be 'md5'||md5(passwd||user),
thus:

regression=# select md5('test_passwd' || 'test_user');
               md5
----------------------------------
 c573460a3b356e4610bfae406e1d8a9f
(1 row)

So either you are mistyping the password at the client end, or there's
something broken about the client-side code.

            regards, tom lane