<SPAN
class=413313711-13032002>pgAdmin doesn't use encryption itself, that tickbox
just makes it use the ENCRYPTED keyword in CREATE/ALTER USER sql statements in
PostgreSQL 7.2+. Check out the PostgreSQL 7.2 documentation for details on using
the encrypted passwords.
<SPAN
class=413313711-13032002>
BTW.
PostgreSQL uses MD5.
<SPAN
class=413313711-13032002>
<SPAN
class=413313711-13032002>Regards, Dave.
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid;
MARGIN-RIGHT: 0px">
<FONT
face=Tahoma size=2>-----Original Message-----From: Ivan Horvath
[mailto:[EMAIL PROTECTED]] Sent: 13 March 2002
11:34To: Dave Page;
[EMAIL PROTECTED]: Re: [pgadmin-support]
password encyption
Hi Dave,
ok thank you!
but nevertheless the encryption of the user
password is not a bad idea, so what encyption method is used by
pgadmin?
i mean i create a user with pgadmin, specify a
password for the user
if i check the pg_shadow table i see a long text
in the pasword field.
if i want to connect this user to the
database, what kind encyption method i have to use?
Ivan
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000
2px solid; MARGIN-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
<A [EMAIL PROTECTED]
href="mailto:[EMAIL PROTECTED]";>Dave Page
To: <A [EMAIL PROTECTED]
href="mailto:[EMAIL PROTECTED]";>'Ivan Horvath' ; <A
[EMAIL PROTECTED]
href="mailto:[EMAIL PROTECTED]";>[EMAIL PROTECTED]
Sent: Wednesday, March 13, 2002 12:15
PM
Subject: RE: [pgadmin-support] password
encyption
<FONT face=Arial color=#0000ff
size=2>Hi,
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>Under Tools -> Options, on the PostgreSQL tab, uncheck the box
labelled 'Use Encrypted Passwords', and then alter the password for your
user.
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>Regards, Dave.
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid;
MARGIN-RIGHT: 0px">
<FONT
face=Tahoma size=2>-----Original Message-----From: Ivan Horvath
[mailto:[EMAIL PROTECTED]] Sent: 13 March 2002
10:53To: <A
href="mailto:[EMAIL PROTECTED]";>[EMAIL PROTECTED]:
[pgadmin-support] password encyption
Hi All,
i created a user in pgadmin, specified a
password of course. the user is created, but the password is encypted
somehow., i cannot log in anymore!!!
please help me, what is the
problem
Best
Regards,
Iván HorváthChief Programmer
Alcatel NSDPMS 2000 Product Team
H-1116, BudapestKondorfa u. 10.Tel.:
+36 1 209 9546Fax.: +36 1 463 7271Mobil: +36 30 257
0235E-mail: <FONT
face=Arial size=2>[EMAIL PROTECTED]<FONT face=Arial
size=2>Check my Web Page
Anyone who has never made a mistake has
never tried anything new.
/Albert
Einstein/
