User Tools

Site Tools


сервис_odbc

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
сервис_odbc [2019/04/29 10:57]
val [Настройка подключения]
сервис_odbc [2021/11/09 13:06]
val [Debian 9/10]
Line 11: Line 11:
 ===== Установка коннектора MySQL ===== ===== Установка коннектора MySQL =====
  
-==== Debian 9 ====+==== Debian 11 ==== 
 + 
 +<​code>​ 
 +# apt install odbc-mariadb 
 +</​code>​ 
 + 
 +==== Debian 9/10 ====
  
   * [[https://​dev.mysql.com/​downloads/​connector/​odbc/​5.3.html|Download Connector/​ODBC]]   * [[https://​dev.mysql.com/​downloads/​connector/​odbc/​5.3.html|Download Connector/​ODBC]]
   ​   ​
 <​code>​ <​code>​
-# wget http://​val.bmstu.ru/​unix/​sql/​mysql-connector-odbc-5.3.9-linux-debian9-x86-64bit.tar.gz+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 # tar -xvf mysql-connector-odbc-5.3.*.tar.gz
  
-# cp -v mysql-connector-odbc-5.3.*-linux-debian9-x86-64bit/​lib/​libmyodbc5* /​usr/​lib/​x86_64-linux-gnu/​odbc/​+# cp -v mysql-connector-odbc-5.3.*-linux-debian*-x86-64bit/​lib/​libmyodbc5* /​usr/​lib/​x86_64-linux-gnu/​odbc/​
 </​code>​ </​code>​
  
Line 44: Line 52:
 # cat /​etc/​odbc.ini # cat /​etc/​odbc.ini
 </​code><​code>​ </​code><​code>​
-[asterisk_dsn]+[asterisk]
 Description=DSN to asterisk mysql DB Description=DSN to asterisk mysql DB
 Driver=myodbc_mysql Driver=myodbc_mysql
Line 57: Line 65:
 ReadOnly=No ReadOnly=No
 Charset=utf8 Charset=utf8
-</​code><​code>​ +</​code>​ 
-# isql -v asterisk_dsn+===== Проверка подключения ===== 
 +<​code>​ 
 +# isql -v asterisk
 </​code><​code>​ </​code><​code>​
 SQL> show tables; SQL> show tables;
сервис_odbc.txt · Last modified: 2022/10/27 10:57 by val