From: | <btober(at)computer(dot)org> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: encrypted passwords |
Date: | 2004-06-08 12:18:28 |
Message-ID: | 64670.216.238.112.88.1086697108.squirrel@$HOSTNAME |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>>
>> I cannot set up password authentication with encrypted passwords.
>> With plaintext passwords auth works fine. So my guess is that I am
>> using an incorrect password encryption program.
>>
>> What encryption utility should I use to store an MD5 password?
>>
>> I tried md5sum, but passwords encrypted with md5sum will not let me
>> log in.
>>
>> I also tried classic "crypt", and I used Python's crypt module to
>> encrypt my password, and it did not work either.
>
> You don't manually encrypt them with anything. You enter them
> plain-text and pgsql encrypts them before storage.
>
But, FWIW, someone else in an earlier thread posted that what gets stored
in the passwd column of pg_shadow is the value returned by
select 'md5'||encode(digest('your_password'||'your_username' , 'md5'),
'hex')
--Berend Tober
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2004-06-08 12:34:59 | Re: Slony-I goes BETA (possible bug) |
Previous Message | Holger Klawitter | 2004-06-08 12:17:57 | Index on points |