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 Next revision Both sides next revision | ||
|
сервис_odbc [2019/02/08 13:34] val [Настройка подключения] |
сервис_odbc [2019/12/04 13:34] val [Настройка подключения] |
||
|---|---|---|---|
| Line 11: | Line 11: | ||
| ===== Установка коннектора MySQL ===== | ===== Установка коннектора MySQL ===== | ||
| - | ==== Debian 9 ==== | + | ==== Debian 9/10 ==== |
| * [[https://dev.mysql.com/downloads/connector/odbc/5.3.html|Download Connector/ODBC]] | * [[https://dev.mysql.com/downloads/connector/odbc/5.3.html|Download Connector/ODBC]] | ||
| | | ||
| <code> | <code> | ||
| - | # wget http://val.bmstu.ru/unix/sql/mysql-connector-odbc-5.3.9-linux-debian9-x86-64bit.tar.gz | + | 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 | # 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 40: | Line 42: | ||
| Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so | Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so | ||
| Setup=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5S.so | Setup=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5S.so | ||
| - | UsageCount=2 | + | #UsageCount=2 |
| </code><code> | </code><code> | ||
| # cat /etc/odbc.ini | # cat /etc/odbc.ini | ||
| </code><code> | </code><code> | ||
| - | [asterisk_dsn] | + | [asterisk] |
| - | Description=description of your DSN | + | Description=DSN to asterisk mysql DB |
| Driver=myodbc_mysql | Driver=myodbc_mysql | ||
| - | Server=localhost | + | #Server=localhost |
| - | Port=3306 | + | #Port=3306 |
| Socket=/var/run/mysqld/mysqld.sock | Socket=/var/run/mysqld/mysqld.sock | ||
| #Debug=1 | #Debug=1 | ||
| Line 54: | Line 56: | ||
| Password=asterisk | Password=asterisk | ||
| Database=asterisk | Database=asterisk | ||
| - | Option=3 | + | #Option=3 |
| ReadOnly=No | ReadOnly=No | ||
| Charset=utf8 | Charset=utf8 | ||
| </code><code> | </code><code> | ||
| - | # isql -v asterisk_dsn | + | # isql -v asterisk |
| </code><code> | </code><code> | ||
| SQL> show tables; | SQL> show tables; | ||
сервис_odbc.txt · Last modified: 2022/10/27 10:57 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
