Freepbx 13 CDR stopped working

Our CDR stopped working. Trying to figure out whats going on with it. I can login to the Mysql database with

Its running the FreePBX 13 Distro: 10.13.66-21

Asterisk 13.17.1

I can connect to MySQL with the freepbxuser and the associated password and I can access the database asteriskcdrdb.

Call Detail Record (CDR) settings

Logging: Enabled
Mode: Simple
Log unanswered calls: No
Log congestion: No

  • Registered Backends

Adaptive ODBC

Tried loading the cdr adaptative while atserisk was running and:

module load
Unable to load module
Command 'module load ’ failed.
[2017-09-21 15:52:27] WARNING[18312]: loader.c:1042 load_resource: Module ‘’ already exists.

Fwconsole restarted and:

== Parsing ‘/etc/asterisk/cdr.conf’: Found
[2017-09-20 23:27:07] WARNING[5630]: cdr_manager.c:214 load_config: Failed to load configuration file. Module not activated.
== Unregistered ‘cdr_manager’ CDR backend
[2017-09-20 23:27:07] WARNING[5630]: cdr_odbc.c:205 odbc_load_module: cdr_odbc: Unable to load config for ODBC CDR’s: cdr_odbc.conf
== Parsing ‘/etc/asterisk/cel_custom.conf’: Found
Added CEL CSV mapping for 0 files.
== => (Customizable Comma Separated Values CEL Backend)
== Parsing ‘/etc/asterisk/cel.conf’: Found
== Parsing ‘/etc/asterisk/cel_general_additional.conf’: Found
== Parsing ‘/etc/asterisk/cel_general_custom.conf’: Found
== Parsing ‘/etc/asterisk/cel_custom_post.conf’: Found
== => (Asterisk Manager Interface CEL Backend)
== Parsing ‘/etc/asterisk/cel_odbc.conf’: Found
== Parsing ‘/etc/asterisk/cel_odbc_custom.conf’: Found
– Found CEL table [email protected]
== => (ODBC CEL backend)
[2017-09-20 23:27:07] ERROR[5630]: cdr_syslog.c:145 load_config: Unable to load cdr_syslog.conf. Not logging custom CSV CDRs to syslog.
[2017-09-20 23:27:07] ERROR[5630]: cdr_custom.c:101 load_config: Unable to load cdr_custom.conf. Not logging custom CSV CDRs.
== => (Customizable Comma Separated Values CDR Backend)

Can you think of anything that might be stopping CDR’s from being logged?

Is the Adaptive ODBC the only backend I need for it to log into CDR reports and show up properly in the UCP? My Freepbx 14 server only has the Adaptive enabled.


Crashed databases?

Good luck and have a nice day!


1 Like

I don’t think its crashed.

Thanks and you too!

Your post itself shows the cel table working, but the cdr hasn’t done anything for a week, what did you do at a few minutes after midnight on the 14th? presumably an automated update.

Installed the RTP bleed update. Asterisk 13.17.1 & Yum update.

Then one of those actions are likely the root cause of your problem , no?

Restore your system to prior to that time and do things one at a time, check the functionality after each step.


You do have quite a few warnings…

The problem with those is that some of them might be normal:wink:

I don’t remember off hand the content of each file it complains about or if they are always there, I will check what they are tonight on my test system…

(It’s running FreePBX 14 but I don’t think this has changed much if at all…)

Good luck and have a nice day!



Those warnings seems legit, I believe I have all of them…

Are the files /etc/asterisk/cdr_adaptive_odbc.conf and /etc/odbc.ini present and what is their content?

I kinda expect /etc/odbc.ini to be since I am pretty sure CEL would not work and you would get additional warning but maybe /etc/asterisk/cdr_adaptive_odbc.conf is not…

Good luck and have a nice day!


PS: :sleeping:zzzzzzzzzzzzzzz time…