<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi Nambiar,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2>Best wishes,</FONT></DIV>
<DIV><FONT face=Arial size=2>Hakan.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=voip_freak@yahoo.co.in href="mailto:voip_freak@yahoo.co.in">Jayesh
Nambiar</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=users@openser.org
href="mailto:users@openser.org">openser</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, August 22, 2006 11:03
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Users] lot of BYEs
missing</DIV>
<DIV><BR></DIV>Hi folks,<BR>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.<BR>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.<BR>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.<BR>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.<BR><BR>I wanted to take some expert
advice on this issue. <BR>- 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.<BR><BR>- Is there a way that the UA can disconnect
calls without sending BYEs to the openser.<BR><BR>- 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.<BR><BR>- 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.<BR>This indicates that someone must have
intentionaly done this. <BR><BR>If someone has come across this problem
earlier please share it with me. <BR><BR>The query I used to find the INVITEs
without BYEs is as
follows:<BR>SELECT<BR> t1.from_uri
as orig_number,<BR> t1.to_uri as
term_number,<BR>
DATE_FORMAT(t1.timestamp, '%a %b %D %Y, %h:%i:%s %p')
as<BR>calldate,<BR> t1.sip_callid as
callid<BR> FROM<BR> acc
t1<BR> WHERE<BR>
t1.sip_method='INVITE' AND<BR>
t1.sip_callid NOT IN (SELECT t2.sip_callid FROM acc t2
WHERE<BR> t2.sip_method = 'BYE').<BR><BR>Thanks a lot in
advance...<BR><BR>w/regards,<BR>jayesh<BR>
<P>
<HR SIZE=1>
</HR>Here's a new way to find what you're looking for - <A
href="http://us.rd.yahoo.com/mail/in/yanswers/*http://in.answers.yahoo.com/">Yahoo!
Answers</A> <BR>Send FREE SMS to your friend's mobile from Yahoo! Messenger
Version 8. <A
href="http://in.rd.yahoo.com/mail/in/messengertagline/*http://in.messenger.yahoo.com">Get
it NOW</A>
<P>
<HR>
<P></P>_______________________________________________<BR>Users mailing
list<BR>Users@openser.org<BR>http://openser.org/cgi-bin/mailman/listinfo/users<BR></BLOCKQUOTE></BODY></HTML>