FreeSWITCH中文网,电话机器人开发网 ,微信订阅号:

FreeSWITCH及VOIP,Openser,电话机器人等产品中文技术资讯、交流、沟通、培训、咨询、服务一体化网络。QQ群:293697898

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


tags:FreeSWITCH mysql odbc 配置 创建时间:2015-09-07 18:58:45

来自于: https://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core

  1. Install unixODBC

sudo apt-get install unixodbc-dev libmyodbc

  1. 配置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
  1. 测试ODBC

isql -v freeswitch

如果正常会显示以下:

+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>
  1. 配置到FreeSWITCH中的DSN格式

    DSN with username and password or

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

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

<param name="odbc-dsn" value="MYSQLTP:root:123456"/>
  1. 修改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群: