Might be something with your setup. Are you sure DLRs are receiving? Can you check sent_sms table, is there any DLR entries?
About dlr table: I strongly suggest adding indexes there for speeding things up. If you're inserting message into send_sms with dlr_mask!=NULL kannel automatically adds relevant entry into dlr table to keep track of the DLR, after DLR is received kannel deletes entry from dlr table and moves DLR entry into sent_sms table. It's bit weird that your dlr table has over 8mln of entries, something is wrong with your setup. Regards 2012/4/3 Tapan Thapa <[email protected]> > Hello Community, > > I had enabled dlr-storage under kannel to store delivery report in mysql > database and now dlr table is having more then 8 (.8 million) lacs records. > > Can any one let me know how should i delete old dlr from database for > which i have not received the delivery report since last 10 days? > > Thanks in advance. > > Regards > Tapan Thapa >
