Security Basics mailing list archives
Re: SQL Storing Passwords?
From: khushal201301 () gmail com
Date: Tue, 4 Sep 2012 12:22:26 +0000
Hi All, As hash is irreversible, therefore even you get an access to a password field you will not be able to get the actual password, storing the random value in DB is the salt value that concatenate with the hash of the actual password then again hash of it. -----Original Message----- From: Alexander Meesters <a.meesters () sansyl com> Sender: listbounce () securityfocus com Date: Tue, 04 Sep 2012 13:38:24 To: <security-basics () securityfocus com> Subject: Re: SQL Storing Passwords? -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 hello, First of all, storing salts next to a hash is not bad design, it perfect. Why? Well, now if somebody want to crack them using rainbow tables, then need to regenerate the rainbow table every time the user changes. This will really slow down the whole process of cracking and might even make the unsub give up the project as a whole. At least it will buy you some time to get users to change the passwords once you detected your breach. have a good one, Alexander Meesters On 09/04/2012 12:10 PM, Gautam wrote:
Hi Jim, The PWD in the table should be the actual hash of your password, however they don't seem to be basic hash in your case. They are salted and the key values in your table are the salt. so the hashing is done like this SSHA('mypassword','key') From my point of view keeping the passwords and the key in the same table is a poor design, however that's what a developer generally do so that he can manage everything in one space. if you want to verify take a known password and take a 'key' value from your table and you will notice that you will get the value from the "pwd" field. Just check what hashing is used. Notice this on crackstation.net 'Enter up to 10 non-salted hashes: ' :-) . that's why it will not give you any results. Hope this helps. G On Thu, Aug 30, 2012 at 11:07 PM, Greg Merideth <gmerideth () uclnj com> wrote:If it ends in an "=" sign it's more than likely base64 encoded text. It could have been encrypted before and then stored in base64 so it may be gibberish but try running it through a base64 decoder and see what you get. .:.:.:.:.:.:. Greg Merideth President/Chief Problem Solver United Computer Technologies gmerideth () uclnj com http://www.facebook.com/uclnj -----Original Message----- From: listbounce () securityfocus com [mailto:listbounce () securityfocus com] On Behalf Of jim.jones12 () gmail com Sent: Wednesday, August 29, 2012 4:49 PM To: security-basics () securityfocus com Subject: SQL Storing Passwords? Hello, I'm looking for so help, i've come across a user table within SQL 2008 that contains two columns "Pwd" & "Key" and concerned they may contain our users Active Directory credentials. The Pwd column contains what appears to be a 40 character hash (uppercase) and the Key column has a random 8 character key that ends in "=". I've tried running the Pwd string through crackstation.net but to not avail. The same user tables also contains a column for username and full name. I guess with the recent Linkedin and Philips hack I may be a little over paranoid. Could someone point me in the right direction on what I can to do validate this information? Thanks, Jim ------------------------------------------------------------------------
Securing Apache Web Server with thawte Digital Certificate In this guide we examine the importance of Apache-SSL and who needs an SSL certificate. We look at how SSL works, how it benefits your company and how your customers can tell if a site is secure. You will find out how to test, purchase, install and use a thawte Digital Certificate on your Apache web server. Throughout, best practices for set-up are highlighted to help you ensure efficient ongoing management of your encryption keys and digital certificates.
http://www.dinclinx.com/Redirect.aspx?36;4175;25;1371;0;5;946;e13b6be442f727d1
- ------------------------------------------------------------------------
------------------------------------------------------------------------
Securing Apache Web Server with thawte Digital Certificate
In this guide we examine the importance of Apache-SSL and who needs an SSL certificate. We look at how SSL works, how it benefits your company and how your customers can tell if a site is secure. You will find out how to test, purchase, install and use a thawte Digital Certificate on your Apache web server. Throughout, best practices for set-up are highlighted to help you ensure efficient ongoing management of your encryption keys and digital certificates. http://www.dinclinx.com/Redirect.aspx?36;4175;25;1371;0;5;946;e13b6be442f727d1
- ------------------------------------------------------------------------
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://www.enigmail.net/ iQEcBAEBAgAGBQJQRegwAAoJEFOGF85BKmb2ugYH/3zr4elw9jOudm24S7C4miH3 beP6Px+x9d5u/hBu9beISFKWNCOJuiih+cmK0UF/bzA2vq4mGchiQMbYotwKuEMG rDzh+3JghFeDwU+BsifSXvhiSJmfskL3zp+SXGcHowWuY0kfm4Nzd5/538Iz7tG6 E1o4a18bgCg72QJvI3jdN2RwMl6OLjjSXvpmqaXkRcLdoXMm/xEssmjYcQcefLRf fHbO/IPob+PT7ZALH0O62pO25pkf9yrzSxdCGh8bWoNFZsVEn5pCBsacVqvf3k9d vhvHTPZNwav3t5woQQWmJBasrL5uPE6WYUqP4AIBSctdEcXD0zuwV7fUub21Y78= =QIeX -----END PGP SIGNATURE----- ------------------------------------------------------------------------ Securing Apache Web Server with thawte Digital Certificate In this guide we examine the importance of Apache-SSL and who needs an SSL certificate. We look at how SSL works, how it benefits your company and how your customers can tell if a site is secure. You will find out how to test, purchase, install and use a thawte Digital Certificate on your Apache web server. Throughout, best practices for set-up are highlighted to help you ensure efficient ongoing management of your encryption keys and digital certificates. http://www.dinclinx.com/Redirect.aspx?36;4175;25;1371;0;5;946;e13b6be442f727d1 ------------------------------------------------------------------------
Current thread:
- Re: SQL Storing Passwords? Gautam (Sep 04)
- Re: SQL Storing Passwords? Alexander Meesters (Sep 04)
- Re: SQL Storing Passwords? khushal201301 (Sep 04)
- Re: SQL Storing Passwords? Davin Enigl (Sep 04)
- Re: SQL Storing Passwords? Jeffrey Walton (Sep 04)
- Re: SQL Storing Passwords? Davin Enigl (Sep 05)
- Re: SQL Storing Passwords? Alexander Meesters (Sep 04)