[SR-Users] [ *SPAM* 2.0 ] Re: Kamailio CDR "best practices"

[Yu Boot]

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!