yashsingh1/xdaforums huggingface dataset:
[Android Apps and Games] ztedd:
@Mayn

Yes, that is what I expected. Your db file seems to be somehow of a different format than the script expects. What does the output html look like?

Which version of Whatsapp on Iphone do you use that created the database?

In order to help you further, I need screenshots of the output html and the input database. Please use SQLite Database Browser ( http://sqlitebrowser.sourceforge.net/ ) to generate screenshots of the database structure, especially of the tables ZWACHATSESSION, ZWASTATUS, ZWAMESSAGE and ZWAMEDIAITEM.

You may blacken parts of private data and you can send to me by PM if you prefer.
[Android Apps and Games] _Josito_:
Error

Hola, he leido lo que ha puesto Oscargpes en español, he seguido todos los pasos, pero cuando llego al paso 7 donde hay que ejecutar el .bat me sale lo siguiente en el MS DOS:

Hello, I read what has Oscargpes in Spanish, I followed all the steps, but when I get to step 7 where you have to run the. Bat I get the following at the MS DOS:

C:\Users\Jose\Desktop\Nueva carpeta (2)>whatsapp_xtract.py -i msgstore.db.crypt

El sistema no puede ejecutar el programa especificado

The system can not execute the specified program

C:\Users\Jose\Desktop\Nueva carpeta (2)>pause

Presione una tecla para continuar . . .

Press any key to continue. . .

So... What's the problem ???
[Android Apps and Games] ztedd:
Did you install ActivePython correctly? You need to check all the install options like shown in this screenshot:

Maybe you need to install it with administrator rights. Also you may need to restart windows for that the .py extension is correctly connected to Python.

Alternatively try this:

start whatsapp_xtract_console.bat

then type:

python whatsapp_xtract.py -i msgstore.db.crypt

If python is installed, this really should work. If not, you have to figure out how to install ActivePython correctly...
[Android Apps and Games] _Josito_:
Thanks

I tried typing "python-i whatsapp_xtract.py msgstore.db.crypt" and it worked! : D Thank youuu!! . But missing a lot of conversations that had been deleted in the whatsapp, for example, I talk a lot with a friend of December 25, 2011 but the conversation does not appear.

Note: the backup is from January 5, 2012
[Android Apps and Games] ztedd:
Whatsapp Xtract can only extract those messages that are inside the backup. I guess they aren't included in the db file. You can use SQLite Database Browser ( http://sqlitebrowser.sourceforge.net/ ) to check if you find the messages you are looking for.

Are you missing a whole chat (with a certain friend) or are you just missing some (older) messages inside that chat? As to say, are the newer messages with that friend included?

Are the messages also missing in the Whatsapp app? Maybe they have been deleted somehow.
[Android Apps and Games] dradeloos:
TypeError on a record

Hi

Thanks so much for your app :D

The android part works perfectly on for my android, but I get a TypeError on a record when trying to open an Iphone db.

It does however create a html version of the db, but with 'unreadable' text and numbers etc. ex: From is: 357584707.214

The error goes something like this:

Error TypeError while reading media message #267 in chat #5: 'NoneType' object is not subscriptable

I guess this means...

unsupported operand type(s) for +: 'int' and 'str'

Printing output to....

done!

I would really appreciate if you can look into this error...

Cheers
[Android Apps and Games] ztedd:
Issue with Iphone Whatsapp Database

great! :)

This is the same problem that occurs to Mayn.

The problem is, I don't have an up-to-date sample database file for the Iphone version. To be able to fix this error, I need such a sample db.

At first, can you please answer these questions:

Then I need a sample db file.

HOW TO CREATE A SAMPLE DATABASE:

You may also create a new blackberry sample database by reinstalling the blackberry whatsapp and then sending some test messages.

Ideally, these should include:

Also you can use SQLite Database Browser to anonymize your database file by modifying/deleting sensitive information.

Would appreciate if you can help me with either the screenshots or your database file or a sample database file!
[Android Apps and Games] ztedd:
I updated again, changing the way the script parses the sqlite databases (technically: columns are now accessed by name and not by number, e.g., msgs["ZTEXT"] instead of msgs[10]).

I guess this helps for the Iphone problem. You may try the new update (v2.0-bugsfixed-8) with an Iphone database file. Maybe something changed...

However, a sample database file is still needed, because the displaying of media messages and group messages still needs to be corrected/optimized.
[Android Apps and Games] Mayn:
Send you email
[Android Apps and Games] dradeloos:
Cannot open db with sqllite

Hi ztedd

I will try the update as soon as im back at my pc. Thanks for the quick reply.

I will try to also get the info you asked for, but i cannot even open the db with sqllite browser.

Not a valid sqllite 3 db error. So i guess it is encrypted?

Btw. I think the error rec is google maps record I received?

Anyway will let you know outcome and get you the data you requested.

Cheers
[Android Apps and Games] ztedd:
new major bug fix for Iphone version: support of media messages

@all: There is a new major bug fix for the Iphone version. Now also the support of media messages should be better (displaying of thumbnails, ..).

I included Iphone support for images, videos, vcard and (beta) gps. Also I fixed a bug of opening a wrong output file in browser.

New download links in the first posting (Whatsapp_Xtract_V2.0_2012-05-02-2.zip).

However, Iphone support still needs development.

ToDo: include Iphone support for audio, gps, gps of a place (like a restaurant), group messages and change of group name

For this, I need an Iphone sample database containing these message types!

Could someone send some test messages like the described and then send me the database (or at least screenshots of the ZWAMESSAGE and ZWAMEDIAITEM tables) ? That would be great.
[Android Apps and Games] Ghaanz:
This last version solves my issues with the iPhone database.

Now I do not receive any further error messages and all numbers are recognized and all messages are displayed correctly:)
[Android Apps and Games] denzel09:
Thank you

Inviato dal mio LG-P690 con Tapatalk 2
[Android Apps and Games] Ruddy13:
Hi,

Sorry for the inconvenience but I installed the ActivePython and the

crypto module, everything worked fine but all I get is the message:

"decrypted database written to msgstore.plain.db

Error: no such table: chat_list"

The result is a msgstore.plain.db file with 0 kb.

No browser opens.

Can you tell me what is wrong?

Thank you in advance.
[Android Apps and Games] utmuk:
Why doesn't the tool work with iPhone databases anymore? This has nothing to do with encryption because SQLite Browser views them all right

This is the output of whatsapp_xtract_iphone.bat:

C:\Users\MyName\Xtract>python whatsapp_xtract.py ChatStorage.sqlite
Python Version 3.x
iPhone mode!

*** METADATA PLIST DUMP ***

Plist ver.: 1
UUID: 0D94219C-327A-4451-B9D0-C01E3C65A444
Metadata Plist Dump is failed. Note that you need to use Python 2.7 for that bpl
ist.py works
Traceback (most recent call last):
File "whatsapp_xtract.py", line 2453, in <module>
main(sys.argv[1:])
File "whatsapp_xtract.py", line 1667, in main
curr_message = Message(msgs["Z_PK"],msgs["ZISFROMME"],msgs["ZMESSAGEDATE"],m
sgs["ZTEXT"],contactfrom,msgs["ZMESSAGESTATUS"],media["ZMEDIALOCALPATH"],media["
ZMEDIAURL"],media["ZTHUMBNAILDATA"],ZXMPPTHUMBPATH,mediawatype,media["ZFILESIZE"
],media["ZLATITUDE"],media["ZLONGITUDE"],media["ZVCARDNAME"],media["ZVCARDSTRING
"])
IndexError: No item with that key

C:\Users\MyName\Xtract>pause
[Android Apps and Games] Amon-Don:
Well i can view the old chatstorages with SQL Browser. New files i get " File not a SQLite 3 database"
[Android Apps and Games] utmuk:
Strange. I have latest whatsapp 2.11.8 and its databases open just fine. Confirmed.
[Android Apps and Games] rathodkaran07:
cannot open crypt5 database...

Guys is there any solution i am not able to extract msgstore.db.crypt5 please help...
[Android Apps and Games] vikalppatelce:
Decrypt Whatsapp database (crypt5)

Tested for Whatsapp Android : 2.11.186

One can use google - 'whatsapp.livetrack.mobi' to decrypt the whatsapp crypt5 database file. :laugh: As XDA not letting me include URL's please try to google them. :(

How to use it:-

1. Enter your gmail account associated with the device.

2. Upload your whatsapp database file encrypted.

3. Download your processed whatsapp decrypted file.

Open with SqliteStudio in your PC(Windows) - google - 'sqlitestudio.pl/?act=download' or with any of your Sqlite database viewer. :cowboy:

You can also open your database file inside android with google - 'dk.andsen.asqlitemanager' :good:
[Android Apps and Games] sam@xda29:
Using your browser
[Android Apps and Games] celucdp:
Dont work... after 30mar

Decryption failed / Incorrect account?

:/
[Android Apps and Games] 666edu666:
could not open database file. guess it's not a valid android or iphone database file

First say sorry for my language level. This is written in Spanish and translated with google.

I have a problem. I installed the python, the pycripto Seller adequate version of my python, I have the whatsapp xtract 2.2 and the database taken out of my cell phone, trying transcription says "could not open database file. Guess it's not a valid android or iphone database file "

versión python: 2.7.5.6

versión pycripto 2.7 - 2.6

whatsapp: 2.11.186

Samsung S4
[Android Apps and Games] TripCode:
Just been messing around with WhatsApp 2.11.206 for Android from the WhatsApp website. I have noticed that the encryption has now changed to a crypt6 format. This new method of encryption requires this file: /data/data/com.whatsapp/files/key This file is generated by the WhatsApp server so your device needs to be online in order to generate it. The key file will be exactly 158 bytes, though you can ignore the first 28 bytes. The rest is the key. ;) If the key is deleted a new one will be generated. A newly generated key will be different, but will still be able to decrypt a previous crypt6 backup. This suggests that the key itself contains encrypted data that remains constant. I'm unsure what this data is yet, but if it's not the account name or phone number and is something generated randomly (it most likely is), then this will officially end the ability for non rooted users to decrypt WhatsApp backups on Android. Unless of course the key can be extracted using a device to usb backup solution.

Wait for the Play Store update and then wait for people to visit this thread and complain about crypt6. You got your heads up here first. :rolleyes:
[Android Apps and Games] DeMoNisNaDeR:
Doubt

I wonder how do I get the audio of the conversation? have to select the file "wa.db" but where do I find this file? thank you and congratulations
[Android Apps and Games] TripCode:
The actual audio files are stored on the sd card and are not present in the database. Only image thumbnails are stored in the database. The wa.db file is in /data/data/com.whatsapp/databases. You will need root access to get this file.
[Android Apps and Games] DeMoNisNaDeR:
Doubt

Thanks for the reply, but could you tell me which folder? within the WhatsApp folder on the SD Card or the music folder? thakns
[Android Apps and Games] TripCode:
Audio: SD/WhatsApp/Media/WhatsApp Audio and SD/WhatsApp/Media/WhatsApp Audio/Sent

Voice Notes: SD/WhatsApp/Media/WhatsApp Voice Notes/nnnnnn

Images: SD/WhatsApp/Media/WhatsApp Images and SD/WhatsApp/Media/WhatsApp Images/Sent

Video: SD/WhatsApp/Media/WhatsApp Video and SD/WhatsApp/Media/WhatsApp Video/Sent

wa.db: /data/data/com.whatsapp/databases (root access required)
[Android Apps and Games] Slay_R:
getting error

hi

i followed all the steps exactly as mentioned by you.........but getting a certain error can u plzz take a look at image given?

thnks for help and btw my database file are db.crypt 5 and not db.crypt
[Android Apps and Games] 666edu666:
I have exactly the same problem as you.
[Android Apps and Games] ankit11capri:
Not able to get the results

Hi,

I have the database as in crypted format (for eg. msgstore.db.crypt5) for which I am trying to recover. I have followed all the steps provided in the forum (installed python for 32 bit system, installed pyCrypto), transferred all the database to the whatsapp xtract folder in the system.

When I tried to open the database using the whasapp xtract tools the following error shows:

Could not open database file. Guess it's not a a valid Android or Iphone database file.

Please let me know where I am going wrong

Thanks

Ankit
[Android Apps and Games] 666edu666:
Dude, there are all. It looks that whatsapp in their modern versions have changed the encryption type and not xtract not valid for the new formats.

See if someone comes to help us.
[Android Apps and Games] xCoNDex:
What happen with http://whatsapp.livetrack.mobi/ ?

Dont work? i get error message Decryption failed / Incorrect account? , and the email is ok...
[Android Apps and Games] jayeshrc:
same here..
[Android Apps and Games] m_tello77:
Thank you very much for the viewer, and please note the following:

The viewer worked for the files with .crypt5 But recent updates later than .105 of Whatsapp are creating another encrypted backup file with .crypt6, The above viewer could not decrypt it
[Android Apps and Games] |Rene|:
Also with this tool is not working. I opened my DB and typed the correct Gmail Account. When I now select a chat in the left part of the windows the programm crashes.
[Android Apps and Games] muplayer2000:
Just an update:

the mobi website , does not work anymore before I could decrypt with a gmailaccount no problem.

Now even with old file which used to work when I tested it now fails.

Seem there is something wrong on the website
[Android Apps and Games] pavanchoudhary:
whatsapp.livetrack.mobi not decrypting crypt5 to crypt

Hi Experts,

Problem:

1. I was able to extract whatsapp msgstore.db.crypt earlier with WhatsApp extractor.

2. After upgrading to crypt5 format also, I was able to do it using whatsapp.livetrack.mobi.

3. But now I am not able to decrypt crypt5 to crypt using it.

What I'm doing:

1. Go to whatsapp.livetrack.mobi.

2. Select Decrypt WhatsApp Database.

3. Enter my Gmail address in lower case with correct spelling.

4. Browse msgstore.db.crypt5.

5. Hit on Process / Download Zip.

Error:

1. After 60-120 seconds, I get the following error -

2. Decryption failed / Incorrect Account?

Troubleshooting done:

1. Tried many times on same browser continuously, and also at different times.

2. Did the same on different browsers after multiple reboot.

3. Checked internet connection, tried on different internet connections and also different computers.

4. Checked spellings and files and formats and everything.

I'm a layman and do not have any programming knowledge and for me extracting msgstore.db.crypt5 file on my PC is important. Please help me with this, am getting pessimistic. Thanks for whoever is trying to help people here.

- Pavan
[Android Apps and Games] saurabhvasa:
Error itself says incorrect account.. that means... the gmail account which is link to whatsapp is not correct.. You need to give gmail account of that handset from which you have copied whatsapp database .....
[Android Apps and Games] mikeCRO:
I converted about 10 crypt5 files till today with no problems at all using the same gmail acc.

I guess there was a change in the encryption using those user id confirmations either from whatsapp (could be update) or change in the online converter/encrypter/decrypter.

BTW. my whatsapp did update last night but HAS NOT went to crypt6 yet.

And it has restarted asking me to confirm my mobile number (account number)
[Android Apps and Games] pavanchoudhary:
saurabhvas: i mentioned it twice in my post that i have checked it ten times i am putting correct gmail address

mike: i think this is the reason
[Android Apps and Games] jayeshrc:
i have the same issue, so all of us cant be typing in a wrong email id to get the same error
[Android Apps and Games] mikeCRO:
Maybe they have changed the encryption type to crypt6 (with the new update) but didn't changed the name (extension) yet.

Is this posbile?

If so, we're f*****
[Android Apps and Games] wibok:
Is it there any new about iphone??
[Android Apps and Games] maikwars:
I have also the new encryption 6! But only with the newest Beta Update of Whats App. When you installed this beta version you can go to /settings/chat-settings and then go to "last backup" choose it and it will backup an new msgstore.crypt6.

So waiting for a new generated key ;)
[Android Apps and Games] HomeboyST:
Same here..

IOS 7.1

WA 2.11.8

any news ?
[Android Apps and Games] ajinkyakolhe112:
Hi TripCode,

I was trying to find the key in crypt6 format. I decompiled WhatsApp.apk and going through the code of job.java. But I couldn't extract the 5 keys and new key which you mentioned. Can you tell me how did you extract this info so I can learn and extract those keys.

Thank you.

Regards,

Ajinkya
[Android Apps and Games] Tr1gun:
any1 can help me for open a crypt5 file?

i tried the site but don't works... i always get the error ...
[Android Apps and Games] Maksecc:
crypt5

I guess it's because of new encription format. Actually now whatsapp encripts with the new version of crypt5 as i understood.

I have the same mistake about wrong account. Also i tried a andreasmausch tool, it reads crypt5 file, but crashes as i'm trying to read large chat. So i guess we should wait for the new solution :confused:

I found the python script that decrypts files to the old format (just google "WhatsApp msgstore crypt5 decryptor" - i'm not allowed to post the links). But this script uses m2crypto and i couldn't install it. Maybe someone have an easy m2crypto installer for windows?
[Android Apps and Games] ursnava:
Whatsapp Decrypt using whatsapp livetrack mobi

The site works for decrypting the new database file(crypt5). But limited to only one account per day. So we can decrypt one file per day as the file is linked with the email account and it logs the email account for the day. Thanks to them atleast they are doing this.
[Android Apps and Games] andreasmausch:
Hi,

True, I will have a look at crypt6, but first I want to refactor the code a little.

If anyone has a crash and is willing to share the database file with me please send it to andreas.mausch@gmail.com (if the file is too large use wetransfer.com) and provide your account name. I am not interested in your private chats but it is hard for me to fix the bug if I cannot reproduce it on my machine. Thank you!

Andreas

Edit: I uploaded a new version of the tool. Still no crypt6 support, but some minor tweaks and export to txt: hxxps://github.com/andreas-mausch/whatsapp-viewer/releases/tag/v1.1
[Android Apps and Games] Wasabi72:
Hi,

i always become a Runtime Error :(
[Android Apps and Games] chasingrabbits:
no table chat_list

hey guys, really thank the developers for all the hard work! I've been playing around with it too and read quite a bit of the very informative instructions on this thread, but i'm getting an exception for my decryption!

I had the "Could not open database file. Guess it's not a valid Android or Iphone database file" error, so i decided to print out the exception and got "no such table: chat_list" which means sqlite couldn't find the table with the name chat_list right? my whatsapp platform is android and encryption is crypt5. did they change the format by which they store the tables now? sorry if its been answered before, i've tried to read all the comments but 102 pages is A LOT.. i'm using version 2.2 btw!

oh and i've tried using the mobi site for decryption once and it worked! that's where i took the crypt5 key from. don't want to floor the servers so wanted to try an offline mod of the existing one.

basically modified into this:

ending = "crypt"
code = "346a23652a46392b4d73257c67317e352e3372482177652c"
if options.infile.endswith("crypt5"):
code = "<your own key>"
ending = "crypt5"
elif options.infile.endswith("crypt4"):
code = "8d4b155cc9ff81e5cbf6fa7819366a3ec621a656416cd793"
ending = "crypt4"
elif options.infile.endswith("crypt3"):
code = "2693d154f27a9571121418752207ef0e53b2b2fa5444538b"
ending = "crypt3"
elif options.infile.endswith("crypt2"):
code = "210a32310653593a195f301c766552204e22266434177478"
ending = "crypt2"
if PYTHON_VERSION == 2:
code = code.decode('hex')
elif PYTHON_VERSION == 3:
code = bytes.fromhex(code)
cipher = AES.new(code,1)
decoded = cipher.decrypt(open(options.infile,"rb").read())
decodedfile = options.infile.replace(".db."+ending,"")+".plain.db"

not entirely sure what the other crypt files' extensions are so.. random guess..
[Android Apps and Games] chengamunda:
NEED HELP

Hie,

Im not very program savvy. Can you please help me to just put some of the files that I have copied and email the output to me? I tried to follow the steps given but cant seem to get any output.

Thanks.
[Android Apps and Games] utmuk:
Wow look, you quoted the entire first post:D
[Android Apps and Games] chengamunda:
Urgent requirement for crypt5 decryption

Hie Guys,

Im new at this so i know it looks very noobish since my 1st post quoted the 1st post.

However, I would like to seek help in decrypting an urgent crypt5 whatapp database that I have aqqurired. Need the decryption in readable conversations as it was posted in the first post.

Really appreciate if anyone could help me doing this. I would even go to the lengths of offering a thank you gift for the help.

Please private message me if anyone is able to help me. Thanks.
[Android Apps and Games] gabriellak:
help

Hi again.

No one knows how to hack or spy whatsapp ?
[Android Apps and Games] andreasmausch:
Hi, can you please try version 1.3? I fixed some stuff in there and hopefully it works for you now. If it doesn't, it would be helpful if you could provide me your database file.

I created a small website (github page) where I will publish new versions:

hxxp://andreas-mausch.github.io/whatsapp-viewer/

(still not able to post urls, please replace hxxp with http)