31 Jul
2017
31 Jul
'17
7:18 a.m.
How to make Kamailio write "normal" CDRs? acc cdr module writes start
time and end time in unixtime format, that is very uncomfortable.
Fnd stcond question - how to make Kamailio to write CDR in ordinary text
file?
31 Jul
31 Jul
10:35 a.m.
On 31.07.17 13:18, Yu Boot wrote:
How to make Kamailio write "normal" CDRs?
Can you provide more details about what you consider a 'normal' CDR? It
is hard to guess what you expect here.
acc cdr module writes start time and end time in
unixtime format, that
is very uncomfortable.
Which format would you consider more appropriate?
Fnd stcond question - how to make Kamailio to write CDR in ordinary
text file?
You can get accounting records/cdrs into a syslog file, and you can
configure syslog daemon to write those into a dedicated file -- see the
readme of acc module for log facility as well as the manual of your
syslog daemon application.
An alternative is to use db_flatstore module as a database driver.
Cheers,
Daniel
--
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training - www.asipto.com
Kamailio World Conference - www.kamailioworld.com
2 Aug
2 Aug
5:06 a.m.
New subject: [ *SPAM* 2.0 ] Re: Kamailio CDR "best practices"
31.07.2017 17:35, Daniel-Constantin Mierla пишет:
2017-08-02 09:52:43
It was my fault, I make respective field in SQL too short. with enough
varchar() length CDR time-date looks exactly how I wanted.
On 31.07.17 13:18, Yu Boot wrote:
Like Asterisk/FS/Yate one :)
sourceIP (detected with NAT), callerID number, destIP(detected with
NAT), called number, startdate, starttime, duration, release_code
How to make Kamailio write "normal"
CDRs?
Can you provide more details about what you consider a 'normal' CDR?
It
is hard to guess what you expect here. acc cdr module writes start time and end time in
unixtime format, that
is very uncomfortable.
Which format would you consider more appropriate? You can get accounting records/cdrs into a syslog
file, and you can
configure syslog daemon to write those into a dedicated file -- see the
readme of acc module for log facility as well as the manual of your
syslog daemon application.
An alternative is to use db_flatstore module as a database driver.
Thanks so much!
7:17 a.m.
On 02.08.17 11:06, Yu Boot wrote:
31.07.2017 17:35, Daniel-Constantin Mierla пишет:
Many here never did CDRs with something these apps
...
On 31.07.17 13:18, Yu Boot wrote:
Like Asterisk/FS/Yate one :) How to make Kamailio write "normal"
CDRs?
Can you provide more details about what you consider a 'normal' CDR?
It
is hard to guess what you expect here.
sourceIP (detected with NAT), callerID number, destIP(detected with
NAT), called number, startdate, starttime, duration, release_code
See the acc module -- you have the option to get START and STOP records
for each call, or if you use dialog module, you can get one CDR.
For the first option, you need to aggregate START and STOP, one option
is via a stored procedure -- for example, siremis does something like
this, see:
- https://kb.asipto.com/siremis:install40x:accounting
-
https://github.com/asipto/siremis/blob/master/siremis/modules/sipadmin/mod.…
[...]
Cheers,
Daniel
--
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training - www.asipto.com
Kamailio World Conference - www.kamailioworld.com
2704
days inactive
2706
days old
3 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Yu Boot