Tom Lane wrote:
> Gerardo Herzig writes:
>> Hi all. Im triyng, with no success, to create a user, and set the
>> password with a md5 string.
>
> The correct method for computing the md5'd password includes the
> username. I think it's 'md5' || md5sum(password || username)
> but look at the code
Sorry for my prev post. I mean md5(password || username).
'test10' is a username on which i checked. :) Sorry!
2009/12/3 Dmitriy Igrishin
> Hello all.
> Tom right. Encrypted MD5 passwords computed as md5(password || test10). I
> checked.
>
> Regards, Dmitriy Igrishin.
>
> 2009/12/3 Tom Lane
>
>
Hello all.
Tom right. Encrypted MD5 passwords computed as md5(password || test10). I
checked.
Regards, Dmitriy Igrishin.
2009/12/3 Tom Lane
> Gerardo Herzig writes:
> > Hi all. Im triyng, with no success, to create a user, and set the
> > password with a md5 string.
>
> The correct method for
Gerardo Herzig writes:
> Hi all. Im triyng, with no success, to create a user, and set the
> password with a md5 string.
The correct method for computing the md5'd password includes the
username. I think it's 'md5' || md5sum(password || username)
but look at the code or docs.
Hi all. Im triyng, with no success, to create a user, and set the
password with a md5 string.
I did this:
comechingon:~ # echo -n 123 | md5sum
202cb962ac59075b964b07152d234b70 -
Ok, so then
test=# CREATE USER foobar ENCRYPTED PASSWORD
'md5202cb962ac59075b964b07152d234b70'; --I have to add 'md5
