Looking for a bit of assistance with a CDR reports issue. We did a migration and did a backup and restore of the configurations but are running into issues with the CDR reports coming in.
cat 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
cat odbcinst.ini
# Example driver definitions
# Driver from the postgresql-odbc package
# Setup from the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/psqlodbc.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbc.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1
# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc5.so
Setup = /usr/lib/libodbcmyS.so
Driver64 = /usr/lib64/libmyodbc5.so <----- Verified that it is there
Setup64 = /usr/lib64/libodbcmyS.so <----- Verified that it is there
FileUsage = 1
cat cdr_odbc.conf
#include cdr_adaptive_odbc.conf
cat cdr_adaptive_odbc.conf
[asteriskcdrdb]
connection=asteriskcdrdb
loguniqueid=yes
table=cdr
alias start => calldate
cat res_odbc.conf
[asteriskcdrdb]
enabled=>yes
dsn=>MySQL-asteriskcdrdb
pooling=>no
limit=>1
pre-connect=>yes
username=>freepbxuser
password=>PASSWORD IS CORRECT
database=>asteriskcdrdb
I did verify that the password listed here is correct. Tested logging in with mysql -u freepbxuser -p then running a show grants. Has full access to asteriskcdrdb
cat freepbx.conf
<?php
$amp_conf['AMPDBUSER'] = 'freepbxuser';
$amp_conf['AMPDBPASS'] = 'MATCHES PASSWORD ABOVE';
$amp_conf['AMPDBHOST'] = 'localhost';
$amp_conf['AMPDBNAME'] = 'asterisk';
$amp_conf['AMPDBENGINE'] = 'mysql';
$amp_conf['datasource'] = ''; //for sqlite3
require_once('/var/www/html/admin/bootstrap.php');
?>
module show like cdr
Module Description Use Count Status Support Level
app_cdr.so Tell Asterisk to not maintain a CDR for 0 Running core
app_forkcdr.so Fork The CDR into 2 separate entities 0 Running core
cdr_adaptive_odbc.so Adaptive ODBC CDR backend 0 Running core
cdr_csv.so Comma Separated Values CDR Backend 0 Not Running extended
cdr_custom.so Customizable Comma Separated Values CDR 0 Running core
cdr_manager.so Asterisk Manager Interface CDR Backend 0 Running core
cdr_mysql.so MySQL CDR Backend 0 Running deprecated
cdr_odbc.so ODBC CDR Backend 0 Running extended
cdr_syslog.so Customizable syslog CDR Backend 0 Not Running core
func_cdr.so Call Detail Record (CDR) dialplan functi 0 Running core
10 modules loaded
CDR does show an active call when running cdr show active.
cdr show status
Call Detail Record (CDR) settings
----------------------------------
Logging: Enabled
Mode: Simple
Log unanswered calls: No
Log congestion: No
* Registered Backends
-------------------
Adaptive ODBC
cdr_manager
cdr-custom
res_config_sqlite
module show like res_odbc.so
Module Description Use Count Status Support Level
res_odbc.so ODBC resource 0 Running core
1 modules loaded
module reload res_odbc.so
Module 'res_odbc.so' reloaded successfully.
[2022-03-01 13:31:54] WARNING[35292]: res_odbc.c:525 load_odbc_config: The 'pooling', 'shared_connections', 'limit', and 'idlecheck' options were replaced by 'max_connections'. See res_odbc.conf.sample.
[2022-03-01 13:31:54] WARNING[35292]: res_odbc.c:525 load_odbc_config: The 'pooling', 'shared_connections', 'limit', and 'idlecheck' options were replaced by 'max_connections'. See res_odbc.conf.sample.
[2022-03-01 13:31:54] NOTICE[35292]: res_odbc.c:616 load_odbc_config: Registered ODBC class 'asteriskcdrdb' dsn->[MySQL-asteriskcdrdb]
module reload cdr_adaptive_odbc.so
Module 'cdr_adaptive_odbc.so' reloaded successfully.
Any help would be greatly appreciated!