Using md5 authentication

From: Philip Poloczek <Philip(dot)Poloczek(at)dlr(dot)de>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Using md5 authentication
Date: 2013-07-31 07:17:24
Message-ID: 51F8BA04.8030308@dlr.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Athanasios Kostopoulos 2013-07-31 07:43:16 Re: Using md5 authentication
Previous Message Daniel Gomez Blanco 2013-07-29 13:06:07 Re: User with "almost" superuser privileges