Hi,
Try to send iso-8859-7 encoded SMS. Then post any warnings in bb log. I
suspect, it could be that sqlbox is not observing kannel's encoding
standards and sends latin1 instead of UTF-8 to bb.
BR,
Nikos
----- Original Message -----
From: "Mike Nakos" <[email protected]>
To: <[email protected]>
Sent: Saturday, April 30, 2011 3:37 PM
Subject: SMS from sqlbox - Problem when sending more that 160 char with
greek letters
Hello all,
I have a problem when sending SMS with more than 160 characters from
sqlbox.
Specifically, the problem is with greek letters (DELTA, SIGMA etc). All
latin letters transmitted successfully.
I insert the message of sms url-encoded. So, for DELTA I give %10 and so
on.
I also set the field coding to 0.
for ex. the below SMS is sent ok:
INSERT INTO send_sms (momt, sender, receiver, msgdata, time, dlr_mask,
dlr_url, coding)
VALUES('MT', 'mike', '3069XXXXXX', '%10%41', UNIX_TIMESTAMP(), 31,
'myid00001', 0);
But, with more than 160 characters I get ? in place of greek letters.
my configuration is:
group = smsc
smsc = smpp
smsc-id = provider1
host = XXX.XXX.XXX.XXX
port = XXXX
receive-port = XXXX
smsc-username = myusername
smsc-password = mypass
source-addr-ton = 0
source-addr-npi = 1
dest-addr-ton = 1
#dest-addr-np = 1
bind-addr-ton = 0
bind-addr-npi = 1
system-type = "VMA"
enquire-link-interval = 30
reconnect-delay = 10
throughput = 20
validityperiod = 1340
allowed-prefix = "30"
alt-charset = ASCII
and both bearerbox and sqlbox uses mySQL as DB with typical parameters.
When I send SMS with up to 160 chars I get the below output:
==========================================
2011-04-30 08:26:56 [4293] [8] DEBUG: SMPP[provider1]: Manually forced
source addr ton = 0, source add npi = 1
2011-04-30 08:26:56 [4293] [8] DEBUG: SMPP[provider1]: Sending PDU:
2011-04-30 08:26:56 [4293] [8] DEBUG: SMPP PDU 0x81bf7d0 dump:
2011-04-30 08:26:56 [4293] [8] DEBUG: type_name: submit_sm
2011-04-30 08:26:56 [4293] [8] DEBUG: command_id: 4 = 0x00000004
2011-04-30 08:26:56 [4293] [8] DEBUG: command_status: 0 = 0x00000000
2011-04-30 08:26:56 [4293] [8] DEBUG: sequence_number: 3 = 0x00000003
2011-04-30 08:26:56 [4293] [8] DEBUG: service_type: NULL
2011-04-30 08:26:56 [4293] [8] DEBUG: source_addr_ton: 5 = 0x00000005
2011-04-30 08:26:56 [4293] [8] DEBUG: source_addr_npi: 0 = 0x00000000
2011-04-30 08:26:56 [4293] [8] DEBUG: source_addr: "mike307"
2011-04-30 08:26:56 [4293] [8] DEBUG: dest_addr_ton: 2 = 0x00000002
2011-04-30 08:26:56 [4293] [8] DEBUG: dest_addr_npi: 1 = 0x00000001
2011-04-30 08:26:56 [4293] [8] DEBUG: destination_addr: "3069XXXXXX"
2011-04-30 08:26:56 [4293] [8] DEBUG: esm_class: 3 = 0x00000003
2011-04-30 08:26:56 [4293] [8] DEBUG: protocol_id: 0 = 0x00000000
2011-04-30 08:26:56 [4293] [8] DEBUG: priority_flag: 0 = 0x00000000
2011-04-30 08:26:56 [4293] [8] DEBUG: schedule_delivery_time: NULL
2011-04-30 08:26:56 [4293] [8] DEBUG: validity_period:
"110501104656000+"
2011-04-30 08:26:56 [4293] [8] DEBUG: registered_delivery: 1 =
0x00000001
2011-04-30 08:26:56 [4293] [8] DEBUG: replace_if_present_flag: 0 =
0x00000000
2011-04-30 08:26:56 [4293] [8] DEBUG: data_coding: 0 = 0x00000000
2011-04-30 08:26:56 [4293] [8] DEBUG: sm_default_msg_id: 0 = 0x00000000
2011-04-30 08:26:56 [4293] [8] DEBUG: sm_length: 160 = 0x000000a0
2011-04-30 08:26:56 [4293] [8] DEBUG: short_message:
2011-04-30 08:26:56 [4293] [8] DEBUG: Octet string at 0x81bbc80:
2011-04-30 08:26:56 [4293] [8] DEBUG: len: 160
2011-04-30 08:26:56 [4293] [8] DEBUG: size: 161
2011-04-30 08:26:56 [4293] [8] DEBUG: immutable: 0
2011-04-30 08:26:56 [4293] [8] DEBUG: data: 10 10 10 10 10 10 10 10
10 10 10 10 10 10 10 10 ................
2011-04-30 08:26:56 [4293] [8] DEBUG: data: 10 10 10 10 10 10 10 10
10 10 10 10 10 10 10 10 ................
2011-04-30 08:26:56 [4293] [8] DEBUG: data: 10 10 10 10 10 10 10 10
10 10 10 10 10 10 10 10 ................
2011-04-30 08:26:56 [4293] [8] DEBUG: data: 10 10 10 10 10 10 10 10
10 10 10 10 10 10 10 10 ................
2011-04-30 08:26:56 [4293] [8] DEBUG: data: 10 10 10 10 10 10 10 10
10 10 10 10 10 10 10 10 ................
2011-04-30 08:26:56 [4293] [8] DEBUG: data: 10 10 10 10 10 10 10 10
10 10 10 10 10 10 10 10 ................
2011-04-30 08:26:56 [4293] [8] DEBUG: data: 10 10 10 10 10 10 10 10
10 10 10 10 10 10 10 10 ................
2011-04-30 08:26:56 [4293] [8] DEBUG: data: 10 10 10 10 10 10 10 10
10 10 10 10 10 10 10 10 ................
2011-04-30 08:26:56 [4293] [8] DEBUG: data: 10 10 10 10 10 10 10 10
10 10 10 10 10 10 10 10 ................
2011-04-30 08:26:56 [4293] [8] DEBUG: data: 10 10 10 10 10 10 10 10
10 10 10 10 10 10 10 10 ................
2011-04-30 08:26:56 [4293] [8] DEBUG: Octet string dump ends.
2011-04-30 08:26:56 [4293] [8] DEBUG: SMPP PDU dump ends.
As you can see the 160 DELTAS were sent successfully.
When I submit 161 DELTAS I get the below output:
===================================
2011-04-30 08:23:48 [4254] [14] DEBUG: boxc_receiver: sms received
2011-04-30 08:23:48 [4254] [14] DEBUG: new split_parts created 0x81a3c40
2011-04-30 08:23:48 [4254] [14] DEBUG: send_msg: sending msg to boxc:
<mysmsbox>
2011-04-30 08:23:48 [4254] [8] DEBUG: SMPP[provider1]: throughput
(0.00,20.00)
2011-04-30 08:23:48 [4254] [8] DEBUG: SMPP[provider1]: Manually forced
source addr ton = 0, source add npi = 1
2011-04-30 08:23:48 [4254] [8] DEBUG: SMPP[provider1]: Sending PDU:
2011-04-30 08:23:48 [4254] [8] DEBUG: SMPP PDU 0x81bcbc0 dump:
2011-04-30 08:23:48 [4254] [8] DEBUG: type_name: submit_sm
2011-04-30 08:23:48 [4254] [8] DEBUG: command_id: 4 = 0x00000004
2011-04-30 08:23:48 [4254] [8] DEBUG: command_status: 0 = 0x00000000
2011-04-30 08:23:48 [4254] [8] DEBUG: sequence_number: 196 = 0x000000c4
2011-04-30 08:23:48 [4254] [8] DEBUG: service_type: NULL
2011-04-30 08:23:48 [4254] [8] DEBUG: source_addr_ton: 5 = 0x00000005
2011-04-30 08:23:48 [4254] [8] DEBUG: source_addr_npi: 0 = 0x00000000
2011-04-30 08:23:48 [4254] [8] DEBUG: source_addr: "mike304"
2011-04-30 08:23:48 [4254] [8] DEBUG: dest_addr_ton: 2 = 0x00000002
2011-04-30 08:23:48 [4254] [8] DEBUG: dest_addr_npi: 1 = 0x00000001
2011-04-30 08:23:48 [4254] [8] DEBUG: destination_addr: "3069XXXXXX"
2011-04-30 08:23:48 [4254] [8] DEBUG: esm_class: 67 = 0x00000043
2011-04-30 08:23:48 [4254] [8] DEBUG: protocol_id: 0 = 0x00000000
2011-04-30 08:23:48 [4254] [8] DEBUG: priority_flag: 0 = 0x00000000
2011-04-30 08:23:48 [4254] [8] DEBUG: schedule_delivery_time: NULL
2011-04-30 08:23:48 [4254] [8] DEBUG: validity_period:
"110501104348000+"
2011-04-30 08:23:48 [4254] [8] DEBUG: registered_delivery: 1 =
0x00000001
2011-04-30 08:23:48 [4254] [8] DEBUG: replace_if_present_flag: 0 =
0x00000000
2011-04-30 08:23:48 [4254] [8] DEBUG: data_coding: 0 = 0x00000000
2011-04-30 08:23:48 [4254] [8] DEBUG: sm_default_msg_id: 0 = 0x00000000
2011-04-30 08:23:48 [4254] [8] DEBUG: sm_length: 159 = 0x0000009f
2011-04-30 08:23:48 [4254] [8] DEBUG: short_message:
2011-04-30 08:23:48 [4254] [8] DEBUG: Octet string at 0x81ad7b8:
2011-04-30 08:23:48 [4254] [8] DEBUG: len: 159
2011-04-30 08:23:48 [4254] [8] DEBUG: size: 1024
2011-04-30 08:23:48 [4254] [8] DEBUG: immutable: 0
2011-04-30 08:23:48 [4254] [8] DEBUG: data: 05 00 03 03 02 01 3f 3f
3f 3f 3f 3f 3f 3f 3f 3f ......??????????
2011-04-30 08:23:48 [4254] [8] DEBUG: data: 3f 3f 3f 3f 3f 3f 3f 3f
3f 3f 3f 3f 3f 3f 3f 3f ????????????????
2011-04-30 08:23:48 [4254] [8] DEBUG: data: 3f 3f 3f 3f 3f 3f 3f 3f
3f 3f 3f 3f 3f 3f 3f 3f ????????????????
2011-04-30 08:23:48 [4254] [8] DEBUG: data: 3f 3f 3f 3f 3f 3f 3f 3f
3f 3f 3f 3f 3f 3f 3f 3f ????????????????
2011-04-30 08:23:48 [4254] [8] DEBUG: data: 3f 3f 3f 3f 3f 3f 3f 3f
3f 3f 3f 3f 3f 3f 3f 3f ????????????????
2011-04-30 08:23:48 [4254] [8] DEBUG: data: 3f 3f 3f 3f 3f 3f 3f 3f
3f 3f 3f 3f 3f 3f 3f 3f ????????????????
2011-04-30 08:23:48 [4254] [8] DEBUG: data: 3f 3f 3f 3f 3f 3f 3f 3f
3f 3f 3f 3f 3f 3f 3f 3f ????????????????
2011-04-30 08:23:48 [4254] [8] DEBUG: data: 3f 3f 3f 3f 3f 3f 3f 3f
3f 3f 3f 3f 3f 3f 3f 3f ????????????????
2011-04-30 08:23:48 [4254] [8] DEBUG: data: 3f 3f 3f 3f 3f 3f 3f 3f
3f 3f 3f 3f 3f 3f 3f 3f ????????????????
2011-04-30 08:23:48 [4254] [8] DEBUG: data: 3f 3f 3f 3f 3f 3f 3f 3f
3f 3f 3f 3f 3f 3f 3f ???????????????
2011-04-30 08:23:48 [4254] [8] DEBUG: Octet string dump ends.
2011-04-30 08:23:48 [4254] [8] DEBUG: more_messages_to_send: 1 =
0x00000001
2011-04-30 08:23:48 [4254] [8] DEBUG: SMPP PDU dump ends.
2011-04-30 08:23:48 [4254] [8] DEBUG: SMPP[provider1]: throughput
(1.00,20.00)
2011-04-30 08:23:48 [4254] [8] DEBUG: SMPP[provider1]: Manually forced
source addr ton = 0, source add npi = 1
2011-04-30 08:23:48 [4254] [8] DEBUG: SMPP[provider1]: Sending PDU:
2011-04-30 08:23:48 [4254] [8] DEBUG: SMPP PDU 0x81bcbc0 dump:
2011-04-30 08:23:48 [4254] [8] DEBUG: type_name: submit_sm
2011-04-30 08:23:48 [4254] [8] DEBUG: command_id: 4 = 0x00000004
2011-04-30 08:23:48 [4254] [8] DEBUG: command_status: 0 = 0x00000000
2011-04-30 08:23:48 [4254] [8] DEBUG: sequence_number: 197 = 0x000000c5
2011-04-30 08:23:48 [4254] [8] DEBUG: service_type: NULL
2011-04-30 08:23:48 [4254] [8] DEBUG: source_addr_ton: 5 = 0x00000005
2011-04-30 08:23:48 [4254] [8] DEBUG: source_addr_npi: 0 = 0x00000000
2011-04-30 08:23:48 [4254] [8] DEBUG: source_addr: "mike304"
2011-04-30 08:23:48 [4254] [8] DEBUG: dest_addr_ton: 2 = 0x00000002
2011-04-30 08:23:48 [4254] [8] DEBUG: dest_addr_npi: 1 = 0x00000001
2011-04-30 08:23:48 [4254] [8] DEBUG: destination_addr: "3069XXXXXX"
2011-04-30 08:23:48 [4254] [8] DEBUG: esm_class: 67 = 0x00000043
2011-04-30 08:23:48 [4254] [8] DEBUG: protocol_id: 0 = 0x00000000
2011-04-30 08:23:48 [4254] [8] DEBUG: priority_flag: 0 = 0x00000000
2011-04-30 08:23:48 [4254] [8] DEBUG: schedule_delivery_time: NULL
2011-04-30 08:23:48 [4254] [8] DEBUG: validity_period:
"110501104348000+"
2011-04-30 08:23:48 [4254] [8] DEBUG: registered_delivery: 0 =
0x00000000
2011-04-30 08:23:48 [4254] [8] DEBUG: replace_if_present_flag: 0 =
0x00000000
2011-04-30 08:23:48 [4254] [8] DEBUG: data_coding: 0 = 0x00000000
2011-04-30 08:23:48 [4254] [8] DEBUG: sm_default_msg_id: 0 = 0x00000000
2011-04-30 08:23:48 [4254] [8] DEBUG: sm_length: 14 = 0x0000000e
2011-04-30 08:23:48 [4254] [8] DEBUG: short_message:
2011-04-30 08:23:48 [4254] [8] DEBUG: Octet string at 0x81a3f60:
2011-04-30 08:23:48 [4254] [8] DEBUG: len: 14
2011-04-30 08:23:48 [4254] [8] DEBUG: size: 1024
2011-04-30 08:23:48 [4254] [8] DEBUG: immutable: 0
2011-04-30 08:23:48 [4254] [8] DEBUG: data: 05 00 03 03 02 02 3f 3f
3f 3f 3f 3f 3f 3f ......????????
2011-04-30 08:23:48 [4254] [8] DEBUG: Octet string dump ends.
2011-04-30 08:23:48 [4254] [8] DEBUG: SMPP PDU dump ends.
As you can see the concatenation is done: data: 05 00 03 03 02 01
but I something's wrong with the char conversion this time.
Any idea?
Thanks in advance.
Mike Nakos
