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