Re: Question on MD5 authentication - Mailing list pgsql-general

From Tom Lane
Subject Re: Question on MD5 authentication
Date
Msg-id 19602.1160687862@sss.pgh.pa.us
Whole thread Raw
In response to Re: Question on MD5 authentication  (Wei Weng <wweng@kencast.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Tomi NA"
Date:
Subject: Re: UTF-8
Next
From: Oisin Glynn
Date:
Subject: Re: Windows install problem