FreeSWITCH折腾笔记3——数据库修改为postgresql

需要修改的配置文件：

switch.conf.xml //核心表

cdr_pg_csv.conf.xml //通话记录 db.conf.xml //核心表
voicemail.conf.xml //留言相关的表
internal.xml //
external.xml //
fifo.conf.xml //fifo相关的表
callcenter.conf.xml //callcenter程序相关的表。

1、switch.conf.xml

2、cdr_pg_csv.conf.xml

3、db.conf.xml、voicemail.conf.xml、internal.xml、external.xml、fifo.conf.xml、callcenter.conf.xml

或者在var.xml追加以下配置，然后去注释db.conf.xml、voicemail.conf.xml、internal.xml、external.xml、fifo.conf.xml、callcenter.conf.xml 中的" "

【附】xml_cdr建表sql及cdr_pg_csv.conf.xml 字段设置

CREATE TABLE "public"."xml_cdr" ("uuid" uuid NOT NULL,"domain_uuid" uuid,"extension_uuid" uuid,"domain_name" text COLLATE "default","accountcode" text COLLATE "default","direction" text COLLATE "default","default_language" text COLLATE "default","context" text COLLATE "default","xml_cd" text COLLATE "default","json" jsonb,"caller_id_name" text COLLATE "default","caller_id_number" text COLLATE "default","source_number" text COLLATE "default","destination_number" text COLLATE "default","start_epoch" numeric,"start_stamp" timestamp(6),"answer_stamp" timestamp(6),"answer_epoch" numeric,"end_epoch" numeric,"end_stamp" text COLLATE "default","duration" numeric,"mduration" numeric,"billsec" numeric,"billmsec" numeric,"bridge_uuid" text COLLATE "default","read_codec" text COLLATE "default","read_rate" text COLLATE "default","write_codec" text COLLATE "default","write_rate" text COLLATE "default","remote_media_ip" text COLLATE "default","network_addr" text COLLATE "default","recording_file" text COLLATE "default","leg" char(1) COLLATE "default","pdd_ms" numeric,"rtp_audio_in_mos" numeric,"last_app" text COLLATE "default","last_arg" text COLLATE "default","cc_side" text COLLATE "default","cc_member_uuid" uuid,"cc_queue_joined_epoch" text COLLATE "default","cc_queue" text COLLATE "default","cc_member_session_uuid" uuid,"cc_agent" text COLLATE "default","cc_agent_type" text COLLATE "default","waitsec" numeric,"conference_name" text COLLATE "default","conference_uuid" uuid,"conference_member_id" text COLLATE "default","digits_dialed" text COLLATE "default","pin_number" text COLLATE "default","hangup_cause" text COLLATE "default","hangup_cause_q850" numeric,"sip_hangup_disposition" text COLLATE "default",CONSTRAINT "xml_cdr_pkey" PRIMARY KEY ("uuid"))WITH (OIDS=FALSE);ALTER TABLE "public"."xml_cdr" OWNER TO "freeswitch";

【附】录音文件路径写入数据库：

dialpanl/default.xml中添加一行，定义录音文件路径

再在autoload_configs/cdr_pg_csv.conf.xml的字段定义中添加一行

最后在数据库表中添加一个字段
recording_file

重新加载模块reload mod_cdr_pg_csv
再打电话就有录音路径生成了