Re: Postgres: pg_hba.conf, md5, pg_shadow, encrypted passwords

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Postgres: pg_hba.conf, md5, pg_shadow, encrypted passwords
Date: 2005-04-21 18:18:43
Message-ID: 20050421181843.GC29028@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Josh Berkus (josh(at)agliodbs(dot)com) wrote:
> David, Stephen,

[Changed back to pgsql-hackers]

> Well, from our perspective, a random salt only protects against a very narrow
> range of attack types -- ones in which the attacker already has access to the
> physical database and wants to reverse-engineer user's passwords. We'd be
> much more interested in the implementation of more/better authentication
> mechanisms. See follow-up dicussion on pgsql-hackers.

I'm concerned about both using a random salt in pg_shadow and about
better documentation about what happens when you use 'md5' in
pg_hba.conf.

> Of course, if either of you *wrote* a random-salt patch for PostgreSQL, psql
> and libpq, then that would be a different story. I don't know that anyone
> has anything *against* a random salt. It's just not nearly as useful as,
> for example, implementing SHA1.

It was generally my understanding that it was better to get it
'sanctioned' and on the TODO list before just writing something up and
expecting it to be included. I've already offered elsewhere to work on
writing a random-salt patch for PostgreSQL targeted at 8.1 and this
encourages me further. I understand that I'd need to be sure it was
backwards compatible to some extent (do both older client <-> newer
server and newer client <-> older server need to work? I seem to recall
only older client <-> newer server had to work, but perhaps I'm not
remembering right).

Stephen

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-04-21 18:23:37 Re: Postgres: pg_hba.conf, md5, pg_shadow, encrypted passwords
Previous Message Stephen Frost 2005-04-21 18:05:54 Re: Postgres: pg_hba.conf, md5, pg_shadow, encrypted passwords