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
сервис_odbc [2018/12/13 09:21]
val [Debian/Ubuntu]
сервис_odbc [2022/10/27 10:57] (current)
val [Настройка подключения]
Line 11: Line 11:
 ===== Установка коннектора MySQL ===== ===== Установка коннектора MySQL =====
  
-==== Debian 9 ====+==== Debian 11 ==== 
 + 
 +<​code>​ 
 +# apt install odbc-mariadb 
 +</​code>​ 
 + 
 +==== 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-32bit.tar.gz+debian9# 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.9-linux-debian9-x86-32bit.tar.gz+debian10wget http://​val.bmstu.ru/​unix/​sql/​mysql-connector-odbc-5.3.14-linux-debian10-x86-64bit.tar.gz
  
-# cp mysql-connector-odbc-5.3.9-linux-debian9-x86-32bit/​lib/​libmyodbc5* /usr/lib/i386-linux-gnu/​odbc/​+# 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>​
  
-==== Debian8/Ubuntu16 ​====+==== Debian 8/Ubuntu 16 ====
  
 <​code>​ <​code>​
Line 31: Line 39:
 ===== Настройка подключения ===== ===== Настройка подключения =====
  
-  * [[http://www.kaffeetalk.de/how-to-setup-and-configure-mysql-with-unixodbc-under-ubuntu-14-04/​|How to setup and configure MySQL with unixODBC under Ubuntu 14.04]]+  * [[https://askubuntu.com/​questions/621442/odbc-error-connecting-to-mysql|How to setup and configure MySQL with unixODBC under Ubuntu 14.04]]
  
 <​code>​ <​code>​
-# cat /​etc/​odbcinst.ini+debian11# less /​etc/​odbcinst.ini 
 + 
 +debian10# cat /​etc/​odbcinst.ini
 </​code><​code>​ </​code><​code>​
 [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 +#​Driver=MariaDB Unicode 
-Port=3306+ 
 +###Server=localhost 
 +###Port=3306
 Socket=/​var/​run/​mysqld/​mysqld.sock Socket=/​var/​run/​mysqld/​mysqld.sock
-#Debug=1+
 USER=asterisk USER=asterisk
 Password=asterisk Password=asterisk
 Database=asterisk Database=asterisk
-Option=3+
 ReadOnly=No ReadOnly=No
 Charset=utf8 Charset=utf8
-</​code><​code>​ +</​code>​ 
-# isql -v asterisk_dsn+===== Проверка подключения ===== 
 +<​code>​ 
 +# isql -v asterisk
 </​code><​code>​ </​code><​code>​
 SQL> show tables; SQL> show tables;
сервис_odbc.1544682080.txt.gz · Last modified: 2018/12/13 09:21 by val