FreeSWITCH使用mysql等采用ODBC方式作为内核数据库

FreeSWITCH使用mysql等采用ODBC方式作为内核数据库

            来自于: [https://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core](https://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core)
  • Install unixODBC

sudo apt-get install unixodbc-dev libmyodbc

  • 配置odbc

/etc/odbc.ini for MySQL

`[freeswitch]
Driver      = /usr/lib64/odbc/libmyodbc.so
SERVER      = localhost
PORT        = 3306
DATABASE    = freeswitch
OPTION      = 67108864
USER                = root
PASSWORD    = password

/etc/odbcinst.ini for MySQL

`[MySQL]
Description = MySQL driver
Driver      = /usr/lib64/odbc/libmyodbc.so
Setup       = /usr/lib64/odbc/libodbcmyS.so
UsageCount  = 1
FileUsage       = 1
Threading       = 0

  • 测试ODBC

isql -v freeswitch

如果正常会显示以下:

`+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

配置到FreeSWITCH中的DSN格式

DSN with username and password

or

配置相关的配置文件,如:

1.修改conf/autoload_configs中的db.conf.xml文件

`<param name="odbc-dsn" value="MYSQLTP:root:123456"/>

  • 修改conf/autoload_configs中的switch.conf.xml

修改字段

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

添加

`<param name="odbc-dsn" value="MYSQLTP:root:123456"/>

3.修改conf/autoload_configs中的voicemail.conf.xml

修改字段

`<param name="odbc-dsn" value="MYSQLTP:root:123456"/>

4.修改conf/autoload_configs中的callcenter.conf.xml

`<param name="odbc-dsn" value="MYSQLTP:root:123456"/>

5.修改conf/sip_profiles中的internal.xml 和external.xml,internal-ipv6.xml

`<param name="odbc-dsn" value="MYSQLTP:root:123456"/>

上海老李,QQ:1354608370,FreeSWITCH QQ群: