If you don't want to receive DLR's you can use different dlr_mask. Read User-Guide about it.
2013/6/10 testn4n1 <[email protected]> > also, i have two dlr entries for every sms sent. the following are these: > > | 11 | DLR | 1234 | 919067184864 | NULL | ACK%2F | 1370495085 | > smpp-nexmo | NULL | NULL | NULL | 3 | NULL | NULL | NULL > | NULL | NULL | NULL | 8 | NULL | NULL | NULL | > NULL | NULL | sqlbox | NULL | NULL | > > > | 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& | > > > On 10 June 2013 17:00, testn4n1 <[email protected]> wrote: > >> 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? >> >> >> 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. >>>> >>> >>> >> >
