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
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@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@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
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@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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
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
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
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
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
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@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-
Alex Balashov -
DanB -
Daniel-Constantin Mierla -
Jordan Rinke -
Jorj Bauer -
Victor V. Kustov