<!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.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I wrote a crude little perl script that reads the
SYSLOG and then generates Call Detail Records which are output to MySQL "cdrs"
table and a flat file as well. Its job is to match INVITES to BYES and
then compute the call duration. Works great on RedHat Linux 7.3. Can
easly be modified to work on other platforms.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The syslog in the default install of RH7.3 is in
/var/log/messages</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Attached is the script.</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
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=dg@nefacomp.net href="mailto:dg@nefacomp.net">Director General:
NEFACOMP</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=serusers@lists.iptel.org
href="mailto:serusers@lists.iptel.org">serusers</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, July 07, 2003 3:17 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Serusers] Accounting with
SER</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>I would like to get more information on
accounting with SER.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Ok, I followed the documentation about accounting
but it doesn't give enough information about how to retrieve the accounting
information. It just says that Reports are by DEFAULT sent to the syslog
facility. Where is that syslog? How do I retreive that information? Is it
possible to put that information in the MySQL database? How?</FONT></DIV>
<DIV><FONT face=Arial size=2>That is by DEFAULT; so, is it possible to change
that default location?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Some gurus will realize how NEWBIE I am in the
Linux World.</FONT></DIV>
<DIV><FONT face=Arial size=2>Please help me.</FONT></DIV>
<DIV><FONT face=Arial size=2></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>__________________________________<BR>NZEYIMANA
Emery Fabrice<BR>NEFA Computing Services, Inc.<BR>P.O. Box 5078
Kigali<BR>Office Phone: +250-51 11 06<BR>Office Fax: +250-50 15 19<BR>Mobile:
+250-08517768<BR>Email: <A
href="mailto:dg@nefacomp.net">dg@nefacomp.net</A><BR><A
href="http://www.nefacomp.net/">http://www.nefacomp.net/</A></FONT></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>Serusers mailing
list<BR>serusers@lists.iptel.org<BR>http://lists.iptel.org/mailman/listinfo/serusers<BR></BLOCKQUOTE></BODY></HTML>