How to access SMS database in Sailfish? - Page 3 - maemo.org

Active Topics

Camera phone competition March 2023 "Endless" (35)
to General by Maemish - 5 hrs, 42 mins ago
TLS 1.2 for N9 is ready (28)
to MeeGo / Harmattan by smartblu9 - 6 hrs, 56 mins ago
Maemo repository (3)
to Community by torsen - 22 hrs, 26 mins ago
Error after installing Leste on sdcard (11)
to Maemo 7 / Leste by Maemish - 1 day, 20 hrs ago
Introducing ubiboot N9 (multiboot OS loader) (1,393)
to Alternatives by smatkovi - 3 days, 2 hrs ago
more...

Page 3 of 7

< Prev

Next >

Last »

Thread Tools

	merlin1991	2013-12-24 , 17:05
	Posts: 125 \| Thanked: 1,142 times \| Joined on Feb 2010 @ Austria	#21

Originally Posted by Nikos Alexandris

The only place from where I could execute the binary smsExport was from /home/user. Anywhere else, e.g. under /home/user/MyDocs/N9Export I could neither alter permissions nor let it run (always permission denied).

If you have a look at mount, especially this bit:

Code:

/dev/mmcblk0p1 on /home/user/MyDocs type vfat (rw,nosuid,nodev,noexec,noatime,nodiratime,uid=29999,fmask=0133,dmask=0000,allow_utime=0022,codepage=cp437,iocharset=iso8859-1,shortname=mixed,utf8,rodir,errors=remount-ro)

you'll see, that "noexec" flag ist set for MyDocs which prevents you from running executables from there.

Regarding your problem, never forget our dear friend aegis. You have to run the application as the developer user since he is the only user with enough aegis credentials to access your messages database.

__________________
"Fog is neither water nor air, it's something between." Merlin

Quote & Reply |

rainisto	2013-12-25 , 14:45
Posts: 1,067 \| Thanked: 2,383 times \| Joined on Jan 2012 @ Finland	#22

Otherwise works ok, but it scrambles öäå characters on import, maybe it should export/import in utf8 or something?

And on N9 side you needed to run it as developer and not as user.

__________________
IRC: jonni@freenode
Sailfish: ¤ Qt5 SailfishTouchExample ¤ Qt5 MultiPointTouchArea Example ¤ ipaddress ¤ stoken ¤ Sailbox (Dropbox client) ¤
Harmattan: ¤ Presence VNC for Harmattan ¤ Live-F1 ¤ BTinput-terminal ¤ BabyLock ¤ BabyLock Trial ¤ QML TextTV ¤
Disclaimer: all my posts in this forum are personal trolling and I never post in any official capacity on behalf of any company.

Last edited by rainisto; 2013-12-25 at 17:46.

Quote & Reply |

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

	zlatko	2013-12-25 , 16:05
	Posts: 861 \| Thanked: 936 times \| Joined on Feb 2010 @ Bulgaria	#23

Worked perfect on my N9 and Jolla

Thanks everyone involved!

Quote & Reply |

	merlin1991	2013-12-26 , 01:05
	Posts: 125 \| Thanked: 1,142 times \| Joined on Feb 2010 @ Austria	#24

Another day, another update:

As suggested by rainisto the application now saves to utf-8 files.
It also can ex/import the call history now by using the -c flag.

New binaries:
http://cdnm.at/~christian/Harmattan-...at/jollaImport
http://cdnm.at/~christian/Harmattan-SMS-Boat/n9Export

Source still at github:
https://github.com/merlin1991/Harmattan-SMS-Boat

__________________
"Fog is neither water nor air, it's something between." Merlin

Quote & Reply |

The Following 16 Users Say Thank You to merlin1991 For This Useful Post:
bb_szx, erendorn, ezameht, Hariainm, Iipe, lokimotive, mattaustin, n-mi, Naranek, rcolistete, Roth, shubell, Watchmaker, xkkkx, zamorph, zlatko

Nikos Alexandris	2013-12-26 , 04:18
Posts: 22 \| Thanked: 18 times \| Joined on Oct 2012	#25

Originally Posted by merlin1991

Another day, another update:

As suggested by rainisto the application now saves to utf-8 files.
It also can ex/import the call history now by using the -c flag.

New binaries:
http://cdnm.at/~christian/Harmattan-...at/jollaImport
http://cdnm.at/~christian/Harmattan-SMS-Boat/n9Export

Source still at github:
https://github.com/merlin1991/Harmattan-SMS-Boat

Amazing! I can't get it working though :-(

Code:

/home/user # whoami 
root
/home/user # ls -lah n9Export 
-rwxr-xr-x    1 user     users     259.1K Dec 26 06:14 n9Export
/home/user # ./n9Export -s sms_n9
"GDBus.Error:org.freedesktop.DBus.Error.AccessDenied: Rejected send message, 2 matched rules; type="method_call", sender=":1.148" (uid=0 pid=6202 comm="./n9Export -s sms_n9 ") interface="org.freedesktop.Tracker1.Steroids" member="Query" error name="(unset)" requested_reply=0 destination="org.freedesktop.Tracker1" (uid=29999 pid=1346 comm="/usr/lib/tracker/tracker-store "))" 
# sms:  0 
QTrackerDirectSelectResult: QSparqlError(9, "GDBus.Error:org.freedesktop.DBus.Error.AccessDenied: Rejected send message, 2 matched rules; type="method_call", sender=":1.148" (uid=0 pid=6202 comm="./n9Export -s sms_n9 ") interface="org.freedesktop.Tracker1.Steroids" member="Query" error name="(unset)" requested_reply=0 destination="org.freedesktop.Tracker1" (uid=29999 pid=1346 comm="/usr/lib/tracker/tracker-store "))", 4) "SELECT ?message nie:plainTextContent(?message) rdf:type(?message) nmo:communicationChannel(?message) nmo:sentDate(?message) nmo:messageId(?message) nmo:receivedDate(?message) nie:contentLastModified(?message) nmo:isSent(?message) nmo:isDraft(?message) nmo:isRead(?message) nmo:encoding(?message) nie:characterSet(?message) nie:language(?message) (SELECT GROUP_CONCAT(tracker:coalesce(nco:imID(?medium), nco:phoneNumber(?medium), ?medium), "\u001e") WHERE { ?from nco:hasContactMedium ?medium . }) (SELECT GROUP_CONCAT(tracker:coalesce(nco:imID(?medium), nco:phoneNumber(?medium), ?medium), "\u001e") WHERE { ?to nco:hasContactMedium ?medium . }) nmo:phoneMessageId(?message) WHERE { SELECT ?message ?from ?to  IF (nmo:isSent(?message) = true, ?to, ?from) AS ?target  ?message WHERE {?message nmo:from ?from ; nmo:to ?to .  ?message rdf:type nmo:SMSMessage . } }"

Quote & Reply |

	zlatko	2013-12-26 , 06:54
	Posts: 861 \| Thanked: 936 times \| Joined on Feb 2010 @ Bulgaria	#26

@Nikos Alexandris
Run

Code:

develsh

prior executing the export.

Quote & Reply |

Nikos Alexandris	2013-12-26 , 11:18
Posts: 22 \| Thanked: 18 times \| Joined on Oct 2012	#27

Originally Posted by zlatko

@Nikos Alexandris
Run
Code:
develsh
prior executing the export.

Thank you! Apologies for my ignorance. It works :-). For the "-c" option, however, I get countless lines of:

Code:

libqtcontacts-tracker: engine.cpp:1591: Not cleaning up obsolete resources for nao:hasTag property since the property's range is too generic (rdfs:Resource).

What does it actually mean?

Quote & Reply |

Nikos Alexandris	2013-12-26 , 12:59
Posts: 22 \| Thanked: 18 times \| Joined on Oct 2012	#28

Originally Posted by Nikos Alexandris

Thank you! Apologies for my ignorance. It works :-). For the "-c" option, however, I get countless lines of:
Code:
libqtcontacts-tracker: engine.cpp:1591: Not cleaning up obsolete resources for nao:hasTag property since the property's range is too generic (rdfs:Resource).
What does it actually mean?

In any case, it worked. Awesome work!!

Quote & Reply |

nicetux	2013-12-26 , 13:04
Posts: 9 \| Thanked: 2 times \| Joined on Mar 2011 @ Freiburg / Germany	#29

When i try to export my sms on n9 i get following error message:

Code:

~/MyDocs/SMSBackup $ develsh n9export -s 20132612
n9export: line 1: syntax error: unexpected word (expecting ")")

What I'mdoing wrong?

Last edited by nicetux; 2013-12-26 at 13:35.

Quote & Reply |

juiceme	2013-12-26 , 17:34
Community Council \| Posts: 4,920 \| Thanked: 12,867 times \| Joined on May 2012 @ Southerrn Finland	#30

Originally Posted by nicetux

When i try to export my sms on n9 i get following error message:
Code:
~/MyDocs/SMSBackup $ develsh n9export -s 20132612
n9export: line 1: syntax error: unexpected word (expecting ")")
What I'mdoing wrong?

you should first launch "develsh", then "./n9export"