Ubuntu 18 ODBC installation

 

 wget http://ftp.iij.ad.jp/pub/db/mysql/Downloads/Connector-ODBC/8.0/mysql-connector-odbc-8.0.15-linux-ubuntu18.04-x86-64bit.tar.gz

 cp *.so /usr/lib/x86_64-linux-gnu/odbc/

nano /etc/odbc.ini

[MySQL-asteriskcdrdb]

Description=MySQL connection to 'asteriskcdrdb' database

driver=MySQL

server=localhost

database=asteriskcdrdb

Port=3306

;Socket=/var/lib/mysql/mysql.sock

option=3

Charset=utf8

 nano /etc/odbcinst.ini

# Driver from the mysql-connector-odbc package

# Setup from the unixODBC package

[MySQL]

Description     = ODBC for MySQL

Driver          = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so

Setup           =/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so

Driver64        = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so

Setup64         = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so

FileUsage       = 1

----------------------------------

Module 'res_odbc.so' reloaded successfully.

    -- Reloading module 'res_odbc.so' (ODBC resource)

[2022-06-07 22:28:10] NOTICE[1044]: res_odbc.c:706 load_odbc_config: Registered ODBC class 'asteriskcdrdb' dsn->[MySQL-asteriskcdrdb]

-------------------------------

 odbc show

ODBC DSN Settings

-----------------

  Name:   asteriskcdrdb

  DSN:    MySQL-asteriskcdrdb

    Number of active connections: 1 (out of 5)

    Logging: Disabled