Using md5 authentication

Поиск
Список
Период
Сортировка
Искать
От
Philip Poloczek
Тема
Using md5 authentication
Дата
Msg-id
51F8BA04.8030308@dlr.de
Список
Дерево обсуждения
Using md5 authentication Philip Poloczek <Philip.Poloczek@dlr.de>
Re: Using md5 authentication Athanasios Kostopoulos <athanasios.kostopoulos@classmarkets.com>
Re: Using md5 authentication Philip Poloczek <Philip.Poloczek@dlr.de>
Re: Using md5 authentication Athanasios Kostopoulos <athanasios.kostopoulos@classmarkets.com>
Re: Using md5 authentication Philip Poloczek <Philip.Poloczek@dlr.de>
Re: Using md5 authentication "ktm@rice.edu" <ktm@rice.edu>
really novice with Postgres ! Jean MAURICE <mauricejea@numericable.fr>
Re: really novice with Postgres ! raghu ram <raghuchennuru@gmail.com>
Re: really novice with Postgres ! Jean MAURICE <mauricejea@numericable.fr>
really novice with Postgres ! Jean MAURICE <mauricejea@numericable.fr>
Re: really novice with Postgres ! Ziggy Skalski <zskalski@afilias.info>
Re: really novice with Postgres ! Jean MAURICE <mauricejea@numericable.fr>
Re: really novice with Postgres ! "Kevin Salisbury" <Kevin.Salisbury@twinman.com>
Re: really novice with Postgres ! Jean MAURICE <mauricejea@numericable.fr>
Re: really novice with Postgres ! "Kevin Salisbury" <Kevin.Salisbury@twinman.com>
really novice with Postgres ! Jean MAURICE <mauricejea@numericable.fr>
Re: really novice with Postgres ! Kevin Grittner <kgrittn@ymail.com>
Re: really novice with Postgres ! Jean MAURICE <mauricejea@numericable.fr>
'moving' from one database to another Jean MAURICE <mauricejea@numericable.fr>
Re: 'moving' from one database to another Kevin Grittner <kgrittn@ymail.com>
Re: 'moving' from one database to another Tom Lane <tgl@sss.pgh.pa.us>
Re: 'moving' from one database to another Jean MAURICE <mauricejea@numericable.fr>
Re: really novice with Postgres ! Tovo Rabemanantsoa <tovo.rabemanantsoa@bordeaux.inra.fr>
Re: really novice with Postgres ! Jean MAURICE <mauricejea@numericable.fr>
Re: really novice with Postgres ! Tovo Rabemanantsoa <tovo.rabemanantsoa@bordeaux.inra.fr>
Re: really novice with Postgres ! Steve Crawford <scrawford@pinpointresearch.com>
Re: really novice with Postgres ! raghu ram <raghuchennuru@gmail.com>
Hello,

I want to connect to my database using a md5 hash instead of the plain 
password, so i changed the authentication method in the pg_hba.conf to 
md5 instead of password.
example: i want to use '5f4dcc3b5aa765d61d8327deb882cf99' instead of 
'password' in the login mask.

But until now i didn't get it working, i still can connect to the 
database with the plain password but not with the corresponding md5 
Hash. When i'am using the md5 hash i just get a FATAL error for password 
authentication. I used pg_ctl to reload the pg_hba.conf and also 
restarted the server.

Also the md5 hash which is saved for the users in the database differs 
from my created ones for that specific password. I read that the 
passwords are salted before encrypted with a part of the usernames? But 
even if i use these md5 hashes as password input, i can not connect and 
get a FATAL error.

BTW is it possible to use SHA-1 encrypted passwords with postgresql?

I'am currently using postgresql 8.4.

pg_hba.conf
local   all         all                                md5
host    all         all         127.0.0.1/32           md5

Best recards,
pp

В списке pgsql-novice по дате отправления
От: Daniel Gomez Blanco
Дата:
От: Athanasios Kostopoulos
Дата:
Сообщение: Re: Using md5 authentication
FAQ