I am sorry about this post about CDR BUT

1

I have managed to install FreePBX and get SIP trunking, extensions,IVR, recordings,etc working great BUT for the life of me I cannot get any CDR. I try a report and it comes up empty. I have read many of the posts and have tried to figure this out. I have done the CLI check, the ODBC reload, and made sure that CDR module is installed and up to date. I am not a MYSQL guy so I am still learning database.
Asterisk version is 13.50
CDR version is 13.0.17
FreePBX 13.0.1RC1.28 'VoIP Server’
all Detail Record (CDR) settings

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

  • Registered Backends

    Adaptive ODBC
    [centos@ip-10-0-1-39 etc]$ sudo cat odbc.ini
    [MySQL-asteriskcdrdb]
    Description=MySQL connection to ‘asteriskcdrdb’ database
    driver=MySQL
    server=localhost
    database=asteriskcdrdb
    Port=3306
    Socket=/var/lib/mysql/mysql.sock
    option=3]

[centos@ip-10-0-1-39 asterisk]$ sudo cat cdr.conf
enable=yes
unanswered=no
end before hexten=no

I appreciate all the support from the community. It has helped me to get this far.

Is there something System wide I need to do that I am missing

2

you will need a mysql odbc connector defined in

/etc/odbcinst.ini

which needs to match it’s location. Start with

http://www.voip-info.org/wiki/view/Asterisk+cdr+odbc

3

You should have the following in /etc/asterisk/cdr_adaptive_odbc.conf

[asteriskcdrdb]
connection=asteriskcdrdb
loguniqueid=yes
table=cdr
alias start => calldate

And also ensure that Asterisk is built with support for ODBC CDRs.

4

Yaaaayyyy Thanks guys, I got it working without trashing my database or PBX.