I've been playing around lately with hashing via both SQL Server 2008 and
CF. The following should give you the same results in both:
<cfset hashpwd = hash(pwd & uuid,"SHA-1" )>
SET @pwdHash = CONVERT(VARCHAR(40),HashBytes('SHA1', @pwd + @UUID),2)
My understanding is, SQL Server 2012 is the only version that currently
supports SHA512.
Thanks,
Eric Cobb
http://www.cfgears.com
----------------------------------------
From: "Bobby" <bo...@acoderslife.com>
Sent: Monday, March 11, 2013 11:04 AM
To: "cf-talk" <cf-talk@houseoffusion.com>
Subject: Re: Adding Salt and Password Hash to existing acocunts
In the example it was a hardcoded string for the salt. 'mySalt'. you'd
just replace that with whatever you intend to use.
I haven't used SHA512 this way. I only did it the way I did so there was
an equivalent method in CF to generate the same hash.
You'd have to play around with generating SHA512 hashes in TSQL and make
sure you are also able to generate that same hash in CF (assuming you will
be doing your hashing in CF at all before sending to the database).
You can do as many iterations of the salt as you want I suppose. If I was
going to hash multiple times, I'd salt them all.
On 3/11/13 9:05 AM, "Torrent Girl" <moniqueb...@gmail.com> wrote:
>SHA512
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354926
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
