This is an old revision of the document!
# apt install unixodbc
# wget http://val.bmstu.ru/unix/sql/mysql-connector-odbc-5.3.9-linux-debian9-x86-32bit.tar.gz # wget http://val.bmstu.ru/unix/sql/mysql-connector-odbc-5.3.9-linux-debian9-x86-64bit.tar.gz # tar -xvf mysql-connector-odbc-5.3.*.tar.gz # cp -v mysql-connector-odbc-5.3.9-linux-debian9-x86-32bit/lib/libmyodbc5* /usr/lib/i386-linux-gnu/odbc/ # cp -v mysql-connector-odbc-5.3.9-linux-debian9-x86-64bit/lib/libmyodbc5* /usr/lib/x86_64-linux-gnu/odbc/
# apt install libmyodbc
# cat /etc/odbcinst.ini
[myodbc_mysql] Description=ODBC for MySQL #Driver=/usr/lib/i386-linux-gnu/odbc/libmyodbc5a.so #Setup=/usr/lib/i386-linux-gnu/odbc/libmyodbc5S.so #Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so #Setup=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5S.so UsageCount=2
# cat /etc/odbc.ini
[asterisk_dsn] Description=description of your DSN Driver=myodbc_mysql Server=localhost Port=3306 Socket=/var/run/mysqld/mysqld.sock #Debug=1 USER=asterisk Password=asterisk Database=asterisk Option=3 ReadOnly=No Charset=utf8
# isql -v asterisk_dsn
SQL> show tables; SQL> select * from cdr; SQL> select fullname from sipfriends; SQL> quit