Small update. After some debugging I found the problem (I guess), the module module cdr_adaptive_odbc.so doesn’t exist anymore. When I try to reload this module, the following message appears:
pbx*CLI> module reload cdr_adaptive_odbc.so
No such module 'cdr_adaptive_odbc.so'
Does someone has an idea how I can reinstall this module? The config files are still present on the server.
[root@pbx ~]# cd /etc/asterisk/cdr
cdr_adaptive_odbc.conf cdr.conf cdr_mysql.conf cdr_mysql.conf.bak cdr_odbc.conf
[EDIT] Some extra information: in the directory /usr/lib64/asterisk/modules/ I find the following .so files. So I missing the files cdr_odbc.so & cdr_adaptive_odbc.so.
-rwxr-xr-x 1 root root 12352 Jan 29 01:24 cdr_csv.so
-rwxr-xr-x 1 root root 11392 Jan 29 01:24 cdr_custom.so
-rwxr-xr-x 1 root root 11488 Jan 29 01:24 cdr_manager.so
-rwxr-xr-x 1 root root 32608 Jan 29 01:24 cdr_mysql.so
-rwxr-xr-x 1 root root 15744 Jan 29 01:24 cdr_radius.so
-rwxr-xr-x 1 root root 13728 Jan 29 01:24 cdr_syslog.so
[EDIT2] Copying the 2 .so files from my test VM (clean FreePBX distro install) to the production server didn’t do the trick. I already restart amportal, only module reload cdr_adaptive_odbc.so still giving the message ***No such module ‘cdr_adaptive_odbc.so’***.
[EDIT3] After install asterisk11-odbc.x86_64 (yum install asterisk11-odbc.x86_64) the ODBC module is loaded in Asterisk. The only thing I need to solve now is the database connection, because I got the following error message:
[2015-02-08 14:47:22] NOTICE[30081][C-00000001]: res_odbc.c:1537 odbc_obj_connect: Connecting asteriskcdrdb
[2015-02-08 14:47:22] WARNING[30081][C-00000001]: res_odbc.c:1562 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not found, and no default driver specified
[2015-02-08 14:47:22] WARNING[30081][C-00000001]: res_odbc.c:1377 _ast_odbc_request_obj2: Failed to connect to asteriskcdrdb
[2015-02-08 14:47:22] ERROR[30081][C-00000001]: cdr_odbc.c:148 odbc_log: Unable to retrieve database handle. CDR failed.
The login details in /etc/asterisk/cdr_mysql.conf and /etc/asterisk/res_odbc_additional.conf are working…
[code]pbx*CLI> odbc show all
ODBC DSN Settings
Name: asteriskcdrdb
DSN: MySQL-asteriskcdrdb
Last connection attempt: 2015-02-08 14:47:22
pbx*CLI>[/code]