FreeSWITCH ODBC cdr

freeswitch-1.10.6.-release

Ubuntu20.04

1、安装apt-get install unixodbc

2、去官网下载合适的驱动包https://dev.mysql.com/downloads/connector/odbc/   注意使用5.3的版本

3、配置ODBC

# vim /etc/odbc.ini
[freeswitch]
Driver = MySQL
SERVER = localhost 请填写实际MySql 服务器地址
PORT = 3306
DATABASE = freeswitch  请更改为自己的数据库名
OPTION = 67108864

4、验证ODBC isql -v freeswitch

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

5、重新编译freeswitch vim /usr/local/src/freeswitch/modules.conf

event_handlers/mod_odbc_cdr
#applications/mod_abstraction
#applications/mod_av
#applications/mod_avmd
#applications/mod_bert
#applications/mod_blacklist
#applications/mod_callcenter
#applications/mod_cidlookup
#applications/mod_cluechoo
applications/mod_commands

make && make install

6、复制配置文件到freeswitch 配置目录

cp /usr/local/src/freeswitch/src/mod/event_handlers/mod_odbc_cdr/conf/autoload_configs/odbc_cdr.conf.xml /usr/local/freeswitch/conf/autoload_configs/odbc_cdr.conf.xml

7、修改配置文件

 

2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58

<configuration name="odbc_cdr.conf" description="ODBC CDR Configuration"> <settings> <!-- <param name="odbc-dsn" value=