Re: encrypted passwords
От | |
---|---|
Тема | Re: encrypted passwords |
Дата | |
Msg-id | 64670.216.238.112.88.1086697108.squirrel@$HOSTNAME обсуждение исходный текст |
Ответ на | Re: encrypted passwords (jseymour@linxnet.com (Jim Seymour)) |
Список | 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
В списке pgsql-general по дате отправления: