i want dlrs but not in the sent_sms table On 10 June 2013 17:04, spameden <[email protected]> wrote:
> 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. >>>>> >>>> >>>> >>> >> >
