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 [2021/11/09 13:07] val [Настройка подключения] |
сервис_odbc [2025/07/26 06:18] (current) val [Настройка подключения] |
||
|---|---|---|---|
| Line 11: | Line 11: | ||
| ===== Установка коннектора MySQL ===== | ===== Установка коннектора MySQL ===== | ||
| - | ==== Debian 11 ==== | + | ==== Debian11/Ubuntu24 ==== |
| <code> | <code> | ||
| # apt install odbc-mariadb | # apt install odbc-mariadb | ||
| - | </code> | ||
| - | |||
| - | ==== Debian 9/10 ==== | ||
| - | |||
| - | * [[https://dev.mysql.com/downloads/connector/odbc/5.3.html|Download Connector/ODBC]] | ||
| - | | ||
| - | <code> | ||
| - | 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 | ||
| - | |||
| - | # cp -v mysql-connector-odbc-5.3.*-linux-debian*-x86-64bit/lib/libmyodbc5* /usr/lib/x86_64-linux-gnu/odbc/ | ||
| - | </code> | ||
| - | |||
| - | ==== Debian 8/Ubuntu 16 ==== | ||
| - | |||
| - | <code> | ||
| - | # apt install libmyodbc | ||
| </code> | </code> | ||
| ===== Настройка подключения ===== | ===== Настройка подключения ===== | ||
| - | * [[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> | ||
| - | debian11# less /etc/odbcinst.ini | + | !!! Ничего не нужно менять !!! |
| - | # cat /etc/odbcinst.ini | + | debian11/ubuntu24# less /etc/odbcinst.ini |
| - | </code><code> | + | |
| - | [myodbc_mysql] | + | |
| - | Description=ODBC for MySQL | + | |
| - | Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so | + | |
| - | Setup=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5S.so | + | |
| - | #UsageCount=2 | + | |
| </code><code> | </code><code> | ||
| # cat /etc/odbc.ini | # cat /etc/odbc.ini | ||
| Line 57: | Line 31: | ||
| Description=DSN to asterisk mysql DB | Description=DSN to asterisk mysql DB | ||
| - | Driver=myodbc_mysql | + | Driver=MariaDB Unicode |
| - | #Driver=MariaDB Unicode | + | |
| ###Server=localhost | ###Server=localhost | ||
сервис_odbc.1636452462.txt.gz · Last modified: 2021/11/09 13:07 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
