CDR Reports empty

Thought i would share what i got to work: YMMV.

yum install asterisk11-odbc.x86-64…

Checked this posting:

Modified the /etc/odbc.ini to reflect
[MySQL-asteriskcdrdb]
Description=MySQL connection to ‘asterisk’ database
driver=MySQL
server=localhost
database=asteriskcdrdb
username=freepbx
password=fpbx
Port=3306
Socket=/var/lib/mysql/mysql.sock
option=3

From CLI:
module reload res_odbc.so
module reload cdr_adaptive_odbc.so
cdr show status

Call Detail Record (CDR) settings

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

  • Registered Backends

    ODBC
    Adaptive ODBC
    cdr-custom

Checked for new entries in mysql:
select calldate from cdr;
| 2015-04-09 09:35:50 |
±--------------------+
1161 rows in set (0.00 sec)

VIOLA! We back in CDR Buidness…