[beginners] who to parse raw dbs

unlockermr

Lurker
Member
Joined
Threads
7
Posts
380
I will show you the complete solution how can you extract email and hash:salt or hash from a raw db.

If you have the complete SQL database with .sql format then download the below tool.
SpitefulLinedBushbaby-size_restricted.gif

You must reply to see the hidden content. Consider upgrading your account to increase your reply limit.
A nice tool to extract columns i am using this since months it never stopped working.

Now come to other things if you have a txt fine with is in some junk format something like below.
4092.jpg


We need to extract the username, hash and salt from the above file.What we need is regex it helps a lot to parse the raw txt. And we also need to use some commonsense also,everytime same regex wont work on all raw files.You need to modify it as per you needs.But this tutorial will give some idea how to work with raw files.
Now lets start, I remove the empty spaces and replaced them with ':' like below.
655f.jpg


Now we need to get the username ,password and salt the first column denotes users name we can say that by seeing the structure.
Now go to
Take a few linkes of raw file and paste it in that website . See the image below.
e8d4.jpg


That regex give the hash and salt depends on the raw text we need to change the regex or we need to use some replace regex expressions in notepad++

You build the regex now we need to use that regex to extrac.Online sites support to extact that data but for large dbs its impossible and browser gets hanged .So download a regex tool from here for windows version.
SpitefulLinedBushbaby-size_restricted.gif

You must reply to see the hidden content. Consider upgrading your account to increase your reply limit.

Nice tool it works same as online tool.

Just play with that expresso tool a 5 min you will understand how to do that shit.I hope you guys got some idea how to parse the raw file or database.

Note: We don't hate any one and there is no reason to choose this db for a demo.I just want to share with you.And i mask the ips from the pictures.
 
thanks for the tutorial
 
thanks Man.... your tutorial is helpful!