use sqlbox for logging MO,MT,DLR
On Tue, Dec 11, 2018 at 8:42 PM Web Min <meweb...@gmail.com> wrote:
> It delete from dlr table if you are passing dlr_url to update your
> original database
>
> in my case, I have queue table contain the status, sender_id, msg, etc...
> this table is used by my portal, when I send an sms it insert into
> dlr table for while and once I received the DLR status pushed from the
> SMSC, I'm updating my queue table and Kannel delete the record from the dlr
>
> On Tue, Dec 11, 2018 at 6:07 PM christopher kamutumwa <
> chriskamutu...@gmail.com> wrote:
>
>> I have kannel v1.4.4 running properly am able to sending messages and
>> receive dlrs as per access log.
>>
>> but I cant see it getting saved to msql as table dlr in temp_dlr is
>> empty. I have checked bearerbox.log and am getting below action that dlr is
>> getting deleted. How do I resolve this?
>>
>> Bearerbox.log below
>> ………………………………………………………………….
>> removing DLR from database
>> 2018-12-11 14:34:08 [16289] [7] DEBUG: sql: DELETE FROM `dlr` WHERE
>> `smsc`=? AND `ts`=? LIMIT 1
>>
>> ………………………………………………………………………
>>
>> Thanks in advance
>> Chris
>>
>
--
Thanks & Regards,
Vinayak
======================================================================
*Confucius* once said,
"*Life is really simple, but we insist on making it complicated.*"
*Leonardo da Vinci* once said,
"*Simplicity is the ultimate sophistication.*"
*Albert Einstein* once said,
"*Everything should be made as simple as possible, but not simpler.*"
