From Sweet Meerkat, 6 Years ago, written in Plain Text.
- view diff
Embed
  1. 2017-10-18 15:42:56.072002 [INFO] sofia.c:5782 Setting MAX Auth Validity to 0 Attempts
  2. 2017-10-18 15:42:56.072044 [NOTICE] sofia.c:5946 Connecting ODBC Profile dq [sofia_reg_dq]
  3. 2017-10-18 15:42:56.072135 [DEBUG] sofia.c:3046 Creating agent for dq
  4. 2017-10-18 15:42:56.072226 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: sip_registrations]
  5. [delete from sip_registrations where sub_host is null and hostname='ccc-prod-fs2' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user  like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%']
  6. Auto Generating Table!
  7. 2017-10-18 15:42:56.072252 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: sip_registrations]
  8. [drop table sip_registrations]
  9. 2017-10-18 15:42:56.072707 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: sip_subscriptions]
  10. [delete from sip_subscriptions where hostname='ccc-prod-fs2' and full_to='XXX']
  11. Auto Generating Table!
  12. 2017-10-18 15:42:56.072728 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: sip_subscriptions]
  13. [DROP TABLE sip_subscriptions]
  14. 2017-10-18 15:42:56.072964 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: sip_dialogs]
  15. [delete from sip_dialogs where hostname='ccc-prod-fs2' and (expires <> -9999 or rpid='' or sip_from_tag='' or rcd > 0)]
  16. Auto Generating Table!
  17. 2017-10-18 15:42:56.072985 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: sip_dialogs]
  18. [DROP TABLE sip_dialogs]
  19. 2017-10-18 15:42:56.073209 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: sip_presence]
  20. [delete from sip_presence where hostname='ccc-prod-fs2' or open_closed='']
  21. Auto Generating Table!
  22. 2017-10-18 15:42:56.073229 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: sip_presence]
  23. [DROP TABLE sip_presence]
  24. 2017-10-18 15:42:56.073418 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: sip_authentication]
  25. [delete from sip_authentication where hostname='ccc-prod-fs2' or last_nc >= 0]
  26. Auto Generating Table!
  27. 2017-10-18 15:42:56.073439 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: sip_authentication]
  28. [DROP TABLE sip_authentication]
  29. 2017-10-18 15:42:56.073595 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: sip_shared_appearance_subscriptions]
  30. [delete from sip_shared_appearance_subscriptions where contact_str='' or hostname='ccc-prod-fs2' and network_ip like '%']
  31. Auto Generating Table!
  32. 2017-10-18 15:42:56.073618 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: sip_shared_appearance_subscriptions]
  33. [DROP TABLE sip_shared_appearance_subscriptions]
  34. 2017-10-18 15:42:56.073802 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: sip_shared_appearance_dialogs]
  35. [delete from sip_shared_appearance_dialogs where contact_str='' or hostname='ccc-prod-fs2' and network_ip like '%']
  36. Auto Generating Table!
  37. 2017-10-18 15:42:56.073823 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: sip_shared_appearance_dialogs]
  38. [DROP TABLE sip_shared_appearance_dialogs]
  39. 2017-10-18 15:42:56.114657 [DEBUG] switch_pgsql.c:415 Query (create index sr_call_id on sip_registrations (call_id)) returned PGRES_FATAL_ERROR
  40. 2017-10-18 15:42:56.115028 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_user on sip_registrations (sip_user)) returned PGRES_FATAL_ERROR
  41. 2017-10-18 15:42:56.115301 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_host on sip_registrations (sip_host)) returned PGRES_FATAL_ERROR
  42. 2017-10-18 15:42:56.115615 [DEBUG] switch_pgsql.c:415 Query (create index sr_sub_host on sip_registrations (sub_host)) returned PGRES_FATAL_ERROR
  43. 2017-10-18 15:42:56.115912 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_user on sip_registrations (mwi_user)) returned PGRES_FATAL_ERROR
  44. 2017-10-18 15:42:56.116200 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_host on sip_registrations (mwi_host)) returned PGRES_FATAL_ERROR
  45. 2017-10-18 15:42:56.116488 [DEBUG] switch_pgsql.c:415 Query (create index sr_profile_name on sip_registrations (profile_name)) returned PGRES_FATAL_ERROR
  46. 2017-10-18 15:42:56.116780 [DEBUG] switch_pgsql.c:415 Query (create index sr_presence_hosts on sip_registrations (presence_hosts)) returned PGRES_FATAL_ERROR
  47. 2017-10-18 15:42:56.117047 [DEBUG] switch_pgsql.c:415 Query (create index sr_contact on sip_registrations (contact)) returned PGRES_FATAL_ERROR
  48. 2017-10-18 15:42:56.117382 [DEBUG] switch_pgsql.c:415 Query (create index sr_expires on sip_registrations (expires)) returned PGRES_FATAL_ERROR
  49. 2017-10-18 15:42:56.117696 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_expires on sip_registrations (ping_expires)) returned PGRES_FATAL_ERROR
  50. 2017-10-18 15:42:56.117981 [DEBUG] switch_pgsql.c:415 Query (create index sr_hostname on sip_registrations (hostname)) returned PGRES_FATAL_ERROR
  51. 2017-10-18 15:42:56.118245 [DEBUG] switch_pgsql.c:415 Query (create index sr_status on sip_registrations (status)) returned PGRES_FATAL_ERROR
  52. 2017-10-18 15:42:56.118493 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_status on sip_registrations (ping_status)) returned PGRES_FATAL_ERROR
  53. 2017-10-18 15:42:56.118804 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_ip on sip_registrations (network_ip)) returned PGRES_FATAL_ERROR
  54. 2017-10-18 15:42:56.119073 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_port on sip_registrations (network_port)) returned PGRES_FATAL_ERROR
  55. 2017-10-18 15:42:56.119344 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_username on sip_registrations (sip_username)) returned PGRES_FATAL_ERROR
  56. 2017-10-18 15:42:56.119604 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_realm on sip_registrations (sip_realm)) returned PGRES_FATAL_ERROR
  57. 2017-10-18 15:42:56.119871 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_server_host on sip_registrations (orig_server_host)) returned PGRES_FATAL_ERROR
  58. 2017-10-18 15:42:56.120119 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_hostname on sip_registrations (orig_hostname)) returned PGRES_FATAL_ERROR
  59. 2017-10-18 15:42:56.120373 [DEBUG] switch_pgsql.c:415 Query (create index ss_call_id on sip_subscriptions (call_id)) returned PGRES_FATAL_ERROR
  60. 2017-10-18 15:42:56.120680 [DEBUG] switch_pgsql.c:415 Query (create index ss_multi on sip_subscriptions (call_id, profile_name, hostname)) returned PGRES_FATAL_ERROR
  61. 2017-10-18 15:42:56.120922 [DEBUG] switch_pgsql.c:415 Query (create index ss_hostname on sip_subscriptions (hostname)) returned PGRES_FATAL_ERROR
  62. 2017-10-18 15:42:56.121187 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_ip on sip_subscriptions (network_ip)) returned PGRES_FATAL_ERROR
  63. 2017-10-18 15:42:56.121446 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_user on sip_subscriptions (sip_user)) returned PGRES_FATAL_ERROR
  64. 2017-10-18 15:42:56.121739 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_host on sip_subscriptions (sip_host)) returned PGRES_FATAL_ERROR
  65. 2017-10-18 15:42:56.121990 [DEBUG] switch_pgsql.c:415 Query (create index ss_presence_hosts on sip_subscriptions (presence_hosts)) returned PGRES_FATAL_ERROR
  66. 2017-10-18 15:42:56.122076 [DEBUG] sofia.c:3164 Created agent for agent
  67. 2017-10-18 15:42:56.122113 [DEBUG] sofia.c:3212 Set params for agent
  68. 2017-10-18 15:42:56.122118 [DEBUG] sofia.c:3259 Activated db for agent
  69. 2017-10-18 15:42:56.122240 [DEBUG] switch_pgsql.c:415 Query (create index ss_event on sip_subscriptions (event)) returned PGRES_FATAL_ERROR
  70. 2017-10-18 15:42:56.122496 [DEBUG] switch_pgsql.c:415 Query (create index ss_proto on sip_subscriptions (proto)) returned PGRES_FATAL_ERROR
  71. 2017-10-18 15:42:56.122802 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_user on sip_subscriptions (sub_to_user)) returned PGRES_FATAL_ERROR
  72. 2017-10-18 15:42:56.123065 [INFO] switch_core_sqldb.c:1693 sofia:agent Starting SQL thread.
  73. 2017-10-18 15:42:56.123071 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_host on sip_subscriptions (sub_to_host)) returned PGRES_FATAL_ERROR
  74. 2017-10-18 15:42:56.123141 [DEBUG] sofia.c:3297 Starting thread for agent
  75. 2017-10-18 15:42:56.123146 [DEBUG] sofia.c:2946 Launching worker thread for agent
  76. 2017-10-18 15:42:56.123314 [DEBUG] switch_pgsql.c:415 Query (create index ss_expires on sip_subscriptions (expires)) returned PGRES_FATAL_ERROR
  77. 2017-10-18 15:42:56.123586 [DEBUG] switch_pgsql.c:415 Query (create index ss_orig_proto on sip_subscriptions (orig_proto)) returned PGRES_FATAL_ERROR
  78. 2017-10-18 15:42:56.123856 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_port on sip_subscriptions (network_port)) returned PGRES_FATAL_ERROR
  79. 2017-10-18 15:42:56.124119 [DEBUG] switch_pgsql.c:415 Query (create index ss_profile_name on sip_subscriptions (profile_name)) returned PGRES_FATAL_ERROR
  80. 2017-10-18 15:42:56.124365 [DEBUG] switch_pgsql.c:415 Query (create index ss_version on sip_subscriptions (version)) returned PGRES_FATAL_ERROR
  81. 2017-10-18 15:42:56.124616 [DEBUG] switch_pgsql.c:415 Query (create index ss_full_from on sip_subscriptions (full_from)) returned PGRES_FATAL_ERROR
  82. 2017-10-18 15:42:56.124862 [DEBUG] switch_pgsql.c:415 Query (create index ss_contact on sip_subscriptions (contact)) returned PGRES_FATAL_ERROR
  83. 2017-10-18 15:42:56.125118 [DEBUG] switch_pgsql.c:415 Query (create index sd_uuid on sip_dialogs (uuid)) returned PGRES_FATAL_ERROR
  84. 2017-10-18 15:42:56.125363 [DEBUG] switch_pgsql.c:415 Query (create index sd_hostname on sip_dialogs (hostname)) returned PGRES_FATAL_ERROR
  85. 2017-10-18 15:42:56.125638 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_data on sip_dialogs (presence_data)) returned PGRES_FATAL_ERROR
  86. 2017-10-18 15:42:56.125955 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info on sip_dialogs (call_info)) returned PGRES_FATAL_ERROR
  87. 2017-10-18 15:42:56.126228 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info_state on sip_dialogs (call_info_state)) returned PGRES_FATAL_ERROR
  88. 2017-10-18 15:42:56.126480 [DEBUG] switch_pgsql.c:415 Query (create index sd_expires on sip_dialogs (expires)) returned PGRES_FATAL_ERROR
  89. 2017-10-18 15:42:56.126775 [DEBUG] switch_pgsql.c:415 Query (create index sd_rcd on sip_dialogs (rcd)) returned PGRES_FATAL_ERROR
  90. 2017-10-18 15:42:56.127020 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_tag on sip_dialogs (sip_to_tag)) returned PGRES_FATAL_ERROR
  91. 2017-10-18 15:42:56.127278 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_user on sip_dialogs (sip_from_user)) returned PGRES_FATAL_ERROR
  92. 2017-10-18 15:42:56.127551 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_host on sip_dialogs (sip_from_host)) returned PGRES_FATAL_ERROR
  93. 2017-10-18 15:42:56.127810 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_host on sip_dialogs (sip_to_host)) returned PGRES_FATAL_ERROR
  94. 2017-10-18 15:42:56.128063 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_id on sip_dialogs (presence_id)) returned PGRES_FATAL_ERROR
  95. 2017-10-18 15:42:56.128308 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_id on sip_dialogs (call_id)) returned PGRES_FATAL_ERROR
  96. 2017-10-18 15:42:56.128578 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_tag on sip_dialogs (sip_from_tag)) returned PGRES_FATAL_ERROR
  97. 2017-10-18 15:42:56.128836 [DEBUG] switch_pgsql.c:415 Query (create index sp_hostname on sip_presence (hostname)) returned PGRES_FATAL_ERROR
  98. 2017-10-18 15:42:56.129078 [DEBUG] switch_pgsql.c:415 Query (create index sp_open_closed on sip_presence (open_closed)) returned PGRES_FATAL_ERROR
  99. 2017-10-18 15:42:56.129342 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_user on sip_presence (sip_user)) returned PGRES_FATAL_ERROR
  100. 2017-10-18 15:42:56.129619 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_host on sip_presence (sip_host)) returned PGRES_FATAL_ERROR
  101. 2017-10-18 15:42:56.129921 [DEBUG] switch_pgsql.c:415 Query (create index sp_profile_name on sip_presence (profile_name)) returned PGRES_FATAL_ERROR
  102. 2017-10-18 15:42:56.130206 [DEBUG] switch_pgsql.c:415 Query (create index sp_expires on sip_presence (expires)) returned PGRES_FATAL_ERROR
  103. 2017-10-18 15:42:56.131297 [DEBUG] switch_pgsql.c:415 Query (create index sa_nonce on sip_authentication (nonce)) returned PGRES_FATAL_ERROR
  104. 2017-10-18 15:42:56.131642 [DEBUG] switch_pgsql.c:415 Query (create index sa_hostname on sip_authentication (hostname)) returned PGRES_FATAL_ERROR
  105. 2017-10-18 15:42:56.131900 [DEBUG] switch_pgsql.c:415 Query (create index sa_expires on sip_authentication (expires)) returned PGRES_FATAL_ERROR
  106. 2017-10-18 15:42:56.132176 [DEBUG] switch_pgsql.c:415 Query (create index sa_last_nc on sip_authentication (last_nc)) returned PGRES_FATAL_ERROR
  107. 2017-10-18 15:42:56.132473 [DEBUG] switch_pgsql.c:415 Query (create index ssa_hostname on sip_shared_appearance_subscriptions (hostname)) returned PGRES_FATAL_ERROR
  108. 2017-10-18 15:42:56.132771 [DEBUG] switch_pgsql.c:415 Query (create index ssa_network_ip on sip_shared_appearance_subscriptions (network_ip)) returned PGRES_FATAL_ERROR
  109. 2017-10-18 15:42:56.133060 [DEBUG] switch_pgsql.c:415 Query (create index ssa_subscriber on sip_shared_appearance_subscriptions (subscriber)) returned PGRES_FATAL_ERROR
  110. 2017-10-18 15:42:56.133356 [DEBUG] switch_pgsql.c:415 Query (create index ssa_profile_name on sip_shared_appearance_subscriptions (profile_name)) returned PGRES_FATAL_ERROR
  111. 2017-10-18 15:42:56.133627 [DEBUG] switch_pgsql.c:415 Query (create index ssa_aor on sip_shared_appearance_subscriptions (aor)) returned PGRES_FATAL_ERROR
  112. 2017-10-18 15:42:56.133883 [DEBUG] switch_pgsql.c:415 Query (create index ssd_profile_name on sip_shared_appearance_dialogs (profile_name)) returned PGRES_FATAL_ERROR
  113. 2017-10-18 15:42:56.134162 [DEBUG] switch_pgsql.c:415 Query (create index ssd_hostname on sip_shared_appearance_dialogs (hostname)) returned PGRES_FATAL_ERROR
  114. 2017-10-18 15:42:56.134434 [DEBUG] switch_pgsql.c:415 Query (create index ssd_contact_str on sip_shared_appearance_dialogs (contact_str)) returned PGRES_FATAL_ERROR
  115. 2017-10-18 15:42:56.134691 [DEBUG] switch_pgsql.c:415 Query (create index ssd_call_id on sip_shared_appearance_dialogs (call_id)) returned PGRES_FATAL_ERROR
  116. 2017-10-18 15:42:56.134944 [DEBUG] switch_pgsql.c:415 Query (create index ssd_expires on sip_shared_appearance_dialogs (expires)) returned PGRES_FATAL_ERROR
  117. 2017-10-18 15:42:56.170467 [DEBUG] sofia.c:3164 Created agent for dq
  118. 2017-10-18 15:42:56.170523 [DEBUG] sofia.c:3212 Set params for dq
  119. 2017-10-18 15:42:56.170527 [DEBUG] sofia.c:3259 Activated db for dq
  120. 2017-10-18 15:42:56.171524 [INFO] switch_core_sqldb.c:1693 sofia:dq Starting SQL thread.
  121. 2017-10-18 15:42:56.171612 [DEBUG] sofia.c:3297 Starting thread for dq
  122. 2017-10-18 15:42:56.171619 [DEBUG] sofia.c:2946 Launching worker thread for dq
  123. 2017-10-18 15:42:56.222627 [ERR] mod_xml_curl.c:315 Received HTTP error 500 trying to fetch https://ccc-prod-lb.objectbrains.com/tms/rest/all_in_one/directory
  124. data: [hostname=ccc-prod-fs2&section=directory&tag_name=&key_name=&key_value=&Event-Name=REQUEST_PARAMS&Core-UUID=17ecaae7-fd12-4299-afd6-870c5152c3ab&FreeSWITCH-Hostname=ccc-prod-fs2&FreeSWITCH-Switchname=ccc-prod-fs2&FreeSWITCH-IPv4=10.120.3.24&FreeSWITCH-IPv6=%3A%3A1&Event-Date-Local=2017-10-18%2015%3A42%3A56&Event-Date-GMT=Wed,%2018%20Oct%202017%2015%3A42%3A56%20GMT&Event-Date-Timestamp=1508341376123188&Event-Calling-File=sofia.c&Event-Calling-Function=launch_sofia_worker_thread&Event-Calling-Line-Number=2967&Event-Sequence=33&purpose=gateways&profile=agent]
  125. 2017-10-18 15:42:56.222818 [NOTICE] sofia_reg.c:3398 Added gateway 'example.com' to profile 'agent'
  126. 2017-10-18 15:42:56.270879 [ERR] mod_xml_curl.c:315 Received HTTP error 500 trying to fetch https://ccc-prod-lb.objectbrains.com/tms/rest/all_in_one/directory
  127. data: [hostname=ccc-prod-fs2&section=directory&tag_name=&key_name=&key_value=&Event-Name=REQUEST_PARAMS&Core-UUID=17ecaae7-fd12-4299-afd6-870c5152c3ab&FreeSWITCH-Hostname=ccc-prod-fs2&FreeSWITCH-Switchname=ccc-prod-fs2&FreeSWITCH-IPv4=10.120.3.24&FreeSWITCH-IPv6=%3A%3A1&Event-Date-Local=2017-10-18%2015%3A42%3A56&Event-Date-GMT=Wed,%2018%20Oct%202017%2015%3A42%3A56%20GMT&Event-Date-Timestamp=1508341376171657&Event-Calling-File=sofia.c&Event-Calling-Function=launch_sofia_worker_thread&Event-Calling-Line-Number=2967&Event-Sequence=36&purpose=gateways&profile=dq]
  128. 2017-10-18 15:42:57.072200 [DEBUG] sofia.c:4450 debug [0]
  129. 2017-10-18 15:42:57.072220 [DEBUG] sofia.c:4450 sip-trace [no]
  130. 2017-10-18 15:42:57.072224 [DEBUG] sofia.c:4450 sip-capture [yes]
  131. 2017-10-18 15:42:57.072230 [DEBUG] sofia.c:4450 rfc2833-pt [101]
  132. 2017-10-18 15:42:57.072246 [DEBUG] sofia.c:4450 sip-port [5040]
  133. 2017-10-18 15:42:57.072250 [DEBUG] sofia.c:4450 dialplan [XML]
  134. 2017-10-18 15:42:57.072257 [DEBUG] sofia.c:4450 context [fifo_dp]
  135. 2017-10-18 15:42:57.072261 [DEBUG] sofia.c:4450 dtmf-duration [2000]
  136. 2017-10-18 15:42:57.072265 [DEBUG] sofia.c:4450 inbound-codec-prefs [PCMU]
  137. 2017-10-18 15:42:57.072271 [DEBUG] sofia.c:4450 outbound-codec-prefs [PCMU]
  138. 2017-10-18 15:42:57.072274 [DEBUG] sofia.c:4450 hold-music [local_stream://moh]
  139. 2017-10-18 15:42:57.072277 [DEBUG] sofia.c:4450 rtp-timer-name [soft]
  140. 2017-10-18 15:42:57.072279 [DEBUG] sofia.c:4450 local-network-acl [localnet.auto]
  141. 2017-10-18 15:42:57.072282 [DEBUG] sofia.c:4450 manage-presence [false]
  142. 2017-10-18 15:42:57.072285 [DEBUG] sofia.c:4450 odbc-dsn [pgsql://hostaddr=10.120.3.3 dbname=svp2 user=tms password='s1IghR2gMZ19G81LxFtvc8BH0TJgq7Mw' options='-c client_min_messages=NOTICE' application_name='freeswitch']
  143. 2017-10-18 15:42:57.072290 [DEBUG] sofia.c:4450 inbound-codec-negotiation [generous]
  144. 2017-10-18 15:42:57.072293 [DEBUG] sofia.c:4450 nonce-ttl [60]
  145. 2017-10-18 15:42:57.072295 [DEBUG] sofia.c:4450 auth-calls [false]
  146. 2017-10-18 15:42:57.072298 [DEBUG] sofia.c:4450 inbound-late-negotiation [true]
  147. 2017-10-18 15:42:57.072301 [DEBUG] sofia.c:4450 inbound-zrtp-passthru [true]
  148. 2017-10-18 15:42:57.072305 [DEBUG] sofia.c:4450 rtp-ip [10.120.3.24]
  149. 2017-10-18 15:42:57.072308 [DEBUG] sofia.c:4450 sip-ip [10.120.3.24]
  150. 2017-10-18 15:42:57.072312 [DEBUG] sofia.c:4450 ext-rtp-ip [auto-nat]
  151. 2017-10-18 15:42:57.072315 [DEBUG] sofia.c:4450 ext-sip-ip [auto-nat]
  152. 2017-10-18 15:42:57.072319 [DEBUG] sofia.c:4450 rtp-timeout-sec [300]
  153. 2017-10-18 15:42:57.072323 [DEBUG] sofia.c:4450 rtp-hold-timeout-sec [1800]
  154. 2017-10-18 15:42:57.072325 [DEBUG] sofia.c:4450 tls [false]
  155. 2017-10-18 15:42:57.072329 [DEBUG] sofia.c:4450 tls-only [false]
  156. 2017-10-18 15:42:57.072333 [DEBUG] sofia.c:4450 tls-bind-params [transport=tls]
  157. 2017-10-18 15:42:57.072337 [DEBUG] sofia.c:4450 tls-sip-port [5041]
  158. 2017-10-18 15:42:57.072340 [DEBUG] sofia.c:4450 tls-passphrase []
  159. 2017-10-18 15:42:57.072345 [DEBUG] sofia.c:4450 tls-verify-date [true]
  160. 2017-10-18 15:42:57.072351 [DEBUG] sofia.c:4450 tls-verify-policy [none]
  161. 2017-10-18 15:42:57.072355 [DEBUG] sofia.c:4450 tls-verify-depth [2]
  162. 2017-10-18 15:42:57.072366 [DEBUG] sofia.c:4450 tls-verify-in-subjects []
  163. 2017-10-18 15:42:57.072369 [DEBUG] sofia.c:4450 tls-version [tlsv1,tlsv1.1,tlsv1.2]
  164. 2017-10-18 15:42:57.072387 [INFO] sofia.c:5782 Setting MAX Auth Validity to 0 Attempts
  165. 2017-10-18 15:42:57.072455 [NOTICE] sofia.c:5946 Connecting ODBC Profile fifo [sofia_reg_fifo]
  166. 2017-10-18 15:42:57.072516 [DEBUG] sofia.c:3046 Creating agent for fifo
  167. 2017-10-18 15:42:57.091876 [DEBUG] switch_pgsql.c:415 Query (create index sr_call_id on sip_registrations (call_id)) returned PGRES_FATAL_ERROR
  168. 2017-10-18 15:42:57.092199 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_user on sip_registrations (sip_user)) returned PGRES_FATAL_ERROR
  169. 2017-10-18 15:42:57.092537 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_host on sip_registrations (sip_host)) returned PGRES_FATAL_ERROR
  170. 2017-10-18 15:42:57.092826 [DEBUG] switch_pgsql.c:415 Query (create index sr_sub_host on sip_registrations (sub_host)) returned PGRES_FATAL_ERROR
  171. 2017-10-18 15:42:57.093099 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_user on sip_registrations (mwi_user)) returned PGRES_FATAL_ERROR
  172. 2017-10-18 15:42:57.093373 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_host on sip_registrations (mwi_host)) returned PGRES_FATAL_ERROR
  173. 2017-10-18 15:42:57.093627 [DEBUG] switch_pgsql.c:415 Query (create index sr_profile_name on sip_registrations (profile_name)) returned PGRES_FATAL_ERROR
  174. 2017-10-18 15:42:57.093921 [DEBUG] switch_pgsql.c:415 Query (create index sr_presence_hosts on sip_registrations (presence_hosts)) returned PGRES_FATAL_ERROR
  175. 2017-10-18 15:42:57.094201 [DEBUG] switch_pgsql.c:415 Query (create index sr_contact on sip_registrations (contact)) returned PGRES_FATAL_ERROR
  176. 2017-10-18 15:42:57.094574 [DEBUG] switch_pgsql.c:415 Query (create index sr_expires on sip_registrations (expires)) returned PGRES_FATAL_ERROR
  177. 2017-10-18 15:42:57.094900 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_expires on sip_registrations (ping_expires)) returned PGRES_FATAL_ERROR
  178. 2017-10-18 15:42:57.095182 [DEBUG] switch_pgsql.c:415 Query (create index sr_hostname on sip_registrations (hostname)) returned PGRES_FATAL_ERROR
  179. 2017-10-18 15:42:57.095452 [DEBUG] switch_pgsql.c:415 Query (create index sr_status on sip_registrations (status)) returned PGRES_FATAL_ERROR
  180. 2017-10-18 15:42:57.095709 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_status on sip_registrations (ping_status)) returned PGRES_FATAL_ERROR
  181. 2017-10-18 15:42:57.095967 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_ip on sip_registrations (network_ip)) returned PGRES_FATAL_ERROR
  182. 2017-10-18 15:42:57.096226 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_port on sip_registrations (network_port)) returned PGRES_FATAL_ERROR
  183. 2017-10-18 15:42:57.096483 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_username on sip_registrations (sip_username)) returned PGRES_FATAL_ERROR
  184. 2017-10-18 15:42:57.096733 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_realm on sip_registrations (sip_realm)) returned PGRES_FATAL_ERROR
  185. 2017-10-18 15:42:57.096991 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_server_host on sip_registrations (orig_server_host)) returned PGRES_FATAL_ERROR
  186. 2017-10-18 15:42:57.097266 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_hostname on sip_registrations (orig_hostname)) returned PGRES_FATAL_ERROR
  187. 2017-10-18 15:42:57.097539 [DEBUG] switch_pgsql.c:415 Query (create index ss_call_id on sip_subscriptions (call_id)) returned PGRES_FATAL_ERROR
  188. 2017-10-18 15:42:57.097831 [DEBUG] switch_pgsql.c:415 Query (create index ss_multi on sip_subscriptions (call_id, profile_name, hostname)) returned PGRES_FATAL_ERROR
  189. 2017-10-18 15:42:57.098100 [DEBUG] switch_pgsql.c:415 Query (create index ss_hostname on sip_subscriptions (hostname)) returned PGRES_FATAL_ERROR
  190. 2017-10-18 15:42:57.098369 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_ip on sip_subscriptions (network_ip)) returned PGRES_FATAL_ERROR
  191. 2017-10-18 15:42:57.098638 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_user on sip_subscriptions (sip_user)) returned PGRES_FATAL_ERROR
  192. 2017-10-18 15:42:57.098924 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_host on sip_subscriptions (sip_host)) returned PGRES_FATAL_ERROR
  193. 2017-10-18 15:42:57.099189 [DEBUG] switch_pgsql.c:415 Query (create index ss_presence_hosts on sip_subscriptions (presence_hosts)) returned PGRES_FATAL_ERROR
  194. 2017-10-18 15:42:57.099451 [DEBUG] switch_pgsql.c:415 Query (create index ss_event on sip_subscriptions (event)) returned PGRES_FATAL_ERROR
  195. 2017-10-18 15:42:57.099743 [DEBUG] switch_pgsql.c:415 Query (create index ss_proto on sip_subscriptions (proto)) returned PGRES_FATAL_ERROR
  196. 2017-10-18 15:42:57.100006 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_user on sip_subscriptions (sub_to_user)) returned PGRES_FATAL_ERROR
  197. 2017-10-18 15:42:57.100261 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_host on sip_subscriptions (sub_to_host)) returned PGRES_FATAL_ERROR
  198. 2017-10-18 15:42:57.100518 [DEBUG] switch_pgsql.c:415 Query (create index ss_expires on sip_subscriptions (expires)) returned PGRES_FATAL_ERROR
  199. 2017-10-18 15:42:57.100771 [DEBUG] switch_pgsql.c:415 Query (create index ss_orig_proto on sip_subscriptions (orig_proto)) returned PGRES_FATAL_ERROR
  200. 2017-10-18 15:42:57.101019 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_port on sip_subscriptions (network_port)) returned PGRES_FATAL_ERROR
  201. 2017-10-18 15:42:57.101288 [DEBUG] switch_pgsql.c:415 Query (create index ss_profile_name on sip_subscriptions (profile_name)) returned PGRES_FATAL_ERROR
  202. 2017-10-18 15:42:57.101564 [DEBUG] switch_pgsql.c:415 Query (create index ss_version on sip_subscriptions (version)) returned PGRES_FATAL_ERROR
  203. 2017-10-18 15:42:57.101828 [DEBUG] switch_pgsql.c:415 Query (create index ss_full_from on sip_subscriptions (full_from)) returned PGRES_FATAL_ERROR
  204. 2017-10-18 15:42:57.102113 [DEBUG] switch_pgsql.c:415 Query (create index ss_contact on sip_subscriptions (contact)) returned PGRES_FATAL_ERROR
  205. 2017-10-18 15:42:57.102383 [DEBUG] switch_pgsql.c:415 Query (create index sd_uuid on sip_dialogs (uuid)) returned PGRES_FATAL_ERROR
  206. 2017-10-18 15:42:57.102662 [DEBUG] switch_pgsql.c:415 Query (create index sd_hostname on sip_dialogs (hostname)) returned PGRES_FATAL_ERROR
  207. 2017-10-18 15:42:57.102931 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_data on sip_dialogs (presence_data)) returned PGRES_FATAL_ERROR
  208. 2017-10-18 15:42:57.103190 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info on sip_dialogs (call_info)) returned PGRES_FATAL_ERROR
  209. 2017-10-18 15:42:57.103446 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info_state on sip_dialogs (call_info_state)) returned PGRES_FATAL_ERROR
  210. 2017-10-18 15:42:57.103693 [DEBUG] switch_pgsql.c:415 Query (create index sd_expires on sip_dialogs (expires)) returned PGRES_FATAL_ERROR
  211. 2017-10-18 15:42:57.103948 [DEBUG] switch_pgsql.c:415 Query (create index sd_rcd on sip_dialogs (rcd)) returned PGRES_FATAL_ERROR
  212. 2017-10-18 15:42:57.104206 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_tag on sip_dialogs (sip_to_tag)) returned PGRES_FATAL_ERROR
  213. 2017-10-18 15:42:57.104465 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_user on sip_dialogs (sip_from_user)) returned PGRES_FATAL_ERROR
  214. 2017-10-18 15:42:57.104743 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_host on sip_dialogs (sip_from_host)) returned PGRES_FATAL_ERROR
  215. 2017-10-18 15:42:57.105012 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_host on sip_dialogs (sip_to_host)) returned PGRES_FATAL_ERROR
  216. 2017-10-18 15:42:57.105291 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_id on sip_dialogs (presence_id)) returned PGRES_FATAL_ERROR
  217. 2017-10-18 15:42:57.105550 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_id on sip_dialogs (call_id)) returned PGRES_FATAL_ERROR
  218. 2017-10-18 15:42:57.105816 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_tag on sip_dialogs (sip_from_tag)) returned PGRES_FATAL_ERROR
  219. 2017-10-18 15:42:57.106104 [DEBUG] switch_pgsql.c:415 Query (create index sp_hostname on sip_presence (hostname)) returned PGRES_FATAL_ERROR
  220. 2017-10-18 15:42:57.106387 [DEBUG] switch_pgsql.c:415 Query (create index sp_open_closed on sip_presence (open_closed)) returned PGRES_FATAL_ERROR
  221. 2017-10-18 15:42:57.106675 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_user on sip_presence (sip_user)) returned PGRES_FATAL_ERROR
  222. 2017-10-18 15:42:57.106970 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_host on sip_presence (sip_host)) returned PGRES_FATAL_ERROR
  223. 2017-10-18 15:42:57.107236 [DEBUG] switch_pgsql.c:415 Query (create index sp_profile_name on sip_presence (profile_name)) returned PGRES_FATAL_ERROR
  224. 2017-10-18 15:42:57.107508 [DEBUG] switch_pgsql.c:415 Query (create index sp_expires on sip_presence (expires)) returned PGRES_FATAL_ERROR
  225. 2017-10-18 15:42:57.107788 [DEBUG] switch_pgsql.c:415 Query (create index sa_nonce on sip_authentication (nonce)) returned PGRES_FATAL_ERROR
  226. 2017-10-18 15:42:57.108043 [DEBUG] switch_pgsql.c:415 Query (create index sa_hostname on sip_authentication (hostname)) returned PGRES_FATAL_ERROR
  227. 2017-10-18 15:42:57.108304 [DEBUG] switch_pgsql.c:415 Query (create index sa_expires on sip_authentication (expires)) returned PGRES_FATAL_ERROR
  228. 2017-10-18 15:42:57.108561 [DEBUG] switch_pgsql.c:415 Query (create index sa_last_nc on sip_authentication (last_nc)) returned PGRES_FATAL_ERROR
  229. 2017-10-18 15:42:57.108815 [DEBUG] switch_pgsql.c:415 Query (create index ssa_hostname on sip_shared_appearance_subscriptions (hostname)) returned PGRES_FATAL_ERROR
  230. 2017-10-18 15:42:57.109062 [DEBUG] switch_pgsql.c:415 Query (create index ssa_network_ip on sip_shared_appearance_subscriptions (network_ip)) returned PGRES_FATAL_ERROR
  231. 2017-10-18 15:42:57.109325 [DEBUG] switch_pgsql.c:415 Query (create index ssa_subscriber on sip_shared_appearance_subscriptions (subscriber)) returned PGRES_FATAL_ERROR
  232. 2017-10-18 15:42:57.109592 [DEBUG] switch_pgsql.c:415 Query (create index ssa_profile_name on sip_shared_appearance_subscriptions (profile_name)) returned PGRES_FATAL_ERROR
  233. 2017-10-18 15:42:57.109849 [DEBUG] switch_pgsql.c:415 Query (create index ssa_aor on sip_shared_appearance_subscriptions (aor)) returned PGRES_FATAL_ERROR
  234. 2017-10-18 15:42:57.110122 [DEBUG] switch_pgsql.c:415 Query (create index ssd_profile_name on sip_shared_appearance_dialogs (profile_name)) returned PGRES_FATAL_ERROR
  235. 2017-10-18 15:42:57.110383 [DEBUG] switch_pgsql.c:415 Query (create index ssd_hostname on sip_shared_appearance_dialogs (hostname)) returned PGRES_FATAL_ERROR
  236. 2017-10-18 15:42:57.110637 [DEBUG] switch_pgsql.c:415 Query (create index ssd_contact_str on sip_shared_appearance_dialogs (contact_str)) returned PGRES_FATAL_ERROR
  237. 2017-10-18 15:42:57.110899 [DEBUG] switch_pgsql.c:415 Query (create index ssd_call_id on sip_shared_appearance_dialogs (call_id)) returned PGRES_FATAL_ERROR
  238. 2017-10-18 15:42:57.111161 [DEBUG] switch_pgsql.c:415 Query (create index ssd_expires on sip_shared_appearance_dialogs (expires)) returned PGRES_FATAL_ERROR
  239. 2017-10-18 15:42:57.146952 [DEBUG] sofia.c:3164 Created agent for fifo
  240. 2017-10-18 15:42:57.147001 [DEBUG] sofia.c:3212 Set params for fifo
  241. 2017-10-18 15:42:57.147004 [DEBUG] sofia.c:3259 Activated db for fifo
  242. 2017-10-18 15:42:57.147951 [INFO] switch_core_sqldb.c:1693 sofia:fifo Starting SQL thread.
  243. 2017-10-18 15:42:57.148035 [DEBUG] sofia.c:3297 Starting thread for fifo
  244. 2017-10-18 15:42:57.148043 [DEBUG] sofia.c:2946 Launching worker thread for fifo
  245. 2017-10-18 15:42:57.241538 [ERR] mod_xml_curl.c:315 Received HTTP error 500 trying to fetch https://ccc-prod-lb.objectbrains.com/tms/rest/all_in_one/directory
  246. data: [hostname=ccc-prod-fs2&section=directory&tag_name=&key_name=&key_value=&Event-Name=REQUEST_PARAMS&Core-UUID=17ecaae7-fd12-4299-afd6-870c5152c3ab&FreeSWITCH-Hostname=ccc-prod-fs2&FreeSWITCH-Switchname=ccc-prod-fs2&FreeSWITCH-IPv4=10.120.3.24&FreeSWITCH-IPv6=%3A%3A1&Event-Date-Local=2017-10-18%2015%3A42%3A57&Event-Date-GMT=Wed,%2018%20Oct%202017%2015%3A42%3A57%20GMT&Event-Date-Timestamp=1508341377148081&Event-Calling-File=sofia.c&Event-Calling-Function=launch_sofia_worker_thread&Event-Calling-Line-Number=2967&Event-Sequence=41&purpose=gateways&profile=fifo]
  247. 2017-10-18 15:42:57.371318 [WARNING] sofia.c:2206 MSG Thread 1 Started
  248. 2017-10-18 15:42:57.371317 [WARNING] sofia.c:2206 MSG Thread 0 Started
  249. 2017-10-18 15:42:58.072567 [DEBUG] sofia.c:4450 debug [0]
  250. 2017-10-18 15:42:58.072580 [DEBUG] sofia.c:4450 sip-trace [no]
  251. 2017-10-18 15:42:58.072583 [DEBUG] sofia.c:4450 sip-capture [yes]
  252. 2017-10-18 15:42:58.072587 [DEBUG] sofia.c:4450 rfc2833-pt [101]
  253. 2017-10-18 15:42:58.072593 [DEBUG] sofia.c:4450 sip-port [5042]
  254. 2017-10-18 15:42:58.072598 [DEBUG] sofia.c:4450 dialplan [XML]
  255. 2017-10-18 15:42:58.072605 [DEBUG] sofia.c:4450 context [ivr_dp]
  256. 2017-10-18 15:42:58.072609 [DEBUG] sofia.c:4450 dtmf-duration [2000]
  257. 2017-10-18 15:42:58.072616 [DEBUG] sofia.c:4450 inbound-codec-prefs [PCMU]
  258. 2017-10-18 15:42:58.072619 [DEBUG] sofia.c:4450 outbound-codec-prefs [PCMU]
  259. 2017-10-18 15:42:58.072622 [DEBUG] sofia.c:4450 hold-music [local_stream://moh]
  260. 2017-10-18 15:42:58.072625 [DEBUG] sofia.c:4450 rtp-timer-name [soft]
  261. 2017-10-18 15:42:58.072628 [DEBUG] sofia.c:4450 local-network-acl [localnet.auto]
  262. 2017-10-18 15:42:58.072630 [DEBUG] sofia.c:4450 manage-presence [false]
  263. 2017-10-18 15:42:58.072634 [DEBUG] sofia.c:4450 odbc-dsn [pgsql://hostaddr=10.120.3.3 dbname=svp2 user=tms password='s1IghR2gMZ19G81LxFtvc8BH0TJgq7Mw' options='-c client_min_messages=NOTICE' application_name='freeswitch']
  264. 2017-10-18 15:42:58.072638 [DEBUG] sofia.c:4450 inbound-codec-negotiation [generous]
  265. 2017-10-18 15:42:58.072642 [DEBUG] sofia.c:4450 nonce-ttl [60]
  266. 2017-10-18 15:42:58.072646 [DEBUG] sofia.c:4450 auth-calls [false]
  267. 2017-10-18 15:42:58.072653 [DEBUG] sofia.c:4450 inbound-late-negotiation [true]
  268. 2017-10-18 15:42:58.072659 [DEBUG] sofia.c:4450 inbound-zrtp-passthru [true]
  269. 2017-10-18 15:42:58.072663 [DEBUG] sofia.c:4450 rtp-ip [10.120.3.24]
  270. 2017-10-18 15:42:58.072666 [DEBUG] sofia.c:4450 sip-ip [10.120.3.24]
  271. 2017-10-18 15:42:58.072669 [DEBUG] sofia.c:4450 ext-rtp-ip [auto-nat]
  272. 2017-10-18 15:42:58.072672 [DEBUG] sofia.c:4450 ext-sip-ip [auto-nat]
  273. 2017-10-18 15:42:58.072675 [DEBUG] sofia.c:4450 rtp-timeout-sec [300]
  274. 2017-10-18 15:42:58.072678 [DEBUG] sofia.c:4450 rtp-hold-timeout-sec [1800]
  275. 2017-10-18 15:42:58.072682 [DEBUG] sofia.c:4450 enable-3pcc [true]
  276. 2017-10-18 15:42:58.072685 [DEBUG] sofia.c:4450 tls [false]
  277. 2017-10-18 15:42:58.072691 [DEBUG] sofia.c:4450 tls-only [false]
  278. 2017-10-18 15:42:58.072697 [DEBUG] sofia.c:4450 tls-bind-params [transport=tls]
  279. 2017-10-18 15:42:58.072706 [DEBUG] sofia.c:4450 tls-sip-port [5043]
  280. 2017-10-18 15:42:58.072710 [DEBUG] sofia.c:4450 tls-passphrase []
  281. 2017-10-18 15:42:58.072716 [DEBUG] sofia.c:4450 tls-verify-date [true]
  282. 2017-10-18 15:42:58.072721 [DEBUG] sofia.c:4450 tls-verify-policy [none]
  283. 2017-10-18 15:42:58.072725 [DEBUG] sofia.c:4450 tls-verify-depth [2]
  284. 2017-10-18 15:42:58.072728 [DEBUG] sofia.c:4450 tls-verify-in-subjects []
  285. 2017-10-18 15:42:58.072732 [DEBUG] sofia.c:4450 tls-version [tlsv1,tlsv1.1,tlsv1.2]
  286. 2017-10-18 15:42:58.072749 [INFO] sofia.c:5782 Setting MAX Auth Validity to 0 Attempts
  287. 2017-10-18 15:42:58.072845 [NOTICE] sofia.c:5946 Connecting ODBC Profile ivr [sofia_reg_ivr]
  288. 2017-10-18 15:42:58.072924 [DEBUG] sofia.c:3046 Creating agent for ivr
  289. 2017-10-18 15:42:58.081914 [DEBUG] switch_pgsql.c:415 Query (create index sr_call_id on sip_registrations (call_id)) returned PGRES_FATAL_ERROR
  290. 2017-10-18 15:42:58.082291 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_user on sip_registrations (sip_user)) returned PGRES_FATAL_ERROR
  291. 2017-10-18 15:42:58.082551 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_host on sip_registrations (sip_host)) returned PGRES_FATAL_ERROR
  292. 2017-10-18 15:42:58.082907 [DEBUG] switch_pgsql.c:415 Query (create index sr_sub_host on sip_registrations (sub_host)) returned PGRES_FATAL_ERROR
  293. 2017-10-18 15:42:58.083221 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_user on sip_registrations (mwi_user)) returned PGRES_FATAL_ERROR
  294. 2017-10-18 15:42:58.083572 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_host on sip_registrations (mwi_host)) returned PGRES_FATAL_ERROR
  295. 2017-10-18 15:42:58.083871 [DEBUG] switch_pgsql.c:415 Query (create index sr_profile_name on sip_registrations (profile_name)) returned PGRES_FATAL_ERROR
  296. 2017-10-18 15:42:58.084201 [DEBUG] switch_pgsql.c:415 Query (create index sr_presence_hosts on sip_registrations (presence_hosts)) returned PGRES_FATAL_ERROR
  297. 2017-10-18 15:42:58.084505 [DEBUG] switch_pgsql.c:415 Query (create index sr_contact on sip_registrations (contact)) returned PGRES_FATAL_ERROR
  298. 2017-10-18 15:42:58.084956 [DEBUG] switch_pgsql.c:415 Query (create index sr_expires on sip_registrations (expires)) returned PGRES_FATAL_ERROR
  299. 2017-10-18 15:42:58.085284 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_expires on sip_registrations (ping_expires)) returned PGRES_FATAL_ERROR
  300. 2017-10-18 15:42:58.085555 [DEBUG] switch_pgsql.c:415 Query (create index sr_hostname on sip_registrations (hostname)) returned PGRES_FATAL_ERROR
  301. 2017-10-18 15:42:58.085941 [DEBUG] switch_pgsql.c:415 Query (create index sr_status on sip_registrations (status)) returned PGRES_FATAL_ERROR
  302. 2017-10-18 15:42:58.086220 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_status on sip_registrations (ping_status)) returned PGRES_FATAL_ERROR
  303. 2017-10-18 15:42:58.086490 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_ip on sip_registrations (network_ip)) returned PGRES_FATAL_ERROR
  304. 2017-10-18 15:42:58.086764 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_port on sip_registrations (network_port)) returned PGRES_FATAL_ERROR
  305. 2017-10-18 15:42:58.087033 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_username on sip_registrations (sip_username)) returned PGRES_FATAL_ERROR
  306. 2017-10-18 15:42:58.087325 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_realm on sip_registrations (sip_realm)) returned PGRES_FATAL_ERROR
  307. 2017-10-18 15:42:58.087595 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_server_host on sip_registrations (orig_server_host)) returned PGRES_FATAL_ERROR
  308. 2017-10-18 15:42:58.087874 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_hostname on sip_registrations (orig_hostname)) returned PGRES_FATAL_ERROR
  309. 2017-10-18 15:42:58.088135 [DEBUG] switch_pgsql.c:415 Query (create index ss_call_id on sip_subscriptions (call_id)) returned PGRES_FATAL_ERROR
  310. 2017-10-18 15:42:58.088423 [DEBUG] switch_pgsql.c:415 Query (create index ss_multi on sip_subscriptions (call_id, profile_name, hostname)) returned PGRES_FATAL_ERROR
  311. 2017-10-18 15:42:58.088676 [DEBUG] switch_pgsql.c:415 Query (create index ss_hostname on sip_subscriptions (hostname)) returned PGRES_FATAL_ERROR
  312. 2017-10-18 15:42:58.088937 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_ip on sip_subscriptions (network_ip)) returned PGRES_FATAL_ERROR
  313. 2017-10-18 15:42:58.089233 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_user on sip_subscriptions (sip_user)) returned PGRES_FATAL_ERROR
  314. 2017-10-18 15:42:58.089491 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_host on sip_subscriptions (sip_host)) returned PGRES_FATAL_ERROR
  315. 2017-10-18 15:42:58.089745 [DEBUG] switch_pgsql.c:415 Query (create index ss_presence_hosts on sip_subscriptions (presence_hosts)) returned PGRES_FATAL_ERROR
  316. 2017-10-18 15:42:58.090022 [DEBUG] switch_pgsql.c:415 Query (create index ss_event on sip_subscriptions (event)) returned PGRES_FATAL_ERROR
  317. 2017-10-18 15:42:58.090296 [DEBUG] switch_pgsql.c:415 Query (create index ss_proto on sip_subscriptions (proto)) returned PGRES_FATAL_ERROR
  318. 2017-10-18 15:42:58.090550 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_user on sip_subscriptions (sub_to_user)) returned PGRES_FATAL_ERROR
  319. 2017-10-18 15:42:58.090838 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_host on sip_subscriptions (sub_to_host)) returned PGRES_FATAL_ERROR
  320. 2017-10-18 15:42:58.091090 [DEBUG] switch_pgsql.c:415 Query (create index ss_expires on sip_subscriptions (expires)) returned PGRES_FATAL_ERROR
  321. 2017-10-18 15:42:58.091344 [DEBUG] switch_pgsql.c:415 Query (create index ss_orig_proto on sip_subscriptions (orig_proto)) returned PGRES_FATAL_ERROR
  322. 2017-10-18 15:42:58.091729 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_port on sip_subscriptions (network_port)) returned PGRES_FATAL_ERROR
  323. 2017-10-18 15:42:58.092025 [DEBUG] switch_pgsql.c:415 Query (create index ss_profile_name on sip_subscriptions (profile_name)) returned PGRES_FATAL_ERROR
  324. 2017-10-18 15:42:58.092307 [DEBUG] switch_pgsql.c:415 Query (create index ss_version on sip_subscriptions (version)) returned PGRES_FATAL_ERROR
  325. 2017-10-18 15:42:58.092584 [DEBUG] switch_pgsql.c:415 Query (create index ss_full_from on sip_subscriptions (full_from)) returned PGRES_FATAL_ERROR
  326. 2017-10-18 15:42:58.092869 [DEBUG] switch_pgsql.c:415 Query (create index ss_contact on sip_subscriptions (contact)) returned PGRES_FATAL_ERROR
  327. 2017-10-18 15:42:58.093140 [DEBUG] switch_pgsql.c:415 Query (create index sd_uuid on sip_dialogs (uuid)) returned PGRES_FATAL_ERROR
  328. 2017-10-18 15:42:58.093413 [DEBUG] switch_pgsql.c:415 Query (create index sd_hostname on sip_dialogs (hostname)) returned PGRES_FATAL_ERROR
  329. 2017-10-18 15:42:58.093673 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_data on sip_dialogs (presence_data)) returned PGRES_FATAL_ERROR
  330. 2017-10-18 15:42:58.093956 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info on sip_dialogs (call_info)) returned PGRES_FATAL_ERROR
  331. 2017-10-18 15:42:58.094230 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info_state on sip_dialogs (call_info_state)) returned PGRES_FATAL_ERROR
  332. 2017-10-18 15:42:58.094471 [DEBUG] switch_pgsql.c:415 Query (create index sd_expires on sip_dialogs (expires)) returned PGRES_FATAL_ERROR
  333. 2017-10-18 15:42:58.094766 [DEBUG] switch_pgsql.c:415 Query (create index sd_rcd on sip_dialogs (rcd)) returned PGRES_FATAL_ERROR
  334. 2017-10-18 15:42:58.095030 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_tag on sip_dialogs (sip_to_tag)) returned PGRES_FATAL_ERROR
  335. 2017-10-18 15:42:58.095347 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_user on sip_dialogs (sip_from_user)) returned PGRES_FATAL_ERROR
  336. 2017-10-18 15:42:58.095618 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_host on sip_dialogs (sip_from_host)) returned PGRES_FATAL_ERROR
  337. 2017-10-18 15:42:58.095927 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_host on sip_dialogs (sip_to_host)) returned PGRES_FATAL_ERROR
  338. 2017-10-18 15:42:58.096229 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_id on sip_dialogs (presence_id)) returned PGRES_FATAL_ERROR
  339. 2017-10-18 15:42:58.096516 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_id on sip_dialogs (call_id)) returned PGRES_FATAL_ERROR
  340. 2017-10-18 15:42:58.096789 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_tag on sip_dialogs (sip_from_tag)) returned PGRES_FATAL_ERROR
  341. 2017-10-18 15:42:58.097089 [DEBUG] switch_pgsql.c:415 Query (create index sp_hostname on sip_presence (hostname)) returned PGRES_FATAL_ERROR
  342. 2017-10-18 15:42:58.097393 [DEBUG] switch_pgsql.c:415 Query (create index sp_open_closed on sip_presence (open_closed)) returned PGRES_FATAL_ERROR
  343. 2017-10-18 15:42:58.097671 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_user on sip_presence (sip_user)) returned PGRES_FATAL_ERROR
  344. 2017-10-18 15:42:58.097957 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_host on sip_presence (sip_host)) returned PGRES_FATAL_ERROR
  345. 2017-10-18 15:42:58.098239 [DEBUG] switch_pgsql.c:415 Query (create index sp_profile_name on sip_presence (profile_name)) returned PGRES_FATAL_ERROR
  346. 2017-10-18 15:42:58.098575 [DEBUG] switch_pgsql.c:415 Query (create index sp_expires on sip_presence (expires)) returned PGRES_FATAL_ERROR
  347. 2017-10-18 15:42:58.098870 [DEBUG] switch_pgsql.c:415 Query (create index sa_nonce on sip_authentication (nonce)) returned PGRES_FATAL_ERROR
  348. 2017-10-18 15:42:58.099175 [DEBUG] switch_pgsql.c:415 Query (create index sa_hostname on sip_authentication (hostname)) returned PGRES_FATAL_ERROR
  349. 2017-10-18 15:42:58.099495 [DEBUG] switch_pgsql.c:415 Query (create index sa_expires on sip_authentication (expires)) returned PGRES_FATAL_ERROR
  350. 2017-10-18 15:42:58.099751 [DEBUG] switch_pgsql.c:415 Query (create index sa_last_nc on sip_authentication (last_nc)) returned PGRES_FATAL_ERROR
  351. 2017-10-18 15:42:58.100054 [DEBUG] switch_pgsql.c:415 Query (create index ssa_hostname on sip_shared_appearance_subscriptions (hostname)) returned PGRES_FATAL_ERROR
  352. 2017-10-18 15:42:58.100393 [DEBUG] switch_pgsql.c:415 Query (create index ssa_network_ip on sip_shared_appearance_subscriptions (network_ip)) returned PGRES_FATAL_ERROR
  353. 2017-10-18 15:42:58.100687 [DEBUG] switch_pgsql.c:415 Query (create index ssa_subscriber on sip_shared_appearance_subscriptions (subscriber)) returned PGRES_FATAL_ERROR
  354. 2017-10-18 15:42:58.101004 [DEBUG] switch_pgsql.c:415 Query (create index ssa_profile_name on sip_shared_appearance_subscriptions (profile_name)) returned PGRES_FATAL_ERROR
  355. 2017-10-18 15:42:58.101304 [DEBUG] switch_pgsql.c:415 Query (create index ssa_aor on sip_shared_appearance_subscriptions (aor)) returned PGRES_FATAL_ERROR
  356. 2017-10-18 15:42:58.101572 [DEBUG] switch_pgsql.c:415 Query (create index ssd_profile_name on sip_shared_appearance_dialogs (profile_name)) returned PGRES_FATAL_ERROR
  357. 2017-10-18 15:42:58.101860 [DEBUG] switch_pgsql.c:415 Query (create index ssd_hostname on sip_shared_appearance_dialogs (hostname)) returned PGRES_FATAL_ERROR
  358. 2017-10-18 15:42:58.102174 [DEBUG] switch_pgsql.c:415 Query (create index ssd_contact_str on sip_shared_appearance_dialogs (contact_str)) returned PGRES_FATAL_ERROR
  359. 2017-10-18 15:42:58.102461 [DEBUG] switch_pgsql.c:415 Query (create index ssd_call_id on sip_shared_appearance_dialogs (call_id)) returned PGRES_FATAL_ERROR
  360. 2017-10-18 15:42:58.102764 [DEBUG] switch_pgsql.c:415 Query (create index ssd_expires on sip_shared_appearance_dialogs (expires)) returned PGRES_FATAL_ERROR
  361. 2017-10-18 15:42:58.138762 [DEBUG] sofia.c:3164 Created agent for ivr
  362. 2017-10-18 15:42:58.138815 [DEBUG] sofia.c:3212 Set params for ivr
  363. 2017-10-18 15:42:58.138818 [DEBUG] sofia.c:3259 Activated db for ivr
  364. 2017-10-18 15:42:58.139766 [INFO] switch_core_sqldb.c:1693 sofia:ivr Starting SQL thread.
  365. 2017-10-18 15:42:58.139853 [DEBUG] sofia.c:3297 Starting thread for ivr
  366. 2017-10-18 15:42:58.139858 [DEBUG] sofia.c:2946 Launching worker thread for ivr
  367. 2017-10-18 15:42:58.226917 [ERR] mod_xml_curl.c:315 Received HTTP error 500 trying to fetch https://ccc-prod-lb.objectbrains.com/tms/rest/all_in_one/directory
  368. data: [hostname=ccc-prod-fs2&section=directory&tag_name=&key_name=&key_value=&Event-Name=REQUEST_PARAMS&Core-UUID=17ecaae7-fd12-4299-afd6-870c5152c3ab&FreeSWITCH-Hostname=ccc-prod-fs2&FreeSWITCH-Switchname=ccc-prod-fs2&FreeSWITCH-IPv4=10.120.3.24&FreeSWITCH-IPv6=%3A%3A1&Event-Date-Local=2017-10-18%2015%3A42%3A58&Event-Date-GMT=Wed,%2018%20Oct%202017%2015%3A42%3A58%20GMT&Event-Date-Timestamp=1508341378139898&Event-Calling-File=sofia.c&Event-Calling-Function=launch_sofia_worker_thread&Event-Calling-Line-Number=2967&Event-Sequence=45&purpose=gateways&profile=ivr]
  369. 2017-10-18 15:42:59.072987 [DEBUG] sofia.c:4450 debug [0]
  370. 2017-10-18 15:42:59.073001 [DEBUG] sofia.c:4450 sip-trace [no]
  371. 2017-10-18 15:42:59.073004 [DEBUG] sofia.c:4450 sip-capture [yes]
  372. 2017-10-18 15:42:59.073010 [DEBUG] sofia.c:4450 rfc2833-pt [101]
  373. 2017-10-18 15:42:59.073016 [DEBUG] sofia.c:4450 sip-port [5048]
  374. 2017-10-18 15:42:59.073020 [DEBUG] sofia.c:4450 dialplan [XML]
  375. 2017-10-18 15:42:59.073027 [DEBUG] sofia.c:4450 context [rsbc_dp]
  376. 2017-10-18 15:42:59.073031 [DEBUG] sofia.c:4450 dtmf-duration [2000]
  377. 2017-10-18 15:42:59.073035 [DEBUG] sofia.c:4450 inbound-codec-prefs [PCMU]
  378. 2017-10-18 15:42:59.073039 [DEBUG] sofia.c:4450 outbound-codec-prefs [PCMU]
  379. 2017-10-18 15:42:59.073042 [DEBUG] sofia.c:4450 hold-music [local_stream://moh]
  380. 2017-10-18 15:42:59.073044 [DEBUG] sofia.c:4450 rtp-timer-name [soft]
  381. 2017-10-18 15:42:59.073046 [DEBUG] sofia.c:4450 local-network-acl [localnet.auto]
  382. 2017-10-18 15:42:59.073049 [DEBUG] sofia.c:4450 manage-presence [false]
  383. 2017-10-18 15:42:59.073051 [DEBUG] sofia.c:4450 inbound-codec-negotiation [generous]
  384. 2017-10-18 15:42:59.073054 [DEBUG] sofia.c:4450 nonce-ttl [60]
  385. 2017-10-18 15:42:59.073066 [DEBUG] sofia.c:4450 auth-calls [false]
  386. 2017-10-18 15:42:59.073071 [DEBUG] sofia.c:4450 inbound-late-negotiation [true]
  387. 2017-10-18 15:42:59.073074 [DEBUG] sofia.c:4450 inbound-zrtp-passthru [true]
  388. 2017-10-18 15:42:59.073076 [DEBUG] sofia.c:4450 rtp-ip [10.120.3.24]
  389. 2017-10-18 15:42:59.073079 [DEBUG] sofia.c:4450 sip-ip [10.120.3.24]
  390. 2017-10-18 15:42:59.073082 [DEBUG] sofia.c:4450 ext-rtp-ip [auto-nat]
  391. 2017-10-18 15:42:59.073086 [DEBUG] sofia.c:4450 ext-sip-ip [auto-nat]
  392. 2017-10-18 15:42:59.073090 [DEBUG] sofia.c:4450 rtp-timeout-sec [300]
  393. 2017-10-18 15:42:59.073093 [DEBUG] sofia.c:4450 rtp-hold-timeout-sec [1800]
  394. 2017-10-18 15:42:59.073095 [DEBUG] sofia.c:4450 enable-3pcc [true]
  395. 2017-10-18 15:42:59.073100 [DEBUG] sofia.c:4450 tls [false]
  396. 2017-10-18 15:42:59.073105 [DEBUG] sofia.c:4450 tls-only [false]
  397. 2017-10-18 15:42:59.073130 [DEBUG] sofia.c:4450 tls-bind-params [transport=tls]
  398. 2017-10-18 15:42:59.073137 [DEBUG] sofia.c:4450 tls-sip-port [5049]
  399. 2017-10-18 15:42:59.073142 [DEBUG] sofia.c:4450 tls-passphrase []
  400. 2017-10-18 15:42:59.073152 [DEBUG] sofia.c:4450 tls-verify-date [true]
  401. 2017-10-18 15:42:59.073158 [DEBUG] sofia.c:4450 tls-verify-policy [none]
  402. 2017-10-18 15:42:59.073161 [DEBUG] sofia.c:4450 tls-verify-depth [2]
  403. 2017-10-18 15:42:59.073169 [DEBUG] sofia.c:4450 tls-verify-in-subjects []
  404. 2017-10-18 15:42:59.073176 [DEBUG] sofia.c:4450 tls-version [tlsv1,tlsv1.1,tlsv1.2]
  405. 2017-10-18 15:42:59.073199 [INFO] sofia.c:5782 Setting MAX Auth Validity to 0 Attempts
  406. 2017-10-18 15:42:59.073272 [NOTICE] sofia.c:5949 Started Profile rsbc [sofia_reg_rsbc]
  407. 2017-10-18 15:42:59.073302 [DEBUG] sofia.c:4450 debug [0]
  408. 2017-10-18 15:42:59.073304 [DEBUG] sofia.c:4450 sip-trace [no]
  409. 2017-10-18 15:42:59.073306 [DEBUG] sofia.c:4450 sip-capture [yes]
  410. 2017-10-18 15:42:59.073309 [DEBUG] sofia.c:4450 rfc2833-pt [101]
  411. 2017-10-18 15:42:59.073313 [DEBUG] sofia.c:4450 sip-port [5046]
  412. 2017-10-18 15:42:59.073317 [DEBUG] sofia.c:4450 dialplan [XML]
  413. 2017-10-18 15:42:59.073325 [DEBUG] sofia.c:4450 context [sbc_dp]
  414. 2017-10-18 15:42:59.073331 [DEBUG] sofia.c:4450 dtmf-duration [2000]
  415. 2017-10-18 15:42:59.073335 [DEBUG] sofia.c:4450 inbound-codec-prefs [PCMU]
  416. 2017-10-18 15:42:59.073345 [DEBUG] sofia.c:4450 outbound-codec-prefs [PCMU]
  417. 2017-10-18 15:42:59.073353 [DEBUG] sofia.c:4450 hold-music [local_stream://moh]
  418. 2017-10-18 15:42:59.073358 [DEBUG] sofia.c:4450 rtp-timer-name [soft]
  419. 2017-10-18 15:42:59.073361 [DEBUG] sofia.c:4450 local-network-acl [localnet.auto]
  420. 2017-10-18 15:42:59.073364 [DEBUG] sofia.c:4450 manage-presence [false]
  421. 2017-10-18 15:42:59.073365 [DEBUG] sofia.c:3046 Creating agent for rsbc
  422. 2017-10-18 15:42:59.073367 [DEBUG] sofia.c:4450 odbc-dsn [pgsql://hostaddr=10.120.3.3 dbname=svp2 user=tms password='s1IghR2gMZ19G81LxFtvc8BH0TJgq7Mw' options='-c client_min_messages=NOTICE' application_name='freeswitch']
  423. 2017-10-18 15:42:59.073421 [DEBUG] sofia.c:4450 inbound-codec-negotiation [generous]
  424. 2017-10-18 15:42:59.073428 [DEBUG] sofia.c:4450 nonce-ttl [60]
  425. 2017-10-18 15:42:59.073437 [DEBUG] sofia.c:4450 auth-calls [false]
  426. 2017-10-18 15:42:59.073443 [DEBUG] sofia.c:4450 inbound-late-negotiation [true]
  427. 2017-10-18 15:42:59.073446 [DEBUG] sofia.c:4450 inbound-zrtp-passthru [true]
  428. 2017-10-18 15:42:59.073449 [DEBUG] sofia.c:4450 rtp-ip [10.120.3.24]
  429. 2017-10-18 15:42:59.073455 [DEBUG] sofia.c:4450 sip-ip [10.120.3.24]
  430. 2017-10-18 15:42:59.073458 [DEBUG] sofia.c:4450 ext-rtp-ip [auto-nat]
  431. 2017-10-18 15:42:59.073462 [DEBUG] sofia.c:4450 ext-sip-ip [auto-nat]
  432. 2017-10-18 15:42:59.073466 [DEBUG] sofia.c:4450 rtp-timeout-sec [300]
  433. 2017-10-18 15:42:59.073472 [DEBUG] sofia.c:4450 rtp-hold-timeout-sec [1800]
  434. 2017-10-18 15:42:59.073480 [DEBUG] sofia.c:4450 enable-3pcc [true]
  435. 2017-10-18 15:42:59.073486 [DEBUG] sofia.c:4450 tls [false]
  436. 2017-10-18 15:42:59.073495 [DEBUG] sofia.c:4450 tls-only [false]
  437. 2017-10-18 15:42:59.073503 [DEBUG] sofia.c:4450 tls-bind-params [transport=tls]
  438. 2017-10-18 15:42:59.073513 [DEBUG] sofia.c:4450 tls-sip-port [5047]
  439. 2017-10-18 15:42:59.073520 [DEBUG] sofia.c:4450 tls-passphrase []
  440. 2017-10-18 15:42:59.073530 [DEBUG] sofia.c:4450 tls-verify-date [true]
  441. 2017-10-18 15:42:59.073542 [DEBUG] sofia.c:4450 tls-verify-policy [none]
  442. 2017-10-18 15:42:59.073549 [DEBUG] sofia.c:4450 tls-verify-depth [2]
  443. 2017-10-18 15:42:59.073553 [DEBUG] sofia.c:4450 tls-verify-in-subjects []
  444. 2017-10-18 15:42:59.073559 [DEBUG] sofia.c:4450 tls-version [tlsv1,tlsv1.1,tlsv1.2]
  445. 2017-10-18 15:42:59.073569 [INFO] sofia.c:5782 Setting MAX Auth Validity to 0 Attempts
  446. 2017-10-18 15:42:59.073618 [NOTICE] sofia.c:5946 Connecting ODBC Profile sbc [sofia_reg_sbc]
  447. 2017-10-18 15:42:59.073732 [DEBUG] sofia.c:3046 Creating agent for sbc
  448. 2017-10-18 15:42:59.082495 [DEBUG] switch_pgsql.c:415 Query (create index sr_call_id on sip_registrations (call_id)) returned PGRES_FATAL_ERROR
  449. 2017-10-18 15:42:59.082792 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_user on sip_registrations (sip_user)) returned PGRES_FATAL_ERROR
  450. 2017-10-18 15:42:59.083043 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_host on sip_registrations (sip_host)) returned PGRES_FATAL_ERROR
  451. 2017-10-18 15:42:59.083298 [DEBUG] switch_pgsql.c:415 Query (create index sr_sub_host on sip_registrations (sub_host)) returned PGRES_FATAL_ERROR
  452. 2017-10-18 15:42:59.083554 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_user on sip_registrations (mwi_user)) returned PGRES_FATAL_ERROR
  453. 2017-10-18 15:42:59.083800 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_host on sip_registrations (mwi_host)) returned PGRES_FATAL_ERROR
  454. 2017-10-18 15:42:59.084056 [DEBUG] switch_pgsql.c:415 Query (create index sr_profile_name on sip_registrations (profile_name)) returned PGRES_FATAL_ERROR
  455. 2017-10-18 15:42:59.084309 [DEBUG] switch_pgsql.c:415 Query (create index sr_presence_hosts on sip_registrations (presence_hosts)) returned PGRES_FATAL_ERROR
  456. 2017-10-18 15:42:59.084569 [DEBUG] switch_pgsql.c:415 Query (create index sr_contact on sip_registrations (contact)) returned PGRES_FATAL_ERROR
  457. 2017-10-18 15:42:59.084884 [DEBUG] switch_pgsql.c:415 Query (create index sr_expires on sip_registrations (expires)) returned PGRES_FATAL_ERROR
  458. 2017-10-18 15:42:59.085215 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_expires on sip_registrations (ping_expires)) returned PGRES_FATAL_ERROR
  459. 2017-10-18 15:42:59.085481 [DEBUG] switch_pgsql.c:415 Query (create index sr_hostname on sip_registrations (hostname)) returned PGRES_FATAL_ERROR
  460. 2017-10-18 15:42:59.085865 [DEBUG] switch_pgsql.c:415 Query (create index sr_status on sip_registrations (status)) returned PGRES_FATAL_ERROR
  461. 2017-10-18 15:42:59.086153 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_status on sip_registrations (ping_status)) returned PGRES_FATAL_ERROR
  462. 2017-10-18 15:42:59.086406 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_ip on sip_registrations (network_ip)) returned PGRES_FATAL_ERROR
  463. 2017-10-18 15:42:59.086652 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_port on sip_registrations (network_port)) returned PGRES_FATAL_ERROR
  464. 2017-10-18 15:42:59.086900 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_username on sip_registrations (sip_username)) returned PGRES_FATAL_ERROR
  465. 2017-10-18 15:42:59.087153 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_realm on sip_registrations (sip_realm)) returned PGRES_FATAL_ERROR
  466. 2017-10-18 15:42:59.087394 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_server_host on sip_registrations (orig_server_host)) returned PGRES_FATAL_ERROR
  467. 2017-10-18 15:42:59.087666 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_hostname on sip_registrations (orig_hostname)) returned PGRES_FATAL_ERROR
  468. 2017-10-18 15:42:59.087927 [DEBUG] switch_pgsql.c:415 Query (create index ss_call_id on sip_subscriptions (call_id)) returned PGRES_FATAL_ERROR
  469. 2017-10-18 15:42:59.088251 [DEBUG] switch_pgsql.c:415 Query (create index ss_multi on sip_subscriptions (call_id, profile_name, hostname)) returned PGRES_FATAL_ERROR
  470. 2017-10-18 15:42:59.088505 [DEBUG] switch_pgsql.c:415 Query (create index ss_hostname on sip_subscriptions (hostname)) returned PGRES_FATAL_ERROR
  471. 2017-10-18 15:42:59.088761 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_ip on sip_subscriptions (network_ip)) returned PGRES_FATAL_ERROR
  472. 2017-10-18 15:42:59.089013 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_user on sip_subscriptions (sip_user)) returned PGRES_FATAL_ERROR
  473. 2017-10-18 15:42:59.089269 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_host on sip_subscriptions (sip_host)) returned PGRES_FATAL_ERROR
  474. 2017-10-18 15:42:59.089553 [DEBUG] switch_pgsql.c:415 Query (create index ss_presence_hosts on sip_subscriptions (presence_hosts)) returned PGRES_FATAL_ERROR
  475. 2017-10-18 15:42:59.089821 [DEBUG] switch_pgsql.c:415 Query (create index ss_event on sip_subscriptions (event)) returned PGRES_FATAL_ERROR
  476. 2017-10-18 15:42:59.090077 [DEBUG] switch_pgsql.c:415 Query (create index ss_proto on sip_subscriptions (proto)) returned PGRES_FATAL_ERROR
  477. 2017-10-18 15:42:59.090348 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_user on sip_subscriptions (sub_to_user)) returned PGRES_FATAL_ERROR
  478. 2017-10-18 15:42:59.090635 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_host on sip_subscriptions (sub_to_host)) returned PGRES_FATAL_ERROR
  479. 2017-10-18 15:42:59.090900 [DEBUG] switch_pgsql.c:415 Query (create index ss_expires on sip_subscriptions (expires)) returned PGRES_FATAL_ERROR
  480. 2017-10-18 15:42:59.091163 [DEBUG] switch_pgsql.c:415 Query (create index ss_orig_proto on sip_subscriptions (orig_proto)) returned PGRES_FATAL_ERROR
  481. 2017-10-18 15:42:59.091521 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_port on sip_subscriptions (network_port)) returned PGRES_FATAL_ERROR
  482. 2017-10-18 15:42:59.091781 [DEBUG] switch_pgsql.c:415 Query (create index ss_profile_name on sip_subscriptions (profile_name)) returned PGRES_FATAL_ERROR
  483. 2017-10-18 15:42:59.092096 [DEBUG] switch_pgsql.c:415 Query (create index ss_version on sip_subscriptions (version)) returned PGRES_FATAL_ERROR
  484. 2017-10-18 15:42:59.092425 [DEBUG] switch_pgsql.c:415 Query (create index ss_full_from on sip_subscriptions (full_from)) returned PGRES_FATAL_ERROR
  485. 2017-10-18 15:42:59.092725 [DEBUG] switch_pgsql.c:415 Query (create index ss_contact on sip_subscriptions (contact)) returned PGRES_FATAL_ERROR
  486. 2017-10-18 15:42:59.092997 [DEBUG] switch_pgsql.c:415 Query (create index sd_uuid on sip_dialogs (uuid)) returned PGRES_FATAL_ERROR
  487. 2017-10-18 15:42:59.093297 [DEBUG] switch_pgsql.c:415 Query (create index sd_hostname on sip_dialogs (hostname)) returned PGRES_FATAL_ERROR
  488. 2017-10-18 15:42:59.093586 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_data on sip_dialogs (presence_data)) returned PGRES_FATAL_ERROR
  489. 2017-10-18 15:42:59.093841 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info on sip_dialogs (call_info)) returned PGRES_FATAL_ERROR
  490. 2017-10-18 15:42:59.094120 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info_state on sip_dialogs (call_info_state)) returned PGRES_FATAL_ERROR
  491. 2017-10-18 15:42:59.094371 [DEBUG] switch_pgsql.c:415 Query (create index sd_expires on sip_dialogs (expires)) returned PGRES_FATAL_ERROR
  492. 2017-10-18 15:42:59.094620 [DEBUG] switch_pgsql.c:415 Query (create index sd_rcd on sip_dialogs (rcd)) returned PGRES_FATAL_ERROR
  493. 2017-10-18 15:42:59.094869 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_tag on sip_dialogs (sip_to_tag)) returned PGRES_FATAL_ERROR
  494. 2017-10-18 15:42:59.095140 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_user on sip_dialogs (sip_from_user)) returned PGRES_FATAL_ERROR
  495. 2017-10-18 15:42:59.095398 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_host on sip_dialogs (sip_from_host)) returned PGRES_FATAL_ERROR
  496. 2017-10-18 15:42:59.095657 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_host on sip_dialogs (sip_to_host)) returned PGRES_FATAL_ERROR
  497. 2017-10-18 15:42:59.095914 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_id on sip_dialogs (presence_id)) returned PGRES_FATAL_ERROR
  498. 2017-10-18 15:42:59.096156 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_id on sip_dialogs (call_id)) returned PGRES_FATAL_ERROR
  499. 2017-10-18 15:42:59.096406 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_tag on sip_dialogs (sip_from_tag)) returned PGRES_FATAL_ERROR
  500. 2017-10-18 15:42:59.096655 [DEBUG] switch_pgsql.c:415 Query (create index sp_hostname on sip_presence (hostname)) returned PGRES_FATAL_ERROR
  501. 2017-10-18 15:42:59.096909 [DEBUG] switch_pgsql.c:415 Query (create index sp_open_closed on sip_presence (open_closed)) returned PGRES_FATAL_ERROR
  502. 2017-10-18 15:42:59.097191 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_user on sip_presence (sip_user)) returned PGRES_FATAL_ERROR
  503. 2017-10-18 15:42:59.097470 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_host on sip_presence (sip_host)) returned PGRES_FATAL_ERROR
  504. 2017-10-18 15:42:59.097748 [DEBUG] switch_pgsql.c:415 Query (create index sp_profile_name on sip_presence (profile_name)) returned PGRES_FATAL_ERROR
  505. 2017-10-18 15:42:59.098162 [DEBUG] switch_pgsql.c:415 Query (create index sp_expires on sip_presence (expires)) returned PGRES_FATAL_ERROR
  506. 2017-10-18 15:42:59.098459 [DEBUG] switch_pgsql.c:415 Query (create index sa_nonce on sip_authentication (nonce)) returned PGRES_FATAL_ERROR
  507. 2017-10-18 15:42:59.098764 [DEBUG] switch_pgsql.c:415 Query (create index sa_hostname on sip_authentication (hostname)) returned PGRES_FATAL_ERROR
  508. 2017-10-18 15:42:59.099085 [DEBUG] switch_pgsql.c:415 Query (create index sa_expires on sip_authentication (expires)) returned PGRES_FATAL_ERROR
  509. 2017-10-18 15:42:59.099356 [DEBUG] switch_pgsql.c:415 Query (create index sa_last_nc on sip_authentication (last_nc)) returned PGRES_FATAL_ERROR
  510. 2017-10-18 15:42:59.099654 [DEBUG] switch_pgsql.c:415 Query (create index ssa_hostname on sip_shared_appearance_subscriptions (hostname)) returned PGRES_FATAL_ERROR
  511. 2017-10-18 15:42:59.099910 [DEBUG] switch_pgsql.c:415 Query (create index ssa_network_ip on sip_shared_appearance_subscriptions (network_ip)) returned PGRES_FATAL_ERROR
  512. 2017-10-18 15:42:59.100179 [DEBUG] switch_pgsql.c:415 Query (create index ssa_subscriber on sip_shared_appearance_subscriptions (subscriber)) returned PGRES_FATAL_ERROR
  513. 2017-10-18 15:42:59.100470 [DEBUG] switch_pgsql.c:415 Query (create index ssa_profile_name on sip_shared_appearance_subscriptions (profile_name)) returned PGRES_FATAL_ERROR
  514. 2017-10-18 15:42:59.100746 [DEBUG] switch_pgsql.c:415 Query (create index ssa_aor on sip_shared_appearance_subscriptions (aor)) returned PGRES_FATAL_ERROR
  515. 2017-10-18 15:42:59.101019 [DEBUG] switch_pgsql.c:415 Query (create index ssd_profile_name on sip_shared_appearance_dialogs (profile_name)) returned PGRES_FATAL_ERROR
  516. 2017-10-18 15:42:59.101317 [DEBUG] switch_pgsql.c:415 Query (create index ssd_hostname on sip_shared_appearance_dialogs (hostname)) returned PGRES_FATAL_ERROR
  517. 2017-10-18 15:42:59.101632 [DEBUG] switch_pgsql.c:415 Query (create index ssd_contact_str on sip_shared_appearance_dialogs (contact_str)) returned PGRES_FATAL_ERROR
  518. 2017-10-18 15:42:59.101881 [DEBUG] switch_pgsql.c:415 Query (create index ssd_call_id on sip_shared_appearance_dialogs (call_id)) returned PGRES_FATAL_ERROR
  519. 2017-10-18 15:42:59.102145 [DEBUG] switch_pgsql.c:415 Query (create index ssd_expires on sip_shared_appearance_dialogs (expires)) returned PGRES_FATAL_ERROR