SMS Content Access for Third Party Android Apps

asked 2016-08-30 12:18:57 +0200

skaich gravatar image

Hi Jolla Team,

Can you please let us know when the SMS content access will be available in Sailfish 2.0 ?

Because currently no android applications for backup and restore call logs, contact list and sms-es are not able to pickup any information from the Sailfish OS 2.0 even after installing those android apps from your designated jolla store.

I also tried some scripts uploaded by people in this blog but none seems to be working because of encrypted commhistory.db

Thanking you Suman from India

Currently I am using SailFish 2.0 ( 2.0.2.48) in Intex AquaFish phone.

edit retag flag offensive close delete

Comments

I have no idea how you have managed to get your commhistory encrypted?

It's normal sqlite3 database....

juiceme ( 2016-08-30 12:36:23 +0200 )edit

Please note that I am searching in the /home/nemo/.local/share/commhistory/commhistory.db.

When I am running the following query it is giving following message.

SELECT remoteUid, direction, startTime, isRead, freeText FROM Events WHERE type=2;

Event Not Found

And this file is not expanding when new SMS is coming. Instead the other file commhistory.db-wal is expanding

When I am using the same query it is giving following error:

SQL error: file is encrypted or is not a database

skaich ( 2016-08-30 12:54:45 +0200 )edit

@skaich, the .db-wal file is a database cache file, of course it changes when you have operations done to the DB. You cannot see a database file "expand" when you insert rows, it is not a flat file but has internal structure where the data goes... only when some limits are reached the DB needs to grow in size... :)

juiceme ( 2016-08-30 13:18:02 +0200 )edit

using sqlite-browser (http://sqlitebrowser.org/), you can view and edit the commhistory.db file once you copied it onto a pc

till ( 2016-08-30 13:21:50 +0200 )edit

Besides, the query "SELECT remoteUid, direction, startTime, isRead, freeText FROM Events WHERE type=2;" works rather well on my DB, and returns a load of SMS messages.

Try for example "SELECT count(*) FROM Events WHERE type=2;", that gives you the number of messages in the store. (I have 6505 sms messages, it seems)

juiceme ( 2016-08-30 13:23:41 +0200 )edit