Hi all,
I'm currently playing with accounting and cdrs, and meaning to test cdr record generation. Using Kamailio 3.2.3 on Ubuntu.
My question is how to enable Kamailio to save cdr data into database (MySql in my case)? I have loaded the dialog module and enabled the cdr generation:
modparam("acc", "cdr_enable", 1)
... but no cdrs in db, what else do I need to do? The script is mostly default config, any logic I need to add etc? I'll be fine with the most basic cdrs first and will expand from there.
I do get entries in syslog for invite and bye of the transaction. I assume the cdr recodrs should be visible in cdrs table, but have nothing there.
According to the acc module documentation: "In order to set up CDR generation, you must enable the CDR switch and load the dialog module", does cdr switch here mean the cdr_enable module parameter of the acc module?
cheers, Pirjo
-- Pirjo Ahvenainen +35844 559 7729
Hi Pirijo,
try
#!define WITH_ACCDB
in your kamailio.cfg
Hi Karsten,
Thanks for the tip, I do have that defined but no cdrs.
cheers, Pirjo
20. huhtikuuta 2012 16.15 Karsten Horsmann khorsmann@gmail.com kirjoitti:
Hi Pirijo,
try
#!define WITH_ACCDB
in your kamailio.cfg
-- Mit freundlichen Grüßen *Karsten Horsmann*
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
Hey Pirjo,
Am 20.04.2012 um 15:21 schrieb Pirjo Ahvenainen:
Hi Karsten,
Thanks for the tip, I do have that defined but no cdrs.
cheers, Pirjo
I haven't looked at the acc module in quite a while but to my knowledge, direct-to-DB storage of CDRs is still in the making. The second to last commit messages by Sven Knoblich (7b4567) mentions that the patch is "necessary for the upcoming db-storage of cdr's."
HTH,
--Timo
- huhtikuuta 2012 16.15 Karsten Horsmann khorsmann@gmail.com kirjoitti:
Hi Pirijo,
try
#!define WITH_ACCDB
in your kamailio.cfg
-- Mit freundlichen Grüßen *Karsten Horsmann*
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
--
-- Pirjo Ahvenainen +35844 559 7729
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
Hi Timo and all,
That would sort of make sense... Although, 'kamdbctl create' generates cdrs table along with all others, why have a table (+ 3.2 documentation), with nothing to populate that table in code?
cheers, Pirjo
20. huhtikuuta 2012 20.48 Timo Reimann sr@foo-lounge.de kirjoitti:
Hey Pirjo,
Am 20.04.2012 um 15:21 schrieb Pirjo Ahvenainen:
Hi Karsten,
Thanks for the tip, I do have that defined but no cdrs.
cheers, Pirjo
I haven't looked at the acc module in quite a while but to my knowledge, direct-to-DB storage of CDRs is still in the making. The second to last commit messages by Sven Knoblich (7b4567) mentions that the patch is "necessary for the upcoming db-storage of cdr's."
HTH,
--Timo
- huhtikuuta 2012 16.15 Karsten Horsmann khorsmann@gmail.com kirjoitti:
Hi Pirijo,
try
#!define WITH_ACCDB
in your kamailio.cfg
-- Mit freundlichen Grüßen *Karsten Horsmann*
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
--
-- Pirjo Ahvenainen +35844 559 7729
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
Hey Pirjo,
sorry for the delay!
Am 20.04.2012 um 20:05 schrieb Pirjo Ahvenainen:
That would sort of make sense... Although, 'kamdbctl create' generates cdrs table along with all others, why have a table (+ 3.2 documentation), with nothing to populate that table in code?
I cannot find any instances of the word "cdr" in any file of the util/kamctl and lib/ directories. Are you sure that there are CDR-related tables being created with that script?
With regards to the acc documentation, there's no mentioning of any database storage as far as I can tell. I wrote the original piece of documentation, so unless someone has extended the code base and updated the docs there shouldn't be any reference (yet) to the feature you desire. What the original CDR-generating implementation allowed you to do was to create a syslog-based stream of CDRs similar to how transaction logging works in the acc module. Pumping that CDR stream into a database had to be done via an external process, however.
Cheers,
--Timo
- huhtikuuta 2012 20.48 Timo Reimann sr@foo-lounge.de kirjoitti:
Hey Pirjo,
Am 20.04.2012 um 15:21 schrieb Pirjo Ahvenainen:
Hi Karsten,
Thanks for the tip, I do have that defined but no cdrs.
cheers, Pirjo
I haven't looked at the acc module in quite a while but to my knowledge, direct-to-DB storage of CDRs is still in the making. The second to last commit messages by Sven Knoblich (7b4567) mentions that the patch is "necessary for the upcoming db-storage of cdr's."
HTH,
--Timo
- huhtikuuta 2012 16.15 Karsten Horsmann khorsmann@gmail.com kirjoitti:
Hi Pirijo,
try
#!define WITH_ACCDB
in your kamailio.cfg
-- Mit freundlichen Grüßen *Karsten Horsmann*
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
--
-- Pirjo Ahvenainen +35844 559 7729
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
--
-- Pirjo Ahvenainen +35844 559 7729
Hi,
No prob, and thanks for your comments, I'm suspecting I had installed a devel version on the system I was testing before installing 3.2.3 and had used its db creation scripts. So what I will need to do is go back to testing the right version! ;) I installed a clean box with 3.2.3, no cdrs table vs. the one I had, I'll use that for devel version testing. Next job, I'll try it out with the devel version.
So the cdr to db is on its way, the 3.2 documentation means saving only to syslog. Originally I associated this to the cdrs table I was staring at. I think I can call this myth busted!
Thanks Timo!
cheers, Pirjo
23. huhtikuuta 2012 18.15 Timo Reimann sr@foo-lounge.de kirjoitti:
Hey Pirjo,
sorry for the delay!
Am 20.04.2012 um 20:05 schrieb Pirjo Ahvenainen:
That would sort of make sense... Although, 'kamdbctl create' generates cdrs table along with all others, why have a table (+ 3.2 documentation), with nothing to populate that table in code?
I cannot find any instances of the word "cdr" in any file of the util/kamctl and lib/ directories. Are you sure that there are CDR-related tables being created with that script?
With regards to the acc documentation, there's no mentioning of any database storage as far as I can tell. I wrote the original piece of documentation, so unless someone has extended the code base and updated the docs there shouldn't be any reference (yet) to the feature you desire. What the original CDR-generating implementation allowed you to do was to create a syslog-based stream of CDRs similar to how transaction logging works in the acc module. Pumping that CDR stream into a database had to be done via an external process, however.
Cheers,
--Timo
- huhtikuuta 2012 20.48 Timo Reimann sr@foo-lounge.de kirjoitti:
Hey Pirjo,
Am 20.04.2012 um 15:21 schrieb Pirjo Ahvenainen:
Hi Karsten,
Thanks for the tip, I do have that defined but no cdrs.
cheers, Pirjo
I haven't looked at the acc module in quite a while but to my knowledge, direct-to-DB storage of CDRs is still in the making. The second to last commit messages by Sven Knoblich (7b4567) mentions that the patch is "necessary for the upcoming db-storage of cdr's."
HTH,
--Timo
- huhtikuuta 2012 16.15 Karsten Horsmann khorsmann@gmail.com kirjoitti:
Hi Pirijo,
try
#!define WITH_ACCDB
in your kamailio.cfg
-- Mit freundlichen Grüßen *Karsten Horsmann*
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
--
-- Pirjo Ahvenainen +35844 559 7729
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
--
-- Pirjo Ahvenainen +35844 559 7729
Hey,
Am 23.04.2012 um 22:57 schrieb Pirjo Ahvenainen:
No prob, and thanks for your comments, I'm suspecting I had installed a devel version on the system I was testing before installing 3.2.3 and had used its db creation scripts. So what I will need to do is go back to testing the right version! ;) I installed a clean box with 3.2.3, no cdrs table vs. the one I had, I'll use that for devel version testing. Next job, I'll try it out with the devel version.
So the cdr to db is on its way, the 3.2 documentation means saving only to syslog. Originally I associated this to the cdrs table I was staring at. I think I can call this myth busted!
Admittedly, the docs could be a bit more clear on the fact that CDR generation doesn't involve database storage (yet). Being the original author, I'm the one to blame. :) I'll try to increase documentation accuracy of the acc module as soon as I can get to it.
Thanks and
cheers,
--Timo
- huhtikuuta 2012 18.15 Timo Reimann sr@foo-lounge.de kirjoitti:
Hey Pirjo,
sorry for the delay!
Am 20.04.2012 um 20:05 schrieb Pirjo Ahvenainen:
That would sort of make sense... Although, 'kamdbctl create' generates cdrs table along with all others, why have a table (+ 3.2 documentation), with nothing to populate that table in code?
I cannot find any instances of the word "cdr" in any file of the util/kamctl and lib/ directories. Are you sure that there are CDR-related tables being created with that script?
With regards to the acc documentation, there's no mentioning of any database storage as far as I can tell. I wrote the original piece of documentation, so unless someone has extended the code base and updated the docs there shouldn't be any reference (yet) to the feature you desire. What the original CDR-generating implementation allowed you to do was to create a syslog-based stream of CDRs similar to how transaction logging works in the acc module. Pumping that CDR stream into a database had to be done via an external process, however.
Cheers,
--Timo
- huhtikuuta 2012 20.48 Timo Reimann sr@foo-lounge.de kirjoitti:
Hey Pirjo,
Am 20.04.2012 um 15:21 schrieb Pirjo Ahvenainen:
Hi Karsten,
Thanks for the tip, I do have that defined but no cdrs.
cheers, Pirjo
I haven't looked at the acc module in quite a while but to my knowledge, direct-to-DB storage of CDRs is still in the making. The second to last commit messages by Sven Knoblich (7b4567) mentions that the patch is "necessary for the upcoming db-storage of cdr's."
HTH,
--Timo
- huhtikuuta 2012 16.15 Karsten Horsmann khorsmann@gmail.com kirjoitti:
Hi Pirijo,
try
#!define WITH_ACCDB
in your kamailio.cfg
-- Mit freundlichen Grüßen *Karsten Horsmann*
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
--
-- Pirjo Ahvenainen +35844 559 7729
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
--
-- Pirjo Ahvenainen +35844 559 7729
--
-- Pirjo Ahvenainen +35844 559 7729
Am 25.04.2012 um 21:00 schrieb Timo Reimann:
Am 23.04.2012 um 22:57 schrieb Pirjo Ahvenainen:
No prob, and thanks for your comments, I'm suspecting I had installed a devel version on the system I was testing before installing 3.2.3 and had used its db creation scripts. So what I will need to do is go back to testing the right version! ;) I installed a clean box with 3.2.3, no cdrs table vs. the one I had, I'll use that for devel version testing. Next job, I'll try it out with the devel version.
So the cdr to db is on its way, the 3.2 documentation means saving only to syslog. Originally I associated this to the cdrs table I was staring at. I think I can call this myth busted!
Admittedly, the docs could be a bit more clear on the fact that CDR generation doesn't involve database storage (yet). Being the original author, I'm the one to blame. :) I'll try to increase documentation accuracy of the acc module as soon as I can get to it.
Done! (See commit caee2de.)
HTH,
--Timo
- huhtikuuta 2012 18.15 Timo Reimann sr@foo-lounge.de kirjoitti:
Hey Pirjo,
sorry for the delay!
Am 20.04.2012 um 20:05 schrieb Pirjo Ahvenainen:
That would sort of make sense... Although, 'kamdbctl create' generates cdrs table along with all others, why have a table (+ 3.2 documentation), with nothing to populate that table in code?
I cannot find any instances of the word "cdr" in any file of the util/kamctl and lib/ directories. Are you sure that there are CDR-related tables being created with that script?
With regards to the acc documentation, there's no mentioning of any database storage as far as I can tell. I wrote the original piece of documentation, so unless someone has extended the code base and updated the docs there shouldn't be any reference (yet) to the feature you desire. What the original CDR-generating implementation allowed you to do was to create a syslog-based stream of CDRs similar to how transaction logging works in the acc module. Pumping that CDR stream into a database had to be done via an external process, however.
Cheers,
--Timo
- huhtikuuta 2012 20.48 Timo Reimann sr@foo-lounge.de kirjoitti:
Hey Pirjo,
Am 20.04.2012 um 15:21 schrieb Pirjo Ahvenainen:
Hi Karsten,
Thanks for the tip, I do have that defined but no cdrs.
cheers, Pirjo
I haven't looked at the acc module in quite a while but to my knowledge, direct-to-DB storage of CDRs is still in the making. The second to last commit messages by Sven Knoblich (7b4567) mentions that the patch is "necessary for the upcoming db-storage of cdr's."
HTH,
--Timo
- huhtikuuta 2012 16.15 Karsten Horsmann khorsmann@gmail.com kirjoitti:
> Hi Pirijo, > > try > > #!define WITH_ACCDB > > in your kamailio.cfg > > > -- > Mit freundlichen Grüßen > *Karsten Horsmann* > > _______________________________________________ > 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
--
-- Pirjo Ahvenainen +35844 559 7729
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
--
-- Pirjo Ahvenainen +35844 559 7729
--
-- Pirjo Ahvenainen +35844 559 7729
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
Hi,
Thanks Timo, I think you've done excellent job, the problem was just me using the wrong underlying database version. But all clarifications help me and others I'm sure, thanks!
cheers, Pirjo
26. huhtikuuta 2012 1.57 Timo Reimann sr@foo-lounge.de kirjoitti:
Am 25.04.2012 um 21:00 schrieb Timo Reimann:
Am 23.04.2012 um 22:57 schrieb Pirjo Ahvenainen:
No prob, and thanks for your comments, I'm suspecting I had installed a devel version on the system I was testing before installing 3.2.3 and had used its db creation scripts. So what I will need to do is go back to testing the right version! ;) I installed a clean box with 3.2.3, no cdrs table vs. the one I had, I'll use that for devel version testing. Next job, I'll try it out with the devel version.
So the cdr to db is on its way, the 3.2 documentation means saving only to syslog. Originally I associated this to the cdrs table I was staring at. I think I can call this myth busted!
Admittedly, the docs could be a bit more clear on the fact that CDR generation doesn't involve database storage (yet). Being the original author, I'm the one to blame. :) I'll try to increase documentation accuracy of the acc module as soon as I can get to it.
Done! (See commit caee2de.)
HTH,
--Timo
- huhtikuuta 2012 18.15 Timo Reimann sr@foo-lounge.de kirjoitti:
Hey Pirjo,
sorry for the delay!
Am 20.04.2012 um 20:05 schrieb Pirjo Ahvenainen:
That would sort of make sense... Although, 'kamdbctl create' generates cdrs table along with all others, why have a table (+ 3.2 documentation), with nothing to populate that table in code?
I cannot find any instances of the word "cdr" in any file of the util/kamctl and lib/ directories. Are you sure that there are CDR-related tables being created with that script?
With regards to the acc documentation, there's no mentioning of any database storage as far as I can tell. I wrote the original piece of documentation, so unless someone has extended the code base and updated the docs there shouldn't be any reference (yet) to the feature you desire. What the original CDR-generating implementation allowed you to do was to create a syslog-based stream of CDRs similar to how transaction logging works in the acc module. Pumping that CDR stream into a database had to be done via an external process, however.
Cheers,
--Timo
- huhtikuuta 2012 20.48 Timo Reimann sr@foo-lounge.de kirjoitti:
Hey Pirjo,
Am 20.04.2012 um 15:21 schrieb Pirjo Ahvenainen: > Hi Karsten, > > Thanks for the tip, I do have that defined but no cdrs. > > cheers, > Pirjo
I haven't looked at the acc module in quite a while but to my knowledge, direct-to-DB storage of CDRs is still in the making. The second to last commit messages by Sven Knoblich (7b4567) mentions that the patch is "necessary for the upcoming db-storage of cdr's."
HTH,
--Timo
> 20. huhtikuuta 2012 16.15 Karsten Horsmann khorsmann@gmail.com kirjoitti: >> Hi Pirijo, >> >> try >> >> #!define WITH_ACCDB >> >> in your kamailio.cfg >> >> >> -- >> Mit freundlichen Grüßen >> *Karsten Horsmann* >> >> _______________________________________________ >> 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 > > > > -- > > -- > Pirjo Ahvenainen > +35844 559 7729 > > _______________________________________________ > 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
--
-- Pirjo Ahvenainen +35844 559 7729
--
-- Pirjo Ahvenainen +35844 559 7729
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
-
Karsten Horsmann -
Pirjo Ahvenainen -
Timo Reimann