Re: MD5 Passwords and user administratio - Mailing list pgsql-admin

From Rob Abernethy IV
Subject Re: MD5 Passwords and user administratio
Date
Msg-id 20030210091843.M49785@dynedge.com
Whole thread Raw
In response to MD5 Passwords and user administratio  (Carlos Ortiz <ortizc2@yahoo.com>)
List pgsql-admin
The username is the salt.

--
Robert Abernethy IV
Dynamic Edge, Inc.
734.975.0460


> I am trying to figure out exactly how to set someone's password when
> using MD5 passwords in postgres.  I am trying to automate some
> features, and still can't figure out what I am doing wrong.  MD5 of
> the password is obviously not wha  is used by itself, since that
> would be insecure, but I can't figure out what the salt is.  What
> exactly is psotgres passing to the MD5 hash to make up that
> incredible  unintelligible stream of characters that it stores in
> the password field of the pg_shadow table?
>
> desperate,
>
> Carlos
>
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)



pgsql-admin by date:

Previous
From: Jyry Kuukkanen
Date:
Subject: phpPgAdmin & PHP 4.3 problem sorted
Next
From: Mike Alford
Date:
Subject: ODBC and unknown i.p.