20 Apr
2012
20 Apr
'12
6:04 p.m.
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
20 Apr
20 Apr
6:15 p.m.
Hi Pirijo,
try
#!define WITH_ACCDB
in your kamailio.cfg
--
Mit freundlichen Grüßen
*Karsten Horsmann*
6:21 p.m.
Hi Karsten,
Thanks for the tip, I do have that defined but no cdrs.
cheers,
Pirjo
20. huhtikuuta 2012 16.15 Karsten Horsmann <khorsmann(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
--
Pirjo Ahvenainen
+35844 559 7729
10:48 p.m.
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(a)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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
11:05 p.m.
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(a)foo-lounge.de> kirjoitti:
Hey Pirjo,
Am 20.04.2012 um 15:21 schrieb Pirjo Ahvenainen:
--
--
Pirjo Ahvenainen
+35844 559 7729
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(a)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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
23 Apr
23 Apr
8:15 p.m.
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
20. huhtikuuta 2012 20.48 Timo Reimann
<sr(a)foo-lounge.de> kirjoitti:
Hey Pirjo,
Am 20.04.2012 um 15:21 schrieb Pirjo Ahvenainen:
--
--
Pirjo Ahvenainen
+35844 559 7729 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(a)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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
24 Apr
24 Apr
1:57 a.m.
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(a)foo-lounge.de> kirjoitti:
Hey Pirjo,
sorry for the delay!
Am 20.04.2012 um 20:05 schrieb Pirjo Ahvenainen:
--
--
Pirjo Ahvenainen
+35844 559 7729
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
20. huhtikuuta 2012 20.48 Timo Reimann
<sr(a)foo-lounge.de> kirjoitti:
Hey Pirjo,
Am 20.04.2012 um 15:21 schrieb Pirjo Ahvenainen:
--
--
Pirjo Ahvenainen
+35844 559 7729 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(a)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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
26 Apr
26 Apr
midnight
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
23. huhtikuuta 2012 18.15 Timo Reimann <sr(a)foo-lounge.de> kirjoitti:
Hey Pirjo,
sorry for the delay!
Am 20.04.2012 um 20:05 schrieb Pirjo Ahvenainen:
--
--
Pirjo Ahvenainen
+35844 559 7729 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
20. huhtikuuta 2012 20.48 Timo Reimann
<sr(a)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(a)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(a)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(a)lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
--
Pirjo Ahvenainen
+35844 559 7729
3:57 a.m.
Am 25.04.2012 um 21:00 schrieb Timo Reimann:
Am 23.04.2012 um 22:57 schrieb Pirjo Ahvenainen:
Done! (See commit caee2de.)
HTH,
--Timo
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. 23. huhtikuuta
2012 18.15 Timo Reimann <sr(a)foo-lounge.de> kirjoitti:
_______________________________________________
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 Hey Pirjo,
sorry for the delay!
Am 20.04.2012 um 20:05 schrieb Pirjo Ahvenainen:
--
--
Pirjo Ahvenainen
+35844 559 7729 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
20. huhtikuuta 2012 20.48 Timo Reimann
<sr(a)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(a)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(a)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(a)lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
--
--
Pirjo Ahvenainen
+35844 559 7729
2:17 p.m.
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(a)foo-lounge.de> kirjoitti:
Am 25.04.2012 um 21:00 schrieb Timo Reimann:
--
--
Pirjo Ahvenainen
+35844 559 7729
Am 23.04.2012 um 22:57 schrieb Pirjo Ahvenainen:
Done! (See commit caee2de.)
HTH,
--Timo
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. 23.
huhtikuuta 2012 18.15 Timo Reimann <sr(a)foo-lounge.de> kirjoitti:
_______________________________________________
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 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
> 20. huhtikuuta 2012 20.48 Timo Reimann <sr(a)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(a)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(a)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(a)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
4393
days inactive
4399
days old
9 comments
3 participants
participants (3)
-
Karsten Horsmann -
Pirjo Ahvenainen -
Timo Reimann