Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 63712633267
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  3 Dec 2009 15:37:11 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 78467-08 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  3 Dec 2009 19:36:57 +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 27C186328E7
	for <pgsql-sql@postgresql.org>; Thu,  3 Dec 2009 15:36:59 -0400 (AST)
Received: by bwz5 with SMTP id 5so1404868bwz.3
	for <pgsql-sql@postgresql.org>; Thu, 03 Dec 2009 11:36:58 -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=XxPMp7bB9TMCexQGQ6/1B2YDaRy1aUQ5FSPWqvxto3A=;
	b=RkCgwdL0kSTsLYZgWFlAZnyO26gyuINWGb/NTSz32kb9Z3Go4Rku3OacO57XYaLXH5
	6n1nL+wCaSA80HzESxinUu7VYLhIzqp43NLwAepfalyDtjzbcwOztBZJmA71An4PB1MH
	bkMciTxtLVpVvo+CzRwCXLvOjTVSO9imR/huI=
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=Ibe2Hb6gXjNyh8HcoTyj7Z4xiwN7LvwxvmxQ3n0rCKPP5vAY9AYrD4p0PbYdBw7xRB
	bvCaeO1o2U7Wd1omRZi23HdaHyRj1zPBJzgVzOBJvpejTUw9Px+Qy7w4Sx+ao0tbKfvM
	wB0xCY7p2WtoopzCnI3FmJR07J9ZOVGz3EItg=
MIME-Version: 1.0
Received: by 10.204.154.208 with SMTP id p16mr2153869bkw.80.1259869018344;
	Thu, 03 Dec 2009 11:36:58 -0800 (PST)
In-Reply-To: <12517.1259868079@sss.pgh.pa.us>
References: <4B17FDCE.6030200@fmed.uba.ar> <12517.1259868079@sss.pgh.pa.us>
Date: Thu, 3 Dec 2009 22:36:58 +0300
Message-ID: <b4399d110912031136x5d24c43aq4369a1c84d7dda0e@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=0015175ce1ac4d4d080479d81d59
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5 tests=AWL=-0.000,
	BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200912/4
X-Sequence-Number: 33442

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

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
>

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

Hello all.<div>Tom right. Encrypted MD5 passwords computed as md5(password =
|| test10). I checked.</div><div><br></div><div>Regards, Dmitriy Igrishin.=
=A0<br><br><div class=3D"gmail_quote">2009/12/3 Tom Lane <span dir=3D"ltr">=
&lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt;</span><b=
r>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;"><div class=3D"im">Gerardo Herzig &lt;<a hre=
f=3D"mailto:gherzig@fmed.uba.ar">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 class=3D"h5"><br>
--<br>
Sent via pgsql-sql mailing list (<a href=3D"mailto:pgsql-sql@postgresql.org=
">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><br></div>

--0015175ce1ac4d4d080479d81d59--