asterisk-16 freepbx16 odbc cdrレポート表示

sudo apt install unixodbc unixodbc-dev

次をダウンロードインストールする

http://archive.ubuntu.com/ubuntu/pool/universe/m/mariadb-connector-odbc/odbc-mariadb_3.1.4-1_amd64.deb

archive.ubuntu.com

vi /etc/odbc.ini

[MySQL-asteriskcdrdb]
Description = MySQL connection to ‘asteriskcdrdb’ database
Driver = MySQL
Server = localhost
Database = asteriskcdrdb
Port = 3306
Socket = /var/run/mysqld/mysqld.sock
Option = 3

vi /etc/odbcinst.ini

[MySQL]
Description = ODBC for MySQL (MariaDB)
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so
FileUsage = 1

odbc接続がOKの場合

deskmini*CLI> odbc show

ODBC DSN Settings
—————–

Name: asteriskcdrdb
DSN: MySQL-asteriskcdrdb
Number of active connections: 1 (out of 5)
Logging: Disabled