Re: [BUGS] BUG #1134: ALTER USER ... RENAME breaks md5

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [BUGS] BUG #1134: ALTER USER ... RENAME breaks md5
Date: 2004-04-27 07:37:50
Message-ID: Pine.LNX.4.58.0404270926080.28436@sablons.cri.ensmp.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches


Dear Bruce,

> Yes, the problem is that we used the username for the salt, just like
> FreeBSD does for its MD5 passwords.

Not that I know of on FreeBSD?

shell> uname -a
FreeBSD palo-alto2.ensmp.fr 4.9-STABLE FreeBSD 4.9-STABLE #5: Mon Mar 1 21:31:30 CET 2004 root(at)palo-alto2(dot)ensmp(dot)fr:/usr/src/sys/compile/IAR2M i386

shell> grep coelho /var/yp/master.passwd
coelho:$1$00EacB0I$4kQ/HmqFFQANZP/mxj8ZX0:210:20::0:0:COELHO, Fabien:/users/cri/coelho:/usr/local/bin/bash
^^^^^^^^ ^^^^^^^^^^^^^^^^^^^^^^
salt some base 64 encoding of 1002 paranoid md5 computations.

Even of the salt is based on the login, the point is that it is stored
separatly, so the system does not rely on the login string to check the
password.

The only other scheme which requires the user password somehow is the HTTP
digest authentification, and AFAIK no one in the world uses it;-)

> The attached patch clears the password field on rename:

By 'clearing' and after a look at the patch, I understand that the access
will be denied after the rename, which is the current behavior anyway;-)

> and adds documention explaining this behavior. I can't think of a
> better solution.

Yes, I'm afraid there is no 'light' fix, other than acknowledging the
fact... Not a big issue.

Thanks,

--
Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PostgreSQL Bugs List 2004-04-27 11:21:47 BUG #1142: Problem with update permissions for view
Previous Message Bruce Momjian 2004-04-27 02:16:19 Re: [BUGS] BUG #1134: ALTER USER ... RENAME breaks md5 passwords

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-04-27 13:04:24 Re: [BUGS] BUG #1134: ALTER USER ... RENAME breaks md5
Previous Message Bruce Momjian 2004-04-27 03:54:19 Re: subtransactions -- storage manager