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:32] val [Debian8/Ubuntu16] |
сервис_odbc [2019/04/29 10:57] val [Настройка подключения] |
||
---|---|---|---|
Line 16: | Line 16: | ||
| | ||
<code> | <code> | ||
- | # wget http://val.bmstu.ru/unix/sql/mysql-connector-odbc-5.3.9-linux-debian9-x86-32bit.tar.gz | ||
# wget http://val.bmstu.ru/unix/sql/mysql-connector-odbc-5.3.9-linux-debian9-x86-64bit.tar.gz | # wget http://val.bmstu.ru/unix/sql/mysql-connector-odbc-5.3.9-linux-debian9-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-32bit/lib/libmyodbc5* /usr/lib/i386-linux-gnu/odbc/ | ||
# 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-debian9-x86-64bit/lib/libmyodbc5* /usr/lib/x86_64-linux-gnu/odbc/ | ||
</code> | </code> | ||
Line 40: | Line 38: | ||
[myodbc_mysql] | [myodbc_mysql] | ||
Description=ODBC for MySQL | Description=ODBC for MySQL | ||
- | #Driver=/usr/lib/i386-linux-gnu/odbc/libmyodbc5a.so | + | Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so |
- | #Setup=/usr/lib/i386-linux-gnu/odbc/libmyodbc5S.so | + | Setup=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5S.so |
- | #Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so | + | #UsageCount=2 |
- | #Setup=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5S.so | + | |
- | UsageCount=2 | + | |
</code><code> | </code><code> | ||
# cat /etc/odbc.ini | # cat /etc/odbc.ini | ||
</code><code> | </code><code> | ||
[asterisk_dsn] | [asterisk_dsn] | ||
- | 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 58: | Line 54: | ||
Password=asterisk | Password=asterisk | ||
Database=asterisk | Database=asterisk | ||
- | Option=3 | + | #Option=3 |
ReadOnly=No | ReadOnly=No | ||
Charset=utf8 | Charset=utf8 |