<!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.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Account is not compiled with MySQL support by
default. Simply uncomment the line</FONT></DIV>
<DIV><FONT face=Arial size=2># DEFS+=-DSQL_ACC<BR>and recompile
again.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>But actually, if you want to leverage Acc module
for CDR, you'll get disappointed probably. In normal situation, you have no
problem. The trouble is, your account information is based on the SIP message
exchange through the ser proxy. If a called failed after establishment and no
further message is sent by UAC and UAS. If ser proxy queries both side of a call
at certain intervals, that will be ok. However, I am not sure if SIP supports
such status query.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Younger Wang</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=greg@august.net href="mailto:greg@august.net">Greg Fausak</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=dg@nefacomp.net
href="mailto:dg@nefacomp.net">'Director General: NEFACOMP'</A> ; <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 2:38 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [Serusers] Accounting with
SER</DIV>
<DIV><BR></DIV>
<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>
<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>