CDR not showing any info

Tags: #<Tag:0x00007fb47c38a7b0>

(Greg) #1

I’m not sure when it happened but I’m not getting any info from cdr. I’ve looked around the forums and believe this could help diagnose the issue…

Asterisk 13.29.2 built by mockbuild @ on a x86_64 running Linux on 2019-12-17 03:57:42 UTC

localhost*CLI> cdr show status

Call Detail Record (CDR) settings
  Logging:                    Enabled
  Mode:                       Simple
  Log unanswered calls:       No
  Log congestion:             No

* Registered Backends
    Adaptive ODBC

localhost*CLI> module show like odbc
Module                         Description                              Use Count  Status      Support Level           Adaptive ODBC CDR backend                0          Running              core                    ODBC CDR Backend                         0          Not Running      extended                    ODBC CEL backend                         0          Running              core                   ODBC lookups                             0          Not Running          core             Realtime ODBC configuration              0          Running              core                    ODBC resource                            0          Running              core        ODBC transaction resource                0          Running              core
7 modules loaded


[root@localhost ~]# yum list asterisk11*
Loaded plugins: fastestmirror, kmod
Loading mirror speeds from cached hostfile
Available Packages
asterisk11.x86_64                                                                                                            11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-addons.x86_64                                                                                                     11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-addons-bluetooth.x86_64                                                                                           11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-addons-core.x86_64                                                                                                11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-addons-mysql.x86_64                                                                                               11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-addons-ooh323.x86_64                                                                                              11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-alsa.x86_64                                                                                                       11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-configs.x86_64                                                                                                    11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-core.x86_64                                                                                                       11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-curl.x86_64                                                                                                       11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-dahdi.x86_64                                                                                                      11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-debuginfo.x86_64                                                                                                  11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-devel.x86_64                                                                                                      11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-doc.x86_64                                                                                                        11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-flite.x86_64                                                                                                      11.25.2-1.shmz65.1.53                                                                                        pbx
asterisk11-flite-debuginfo.x86_64                                                                                            11.25.2-1.shmz65.1.53                                                                                        pbx
asterisk11-odbc.x86_64                                                                                                       11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-ogg.x86_64                                                                                                        11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-pgsql.x86_64                                                                                                      11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-res_digium_phone.x86_64                                                                                           2.1.1-1.shmz65.1.36                                                                                          pbx
asterisk11-resample.x86_64                                                                                                   11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-snmp.x86_64                                                                                                       11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-speex.x86_64                                                                                                      11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-sqlite3.x86_64                                                                                                    11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-tds.x86_64                                                                                                        11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-voicemail.x86_64                                                                                                  11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-voicemail-imapstorage.x86_64                                                                                      11.25.3-1.shmz65.1.123                                                                                       pbx
asterisk11-voicemail-odbcstorage.x86_64                                                                                      11.25.3-1.shmz65.1.123                                                                                       pbx

If there’s anything else I should add to help solve this please let me know. I’m pretty new to the forums and had to read This Guide to get this far :grimacing:

Thanks in advance!!

(Lorne Gaetz) #2

Unrelated to your question - Asterisk 11 is EOL and 13 is nearing it. You should be on Asterisk 16 now or making plans to do so.

What is Asterisk console output of

odbc show all

(Greg) #3

Thank you Lorne,

localhost*CLI> odbc show all

ODBC DSN Settings

  Name:   asteriskcdrdb
  DSN:    MySQL-asteriskcdrdb
    Last connection attempt: 1969-12-31 19:00:00
    Number of active connections: 1 (out of 1)
    Logging: Disabled

(Lorne Gaetz) #4

In Advanced Settings, what shows for the CDR section, they should all be null if the CDR and FreePBX are on the same system. You may need to enable display all and override readonly in order to see these settings:

(Greg) #5

(Greg) #6

Any further insight on this?

(Greg) #7

I tried forcing an install of CDR and received a new error message, after researching that message, I was able to fix the issue with the following command. Thanks for your help though Lorne!

mysqlcheck --repair --all-databases

(system) closed #8

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