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

需要修改的配置文件&＃xff1a;

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

password

&＃39; options&＃61;&＃39;-c client_min_messages&＃61;NOTICE&＃39; application_name&＃61;&＃39;freeswitch&＃39;"/>

或者在var.xml追加以下配置&＃xff0c;然后去注释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&＃61;FALSE)

;

ALTER TABLE "public"."xml_cdr" OWNER TO "freeswitch";

【附】录音文件路径写入数据库&＃xff1a;

dialpanl/default.xml中添加一行&＃xff0c;定义录音文件路径

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

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

recording_file

重新加载模块reload mod_cdr_pg_csv

再打电话就有录音路径生成了