Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

FreeSWITCH toss notes 3 Mui-database modified to postgresql

2025-04-12 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >

Share

Shulou(Shulou.com)06/02 Report--

Configuration files that need to be modified:

Switch.conf.xml / / Core list

Cdr_pg_csv.conf.xml / / call record db.conf.xml / / Core list

Voicemail.conf.xml / / forms related to messages

Internal.xml / /

External.xml / /

Fifo.conf.xml / / fifo related tables

Tables related to callcenter.conf.xml / / callcenter programs.

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

Or append the following configuration to var.xml, and then comment on "" in db.conf.xml, voicemail.conf.xml, internal.xml, external.xml, fifo.conf.xml, and callcenter.conf.xml

[attached] xml_cdr build table sql and cdr_pg_csv.conf.xml field settings

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 "

[attachment] the path of the recording file is written to the database:

Add a line to dialpanl/default.xml to define the recording file path

Add a row to the field definition of autoload_configs/cdr_pg_csv.conf.xml

Finally, add a field to the database table

Recording_file

Reload the module reload mod_cdr_pg_csv

If you make another call, the recording path will be generated.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Servers

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report