How to set up an Asterisk ODBC data source on Linux: Difference between revisions

From voipsupport
Jump to navigation Jump to search
No edit summary
No edit summary
Line 19: Line 19:
The name of the section between [ ] becomes the name of the ODBC connection. The other values should be customized as required, in particular the DATABASE should contain the name of the database to connect to.
The name of the section between [ ] becomes the name of the ODBC connection. The other values should be customized as required, in particular the DATABASE should contain the name of the database to connect to.


<pre>[connection_name]
<pre>[name]
Description    = your text
Description    = your text
Trace          = Off
Trace          = Off
Line 30: Line 30:
4. Test the connection  
4. Test the connection  


USER and PASSWORD should be substituted with the correct credentials to access the database specified in /etc/odbc.ini
the name should be the same as the connection name (the section defined between [ ]) in /etc/odbc.ini. The user and password should be substituted with the correct credentials to access the database specified in /etc/odbc.ini


<pre>isql connection_name USER PASSWORD</pre>
<pre>isql name user password</pre>

Revision as of 20:11, 11 June 2016

These steps were tested on Centos 6.3

1. Install unixODBC and mysql ODBC connector 

yum install unixODBC mysql-connector-odbc

2.Check that /etc/odbcinst.ini should contain something like the following for mysql 

[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib/libmyodbc5.so
Setup           = /usr/lib/libodbcmyS.so
Driver64        = /usr/lib64/libmyodbc5.so
Setup64         = /usr/lib64/libodbcmyS.so
FileUsage       = 1

3. Setup /etc/odbc.ini

The name of the section between [ ] becomes the name of the ODBC connection. The other values should be customized as required, in particular the DATABASE should contain the name of the database to connect to. 

[name]
Description     = your text
Trace           = Off
TraceFile       = stderr
Driver          = MySQL
SERVER          = localhost
PORT            = 3306
DATABASE        = database_name

4. Test the connection

the name should be the same as the connection name (the section defined between [ ]) in /etc/odbc.ini. The user and password should be substituted with the correct credentials to access the database specified in /etc/odbc.ini 

isql name user password
Retrieved from "http://voipsupport.it/wiki/index.php?title=How_to_set_up_an_Asterisk_ODBC_data_source_on_Linux&oldid=164"