Hi,
Hi tried the following insert query with the encoded url:
INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, dlr_mask,
dlr_url, boxc_id) VALUES ('MT', '1234', '919067184864', 'Abbe russshuuuu',
2, 31,
'http%3A%2F%2F192.168.111.151%3A8085%2FKannel_Test%2FReceive_dlr%3Fmessage%3D%25a%26timestamp%3D%25t%26sender%3D%25p%26receiver%3D%25P%26smsc_id%3D%25i%26dlr_value%3D%25d%26msg_id%3D%25F%26sendsms_user%3D%25n',
'box1');
Kannel gives the following error:
ERROR: URL
<http%3A%2F%2F192.168.111.151%3A8085%2FKannel_Test%2FReceive_dlr%3Fmessage%3D%25a%26timestamp%3D%25t%26sender%3D%25p%26receiver%3D%25P%26smsc_id%3D%25i%26dlr_value%3D%25d%26msg_id%3D%25F%26sendsms_user%3D%25n>
doesn't start with `http://' nor `https://'
Regards,
James
On 10 June 2013 19:27, spameden <spame...@gmail.com> wrote:
> check page 91 of the guide (Table 6-9. Parameters (Escape Codes))
>
>
> 2013/6/10 testn4n1 <testn...@gmail.com>
>
>> Hi,
>>
>> I read the user-guide. It says about url encoding in the MO Messages
>> section. but it does not specify what are the key and values for the
>> parameters. i.e. which are the common parameters we need to pass in the
>> dlr-url.
>> Only an example is given like this:
>>
>> http://localhost/myscript?...&meta-data=%D&;...
>>
>> can you please tell me which are the other parameters and their values?
>> also, it specifies %D as value for the meta-data key. Is it something
>> that kannel replaces %D with some other value and then calls the specified
>> url? if yes, then what are the other such values for the keys?
>>
>> Regards,
>> James
>>
>>
>> On 10 June 2013 18:23, spameden <spame...@gmail.com> wrote:
>>
>>> Yes, you need to:
>>>
>>> 1) URLENCODE URL before inserting into database
>>> 2) pass parameters into URL, i.e.
>>>
>>> example:
>>> http%3A%2F%2F192.168.111.151%3A8085%2FKannel_Test%2FReceive_dlr%3Fsmsc-id%3D%25i%22%22
>>>
>>> Once again, read user-guide.
>>>
>>>
>>> 2013/6/10 testn4n1 <testn...@gmail.com>
>>>
>>>> ok...the url i provided gets called the second i insert data into the
>>>> send_sms table but no parameters are passed. i printed all the request
>>>> parameters but got nothing.
>>>>
>>>>
>>>> On 10 June 2013 17:58, spameden <spame...@gmail.com> wrote:
>>>>
>>>>> To achieve this you need to put smsbox in between of the sqlbox and
>>>>> bearerbox or enforce smsbox id into boxc_id field, i.e.:
>>>>>
>>>>> INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type,
>>>>> dlr_mask, dlr_url, boxc_id) VALUES ('MT', '1234', '919067184864', 'Abbe
>>>>> russshuuuu', 2, 31, '
>>>>> http://192.168.111.151:8085/Kannel_Test/Receive_dlr', 'smsbox_id');
>>>>>
>>>>>
>>>>>
>>>>> 2013/6/10 testn4n1 <testn...@gmail.com>
>>>>>
>>>>>> i am trying to send sms by inserting data into send_sms table and
>>>>>> want to process dlrs with script using dlr_url. So, i have changed the
>>>>>> configuration to the following but i cannot receive anything in my
>>>>>> application:
>>>>>>
>>>>>>
>>>>>> group = sendsms-user
>>>>>> username = tester
>>>>>> password = foobar
>>>>>> forced-smsc = smpp-nexmo
>>>>>> name = users
>>>>>> dlr-url = http://192.168.111.151:8085/Kannel_Test/Receive_dlr
>>>>>>
>>>>>> #user-deny-ip = "*.*.*.*"
>>>>>> user-allow-ip = "*.*.*.*"
>>>>>> max-messages = 3
>>>>>> concatenation = 1
>>>>>> omit-empty = 1
>>>>>>
>>>>>>
>>>>>> I am executing the following query for inserting the data:
>>>>>>
>>>>>> INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type,
>>>>>> dlr_mask, dlr_url) VALUES ('MT', '1234', '919067184864', 'Abbe
>>>>>> russshuuuu',
>>>>>> 2, 31, 'http://192.168.111.151:8085/Kannel_Test/Receive_dlr');
>>>>>>
>>>>>> The dlr is not routed to my specified url. Can you please tell me
>>>>>> what is wrong here?
>>>>>>
>>>>>> Regards,
>>>>>> James
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On 10 June 2013 17:06, spameden <spame...@gmail.com> wrote:
>>>>>>
>>>>>>> 2013/6/10 testn4n1 <testn...@gmail.com>
>>>>>>>
>>>>>>>> ok...but then why are there entries in my sent_sms table like the
>>>>>>>> following:
>>>>>>>>
>>>>>>>> 12 | DLR | 1234 | 919067184864 | NULL |
>>>>>>>> id%3A288230376265477711+sub%3A001+dlvrd%3A001+submit+date%3A1306061034+done+date%3A1306060504+stat%3ADELIVRD+err%3A000+text%3Anone++++++++++++++++
>>>>>>>> | 1370495099 | smpp-nexmo | NULL | 51dc0ffb | NULL | 3 |
>>>>>>>> NULL |
>>>>>>>> NULL | NULL | NULL | NULL | NULL | 1 | NULL |
>>>>>>>> NULL
>>>>>>>> | NULL | NULL | NULL | sqlbox | NULL | ?smpp?dlr_err=000& |
>>>>>>>>
>>>>>>>> what are the other ways to handle dlr instead of modifying the
>>>>>>>> source?
>>>>>>>
>>>>>>>
>>>>>>> because sqlbox moves everything into sent_sms table.
>>>>>>>
>>>>>>> you can process DLRs with a script supplied to dlr_url
>>>>>>>
>>>>>>> but it would be easier and more proper to modify sqlbox code to
>>>>>>> store where you want them.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On 10 June 2013 16:55, spameden <spame...@gmail.com> wrote:
>>>>>>>>
>>>>>>>>> dlr table only used to track which messages are awaiting reports
>>>>>>>>>
>>>>>>>>> you need to modify sqlbox source if you need to store DLR entries
>>>>>>>>> separately
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> 2013/6/10 testn4n1 <testn...@gmail.com>
>>>>>>>>>
>>>>>>>>>> Hi,
>>>>>>>>>>
>>>>>>>>>> I am able to send sms using sqlbox and able to receive dlr
>>>>>>>>>> reports also. But, these reports do not go in the table that i
>>>>>>>>>> specify.
>>>>>>>>>> Instead, the reports are stored in sent_sms table. Below is my
>>>>>>>>>> configuration:
>>>>>>>>>>
>>>>>>>>>> Kannel.conf
>>>>>>>>>> ------------------
>>>>>>>>>>
>>>>>>>>>> group = core
>>>>>>>>>> admin-port = 13000
>>>>>>>>>> smsbox-port = 13001
>>>>>>>>>> admin-password = bar
>>>>>>>>>> dlr-storage = mysql
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> group = smsbox
>>>>>>>>>> bearerbox-host = 127.0.0.1
>>>>>>>>>> sendsms-port = 13013
>>>>>>>>>> global-sender = 13013
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> group = sendsms-user
>>>>>>>>>> username = tester
>>>>>>>>>> password = foobar
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> group = sms-service
>>>>>>>>>> keyword = nop
>>>>>>>>>> text = "You asked nothing and I did it!"
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> group = smsc
>>>>>>>>>> smsc = smpp
>>>>>>>>>> smsc-id = server1
>>>>>>>>>> host = smpp0.net
>>>>>>>>>> port = 8000
>>>>>>>>>> transceiver-mode = true
>>>>>>>>>> throughput = 10
>>>>>>>>>> smsc-username = **********
>>>>>>>>>> smsc-password = **********
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> group = sendsms-user
>>>>>>>>>> username = tester
>>>>>>>>>> password = foobar
>>>>>>>>>> forced-smsc = server1
>>>>>>>>>> name = users
>>>>>>>>>> #user-deny-ip = "*.*.*.*"
>>>>>>>>>> user-allow-ip = "*.*.*.*"
>>>>>>>>>> max-messages = 3
>>>>>>>>>> concatenation = 1
>>>>>>>>>> omit-empty = 1
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> group = mysql-connection
>>>>>>>>>> id = mydlr
>>>>>>>>>> host = localhost
>>>>>>>>>> username = root
>>>>>>>>>> password = root
>>>>>>>>>> database = kannel
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> group = dlr-db
>>>>>>>>>> id = mydlr
>>>>>>>>>> table = dlr
>>>>>>>>>> field-smsc = smsc
>>>>>>>>>> field-timestamp = ts
>>>>>>>>>> field-source=source
>>>>>>>>>> field-destination = destination
>>>>>>>>>> field-service = service
>>>>>>>>>> field-url = url
>>>>>>>>>> field-mask = mask
>>>>>>>>>> field-status = status
>>>>>>>>>> field-boxc-id = boxc
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> ------------------------------
>>>>>>>>>> ---------------------------------------------
>>>>>>>>>>
>>>>>>>>>> sqlbox.conf
>>>>>>>>>> ------------------
>>>>>>>>>>
>>>>>>>>>> group = sqlbox
>>>>>>>>>> id = sqlbox-db
>>>>>>>>>> smsbox-id = sqlbox
>>>>>>>>>> bearerbox-host = localhost
>>>>>>>>>> bearerbox-port = 13001
>>>>>>>>>> smsbox-port = 13005
>>>>>>>>>> smsbox-port-ssl = false
>>>>>>>>>> sql-log-table = sent_sms
>>>>>>>>>> sql-insert-table = send_sms
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> # MYSQL Connection
>>>>>>>>>> group = mysql-connection
>>>>>>>>>> id = sqlbox-db
>>>>>>>>>> host = localhost
>>>>>>>>>> username = root
>>>>>>>>>> password = root
>>>>>>>>>> database = kannel
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> ---------------------------------------------------------------------------
>>>>>>>>>>
>>>>>>>>>> The sms are sent successfully from send_sms and transferred to
>>>>>>>>>> the table sent_sms but the delivery reports are also stored in the
>>>>>>>>>> same
>>>>>>>>>> table and the dlr table is always empty.
>>>>>>>>>>
>>>>>>>>>> If anyone has come accross this problem, please help me.
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
