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 
> [EMAIL PROTECTED])



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Reply via email to