FreeSWITCH话单使用mysql原生存储
FreeSWITCH话单使用mysql原生存储
QQ群:293697898 FreeSwitch+Kamailio+Opensips
遇到很多人想要存储话单,我的第一建议是用FreeSWITCH官方推荐的pg_cdr模块,但又有很多人希望使用mysql,那么多年前哥们写过一个mysql原生模块在:
https://github.com/ordinerf/mod_cdr_mysql/
` apt-get install mysql-server
apt-get install libmysql++-dev
在安装了mysql-server后,mysql -u root -p后
`create database cdr;
CREATE TABLE IF NOT EXISTS freeswitch_cdr (
id int(11) NOT NULL AUTO_INCREMENT,
direction varchar(16) DEFAULT NULL,
call_id varchar(255) DEFAULT NULL,
local_ip_v4 varchar(32) CHARACTER SET latin1 DEFAULT NULL,
caller_id_number varchar(255) CHARACTER SET latin1 DEFAULT NULL,
context varchar(32) DEFAULT NULL,
destination_number varchar(255) CHARACTER SET latin1 DEFAULT NULL,
route varchar(255) DEFAULT NULL,
route_ip varchar(32) DEFAULT NULL,
start_stamp timestamp NULL DEFAULT NULL,
answer_stamp timestamp NULL DEFAULT NULL,
end_stamp timestamp NULL DEFAULT NULL,
duration int(11) DEFAULT NULL,
billsec int(11) DEFAULT NULL,
hangup_cause varchar(64) CHARACTER SET latin1 DEFAULT NULL,
uuid varchar(255) CHARACTER SET latin1 DEFAULT NULL,
read_codec varchar(64) CHARACTER SET latin1 DEFAULT NULL,
write_codec varchar(64) CHARACTER SET latin1 DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
然后git clone下以上的git到fs/src/mod/event_handlers/下
并进行编译,一切顺利就会把模块加载到你的fs中了
`freeswitch@internal> load mod_cdr_mysql
+OK Reloading XML
+OK
2016-04-25 18:12:21.721813 [INFO] mod_enum.c:880 ENUM Reloaded
2016-04-25 18:12:21.721813 [INFO] switch_time.c:1415 Timezone reloaded 1750 definitions
2016-04-25 18:12:21.721813 [INFO] mod_cdr_mysql.c:539
##########################################
########## MySQL CDR LOADED ##########
##########################################
########## HOST : localhost
########## DB : cdr
########## Table : freeswitch_cdr
##########################################
2016-04-25 18:12:21.721813 [CONSOLE] switch_loadable_module.c:1465 Successfully Loaded [mod_cdr_mysql]
上海老李,QQ:1354608370,FreeSWITCH QQ群: