CDR reports not working

FreePBX Applications / Modules
1

Hello everyone!

I’ve just installed FreePBX (https://computingforgeeks.com/how-to-install-freepbx-15-on-ubuntu-debian-linux/) on a Ubuntu 20.04 virtual machine, and everything is working fine except for the CDR reports, the database is empty. Please direct me, where should I search for the problem?

FreePBX version is 15.0.16.78, Asterisk 16.15.0.

omega*CLI> cdr show active

Channels with Call Detail Record (CDR) Information

Channel Dst. Channel LastApp Start Answer End Billsec Duration
PJSIP/beotel-00000006 PJSIP/993-00000007 Dial 23:19:23 23:19:30 23:19:33 00000003 00000010

omega*CLI> cdr show status

Call Detail Record (CDR) settings

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

  • Registered Backends

    csv
    cdr_manager (suspended)
    Adaptive ODBC

cdr set debug on
0x7f2cec001a10 - Created CDR for channel PJSIP/beotel-00000006
0x7f2cec001a10 - Transitioning CDR for PJSIP/beotel-00000006 from state NONE to Single
0x7f2cec001d80 - Created CDR for channel PJSIP/993-00000007
0x7f2cec001d80 - Transitioning CDR for PJSIP/993-00000007 from state NONE to Single
0x7f2cec001a10 - Processing Dial Begin message for channel PJSIP/beotel-00000006, peer PJSIP/993-00000007
0x7f2cec001a10 - Updated Party A PJSIP/beotel-00000006 snapshot
0x7f2cec001a10 - Updated Party B PJSIP/993-00000007 snapshot
0x7f2cec001a10 - Transitioning CDR for PJSIP/beotel-00000006 from state Single to Dial
0x7f2cec001a10 - Processing Dial End message for channel PJSIP/beotel-00000006, peer PJSIP/993-00000007
0x7f2cec001a10 - Transitioning CDR for PJSIP/beotel-00000006 from state Dial to DialedPending
0x7f2cec001a10 - Set answered time to 1606256370.394145
Bridge Enter message for channel PJSIP/993-00000007: 1606256370.00396982
0x7f2cec001d80 - Updating Party A PJSIP/993-00000007 snapshot
0x7f2cec001d80 - Processing bridge enter for PJSIP/993-00000007
0x7f2cec001d80 - Transitioning CDR for PJSIP/993-00000007 from state Single to Bridged
Bridge Enter message for channel PJSIP/beotel-00000006: 1606256370.00397729
0x7f2cec001a10 - Updating Party A PJSIP/beotel-00000006 snapshot
0x7f2cec001a10 - Processing bridge enter for PJSIP/beotel-00000006
0x7f2cec001a10 - Transitioning CDR for PJSIP/beotel-00000006 from state DialedPending to Dial
0x7f2cec001a10 - Transitioning CDR for PJSIP/beotel-00000006 from state Dial to Bridged0x7f2cec001a10 - Processing Bridge Leave for PJSIP/beotel-00000006
0x7f2cec001a10 - Transitioning CDR for PJSIP/beotel-00000006 from state Bridged to Finalized
Bridge Leave message for PJSIP/993-00000007: 1606256377.00695881
0x7f2cec001d80 - Processing Bridge Leave for PJSIP/993-00000007
0x7f2cec001d80 - Transitioning CDR for PJSIP/993-00000007 from state Bridged to Finalized
0x7f2cec001d80 - Beginning finalize/dispatch for PJSIP/993-00000007
0x7f2cec001d80 - Dispatching CDR for Party A PJSIP/993-00000007, Party B
0x7f2cec001a10 - Beginning finalize/dispatch for PJSIP/beotel-00000006
0x7f2cec001a10 - Dispatching CDR for Party A PJSIP/beotel-00000006, Party B PJSIP/993-00000007

Thanks, in advance!

2

I forgot to mention, asterisk is logging just fine to /var/log/asterisk/cdr-csv/Master.csv

3

FreePBX and Ubuntu 20.04 will be quite a challenge unless you really understand ‘why’ it will be challenging (start with PHP and node versions) , first ask the scriptor for his/her resolution, or better yet chose a safer path. From the wiki, both Ubuntu and Debian recipes are available. IYAM @billsimon Debian 10 recipe is hard to beat if you want cutting edge debian based Asterisk/FreePBX latest

4

CDR is recorded to database using ODBC. You can start your troubleshooting at the Asterisk command line with “odbc show all” and you should see a connection for asteriskcdrdb. If not, work through your instructions and make sure the ODBC-MySQL connector is installed and the DSNs are set up in the ODBC config files. In my notes that means installing the “odbc-mariadb” package (see line 12) and setting up the odbc config files (line 46 &ff.) Note these instructions are Debian 10 and not Ubuntu, but much is similar.

1 Like
5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.