How To Decrypt WeChat EnMicroMsg.db Database?
原文地址:http://articles.forensicfocus.com/2014/10/01/decrypt-wechat-enmicromsgdb-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.
Figure 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.
Figure 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 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.dbKEY 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.
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.
Figure 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 fromsystem_config_prefs.xml file is, -1881034049.
IMEI: 357725678854269 UIN: -1881034049So the MD5 hash value for these IMEI and UIN is, 4bc36a03296a8b4fc63e5bb8e74db2a2
Therefore the KEY to decrypt EnMicroMsg.db is, 4bc36a0.
Python script, fmd_wechatdecipher.pyTo 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.
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:
IMEI – The 15-digits IMEI number of the mobile phone
And the Output Files after you executed the script:
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 decryptEnMicroMsg.db file automatically.
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相关文章
- Azure sql database 经过一段时间后就中断连接
- drop database出现1010
- 使用SolarWinds Database Performance Analyzer查找,分析和优化SQL Server性能
- Creating Dynamic T-SQL to Move a SQL Server Database
- How To Kill All SPID In Database or Multiple Databases In Sql Server
- Logging - MVC Using Log4net Save to File and Database
- Driver is connected to the database that does not support driver reactive API. In order to use the driver reactive API, please upgrade to neo4j 4.0.0 or later.
- Spring Boot + Jasper Report + MySQL Database Example
- Database Design for Sexbale Forum
- Code First to an Existing Database
- Ubuntu-16.04.6 安装 oracle 12.2.0.1 数据库database软件
- Mysql - 解决Access denied for user ''@'localhost' to database 'mysql'问题
- mysql: see all open connections to a given database?
- Using UTL_DBWS to Make a Database 11g Callout to a Document Style Web Service
- 药物数据库 | DrugBank | Therapeutic target database
- Could not update Activiti database schema: unknown version from database: '5.20.0.1'
- [解决] Error Code: 1044. Access denied for user 'root'@'%' to database
- ORA-38760: This database instance failed to turn on flashback database
- Instance database dbid sid tnsname等概念混个眼熟