FreeSWITCH toss notes 3 Mui-database modified to postgresql

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.