Ubuntu FreeSWITCH MySQL 替换 Sqlite3

Linux and FreeSWITCH Version

Linux Version：Ubuntu 16.04.4 LTS
FreeSWITCH Version: 1.8.5

Install uinxodbc-dev和libmyodbc

• 安装uinxodbc-dev

apt-get install unixodbc-dev
apt-get install unixodbc

• 安装libmyodbc
  mysql下载地址
  [mysql-connector]: http://dev.mysql.com/downloads/connector/odbc/

wget https://dev.mysql.com/get/Downloads/Connector-ODBC/8.0/mysql-connector-odbc-8.0.15-linux-ubuntu16.04-x86-64bit.tar.gz
tar -zxvf mysql-connector-odbc-8.0.15-linux-ubuntu16.04-x86-64bit.tar.gz
cd mysql-connector-odbc-8.0.15-linux-ubuntu16.04-x86-64bit
cp libmyodbc8a.so /usr/lib/x86_64-linux-gnu/odbc/

配置数据库DSN

# path:/etc/odbcinst.ini
[MySQL]
Description 		= ODBC for MySQL
Driver 				= /usr/lib/x86_64-linux-gnu/odbc/libmyodbc8a.so
Setup 				= /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
UsageCount 			= 1
FileUsage 			= 1
Threading 			= 0

# path:/etc/odbc.ini
[freeswitch]
Description         = MySQL connection to database
Driver              = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc8a.so
Database            = freeswitch
Server              = host-IP
User				= username
Password            = password
Port                = Host-Port
OPTION              = 67108864

测试

先在服务器创建数据库"freeswitch"

isql freeswitch -v
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

Reference

• Installing-ubuntu-16-04-lts-how-to-install-odbc
  [blog]: https://askubuntu.com/questions/800216/installing-ubuntu-16-04-lts-how-to-install-odbc