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

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

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

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

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

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

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

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

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

[android] Get all messages from Whatsapp

Examples related to android

Examples related to encryption

Examples related to message

Examples related to whatsapp

Examples related to inbox