Re: sqlbox and åäö
I'm running the latest cvs version, with the unicode fix. The MySQL tables are changed to utf8 and charset is set to utf8 when sending the message. The bblog looks like this when inserting a message into send_sms with msgdata 'åäö' 2011-05-22 15:00:01 [12051] [13] DEBUG: boxc_receiver: sms received 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput (0.00,0.00) 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Manually forced source addr ton = 5, source add npi = 1 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Manually forced dest addr ton = 1, dest add npi = 1 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Sending PDU: 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU 0x1d108f90 dump: 2011-05-22 15:00:01 [12051] [6] DEBUG: type_name: submit_sm 2011-05-22 15:00:01 [12051] [6] DEBUG: command_id: 4 = 0x0004 2011-05-22 15:00:01 [12051] [6] DEBUG: command_status: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: sequence_number: 8 = 0x0008 2011-05-22 15:00:01 [12051] [6] DEBUG: service_type: NULL 2011-05-22 15:00:01 [12051] [6] DEBUG: source_addr_ton: 5 = 0x0005 2011-05-22 15:00:01 [12051] [6] DEBUG: source_addr_npi: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: source_addr: abergman 2011-05-22 15:00:01 [12051] [6] DEBUG: dest_addr_ton: 1 = 0x0001 2011-05-22 15:00:01 [12051] [6] DEBUG: dest_addr_npi: 1 = 0x0001 2011-05-22 15:00:01 [12051] [6] DEBUG: destination_addr: 46708768300 2011-05-22 15:00:01 [12051] [6] DEBUG: esm_class: 3 = 0x0003 2011-05-22 15:00:01 [12051] [6] DEBUG: protocol_id: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: priority_flag: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: schedule_delivery_time: NULL 2011-05-22 15:00:01 [12051] [6] DEBUG: validity_period: NULL 2011-05-22 15:00:01 [12051] [6] DEBUG: registered_delivery: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: replace_if_present_flag: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: data_coding: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: sm_default_msg_id: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: sm_length: 1 = 0x0001 2011-05-22 15:00:01 [12051] [6] DEBUG: short_message: ? 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU dump ends. 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput (1.00,0.00) 2011-05-22 15:00:01 [12051] [13] DEBUG: send_msg: sending msg to boxc: sqlbox 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput (1.00,0.00) 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Got PDU: 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU 0x1d10a0f0 dump: 2011-05-22 15:00:01 [12051] [6] DEBUG: type_name: submit_sm_resp 2011-05-22 15:00:01 [12051] [6] DEBUG: command_id: 2147483652 = 0x8004 2011-05-22 15:00:01 [12051] [6] DEBUG: command_status: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: sequence_number: 8 = 0x0008 2011-05-22 15:00:01 [12051] [6] DEBUG: message_id: 637581306069203840 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU dump ends. 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput (1.00,0.00) Seems like the sqlbox isn't insering the åäö into bearerbox correctly? /A 2011/5/22 Nikos Balkanas nbalka...@gmail.com Hi, there was a long discussion about it in the list for the past 2 weeks. I believe Renee mentioned that sqlbox was patched. Please download latest sqlbox and retry. BR, Nikos - Original Message - From: Andreas Bergman To: users@kannel.org Sent: Sunday, May 22, 2011 1:36 PM Subject: sqlbox and εδφ Hi! When sending εδφ in messages thrugh sqlbox they are changed to ?? i assume this has something to do with unicode chars? The system is en_EN.UTF-8 and in the database it looks correct, is Stipes unicodepatch the solution or? Br Andreas -- Andreas Bergman www.abergman.se 0708-768300 andr...@abergman.se -- Andreas Bergman www.abergman.se 0708-768300 andr...@abergman.se
RE: sqlbox and åäö
Try to urlencode the message before inserting. From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Andreas Bergman Sent: Sunday, 22 May, 2011 15:01 To: us...@vm1.kannel.org Subject: Re: sqlbox and åäö I'm running the latest cvs version, with the unicode fix. The MySQL tables are changed to utf8 and charset is set to utf8 when sending the message. The bblog looks like this when inserting a message into send_sms with msgdata 'åäö' 2011-05-22 15:00:01 [12051] [13] DEBUG: boxc_receiver: sms received 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput (0.00,0.00) 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Manually forced source addr ton = 5, source add npi = 1 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Manually forced dest addr ton = 1, dest add npi = 1 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Sending PDU: 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU 0x1d108f90 dump: 2011-05-22 15:00:01 [12051] [6] DEBUG: type_name: submit_sm 2011-05-22 15:00:01 [12051] [6] DEBUG: command_id: 4 = 0x0004 2011-05-22 15:00:01 [12051] [6] DEBUG: command_status: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: sequence_number: 8 = 0x0008 2011-05-22 15:00:01 [12051] [6] DEBUG: service_type: NULL 2011-05-22 15:00:01 [12051] [6] DEBUG: source_addr_ton: 5 = 0x0005 2011-05-22 15:00:01 [12051] [6] DEBUG: source_addr_npi: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: source_addr: abergman 2011-05-22 15:00:01 [12051] [6] DEBUG: dest_addr_ton: 1 = 0x0001 2011-05-22 15:00:01 [12051] [6] DEBUG: dest_addr_npi: 1 = 0x0001 2011-05-22 15:00:01 [12051] [6] DEBUG: destination_addr: 46708768300 2011-05-22 15:00:01 [12051] [6] DEBUG: esm_class: 3 = 0x0003 2011-05-22 15:00:01 [12051] [6] DEBUG: protocol_id: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: priority_flag: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: schedule_delivery_time: NULL 2011-05-22 15:00:01 [12051] [6] DEBUG: validity_period: NULL 2011-05-22 15:00:01 [12051] [6] DEBUG: registered_delivery: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: replace_if_present_flag: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: data_coding: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: sm_default_msg_id: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: sm_length: 1 = 0x0001 2011-05-22 15:00:01 [12051] [6] DEBUG: short_message: ? 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU dump ends. 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput (1.00,0.00) 2011-05-22 15:00:01 [12051] [13] DEBUG: send_msg: sending msg to boxc: sqlbox 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput (1.00,0.00) 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Got PDU: 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU 0x1d10a0f0 dump: 2011-05-22 15:00:01 [12051] [6] DEBUG: type_name: submit_sm_resp 2011-05-22 15:00:01 [12051] [6] DEBUG: command_id: 2147483652 = 0x8004 2011-05-22 15:00:01 [12051] [6] DEBUG: command_status: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: sequence_number: 8 = 0x0008 2011-05-22 15:00:01 [12051] [6] DEBUG: message_id: 637581306069203840 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU dump ends. 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput (1.00,0.00) Seems like the sqlbox isn't insering the åäö into bearerbox correctly? /A 2011/5/22 Nikos Balkanas nbalka...@gmail.com Hi, there was a long discussion about it in the list for the past 2 weeks. I believe Renee mentioned that sqlbox was patched. Please download latest sqlbox and retry. BR, Nikos - Original Message - From: Andreas Bergman To: users@kannel.org Sent: Sunday, May 22, 2011 1:36 PM Subject: sqlbox and εδφ Hi! When sending εδφ in messages thrugh sqlbox they are changed to ?? i assume this has something to do with unicode chars? The system is en_EN.UTF-8 and in the database it looks correct, is Stipes unicodepatch the solution or? Br Andreas -- Andreas Bergman www.abergman.se 0708-768300 andr...@abergman.se -- Andreas Bergman www.abergman.se 0708-768300 andr...@abergman.se smime.p7s Description: S/MIME cryptographic signature
Re: sqlbox and åäö
I tried that using the php urlencode function but i only got the urlencoded message sent to me. 2011/5/22 Rene Kluwen rene.klu...@chimit.nl Try to urlencode the message before inserting. *From:* users-boun...@kannel.org [mailto:users-boun...@kannel.org] *On Behalf Of *Andreas Bergman *Sent:* Sunday, 22 May, 2011 15:01 *To:* us...@vm1.kannel.org *Subject:* Re: sqlbox and åäö I'm running the latest cvs version, with the unicode fix. The MySQL tables are changed to utf8 and charset is set to utf8 when sending the message. The bblog looks like this when inserting a message into send_sms with msgdata 'åäö' 2011-05-22 15:00:01 [12051] [13] DEBUG: boxc_receiver: sms received 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput (0.00,0.00) 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Manually forced source addr ton = 5, source add npi = 1 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Manually forced dest addr ton = 1, dest add npi = 1 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Sending PDU: 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU 0x1d108f90 dump: 2011-05-22 15:00:01 [12051] [6] DEBUG: type_name: submit_sm 2011-05-22 15:00:01 [12051] [6] DEBUG: command_id: 4 = 0x0004 2011-05-22 15:00:01 [12051] [6] DEBUG: command_status: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: sequence_number: 8 = 0x0008 2011-05-22 15:00:01 [12051] [6] DEBUG: service_type: NULL 2011-05-22 15:00:01 [12051] [6] DEBUG: source_addr_ton: 5 = 0x0005 2011-05-22 15:00:01 [12051] [6] DEBUG: source_addr_npi: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: source_addr: abergman 2011-05-22 15:00:01 [12051] [6] DEBUG: dest_addr_ton: 1 = 0x0001 2011-05-22 15:00:01 [12051] [6] DEBUG: dest_addr_npi: 1 = 0x0001 2011-05-22 15:00:01 [12051] [6] DEBUG: destination_addr: 46708768300 2011-05-22 15:00:01 [12051] [6] DEBUG: esm_class: 3 = 0x0003 2011-05-22 15:00:01 [12051] [6] DEBUG: protocol_id: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: priority_flag: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: schedule_delivery_time: NULL 2011-05-22 15:00:01 [12051] [6] DEBUG: validity_period: NULL 2011-05-22 15:00:01 [12051] [6] DEBUG: registered_delivery: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: replace_if_present_flag: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: data_coding: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: sm_default_msg_id: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: sm_length: 1 = 0x0001 2011-05-22 15:00:01 [12051] [6] DEBUG: short_message: ? 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU dump ends. 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput (1.00,0.00) 2011-05-22 15:00:01 [12051] [13] DEBUG: send_msg: sending msg to boxc: sqlbox 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput (1.00,0.00) 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Got PDU: 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU 0x1d10a0f0 dump: 2011-05-22 15:00:01 [12051] [6] DEBUG: type_name: submit_sm_resp 2011-05-22 15:00:01 [12051] [6] DEBUG: command_id: 2147483652 = 0x8004 2011-05-22 15:00:01 [12051] [6] DEBUG: command_status: 0 = 0x 2011-05-22 15:00:01 [12051] [6] DEBUG: sequence_number: 8 = 0x0008 2011-05-22 15:00:01 [12051] [6] DEBUG: message_id: 637581306069203840 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU dump ends. 2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput (1.00,0.00) Seems like the sqlbox isn't insering the åäö into bearerbox correctly? /A 2011/5/22 Nikos Balkanas nbalka...@gmail.com Hi, there was a long discussion about it in the list for the past 2 weeks. I believe Renee mentioned that sqlbox was patched. Please download latest sqlbox and retry. BR, Nikos - Original Message - From: Andreas Bergman To: users@kannel.org Sent: Sunday, May 22, 2011 1:36 PM Subject: sqlbox and εδφ Hi! When sending εδφ in messages thrugh sqlbox they are changed to ?? i assume this has something to do with unicode chars? The system is en_EN.UTF-8 and in the database it looks correct, is Stipes unicodepatch the solution or? Br Andreas -- Andreas Bergman www.abergman.se 0708-768300 andr...@abergman.se -- Andreas Bergman www.abergman.se 0708-768300 andr...@abergman.se -- Andreas Bergman www.abergman.se 0708-768300 andr...@abergman.se
Re: sqlbox and åäö
I thought the flow was smsbox-sqlbox-bb-smsc since the smsbox is
connecting to a bb port defined in sqbox, or am I wrong?
Anyway, i tried both and the result is the same. But, if i set alt-charset
for the SMSC (which uses GSM 3.38) the ? is replaced by 'eev'.
As I understand kannel uses libiconv to convert from utf8 to GSM 3.38, does
libiconv really support that? or do kannel use it's own libraries? Worth
noticing is also that {} doesnt work, but / do.
UTF8 encoding the chars before putting them into the database didn't make
any difference, or the chars where distorted.
/Andreas
2011/5/22 Nikos Balkanas nbalka...@gmail.com
Hi,
Depends on the flow:
sqlbox - smsbox - bb -smsc
needs urlencoding
sqlbox - bb -smsc
doesn't. Which version do you use?
BR,
Nikos
- Original Message - From: Andreas Bergman
To: Rene Kluwen
Cc: us...@vm1.kannel.org
Sent: Sunday, May 22, 2011 4:31 PM
Subject: Re: sqlbox and εδφ
I tried that using the php urlencode function but i only got the urlencoded
message sent to me.
2011/5/22 Rene Kluwen rene.klu...@chimit.nl
Try to urlencode the message before inserting.
Β
From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf
Of Andreas Bergman
Sent: Sunday, 22 May, 2011 15:01
To: us...@vm1.kannel.org
Subject: Re: sqlbox and åäö
Β
I'm running the latest cvs version, with the unicode fix.
The MySQL tables are changed to utf8 and charset is set to utf8 when
sending the message.
The bblog looks like this when inserting a message into send_sms with
msgdata 'åäö'
2011-05-22 15:00:01 [12051] [13] DEBUG: boxc_receiver: sms received
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput
(0.00,0.00)
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Manually forced
source addr ton = 5, source add npi = 1
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Manually forced dest
addr ton = 1, dest add npi = 1
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Sending PDU:
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU 0x1d108f90 dump:
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β type_name: submit_sm
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β command_id: 4 = 0x0004
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β command_status: 0 = 0x
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β sequence_number: 8 = 0x0008
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β service_type: NULL
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β source_addr_ton: 5 = 0x0005
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β source_addr_npi: 0 = 0x
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β source_addr: abergman
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β dest_addr_ton: 1 = 0x0001
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β dest_addr_npi: 1 = 0x0001
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β destination_addr: 46708768300
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β esm_class: 3 = 0x0003
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β protocol_id: 0 = 0x
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β priority_flag: 0 = 0x
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β schedule_delivery_time: NULL
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β validity_period: NULL
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β registered_delivery: 0 =
0x
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β replace_if_present_flag: 0 =
0x
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β data_coding: 0 = 0x
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β sm_default_msg_id: 0 =
0x
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β sm_length: 1 = 0x0001
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β short_message: ?
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU dump ends.
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput
(1.00,0.00)
2011-05-22 15:00:01 [12051] [13] DEBUG: send_msg: sending msg to boxc:
sqlbox
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput
(1.00,0.00)
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Got PDU:
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU 0x1d10a0f0 dump:
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β type_name: submit_sm_resp
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β command_id: 2147483652 =
0x8004
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β command_status: 0 = 0x
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β sequence_number: 8 = 0x0008
2011-05-22 15:00:01 [12051] [6] DEBUG:Β Β message_id: 637581306069203840
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU dump ends.
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput
(1.00,0.00)
Seems like the sqlbox isn't insering the åäö into bearerbox correctly?
/A
2011/5/22 Nikos Balkanas nbalka...@gmail.com
Hi,
there was a long discussion about it in the list for the past 2 weeks. I
believe Renee mentioned that sqlbox was patched. Please download latest
sqlbox and retry.
BR,
Nikos
- Original Message - From: Andreas
