当前位置:Gxlcms > 数据库问题 > FreeSWITCH折腾笔记3——数据库修改为postgresql

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

时间:2021-07-01 10:21:17 帮助过:111人阅读

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

  1. <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

  1.  <param name="db-info" value="host=localhost user=freeswitch password=nopassword dbname=freeswitch connect_timeout=10" />
  2.  <param name="db-table" value="xml_cdr"/>


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

  1. <param name="odbc-dsn" value="pgsql://host=localhost dbname=freeswitch user=freeswitch password=‘
  2. password
  3. ‘ 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="$${dsn}"/>"

  1. <X-PRE-PROCESS cmd="set" data="dsn=pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password=‘password‘ options=‘-c client_min_messages=NOTICE‘ application_name=‘freeswitch‘" />
  2. <X-PRE-PROCESS cmd="set" data="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 字段设置


  1. CREATE TABLE "public"."xml_cdr" (
  2. "uuid" uuid NOT NULL,
  3. "domain_uuid" uuid,
  4. "extension_uuid" uuid,
  5. "domain_name" text COLLATE "default",
  6. "accountcode" text COLLATE "default",
  7. "direction" text COLLATE "default",
  8. "default_language" text COLLATE "default",
  9. "context" text COLLATE "default",
  10. "xml_cd" text COLLATE "default",
  11. "json" jsonb,
  12. "caller_id_name" text COLLATE "default",
  13. "caller_id_number" text COLLATE "default",
  14. "source_number" text COLLATE "default",
  15. "destination_number" text COLLATE "default",
  16. "start_epoch" numeric,
  17. "start_stamp" timestamp(6),
  18. "answer_stamp" timestamp(6),
  19. "answer_epoch" numeric,
  20. "end_epoch" numeric,
  21. "end_stamp" text COLLATE "default",
  22. "duration" numeric,
  23. "mduration" numeric,
  24. "billsec" numeric,
  25. "billmsec" numeric,
  26. "bridge_uuid" text COLLATE "default",
  27. "read_codec" text COLLATE "default",
  28. "read_rate" text COLLATE "default",
  29. "write_codec" text COLLATE "default",
  30. "write_rate" text COLLATE "default",
  31. "remote_media_ip" text COLLATE "default",
  32. "network_addr" text COLLATE "default",
  33. "recording_file" text COLLATE "default",
  34. "leg" char(1) COLLATE "default",
  35. "pdd_ms" numeric,
  36. "rtp_audio_in_mos" numeric,
  37. "last_app" text COLLATE "default",
  38. "last_arg" text COLLATE "default",
  39. "cc_side" text COLLATE "default",
  40. "cc_member_uuid" uuid,
  41. "cc_queue_joined_epoch" text COLLATE "default",
  42. "cc_queue" text COLLATE "default",
  43. "cc_member_session_uuid" uuid,
  44. "cc_agent" text COLLATE "default",
  45. "cc_agent_type" text COLLATE "default",
  46. "waitsec" numeric,
  47. "conference_name" text COLLATE "default",
  48. "conference_uuid" uuid,
  49. "conference_member_id" text COLLATE "default",
  50. "digits_dialed" text COLLATE "default",
  51. "pin_number" text COLLATE "default",
  52. "hangup_cause" text COLLATE "default",
  53. "hangup_cause_q850" numeric,
  54. "sip_hangup_disposition" text COLLATE "default",
  55. CONSTRAINT "xml_cdr_pkey" PRIMARY KEY ("uuid")
  56. )
  57. WITH (OIDS=FALSE)
  58. ;
  59. ALTER TABLE "public"."xml_cdr" OWNER TO "freeswitch";
  1. </settings>
  2.   <schema>
  3.     <field var="uuid"/>
  4.     <field var="domain_uuid"/>
  5.     <field var="domain_name"/>
  6.     <field var="accountcode"/>
  7.     <field var="direction"/>
  8.     <field var="default_language"/>
  9.     <field var="context"/>
  10.     <field var="xml_cdr"/>
  11.     <!-- <field var="local_ip_v4"/> -->
  12.     <field var="caller_id_name"/>
  13.     <field var="caller_id_number"/>
  14.     <field var="destination_number"/>
  15.     <field var="start_epoch"/>
  16.     <field var="start_stamp"/>
  17.     <field var="answer_stamp"/>
  18.     <field var="answer_epoch"/>
  19.     <field var="end_epoch"/>
  20.     <field var="end_stamp"/>
  21.     <field var="duration"/>
  22.     <field var="mduration"/>
  23.     <field var="billsec"/>
  24.     <field var="billmsec"/>
  25.     <field var="bridge_uuid"/>
  26.     <!-- <field var="bleg_uuid"/> -->
  27.     <field var="read_codec"/>
  28.     <field var="read_rate"/>
  29.     <field var="write_codec"/>
  30.     <field var="write_rate"/>
  31.     <field var="remote_media_ip"/>
  32.     <field var="network_addr"/>
  33.     <field var="recording_file"/>
  34.     <field var="leg"/>
  35.     <field var="pdd_ms"/>
  36.     <field var="last_app"/>
  37.     <field var="last_arg"/>
  38.     <field var="cc_side"/>
  39.     <field var="cc_member_uuid"/>
  40.     <field var="cc_queue_joined_epoch"/>
  41.     <field var="cc_queue"/>
  42.     <field var="cc_member_session_uuid"/>
  43.     <field var="cc_agent"/>
  44.     <field var="cc_agent_type"/>
  45.     <field var="waitsec"/>
  46.     <field var="conference_name"/>
  47.     <field var="conference_uuid"/>
  48.     <field var="conference_member_id"/>
  49.     <field var="digits_dialed"/>
  50.     <field var="hangup_cause"/>
  51.     <field var="hangup_cause_q850"/>
  52.     <field var="sip_hangup_disposition"/>
  53.     <!-- <field var="sip_hangup_disposition"/> -->
  54.     <!-- <field var="ani"/> -->
  55.   </schema>




本文出自 “折腾笔记” 博客,请务必保留此出处http://908405.blog.51cto.com/898405/1950318

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

标签:freeswitch pgsql

人气教程排行