[Users] accounting missing 'BYE'

[Bogdan-Andrei Iancu]

Hi Jayesh,

I'm afraid there is no way to generate proper CDR for a call without BYE 
- if you missed the BYE (due whatever reason), there is no much to do.

Question: even if you restart the proxy, weren't some retransmissions of 
the BYE (if the BYE was generated)?

regards,
bogdan

jayesh nambiar wrote:

> hi everybody,
> Can somebody pls help me with the following issue. I collect my CDR 
> using the following query:
>  
> SELECT t1.from_uri as orig_number,  t1.to_uri as term_number, 
> TIMEDIFF(t2.time, t1.time) as duration,  t1.timestamp as calldate
> FROM acc t1, acc t2 
> WHERE t1.sip_callid = t2.sip_callid AND
> ((t1.fromtag = t2.fromtag and t1.totag = t2.totag) OR
>  (t1.fromtag = t2.totag and t1.totag = t2.fromtag)) AND
> t1.sip_method='INVITE' AND
> t2.sip_method='BYE'
>  
> This query works fine and gives the call duration between an INVITE 
> and BYE discarding the re-invites.
> But recently in the peak calling time, I had to restart my openser for 
> some technical reasons,
> and I think I might have lost some BYEs during this.
> Can somebody pls help me to extract the calls from acc table which has 
> an INVITE but no BYE.
> Will be very thanful to you,
>  
> jayesh.
>
> ------------------------------------------------------------------------
> Yahoo! for Good
> Click here to donate <http://store.yahoo.com/redcross-donate3/> to the 
> Hurricane Katrina relief effort.
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Users mailing list
>Users at openser.org
>http://openser.org/cgi-bin/mailman/listinfo/users
>  
>