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 cel@asteriskcdrdb.
== 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.