CDR Report is Blank

FreePBX Installation / Upgrade
21

Here are the results:

Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile

  • base: mirrors.advancedhosters.com
  • extras: mirror.symnds.com
  • updates: mirrors.centos.webair.com
    Package unixODBC-2.3.1-11.el7.x86_64 already installed and latest version
    Package unixODBC-devel-2.3.1-11.el7.x86_64 already installed and latest version
    Package libtool-ltdl-2.4.2-21.el7_2.x86_64 already installed and latest version
    Package libtool-ltdl-devel-2.4.2-21.el7_2.x86_64 already installed and latest version
    Nothing to do

Please note that I found that the mysql database is not getting updated when a call is made. (CDR reports work when you manually add records to the cdr database).

22

OK.

You have the ODBC stuff installed - good.

That means that the problem is in your connector. Look in your logs (/var/log/asterisk/full) and see what error is being generated when you start up the system. I’m expecting a configuration error in one of the ODBC/SQL configuration files.

The connector for the reports is different than the one for the actual insert into the cdr table. There are also a couple of CDR config files that need to correctly identify your ODBC data source as the destination for the writes.

23

I listed these before: Here are the errors in /var/log/asterisk/full:

[2016-04-07 12:56:44] NOTICE[11752] res_odbc.c: Connecting asteriskcdrdb
[2016-04-07 12:56:44] WARNING[11752] res_odbc.c: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Can’t open lib ‘/usr/lib64/libmyodbc5.so’ : file not found
[2016-04-07 12:56:44] WARNING[11752] res_odbc.c: Failed to connect to asteriskcdrdb
[2016-04-07 12:56:44] NOTICE[11752] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]

[2016-04-07 12:56:44] WARNING[11752] res_odbc.c: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Can’t open lib ‘/usr/lib64/libmyodbc5.so’ : file not found
[2016-04-07 12:56:44] WARNING[11752] res_odbc.c: Failed to connect to asteriskcdrdb
[2016-04-07 12:56:44] WARNING[11752] cel_odbc.c: No such connection ‘asteriskcdrdb’ in the ‘cel’ section of cel_odbc.conf. Check res_odbc.conf.

24

This is the problem we were trying to solve with you making sure you’d updated all of your libraries.

This file doesn’t exist, so reinstalling the packages that you’ve installed again are not going to do what you need.

Did you follow the instructions I found on solving this specific problem at Installing MyOBDC for Asterisk?

The article at that URL SPECIFICALLY talks about how to solve this error.

25

Thank you. That fixed the CDR report problem. It also seem to fix most of the Dashboard, FreePBX Statistics issues. Now the only problem is Memory on the FreePBX Statistics generates an exception: psi.Memory.Details.@attributes.AppPercent File:/var/www/html/admin/modules/dashboard/classes/Statistics.class.php:595