Hi
It seems the issue is most probably with your application. Somehow it is
not inserting the correct charset/code to sqlbox.
What charset defaults your app? and your table?
If you compare the content of two registers one inserted with your app and
one inserted directly are there some differences?
Hope helps
Regards
Alvaro
|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
y GPRS online
Visitenos en www.perusms.com
On Sat, Mar 28, 2015 at 2:29 AM, Ammar Ali <ammarali3...@gmail.com> wrote:
> Hello,
>
> I had three test on UNICODE message:
>
> 1. I sent unicode message from application with coding=2 and charset=utf-8
> using sqlbox. I'm not getting proper message on cell phone.
> 2. I sent unicode message from url with coding=2 and charset=utf-8 using
> send sms service. I'm getting proper message on cell phone.
> 3. I had directly insert into sqlbox insert table 'sqlbox_send_sms' with
> coding=2 and charset=utf-8. I'm getting proper message on cell phone.
>
>
>
> So please suggest me what to do.
>
>
> Thanks and Regards
> Ammar Ali
>
>
> On Sat, Mar 28, 2015 at 11:13 AM, Ammar Ali <ammarali3...@gmail.com>
> wrote:
>
>> Hello Spameden,
>>
>> I have checked my code as well as mysql data. Everything is fine because
>> in sqlbox insert table 'send_sms' msgdata has been inserted with urlencoded
>> properly. Because I have urldecode this msgdata, It gives me correct
>> message that I have inserted into mysql send_sms table.
>>
>>
>> So, Please give me some valuable guidance what to do.
>>
>>
>> Thanks
>> Ammar Ali
>>
>>
>>
>>
>>
>> On Fri, Mar 27, 2015 at 8:59 PM, spameden <spame...@gmail.com> wrote:
>>
>>> Try using charset="utf8" and coding=2 it should work.
>>>
>>> No need to specify alt-charset in the kannel's configuration.
>>>
>>> 2015-03-27 17:39 GMT+03:00 Ammar Ali <ammarali3...@gmail.com>:
>>>
>>>> Hello Spameden,
>>>>
>>>>
>>>> This will be valid value for alt-charset in SMSC group in kannel
>>>> configuration
>>>>
>>>> alt-charset =
>>>> "ASCII;windows-1252;UTF-8;ISO-8859-1;ISO-8859-7;GSM;UTF-16BE"
>>>>
>>>>
>>>>
>>>> Thanks
>>>> Ammar Ali
>>>>
>>>>
>>>>
>>>> On Fri, Mar 27, 2015 at 8:00 PM, spameden <spame...@gmail.com> wrote:
>>>>
>>>>>
>>>>>
>>>>> 2015-03-27 16:31 GMT+03:00 Ammar Ali <ammarali3...@gmail.com>:
>>>>>
>>>>>> Hello Spameden,
>>>>>>
>>>>>> I have one more issue regarding smsc connection to the kannel. My
>>>>>> smsc connections are going on reconnection mode again and again.
>>>>>>
>>>>>
>>>>> Most likely you have either a network issue or problem with upstream
>>>>> SMSC, contact your upstream SMSC provider for details.
>>>>>
>>>>>>
>>>>>> This is my SMSC configuration in kannel
>>>>>>
>>>>>> group = smsc
>>>>>> smsc = "smpp"
>>>>>> smsc-id = "smsc1"
>>>>>> log-file = "mysmsc1.log"
>>>>>> log-level = "0"
>>>>>> host = "***.***.***.***"
>>>>>> port = "****"
>>>>>> #receive-port="****"
>>>>>> smsc-username = "******"
>>>>>> smsc-password = "******"
>>>>>> denied-smsc-id = "smsc2"
>>>>>> allowed-smsc-id = "smsc1"
>>>>>> preferred-smsc-id = "smsc1"
>>>>>> source-addr-ton = "0"
>>>>>> source-addr-npi = "1"
>>>>>> dest-addr-ton = "1"
>>>>>> dest-addr-npi = "1"
>>>>>> service-type = "CMT"
>>>>>> #validityperiod = "600"
>>>>>> system-type = "VMA"
>>>>>> alt-charset="us-ascii"
>>>>>> #alt-addr-charset = "GSM"
>>>>>> #address-range = "^$"
>>>>>> #bind-addr-ton = "0"
>>>>>> #bind-addr-npi = "0"
>>>>>> enquire-link-interval = "120"
>>>>>> reconnect-delay = "120"
>>>>>> transceiver-mode = "true"
>>>>>> interface-version = "34"
>>>>>> connection-timeout = "120"
>>>>>> throughput = "100"
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Fri, Mar 27, 2015 at 6:59 PM, Ammar Ali <ammarali3...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> I also use this urlencode function for encoding but not getting
>>>>>>> proper message on cell phone.
>>>>>>>
>>>>>>> On Fri, Mar 27, 2015 at 6:49 PM, spameden <spame...@gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> msgdata needs to be urlencoded, you can use urlencode() php
>>>>>>>> function to do this.
>>>>>>>>
>>>>>>>> 2015-03-27 16:04 GMT+03:00 Ammar Ali <ammarali3...@gmail.com>:
>>>>>>>>
>>>>>>>>> Hello Spameden,
>>>>>>>>>
>>>>>>>>> Yes, I'm currently use latest Kannel Version 1.4.4. I'm inserting
>>>>>>>>> this values in sqlbox_send_sms table:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> *momt=MTsender=123456receiver=99999123456msgdata="unicode
>>>>>>>>> message"smsc_id=smsc1sms_type=2coding=2dlr_mask=31alt_dcs=1*
>>>>>>>>> *charset=utf-8*
>>>>>>>>> I notice one thing, when I'm inserting unicode message into
>>>>>>>>> sqlbox_send_sms table then stored correct sms in this table. But this
>>>>>>>>> table
>>>>>>>>> forward to kannel queue. It convert into codes, So message has not
>>>>>>>>> been
>>>>>>>>> received properly. Only "?" sign.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Please resolve this issue as soon as possible.
>>>>>>>>>
>>>>>>>>> Thanks
>>>>>>>>> Ammar Ali
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Fri, Mar 27, 2015 at 5:10 PM, spameden <spame...@gmail.com>
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> 2015-03-27 13:52 GMT+03:00 Ammar Ali <ammarali3...@gmail.com>:
>>>>>>>>>>
>>>>>>>>>>> Hello Everyone,
>>>>>>>>>>>
>>>>>>>>>>> When I'm sending UNICODE message through URL like:
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> http://192.168.1.1:15010/cgi-bin/sendsms?username=tester2&password=tester2&to=9039238251&text=%E0%A4%AF%E0%A4%B9%20%E0%A4%B8%E0%A4%A8%E0%A5%8D%E0%A4%A6%E0%A5%87%E0%A4%B6%20%E0%A4%B9%E0%A5%88&from=454545&coding=2&charset=utf-8
>>>>>>>>>>>
>>>>>>>>>>> It has been receive correctly. But I'm using SQLBox then it has
>>>>>>>>>>> not been delivered properly.
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Make sure when you insert into database text source encoding is
>>>>>>>>>> UTF-8 and text is urlencoded. Also there was some bug with builds
>>>>>>>>>> posted on
>>>>>>>>>> kannel.org site (specifically kannel-1.5.0 dev build), so make
>>>>>>>>>> sure to use latest kannel version 1.4.4 or better build from SVN
>>>>>>>>>> (which
>>>>>>>>>> contains all the latest fixes and considered as stable).
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> So please check my Kannel configuration and logs. Where is the
>>>>>>>>>>> exact problem.
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> Thanks in advance.
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> Thanks & Regards
>>>>>>>>>>> Ammar Ali
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> ---------- Forwarded message ----------
>>>>>>>>>>> From: Ammar Ali <ammarali3...@gmail.com>
>>>>>>>>>>> Date: Fri, Mar 27, 2015 at 12:27 PM
>>>>>>>>>>> Subject: Unicode Message is not Delivered properly on cell phones
>>>>>>>>>>> To: "users@kannel.org" <users@kannel.org>
>>>>>>>>>>> Cc: Ammar Ali <ammarali3...@gmail.com>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> Hello Everyone,
>>>>>>>>>>>
>>>>>>>>>>> When I'm sending unicode message from my interface then it is
>>>>>>>>>>> not delivered properly on cell phones. Only "?" got.
>>>>>>>>>>>
>>>>>>>>>>> I'm using sqlbox for message pushing. When I'm inserting sms
>>>>>>>>>>> into send_sms table then I'm also inserting the value of coding
>>>>>>>>>>> parameter (
>>>>>>>>>>> *coding=2*) and charset parameter (*charset=UTF-8*).
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> This is my whole configuration:
>>>>>>>>>>>
>>>>>>>>>>> #-------------------------------------------------
>>>>>>>>>>> # THIS IS A CONFIGURATION FOR KANNEL
>>>>>>>>>>> #-------------------------------------------------
>>>>>>>>>>> # Single Group "CORE"
>>>>>>>>>>> #-------------------------------------------------
>>>>>>>>>>>
>>>>>>>>>>> group = core
>>>>>>>>>>> admin-port = "15000"
>>>>>>>>>>> admin-port-ssl="no"
>>>>>>>>>>> admin-password = "******"
>>>>>>>>>>> status-password = "******"
>>>>>>>>>>> admin-deny-ip="*.*.*.*"
>>>>>>>>>>> admin-allow-ip="*.*.*.*"
>>>>>>>>>>> smsbox-interface ="127.0.0.1"
>>>>>>>>>>> smsbox-port = "15001"
>>>>>>>>>>> #smsbox-port-ssl="no"
>>>>>>>>>>> log-file = "mykannel.log"
>>>>>>>>>>> log-level = "0"
>>>>>>>>>>> access-log = "myaccess.access"
>>>>>>>>>>> dlr-storage = "internal"
>>>>>>>>>>> sms-incoming-queue-limit = "-1"
>>>>>>>>>>> sms-outgoing-queue-limit = "1000000"
>>>>>>>>>>> smsbox-max-pending = "100"
>>>>>>>>>>> sms-resend-freq = "60"
>>>>>>>>>>> sms-resend-retry = "-1"
>>>>>>>>>>>
>>>>>>>>>>> #-------------------------------------------------
>>>>>>>>>>> # Single Group "smsbox"
>>>>>>>>>>> #-------------------------------------------------
>>>>>>>>>>>
>>>>>>>>>>> group = smsbox
>>>>>>>>>>> smsbox-id = "smsbox"
>>>>>>>>>>> bearerbox-host = "127.0.0.1"
>>>>>>>>>>> bearerbox-port = "15001"
>>>>>>>>>>> sendsms-port = "15010"
>>>>>>>>>>> log-file = "mysmsbox1.log"
>>>>>>>>>>> log-level = "0"
>>>>>>>>>>> access-log="smsaccess1.access"
>>>>>>>>>>> sendsms-chars = "0123456789+ "
>>>>>>>>>>> #max-pending-requests = "512"
>>>>>>>>>>> #sendsms-url="/cgi-bin/sendsms"
>>>>>>>>>>> #global-sender = "123456"
>>>>>>>>>>> #ms-length = "140"
>>>>>>>>>>> #http-request-retry=5
>>>>>>>>>>> mo-recode='1'
>>>>>>>>>>>
>>>>>>>>>>> #-------------------------------------------------
>>>>>>>>>>> # Multi Group "SMSC"
>>>>>>>>>>> #-------------------------------------------------
>>>>>>>>>>>
>>>>>>>>>>> group = smsc
>>>>>>>>>>> smsc = "smpp"
>>>>>>>>>>> smsc-id = "smsc1"
>>>>>>>>>>> log-file = "mysmsc1.log"
>>>>>>>>>>> log-level = "0"
>>>>>>>>>>> host = "***.***.***.***"
>>>>>>>>>>> port = "*****"
>>>>>>>>>>> #receive-port="2776"
>>>>>>>>>>> smsc-username = "*******"
>>>>>>>>>>> smsc-password = "******"
>>>>>>>>>>> denied-smsc-id = "smsc2"
>>>>>>>>>>> allowed-smsc-id = "smsc1"
>>>>>>>>>>> preferred-smsc-id = "smsc1"
>>>>>>>>>>> source-addr-ton = "0"
>>>>>>>>>>> source-addr-npi = "1"
>>>>>>>>>>> dest-addr-ton = "1"
>>>>>>>>>>> dest-addr-npi = "1"
>>>>>>>>>>> service-type = "CMT"
>>>>>>>>>>> validityperiod = "600"
>>>>>>>>>>> system-type = "VMA"
>>>>>>>>>>> alt-charset="us-ascii"
>>>>>>>>>>> #alt-charset =
>>>>>>>>>>> "ASCII;windows-1252;UTF-8;ISO-8859-1;ISO-8859-7;GSM;UTF-16BE"
>>>>>>>>>>> #alt-addr-charset = "GSM"
>>>>>>>>>>> address-range = "^$"
>>>>>>>>>>> bind-addr-ton = "0"
>>>>>>>>>>> bind-addr-npi = "0"
>>>>>>>>>>> enquire-link-interval = "200000"
>>>>>>>>>>> reconnect-delay = "0"
>>>>>>>>>>> transceiver-mode = "true"
>>>>>>>>>>> interface-version = "34"
>>>>>>>>>>> connection-timeout = "0"
>>>>>>>>>>> throughput = "10000000.00"
>>>>>>>>>>> max-pending-submits="10"
>>>>>>>>>>> #reroute="true"
>>>>>>>>>>> #reroute-smsc-id="smsc1"
>>>>>>>>>>> reroute-dlr="true"
>>>>>>>>>>>
>>>>>>>>>>> #-------------------------------------------
>>>>>>>>>>>
>>>>>>>>>>> group = smsc
>>>>>>>>>>> smsc = "smpp"
>>>>>>>>>>> smsc-id = "smsc2"
>>>>>>>>>>> log-file = "mysmsc2.log"
>>>>>>>>>>> log-level = "0"
>>>>>>>>>>> host = "***.***.***.***"
>>>>>>>>>>> port = "****"
>>>>>>>>>>> #receive-port="2776"
>>>>>>>>>>> smsc-username = "*****"
>>>>>>>>>>> smsc-password = "*****"
>>>>>>>>>>> denied-smsc-id = "smsc1"
>>>>>>>>>>> allowed-smsc-id = "smsc2"
>>>>>>>>>>> preferred-smsc-id = "smsc2"
>>>>>>>>>>> source-addr-ton = "0"
>>>>>>>>>>> source-addr-npi = "1"
>>>>>>>>>>> dest-addr-ton = "1"
>>>>>>>>>>> dest-addr-npi = "1"
>>>>>>>>>>> service-type = "CMT"
>>>>>>>>>>> validityperiod = "600"
>>>>>>>>>>> system-type = "VMA"
>>>>>>>>>>> alt-charset="us-ascii"
>>>>>>>>>>> #alt-charset =
>>>>>>>>>>> "ASCII;windows-1252;UTF-8;ISO-8859-1;ISO-8859-7;GSM;UTF-16BE"
>>>>>>>>>>> #alt-addr-charset = "GSM"
>>>>>>>>>>> address-range = "^$"
>>>>>>>>>>> bind-addr-ton = "0"
>>>>>>>>>>> bind-addr-npi = "0"
>>>>>>>>>>> enquire-link-interval = "200000"
>>>>>>>>>>> reconnect-delay = "0"
>>>>>>>>>>> transceiver-mode = "true"
>>>>>>>>>>> interface-version = "34"
>>>>>>>>>>> connection-timeout = "0"
>>>>>>>>>>> throughput = "10000000.00"
>>>>>>>>>>> max-pending-submits="10"
>>>>>>>>>>> #reroute="true"
>>>>>>>>>>> #reroute-smsc-id="smsc2"
>>>>>>>>>>> reroute-dlr="true"
>>>>>>>>>>>
>>>>>>>>>>> #-------------------------------------------------
>>>>>>>>>>> # Multi Group "smsbox-route"
>>>>>>>>>>> #-------------------------------------------------
>>>>>>>>>>>
>>>>>>>>>>> group = smsbox-route
>>>>>>>>>>> smsbox-id = "smsbox"
>>>>>>>>>>> smsc-id = "smsc1"
>>>>>>>>>>>
>>>>>>>>>>> group = smsbox-route
>>>>>>>>>>> smsbox-id = "smsbox"
>>>>>>>>>>> smsc-id = "smsc2"
>>>>>>>>>>>
>>>>>>>>>>> #-------------------------------------------------
>>>>>>>>>>> # Multi Group "sms-service"
>>>>>>>>>>> # There should be always a 'default' service.
>>>>>>>>>>> # This service is used when no other 'sms-service' is applied.
>>>>>>>>>>> #-------------------------------------------------
>>>>>>>>>>>
>>>>>>>>>>> group = sms-service
>>>>>>>>>>> keyword = default
>>>>>>>>>>> text = "No service specified"
>>>>>>>>>>> accept-x-kannel-headers = true
>>>>>>>>>>> #max-messages = 3
>>>>>>>>>>> concatenation = true
>>>>>>>>>>> catch-all = true
>>>>>>>>>>>
>>>>>>>>>>> #-------------------------------------------------
>>>>>>>>>>> # Multi Group "sendsms-user"
>>>>>>>>>>> #-------------------------------------------------
>>>>>>>>>>>
>>>>>>>>>>> group = sendsms-user
>>>>>>>>>>> name = "sendsmsuser1"
>>>>>>>>>>> username = "tester1"
>>>>>>>>>>> password = "tester1"
>>>>>>>>>>> forced-smsc = "smsc1"
>>>>>>>>>>> #default-smsc= "smsc1"
>>>>>>>>>>> #user-allow-ip="*.*.*.*"
>>>>>>>>>>> max-messages="10"
>>>>>>>>>>>
>>>>>>>>>>> group = sendsms-user
>>>>>>>>>>> name = "sendsmsuser2"
>>>>>>>>>>> username = "tester2"
>>>>>>>>>>> password = "tester2"
>>>>>>>>>>> forced-smsc = "smsc2"
>>>>>>>>>>> #default-smsc= "smsc2"
>>>>>>>>>>> user-allow-ip="*.*.*.*"
>>>>>>>>>>> max-messages="10"
>>>>>>>>>>>
>>>>>>>>>>> #-------------------------------------------------
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> Please resolve my problem as soon as possible.
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> Thanks
>>>>>>>>>>> Ammar Ali
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
