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:
- CLI> cdr show status
Call Detail Record (CDR) settings
Logging: Enabled
Mode: Simple
Log unanswered calls: No
-
Registered Backends
(none)
2)CLI> module show like cdr
Module Description Use Count
func_cdr.so Call Detail Record (CDR) dialplan functi 0
app_cdr.so Tell Asterisk to not maintain a CDR for 0
cdr_manager.so Asterisk Manager Interface CDR Backend 0
app_forkcdr.so Fork The CDR into 2 separate entities 0
cdr_syslog.so Customizable syslog CDR Backend 0
5 modules loaded
3)CLI> module load cdr_mysql.so
Unable to load module cdr_mysql.so
Command ‘module load cdr_mysql.so’ failed.
4)[root@***** modules]# ls | grep cdr
app_cdr.so
app_forkcdr.so
cdr_csv.so
cdr_custom.so
cdr_manager.so
cdr_mysql.so
cdr_syslog.so
func_cdr.so
that means the file is there. but asterisk wont load it for some reason.
-
nano /etc/asterisk/cdr_mysql.conf
[global]
hostname = localhost
dbname=asteriskcdrdb
password = *******
user = ******
userfield=1
;port=3306 -
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.
- 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.