abc to qwerty Messaging

by karthikselvakumar


Is your hands sore of messaging on whole day with your abc mobile keypad ?

Are you in need of tracking all your messages your loved ones send with some database ?

Need of a online chatting environment for sms ?

Here you are ,

All you need is :

i) Any Linux OS
ii) Mysql database to store the message
iii) SMSD to track and send message
iv) gnokii Suite

Installing Linux :

I guess every one knows how to install linux in your desktop , if not Check this link

Installing Mysql database :

try sudo apt-get install mysql

or

directly from synaptic

Installing gnokii and smsd :

sudo apt-get install gnokii

and then

smsd as sudo apt-get install gnokii-smsd-mysql

Now you have setup a base 😀


Step 1:

Configuring gnokii:

Connect your mobile via datacable or bluetooth to pc

create a file called /home/.gnokiirc

sudo gedit /home/.gnokiirc

add this lines to the file if you have Nokia mobile


[global]
port = /dev/ttyACM0
model = series40
initlength = default
connection = dku2libusb
use_locking = no
serial_baudrate = 19200
smsc_timeout = 10

[gnokiid]
bindir = /usr/local/sbin/

[connect_script]
TELEPHONE = +919xxxxxxxxx
[disconnect_script]

[logging]
debug = on
rlpdebug = off
xdebug = off

replace phone number field with yours

if you are not Nokia user try this link to configure your mobile

save the file

Open terminal and type sudo gnokii —identify

it must say something like this

GNOKII Version 0.6.26
LOG: debug mask is 0x1
Config read from file /home/karthik/.gnokiirc.
phone instance config:
model = series40
port = /dev/ttyACM0
connection = dku2libusb
initlength = default
serial_baudrate = 19200
serial_write_usleep = -1
handshake = software
require_dcd = 0
smsc_timeout = 10
rfcomm_channel = 1
sm_retry = 0
Connecting
Serial device: opening device USB
Ignoring extra header, type 171, length 5
Found FBUS interface
Can’t set configuration: -16
Getting model…
Message sent: 0x1b / 0x0006
00 01 00 07 01 00 |
Message received: 0x1b / 0x003e
01 39 00 08 00 01 58 38 00 31 56 20 30 35 2e 38 | 9 X8 1V 05.8
30 0a 31 38 2d 31 32 2d 30 38 0a 52 4d 2d 34 39 | 0 18-12-08 RM-49
35 0a 28 63 29 20 4e 6f 6b 69 61 20 20 20 20 20 | 5 (c) Nokia
20 20 20 20 20 20 20 0a 4d 48 00 00 00 00 | MH
Received message type 1b
model length: 6
Received model RM-495
Identifying…
Message sent: 0x1b / 0x0005
00 01 00 00 41 | A
Message sent: 0x1b / 0x0006
00 01 00 07 01 00 |
Message received: 0x1b / 0x001a
01 39 00 01 00 01 41 14 00 10 33 35 34 32 32 33 | 9 A 354223
30 33 30 30 33 39 33 31 37 00 | 030039317
Received message type 1b
Received imei 354223030039317
Message received: 0x1b / 0x003e
01 39 00 08 00 01 58 38 00 31 56 20 30 35 2e 38 | 9 X8 1V 05.8
30 0a 31 38 2d 31 32 2d 30 38 0a 52 4d 2d 34 39 | 0 18-12-08 RM-49
35 0a 28 63 29 20 4e 6f 6b 69 61 20 20 20 20 20 | 5 (c) Nokia
20 20 20 20 20 20 20 0a 4d 48 00 00 00 00 | MH
Received message type 1b
Received revision V 05.80
model length: 6
Received model RM-495
IMEI : 354223030039317
Manufacturer : Nokia
Model : RM-495
Product name : RM-495
Revision : V 05.80
Serial device: closing device

Step 2:

Then move on to smsd

Configure smsd very simple as follows in this link
replace this line as

mysql -u root -p your-db-password smsgw < /usr/share/doc/gnokii-smsd-mysql/sms.tables.mysql.sql

if you get access denied error

same thing in replace the sms line as below

and start the sms daemon

/usr/sbin/smsd -u root -d smsgw -c localhost -m mysql -p your-db-password -b IN -f /var/log/smsdaemon.log

Now all inbox and outbox messages will be in

smsgw database as inbox and outbox table😀

insert a tuple in outbox table to message to your friends
as
insert into outbox (number,text) values(‘+91987654321’, ‘message from sms daemon😉’);

enjoy messaging by inserting values into database as above🙂

to be continued ……….