[Serusers] Accounting with SER

[Ricardo Villa]

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.

The syslog in the default install of RH7.3 is in /var/log/messages

Attached is the script.

Regards,
Ricardo
  ----- Original Message ----- 
  From: Director General: NEFACOMP 
  To: serusers 
  Sent: Monday, July 07, 2003 3:17 PM
  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/20030707/8beeb5b0/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bill.pl
Type: application/octet-stream
Size: 7005 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20030707/8beeb5b0/attachment.obj>