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

cdr_manager
cdr-custom
res_config_sqlite
Adaptive ODBC

Tried loading the cdr adaptative while atserisk was running and:

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


Fwconsole restarted and:

Loading cdr_csv.so.
== Parsing ‘/etc/asterisk/cdr.conf’: Found
Loading cdr_manager.so.
[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
Loading cdr_odbc.so.
[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
Loading cel_custom.so.
== Parsing ‘/etc/asterisk/cel_custom.conf’: Found
Added CEL CSV mapping for 0 files.
== cel_custom.so => (Customizable Comma Separated Values CEL Backend)
Loading cel_manager.so.
== 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
== cel_manager.so => (Asterisk Manager Interface CEL Backend)
Loading cel_odbc.so.
== Parsing ‘/etc/asterisk/cel_odbc.conf’: Found
== Parsing ‘/etc/asterisk/cel_odbc_custom.conf’: Found
– Found CEL table [email protected]
== cel_odbc.so => (ODBC CEL backend)
Loading cdr_syslog.so.
[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.
Loading cdr_custom.so.
[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.
== cdr_custom.so => (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.

Hi!

Crashed databases?

Good luck and have a nice day!

Nick

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.

Hi!

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!

Nick

Hi!

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!

Nick

PS: :sleeping:zzzzzzzzzzzzzzz time…