You can use sqlbox to get reports in the MySQL DB. dlr table is only for temporary tracking of DLR reports.
2016-01-18 16:44 GMT+03:00 Achyut Raj <de...@bongolive.co.tz>: > Hi Deins, > > It is the normal behaviour of Kannel /SQLBOX. > Actually the dlr table is used to hold the dlr for receiving the dlr's. > Record on this table will be removed once dlr is received. For your > convenience see the highlighted text below : > > DLR: received 33250, sent 0 > DLR: inbound (0.00,0.01,0.13) msg/sec, outbound (0.00,0.00,0.00) msg/sec > *DLR: 80412 queued*, using mysql storage > > > To store the dlr status permanently you can > 1) make create new table and use of dlr-mask and dlr-url parameters while > sending message and develop the php script or the script of any language of > your choice to receive and store dlr. > Ref : http://www.kannel.org/pipermail/users/2008-June/005035.html > > 2) make use of some mysql triggers to store the dlr > Ref : http://www.blogalex.com/archives/322 > > > On Mon, Jan 18, 2016 at 4:11 PM, Deins <notabenaaba...@gmail.com> wrote: > >> Hi! >> Sorry for my english. >> I'm try to set up mySQL dlr storage. It works, but not the way I want it. >> When delievery-sm comes to kannel it does two sql transactions. >> >> 1. It writes dlr record >> DEBUG: sql: INSERT INTO dlr (smsc, ts, source, destination, service, url, >> boxc, status) VALUES ('myprovider-smsc', '569CC8480000', 'MYNUM', >> 'myservice', '', '1', '', '0') >> 2. Then it delete record just written >> DEBUG: sql: DELETE FROM dlr WHERE smsc='myprovider-smsc' AND >> ts='569CC8480000' LIMIT 1 >> >> As a result I have empty dlr table. Is it normal behavior of kannel and >> how to stop it, because I need to store delivery records? >> >> >