CDR reports blank

I have a server hat has blank CDR reports.

So i have data in the cdr database (database is remote) and its configured in asterisk > Settings

If do show process list I do see connections to the database from that user.
If I query he DB I do have my calls in there as expected.

I don’t have odbc errors on the cli,
I don’t have odbc errors in the full log.

Any ideas on what to check,

cdr show status
Call Detail Record (CDR) settings

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

  • Registered Backends

cdr_manager
csv
Adaptive ODBC

[[email protected] ~]# cat /etc/asterisk/cdr_adaptive_odbc.conf
[asteriskcdrdb]
connection=asteriskcdrdb
loguniqueid=1
table=cdr
alias start => calldate

ODBC DSN Settings

Name: config
DSN: asterisk.config
Number of active connections: 1 (out of 1)
Logging: Disabled

Name: messages
DSN: messages
Number of active connections: 1 (out of 1)
Logging: Disabled

Name: asteriskcdrdb
DSN: MySQL-asteriskcdrdb
Number of active connections: 2 (out of 5)
Logging: Disabled

Settings in the Asterisk > Settings web page for remote cdr database are filled in and I can log in from isql and mysql clients

I don’t see any php errors being logged in error log I do see the page beening accessed in the httpd access log,

I rebuilt the table from a different server.

Appears that schema was the reason Freepbx didn’t like. Asterisk could log to it just fine.

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