CDR CSV with date and time problems

General Help
1

Hi friends. I’ve configured the cdr.conf to enable the creation of a CSV file, according to https://wiki.freepbx.org/display/FPG/Enable+CSV+of+CDRs. The thing is that the CDR does not reflect the date and time properly meaning at least 6 hours of difference from actual CDR, which can be visualised in the web. I cron a task that ntpdate takes from an external ntp server. I have configured date and time in FreePBX according https://wiki.freepbx.org/display/PPS/Time+and+NTP ,which I did a long time ago. How this would happen?

2

My guess is that you are in CentralStandardTime (check from bash date +’%Z %z’)

http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/asterisk-SysAdmin-SECT-1.html

make sure you don’t have

usegmtime yes set

3

usegmtime was set to yes. After setting it to no and fwconsole restart, problem solved. Thanks!

4

By the way, do you know how big the CSV file can be?
Does FreePBX has implemented a script or task to ´´rotate´´ this file?

5

In /etc/logrotate.d/asterisk

if you have

/var/log/asterisk/cdr-csv/*csv {
su root asterisk
missingok
rotate 5
size 100G
create 0640 asterisk asterisk
}

You would rotate every time it got to 100G , for other choices like number or whatever

man logrotate

1 Like
6

I think that will do the work. Thanks!

7

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.