Page 4 of 4 « First 23 4
Reply
Thread Tools
thedead1440 is offline thedead1440
2012-11-16 , 03:06
Moderator | Posts: 6,215 | Thanked: 6,400 times | Joined on Nov 2011
#31
Leinad,

I use in firefox an extension named "SQLite Manager" (but then my SQL skills are non-existent so I don't know if this is what you are looking for)...My meta.db is over >110MB as you can see from the ls -l I posted so 40MB is pretty ok

Also on your phone you can use sqlite3 to explore...

I'm running the grep now...let's see what happens...

Edit: Grep doesn't do anything for me too...Just keeps running...
Last edited by thedead1440; 2012-11-16 at 03:34.
 

The Following User Says Thank You to thedead1440 For This Useful 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:
ranga is offline ranga
2012-11-17 , 01:31
Posts: 17 | Thanked: 6 times | Joined on Apr 2012
#33
May i know who created the native message app in Nokia N9 it self...
 
Leinad is offline Leinad
2012-11-17 , 02:24
Posts: 594 | Thanked: 1,094 times | Joined on Aug 2012 @ Rhine
#34
Originally Posted by thedead1440 View Post
I use in firefox an extension named "SQLite Manager" (but then my SQL skills are non-existent so I don't know if this is what you are looking for)...My meta.db is over >110MB as you can see from the ls -l I posted so 40MB is pretty ok
This Firefox-Addon works great, better than all the stuff i downloaded before. SQLite is not my native "dialect", but i have to deal with mySQL everyday

Originally Posted by thedead1440 View Post
I'm running the grep now...let's see what happens...
Edit: Grep doesn't do anything for me too...Just keeps running...
It ran at least 2 hours on my phone and looked like it was freezing,maybe give it some time more (8h over night?)

Originally Posted by juiceme View Post
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":
Yep. i noticed that too

Originally Posted by juiceme View Post
Access to the file/directory is of course possible when you are root.
Nope. (for proof, see my putty-log, i was logged in as root)

Originally Posted by juiceme View Post
(and for the record, of course I also run my device in open mode, else all this stuff wouldn't be possible)
Nope. possible without open mode, thanks to Ariadne


Did a tracker reset and some things more to report, but i will do it tomorrow... got to go to sleep now
Last edited by Leinad; 2012-11-17 at 02:31.
 
thedead1440 is offline thedead1440
2012-11-17 , 02:35
Moderator | Posts: 6,215 | Thanked: 6,400 times | Joined on Nov 2011
#35
Ok will leave it to run over-night tonight; will report after 24 hrs as its 1035 here now

However, I don't think we'll get anything interesting except for the freezing part which I too experienced yesterday
 
Leinad is offline Leinad
2012-11-17 , 02:38
Posts: 594 | Thanked: 1,094 times | Joined on Aug 2012 @ Rhine
#36
Let me know, here it's 03:38
 
ranga is offline ranga
2012-12-01 , 17:43
Posts: 17 | Thanked: 6 times | Joined on Apr 2012
#37
any further improvement???
 
ranga is offline ranga
2013-07-21 , 14:29
Posts: 17 | Thanked: 6 times | Joined on Apr 2012
#38
Hi friends , Till now there is no solution for multiselection and delete on the message application.

Can anyone confirm it that it'll be available in sailfish...
 
Reply
Page 4 of 4 « First 23 4

« Previous Thread | Next Thread »

 
Forum Jump


All times are GMT. The time now is 18:05.

Contact Us - Home - Archive - Top