首页 > 代码库 > FreeSWITCH折腾笔记3——数据库修改为postgresql
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
<param name="core-db-dsn" value="pgsql://host=localhost dbname=freeswitch user=freeswitch password=‘password‘ options=‘-c client_min_messages=NOTICE‘ application_name=‘freeswitch‘" />
2、cdr_pg_csv.conf.xml
<param name="db-info" value="http://www.mamicode.com/host=localhost user=freeswitch password=nopassword dbname=freeswitch connect_timeout=10" /> <param name="db-table" value="http://www.mamicode.com/xml_cdr"/>
3、db.conf.xml、voicemail.conf.xml、internal.xml、external.xml、fifo.conf.xml、callcenter.conf.xml
<param name="odbc-dsn" value="pgsql://host=localhost dbname=freeswitch user=freeswitch password=‘ password ‘ options=‘-c client_min_messages=NOTICE‘ application_name=‘freeswitch‘"/>
或者在var.xml追加以下配置,然后去注释db.conf.xml、voicemail.conf.xml、internal.xml、external.xml、fifo.conf.xml、callcenter.conf.xml 中的" <param name="odbc-dsn" value="http://www.mamicode.com/$${dsn}"/>"
<X-PRE-PROCESS cmd="set" data="http://www.mamicode.com/dsn=pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password=‘password‘ options=‘-c client_min_messages=NOTICE‘ application_name=‘freeswitch‘" /> <X-PRE-PROCESS cmd="set" data="http://www.mamicode.com/dsn_callcenter=pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password=‘password‘ options=‘-c client_min_messages=NOTICE‘ application_name=‘freeswitch‘" />
【附】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";
</settings> <schema> <field var="uuid"/> <field var="domain_uuid"/> <field var="domain_name"/> <field var="accountcode"/> <field var="direction"/> <field var="default_language"/> <field var="context"/> <field var="xml_cdr"/> <!-- <field var="local_ip_v4"/> --> <field var="caller_id_name"/> <field var="caller_id_number"/> <field var="destination_number"/> <field var="start_epoch"/> <field var="start_stamp"/> <field var="answer_stamp"/> <field var="answer_epoch"/> <field var="end_epoch"/> <field var="end_stamp"/> <field var="duration"/> <field var="mduration"/> <field var="billsec"/> <field var="billmsec"/> <field var="bridge_uuid"/> <!-- <field var="bleg_uuid"/> --> <field var="read_codec"/> <field var="read_rate"/> <field var="write_codec"/> <field var="write_rate"/> <field var="remote_media_ip"/> <field var="network_addr"/> <field var="recording_file"/> <field var="leg"/> <field var="pdd_ms"/> <field var="last_app"/> <field var="last_arg"/> <field var="cc_side"/> <field var="cc_member_uuid"/> <field var="cc_queue_joined_epoch"/> <field var="cc_queue"/> <field var="cc_member_session_uuid"/> <field var="cc_agent"/> <field var="cc_agent_type"/> <field var="waitsec"/> <field var="conference_name"/> <field var="conference_uuid"/> <field var="conference_member_id"/> <field var="digits_dialed"/> <field var="hangup_cause"/> <field var="hangup_cause_q850"/> <field var="sip_hangup_disposition"/> <!-- <field var="sip_hangup_disposition"/> --> <!-- <field var="ani"/> --> </schema>
本文出自 “折腾笔记” 博客,请务必保留此出处http://908405.blog.51cto.com/898405/1950318
FreeSWITCH折腾笔记3——数据库修改为postgresql
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。