Get all messages from Whatsapp

Question

I m trying to implement an app that will show in a textview all the messages received from Whatsapp  Is there any way to do it  Is it possible to extract all the messages from Whatsapp

User · Answer

Edit

As WhatsApp put some effort into improving their encryption system, getting the data is not that easy anymore. With newer versions of WhatsApp it is no longer possible to use adb backup. Apps can deny backups and the WhatsApp client does that. If you happen to have a rooted phone, you can use a root shell to get the unencrypted database file.

If you do not have root, you can still decrypt the data if you have an old WhatsApp APK. Find a version that still allows backups. Then you can make a backup of the app's data folder, which will contain an encryption key named, well, key.

Now you'll need the encrypted database. Use a file explorer of your choice or, if you like the command line more, use adb:

adb pull /sdcard/WhatsApp/Databases/msgstore.db.crypt12

Using the two files, you could now use https://gitlab.com/digitalinternals/whatsapp-crypt12 to get the plain text database. It is no longer possible to use Linux board tools like openssl because WhatsApp seems to use a modified version of the Spongy Castle API for cryptography that openssl does not understand.

Original Answer (only for the old crypt7)

As whatsapp is now using the crypt7 format, it is not that easy to get and decrypt the database anymore. There is a working approach using ADB and USB debugging.

You can either get the encryption keys via ADB and decrypt the message database stored on /sdcard, or you just get the plain version of the database via ADB backup, what seems to be the easier option.

To get the database, do the following:

Connect your Android phone to your computer. Now run

adb backup -f whatsapp_backup.ab -noapk com.whatsapp

to backup all files WhatsApp has created in its private folder.
You will get a zlib compressed file using tar format with some ADB headers. We need to get rid of those headers first as they confuse the decompression command:

dd if=whatsapp_backup.ab ibs=1 skip=24 of=whatsapp_backup.ab.nohdr

The file can now be decompressed:

cat whatsapp_backup.ab.nohdr | python -c "import zlib,sys;sys.stdout.write(zlib.decompress(sys.stdin.read()))" 1> whatsapp_backup.tar

This command runs Python and decompresses the file using zlib to whatsapp_backup.tar
Now we can unTAR the file:

tar xf whatsapp_backup.tar

The archive is now extracted to your current working directory and you can find the databases (msgstore.db and wa.db) in apps/com.whatsapp/db/

User · Answer

If you really want something simple and know how to write run Python  take a look at the script Bas Bosschert  sources     usr bin env python  import sys from Crypto Cipher import AES  try      wafile sys argv 1  except      print  Usage   s  lt msgstore db crypt gt       file       sys exit 1   key    346a23652a46392b4d73257c67317e352e3372482177652c  decode  hex   cipher   AES new key 1  open  msgstore db   wb   write cipher decrypt open wafile  rb   read       Full run    scratch ehtesh ackee  tmp whatsapp  mkvirtualenv whatsapp decrypt New python executable in whatsapp decrypt bin python Installing setuptools  pip   done   whatsapp decrypt ehtesh ackee  tmp whatsapp  pip install pycrypto  gt  dev null  whatsapp decrypt ehtesh ackee  tmp whatsapp  wget https   gist githubusercontent com shurane ffa15e959e2d134086c9 raw bc99a9997123bea0ea0acde185e24c7e89133559 whatsapp decrypt py  gt  dev null  whatsapp decrypt ehtesh ackee  tmp whatsapp  ls msgstore db crypt  whatsapp decrypt py  whatsapp decrypt ehtesh ackee  tmp whatsapp  python whatsapp decrypt py msgstore db crypt  whatsapp decrypt ehtesh ackee  tmp whatsapp  ls msgstore db crypt  msgstore db  whatsapp decrypt py  whatsapp decrypt ehtesh ackee  tmp whatsapp  sqlite3 msgstore db SQLite version 3 7 17 2013-05-20 00 56 22 Enter   help  for instructions Enter SQL statements terminated with a     sqlite gt  PRAGMA table info messages   0  id INTEGER 0  1 1 key remote jid TEXT 1  0 2 key from me INTEGER 0  0 3 key id TEXT 1  0 4 status INTEGER 0  0 5 needs push INTEGER 0  0 6 data TEXT 0  0 7 timestamp INTEGER 0  0 8 media url TEXT 0  0 9 media mime type TEXT 0  0 10 media wa type TEXT 0  0 11 media size INTEGER 0  0 12 media name TEXT 0  0 13 media hash TEXT 0  0 14 media duration INTEGER 0  0 15 origin INTEGER 0  0 16 latitude REAL 0  0 17 longitude REAL 0  0 18 thumb image TEXT 0  0 19 remote resource TEXT 0  0 20 received timestamp INTEGER 0  0 21 send timestamp INTEGER 0  0 22 receipt server timestamp INTEGER 0  0 23 receipt device timestamp INTEGER 0  0 24 raw data BLOB 0  0 25 recipient count INTEGER 0  0 sqlite gt    Pritam Baral has mentioned an even simpler way   openssl aes-192-ecb -d -in msgstore db crypt -out msgstore db -K 346a23652a46392b4d73257c67317e352e3372482177652c

User · Answer

Whatsapp store all messages in an encrypted database  pyCrypt  which is very easy to decipher using Python   You can fetch this database easily on Android  iPhone  Blackberry and dump it into html file  Here are complete instructions  Read  Extract WhatsApp Messages backup on Android  iPhone  Blackberry   Disclaimer  I researched and wrote this extensive guide

User · Answer

You can get access to the WhatsApp data base located on the SD card only as a root user I think   if you open   data data com whatsapp   you will see that   databases  is linked to   firstboot sqlite com whatsapp

User · Answer

Working Android Code    No root required  Once you have access to the dbcrypt5 file   here is the android code to decrypt it  private byte   key      byte  141  75  21  92   byte  201   byte  255           byte  129   byte  229   byte  203   byte  246   byte  250  120          25  54  106  62   byte  198  33   byte  166  86  65  108           byte  215   byte  147     private final byte   iv     0x1E  0x39   byte  0xF3  0x69   byte  0xE9  0xD           byte  0xB3  0x3A   byte  0xA7  0x3B  0x44  0x2B   byte  0xBB           byte  0xB6   byte  0xB0   byte  0xB9       long start   System currentTimeMillis            create paths     backupPath   Environment getExternalStorageDirectory                getAbsolutePath      quot  WhatsApp Databases msgstore db crypt5 quot       outputPath   Environment getExternalStorageDirectory                getAbsolutePath      quot  WhatsApp Databases msgstore db decrypt quot        File backup   new File backupPath           check if file exists   is accessible     if   backup isFile              Log e TAG   quot Backup file not found  Path   quot    backupPath           return                acquire account name     AccountManager manager   AccountManager get this       Account   accounts   manager getAccountsByType  quot com google quot         if  accounts length    0            Log e TAG   quot Unable to fetch account  quot            return             String account   accounts 0  name       try              calculate md5 hash over account name         MessageDigest message   MessageDigest getInstance  quot MD5 quot            message update account getBytes             byte   md5   message digest                generate key for decryption         for  int i   0  i  lt  24  i                key i     md5 i  amp  0xF               read encrypted byte stream         byte   data   new byte  int  backup length             DataInputStream reader   new DataInputStream new FileInputStream                  backup            reader readFully data           reader close                create output writer         File output   new File outputPath           DataOutputStream writer   new DataOutputStream                  new FileOutputStream output                decrypt file         Cipher cipher   Cipher getInstance  quot AES CBC PKCS5Padding quot            SecretKeySpec secret   new SecretKeySpec key   quot AES quot            IvParameterSpec vector   new IvParameterSpec iv           cipher init Cipher DECRYPT MODE  secret  vector           writer write cipher update data            writer write cipher doFinal             writer close          catch  NoSuchAlgorithmException e            Log e TAG   quot Could not acquire hash algorithm  quot   e           return        catch  IOException e            Log e TAG   quot Error accessing file  quot   e           return        catch  Exception e            Log e TAG   quot Something went wrong during the encryption  quot   e           return             long end   System currentTimeMillis         Log i TAG   quot Success  It took  quot     end - start     quot ms quot

User · Answer

For rooted users  whats app store all message and contacts in msgstore db and wa db files in plain text These files are available in  data data com whatsapp databases   you can open these files using any sqlite browser like SQLite Database Browser

User · Answer

I m not sure if WhatsApp really stores it s stuff in a sqlite database stored in the private app space but it may be worth a try to do the same I suggested here  You will need root access for this

User · Answer

Yes  it must be ways to get msgs from WhatsApp  since there are some tools available on the market help WhatsApp users to backup WhatsApp chat history to their computer  I know this from here  Therefore  you must be able to implement such kind of app  Maybe you can find these tool on the market to see how they work

[android] Get all messages from Whatsapp

Edit

Original Answer (only for the old crypt7)

Examples related to android

Examples related to encryption

Examples related to message

Examples related to whatsapp

Examples related to inbox