In light of all the CarrierIQ press I started wondering what others applications on my phone might be doing things that I am not aware of. So I installed SQLite Editor and started poking around my phone, that’s when I decided to see what my sms client “Handcent” was up too. Since I wanted to view my out on a bigger monitor I fired up a adb shell and used SQLite see what Handcent sms was hiding under the hood.
I used the following command to search my /data/data folder on my device to look for any files with a .db extension since that indicated it was a database file.
adb shell find /data -name *.db
As you can see I found several databases on my phone but today
we will be looking at one in particular. Handcent's "hc_sms.db".
or this part we will use sqlite to view the database layout (schema)
and its contents:
CREATE TABLE DELIVERY_REPORT (MESSAGE_ID INTEGER Primary KEY,TIMESTAMP text,UPDATE_TIMESTAMP text);
CREATE TABLE SEND_LOG (ID Integer Primary KEY,SID INTEGER ,SEND_TYPE INTEGER,BEGIN_SEND_TIME text,END_SEND_TIME text,SEND_CONTENT TEXT,
SENDING_PERSON_NUBER INTEGER,SUCCESS_NUMBER INTEGER,FAIL_NUMBER INTEGER);
CREATE TABLE SEND_LOG_DETAIL (SID INTEGER,PID INTEGER,BEGIN_SEND_TIME TEXT,END_SEND_TIME TEXT,PERSON_NAME TEXT,PERSON_NUMBER TEXT,SENDI
NG_MESSAGE_NUMBER INTEGER,SENT_SUCCESS_NUMBER INTEGER,SENT_FAIL_NUMBER INTEGER);
CREATE TABLE android_metadata (locale TEXT);
DELIVERY_REPORT SEND_LOG SEND_LOG_DETAIL android_metadata
And now afte
r doing a select * from SEND_LOG; to my amazement
I saw all my text messages that were sent since I installed
the handcent application both
Also looking at select * from SEND_LOG_DETAIL I saw the same
information but this log also held the receiver of the sms name
and phone number.
Now my question is, if I am deleting a message and thinking
its being deleted why would handcent chose to keep a copy of
this message in an unencrypted database where anyone can access
it? I would love to hear from them and try to understand why
this is being done.
Hello all, I know I have been a bit lazy on the posting of new content for a while, hopefully my busy schedule is now getting a little more manageable and I can start back blogging. Apart from work being crazy recently I was involved with assisting my wife with her debut album that will be released by year end, check her out on www.facebookcom/yonetteodessa and become a fan :).
Ok back to reason why you visited the blog, I recently got a new phone “Verizon Droid Bionic”, this for me was a big change from my current Blackberry storm, so after playing around with the phone for about 2 weeks I started wondering what else can I do with this powerful little machine in my pocket.
I went ahead like any techno enthusiast powered up my Linux net-book and rooted my device using a guide found over at www.droidbionicroot.com , and I was up and running in a few mins.
Next I started to ask myself, ok I have rooted my Droid now what? While doing some searching online I came across a few things that you might want to do after rooting your device:
- Tweak your device for longer battery life –> courtesy of http://forums.androidcenteral.com
- Start learning about ROMs, how to backup/install
- Useful forums you should signup for:
- If you want to start installing custom ROMs you need “ROM Manager” -> http://www.clockworkmod.com/
- Other interesting apps I have installed so far:
- Droidsheep (Awesome Session Hijacking Android app) —Need root
- Titanium Backup ( Backup ALL apps,remove bloatware & MORE) –Need root
- Arpspoof (Broadcast spoofed ARP messages) –Need root
- AdFree ( removes most ads in the browser and other apps) —Need root
- DroidWall (Allows you to restrict which apps can access the network) –Need root
- Lookout Security & AV (Antivirus, Phone Locator, Data Backup) –Does not need root
- Wifi Analyzer (Turns your phone into a Wi-Fi analyzer) —Does not need root
- Prey (Track download your lost of stolen device) —Does not need root
- Dropbox (cloud storage access) —Does not need root
- KeePassDroid (Securely store your passwords) — Does not need root
- Apps referred by friends but I have not tested them as yet:
- AndGuard (Powerful Ad-Blocker and Internet Security App) —need root
- Netmonitor (Monitor GSM/CDMA network) —Does not need root
I am aware that some of the apps listed above does not require you to root your device, however rooting your device allows you to do tons of kool stuff if you are adventurous.You can increase your batter life, install custom ROMs ( I cant wait for a CyannogenMod for the Droid Bionic to be released), install your favorite Linux apps once there is a port available and most importantly gives you more control over your device to truly learn whats under the hood.
Caution: Be mindful what type of apps your install or where you are installing them from because you could easily get your device con.
I would love to know what are others doing with there device, please leave a comment and share.