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


2.Check that /etc/odbcinst.ini should contain something like the following for mysql
2.Check that /etc/odbcinst.ini should contain something like the following for mysql
<code># 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</code>


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

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

  1. 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