FreePBX | Register | Issues | Wiki | Portal | Support

CDR Report is empty (FreePBX 14)


#1

Hi,

I have a FreePBX 14 running fine for making and receiving calls, but there is nothing in the CDR section. I have searched a bit and have been forwarded here and there on the internet with no actual answers or solution. I don’t know exactly where to start. I have found no CDR errors in my full file.

Here is a grep of “CDR” in my /var/log/asterisk/full

[root@freepbx asterisk]# grep -i CDR full
[2019-03-10 22:29:43] NOTICE[24244] cdr.c: CDR simple logging enabled.
[2019-03-10 22:29:44] NOTICE[24244] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]
[2019-03-10 22:29:44] VERBOSE[24244] loader.c: Reloading module ‘cdr_adaptive_odbc.so’ (Adaptive ODBC CDR backend)
[2019-03-10 22:29:44] VERBOSE[24244] loader.c: Reloading module ‘cdr_csv.so’ (Comma Separated Values CDR Backend)
[2019-03-10 22:29:44] VERBOSE[24244] loader.c: Reloading module ‘cdr_custom.so’ (Customizable Comma Separated Values CDR Backend)
[2019-03-10 22:29:44] VERBOSE[24244] loader.c: Reloading module ‘cdr_manager.so’ (Asterisk Manager Interface CDR Backend)
[2019-03-10 22:29:44] VERBOSE[24244] loader.c: Reloading module ‘cdr_odbc.so’ (ODBC CDR Backend)
[2019-03-10 22:29:44] VERBOSE[24244] cel_odbc.c: Found CEL table cel@asteriskcdrdb.
[2019-03-10 22:29:44] VERBOSE[24244] loader.c: Reloading module ‘cdr_mysql.so’ (MySQL CDR Backend)

When I do a cdr show status, I get a cdr_manager that is suspended. Is this a problem?

freepbx*CLI> cdr show status

Call Detail Record (CDR) settings

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

  • Registered Backends

    cdr_manager (suspended)
    cdr-custom
    csv
    Adaptive ODBC

Thanks for your input!


#2

If I remember correctly, the default CDR backend on 14 is Adaptive ODBC, but I might be wrong.


#3

Maybe, but this is confusing to me


(Dave Burgess) #4

We’ve had several discussions pop up here about Asterisk 14 and the Adaptive ODBC settings. Have you looked at any of them to see if they might help you with your confusion?

[HELP] Setting up ODBC CDR on Ast11/FPBX 12 might be a good first step.


#5

I did look at many of the posts but nothing helped me much. The post you linked has no suggestion or answers unfortunately.


#6

Is this the FreePBX Distro or something you put together?


#7

It’s the distro


(system) closed #8

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