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
[root@ec2-nltel40 ~]# 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,