Differences

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

--- wiki:voip:asterisk:odbc [2012/12/11 08:51]
root
+++ wiki:voip:asterisk:odbc [2014/12/26 18:31] (current)
@@ Line 1: / Line 1: @@
-Instalace ODBC
+====== Instalace ODBC ======
-|root@server:~# **apt-get install unixodbc libmyodbc odbcinst1debian2**
-Kontrola zda existují tyto soubory:
+>root@server:~# **apt-get install unixodbc libmyodbc odbcinst1debian2 unixODBC unixODBC-dev**
+Zkontrolujeme zda existují tyto soubory:
   * /etc/odbc.ini
   * /etc/odbcinst.ini
@@ Line 13: / Line 14: @@
 <code>
 root@server:~# ls /usr/lib/odbc/
+#(nebo ls /usr/lib/x86_64-linux-gnu/odbc/)
+#(nebo /usr/lib/i386-linux-gnu/odbc/)
 libesoobS.so  libmyodbc.so  libodbcdrvcfg1S.so	libodbcminiS.so  libodbcnnS.so	  libodbctxtS.so  liboraodbcS.so  libtdsS.so
 libmimerS.so  libnn.so	    libodbcdrvcfg2S.so	libodbcmyS.so	 libodbcpsqlS.so  liboplodbcS.so  libsapdbS.so
@@ Line 20: / Line 24: @@
 >root@server:~# **nano odbc/mysql**
-<file - mysql>
+<file - /root/odbc/mysql>
 [MySQL]
 Description     = MySQL driver for Linux & Win32
@@ Line 34: / Line 38: @@
     Target directory is /etc
 </code>
+>root@server:~# **nano /etc/odbc.ini**
+<file - /etc/odbc.ini>
+[asterisk]
+Description = MySQL Asterisk
+Driver      = MySQL
+SERVER      = localhost
+USER        = username
+PASSWORD    = password
+PORT        = 3306
+DATABASE    = asterisk
+Option      = 3
+</file>
+>root@server:~# **isql asterisk**
+<code>
+root@server:~# isql asterisk
++---------------------------------------+
+| Connected!                            |
+|                                       |
+| sql-statement                         |
+| help [tablename]                      |
+| quit                                  |
+|                                       |
++---------------------------------------+
+SQL>
+</code>

wiki.lkaplan.cz

User Tools

Site Tools

Differences

Page Tools