User Tools
сервис_odbc
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
сервис_odbc [2019/12/04 13:19] val [Debian 9] |
сервис_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 22: | Line 28: | ||
| # 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 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 46: | 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.1575454757.txt.gz · Last modified: 2019/12/04 13:19 by val
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
