Hi,
I am facing some problems.
When i insert into the database using the following query, the dlr_url is
called instantly and it is called as-it-is. i.e. the %i, %p etc. values are
not replced with actual values. After the actual delivery report arrives,
the same url is called again without actual values i.e %i, %t, %P etc. are
passed. Please help.
INSERT INTO send_sms (momt, sender, smsc_id, receiver, msgdata, sms_type,
dlr_mask, dlr_url, boxc_id) VALUES ('MT', '1234', 'smpp-clickatell',
'919067184864', 'Abbe russshuuuu', 2, 31, '
http://192.168.111.151:8085/Kannel_Test/Receive_dlr?message=%25a×tamp=%25t&sender=%25p&receiver=%25P&smsc_id=%25i&dlr_value=%25d&msg_id=%25F&sendsms_user=%25n',
'box1');
On 11 June 2013 13:12, testn4n1 <[email protected]> wrote:
> I am getting this error:
>
> 2013-06-11 12:27:07 [4669] [7] WARNING: DLR[mysql]: DLR from SMSC<smpp>
> for DST<919067184864> not found.
> 2013-06-11 12:27:07 [4669] [7] ERROR: SMPP[smpp]: got DLR but could not
> find message or was not interested in it id<400000007077826>
> dst<919067184864>, type<1>
>
> I read on a blog where it says "try the smsc group parameter "msg-id-type
> = 0x01"
>
> In my configuration, i have already set this but its not working.
>
>
>
> On 11 June 2013 12:12, Jacob Eiler <[email protected]> wrote:
>
>> Hi James
>>
>> It is only the query parameter values part that should be encoded:
>>
>>
>> http://192.168.111.151:8085/Kannel_Test/Recieve_dlr?message=%25a×tamp=%25tetc
>>
>> Jacob Eiler
>> Apide ApS
>> e: [email protected]
>> t: +45 2374 0486
>> w: apide.com
>>
>>
>> Den 11/06/2013 kl. 08.26 skrev testn4n1 <[email protected]>:
>>
>> 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 <[email protected]> wrote:
>>
>>> check page 91 of the guide (Table 6-9. Parameters (Escape Codes))
>>>
>>>
>>> 2013/6/10 testn4n1 <[email protected]>
>>>
>>>> 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 <[email protected]> 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 <[email protected]>
>>>>>
>>>>>> 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 <[email protected]> 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 <[email protected]>
>>>>>>>
>>>>>>>> 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 <[email protected]> wrote:
>>>>>>>>
>>>>>>>>> 2013/6/10 testn4n1 <[email protected]>
>>>>>>>>>
>>>>>>>>>> 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 <[email protected]> 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 <[email protected]>
>>>>>>>>>>>
>>>>>>>>>>>> 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.
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
