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

Get help with installing, upgrading and running Asterisk.

Moderators: muppetmaster, Moderator, Support

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

Postby whiskerp » Thu Oct 15, 2015 9:58 am

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 http://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
whiskerp
Newsterisk
 
Posts: 1
Joined: Thu Oct 15, 2015 9:44 am

Return to Asterisk Support

Who is online

Users browsing this forum: No registered users and 12 guests