This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
сервис_odbc [2021/11/09 13:06] val [Debian 9/10] |
сервис_odbc [2022/10/27 10:57] (current) val [Настройка подключения] |
||
---|---|---|---|
Line 39: | 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 54: | 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 |