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
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 |
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 |