Re: Sqlbox DCS problem

Hi Semion!

Thanks for your reply!

How exactly should I configure smsbox and sqlbox to act like you describe?
I'm sorry to ask you this, but I'm a newbie to kannel and I'm still
discovering how all the pieces fit together.

Best regards,
Jorge

On Tue, Jan 3, 2012 at 5:51 PM, Semion Spivak <[email protected]> wrote:

> ** Hi Jorge,
>
> To check what should be put to the database, try to connect sqlbox as
> following:
>
> Smsbox <-> sqlbox <-> bearerbox
>
> Then, send a test sms via http request to smsbox, providing it with
> dlr-mask=31 and dlr-url containing url-encoded values. The sqlbox should
> create a correct sql row in the db and pass the message to the bearerbox.
> Also, turn on the sql logging in your db before you check it, to catch the
> insert command.
>
> --
> Sent from my Android phone with K-9 Mail. Please excuse my brevity.
>
>
> Jorge Raimundo <[email protected]> wrote:
>>
>> Hi all!
>>
>> I'm using sqlbox to send messages via SMPP, but I'm getting a very
>> strange problem.
>>
>> I've decided to use smsbox to handle the DLR via the dlr_url.
>>
>> So let me see if I can explain all the situations occurring.
>>
>> *1st insertion on the database:*
>> INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type,
>> dlr_mask, dlr_url) VALUES ('MT', 'MV', '+3519******67', 'Hello world', 2,
>> 31, 'http://my_domain/services/teste.php?type=%d%destination=91******7');
>>
>> As you can see, the URL has an error (it should have type=%d&destination instead
>> of type=%d%destination). This ended up in having a DLR with the status
>> of 8 (!?) not properly registered by the php script since the url is
>> malformed.
>>
>> *2nd insertion on the database:*
>> INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type,
>> dlr_mask, dlr_url) VALUES ('MT', 'MV', '+3519******67', 'Hello world', 2,
>> 31, 'http://my_domain/services/teste.php?type=%d&destination=91******7');
>>
>> This ended up in having a DLR with the status of 16 properly registered
>> by my php script (yes, it works with the dlr_url not encoded).
>>
>> At this point I contacted the support of my provider to know why they
>> where rejecting my messages. They told me that the messages where being
>> sent with DCS=216. They told me to set DCS to 1 if I'm sending 7-bit
>> messages or DCS to 3 or 0 if I'm submitting ISO (8-bit message).
>>
>> In fact on the smsc log I have this: data_coding: 216 = 0x000000d8
>>
>> *3rd insertion on the database:*
>> Wondering why the change on the dlr_url gave different DLR status, I made
>> the following
>> INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type,
>> dlr_mask, dlr_url) VALUES ('MT', 'MV', '+3519******67', 'Hello world', 2,
>> 31, '7');
>>
>> This ended up in having a DLR with the status of 0. Yes, I received the
>> message, but... the text was this: 䡥汬漠睯牬搀
>>
>> The smsc log still gives: data_coding: 216 = 0x000000d8
>>
>> *4th insertion on the database:*
>> Testing what would happen if I passed a URL encoded dlr_url
>> INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type,
>> dlr_mask, dlr_url) VALUES ('MT', 'MV', '+3519******67', 'Hello world', 2,
>> 31,
>> 'http%3A%2F%2Fmy_domain%2Fservices%2Fteste.php%3Ftype%3D%25d%26destination%3D91******7');
>>
>> This ended up in having a DLR with the status of 0. I received the same
>> text: 䡥汬漠睯牬搀
>> The smsc log still gives: data_coding: 216 = 0x000000d8
>> The smsbox complains that:
>> ERROR: URL
>> <http%3A%2F%2Fmy_domain%2Fservices%2Fteste.php%3Ftype%3D%25d%26destination%3D91******7>
>> doesn't start with `http://' nor `https://'
>> ERROR: Couldn't send request to
>> <http%3A%2F%2Fmy_domain%2Fservices%2Fteste.php%3Ftype%3D%25d%26destination%3D91******7>
>>
>> *Summarizing:*
>> I don't know what's happening here.
>> Different values of the dlr_url cause different SMSC reactions to the
>> request.
>> The DCS value is strange and I'm getting Chinese characters when I should
>> receive a "Hello world".
>>
>> Anyone could, please, point out what I am missing here?
>>
>> --
>>
>>   [image: Multivision] *Jorge Raimundo
>> *  RAN Consultant | [email protected]  .  Rua António Albino
>> Machado, Nº33, 2ºB.  S. Domingos de Benfica, 1600 - 870 Lisboa  Fixed PT:
>>  +351 21 155 20 53 | Mobile PT: +351 91 933 13 67  www.multivision.pt
>>
>>


-- 

  [image: Multivision] *Jorge Raimundo
*  RAN Consultant | [email protected]  .  Rua António Albino
Machado, Nº33, 2ºB.  S. Domingos de Benfica, 1600 - 870 Lisboa  Fixed PT: +351
21 155 20 53 | Mobile PT: +351 91 933 13 67  www.multivision.pt