How to set up an Asterisk ODBC data source on Linux: Difference between revisions
No edit summary |
No edit summary |
||
Line 33: | Line 33: | ||
<pre>isql name user password</pre> | <pre>isql name user password</pre> | ||
You should get an sql prompt like this | |||
<pre>+---------------------------------------+ | |||
| Connected! | | |||
| | | |||
| sql-statement | | |||
| help [tablename] | | |||
| quit | | |||
| | | |||
+---------------------------------------+</pre> | |||
You may then type sql commands, for example if you have a table in your database named callerid: | |||
<pre>select * from callerid</pre> |
Revision as of 20:13, 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
[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.
[name] Description = your text Trace = Off TraceFile = stderr Driver = MySQL SERVER = localhost PORT = 3306 DATABASE = database_name
4. Test the connection
the name should be the same as the connection name (the section defined between [ ]) in /etc/odbc.ini. The user and password should be substituted with the correct credentials to access the database specified in /etc/odbc.ini
isql name user password
You should get an sql prompt like this
+---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+
You may then type sql commands, for example if you have a table in your database named callerid:
select * from callerid