FORUMS
Remove All Ads from XDA

[TOOL] Whatsapp Xtract: Backup Messages Extractor / Database Analyzer / Chat-Backup

207 posts
Thanks Meter: 286
 
By ztedd, Senior Member on 5th April 2012, 07:13 AM
Post Reply Email Thread
30th April 2012, 11:07 AM |#61  
Junior Member
Thanks Meter: 0
 
More
i have tried in Windows 7 (both 32 and 64 bits) and in an old XP machine.


here you have the screenshots.

Thanks for your time and patience
Attached Thumbnails
Click image for larger version

Name:	1.jpg
Views:	3146
Size:	30.5 KB
ID:	1032432   Click image for larger version

Name:	2.jpg
Views:	3152
Size:	40.4 KB
ID:	1032433   Click image for larger version

Name:	3.jpg
Views:	2780
Size:	30.8 KB
ID:	1032434  
 
 
30th April 2012, 11:18 AM |#62  
Member
Flag Hechtel-Eksel
Thanks Meter: 4
 
More
I'm sorry but I'm afraid it's still not working:
Attached Thumbnails
Click image for larger version

Name:	Clipboard01.jpg
Views:	1578
Size:	177.1 KB
ID:	1032453  
30th April 2012, 11:45 AM |#63  
OP Senior Member
Thanks Meter: 286
 
More
Question Include Blackberry Whatsapp support (messagestore.db)?
Quote:
Originally Posted by valek07

First of all I would like to say that it works great! I was able to see everything from the msgstore.db.crypt file from my Galaxy Note!
Thanks a bunch and congrats on this excellent app!

Thanks!
Quote:
Originally Posted by valek07

Is there any way of opening the messagestore.db file that is used for Whatsapp on Blackberry? I had a BB Bold before and I need to check something from that history. I have the messagestore.db file

In general, this would be an interesting enhancement. Can you tell me how you got the messagestore.db file?

Please download and install SQLite Database Browser : http://sqlitebrowser.sourceforge.net/

Open your messagestore.db file with it - does it work? What do you see?

If the file can be opened with SQLite Database Browser, then generally it also can be converted like the Android or Iphone files. However, the database structure is different for each platform. So it would be necessary to adopt the code.

Google gave me these links:
http://gkfy.com/2012760/open-whatsapp-database-files/
https://code.google.com/p/linuxsleut.../bbwhatsapp.py

You may download and try that python script (bbwhatsapp.py) with your messagestore.db database file. Please tell me if it works.

However that scripts seems to be rather basic. It does not much more than you could achieve by opening the db file with SQLite Database Browser and exporting it to Excel CSV using File - Export.

Theoretically, if this all works (and the messagestore.db file is not encrypted using the strong Blackberry encryption) we could include the support for this as well. But we would need a sample blackberry database for this.
So if you could send us your messagestore.db file, it should be possible.


CREATING A SAMPLE DATABASE:

You may also create a new blackberry sample database by reinstalling the blackberry whatsapp and then sending some test messages.
Ideally, these should include:
Quote:

- group chat
- changing of group name
- all possible types of media messages:
- image
- video
- audio
- vcard (contact)
- gps
- gps of specific place (e.g. a restaurant)

Also a copy of the corresponding media files in the Media folder would be great.

Also you can use SQLite Database Browser to anonymize your database file by modifying/deleting sensitive information.
The Following User Says Thank You to ztedd For This Useful Post: [ View ] Gift ztedd Ad-Free
30th April 2012, 12:10 PM |#64  
OP Senior Member
Thanks Meter: 286
 
More
Quote:
Originally Posted by Mayn

I'm sorry but I'm afraid it's still not working:
error in line 1175: No such file or directory: 'N/A.html'

I updated the file again, see first post.

But I guess you will somehow get a result file with completely empty messages :/
Not sure what exactly fails there.

Maybe your Iphone database file uses a changed structure in comparison to the sample iphone database I used while coding. Maybe we only could solve this problem if you can send me your db file or post screenshots of the Database structure using SQLite Database Browser. (open all "+" and make screenshots of the database structure of each table like ZWACHATSESSION etc.)

Update: I found the error. Stay tuned, I fix it!
Update: fixed error of handling timestamps in Iphone database. see link in first post.
30th April 2012, 12:10 PM |#65  
Junior Member
Thanks Meter: 0
 
More
i´ve installed python Oo
when I start the install pyCrypto.bat the following window appears:
Attached Thumbnails
Click image for larger version

Name:	test .jpg
Views:	1470
Size:	46.5 KB
ID:	1032502  
30th April 2012, 12:15 PM |#66  
OP Senior Member
Thanks Meter: 286
 
More
Question
Quote:
Originally Posted by Ripper_X

here you have the screenshots.
Thanks for your time and patience

I don't get this... manually importing AES works but when called from inside the script, it fails??!

Can you please do this:
- run "whatsapp_xtract_console.bat" inside the folder of this script
- there type: pypm show pycrypto
- make a screenshot
- then type: python
- type: from Crypto.Cipher import AES
- type: import os
- type: os.system("whatsapp_xtract.py -i msgstore.db.crypt")
- make a screenshot
30th April 2012, 12:21 PM |#67  
OP Senior Member
Thanks Meter: 286
 
More
Exclamation
Quote:
Originally Posted by gu1lty

i´ve installed python Oo
when I start the install pyCrypto.bat the following window appears:
Der Befehl "pypm" ist entweder falsch geschrieben..
(error: the command "pypm" is not known / incorrectly written)

Du hast Python installiert, müsstest aber ActivePython installieren! Siehe im Readme / Howto im Punkt 4:
Quote:

You need Python and (for Android msgstore.db.crypt decryption) the PyCrypto library

The easiest way is to install ActivePython (on Windows choose 32bit version even if you have 64bit windows):
http://www.activestate.com/activepython/downloads


and then (for PyCrypto) run install pyCrypto.bat (contained in this archive)
(pyCrypto.bat will execute: pypm install pycrypto)

30th April 2012, 12:43 PM |#68  
Junior Member
Thanks Meter: 0
 
More
yay deutsch
ehm ich hab auf der seite active python die 32bit version geladen und installiert, dennoch kommt die gleiche meldung beim ausführen der datei :\
30th April 2012, 12:44 PM |#69  
Junior Member
Thanks Meter: 0
 
More
Thumbs up
Quote:
Originally Posted by ztedd

Thanks!

In general, this would be an interesting enhancement. Can you tell me how you got the messagestore.db file?

It is simply in the whatsapp directory on the micro sd card.


Quote:
Originally Posted by ztedd



Open your messagestore.db file with it - does it work? What do you see?

Hi Ztedd, the blackberry messagestore is encrypted. I have tried the python script below but just returns with error: sqlite3.databaseError: File is encrypted or is not a database.

Quote:
Originally Posted by ztedd

Google gave me these links:
gkfy.com/2012760/open-whatsapp-database-files
code.google.com/p/linuxsleuthing/source/browse/blackberry_tools/bbwhatsapp.py

Unfortunately I can not supply you with a sample database, for this I apologise.
Carry on the good work
30th April 2012, 12:56 PM |#70  
Junior Member
Thanks Meter: 0
 
More
And here it is the screenshot with the process
Attached Thumbnails
Click image for larger version

Name:	1.jpg
Views:	2684
Size:	115.3 KB
ID:	1032544  
30th April 2012, 01:17 PM |#71  
OP Senior Member
Thanks Meter: 286
 
More
Quote:
Originally Posted by gu1lty

yay deutsch


Quote:
Originally Posted by gu1lty

ehm ich hab auf der seite active python die 32bit version geladen und installiert, dennoch kommt die gleiche meldung beim ausführen der datei :\

Hast du bei der Installation alle diese Optionen gewählt?


Insbesondere "register as Default Python" ist wohl notwendig damit er pypm findet.

Du kannst es aber auch so machen:

Startmenü - ActiveState ActivePython - Python Package Manager (PyPM)
aufrufen

Dann eingeben:
pypm install pycrypto

danach ggf.:
pypm show pycrypto

Falls es nicht klappt, mach wieder nen Screenshot
Attached Thumbnails
Click image for larger version

Name:	options during install of ActivePython.png
Views:	116757
Size:	36.7 KB
ID:	1032582  
Post Reply Subscribe to Thread

Guest Quick Reply (no urls or BBcode)
Message:
Previous Thread Next Thread
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes