Parse Database
#1
Hello!

I need someone who can help me with Database. In one database i got user:hash, in other i have email:user... How i can compare those to get email:hash, because it's not in same order, and one part is diffrent then other, little bit bigger. Thanks
Reply
#2
The operation you are trying to do is called Item Pairing. There are a few tools around that can do it, including an online one linked below.

Online: https://hashes.org/tools.php?tool=list_merge

Download: http://unifiedlm.com/Home
Reply
#3
(01-27-2017, 12:32 AM)Chick3nman Wrote: The operation you are trying to do is called Item Pairing. There are a few tools around that can do it, including an online one linked below.

Online: https://hashes.org/tools.php?tool=list_merge

Download: http://unifiedlm.com/Home

For example i got 


Username1:Hash:Salt

and other part is 


Username1:Email:Salt

So how i can fix
Reply
#4
You will need to reformat them most likely for either tool to handle them although ULM might work better in this case. It shouldnt be too difficult to remove the usernames and salts and reformat the list. Can easily be done with notepad++ or really any other tool that supports regex(sed, awk, grep, etc.).
Reply
#5
(01-27-2017, 12:43 AM)Chick3nman Wrote: You will need to reformat them most likely for either tool to handle them although ULM might work better in this case. It shouldnt be too difficult to remove the usernames and salts and reformat the list. Can easily be done with notepad++ or really any other tool that supports regex(sed, awk, grep, etc.).

But after i remove user and salt i will have just Emails, so how should i know which Emails to add to which User:Hash
Reply
#6
You will need to reformat the lines in such a way that the username or salt fields can be used to pair the emails with the hashes. It shouldn't be very difficult, here's an example format.


user:Hash$Salt

email:user

Using those formats, you can pair the email and the hash+salt.
Reply
#7
(01-27-2017, 01:02 AM)Chick3nman Wrote: You will need to reformat the lines in such a way that the username or salt fields can be used to pair the emails with the hashes. It shouldn't be very difficult, here's an example format.


user:Hash$Salt

email:user

Using those formats, you can pair the email and the hash+salt.

Yes, but problem is database i have is 3 mil while original User:Email:Salt i 8 million, i can't sort them even in A-Z format because there are some missing lines in between on 3 million one
Reply
#8
It should still be possible to both reformat and pair the lists.
Reply
#9
The hashcat way to do this is using --show: https://hashcat.net/wiki/doku.php?id=fre...ilpassword
Reply