is there a way to read SMS's via wifi thru SSH? - maemo.org

Active Topics

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

Thread Tools

	F2thaK	2011-06-25 , 11:23
	Posts: 4,365 \| Thanked: 2,467 times \| Joined on Jan 2010 @ Australia Mate	#1

is there a way to read SMS's via wifi thru SSH?

help appreciated

__________________
N9 / N900 Youtube Videos

N9 "Faster, Darker, Better" Theme Pack
---
www.F2thaK.com

Quote & Reply |

	sakya	2011-06-25 , 11:42
	Posts: 533 \| Thanked: 1,341 times \| Joined on Dec 2010 @ Italy	#2

You can read the sqlite database:

Code:

sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "Select remote_uid,
 free_text, outgoing, is_read, storage_time from Events where service_id=3 and e
vent_type_id=11 order by storage_time desc"

if you want to read only incoming messages add

Code:

 and outgoing=0

to the where condition

__________________
My projects: smssend, groupsms, volumecontroldaemon, vodafone190, vodafone190 desktop widget, QtBatteryWidget, QtLockscreen, Lone Wolf
Donations are welcome

Last edited by sakya; 2011-06-25 at 11:50.

Quote & Reply |

The Following 3 Users Say Thank You to sakya For This Useful Post:
bingomion, ejasmudar, sixwheeledbeast

	F2thaK	2011-06-25 , 11:46
	Posts: 4,365 \| Thanked: 2,467 times \| Joined on Jan 2010 @ Australia Mate	#3

can you do that thru SSH, im using WinSCP?? thanks!

__________________
N9 / N900 Youtube Videos

N9 "Faster, Darker, Better" Theme Pack
---
www.F2thaK.com

Quote & Reply |

	sakya	2011-06-25 , 11:49
	Posts: 533 \| Thanked: 1,341 times \| Joined on Dec 2010 @ Italy	#4

I did it through ssh: open a terminal with WinSCP and execute that command.

__________________
My projects: smssend, groupsms, volumecontroldaemon, vodafone190, vodafone190 desktop widget, QtBatteryWidget, QtLockscreen, Lone Wolf
Donations are welcome

Quote & Reply |

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

	bingomion	2012-08-03 , 14:37
	Posts: 528 \| Thanked: 345 times \| Joined on Aug 2010 @ MLB.AU	#5

Originally Posted by sakya

You can read the sqlite database:
Code:
sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "Select remote_uid,
 free_text, outgoing, is_read, storage_time from Events where service_id=3 and e
vent_type_id=11 order by storage_time asc"
if you want to read only incoming messages add
Code:
 and outgoing=0
to the where condition

Thanks for the info, exactly what i was looking for!

I had to clear my unread messages: sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "update Events set is_read=1 where is_read=0"

I can now make it speak unread messages to me:
sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "Select free_text from Events where is_read=0 order by storage_time desc" | espeak

I was looking at using the power button replacing 'swipe to unlock' screen with a script to run this but all i can find is talk about mod'ing the unlock screen

I drive listening to podcasts/mp3/etc and when i get a message i want to click an external button (vol/power/camera) and have it read to me.

I don't like reading sms/skype while driving.. this would help out heaps!

EDIT: Harder then I thought

Last edited by bingomion; 2012-08-04 at 03:08.

Quote & Reply |

The Following 2 Users Say Thank You to bingomion For This Useful Post:
reinob, rotoflex

	bingomion	2012-08-12 , 00:44
	Posts: 528 \| Thanked: 345 times \| Joined on Aug 2010 @ MLB.AU	#6

I found a way.. Using espeaktime
just copy my cmd line to the end of:
/usr/bin/espeaktime-now.sh

now it reads the time and all unread messages!!
Thanks maemo and thankyou guys