[Serusers] Accounting with SER

[Younger Wang]

MessageAccount is not compiled with MySQL support by default. Simply uncomment the line
# DEFS+=-DSQL_ACC
and recompile again.

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.

Younger Wang
  ----- Original Message ----- 
  From: Greg Fausak 
  To: 'Director General: NEFACOMP' ; 'serusers' 
  Sent: Monday, July 07, 2003 2:38 PM
  Subject: RE: [Serusers] Accounting with SER


  Syslog is a standard unix facility.
  Normally, in a standard linux install, you will see
  a file named /var/log/messages.  That is where the
  accounting information will be written.

  You can groom this, for instance, if you want to
  direct the messages from SER to a special file, using
  the syslog facility.  You will need to look at the manual
  page, ie:

  man syslog.conf

  to get some ideas about this.

  The syslog entries are enabled with the lines:

  ...
  loadmodule "/usr/ser/lib/ser/modules/acc.so"
  ...
  modparam("acc", "log_level", 1)
  modparam("acc", "log_flag", 1 )
  modparam("acc", "log_fmt", "miocfsu" )
  ...

  route
  {
  ...
                  setflag(1);
                  setflag(2);
  ...

  }

  I can't comment on the accounting module for mysql, but I imagine
  that is described by the accounting README.txt file in the appropriate
  module directory.

  Our implementation scans the syslog files and writes into a postgres
  database the call accounting stuff.

  There is a bit of a learning curve involved with this.  However, the
  programming documentation is very good and this list is great for
  when you get stumped, but only then :-)

  ---greg
  Greg Fausak
  Addaline.com, Inc.

    -----Original Message-----
    From: serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org] On Behalf Of Director General: NEFACOMP
    Sent: Monday, July 07, 2003 3:17 PM
    To: serusers
    Subject: [Serusers] Accounting with SER


    I would like to get more information on accounting with SER.

    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?
    That is by DEFAULT; so, is it possible to change that default location?

    Some gurus will realize how NEWBIE I am in the Linux World.
    Please help me.


    Thanks,
    __________________________________
    NZEYIMANA Emery Fabrice
    NEFA Computing Services, Inc.
    P.O. Box 5078 Kigali
    Office Phone: +250-51 11 06
    Office Fax: +250-50 15 19
    Mobile: +250-08517768
    Email: dg at nefacomp.net
    http://www.nefacomp.net/


------------------------------------------------------------------------------


  _______________________________________________
  Serusers mailing list
  serusers at lists.iptel.org
  http://lists.iptel.org/mailman/listinfo/serusers
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20030708/e7e21aef/attachment.htm>