[OpenSIPS-Users] What would be the best way to get CDRs from opensips considering opensips handles heavy traffic load

[Ben Newlin]

We use the db_flatstore module to have Opensips write the CDRs from the ACC module directly to a file. We have a second application which reads the file and processes the CDRs separately.

Thanks,
Ben Newlin

From: Users <users-bounces at lists.opensips.org> on behalf of Aqs Younas <aqsyounas at gmail.com>
Reply-To: OpenSIPS users mailling list <users at lists.opensips.org>
Date: Saturday, May 5, 2018 at 3:32 AM
To: OpenSIPS users mailling list <users at lists.opensips.org>
Subject: Re: [OpenSIPS-Users] What would be the best way to get CDRs from opensips considering opensips handles heavy traffic load

Thanks for reply. Opensips handles around 2000 concurrent calls with cps of 40 at the peak time. I see when opensips writes in ACC and my portal runs queries on the same table, opensips process almost comes to halt and a restart is always needed to make it alive.

I want opensips to do something like just write CDRS in file/post somewhere or put in rabbitmq queue and do continue with processing sip traffic. Also, i would prefer to have something built-in instead of building my own CDRs.

Best Regards,

Aqs Younas


On Sat, 5 May 2018 at 5:46 AM, Jon Abrams <ffshoh at gmail.com<mailto:ffshoh at gmail.com>> wrote:
If you don't need them immediately, you can use the old fashion write CDRS to syslog. Rotate the log file every so often to process the CDRs. Journald is too slow for this though - you must use rsyslog or syslog-ng.

If you use the builtin OpenSIPS accounting and need results more real-time, then I'd look at RADIUS accounting. If you generate your own CDRs, then there are the event datagram and rabbitmq modules that provide opportunities.
Out of curiosity, what do you consider heavy traffic?
- Jon

On Fri, May 4, 2018 at 4:32 PM, Aqs Younas <aqsyounas at gmail.com<mailto:aqsyounas at gmail.com>> wrote:
Greeting list,

I would like to ask expert option,  how they are getting CDRs from opensips which handles heavy traffic.

Actually I don't want to have opensips mantain database connections and write records in a single table acc.

Best Regards,

Aqs Younas

_______________________________________________
Users mailing list
Users at lists.opensips.org<mailto:Users at lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users<http://lists.opensips.org/cgi-bin/mailman/listinfo/users>

_______________________________________________
Users mailing list
Users at lists.opensips.org<mailto:Users at lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users<http://lists.opensips.org/cgi-bin/mailman/listinfo/users>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20180505/bed8090f/attachment-0001.html>