<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Thanks Greg,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am writing a Perl script for this. If it
doesn't work ok then I will contact Andy.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2>Ricardo</FONT></DIV>
<BLOCKQUOTE dir=ltr
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=greg@august.net href="mailto:greg@august.net">Greg Fausak</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=ricvil@epm.net.co
href="mailto:ricvil@epm.net.co">'Ricardo Villa'</A> ; <A
title=serusers@lists.iptel.org
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=sip@august.net
href="mailto:sip@august.net">sip@august.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, March 25, 2003 7:21
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [Serusers] Accounting
Script</DIV>
<DIV><BR></DIV>
<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></BLOCKQUOTE></BODY></HTML>