Dear XDA-community!
I recently bought a `Nokia 8110 4G` (which runs `KaiOS` by default, which is based on `Firefox OS`) and flashed `GerdaOS` as an alternative (more free and secure) OS (see also `https://gerda.tech`). Some things work great, but some not so much. Specifically I'm able to see, that I received a short message (SMS), but unable to open it.
Therefore I downloaded the database containing the SMS (located at `/data/local/storage/permanent/chrome/idb/226660312ssm.sqlite`) using `adb pull` and am now trying to extract the SMS from the database so that I can read it on my PC. But I'm unable to understand the encoding.
Does anyone understand how to decode the SMS-database? What kind of encoding is used? Is there a tool to convert the content of the database to UTF-8 or something similar?
Any hints are welcome!
Related
Hello,
well i'm trying to save talkbox message in to a normal file type cus i wanna send it to my friend. i found out where the files are but they are. ilbc and i have no idea how to play/convert it.
Any suggestions?
Sent from my X10 using XDA App
Bump.....
Sent from my X10 using XDA App
TalkBox - how to get voice messages from iphone to pc
In order to copy voice messages created by talkbox app from your iOS device all you have to do is to gain access to your device file system with any free software (I used iExplorer ). acess your device and you will see at the root file system the directory User->Applications and there all you application data is stored - one of them is TalkBox (you will recognize it by enter every folder and check for the folder that finish with '.app' or see the icon of the application inside it). all the messages are in [talkbox-folder-id]->Documents->Audio at caf files (Core Audio Format). export it easily with your software to your pc. Cheers and Good Luck !
help
white-bear said:
In order to copy voice messages created by talkbox app from your iOS device all you have to do is to gain access to your device file system with any free software (I used iExplorer ). acess your device and you will see at the root file system the directory User->Applications and there all you application data is stored - one of them is TalkBox (you will recognize it by enter every folder and check for the folder that finish with '.app' or see the icon of the application inside it). all the messages are in [talkbox-folder-id]->Documents->Audio at caf files (Core Audio Format). export it easily with your software to your pc. Cheers and Good Luck !
Click to expand...
Click to collapse
Hi
This all sounds really good as i have a deceased friend and wanting desperately to switch / access / back up talk box voice messages between my devices.
All was stored on my samsung galaxy s3 and now i have an s5 things are proving a little tricky so could you please brake down these instructions for me so i can successfully access them from the root.
I can access them in the device but only in the .ilbc format..
Thanks in advance
Hi,
I'm trying to create a desktop (java based) application that extracts SMS from an android device and prints the SMS onto a relational database. I just have a few questions......
/*Answer Found*/
After research I found out that the SMS are stored in a database. I've been pointed in various directions, but the most common is directory is com.android.provider.telephony.SMS although I can't actually find it on my phone. My phone is rooted and I'm looking for the file using a "File manager" app from the Play store.
So my first question would be "Where is the SMS database stored"? I'm assuming it's the same place for all phones as long as it's android based. Please correct me if I'm wrong......
I'm aware the database will be encrypted. Does anyone know what type of encryption is on the database, and if so - is it easy to crack?
Thanks in advance,
Wazza
Update: OK - So it turns out the file explorer I was using was a bit......naff. I've downloaded another and am now able to see the relevant DB.
My idea was to run the developers USB debugging mode onto the computer and extract the DB like that - However, the folders / files being shown when it's plugged into the PC are those on the SDCARD. (I believe this is the level above root?).
Update 2: Seems as if I jumped the gun posting this topic. A few more hours research and I've got to where I need to be.
For those who don't know - this is how I did it.
Plugging your phone into the PC and selecting USB Debugging mode temporarily disables the "SDCARD" on your phone so you can't tamper with it whilst uploading files via the PC.
I downloaded a file manager that allows the user to view root access files / folders. I then found the mmssms.db, copied it and pasted it into a folder on the "SDCARD". I was then able to plug the phone into USB Debugging mode and transfer the database file from the phone onto my desktop.
My next challenge is viewing the database. As started in the OP, I'm aware the database is most likely encrypted. How would I go about breaking this encryption and viewing it on a database.
:good:
If you want to make backup of SMS, just use SMS Backup & Restore. It will export your database to xml file.
przemcio510 said:
If you want to make backup of SMS, just use SMS Backup & Restore. It will export your database to xml file.
Click to expand...
Click to collapse
Thanks przemcio but I'm doing it as a project. I don't want the easy way around
I need to programmatically transfer some files from one Android device to another via a Bluetooth connection. The devices will have been paired already and in close range. This isn't for something that will be for public consumption. It's for use between two devices under the permanent control of a company for use only within the company. One device (the sending device) will have an app that we'll write that calls for user input. Once the user choices are made and submitted, the sending device will send a file or files (probably text files that we'll create dynamically) to a specific path on the receiving device via that Bluetooth connection.
Both devices will probably be rooted, certainly the receiving device will be. But we'll write to a directory on /sdcard, not at the root level. It's likely that the OS will be 4.1.2 or later on both. It'll be 4.2.2 on the receiving device for sure.
I can execute this file transfer easily with something like ES File Explorer. But that won't work in the application that I'm developing because the users can't handle that sort of interactivity and wouldn't have the knowledge to create or choose the files to transfer if they could. They'll need the aforementioned app with the form to make this appropriately simple.
My question is: can I write an app that lets me transfer files via Bluetooth from one device to a specific path on another, without security issues on the receiving device stopping the transfer from successfully taking place? I'm figuring that if ES File Explorer and the like can do it, that I should be able to do it using the Android API. But I'm not clear on that, so better to ask than to have to tell my client after doing a bunch of work.
Any help would be appreciated.
I've seen some threads about accessing the WhatsApp messages backup database files on iPhone, Android and older Windows Phone versions (7.x). However, none of the methods seem to be compatible with the WhatsApp messages backup database file found on Windows Phone 8.1. I am looking for a way to either extract/decrypt or restore an older messages backup database. Tried so far:
- Place messages.db file on SD card and reinstall WhatsApp. WhatsApp does NOT find the backup on installation. It only restores the most recent chats (not the ones from the backup file)
- Tried available tools for iPhone/Android (Python scripts with crypto 5/7/8). Database format is incompatible
- Tried opening the database file directly in Microsoft Access, SQLite Browser. Unrecognized file format
- Tried the Zune/WP Device Manager approach. Seems to work only with Windows Phone 7.x, Windows Phone 8 is not seen by the tool
- Tried Windows Phone Power Tools to access Isolated Storage for the WhatsApp app, but access to an apps isolated storage is not possible in Windows Phone 8 anymore.
- Tried the WhatsApp Xtractor, but it contains the same iPhone/Android python scripts that don't work with the Windows Phone version
- Even tried asking WhatsApp support directly, but they have not given any response yet
Can any WhatsApp / encryption wizard please help me out. I am more than willing to reward/tip you for it if the solution works!
i have the same problem ,pls pls pls tell me about the solution thx
Given that you already enabled full FS access on your phone or have control over an app wich has the ID_CAP_OEMPUBLICDIRECTORY capability, you can extract the unencrypted sqlite database from C:\Data\SharedData\OEM\Public\WhatsApp.
The structure of the database is quite complex (I suppose it grew over the years), but not too hard to understand.
However, I have no experience in using this mechanism as a backup/restore solution.
Source: blackhat . com/docs/ldn-15/materials/london-15-DeFulgentis-Witchcraft-For-Windows-Phone-Breakers.pdf page 68f
Sorry for broken link, I'm a new member.
I realize this is a pity, I want the Microsoft support seriously and updating applications
If you do not want to unlock / flash your phone in order to enable the full FS unlock, you can try the hack as shown in the Blackhat slides posted above.
It works by replacing an apps' core files with your own, but keeping the capability restrictions of the original app. (Use http://forum.xda-developers.com/win...p-customwpsystem-patch-xaps-wpsystem-t2975419 for example)
So just target an app with ID_CAP_OEMPUBLICDIRECTORY, deploy your custom payload and use it to copy the WhatsApp files somewhere.
Given the full FS access, is there any way to access the Whatsapp key file like on Android. That's what you would need to access the backup files instead of the unencrypted current message database, which is easily opened as SQLite database?
Hello ... I'm new here ... just wondering if there is any answer to this question ... I know it's not a recent discussion, but I really need some help from you guys. I have a wp where whatsapp is installed, but it's asking for verification and I dont have no more the sim card related to that account ... I saw chats, but then I made a huge mistake (opened whatsapp while I was online) and now I cannot access to those anymore ... I have messages.db but I'm unable to retrieve the key to decrypt that ... there are tons of posts about similar issue on android or IOS, but I need the same for WP ... is it something someone can drive me through? Thanks a lot in advance
If your phone has the Full-FS-Unlock enabled you can get the unencrypted databases at C:\Data\Users\DefApps\APPDATA\Local\Packages\5319275A.WhatsApp_cv1g1gvanyjgm\LocalState (or similar package name).
Or you can get unencrypted backups from C:\Data\SharedData\OEM\Public\WhatsApp
Or you can use a interop-unlocked File Manager App
jumpz said:
If your phone has the Full-FS-Unlock enabled you can get the unencrypted databases at C:\Data\Users\DefApps\APPDATA\Local\Packages\5319275A.WhatsApp_cv1g1gvanyjgm\LocalState (or similar package name).
Or you can get unencrypted backups from C:\Data\SharedData\OEM\Public\WhatsApp
Or you can use a interop-unlocked File Manager App
Click to expand...
Click to collapse
The files in C:\Data\SharedData\OEM\Public\WhatsApp seem to be encrypted as well … Or can you just not open them with a standard SQLite viewer?
weaselmc said:
The files in C:\Data\SharedData\OEM\Public\WhatsApp seem to be encrypted as well … Or can you just not open them with a standard SQLite viewer?
Click to expand...
Click to collapse
No, these files are indeed encrypted.
The winwazzapmigrator software did a good job migrating my database to a new android phone.
Tool to access file system on Windows 8.1 mobile
jumpz said:
If your phone has the Full-FS-Unlock enabled you can get the unencrypted databases at C:\Data\Users\DefApps\APPDATA\Local\Packages\5319275A.WhatsApp_cv1g1gvanyjgm\LocalState (or similar package name).
Or you can get unencrypted backups from C:\Data\SharedData\OEM\Public\WhatsApp
Or you can use a interop-unlocked File Manager App
Click to expand...
Click to collapse
Can anyone help me with a tool to access the file system where app files are stored on a windows 8.1 mobile?
me too
PritiM said:
Can anyone help me with a tool to access the file system where app files are stored on a windows 8.1 mobile?
Click to expand...
Click to collapse
I do have the same request...
Hey there guys. I am currently trying to retrieve whatsapp conversations from one of my older phones, a Huawei Ascend G510. However, the thing is that when I found the phone, Whatsapp was already asking to verify my phone number, and I don't have the old number nor the old SIM card anymore, my brother also updated whatsapp to the newest version, thinking this would somehow help, needless to say that now when I open Whatsapp it just asks to verify my number, which I don't have anymore. However I managed to find the original crypt7 files, dated all the way back to 2014, I managed to root the device in order to search for the key file, but the thing is I cannot find it anywhere.
Strangely enough, the folder data/data/com.whatsapp contains only these folders:
- app_Keys (made in 2013, but is empty);
- app_minidumps (empty);
- cache;
- code_cache;
- databases (another old folder, containing _jobqueue-WhatsAppJobManager, _jobqueue-WhatsAppJobManager-journal, axolotl.db, axolotl.db-shm, axolotl.db-wal, google_app_measurement_local.db, google_app_measurement_local.db-journal, wa.db, wa.db-shm, and wa.db-wal);
- files;
- lib;
- no-backup;
- shared_prefs.
None of them contain a key file. I read some threads here in the forums, everybody was saying that without the key file, the crypt7 backups are useless. However, I thought that I should also check it with the SQLite Editor app. And surprise. It opened the crypt7 backups. The SQLite Editor opened the conversations, the only problem being that instead of a date it's just an unintelligible timestamp. However, this lead me to believe that the key file must be in there somewhere, otherwise the SQLite Editor couldn't have opened the backups. Does anyone know how can I find it, where could it be, so I can decrypt the backups and be able to read the conversations properly, with a date and time on the messagges? Thank you.