Re: [HACKERS] md5 passwords and pg_shadow

2002-04-25 Thread Bruce Momjian
Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > How many pre-7.2 clients are actually out there? If 'crypt' authentication > > is deprecated in 7.2, is there any chance it will be removed in > > 7.3? If it is, it should be safe to switch to the scheme I mentioned > > in my previous e

Re: [HACKERS] md5 passwords and pg_shadow

2002-04-25 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > How many pre-7.2 clients are actually out there? If 'crypt' authentication > is deprecated in 7.2, is there any chance it will be removed in > 7.3? If it is, it should be safe to switch to the scheme I mentioned > in my previous email, which is both less c

Re: [HACKERS] md5 passwords and pg_shadow

2002-04-25 Thread Bruce Momjian
Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > IMHO, there are two separate processes going on here: > > The connection you are missing is that hashed password storage is > incompatible with crypt-style password transmission. If we force > hashed storage then the only password tra

Re: [HACKERS] md5 passwords and pg_shadow

2002-04-25 Thread Neil Conway
On Thu, 25 Apr 2002 13:32:27 -0400 "Tom Lane" <[EMAIL PROTECTED]> wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > IMHO, there are two separate processes going on here: > > The connection you are missing is that hashed password storage is > incompatible with crypt-style password transmission.

Re: [HACKERS] md5 passwords and pg_shadow

2002-04-25 Thread Bruce Momjian
OK, I remember now. 'Password' is fine for MD5-encrypted pg_shadow because you are using the password supplied over the wire to compare to the md5. (Of couse, no one should be using 'password'.) It is 'crypt' that is the problem. You get a random salted crypted password from the user, and you

Re: [HACKERS] md5 passwords and pg_shadow

2002-04-25 Thread Neil Conway
On Thu, 25 Apr 2002 01:50:32 -0400 (EDT) "Bruce Momjian" <[EMAIL PROTECTED]> wrote: > Neil Conway wrote: > > Hi all, > > > > Why does the password_encryption GUC variable default to false? > > > > AFAICT there shouldn't be any issues with client compatibility -- in > > fact, I'd be inclined to r

Re: [HACKERS] md5 passwords and pg_shadow

2002-04-25 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > IMHO, there are two separate processes going on here: The connection you are missing is that hashed password storage is incompatible with crypt-style password transmission. If we force hashed storage then the only password transmission style available to

Re: [HACKERS] md5 passwords and pg_shadow

2002-04-24 Thread Bruce Momjian
Neil Conway wrote: > Hi all, > > Why does the password_encryption GUC variable default to false? > > AFAICT there shouldn't be any issues with client compatibility -- in > fact, I'd be inclined to rip out all support for storing cleartext > passwords... It is false so passwords can be handled b

[HACKERS] md5 passwords and pg_shadow

2002-04-24 Thread Neil Conway
Hi all, Why does the password_encryption GUC variable default to false? AFAICT there shouldn't be any issues with client compatibility -- in fact, I'd be inclined to rip out all support for storing cleartext passwords... Cheers, Neil -- Neil Conway <[EMAIL PROTECTED]> PGP Key ID: DB3C29FC -