FreePBX 16.0.40.4 CDRs suddenly stopped showing in report->CDR Reports

[faisalkhan]

hi team,

I have a distro installation of FreePBX 16.0.40.4 and it was working fine. I am unable to get any cdr for any calls in the CDR Reports but i have last record available till 09 may 2023.

What could be the reason.

[faisalkhan]

CLI> module show like odbc
Module Description Use Count Status Support Level
cdr_adaptive_odbc.so Adaptive ODBC CDR backend 0 Running core
cdr_odbc.so ODBC CDR Backend 0 Not Running extended
cel_odbc.so ODBC CEL backend 0 Running core
func_odbc.so ODBC lookups 0 Not Running core
res_config_odbc.so Realtime ODBC configuration 0 Running core
res_odbc.so ODBC resource 6 Running core
res_odbc_transaction.so ODBC transaction resource 1 Running core
7 modules loaded

cdr show status

Call Detail Record (CDR) settings

Logging: Disabled
Mode: Simple

cat /etc/asterisk/cdr_adaptive_odbc.conf
[asteriskcdrdb]
connection=asteriskcdrdb
loguniqueid=1
table=cdr
alias start => calldate

asterisk -x “odbc show asteriskcdrdb”

ODBC DSN Settings

Name: asteriskcdrdb
DSN: MySQL-asteriskcdrdb
Number of active connections: 1 (out of 5)
Logging: Disabled

[faisalkhan]

[2023-06-20 11:52:25] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1220-00000006
[2023-06-20 11:52:25] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1220-00000006
[2023-06-20 11:52:45] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1196-00000005
[2023-06-20 11:52:45] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1196-00000005
[2023-06-20 11:53:23] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1225-00000004
[2023-06-20 11:53:23] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1225-00000004
[2023-06-20 11:53:41] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1196-00000009
[2023-06-20 11:53:41] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1196-00000009
[2023-06-20 11:53:50] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1225-0000000b
[2023-06-20 11:53:50] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1225-0000000b
[2023-06-20 11:55:22] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1225-0000000e
[2023-06-20 11:55:22] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1225-0000000e
[2023-06-20 11:55:48] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/979-0000000c
[2023-06-20 11:55:48] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/979-0000000c
[2023-06-20 11:55:53] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1225-00000011
[2023-06-20 11:55:53] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1225-00000011
[2023-06-20 11:58:02] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1208-0000000a
[2023-06-20 11:58:02] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1208-0000000a
[2023-06-20 12:00:42] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1225-00000012
[2023-06-20 12:00:42] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1225-00000012
[2023-06-20 12:03:48] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1193-0000000f
[2023-06-20 12:03:48] ERROR[24148] cdr.c: Unable to find CDR for channel SIP/1193-0000000f

This is what I am getting in the CLI.

[2023-06-20 11:35:06] NOTICE[31290] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]
[2023-06-20 11:35:06] VERBOSE[31290] loader.c: Loading cdr.
[2023-06-20 11:35:06] NOTICE[31290] cdr.c: CDR logging disabled.
[2023-06-20 11:35:06] VERBOSE[31290] loader.c: cdr => (CDR Engine)
[2023-06-20 11:35:06] VERBOSE[31290] loader.c: Loading cdr_adaptive_odbc.so.
[2023-06-20 11:35:06] VERBOSE[31290] cdr_adaptive_odbc.c: Found adaptive CDR table cdr@asteriskcdrdb.
[2023-06-20 11:35:06] VERBOSE[31290] cdr_adaptive_odbc.c: Found alias start for column calldate in cdr@asteriskcdrdb
[2023-06-20 11:35:06] VERBOSE[31290] loader.c: cdr_adaptive_odbc.so => (Adaptive ODBC CDR backend)
[2023-06-20 11:35:08] VERBOSE[31290] loader.c: Loading cdr_csv.so.
[2023-06-20 11:35:08] VERBOSE[31290] loader.c: Loading cdr_manager.so.
[2023-06-20 11:35:08] VERBOSE[31290] loader.c: cdr_manager.so => (Asterisk Manager Interface CDR Backend)
[2023-06-20 11:35:08] VERBOSE[31290] loader.c: Loading cdr_odbc.so.
[2023-06-20 11:35:08] WARNING[31290] cdr_odbc.c: cdr_odbc: Unable to load config for ODBC CDR’s: cdr_odbc.conf
[2023-06-20 11:35:08] VERBOSE[31290] cel_odbc.c: Found CEL table cel@asteriskcdrdb.
[2023-06-20 11:35:08] VERBOSE[31290] loader.c: Loading app_cdr.so.
[2023-06-20 11:35:08] VERBOSE[31290] loader.c: app_cdr.so => (Tell Asterisk to not maintain a CDR for the current call)
[2023-06-20 11:35:08] VERBOSE[31290] loader.c: Loading func_cdr.so.
[2023-06-20 11:35:08] VERBOSE[31290] loader.c: func_cdr.so => (Call Detail Record (CDR) dialplan functions)
[2023-06-20 11:35:08] VERBOSE[31290] loader.c: Loading app_forkcdr.so.
[2023-06-20 11:35:08] VERBOSE[31290] loader.c: app_forkcdr.so => (Fork The CDR into 2 separate entities)
[2023-06-20 11:35:09] ERROR[31290] loader.c: cdr_csv declined to load.
[2023-06-20 11:35:09] ERROR[31290] loader.c: cdr_odbc declined to load.

[lgaetz (Lorne Gaetz)]

No CDR reports output generation after FreePBX update to 16.0.40.3

This is the solution: [Capture] Indeed, the option “Enable CDR Logging” must be set to “Yes”. Double-checking the output of the Asterisk command line when firing the “cdr show status” command when the option is set to “No”: Call Detail Record (CDR) settings Logging: Disabled Mode: Simple And when the option is set to “Yes”: Call Detail Record (CDR) settings Logging: Enabled Mode: Simple Log calls by de…

[faisalkhan]

this is the solution.