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-01
Figure 1:
The encrypted data in EnMicroMsg.db


Get The Latest DFIR News

Join the Forensic Focus newsletter for the best DFIR articles in your inbox every month.


Unsubscribe any time. We respect your privacy - read our privacy policy.

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

  • http://blog.emaze.net/2013/09/a-look-at-wechat-security.html
  • https://www.zetetic.net/sqlcipher/sqlcipher-api
  • https://pypi.python.org/pypi/pysqlcipher
  • https://gist.github.com/scturtle/7248017

7 thoughts on “How To Decrypt WeChat EnMicroMsg.db Database?”

  1. This is an interesting article. How might it be applied to wechat backup files stored on a PC? I presume they use a similar sort of encryption. But since they can be restored to a different phone than the one being backed up, it’s unlikely the IMEI will be part of the encryption key. Have you done any research to see how to decrypt these?

  2. Firstly, thank you for the great article. I actually have a backup file from my old wechat account that I’ve deleted.For instance, files like BAK_0_TEXT, BAK_0_MEDIA. Is there any way I can decrypt this files as it contains important informations for me.

Leave a Comment

Latest Videos

Digital Forensics News Round Up, March 27 2024 #dfir #digitalforensics

Forensic Focus 22 hours ago

Digital Forensics News Round-Up, March 21 2024 #digitalforensics #dfir

Forensic Focus 21st March 2024 6:15 pm

This error message is only visible to WordPress admins

Important: No API Key Entered.

Many features are not available without adding an API Key. Please go to the YouTube Feeds settings page to add an API key after following these instructions.

Latest Articles