[Users] lot of BYEs missing

[Hakan YASTI]

Hi Nambiar,

try to get an etheral capture for an hour. and check the missed bye from your db with the query you have wrote fro that hour. Get the number of lost bye and check with the calls on ethereal capture whose states are in_call. If they are equal so you are right that the byes are not coming to your proxy. But if bye is coming and you are not writing to your db it is related with your openser.cfg.
Best wishes,
Hakan.

  ----- Original Message ----- 
  From: Jayesh Nambiar 
  To: openser 
  Sent: Tuesday, August 22, 2006 11:03 AM
  Subject: [Users] lot of BYEs missing


  Hi folks,
  I've been using openser for last one year and its working fine. Recently I upgraded my openser to 1.1 stable release which allows me to have more features.
  But for the last 15 days I have had many discrepencies in the accounting. Among 40 clients to whom we provide service, there was one client who had around 15,000 INVITEs without BYEs in a single day. The UA is a Cisco Gateway.
  I am aware of BYEs being missed with openser, but there used to be hardly 2% Byes missing. This is very unusual to me and I suffered huge losses due to this behaviour as all the calls were passed to a pstn gateway.
  The method of authentication that we use for these clients are IP based authentication. I use the function allow_trusted() to get the clients authenticated and make calls. These calls are sent to some Tier1 carriers for pstn termination.

  I wanted to take some expert advice on this issue. 
  - Is there any way that the UA can bypass the Openser after sending INVITE to openser even after record routing function is incorporated in the script.

  - Is there a way that the UA can disconnect calls without sending BYEs to the openser.

  - Are there many risks involved in IP based authentication? I am using IP based authentication as these clients only want to call, they dont want to be called.

  - If this was a problem with all the UAs, I would have thought that there must be some problem with my openser configuration, but this is with one particular client. The same Cisco gateway at other places work perfectly with hardly 1-2% BYEs missing which is affordable.
  This indicates that someone must have intentionaly done this. 

  If someone has come across this problem earlier please share it with me. 

  The query I used to find the INVITEs without BYEs is as follows:
  SELECT
          t1.from_uri as orig_number,
          t1.to_uri as term_number,
          DATE_FORMAT(t1.timestamp, '%a %b %D %Y, %h:%i:%s %p') as
  calldate,
          t1.sip_callid as callid
   FROM
          acc t1
   WHERE
          t1.sip_method='INVITE' AND
          t1.sip_callid NOT IN (SELECT t2.sip_callid FROM acc t2 WHERE
   t2.sip_method = 'BYE').

  Thanks a lot in advance...

  w/regards,
  jayesh



------------------------------------------------------------------------------
  Here's a new way to find what you're looking for - Yahoo! Answers 
  Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW


------------------------------------------------------------------------------


  _______________________________________________
  Users mailing list
  Users at openser.org
  http://openser.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20060822/93a0ae49/attachment.htm