Methodology, Mobile Devices

How To Decrypt WeChat EnMicroMsg.db Database?

WeChat is a smartphone application where users can chat with their friends, share pictures, videos and audio chats. Users can also make free video calls and voice calls with their friends as long as they have Internet connection.

Recently, we received a request from the law enforcement agency to extract WeChat chat messages from an Android mobile phone.

Although this mobile phone model is supported by XRY (a mobile phone forensics tool), but it could not extract the WeChat chat messages. Only Whatsapp, and other text messages were successfully extracted.

We have also conducted keyword search using EnCase, but to no avail. Although we can see the chat messages directly from the mobile phone display, EnCase still cannot find the keyword that we searched for.

EnMicroMsg-01Figure 1: The encrypted data in EnMicroMsg.db

However, during the analysis in EnCase, we found a .DB file named, EnMicroMsg.db in the WeChat application folder. This file size is about 3.7MB.

This curiosity leads us to conduct a research on the Internet and we found that the file is an encrypted SQLite database file for WeChat chat messages.

EnMicroMsg.db and SQLCipher

EnMicroMsg.db is an encrypted SQLite database file that contains the WeChat chat messages. This file is encrypted using SQLCipher, an open source extension for SQLite database that provides transparent 256-bit AES encryption of database files.

EnMicroMsg-02Figure 2: Parameters to decrypt EnMicroMsg.db file

Below are the parameters needed to encrypt and decrypt the data in the EnMicroMsg.db file.

  • PRAGMA key = KEY;
  • PRAGMA cipher_use_hmac = off;
  • PRAGMA cipher_page_size = 1024;
  • PRAGMA kdf_iter = 4000;

The simple explanations for these parameters are described below:

  • PRAGMA key – Set the key to use with the database.
  • PRAGMA cipher_use_hmac – Disable the usage of per-page HMAC checks for backwards compatibility with SQLCipher 1.1.x on a specific database.
  • PRAGMA cipher_page_size – Alter the page size used for the database from the default of 1024 bytes to improve performance for some query types.
  • PRAGMA kdf_iter – Change the number of iterations used with PBKDF2 key derivation.

Kindly go to SQLCipher API page for a better understanding about these parameters and their usage in SQLCipher.

KEY to decrypt EnMicroMsg.db

KEY is the most important parameter to decrypt the EnMicroMsg.db file. This KEY is generated from the MD5 hash, combination of IMEI and UIN (a unique identifier of the WeChat user). However, only the first 7-characters of the MD5 hash will be used as the KEY to decrypt it.

EnMicroMsg-03

Figure 3: The process to generate the KEY

IMEI is the 15-digits unique number that you can usually get at the back of the mobile phone. Or you can enter *#06# to get the mobile phone IMEI number.

UIN is the unique identifier that you can get from the system_config_prefs.xml file in the WeChat application folder.

EnMicroMsg-04Figure 4: Example to generate the KEY

In short, the KEY generation can be summarized as follows:

KEY = MD5( IMEI + UIN )[ 0:7 ]

For an example, the IMEI number for the mobile phone is, 357725678854269 and the UIN number which you get from system_config_prefs.xml file is, -1881034049.

  • IMEI: 357725678854269
  • UIN: -1881034049

So the MD5 hash value for these IMEI and UIN is, 4bc36a03296a8b4fc63e5bb8e74db2a2

Therefore the KEY to decrypt EnMicroMsg.db is, 4bc36a0.

Python script, fmd_wechatdecipher.py

To make it easier for you to decrypt this file, we have wrote a Python script, fmd_wechatdecipher.py, which you can use it in your lab.

This script runs on Python and you need to install an additional package, pysqlcipher. Pysqlcipher will allows you to use SQLCipher function in Python.

EnMicroMsg-05

Figure 5: Input and Output for fmd_wechatdecipher.py script

Before you can use this script, there are several things that you need to know about fmd_wechatdecipher.py.

This script requires two input files and one input from the user.

The Input Files are:

  • EnMicroMsg.db – The WeChat database file that contains the encrypted chat messages.
  • system_config_prefs.xml – The WeChat file that contains the UIN number.

The Input that you need to enter:

  • IMEI – The 15-digits IMEI number of the mobile phone

And the Output Files after you executed the script:

  • EnMicroMsg-decrypted.db – Decrypted database file that contains WeChat chat messages.
  • EnMicroMsg-decrypted.log – Log file that contains all information to decrypt the file such as IMEI, UIN, and KEY. It also includes with the MD5 and SHA1 hash values for EnMicroMsg-decrypted.db file.

How to use the script?

In order to use this script, you must put all the Input Files in the same folder with the Python script.

When the script prompts you to enter the IMEI number, just enter the correct IMEI number and it will generate the KEY and decrypt EnMicroMsg.db file automatically.

EnMicroMsg-06

Figure 6: The decrypted data stored in EnMicroMsg-decrypted.db

Once the process is done, you will see two files are generated, EnMicroMsg-decrypted.db and EnMicroMsg-decrypted.log, in the same folder.

All the encrypted WeChat chat messages have been decrypted and are stored in the EnMicroMsg-decrypted.db file. You can extract the chat messages by using your favourite SQLite Browser to analyze this file.

References

About Fauzi Mohd Darus

Fauzi is currently the Operations Manager in Digital Forensics Department, CyberSecurity Malaysia and has been working in digital forensics field since 2008. His specialization and expertise are Internet, Blog and Social Media Forensics.

Discussion

One thought on “How To Decrypt WeChat EnMicroMsg.db Database?

  1. some other reports say the messages are in a file called MM.sqlite

    Posted by nfo | December 3, 2016, 12:45 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 995 other followers

%d bloggers like this: