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. >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >
