I updated my FreePBX 14 box last night. I installed the system updated (yum update). And then started the task of updating my FreePBX modules after that. I did core update, folllowed by framework, then i did all the remaining modules about 3 at a time until they were done.
Restarted asterisk and freepbx.
Today I noticed my CDR records are not populating with new calls. I went into Asterisk CLI, did ‘cdr show status’ and it has normal stuff:
Call Detail Record (CDR) settings
Log unanswered calls: No
Log congestion: No
Registered BackendsAdaptive ODBC
I checked that cdr_odbc.conf extisted and it didn’t. Not sure if it was there to begin with. But this forum said to go ahead and add “#include cdr_adaptive_odbc.conf” into the cdr_odbc.conf file. Reloaded Freepbx but still no joy.
I checked the odbc.ini file in /etc and it shows the [MySql-asteriskcdrdb] section.
I go into mysql and do a “show processlist;” over and over again… and i see records being added into the cel table, but not the cdr table.
I dunno what to do now. I’m out of ideas. I need CDR table to work becuase it was working up until 10pm last night when i did the updates. My PowerBI reports depend on this database for business operations.
How can I get it to write to CDR database again?