How to set up an Asterisk ODBC data source on Linux: Difference between revisions
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 20: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