[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] create user xxx with md5 string?
From:       Dmitriy Igrishin <dmitigr () gmail ! com>
Date:       2009-12-03 19:38:55
Message-ID: b4399d110912031138h5d2c840coef90239b87f93214 () mail ! gmail ! com
[Download RAW message or body]

Sorry for my prev post. I mean md5(password || username).
'test10' is a username on which i checked. :) Sorry!

2009/12/3 Dmitriy Igrishin <dmitigr@gmail.com>

> Hello all.
> Tom right. Encrypted MD5 passwords computed as md5(password || test10). I
> checked.
>
> Regards, Dmitriy Igrishin.
>
> 2009/12/3 Tom Lane <tgl@sss.pgh.pa.us>
>
> Gerardo Herzig <gherzig@fmed.uba.ar> 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.
>>
>>                        regards, tom lane
>>
>> --
>> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-sql
>>
>
>

[Attachment #3 (text/html)]

Sorry for my prev post. I mean md5(password || username).<div>&#39;test10&#39; is a \
username on which i checked. :) Sorry!<br><br><div class="gmail_quote">2009/12/3 \
Dmitriy Igrishin <span dir="ltr">&lt;<a \
href="mailto:dmitigr@gmail.com">dmitigr@gmail.com</a>&gt;</span><br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex;">Hello all.<div>Tom right. Encrypted MD5 passwords computed \
as md5(password || test10). I checked.</div><div><br></div> <div>Regards, Dmitriy \
Igrishin. <br><br><div class="gmail_quote">2009/12/3 Tom Lane <span dir="ltr">&lt;<a \
href="mailto:tgl@sss.pgh.pa.us" \
target="_blank">tgl@sss.pgh.pa.us</a>&gt;</span><div><div></div><div class="h5"><br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div>Gerardo Herzig &lt;<a href="mailto:gherzig@fmed.uba.ar" \
target="_blank">gherzig@fmed.uba.ar</a>&gt; writes:<br> &gt; Hi all. Im triyng, with \
no success, to create a user, and set the<br> &gt; password with a md5 string.<br>
<br>
</div>The correct method for computing the md5&#39;d password includes the<br>
username.  I think it&#39;s &#39;md5&#39; || md5sum(password || username)<br>
but look at the code or docs.<br>
<br>
                        regards, tom lane<br>
<div><div></div><div><br>
--<br>
Sent via pgsql-sql mailing list (<a href="mailto:pgsql-sql@postgresql.org" \
target="_blank">pgsql-sql@postgresql.org</a>)<br> To make changes to your \
subscription:<br> <a href="http://www.postgresql.org/mailpref/pgsql-sql" \
target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br> \
</div></div></blockquote></div></div></div><br></div> </blockquote></div><br></div>



[prev in list] [next in list] [prev in thread] [next in thread]