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 <testn...@gmail.com> > 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. >