How to set up an Asterisk ODBC data source on Linux
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
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.
[connection_name] Description = your text Trace = Off TraceFile = stderr Driver = MySQL SERVER = localhost PORT = 3306 DATABASE = database_name
4. Test the connection
USER and PASSWORD should be substituted with the correct credentials to access the database specified in /etc/odbc.ini
isql connection_name USER PASSWORD