[Q] use calendar.db in win7 - Android Q&A, Help & Troubleshooting

Hi, all
I am a android noob and also new on this forum.
I would like to self-host my synchronizable agendas.
I managed to auto-sync my "calendar.db" file from my android phone to my PC, using BTsync.
This "calendar.db" then I can open using an SQLite viewer.
My question : Is there a WIN7 calendar-application that can directly work with this .db file?
Or do I need to have it converted to ical every time when I auto-sync, to open it for example in Chandler?
Can I write / is there a small script to do so?
Tia for any answers ..

Related

[Q] How to play/ save talkbox message?

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

[Q] File crypter/decrypter for Android AND PC

Hi all,
I use Dropbox to syncronize some files between my PCs and my android phone. The problem is that the files are downloaded in the phone's SDCARD which is unsafe. So I've been searching ... and didn't found an app available on PC AND Android that is able to crypt and decrypt files.
Somebody knows something about that ? I imagine a lot of people need this kind of functionality ....
thanks in advance.
Moved to proper section

SMS Database Android

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

[Q] How to backup all conversation from my Windows Phone using an android emulator?

Need : Periodically backup all the messages of all my conversation on Whatsapp on my Lumia Windows Phone.
What I do now : Open whatsapp in my phone and export all possible meesages using the inbuilt option.
Issues with this : Lumia Windows Phone allows only that last 'n' no. of lines to be sent as mail (around 500 lines). So, in effect I cannot have a complete backup.
One possible option I felt :
Install Whatsapp on Bluestacks.
Get a copy of all messages I get on my Windows phone, on to my bluestacks
Access the database on bluetstacks using a file manager and retrieve the entire database at the end of each month.
There are many issues that might happen with this
Since whatsapp wont allow to get a copy of all messages, I will have to trick whatsapp to think both the devices are the same. I read somewhere that whatsapp does this check using the mac address. So I tried changing the mac address of bluestack to match my windows phone (it did not work)
I am in a mess now. I dont know how to proceed.
What is your suggestion as to how I can approach this issue? Please help.

[Q] Windows Phone 8.1 WhatsApp backup/restore

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...

Categories

Resources