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/12/04 13:34]
val [Настройка подключения]
сервис_odbc [2022/10/27 10:57] (current)
val [Настройка подключения]
Line 10: Line 10:
  
 ===== Установка коннектора MySQL ===== ===== Установка коннектора MySQL =====
 +
 +==== Debian 11 ====
 +
 +<​code>​
 +# apt install odbc-mariadb
 +</​code>​
  
 ==== Debian 9/10 ==== ==== Debian 9/10 ====
Line 33: 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 48: Line 56:
 [asterisk] [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>​ 
 +===== Проверка подключения ===== 
 +<​code>​
 # isql -v asterisk # isql -v asterisk
 </​code><​code>​ </​code><​code>​
сервис_odbc.1575455663.txt.gz · Last modified: 2019/12/04 13:34 by val