hashcat Forum
Parse Database - Printable Version

+- hashcat Forum (https://hashcat.net/forum)
+-- Forum: Misc (https://hashcat.net/forum/forum-15.html)
+--- Forum: General Talk (https://hashcat.net/forum/forum-33.html)
+--- Thread: Parse Database (/thread-6240.html)



Parse Database - tiren1337 - 01-27-2017

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


RE: Parse Database - Chick3nman - 01-27-2017

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


RE: Parse Database - tiren1337 - 01-27-2017

(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


RE: Parse Database - Chick3nman - 01-27-2017

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.).


RE: Parse Database - tiren1337 - 01-27-2017

(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


RE: Parse Database - Chick3nman - 01-27-2017

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.


RE: Parse Database - tiren1337 - 01-27-2017

(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


RE: Parse Database - Chick3nman - 01-27-2017

It should still be possible to both reformat and pair the lists.


RE: Parse Database - atom - 01-27-2017

The hashcat way to do this is using --show: https://hashcat.net/wiki/doku.php?id=frequently_asked_questions#how_can_i_show_previously_cracked_passwords_and_output_them_in_a_specific_format_eg_emailpassword