Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id DC4F06328E7
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  3 Dec 2009 15:39:05 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 10463-08 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  3 Dec 2009 19:38:58 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-bw0-f213.google.com (mail-bw0-f213.google.com
	[209.85.218.213])
	by mail.postgresql.org (Postfix) with ESMTP id 871DA632815
	for <pgsql-sql@postgresql.org>; Thu,  3 Dec 2009 15:38:57 -0400 (AST)
Received: by bwz5 with SMTP id 5so1406309bwz.3
	for <pgsql-sql@postgresql.org>; Thu, 03 Dec 2009 11:38:56 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=nzqoOogUInHZrh2umV31wvaHfR7lnCo+BrKFOvS5O78=;
	b=YaU76WOw4kgcV7DBxalVkmbIIQ/M72Y+K8sXt5hhGUc2TyGqfL0UqtqQ1njZPaKuW9
	W7GM+RUaqV75xNkcNv8bPlcVPDgz/Qr9khgGp66nHQpuvnS0DZHrZVaaAmTXER+pUGnI
	mNo1Mk6hkTv0sP5hyl9NNKoQS6YrnfyDy2R+M=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=sIAXybavkIeGVBxu6L3JovuF0fhUpKsAWhj3xhJqhid1V5A1jpfqLbjWyRBby88GpG
	GQwkncRwAM4kmVKoWkQY3ZO3nYLcWRfgFHDSDi+XYD5ggocT0vnEIyW5hFACgQs0CS1Y
	9fUgkYOdoad4P+HWuoi+NC1hrhiOPdO0kYCqU=
MIME-Version: 1.0
Received: by 10.204.152.4 with SMTP id e4mr2116560bkw.169.1259869135867; Thu,
	03 Dec 2009 11:38:55 -0800 (PST)
In-Reply-To: <b4399d110912031136x5d24c43aq4369a1c84d7dda0e@mail.gmail.com>
References: <4B17FDCE.6030200@fmed.uba.ar> <12517.1259868079@sss.pgh.pa.us>
	<b4399d110912031136x5d24c43aq4369a1c84d7dda0e@mail.gmail.com>
Date: Thu, 3 Dec 2009 22:38:55 +0300
Message-ID: <b4399d110912031138h5d2c840coef90239b87f93214@mail.gmail.com>
Subject: Re: create user xxx with md5 string?
From: Dmitriy Igrishin <dmitigr@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Gerardo Herzig <gherzig@fmed.uba.ar>,
	postgres list <pgsql-sql@postgresql.org>
Content-Type: multipart/alternative; boundary=0015175df0344e919e0479d82455
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5
	tests=BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200912/5
X-Sequence-Number: 33443

--0015175df0344e919e0479d82455
Content-Type: text/plain; charset=ISO-8859-1

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
>>
>
>

--0015175df0344e919e0479d82455
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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=3D"gmail_=
quote">2009/12/3 Dmitriy Igrishin <span dir=3D"ltr">&lt;<a href=3D"mailto:d=
mitigr@gmail.com">dmitigr@gmail.com</a>&gt;</span><br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;">Hello all.<div>Tom right. Encrypted MD5 pas=
swords computed as md5(password || test10). I checked.</div><div><br></div>
<div>Regards, Dmitriy Igrishin.=A0<br><br><div class=3D"gmail_quote">2009/1=
2/3 Tom Lane <span dir=3D"ltr">&lt;<a href=3D"mailto:tgl@sss.pgh.pa.us" tar=
get=3D"_blank">tgl@sss.pgh.pa.us</a>&gt;</span><div><div></div><div class=
=3D"h5"><br>

<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div>Gerardo Herzig &lt;<a href=3D"mailto:gh=
erzig@fmed.uba.ar" target=3D"_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. =A0I think it&#39;s &#39;md5&#39; || md5sum(password || username)=
<br>
but look at the code or docs.<br>
<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0regards, tom lane<br>
<div><div></div><div><br>
--<br>
Sent via pgsql-sql mailing list (<a href=3D"mailto:pgsql-sql@postgresql.org=
" target=3D"_blank">pgsql-sql@postgresql.org</a>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-sql" target=3D"_blank">=
http://www.postgresql.org/mailpref/pgsql-sql</a><br>
</div></div></blockquote></div></div></div><br></div>
</blockquote></div><br></div>

--0015175df0344e919e0479d82455--