How to set up an Asterisk ODBC data source on Linux

From voipsupport
Revision as of 20:02, 11 June 2016 by John (talk | contribs)
Jump to navigation Jump to search

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 

[mysqlrouting]
Description     = your text
Trace           = Off
TraceFile       = stderr
Driver          = MySQL
SERVER          = localhost
PORT            = 3306
DATABASE        = database_name
Retrieved from "http://voipsupport.it/wiki/index.php?title=How_to_set_up_an_Asterisk_ODBC_data_source_on_Linux&oldid=161"