Database Info

PDF & DOC attachments

Did a search, so sorry if I missed it. But, a couple of questions.
1) If you have root, is it possible to download and save PDF and Word files that come in on POP3 (or even gmail) email?
2) Otherwise, does anyone know the phone folder where these files are temporarily store while on the phone, and can they be accessed that way?
I spend a lot of time overseas, and going back and forth to the web to retrieve is a pain and expensive. Thanks

Forget it, I solved the issue.

Informing use how you solved the issue might help others

I'd be really interested in how you managed this, I've searched here, and Googled everywhere (almost). But I still haven't found what I'm looking for...

Mikey1022 said:
Informing use how you solved the issue might help others
Click to expand...
Click to collapse
lol...gotta love these types of posts right?

I'm able to save attachments like this using k-9 mail., for those interested

Sorry to go AWOL -- had to leave the country for a bit. My apologies.
Yeah, I also "solved" it by using K9. But, I find the program very buggie.
On a larger, related question, how does the Android platform make its file associations? In other words, when I receive an email attachment (with the stock app), it will allow me to download and save that attachment to my SD card only if there is an onboard, associated program. I can download .jpg, because Android has an application built in that will read a jpg. So, if I want to download a .doc file, I can't unless there is an appropriate app onboard. (Although k9 seems to have found a way). Where, in the Android platform, is this association made? And, is it possible (with a rooted phone) to somehow manipulate those associations to allow downloading of ANY (or a chosen few) files?
For instance, I find that if I change the file extension on a Word doc (for example) from "doc" to "jpg", my onboard email will allow me to download and save to SD card. So, it obviously CAN do it, what's stopping it?
Again, sorry for "skipping out" in the midst of a thread.

Download Crutch Lite in the market allows you to download any file by making Android believe it can open any filetype.

Theres a app called download crutch on the market that allows downloading of files that may not have associated applications. Not exactly sure what file types it supports but its worth a shot.
EDIT: Fushichou got it before me but heres a link to Cyrket http://www.cyrket.com/search?q=download+crutch

Thanks, but my experience is that Crutch will not work on email attachments. It seems to be an internet based device. I used it for a while. Partially, this is a kind of tech question -- how are the files associated?

(REQ) Folder ReDirector

Looking for a simple app, that can redirect files to a spec folder, for example. Handcent has a subfolder in which it saves files from picture or videos. I would like something that would keep items saved in designated folders. Ie. /Handcent/download folder redirect to dcim/100media/

I've been wanting to test usage of symbolic links on my android device, but never get around to it.
I've found symbolic links to always solve my problems on a pc, so perhaps this is am option for android os, too..

i did some research, seems this is possible.. any one out there any ideas?

we used a symlink for adfree android before we had S-off, so symlinking is definitely doable.

Any input anyone?

File management on CM9

Hi I was wondering if anyone else had this issue. The camera and gallery on CM9 are very peculiar... For one the camera app doesn't focus well and you can't tap to focus? And the gallery app is just broken. When you delete something, it comes back later. Lie if if you delete and go to check your files, it's still there. Which is brings me to my last point, what file management software is the easiest to use and navigate? I found the "My Files" from stock experience the best. Thanks
Sent from my SAMSUNG-SGH-I727 using xda app-developers app

1. I've not had those issues with cm9.
2. root explorer has always been my favorite . I would highly recommend it.(very easy to use).

With the camera, tap to focus has never worked as far as I know.
As for the gallery, many people have experienced that, excluding myself. So either one of them will cone along or keep searching through all the CM9 threads. You will definitely find an abundance of posts regarding that issue.
And for file management, there's also FX File Explorer, as well as Solid Explorer.
Sent from my SAMSUNG-SGH-I727 using Tapatalk 2

Try Quickpic as a replacement for the Gallery, and working great with cm9
Sent From Down The Rabbit Hole. CM9 Nightlies - Cobalt Theme

I use Just Pictures as a picture only gallery replacement.
You might want to go to manage apps. Find the gallery app and select clear data/cache. Can't remember which one it says.
You might have to setup the gallery again or wait for your pics to resync. This usually fixes weird issues. Also, fix permissions in your CWM.
Sent from my SAMSUNG-SGH-I727 using xda app-developers app

QuickPic for the gallery replacement.
Root Explorer & ES File Explorer for file manager.

kchen96 said:
And the gallery app is just broken. When you delete something, it comes back later. Lie if if you delete and go to check your files, it's still there.
Click to expand...
Click to collapse
I was having the exact same issue with CM9 RC2 and did a bunch of digging around in the source code to see if I could figure out what causes it. In my case, I was unable to delete images that were stored on an external SD card. Images stored on the internal SD card were deleted properly.
It turns out that when Gallery deletes images, the directory they are contained in must be in one of two environment variables that are set up at boot time: EXTERNAL_STORAGE and SECONDARY_STORAGE. CM9 RC2 sets EXTERNAL_STORAGE to /mnt/emmc and does not set SECONDARY_STORAGE. Since only /mnt/emmc is listed, files are only deleted from the internal SD card.
Modifying the environment variables is kind of a pain in the butt, since they're initialized in /init.emmc.rc, which is part of the ramdisk, which means you have to grab the boot.img, unpack it, change init.emmc.rc, then repack/flash it. In my case all I did was add an additional line that sets SECONDARY_STORAGE to /mnt/sdcard immediately after setting EXTERNAL_STORAGE. I've been running this way on my phone for about a week now without issues, deleting images from Gallery just fine.
I submitted a bug report and patch at the TeamChopsticks google code page (issue 105), but it hasn't gotten any attention yet.

I breifly searched, but couldn't find the TeamChopsticks Google Code page. If you post a link, I'd gladly support your Issue #105 because I'm experiencing it, too.

Trinition said:
I breifly searched, but couldn't find the TeamChopsticks Google Code page. If you post a link, I'd gladly support your Issue #105 because I'm experiencing it, too.
Click to expand...
Click to collapse
Sorry, I can't hotlink it because I'm a noob without enough posts. If you go to teamchopsticks.org, then click on Release Notes, there's a link in the first paragraph of the text on the page that will take you to their Google Code page. You should be able to find the issue from there. If you could hotlink it I would certainly appreciate it.

AWiseMonkey said:
QuickPic for the gallery replacement.
Root Explorer & ES File Explorer for file manager.
Click to expand...
Click to collapse
1) Highly recommend Root Explorer for general file management.
2) Check out the ported Sony Xperia album app for a pretty slick gallery. It's available for download and direct install in the themes & apps threads.
Sent from my SGH-I727

Subfolder notification using ActiveSync in 4.4 tested and working!

Ok everyone, I know there are a fair number of us out there that have rules setup in Exchange to redirect emails from certain people to folders. The problem with this is that will stop us from getting notifications on our phones (NOTE: I am not referring to syncing those folders. Obviously they need to be synced but the issue was that even with them synced you do not receive a notification when an email arrives in the folder even though it did sync properly). I was shocked when 4.4 came out and this issue hadnt been addressed. However as per the official issue on the android code site a user found out an incredibly easy way to make it work! It appears it is built-in by Google they just chose not to enable the feature.
See this post: https://code.google.com/p/android/issues/detail?id=50188#c59
I wasnt sure where to post this as it should work for any phone running the new email app in 4.4 but I didnt want to create a thread in each phone forum.
Here are some directions that may be a bit clearer than the original comment above.
NOTE: I used Root Explorer (paid version) for this
- Go to your email database folder. Located at: /data/data/com.android.email/databases
- Click on the "EmailProvider.db" file (open in Internal Viewer)
- Choose "Mailbox" from the list
- From this list write down the corresponding "serverId" of each folder that you want to have notifications on
- Convert those numbers to Base64 using the following tool: http://www.motobit.com/util/base64-decoder-encoder.asp (note that you will remove any "=" signs after your number)
- Now go back a folder to: /data/data/com.android.email/shared_prefs
- Now find a currently syncing folder from that same account (i.e. likely labelled: Folder-<ACCOUNT NAME>-<BASE64STRING).xml) So as an example lets say [email protected]. In that example the folder with serverId "5" is being synced. In this case its the "Inbox" folder of that account
- Long press on that file and choose "Copy" and then copy it back to the same directory
- Rename your newly copied file changing JUST the BASE64STRING part to the one that matches the folder you want to sync
- Reboot phone and enjoy!

I guess I should post them in some of the phone forums... there was a big thread somewhere I remember posting in at some point

Thanks for writing out these instructions! Glad to see there's a workaround -- this one little issue has driven me nuts for forever!
Just for reference, there is a thread I've followed for quite some time that's been focused on this issue, but it's buried in a Galaxy S II forum, so I think it could be easy to miss. They seem to be on to the same solution you posted here: http://forum.xda-developers.com/showthread.php?p=48140770#post48140770
EDIT: Actually, just noticed the XDA post I linked to is word-for-word the same as the Android Issue Tracker post you reference, so that's the same guy providing the solution. Small world.

Just an FYI that even in gmail 5.0 this issue still exists and is still easily fixed by adding the file as above (different folder now though). Apparently making this an option is beyond Google's ability

Have the same problem.
The real path to DB is:
/data/data/com.google.android.gm/databases/EmailProvider.db
Shared prefs:
/data/data/com.google.android.gm/shared_prefs
And the manual instructions at the first post of this topic didn't helped me.
I have OnePlus 3T A3003 with Oxygen OS 4.1.3 (beta7) (Android 7.1.1) and Gmail version 7.4.23.154506495.release.
Anyone have any ideas?

Can I extract sms messages from a complete physical memory dump?

So a while ago I grabbed a Motorola G2, made a complete physical memory dump to file “Full_Phone_Backup.image” I also have a .vhd which will not mount, but I remember very clearly extracting the contacts list from it.
I didn’t keep records of how I went about doing it, but I’m sure it was some busybox or cygwin and I’m very sure the file contains all the partitions. Don’t know what happened to .vhd, but I also can’t make a new one either, so bad luck I guess. Anyway, now I need to extract SMS messages from it, and so I turned to Foremost. With the following in a foremost-db.conf:
Code:
db n 4000000 \x53\x51\x4c\x69\x74\x65\x20\x66\x6f\x72\x6d\x61\x74\x20\x33\x00
I hoped to get a good rundown of the databases and extract from there. Now, I don’t need deleted messages or anything, I need to find the SMS messages that would be there as if the phone was on right now. Well, that and search them.
So, Foremost carved a whooping 36 GiB of .db files, which I think suggests that the file header is actually not for SQLite 3 file as much as for a part of SQLite3 file, and one file may contain many. Secondary evidence of that is that massive number of files contain the same data shifted a more or less uniform number of lines (like an entire block shifted 1k lines down across 10 files before it completely disappears).
Anyway, from the carved DB files I got meaningful e-mail messages, from the carved photos and videos, I got meaningful pictures (ones which would be on this phone), so I am sure data is there. Problem is, I could not find the messages I’m looking for. I was unable to find a single SMS message, I was unable to browse any of the recovered databases with sqlite database browsers, and the most useful thing I was able to do was to use Ransack in windows to search for relevant text in those recovered files.
What am I doing wrong that I’m not finding SMS messages or any relevant text in this mess?

KYKYLLIKA said:
So a while ago I grabbed a Motorola G2, made a complete physical memory dump to file “Full_Phone_Backup.image” I also have a .vhd which will not mount, but I remember very clearly extracting the contacts list from it.
I didn’t keep records of how I went about doing it, but I’m sure it was some busybox or cygwin and I’m very sure the file contains all the partitions. Don’t know what happened to .vhd, but I also can’t make a new one either, so bad luck I guess. Anyway, now I need to extract SMS messages from it, and so I turned to Foremost. With the following in a foremost-db.conf:
Code:
dbn 4000000\x53\x51\x4c\x69\x74\x65\x20\x66\x6f\x72\x6d\x61\x74\x20\x33\x00
I hoped to get a good rundown of the databases and extract from there. Now, I don’t need deleted messages or anything, I need to find the SMS messages that would be there as if the phone was on right now. Well, that and search them.
So, Foremost carved a whooping 36 GiB of .db files, which I think suggests that the file header is actually not for SQLite 3 file as much as for a part of SQLite3 file, and one file may contain many. Secondary evidence of that is that massive number of files contain the same data shifted a more or less uniform number of lines (like an entire block shifted 1k lines down across 10 files before it completely disappears).
Anyway, from the carved DB files I got meaningful e-mail messages, from the carved photos and videos, I got meaningful pictures (ones which would be on this phone), so I am sure data is there. Problem is, I could not find the messages I’m looking for. I was unable to find a single SMS message, I was unable to browse any of the recovered databases with sqlite database browsers, and the most useful thing I was able to do was to use Ransack in windows to search for relevant text in those recovered files.
What am I doing wrong that I’m not finding SMS messages or any relevant text in this mess?
Click to expand...
Click to collapse
You can't get into the phone and use SMS backup app or PC to backup your SMS? Can you back them up to your Google account and then recover them from there?
There are several ways to recover SMS from a device, is this method the only one you've tried?
Are you recovering your SMS or someone else's?
Sent from my SM-S903VL using Tapatalk

KYKYLLIKA said:
So a while ago I grabbed a Motorola G2, made a complete physical memory dump to file “Full_Phone_Backup.image”
.
.
and I’m very sure the file contains all the partitions.
Click to expand...
Click to collapse
How did you make this Backup.image? In my question over here I dreamt of something like 'dd if=/dev/sda of=/image.bak' for a really complete backup. Did you make your complete memory dump in such a way and would i be possible to write it back to the phone?
Thanks!

Droidriven said:
You can't get into the phone and use SMS backup app or PC to backup your SMS? Can you back them up to your Google account and then recover them from there?
There are several ways to recover SMS from a device, is this method the only one you've tried?
Are you recovering your SMS or someone else's?
Sent from my SM-S903VL using Tapatalk
Click to expand...
Click to collapse
This is my sister’s phone. The backup is from 16 months back or so. I can’t go search the SMS it has now, because updates been around since then, including a new version of android, and all that. It does not have the old messages.
What I tried is a sqlite forensics utility called “sqlite forensics reporter”, but no luck with that either. Piriform recuva did not work, and I was unable to mount it as a virtual hard drive or find a part of it that I could mount as a virtual hard drive.
andy_ross said:
How did you make this Backup.image? In my question over here I dreamt of something like 'dd if=/dev/sda of=/image.bak' for a really complete backup. Did you make your complete memory dump in such a way and would i be possible to write it back to the phone?
Thanks!
Click to expand...
Click to collapse
This is entirely possible. However, I cannot find the boot record in there or a partition table, which is very strange. I do remember dumping all the partitions in that file, though. It’s been over a year now, so details kind of gone fuzzy. I am sure I could write it back to a phone and use like that, but I don’t have a suitable surrogate phone or a virtual machine to try that on. I will not do it on the device itself, seeing as how it’s in use and all that. I just want to find the text of some messages.