Hello,

I am trying to get CDR works for my asterisk installation.

My OS is Ubuntu 15 with asterisk 13.8 compiled locally on the machine.

MYSQL Server version is 5.6.28-0ubuntu0.15.04.1 (Ubuntu)

I also have another machine Ubuntu 15.04 same os but with asterisk 13.8.1
having the same issue, while same installation on Ubuntu 14.04

with 13.8.1 is working fine.

The only difference I saw is the mysql database engine version number on Ubuntu 14.04 which was 5.5.

While there was no way to downgrade mysql to version 5.5 on Ubuntu 15.04 I
upgraded the mysql to version 5.6 on Ubuntu 14.04

surprisingly! the cdr kept on working.

Would appreciate if someone can help solving this issue

The error that I am getting:

[2016-04-15 19:24:34] WARNING[1709]: res_odbc.c:503 load_odbc_config: The
‘pooling’, ‘shared_connections’, ‘limit’, and ‘idlecheck’ options are deprecated. Please see UPGRADE.txt for information

[2016-04-15 19:24:34] WARNING[1709]: res_odbc.c:503 load_odbc_config: The
‘pooling’, ‘shared_connections’, ‘limit’, and ‘idlecheck’ options are deprecated. Please see UPGRADE.txt for information

[2016-04-15 19:24:34] WARNING[1709]: res_odbc.c:821 odbc_obj_connect:
res_odbc: Error SQLConnect=-1 errno45 [unixODBC]

[2016-04-15 19:24:34] NOTICE[1709]: res_odbc.c:585 load_odbc_config:
Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]

.

The command isql MySQL-asteriskcdrdb is working fine.

isql MySQL-asteriskcdrdb

+—————————————+

| Connected! |

| |

| sql-statement |

| help [tablename] |

| quit |

| |

+—————————————+

The following command returns errors : module reload cdr_adaptive_odbc.so

Module ‘cdr_adaptive_odbc.so’ reloaded successfully.

— Reloading module ‘cdr_adaptive_odbc.so’ (Adaptive ODBC CDR backend)

== Parsing ‘/etc/asterisk/cdr_adaptive_odbc.conf’: Found

[2016-04-15 19:31:41] WARNING[1758]: cdr_adaptive_odbc.c:135 load_config: No such connection ‘MySQL-asteriskcdrdb’ in the ‘asteriskcdrdb’ section of cdr_adaptive_odbc.conf. Check res_odbc.conf.

odbc show, returns the following

ODBC DSN Settings

—————