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