From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | 'Ivan Horvath' <i(dot)horvath(at)alco(dot)co(dot)hu>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: password encyption |
Date: | 2002-03-13 11:44:22 |
Message-ID: | FED2B709E3270E4B903EB0175A49BCB104769A@dogbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
BTW. PostgreSQL uses MD5.
Regards, Dave.
-----Original Message-----
From: Ivan Horvath [mailto:i(dot)horvath(at)alco(dot)co(dot)hu]
Sent: 13 March 2002 11:34
To: Dave Page; pgadmin-support(at)postgresql(dot)org
Subject: 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
----- Original Message -----
From: Dave Page <mailto:dpage(at)vale-housing(dot)co(dot)uk>
To: 'Ivan Horvath' <mailto:i(dot)horvath(at)alco(dot)co(dot)hu> ;
pgadmin-support(at)postgresql(dot)org <mailto:pgadmin-support(at)postgresql(dot)org>
Sent: Wednesday, March 13, 2002 12:15 PM
Subject: RE: [pgadmin-support] password encyption
Hi,
Under Tools -> Options, on the PostgreSQL tab, uncheck the box labelled 'Use
Encrypted Passwords', and then alter the password for your user.
Regards, Dave.
-----Original Message-----
From: Ivan Horvath [mailto:i(dot)horvath(at)alco(dot)co(dot)hu]
Sent: 13 March 2002 10:53
To: pgadmin-support(at)postgresql(dot)org <mailto:pgadmin-support(at)postgresql(dot)org>
Subject: [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áth
Chief Programmer
Alcatel NSD
PMS 2000 Product Team
H-1116, Budapest
Kondorfa u. 10.
Tel.: +36 1 209 9546
Fax.: +36 1 463 7271
Mobil: +36 30 257 0235
E-mail: <mailto:i(dot)horvath(at)alco(dot)co(dot)hu> i(dot)horvath(at)alco(dot)co(dot)hu
Check my Web Page <http://www.extra.hu/pillesoft>
Anyone who has never made a mistake has never tried anything new.
/Albert Einstein/
From | Date | Subject | |
---|---|---|---|
Next Message | Peter E. Chen | 2002-03-13 16:08:41 | Re: password encyption |
Previous Message | Ivan Horvath | 2002-03-13 11:33:33 | Re: password encyption |