Accounting: syslog vs db_flatfile - sr-users - kamailio.org

List overview All Threads
Download

Accounting: syslog vs db_flatfile

Initial REGISTER request/response...

SIP Fragments

DanB

3 Dec 2014 3 Dec '14

11:30 a.m.

Hey Guys, We are in the process to review the interoperability between Kamailio and CGRateS and was wondering what is the best/most recommended/maintained way to generate accounting from Kamailio: * Syslog * db_flatfile * other way maybe? Is CDR generation planned for files already, or just accounting events? Thanks in advance! DanB

Reply

Show replies by date

Alex Balashov

3 Dec 3 Dec

11:56 a.m.

Kamailio has a canonical 'acc' module. But as to the best way to generate accounting, you can do it any way you like. These are a thousand ways to do it, all boiling down to "log call setup, process, failure, answer and teardown events somewhere". On 3 December 2014 05:30:45 GMT-05:00, DanB <danb.lists(a)gmail.com> wrote:

Hey Guys, We are in the process to review the interoperability between Kamailio and CGRateS and was wondering what is the best/most recommended/maintained way to generate accounting from Kamailio: * Syslog * db_flatfile * other way maybe? Is CDR generation planned for files already, or just accounting events? Thanks in advance! DanB _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- Sent from my mobile, and thus lacking in the refinement one might expect from a fully fledged keyboard. Alex Balashov - Principal Evariste Systems LLC 235 E Ponce de Leon Ave Suite 106 Decatur, GA 30030 United States Tel: +1-678-954-0671 Web: http://www.evaristesys.com/, http://www.alexbalashov.com

Reply

Jordan Rinke

12:07 p.m.

Why not just use the acc module for CDR generation and tie CGRateS into the same mysql db storing the generated CDR from kamailio? Looking at the docs it seems CGRateS uses that as it's default CDR store for rating anyways? https://github.com/cgrates/cgrates/tree/master/data/storage/mysql - a lot of the fields look similar to me - I am curious about this now as well. I notice they have a kamailio skeleton etc file so integration is at least on their radar. *Jordan Rinke* *"How can I make your day awesome?"* _______________________________________ Chief Technology Officer Toll free: 888-899-iTEL (4835) Ext. 1019 Direct: (250) 434-8482 iTel.com/.ca On Wed, Dec 3, 2014 at 2:30 AM, DanB <danb.lists(a)gmail.com> wrote:

Hey Guys, We are in the process to review the interoperability between Kamailio and CGRateS and was wondering what is the best/most recommended/maintained way to generate accounting from Kamailio: * Syslog * db_flatfile * other way maybe? Is CDR generation planned for files already, or just accounting events? Thanks in advance! DanB _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Reply

Daniel-Constantin Mierla

12:15 p.m.

Hello, On 03/12/14 11:30, DanB wrote:

Hey Guys, We are in the process to review the interoperability between Kamailio and CGRateS and was wondering what is the best/most recommended/maintained way to generate accounting from Kamailio: * Syslog * db_flatfile * other way maybe?

technically, accounting to db_flatstore is like for any other database connector from acc module point of view, such as db_mysql, db_postgress, db_cassandra, db_mongodb, db_unixodbc, ... Both accounting to syslog and database are very well maintained.

Is CDR generation planned for files already, or just accounting events?

Full cdrs can be written to syslog or database, provided you use dialog module and you enable that feature in acc module. Cheers, Daniel -- Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda

Reply

DanB

12:24 p.m.

Hey Alex, Thank you for your quick answer. I understand what you mean regarding multiple ways of handling accounting. I was hoping about recommendation about best practice, most automated, most used, most maintained one (eg: development of CDR generation going towards syslog and such). For the moment syslog wins :). Cheers, DanB

Reply

DanB

12:26 p.m.

Btw, my preference was db_flatfile due to it's isolation from the rest of the system, however I don't see steps towards it, so prefer to go with most maintained way. Cheers, DanB On 03.12.2014 12:24, DanB wrote:

Hey Alex, Thank you for your quick answer. I understand what you mean regarding multiple ways of handling accounting. I was hoping about recommendation about best practice, most automated, most used, most maintained one (eg: development of CDR generation going towards syslog and such). For the moment syslog wins :). Cheers, DanB

Reply

DanB

4 Dec 4 Dec

12:08 p.m.

Thanks guys for all of your answers! @Daniel: OK, this is good news. I will check both syslog and db_flatfile. @Jorj: the reason I am looking towards a local module is for eliminating the risk of loosing the CDRs on the network. Why flatfile: for simplicity of configuring (vs additional syslog configuration). Plus syslog is shared over the machine so there are increased chances of issues. @Jordan: the CDRs will end up anyway in SQL database (MySQL or Postgres on CGRateS side). I try to avoid inserting the raw cdrs into MySQL directly due to possible load issues on peak times. Once they are on disk, they can be asynchronously processed. And yes, we are working seriously these days to have Kamailio and CGRateS interoperability done (we were planning it since before Kamailio World 2013 but for some reason it got delayed due to our complicated task queue). Have a good one! DanB

Reply

Victor V. Kustov

19 Dec 19 Dec

3:13 p.m.

Hi, DanB! Kamailio has radius accounting too. -- WBR, Victor I use FREE operation system: 3.15.9- GNU/Linux up 2 weeks, 1 day, 5 hours, 22 minutes

Reply

Jorj Bauer

3 Dec 3 Dec

1:31 p.m.

Syslog allows you to configure syslogd to deliver data to a remote host, which can then perform billing and analysis functions without affecting the CPU and disk I/O patterns on the production box. My druthers is always syslog over locally developed mechanisms. Sent from my iPhone

On Dec 3, 2014, at 6:24 AM, DanB <danb.lists(a)gmail.com> wrote: Hey Alex, Thank you for your quick answer. I understand what you mean regarding multiple ways of handling accounting. I was hoping about recommendation about best practice, most automated, most used, most maintained one (eg: development of CDR generation going towards syslog and such). For the moment syslog wins :). Cheers, DanB _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Reply

3436

days inactive

3452

days old

sr-users@lists.kamailio.org

Manage subscription

8 comments

6 participants

tags (0)

participants (6)

Alex Balashov
DanB
Daniel-Constantin Mierla
Jordan Rinke
Jorj Bauer
Victor V. Kustov