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?
Pete
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
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/i386-linux-gnu/odbc/libmyodbc.so
Setup = /usr/lib/i386-linux-gnu/odbc/libodbcmyS.so
FileUsage = 1
EOF
Than don’t change anything the text which is indicated below, wrote it on terminal and press enter.
sudo cat >> /etc/odbc.ini << EOF
[MySQL-asteriskcdrdb]
Description=MySQL connection to ‘asteriskcdrdb’ database
driver=MySQL
server=localhost
database=asteriskcdrdb
Port=3306
Socket=/var/run/mysqld/mysqld.sock
option=3
EOF
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,
Pete
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,
Pete