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