+- 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