CDR database empty

ok cdr_odbc.conf should

#include cdr_ adaptive_odbc.conf

And cdr_adaptive_odbc.conf should contain those lines

1 Like

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
2 Likes

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.

2 Likes

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