This shows you the differences between two versions of the page.
Next revision | Previous revision Last revision Both sides next revision | ||
сервис_odbc [2017/08/30 06:58] val создано |
сервис_odbc [2022/09/21 13:35] val [Настройка подключения] |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Сервис ODBC ====== | ====== Сервис 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 | ||
+ | |||
+ | # 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> |