abc to qwerty Messaging

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 :D _

_ 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 :D

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 ……….