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 8: Line 8:


<code># Driver from the mysql-connector-odbc package
<code># Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
# Setup from the unixODBC package
[MySQL]
[MySQL]
Description    = ODBC for MySQL
Description    = ODBC for MySQL
Driver          = /usr/lib/libmyodbc5.so
Driver          = /usr/lib/libmyodbc5.so
Setup          = /usr/lib/libodbcmyS.so
Setup          = /usr/lib/libodbcmyS.so
Driver64        = /usr/lib64/libmyodbc5.so
Driver64        = /usr/lib64/libmyodbc5.so
Setup64        = /usr/lib64/libodbcmyS.so
Setup64        = /usr/lib64/libodbcmyS.so
FileUsage      = 1</code>
FileUsage      = 1</code>


3. Setup /etc/odbc.ini
3. Setup /etc/odbc.ini

Revision as of 19:00, 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

# Driver from the mysql-connector-odbc package

# Setup from the unixODBC package
[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