Hi
There are currently issues in Debian testing (8.1) due to an upgrade of MySQL to version 5.6 and an incompatibility with the version of package libmyodbc (5.1.10-3) available from the repository.
This results in res_odbc.so causing Asterisk to crash with a Floating point exception.
The solution I have found is to download a new ODBC driver direct from mysql.com and install it as follows (assuming an x64 system):
apt-get remove libmyodbc
cd /usr/src/
wget dev.mysql.com/get/Downloads/Conn … bit.tar.gz
tar zxvf mysql-connector-odbc-5.3.4-linux-debian6.0-x86-64bit.tar.gz
cd mysql-connector-odbc-5.3.4-linux-debian6.0-x86-64bit/
cp -a lib/libmyodbc5* /usr/lib/x86_64-linux-gnu/odbc/
chown root:root /usr/lib/x86_64-linux-gnu/odbc/libmyodbc5*
Edit /etc/odbcinst.ini to look like:
[MySQL ODBC 5.3 Driver]
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so
SETUP=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5S.so
UsageCount=1
Edit /etc/odbc.ini to look like:
[MySQL-asteriskcdrdb]
Driver=MySQL ODBC 5.3 Driver
SERVER=127.0.0.1
UID=asteriskuser
PWD=password
DATABASE=asteriskcdrdb
PORT=3306
This has solved the problem on my Debian system as of October 2015 and CDR and CEL are again working.
Peter