Thread: How to delete multiple SMS messages
View Single Post
juiceme is offline juiceme
2012-11-16 , 05:49
Community Council | Posts: 4,920 | Thanked: 12,867 times | Joined on May 2012 @ Southerrn Finland
#32
You have these file access problems because the /home/user/.cache/tracker attributes do not allow listing of the directory to anyone but users who belong to group "metadata":

Code:
juice@firefly:~$ 
juice@firefly:~$ 
juice@firefly:~$ ssh user@n9usb 
user@n9usb's password: 

BusyBox v1.20.0.git (MeeGo 3:1.20-0.2+0m8) built-in shell (ash)
Enter 'help' for a list of built-in commands.

~ $ devel-su
Password: 

BusyBox v1.20.0.git (MeeGo 3:1.20-0.2+0m8) built-in shell (ash)
Enter 'help' for a list of built-in commands.

~ # 
~ # ls -la /home/user/.cache/
total 72
drwxr-xr-x   15 user     users         4096 Oct  3 14:12 .
drwxrwxrwx   71 user     users         4096 Nov 13 15:55 ..
drwxr-xr-x    3 user     users         4096 Jun 25 15:48 Nokia
drwxr-xr-x    3 user     users         4096 Jun 21 12:19 Till Harbaum
drwxr-xr-x    2 user     users         4096 Nov 15 18:50 contactsd
drwxr-xr-x    3 user     users         4096 Aug  2 11:24 data
drwxr-xr-x    2 user     users         4096 Aug  6 17:37 farsight
drwx------    4 user     users         4096 Jun 28 20:15 libkok
drwxr-xr-x    2 user     users        16384 Oct 21 01:40 media-art
drwx------    2 user     users         4096 Oct  3 14:42 menus
drwxr-xr-x    5 user     users         4096 Jun 21 15:07 music-suite
drwxr-xr-x    4 user     users         4096 Jun 21 15:07 nmsrestapi
drwx------    2 user     users         4096 Jun 21 09:35 rygel
d---rwx---    2 metadata metadata      4096 Nov 15 13:42 tracker
drwxr-xr-x    3 user     users         4096 Jun 21 12:04 video-suite
~ #
Access to the file/directory is of course possible when you are root. (and for the record, of course I also run my device in open mode, else all this stuff wouldn't be possible)

So, I just tarred the whole tracker directory; "tar -cvf trackercache.tar /home/user/.cache/tracker" and then copied it off to my desktop using sftp.

I used sqlitebrowser (version 2.0.0~beta1+ds.1-2 that comes with ubuntu 12.04, but I suppose any version works...) to extract the DB as a CSV file.
Additionally I used python sqlite package "apsw" to test reading the DB file.
 

The Following User Says Thank You to juiceme For This Useful Post: