Thread: Require entry of MD5 hash instead of plaintext password?

Require entry of MD5 hash instead of plaintext password?

From
mwsenecal@yahoo.com
Date:
Is there a way to configure PostgreSQL 8.0 so that when prompted for a
password, the user enters the MD5 hash of his password, instead of the
normal plaintext password?

That is, when prompted for the password, instead of typing the
plaintext password as you normally would ("Foo", for example), you
would instead enter in the MD5 hash ("A8127A7CBLAHBLAHBLAHBLAH").


Re: Require entry of MD5 hash instead of plaintext password?

From
Michael Fuhr
Date:
On Fri, Jul 27, 2007 at 09:33:37AM -0700, mwsenecal@yahoo.com wrote:
> Is there a way to configure PostgreSQL 8.0 so that when prompted for a
> password, the user enters the MD5 hash of his password, instead of the
> normal plaintext password?

What problem are you trying to solve?

--
Michael Fuhr

Re: Require entry of MD5 hash instead of plaintext password?

From
mwsenecal@yahoo.com
Date:
On Jul 28, 12:32 pm, m...@fuhr.org (Michael Fuhr) wrote:
> On Fri, Jul 27, 2007 at 09:33:37AM -0700, mwsene...@yahoo.com wrote:
> > Is there a way to configure PostgreSQL 8.0 so that when prompted for a
> > password, the user enters the MD5 hash of his password, instead of the
> > normal plaintext password?
>
> What problem are you trying to solve?
>
> --
> Michael Fuhr
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org/

Curiosity, mostly. When creating a user you can specify the password
as an MD5 hash. I was just wondering if you could also submit a
password in that form (the assumption being that a trusted external
application had performed the hashing).