Nokia 6021 - smsd and mysql - pulls out Inbox messages but not Sent item

Hi all,

After last weeks attempts of using a Nokia 6301 and it being unsuccessful (thanks anyway Pawel for the help) ive laid my hands on a Nokia 6021 and data cable.

I have got gnokki to identify my phone

Gnokki –identify

GNOKII Version 0.6.29

LOG: debug mask is 0x1

Config read from file /home/ftladmin/.config/gnokii/config.

phone instance config:

model = 6021

port = /dev/ttyUSB0

connection = serial

initlength = default

serial_baudrate = 19200

serial_write_usleep = -1

handshake = software

require_dcd = 0

smsc_timeout = 30

rfcomm_channel = 0

sm_retry = 0

Connecting

Serial device: opening device /dev/ttyUSB0

Serial device: setting speed to 115200

Serial device: setting RTS to low and DTR to low

Getting model...

Message sent: 0x1b / 0x0006

00 01 00 07 01 00 |

[Received Ack of type 1b, seq: 0]

[Sending Ack of type 1b, seq: 2]

Message received: 0x1b / 0x0032

01 39 00 08 00 01 58 2c 00 26 56 20 30 34 2e 35 | 9 X, &V 04.5

30 0a 31 39 2d 31 32 2d 30 35 0a 52 4d 2d 39 34 | 0 19-12-05 RM-94

0a 28 63 29 20 4e 6f 6b 69 61 2e 20 20 0a 43 00 | (c) Nokia. C

00 00 |

Received message type 1b

model length: 5

Received model RM-94

Found model "RM-94"

Identifying...

Message sent: 0x1b / 0x0005

00 01 00 00 41 | A

Message sent: 0x1b / 0x0006

00 01 00 07 01 00 |

[Received Ack of type 1b, seq: 1]

[Received Ack of type 1b, seq: 2]

[Sending Ack of type 1b, seq: 3]

Message received: 0x1b / 0x001a

01 39 00 01 00 01 41 14 00 10 33 35 39 33 35 37 | 9 A 359357

30 30 31 39 33 34 38 35 31 00 | 001934851

Received message type 1b

Received imei 359357001934851

[Sending Ack of type 1b, seq: 4]

Message received: 0x1b / 0x0032

01 39 00 08 00 01 58 2c 00 26 56 20 30 34 2e 35 | 9 X, &V 04.5

30 0a 31 39 2d 31 32 2d 30 35 0a 52 4d 2d 39 34 | 0 19-12-05 RM-94

0a 28 63 29 20 4e 6f 6b 69 61 2e 20 20 0a 43 00 | (c) Nokia. C

00 00 |

Received message type 1b

Received revision V 04.50

model length: 5

Received model RM-94

IMEI : 359357001934851

Manufacturer : Nokia

Found model "RM-94"

Model : 6021

Product name : RM-94

Revision : V 04.50

Serial device: closing device

I can send items fine via the CLI but this doesn’t write to the sent items of the phone! (Is this correct behaviour?)

SO I start the smsd with

/usr/sbin/smsd –uroot –p******* -d Nagios_Text –c 127.0.0.1 –m mysql –b IN –f /home/ftladmin/Desktop/smsd.log

And it outputs

usr/sbin/smsd -uroot -p********* -d Nagios_Text -c 127.0.0.1 -m mysql -b IN -f /home/user/Desktop/smsd.log

smsd - version 1.4.4 from gnokii 0.6.29

LOG: debug mask is 0x1

Config read from file /home/user/.config/gnokii/config.

phone instance config:

model = 6021

port = /dev/ttyUSB0

connection = serial

initlength = default

serial_baudrate = 19200

serial_write_usleep = -1

handshake = software

require_dcd = 0

smsc_timeout = 30

rfcomm_channel = 0

sm_retry = 0

Connecting

Serial device: opening device /dev/ttyUSB0

Serial device: setting speed to 115200

Serial device: setting RTS to low and DTR to low

Getting model...

Message sent: 0x1b / 0x0006

00 01 00 07 01 00 |

[Received Ack of type 1b, seq: 0]

[Sending Ack of type 1b, seq: 6]

Message received: 0x1b / 0x0032

01 39 00 08 00 01 58 2c 00 26 56 20 30 34 2e 35 | 9 X, &V 04.5

30 0a 31 39 2d 31 32 2d 30 35 0a 52 4d 2d 39 34 | 0 19-12-05 RM-94

0a 28 63 29 20 4e 6f 6b 69 61 2e 20 20 0a 43 00 | (c) Nokia. C

00 00 |

Received message type 1b

model length: 5

Received model RM-94

Found model "RM-94"

Identifying...

Message sent: 0x1b / 0x0005

00 01 00 00 41 | A

Message sent: 0x1b / 0x0006

00 01 00 07 01 00 |

[Received Ack of type 1b, seq: 1]

[Received Ack of type 1b, seq: 2]

[Sending Ack of type 1b, seq: 7]

Message received: 0x1b / 0x001a

01 39 00 01 00 01 41 14 00 10 33 35 39 33 35 37 | 9 A 359357

30 30 31 39 33 34 38 35 31 00 | 001934851

Received message type 1b

Received imei 359357001934851

[Sending Ack of type 1b, seq: 0]

Message received: 0x1b / 0x0032

01 39 00 08 00 01 58 2c 00 26 56 20 30 34 2e 35 | 9 X, &V 04.5

30 0a 31 39 2d 31 32 2d 30 35 0a 52 4d 2d 39 34 | 0 19-12-05 RM-94

0a 28 63 29 20 4e 6f 6b 69 61 2e 20 20 0a 43 00 | (c) Nokia. C

00 00 |

Received message type 1b

Received revision V 04.50

model length: 5

Received model RM-94

Found model "RM-94"

Getting SMS Status...

Getting SMS Folder (5) status (2)...

Get message list from the folder (ME)

Message sent: 0x14 / 0x000a

00 01 00 0c 02 05 0f 55 55 55 | UUU

[Received Ack of type 14, seq: 3]

[Sending Ack of type 14, seq: 1]

[Sending Ack of type 14, seq: 2]

[Sending Ack of type 14, seq: 3]

[Sending Ack of type 14, seq: 4]

[Sending Ack of type 14, seq: 5]

[Sending Ack of type 14, seq: 6]

[Sending Ack of type 14, seq: 7]

Message received: 0x14 / 0x0332

01 6a 00 0d 00 00 00 15 00 01 00 02 00 03 00 04 | j

00 05 00 06 00 07 00 08 00 09 00 0a 00 0b 00 0c |

00 0d 00 0e 00 0f 00 10 00 11 00 12 00 13 00 14 |

00 15 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |

00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |

00 00 |

Received message type 14

Message: SMS Folder status received

Message: Number of Entries: 21

Message: IDs of Entries : 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21,

Message sent: 0x14 / 0x0007

00 01 00 08 00 00 01 |

[Received Ack of type 14, seq: 4]

[Sending Ack of type 14, seq: 0]

Message received: 0x14 / 0x0052

01 6a 00 09 00 08 02 0c 02 00 00 96 00 01 00 00 | j

00 00 02 0c 01 00 00 14 00 00 00 00 00 00 05 08 |

00 00 00 00 02 00 05 08 00 00 00 00 01 00 03 0c |

00 0f 00 00 00 0b 00 00 00 00 04 0c 00 0f 00 00 |

00 0a 00 00 00 00 06 08 00 00 00 14 00 28 07 04 | (

00 28 | (

Received message type 14

SMS Status received

Getting SMS #1...

Getting SMS Folders...

Message sent: 0x14 / 0x0006

00 01 00 12 00 00 |

[Received Ack of type 14, seq: 5]

[Sending Ack of type 14, seq: 1]

[Sending Ack of type 14, seq: 2]

[Sending Ack of type 14, seq: 3]

[Sending Ack of type 14, seq: 4]

Message received: 0x14 / 0x01be

01 6a 00 13 00 05 01 58 02 05 00 49 00 6e 00 62 | j X I n b

00 6f 00 78 00 00 00 00 00 00 00 00 00 00 00 00 | o x

00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |

00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 58 | X

03 0a 00 53 00 65 00 6e 00 74 00 20 00 69 00 74 | S e n t i t

00 65 00 6d 00 73 00 00 00 00 00 00 00 00 00 00 | e m s

00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |

00 00 00 00 00 00 01 58 04 10 00 53 00 61 00 76 | X S a v

00 65 00 64 00 20 00 74 00 65 00 78 00 74 00 20 | e d t e x t

00 6d 00 73 00 67 00 73 00 2e 00 00 00 00 00 00 | m s g s .

00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |

00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 58 | X

05 09 00 54 00 65 00 6d 00 70 00 6c 00 61 00 74 | T e m p l a t

00 65 00 73 00 00 00 00 00 00 00 00 00 00 00 00 | e s

00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |

00 00 00 00 00 00 01 58 1a 06 00 4f 00 75 00 74 | X O u t

00 62 00 6f 00 78 00 00 00 00 00 00 00 00 00 00 | b o x

00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |

00 00 00 00 00 00 00 00 00 00 00 00 00 00 |

Received message type 14

Message: 5 SMS Folders received:

folder_id[0]=14

Folder(2) name: Inbox

folder_id[1]=15

Folder(3) name: Sent items

folder_id[2]=16

Folder(4) name: Saved text msgs.

folder_id[3]=17

Folder(5) name: Templates

folder_id[4]=20

Folder(26) name: Outbox

Folder id: 14

Getting SMS Folder (2) status (2)...

Special case IN/OUTBOX in GetSMSFolderStatus!

Get message list from ME

Message sent: 0x14 / 0x000a

00 01 00 0c 02 02 0f 55 55 55 | UUU

[Received Ack of type 14, seq: 6]

[Sending Ack of type 14, seq: 5]

[Sending Ack of type 14, seq: 6]

[Sending Ack of type 14, seq: 7]

[Sending Ack of type 14, seq: 0]

[Sending Ack of type 14, seq: 1]

[Sending Ack of type 14, seq: 2]

[Sending Ack of type 14, seq: 3]

Message received: 0x14 / 0x0332

01 6a 00 0d 00 00 00 00 00 00 00 00 00 00 00 00 | j

00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |

00 00 |

Received message type 14

Message: SMS Folder status received

Message: Number of Entries: 0

Get message list from SM

Message sent: 0x14 / 0x000a

00 01 00 0c 01 02 0f 55 55 55 | UUU

[Received Ack of type 14, seq: 7]

[Sending Ack of type 14, seq: 4]

[Sending Ack of type 14, seq: 5]

[Sending Ack of type 14, seq: 6]

[Sending Ack of type 14, seq: 7]

[Sending Ack of type 14, seq: 0]

[Sending Ack of type 14, seq: 1]

[Sending Ack of type 14, seq: 2]

Message received: 0x14 / 0x0332

01 6a 00 0d 00 00 00 00 00 00 00 00 00 00 00 00 | j

00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |

00 00 |

Received message type 14

Message: SMS Folder status received

Message: Number of Entries: 0

Total number of messages in the folder: 0

Getting SMS from location 0

Getting SMS message (0 in folder 14) status...

Message sent: 0x14 / 0x000a

00 01 00 0e 01 02 00 00 55 55 | UU

[Received Ack of type 14, seq: 0]

[Sending Ack of type 14, seq: 3]

Message received: 0x14 / 0x0006

01 6a 00 0f 02 00 | j

Received message type 14

status not supported?

Getting SMS from location 0

Message sent: 0x14 / 0x000a

00 01 00 02 01 02 00 00 01 00 |

[Received Ack of type 14, seq: 1]

[Sending Ack of type 14, seq: 4]

Message received: 0x14 / 0x000e

01 6a 00 03 02 00 00 00 00 00 00 00 00 00 | j

Received message type 14

Trying to get message #0 in folder #0

It then continues repeating this output until I manually stop it with CTRL+C. (is this normal behaviour?)

It moves any items out of the Inbox to the sql table but still leaves behind anything in the sent items folder on the phone.

Output to smsd.log

30 Dec 2011 10:37:30: Inserting sms from +447********* successful.

30 Dec 2011 10:47:12: Inserting sms from +447********* successful.

I then have to run the command

/usr/sbin/smsd –uroot –p******* -d Nagios_Text –c 127.0.0.1 –m mysql –b IN –f /home/ftladmin/Desktop/smsd.log

Again to move any new items in the inbox (testing)

Do I have to leave the smsd command running all the time instead of manually stopping it with CTRL+C?

How do I get the Sent Items off of the phone as these are the ones I want.

The phone will not ever receive any inbox messages its purely going to be sending out texts from Nagios and that’s it.

All I want in the sql table is the sent items.

I have the 3 default SQL tables after running

mysql -uroot Nagios_Text < /usr/share/doc/gnokii-smsd-mysql/sms.tables.mysql.sql

If I change the –b switch to ME it doesn’t even pull the inbox items off the phone and into SQL

Anybody help me please on how to pull the sent items off the phone and into SQL?

Do I need to create a Sent Items table manually?

Thanks

From:	Andrew Thompson
Subject:	Nokia 6021 - smsd and mysql - pulls out Inbox messages but not Sent items messages
Date:	Fri, 30 Dec 2011 11:27:39 +0000