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