<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1126" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=260301200-26032003>My
partner (Andy Fullford) wrote our code that does this.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=260301200-26032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=260301200-26032003></SPAN></FONT><FONT face=Arial color=#0000ff
size=2><SPAN class=260301200-26032003>We turned on SER accounting, deliver
via SYSLOG, and have a script that</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=260301200-26032003>scrapes all of that up and creates accounting
records.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=260301200-26032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=260301200-26032003>In
addition, we apply the syslog accounting output from our</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=260301200-26032003>gateway routers to verify the INVITE/BYE sequences.
Finally,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=260301200-26032003>we
populate a database with the results. We were going to</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=260301200-26032003>use
radius, but it didn't quite work right for us. I think what we
have</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=260301200-26032003>cobbled together works really well. We don't have
any 'hanging' calls</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=260301200-26032003>anymore....and even if we did we would catch them with
the gateway</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=260301200-26032003>accounting.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=260301200-26032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=260301200-26032003>We did not think the SER user base would be
interested. We use a postgres database and</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=260301200-26032003>this
doesn't seem to be mainstream. However, if there is interest for
this</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=260301200-26032003>sort
of thing perhaps we could donate it?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=260301200-26032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=260301200-26032003>Anyway, you could respond to <A
href="mailto:sip@august.net">sip@august.net</A> and ask Andy if he
can</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=260301200-26032003>hack
you out a piece of it to do what you want.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=260301200-26032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=260301200-26032003>---greg</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=260301200-26032003>Greg
Fausak</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=260301200-26032003></SPAN></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
serusers-admin@iptel.org [mailto:serusers-admin@lists.iptel.org] <B>On Behalf Of
</B>Ricardo Villa<BR><B>Sent:</B> Tuesday, March 25, 2003 3:53
PM<BR><B>To:</B> serusers@lists.iptel.org<BR><B>Subject:</B> [Serusers] Accounting
Script<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Has anybody developed some sort of crude
accounting script for SER that would match all BYEs with their respective
INVITEs in the syslog file and say how many seconds each call
lasted?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2>Ricardo</FONT></DIV></BLOCKQUOTE></BODY></HTML>