CDR not showing any info

gregorybiss · May 28, 2021, 3:48pm

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…

FreePBX 13.0.197.28
Asterisk 13.29.2 built by mockbuild @ jenkins2.schmoozecom.net 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
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                            0          Running              core
res_odbc_transaction.so        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

Thanks in advance!!

lgaetz · May 28, 2021, 3:58pm

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

gregorybiss · May 28, 2021, 4:04pm

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

lgaetz · May 28, 2021, 5:58pm

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:

gregorybiss · May 28, 2021, 7:32pm

gregorybiss · June 15, 2021, 5:41pm

Any further insight on this?

gregorybiss · June 16, 2021, 3:18pm

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 · July 17, 2021, 3:18pm

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