You are absolutely right. There are 2 valid sqlbox configurations:
smsbox->sqlbox->bb->smsc
and
smsbox
sqlbox -> bb -> smsc
Sorry, before I got confused about the urlencoding comment. In both cases
text inserted to the DB should be UTF-8 (I haven't seen the source, though).
libiconv is used to convert all iso to UTF-8 and the reverse. libiconv
doesn't support GSM. Kannel uses its own functions for gsm conversions.
Please post in hex what you insert in send_sms as UTF-8 and the
corresponding bblog when it receives it from sqlbox and when it sends it to
the SMSc.
BR,
Nikos
----- Original Message -----
From: Andreas Bergman
To: Nikos Balkanas
Cc: Rene Kluwen ; [email protected]
Sent: Sunday, May 22, 2011 5:40 PM
Subject: 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 <[email protected]>
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: [email protected]
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 <[email protected]>
Try to urlencode the message before inserting.
Ξ’
From: [email protected] [mailto:[email protected]] On Behalf
Of Andreas Bergman
Sent: Sunday, 22 May, 2011 15:01
To: [email protected]
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 = 0x00000004
2011-05-22 15:00:01 [12051] [6] DEBUG:Ξ’ Ξ’ Β command_status: 0 = 0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG:Ξ’ Ξ’ Β sequence_number: 8 =
0x00000008
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 =
0x00000005
2011-05-22 15:00:01 [12051] [6] DEBUG:Ξ’ Ξ’ Β source_addr_npi: 0 =
0x00000000
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 = 0x00000001
2011-05-22 15:00:01 [12051] [6] DEBUG:Ξ’ Ξ’ Β dest_addr_npi: 1 = 0x00000001
2011-05-22 15:00:01 [12051] [6] DEBUG:Ξ’ Ξ’ Β destination_addr:
"46708768300"
2011-05-22 15:00:01 [12051] [6] DEBUG:Ξ’ Ξ’ Β esm_class: 3 = 0x00000003
2011-05-22 15:00:01 [12051] [6] DEBUG:Ξ’ Ξ’ Β protocol_id: 0 = 0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG:Ξ’ Ξ’ Β priority_flag: 0 = 0x00000000
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 =
0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG:Ξ’ Ξ’ Β replace_if_present_flag: 0 =
0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG:Ξ’ Ξ’ Β data_coding: 0 = 0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG:Ξ’ Ξ’ Β sm_default_msg_id: 0 =
0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG:Ξ’ Ξ’ Β sm_length: 1 = 0x00000001
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 =
0x80000004
2011-05-22 15:00:01 [12051] [6] DEBUG:Ξ’ Ξ’ Β command_status: 0 = 0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG:Ξ’ Ξ’ Β sequence_number: 8 =
0x00000008
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 <[email protected]>
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: [email protected]
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
[email protected]
--
Andreas Bergman
www.abergman.se
0708-768300
[email protected]
--
Andreas Bergman
www.abergman.se
0708-768300
[email protected]
--
Andreas Bergman
www.abergman.se
0708-768300
[email protected]
