This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
сервис_odbc [2022/09/21 13:35] val [Настройка подключения] |
сервис_odbc [2025/01/28 07:28] (current) val |
||
---|---|---|---|
Line 15: | Line 15: | ||
<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> | ||
Line 42: | Line 22: | ||
<code> | <code> | ||
+ | !!! Ничего не нужно менять !!! | ||
+ | |||
debian11# less /etc/odbcinst.ini | debian11# less /etc/odbcinst.ini | ||
- | |||
- | # cat /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 |