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