====== Сервис ODBC ======

===== Установка драйвера ODBC =====

==== Debian/Ubuntu ====

<code>
# apt install unixodbc
</code>

===== Установка коннектора MySQL =====

==== Debian 11 ====

<code>
# apt install odbc-mariadb
</code>

===== Настройка подключения =====

  * [[https://askubuntu.com/questions/621442/odbc-error-connecting-to-mysql|How to setup and configure MySQL with unixODBC under Ubuntu 14.04]]

<code>
!!! Ничего не нужно менять !!!

debian11# less /etc/odbcinst.ini
</code><code>
# cat /etc/odbc.ini
</code><code>
[asterisk]
Description=DSN to asterisk mysql DB

Driver=MariaDB Unicode

###Server=localhost
###Port=3306
Socket=/var/run/mysqld/mysqld.sock

USER=asterisk
Password=asterisk
Database=asterisk

ReadOnly=No
Charset=utf8
</code>
===== Проверка подключения =====
<code>
# isql -v asterisk
</code><code>
SQL> show tables;

SQL> select * from cdr;
SQL> select fullname from sipfriends;

SQL> quit
</code>