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
сервис_odbc [2019/04/29 10:57]
val [Настройка подключения]
сервис_odbc [2022/10/27 10:57] (current)
val [Настройка подключения]
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 31: Line 39:
 ===== Настройка подключения ===== ===== Настройка подключения =====
  
-  * [[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]]+  * [[https://askubuntu.com/​questions/621442/odbc-error-connecting-to-mysql|How to setup and configure MySQL with unixODBC under Ubuntu 14.04]]
  
 <​code>​ <​code>​
-# cat /​etc/​odbcinst.ini+debian11# less /​etc/​odbcinst.ini 
 + 
 +debian10# cat /​etc/​odbcinst.ini
 </​code><​code>​ </​code><​code>​
 [myodbc_mysql] [myodbc_mysql]
Line 44: Line 54:
 # 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
-#​Server=localhost +#​Driver=MariaDB Unicode 
-#Port=3306+ 
 +###​Server=localhost 
 +###Port=3306
 Socket=/​var/​run/​mysqld/​mysqld.sock Socket=/​var/​run/​mysqld/​mysqld.sock
-#Debug=1+
 USER=asterisk USER=asterisk
 Password=asterisk Password=asterisk
 Database=asterisk Database=asterisk
-#Option=3+
 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.1556524676.txt.gz · Last modified: 2019/04/29 10:57 by val