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

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

==== Debian/Ubuntu ====

<code>
# apt install unixodbc
</code>

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

==== Debian 11 ====

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

==== Debian 9/10 ====

  * [[https://dev.mysql.com/downloads/connector/odbc/5.3.html|Download Connector/ODBC]]
  
<code>
debian9# wget http://val.bmstu.ru/unix/sql/mysql-connector-odbc-5.3.9-linux-debian9-x86-64bit.tar.gz

debian10# wget http://val.bmstu.ru/unix/sql/mysql-connector-odbc-5.3.14-linux-debian10-x86-64bit.tar.gz

# tar -xvf mysql-connector-odbc-5.3.*.tar.gz

# cp -v mysql-connector-odbc-5.3.*-linux-debian*-x86-64bit/lib/libmyodbc5* /usr/lib/x86_64-linux-gnu/odbc/
</code>

==== Debian 8/Ubuntu 16 ====

<code>
# apt install libmyodbc
</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

debian10# cat /etc/odbcinst.ini
</code><code>
[myodbc_mysql]
Description=ODBC for MySQL
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so
Setup=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5S.so
#UsageCount=2
</code><code>
# cat /etc/odbc.ini
</code><code>
[asterisk]
Description=DSN to asterisk mysql DB

Driver=myodbc_mysql
#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>