Demo Installing unixODBC, MySQL connector and cdr_adaptive_odbc

Step 1: Install UnixODBC

apt-get install unixodbc-dev unixodbc-bin unixodbc

Step 2: Install MySQL Server

apt-get install mysql-server

Provide a password for mysql "qsasterisk". You can change the password if you want, but change the lab accordingly.

Step 3: Install MySQL connector for ODBC

wget https://dev.mysql.com/get/Downloads/Connector-ODBC/8.0/mysql-connector-odbc-8.0.11-linux-ubuntu16.04-x86-32bit.tar.gz
tar -xzvf mysql-connector-odbc-8.0.11-linux-ubuntu16.04-x86-32bit.tar.gz
cd mysql-connector-odbc-8.0.11-linux-ubuntu16.04-x86-32bit
cp libmyodbc8a.so /usr/lib/i386-linux-gnu/odbc/\

Step 4: Edit odbcinst.init and install the drivers

[MySQL] Description = ODBC for MySQL Driver = /usr/lib/i386-linux-gnu/odbc/libmyodbc8a.so Setup = /usr/lib/i386-linux-gnu/odbc/libodbcmyS.so FileUsage = 1

Step 5: Edit /etc/odbc.ini and create the dsn

[astcdr]
Description = MySQL connection to database
Driver = MySQL
Database = cdr
Server = localhost
User = root
Password = qsasterisk
Port = 3306
Socket = /var/run/mysqld/mysqld.sock

Step 6: Create the database cdr

mysqladmin -uroot -p create cdr

use qsasterisk as the password.

Step 7: Recompile Asterisk to support cdr_adpative_sql

cd /usr/src/asterisk*
./configure
make
make install