User Tools

Site Tools


сервис_odbc

This is an old revision of the document!


Сервис ODBC

Установка драйвера ODBC

Debian/Ubuntu

# apt install unixodbc

Установка коннектора MySQL

Debian 9

# cp mysql-connector-odbc-5.3.9-linux-debian9-x86-32bit/lib/libmyodbc5* /usr/lib/i386-linux-gnu/odbc/

Debian/Ubuntu

# apt install libmyodbc

Настройка подключения

# cat /etc/odbcinst.ini
[myodbc_mysql]
Description=ODBC for MySQL
Driver=/usr/lib/i386-linux-gnu/odbc/libmyodbc5a.so
Setup=/usr/lib/i386-linux-gnu/odbc/libmyodbc5S.so
UsageCount=2
# cat /etc/odbc.ini
[asterisk_dsn]
Description=description of your DSN
Driver=myodbc_mysql
Server=localhost
Port=3306
Socket=/var/run/mysqld/mysqld.sock
#Debug=1
USER=asterisk
Password=asterisk
Database=asterisk
Option=3
ReadOnly=No
# isql -v asterisk_dsn
SQL> show tables;
...

SQL> quit
сервис_odbc.1512984257.txt.gz · Last modified: 2017/12/11 12:24 by val