Differences

This shows you the differences between two versions of the page.

--- сервис_odbc [2017/08/30 06:58]
val создано
+++ сервис_odbc [2020/12/17 12:14]
val [Настройка подключения]
@@ Line 1: / Line 1: @@
 ====== Сервис ODBC ======
+===== Установка драйвера ODBC =====
+==== Debian/Ubuntu ====
+<code>
+# apt install unixodbc
+</code>
+===== Установка коннектора MySQL =====
+==== 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>
+===== Настройка подключения =====
+  * [[http://www.kaffeetalk.de/how-to-setup-and-configure-mysql-with-unixodbc-under-ubuntu-14-04/|How to setup and configure MySQL with unixODBC under Ubuntu 14.04]]
+<code>
+# 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
+#Server=localhost
+#Port=3306
+Socket=/var/run/mysqld/mysqld.sock
+#Debug=1
+USER=asterisk
+Password=asterisk
+Database=asterisk
+#Option=3
+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>

Методические материалы Лохтурова Вячеслава

User Tools

Site Tools

Differences

Page Tools