Upgrade to Ubuntu 16.04 libmyodbc missing

I’m using Asterisk 13.x and just upgraded from Ubuntu 14.04 to Ubuntu 16.04
In the beginning of the logs I’m told that libmyodbc.so is missing and I have tried to reinstall it but Ubuntu tells me that although there is a reference to the packet it is not available in this release.

I’m getting lots of error messages for xmpp but I think that if Asterisk can’t access the database then not much will work.

Any ideas or do I just have to wait until Ubuntu catches up?


I am not so professional but I wish tricks can help you.
Go to command line:
find / -name libmyodbc.so

Wait until terminal response you .
Than change only path of the file under the text which is indicated below.(write this text on terminal but don’t forget to modify path side)

sudo cat >> /etc/odbcinst.ini << EOF
Description = ODBC for MySQL
Driver = /usr/lib/i386-linux-gnu/odbc/libmyodbc.so
Setup = /usr/lib/i386-linux-gnu/odbc/libodbcmyS.so
FileUsage = 1


Than don’t change anything the text which is indicated below, wrote it on terminal and press enter.

sudo cat >> /etc/odbc.ini << EOF
Description=MySQL connection to ‘asteriskcdrdb’ database


Thanks for trying but I don’t think this addresses the problem that libmyodbc doesn’t exist in the Ubuntu 16.04 distribution. It isn’t a question of it not being in the right place.

Best regards,

I have the same problem, was trying to install Asterisk/FreePBC on Ubuntu 16.04.

The package was removed because it’s not compatible with MySQL 5.7 which ships with 16.04.

See https://bugs.launchpad.net/ubuntu/+source/myodbc/+bug/1564856

Did you find a work around?

I managed to make the Asterisk CDR work on Ubuntu 16.04.1 LTS 64 bit using the following this guide

Hi and thanks for the reply.
I also got it to work a while ago by installing from source using the mysql pages on the Oracle site.
I have recently done the same on 16.10 which also works.
Best regards,