From erouse@comsquared.com Tue Nov  17 21:38:01 2009
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 3B812633681
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 17 Nov 2009 17:38:01 -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 21238-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 17 Nov 2009 21:37:53 +0000 (UTC)
X-Greylist: delayed 00:16:40.277021 by SQLgrey-1.7.6
Received: from smtp.comsquared.com (smtp.comsquared.com [209.155.237.140])
	by mail.postgresql.org (Postfix) with ESMTP id 295E9633256
	for <pgsql-sql@postgresql.org>; Tue, 17 Nov 2009 17:37:53 -0400 (AST)
Received: from mdpserv.comsquared.com (mdpserv [10.82.40.1])
	by smtp.comsquared.com (Switch-3.2.7/Switch-3.2.7) with ESMTP id
	nAHLKs9N017464
	for <pgsql-sql@postgresql.org>; Tue, 17 Nov 2009 16:21:09 -0500 (EST)
Received: from erouse052008 (erouse052008.ntc2s.comsquared.com [10.82.60.61])
	by mdpserv.comsquared.com (8.13.6+Sun/8.13.6) with ESMTP id
	nAHLKsx5029600
	for <pgsql-sql@postgresql.org>; Tue, 17 Nov 2009 16:20:54 -0500 (EST)
From: "Edward W. Rouse" <erouse@comsquared.com>
To: <pgsql-sql@postgresql.org>
Subject: lost password
Date: Tue, 17 Nov 2009 16:20:54 -0500
Message-ID: <00b501ca67cb$d8efd9e0$8acf8da0$@com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00B6_01CA67A1.F019D1E0"
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: Acpny9jAbfOmwqNaSjWmw072HC8O4Q==
Content-Language: en-us
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.739 tagged_above=-10 required=5
	tests=BAYES_20=-0.74, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200911/41
X-Sequence-Number: 33392

This is a multi-part message in MIME format.

------=_NextPart_000_00B6_01CA67A1.F019D1E0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

I have a database that has a "process" user. I need to move the database to
an additional server. When I restore it gave me a "user not found" error. So
I am trying to recreate this user, but no one knows what the password is
supposed to be. The processes connecting to it have encrypted versions of
the password. And what I can find in the database uses md5. Is there some
way to find out or copy over the users password? Trying to find every
process that uses this login will be very time consuming and we are
guaranteed to miss some and generate a lot of frustration and confusion as
processes that always worked cease. Not to mention that some stuff may be
failing for a while before someone catches it.

 

I was thinking of just taking the md5 from pg_authid:rolpassword and using
it to update the new server. Will this work? Or is there another way to
retrieve a forgotten password?

 

Edward W. Rouse

Comsquared System, Inc.

770-734-5301

 


------=_NextPart_000_00B6_01CA67A1.F019D1E0
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" =
xmlns:rtc=3D"http://microsoft.com/officenet/conferencing" =
xmlns:Repl=3D"http://schemas.microsoft.com/repl/" =
xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/meetings/" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/xml" =
xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/directory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/"=
 xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile" =
xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/parttopart" =
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/workflow/" =
xmlns:dsss=3D"http://schemas.microsoft.com/office/2006/digsig-setup" =
xmlns:dssi=3D"http://schemas.microsoft.com/office/2006/digsig" =
xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/2006/digital-sig=
nature" =
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compatibility/2006=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/2006/relationshi=
ps" xmlns:spwp=3D"http://microsoft.com/sharepoint/webpartpages" =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/services/2006/types"=
 =
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/services/2006/messag=
es" =
xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/=
" =
xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPortalServer/Pub=
lishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" =
xmlns:st=3D"&#1;" xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal>I have a database that has a &#8220;process&#8221; =
user. I
need to move the database to an additional server. When I restore it =
gave me a &#8220;user
not found&#8221; error. So I am trying to recreate this user, but no one =
knows
what the password is supposed to be. The processes connecting to it have
encrypted versions of the password. And what I can find in the database =
uses
md5. Is there some way to find out or copy over the users password? =
Trying to
find every process that uses this login will be very time consuming and =
we are guaranteed
to miss some and generate a lot of frustration and confusion as =
processes that
always worked cease. Not to mention that some stuff may be failing for a =
while
before someone catches it.<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>I was thinking of just taking the md5 from =
pg_authid:rolpassword
and using it to update the new server. Will this work? Or is there =
another way
to retrieve a forgotten password?<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>Edward W. Rouse<o:p></o:p></p>

<p class=3DMsoNormal>Comsquared System, Inc.<o:p></o:p></p>

<p class=3DMsoNormal>770-734-5301<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

</div>

</body>

</html>

------=_NextPart_000_00B6_01CA67A1.F019D1E0--




From erouse@comsquared.com Tue Nov  17 21:43:35 2009
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id E5C80633681
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 17 Nov 2009 17:43:35 -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 21925-01 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 17 Nov 2009 21:43:28 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp.comsquared.com (smtp.comsquared.com [209.155.237.140])
	by mail.postgresql.org (Postfix) with ESMTP id 99CAB633F23
	for <pgsql-sql@postgresql.org>; Tue, 17 Nov 2009 17:43:27 -0400 (AST)
Received: from mdpserv.comsquared.com (mdpserv [10.82.40.1])
	by smtp.comsquared.com (Switch-3.2.7/Switch-3.2.7) with ESMTP id
	nAHLhLR2021125
	for <pgsql-sql@postgresql.org>; Tue, 17 Nov 2009 16:43:24 -0500 (EST)
Received: from erouse052008 (erouse052008.ntc2s.comsquared.com [10.82.60.61])
	by mdpserv.comsquared.com (8.13.6+Sun/8.13.6) with ESMTP id
	nAHLhL6h029850; Tue, 17 Nov 2009 16:43:21 -0500 (EST)
From: "Edward W. Rouse" <erouse@comsquared.com>
To: "'Edward W. Rouse'" <erouse@comsquared.com>, <pgsql-sql@postgresql.org>
References: <00b501ca67cb$d8efd9e0$8acf8da0$@com>
In-Reply-To: <00b501ca67cb$d8efd9e0$8acf8da0$@com>
Subject: Re: lost password
Date: Tue, 17 Nov 2009 16:43:20 -0500
Message-ID: <00c001ca67ce$fb3fd970$f1bf8c50$@com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00C1_01CA67A5.1269D170"
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: Acpny9jAbfOmwqNaSjWmw072HC8O4QAApuZA
Content-Language: en-us
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.002 tagged_above=-10 required=5
	tests=BAYES_50=0.001, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200911/42
X-Sequence-Number: 33393

This is a multi-part message in MIME format.

------=_NextPart_000_00C1_01CA67A5.1269D170
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Well I quickly found out 2 things:

 

1.       You can copy the md5 over and have it work

2.       The same password can have different md5's

 

After I copied the md5 over I played around a bit and found the for the
process user. I then used the alter user sql statement and rechecked the
md5. It was different, but I could still use the same password to log in.
Needless to say, I am a bit confused by that, but it works and that's what I
need.

 

Edward W. Rouse

 

From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Edward W. Rouse
Sent: Tuesday, November 17, 2009 4:21 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] lost password

 

I have a database that has a "process" user. I need to move the database to
an additional server. When I restore it gave me a "user not found" error. So
I am trying to recreate this user, but no one knows what the password is
supposed to be. The processes connecting to it have encrypted versions of
the password. And what I can find in the database uses md5. Is there some
way to find out or copy over the users password? Trying to find every
process that uses this login will be very time consuming and we are
guaranteed to miss some and generate a lot of frustration and confusion as
processes that always worked cease. Not to mention that some stuff may be
failing for a while before someone catches it.

 

I was thinking of just taking the md5 from pg_authid:rolpassword and using
it to update the new server. Will this work? Or is there another way to
retrieve a forgotten password?

 

Edward W. Rouse

Comsquared System, Inc.

770-734-5301

 


------=_NextPart_000_00C1_01CA67A5.1269D170
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" =
xmlns:rtc=3D"http://microsoft.com/officenet/conferencing" =
xmlns:Repl=3D"http://schemas.microsoft.com/repl/" =
xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/meetings/" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/xml" =
xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/directory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/"=
 xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile" =
xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/parttopart" =
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/workflow/" =
xmlns:dsss=3D"http://schemas.microsoft.com/office/2006/digsig-setup" =
xmlns:dssi=3D"http://schemas.microsoft.com/office/2006/digsig" =
xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/2006/digital-sig=
nature" =
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compatibility/2006=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/2006/relationshi=
ps" xmlns:spwp=3D"http://microsoft.com/sharepoint/webpartpages" =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/services/2006/types"=
 =
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/services/2006/messag=
es" =
xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/=
" =
xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPortalServer/Pub=
lishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" =
xmlns:st=3D"&#1;" xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
	{mso-style-priority:34;
	margin-top:0in;
	margin-right:0in;
	margin-bottom:0in;
	margin-left:.5in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
span.EmailStyle17
	{mso-style-type:personal;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
span.EmailStyle18
	{mso-style-type:personal-reply;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
	{page:Section1;}
 /* List Definitions */
 @list l0
	{mso-list-id:1766149577;
	mso-list-type:hybrid;
	mso-list-template-ids:-107871942 67698703 67698713 67698715 67698703 =
67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
	{mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-.25in;}
ol
	{margin-bottom:0in;}
ul
	{margin-bottom:0in;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><span style=3D'color:#1F497D'>Well I quickly found =
out 2
things:<o:p></o:p></span></p>

<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=3DMsoListParagraph style=3D'text-indent:-.25in;mso-list:l0 =
level1 lfo1'><![if !supportLists]><span
style=3D'color:#1F497D'><span style=3D'mso-list:Ignore'>1.<span =
style=3D'font:7.0pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]><span style=3D'color:#1F497D'>You can =
copy the md5
over and have it work<o:p></o:p></span></p>

<p class=3DMsoListParagraph style=3D'text-indent:-.25in;mso-list:l0 =
level1 lfo1'><![if !supportLists]><span
style=3D'color:#1F497D'><span style=3D'mso-list:Ignore'>2.<span =
style=3D'font:7.0pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]><span style=3D'color:#1F497D'>The same =
password
can have different md5&#8217;s<o:p></o:p></span></p>

<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'>After I copied the =
md5 over I
played around a bit and found the for the process user. I then used the =
alter
user sql statement and rechecked the md5. It was different, but I could =
still
use the same password to log in. Needless to say, I am a bit confused by =
that,
but it works and that&#8217;s what I need.<o:p></o:p></span></p>

<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<div>

<p class=3DMsoNormal><span style=3D'color:#1F497D'>Edward W. =
Rouse<o:p></o:p></span></p>

</div>

<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<div>

<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt =
0in 0in 0in'>

<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span>=
</b><span
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> =
pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org] <b>On Behalf Of </b>Edward W. =
Rouse<br>
<b>Sent:</b> Tuesday, November 17, 2009 4:21 PM<br>
<b>To:</b> pgsql-sql@postgresql.org<br>
<b>Subject:</b> [SQL] lost password<o:p></o:p></span></p>

</div>

</div>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>I have a database that has a &#8220;process&#8221; =
user. I
need to move the database to an additional server. When I restore it =
gave me a
&#8220;user not found&#8221; error. So I am trying to recreate this =
user, but
no one knows what the password is supposed to be. The processes =
connecting to
it have encrypted versions of the password. And what I can find in the =
database
uses md5. Is there some way to find out or copy over the users password? =
Trying
to find every process that uses this login will be very time consuming =
and we
are guaranteed to miss some and generate a lot of frustration and =
confusion as
processes that always worked cease. Not to mention that some stuff may =
be
failing for a while before someone catches it.<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>I was thinking of just taking the md5 from
pg_authid:rolpassword and using it to update the new server. Will this =
work? Or
is there another way to retrieve a forgotten password?<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>Edward W. Rouse<o:p></o:p></p>

<p class=3DMsoNormal>Comsquared System, Inc.<o:p></o:p></p>

<p class=3DMsoNormal>770-734-5301<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

</div>

</body>

</html>

------=_NextPart_000_00C1_01CA67A5.1269D170--




From tgl@sss.pgh.pa.us Tue Nov  17 23:57:04 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 3805C634A79
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 17 Nov 2009 19:57:04 -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 18398-05 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 17 Nov 2009 23:56:38 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by mail.postgresql.org (Postfix) with ESMTP id 6AE94634631
	for <pgsql-sql@postgresql.org>; Tue, 17 Nov 2009 19:56:53 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id nAHNuk61006763;
	Tue, 17 Nov 2009 18:56:46 -0500 (EST)
To: "Edward W. Rouse" <erouse@comsquared.com>
cc: pgsql-sql@postgresql.org
Subject: Re: lost password 
In-reply-to: <00c001ca67ce$fb3fd970$f1bf8c50$@com> 
References: <00b501ca67cb$d8efd9e0$8acf8da0$@com>
	<00c001ca67ce$fb3fd970$f1bf8c50$@com>
Comments: In-reply-to "Edward W. Rouse" <erouse@comsquared.com>
	message dated "Tue, 17 Nov 2009 16:43:20 -0500"
Date: Tue, 17 Nov 2009 18:56:46 -0500
Message-ID: <6762.1258502206@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.542 tagged_above=-10 required=5 tests=AWL=0.057,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 200911/43
X-Sequence-Number: 33394

"Edward W. Rouse" <erouse@comsquared.com> writes:
> After I copied the md5 over I played around a bit and found the for the
> process user. I then used the alter user sql statement and rechecked the
> md5. It was different, but I could still use the same password to log in.
> Needless to say, I am a bit confused by that, but it works and that's what I
> need.

The md5 will depend on both the actual password and the user's name
... does that help?

			regards, tom lane



From erouse@comsquared.com Wed Nov  18 15:11:12 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 25AE56366BA
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 18 Nov 2009 11:11:12 -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 80358-09 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 18 Nov 2009 15:10:52 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp.comsquared.com (smtp.comsquared.com [209.155.237.140])
	by mail.postgresql.org (Postfix) with ESMTP id 6DC236366AB
	for <pgsql-sql@postgresql.org>; Wed, 18 Nov 2009 11:11:01 -0400 (AST)
Received: from mdpserv.comsquared.com (mdpserv [10.82.40.1])
	by smtp.comsquared.com (Switch-3.2.7/Switch-3.2.7) with ESMTP id
	nAIFAhQl007521
	for <pgsql-sql@postgresql.org>; Wed, 18 Nov 2009 10:10:58 -0500 (EST)
Received: from erouse052008 (erouse052008.ntc2s.comsquared.com [10.82.60.61])
	by mdpserv.comsquared.com (8.13.6+Sun/8.13.6) with ESMTP id
	nAIFAgIP015104
	for <pgsql-sql@postgresql.org>; Wed, 18 Nov 2009 10:10:43 -0500 (EST)
From: "Edward W. Rouse" <erouse@comsquared.com>
To: <pgsql-sql@postgresql.org>
References: <00b501ca67cb$d8efd9e0$8acf8da0$@com>
	<00c001ca67ce$fb3fd970$f1bf8c50$@com>
	<6762.1258502206@sss.pgh.pa.us>
In-Reply-To: <6762.1258502206@sss.pgh.pa.us>
Subject: Re: lost password 
Date: Wed, 18 Nov 2009 10:10:42 -0500
Message-ID: <015b01ca6861$4b919930$e2b4cb90$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: Acpn4bCAdGWqlfUwRbqHW87YhqO38gAfxqxA
Content-Language: en-us
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.74 tagged_above=-10 required=5 tests=BAYES_20=-0.74
X-Spam-Level: 
X-Archive-Number: 200911/44
X-Sequence-Number: 33395

Well, the username and password are the same, but the md5 is different. But
it doesn't seem to matter because either one works the same. The fact that
you can have 2 different md5's yet still have the same user name and
password and have logins work is what I found to be interesting.

But my original problem is solved in either case, so it doesn't really
matter to me. I just found it to be ... interesting.

Edward W. Rouse

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Tom Lane
Sent: Tuesday, November 17, 2009 6:57 PM
To: Edward W. Rouse
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] lost password 

"Edward W. Rouse" <erouse@comsquared.com> writes:
> After I copied the md5 over I played around a bit and found the for the
> process user. I then used the alter user sql statement and rechecked the
> md5. It was different, but I could still use the same password to log in.
> Needless to say, I am a bit confused by that, but it works and that's what
I
> need.

The md5 will depend on both the actual password and the user's name
... does that help?

			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