Hi To summarize my questions: 1. What is the correct way to account for Kamailio internally-generated BYEs? 2. Using sql_query inside event_route() crashes Kamailio - is this a bug or unexpected usage? Thanks very much! Yufei On 28/02/12 17:06, Yufei Tao wrote: > Hi > > Thanks for your reply! > > I already set the accounting flag like you say. And all normal BYEs are > inserted into the acc table fine. Just internally generated BYEs don't > get inserted in acc table. > > I've done a bit googling and added event_route: > > event_route[tm:local-request] > { > if (is_method("BYE")) { > xlog("L_INFO", "event_route: BYE: callid=$ci, cseq=$cs - internally > generated\n"); > > setflag(FLT_ACC); # do accounting ... > setflag(FLT_ACCFAILED); # ... even if the transaction fails > } > } > > When I have two clients in a call, I disconnect the network for both > clients, so no RTP either direction, which triggered mediaproxy to send > dlg_bye_dlg to Kamailio, which sent BYE to both clients. I can see from > the log that event_route did get executed, and BYE sent to both clients, > but still BYE isn't inserted to acc table. > > The code inside event_route() above is copied from my route[WITHINDLG], > which for client-generated BYEs operates correctly (inserts BYEs into > acc table). But in event_route it didn't work. > > I also tried to use sql_query to insert BYE into acc table in > event_route and it causes Kamailio to crash. Using sql_query to select * > from acc also causes Kamailio to crash. > > Any idea where I've done wrong? I'm very much lost. > > Thank you! > Yufei > >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Mon, 27 Feb 2012 13:21:50 -0500 >> From: Alex Balashov <abalashov(a)evaristesys.com> >> Subject: Re: [SR-Users] How to do accounting for Kamailio-generated >> BYEs? >> To: sr-users(a)lists.sip-router.org >> Message-ID: <4F4BC9BE.8000704(a)evaristesys.com> >> Content-Type: text/plain; charset=ISO-8859-1; format=flowed >> >> On 02/27/2012 12:58 PM, Yufei Tao wrote: >>> Hi >>> >>> I've got a mediaproxy that detects no media, and sends dlg_end_dlg to >>> Kamailio via mi_datagram socket. Then Kamailio sends BYE to both calling >>> parties. It all works fine. But my question is, how to do accounting for >>> these Kamailio-generated BYEs? They don't appear in the acc table. >> In the loose_route() section of the config script, set the accounting >> flag for BYEs, e.g. >> >> if(is_method("BYE")) >> setflag(xx); >> >>