FreePBX | Register | Issues | Wiki | Portal | Support

CDR database empty


#21

ok cdr_odbc.conf should

#include cdr_ adaptive_odbc.conf

And cdr_adaptive_odbc.conf should contain those lines


(Lorne Gaetz) #22

And corresponding entries in /etc/odbc.ini:

# cat /etc/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
Charset=utf8

(Gerrymad) #23

Got it! There were apparently two issues.

  1. My odbc.ini file was bad.
    The first line of my odbc.ini file was:
    odbc.ini[MySQL-asteriskcdrdb]

I removed “odbc.ini” from that first line. and records began to appear in the cel table

  1. I didn’t actually have a file called cdr_odbc.conf

I created a cdr_odbc.conf file with the following line in it

#include cdr_ adaptive_odbc.conf

With that change the cdr table began to populate.

I never had made any changes to these files so likely some update caused an issue. I found I actually have a file called odbc.ini.rpmsave which has the correct contents of the odbc.ini file.

Thanks so much for the help with this. I genuinely appreciate it.


CDR reports (do i have to setup something before?)
(system) closed #24

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