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?
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
31.07.2017 17:35, Daniel-Constantin Mierla пишет:
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.
Like Asterisk/FS/Yate one :)
sourceIP (detected with NAT), callerID number, destIP(detected with NAT), called number, startdate, starttime, duration, release_code
acc cdr module writes start time and end time in unixtime format, that is very uncomfortable.
Which format would you consider more appropriate?
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.
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!
On 02.08.17 11:06, Yu Boot wrote:
31.07.2017 17:35, Daniel-Constantin Mierla пишет:
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.
Like Asterisk/FS/Yate one :)
Many here never did CDRs with something these apps ...
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.i...
[...]
Cheers, Daniel
-
Daniel-Constantin Mierla -
Yu Boot