*SOLVED* CEL (res_odbc+libmyodbc) crashing in Debian testing

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