FreePBX call logs are Empty

Problem: I had FreePBX reports working. Then I decided to dump CDR records into a CSV so that i could try out SAMReports. Now, when I click on reports tab in FreePBX, it says “No data found !!!”. I am trying to bring the data back to mysql and FreePBX.

So here is what i have tried:

  1. CLI> cdr show status

Call Detail Record (CDR) settings

Logging: Enabled
Mode: Simple
Log unanswered calls: No

  • Registered Backends


2)CLI> module show like cdr
Module Description Use Count Call Detail Record (CDR) dialplan functi 0 Tell Asterisk to not maintain a CDR for 0 Asterisk Manager Interface CDR Backend 0 Fork The CDR into 2 separate entities 0 Customizable syslog CDR Backend 0
5 modules loaded

3)CLI> module load
Unable to load module
Command ‘module load’ failed.

4)[[email protected]***** modules]# ls | grep cdr

that means the file is there. but asterisk wont load it for some reason.

  1. nano /etc/asterisk/cdr_mysql.conf
    hostname = localhost
    password = *******
    user = ******

  2. i logged in with the credentials and into mysql and was able to connect to the database and did
    mysql> select * from cdr;
    Empty set (0.00 sec)

for some reason the table is completely empty.

  1. I have tried yum install asterisk-addons-mysql and that told me that files were conflicting with existing ones.

I have ran out of options. Does anyone see what am I missing???

Please help.

You don’t say anything about your platform,OS/Distro, how you built Asterisk etc.
But there is normally a csv file with the callrecords in it already:-


Do you have that file? I am suspicious as at least the csv back-end should be registered. . . .


I have CSV file. However, i thought that CSV was preventing my calls from being inserted into mysql so i unregistered/unloaded the

Linux Distribution: (Redhat CentOS release 5.8 (Final))
FreePBX version: (2.9.0)

so reload it while you try to remember what you changed to stop from loading. The cdr backends can all work at once, Master.csv isprobably all you needed from the start.

But that is the problem. Any module i try to load, asterisk comes back with:

CLI> module load
Unable to load module
Command ‘module load’ failed.

should I restart asterisk?