User Tools

Site Tools


сервис_odbc

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
сервис_odbc [2017/08/30 09:32]
val [Настройка подключения]
сервис_odbc [2021/11/09 13:06]
val [Debian 9/10]
Line 11: Line 11:
 ===== Установка коннектора MySQL ===== ===== Установка коннектора MySQL =====
  
-==== Debian ​====+==== Debian ​11 ====
  
-  ​[[https://​dev.mysql.com/​downloads/​connector/​odbc/​5.3.html|Download Connector/​ODBC]]+<​code>​ 
 +# apt install odbc-mariadb 
 +</​code>​ 
 + 
 +==== Debian 9/10 ==== 
 + 
 +  * [[https://​dev.mysql.com/​downloads/​connector/​odbc/​5.3.html|Download Connector/​ODBC]]
   ​   ​
 <​code>​ <​code>​
-cp mysql-connector-odbc-5.3.9-linux-debian9-x86-32bit/​lib/​libmyodbc5* /usr/lib/i386-linux-gnu/​odbc/​+debian9wget 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>​ </​code>​
  
-==== Debian/​Ubuntu ====+==== Debian ​8/​Ubuntu ​16 ====
  
 <​code>​ <​code>​
Line 34: Line 46:
 [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 
-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 50: Line 62:
 Password=asterisk Password=asterisk
 Database=asterisk Database=asterisk
-Option=3+#Option=3
 ReadOnly=No ReadOnly=No
-</​code><​code>​ +Charset=utf8 
-# isql -v asterisk_dsn+</​code>​ 
 +===== Проверка подключения ===== 
 +<​code>​ 
 +# isql -v asterisk
 </​code><​code>​ </​code><​code>​
 SQL> show tables; SQL> show tables;
-...+ 
 +SQL> select * from cdr; 
 +SQL> select fullname from sipfriends;
  
 SQL> quit SQL> quit
 </​code>​ </​code>​
сервис_odbc.txt · Last modified: 2022/10/27 10:57 by val