<!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.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>Syslog
is a standard unix facility.</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2>Normally, in a standard linux install, you will see</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>a file
named /var/log/messages. That is where the</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2>accounting information will be written.</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>You
can groom this, for instance, if you want to</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>direct
the messages from SER to a special file, using</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>the
syslog facility. You will need to look at the manual</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>page,
ie:</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>man
syslog.conf</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>to get
some ideas about this.</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>The
syslog entries are enabled with the lines:</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2>...</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2>loadmodule "/usr/ser/lib/ser/modules/acc.so"<BR>...</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2>modparam("acc", "log_level", 1)<BR>modparam("acc", "log_flag", 1
)<BR>modparam("acc", "log_fmt", "miocfsu" )<BR>...</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2>route</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2>{</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2>...</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2>
setflag(1);<BR>
setflag(2);<BR>...</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2>}</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>I
can't comment on the accounting module for mysql, but I
imagine</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>that
is described by the accounting README.txt file in the
appropriate</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>module
directory.</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>Our
implementation scans the syslog files and writes into a
postgres</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2>database the call accounting stuff.</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>There
is a bit of a learning curve involved with this. However,
the</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2>programming documentation is very good and this list is great
for</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>when
you get stumped, but only then :-)</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2>---greg</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff size=2>Greg
Fausak</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2>Addaline.com, Inc.</FONT></SPAN></DIV>
<DIV><SPAN class=537022921-07072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </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-bounces@iptel.org [mailto:serusers-bounces@lists.iptel.org] <B>On Behalf Of
</B>Director General: NEFACOMP<BR><B>Sent:</B> Monday, July 07, 2003 3:17
PM<BR><B>To:</B> serusers<BR><B>Subject:</B> [Serusers] Accounting with
SER<BR><BR></FONT></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></BLOCKQUOTE></BODY></HTML>