CDR report is blank

[wilibox]

I was trying to test CDR reports after some test calls, however, the report shows 0. In the full log I found one warring:

cdr_adaptive_odbc.c: No such connection 'asterisk' in the 'asterisk' section of cdr_adaptive_odbc.conf. Check res_odbc.conf.

Also I found that database of asteriskcdrdb is missing. the odbc.ini config:

[MySQL-asteriskcdrdb] Description = MySQL connection to 'asteriskcdrdb' database driver = MySQL server = freepbx-db User = asterisk Password = asteriskpass database = asterisk Port = 3306 option = 3

[asteriskcdrdb] Description = MySQL connection to 'asteriskcdrdb' database driver = MySQL server = freepbx-db User = asterisk Password = asteriskpass database = asterisk Port = 3306 option = 3

But maybe the database is not needed...I am not sure now, because no other errors regarding call logs or reports are present.

So the main question is: how to make CDR reports display some output ?

Additional note: the backup module also throws error regarding missing database:

In Process.php line 239:
The command "/usr/bin/mysqldump --host pbx-db --port 3306 --user asterisk -
pasteriskpass asteriskcdrdb --opt --compact --table cel --skip-lock
-tables --skip-triggers --no-create-info > /tmp/dbdump/cel.sql" failed.

Exit Code: 2(Misuse of shell builtins)

More info that cdr seems configured:

freepbx*CLI> odbc show

ODBC DSN Settings

Name: asteriskcdrdb DSN: MySQL-asteriskcdrdb Number of active connections: 1 (out of 5)

freepbx*CLI> cdr show status

Call Detail Record (CDR) settings

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

• Registered Backends

  Adaptive ODBC

[tiredofit]

Backup Module they've done some hardcoding in their module I see thinking that the database is always exists to the system. I wonder if I'm able to hack it without triggering their signature check.

With Regards to CDR - In this case asteriskcdrdb doesn't actually exist, I've merged it into one database, during the install to the default "asterisk" database just due to the fact I didn't want to get involved in having to create multiple databases via Docker. When I originally did this 2.5 years ago I had a pretty basic MariaDB image built, now I can support multiple DBs, so it may just call for me to refactor this to support that change, although that would break a heck of alot of installs out there. I'm going to have to get a configured system up and running again and work through this for you. I too went through similar issues when I was tweaking this and triple checked all the settings, yet can't for the life of me recall what the golden fix was - although I do believe it was something simple and I wrote it into the install script. Long story short. I'm going to need to look at this and the backup module. Interesting about backup module, it did work just fine in 14.

[felipem1210]

Hi @wilibox

For your conveniance. I figured it out with the tiredofit/freepbx:14-latest image. The problem was in the cdr_adaptive_odbc.conf file:

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

I changed the connection line from asteriskcdrdb to asterisk, then made an asterisk module reload. After that the CDR was just working fine everywhere (insertion good in table cdr and the GUI was showing the records)

I hope this helps you