freeswitch支持mysql连接

1.安装mysql数据库

https://www.runoob.com/mysql/mysql-install.html

2.安装unixodbc

unixODBC是一个可以让你在Unix/Linux系统下使用ODBC来连接数据库的组件，就像java中的mysql-connector-java-5.1.6-bin.jar一样，负责连接数据库的。

yum install unixODBC-devel.x86_64

yum install mysql-connector-odbc.x86_64

安装后修改两个文件：/etc/odbc.ini,/etc/odbcinst.ini       /etc/odbc.ini  配置要连接的数据库信息，odbc.ini没有就新建一个

# Example driver definitions

# Driver from the postgresql-odbc package
# Setup from the unixODBC package
[PostgreSQL]
Description     = ODBC for PostgreSQL
Driver          = /usr/lib/psqlodbcw.so
Setup           = /usr/lib/libodbcpsqlS.so
Driver64        = /usr/lib64/psqlodbcw.so
Setup64         = /usr/lib64/libodbcpsqlS.so
FileUsage       = 1


# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib64/libmyodbc5.so
Setup           = /usr/lib64/libodbcmyS.so
Driver64        = /usr/lib64/libmyodbc5.so
Setup64         = /usr/lib64/libodbcmyS.so
FileUsage       = 1

[freeswitch]

Driver          = MySQL

SERVER       = ip

PORT           = 3306

DATABASE    = database

USER            = user

PASSWORD   = password

修改之后，执行  isql -v freeswitch root '123456'

如果出现

[root@localhost mysql]# isql -v freeswitch
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> 

则代表你的unixodbc配置成功了

3.修改dsn

搜索 dsn 来查找哪些配置文件中有这个项目

grep -ir dsn

会找到类似下面这个的配置文件，之后将配置文件中的dsn项目修改成我们上面添加的mysql的dsn就可以了，所有找到的都要修改。

<param name="core-db-dsn"value="dsn:user:pass"/>

<param name="core-db-dsn" value="freeswitch:root:123456" />