2020-11-19 14:37:29.910318 [NOTICE] switch_channel.c:1118 New Channel sofia/default/8138902220@192.168.8.6 [5c18286f-5ad9-4a3f-a129-a79f09917d30] 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_NEW (Cur 1 Tot 28510) 2020-11-19 14:37:29.910318 [DEBUG] sofia.c:10243 sofia/default/8138902220@192.168.8.6 receiving invite from 192.168.8.6:5060 version: 1.10.1 -release-12-f9990221e6 64bit 2020-11-19 14:37:29.910318 [DEBUG] sofia.c:10337 verifying acl "default" for ip/port 192.168.8.6:0. 2020-11-19 14:37:29.910318 [DEBUG] sofia.c:10366 IP 192.168.8.6 Approved by acl "default[]". Access Granted. 2020-11-19 14:37:29.910318 [DEBUG] sofia.c:7290 Channel sofia/default/8138902220@192.168.8.6 entering state [received][100] 2020-11-19 14:37:29.910318 [DEBUG] sofia.c:7300 Remote SDP: v=0 o=- 1054601244 1054601244 IN IP4 192.168.8.6 s=Asterisk c=IN IP4 192.168.8.6 t=0 0 m=audio 16050 RTP/AVP 0 8 3 111 9 101 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:3 GSM/8000 a=rtpmap:111 G726-32/8000 a=rtpmap:9 G722/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=ptime:20 a=maxptime:150 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5645 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5645 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1] 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1] 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [G726-32:111:8000:20:0:1]/[PCMA:8:8000:20:64000:1] 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [G726-32:111:8000:20:0:1]/[PCMU:0:8000:20:64000:1] 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5506 Set telephone-event payload to 101@8000 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:3834 Set Codec sofia/default/8138902220@192.168.8.6 PCMU/8000 20 ms 160 samples 64000 bits 1 channels 2020-11-19 14:37:29.910318 [DEBUG] switch_core_codec.c:111 sofia/default/8138902220@192.168.8.6 Original read codec set to PCMU:0 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5849 Set telephone-event payload to 101@8000 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5907 sofia/default/8138902220@192.168.8.6 Set 2833 dtmf send payload to 101 recv payload to 101 2020-11-19 14:37:29.910318 [DEBUG] sofia.c:7724 (sofia/default/8138902220@192.168.8.6) State Change CS_NEW -> CS_INIT 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:604 (sofia/default/8138902220@192.168.8.6) State NEW 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_INIT (Cur 1 Tot 28510) 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:628 (sofia/default/8138902220@192.168.8.6) State INIT 2020-11-19 14:37:29.910318 [DEBUG] mod_sofia.c:93 sofia/default/8138902220@192.168.8.6 SOFIA INIT 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:40 sofia/default/8138902220@192.168.8.6 Standard INIT 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:48 (sofia/default/8138902220@192.168.8.6) State Change CS_INIT -> CS_ROUTING 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:628 (sofia/default/8138902220@192.168.8.6) State INIT going to sleep 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_ROUTING (Cur 1 Tot 28510) 2020-11-19 14:37:29.910318 [DEBUG] switch_channel.c:2332 (sofia/default/8138902220@192.168.8.6) Callstate Change DOWN -> RINGING 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:644 (sofia/default/8138902220@192.168.8.6) State ROUTING 2020-11-19 14:37:29.910318 [DEBUG] mod_sofia.c:154 sofia/default/8138902220@192.168.8.6 SOFIA ROUTING 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:236 sofia/default/8138902220@192.168.8.6 Standard ROUTING 2020-11-19 14:37:29.910318 [INFO] mod_dialplan_xml.c:637 Processing 8138902220 <8138902220>->9088999989 in context default 2020-11-19 14:37:29.910318 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2020-11-19 14:37:29.910318 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2020-11-19 14:37:29.950325 [NOTICE] switch_cpp.cpp:1443 [ASTPP] [xml_handler] Params: Event-Name: REQUEST_PARAMS Core-UUID: ab3e105f-e6f4-458f-b102-a4065f4859ae FreeSWITCH-Hostname: soultech FreeSWITCH-Switchname: soultech FreeSWITCH-IPv4: 192.168.8.3 FreeSWITCH-IPv6: %3A%3A1 Event-Date-Local: 2020-11-19%2014%3A37%3A29 Event-Date-GMT: Thu,%2019%20Nov%202020%2013%3A37%3A29%20GMT Event-Date-Timestamp: 1605793049910318 Event-Calling-File: mod_dialplan_xml.c Event-Calling-Function: dialplan_xml_locate Event-Calling-Line-Number: 608 Event-Sequence: 555749 Channel-State: CS_ROUTING Channel-Call-State: RINGING Channel-State-Number: 2 Channel-Name: sofia/default/8138902220%40192.168.8.6 Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30 Call-Direction: inbound Presence-Call-Direction: inbound Channel-HIT-Dialplan: true Channel-Presence-ID: 8138902220%40192.168.8.6 Channel-Call-UUID: 5c18286f-5ad9-4a3f-a129-a79f09917d30 Answer-State: ringing Channel-Read-Codec-Name: PCMU Channel-Read-Codec-Rate: 8000 Channel-Read-Codec-Bit-Rate: 64000 Channel-Write-Codec-Name: PCMU Channel-Write-Codec-Rate: 8000 Channel-Write-Codec-Bit-Rate: 64000 Caller-Direction: inbound Caller-Logical-Direction: inbound Caller-Username: 8138902220 Caller-Dialplan: XML Caller-Caller-ID-Name: 8138902220 Caller-Caller-ID-Number: 8138902220 Caller-Orig-Caller-ID-Name: 8138902220 Caller-Orig-Caller-ID-Number: 8138902220 Caller-Network-Addr: 192.168.8.6 Caller-ANI: 8138902220 Caller-Destination-Number: 9088999989 Caller-Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30 Caller-Source: mod_sofia Caller-Context: default Caller-Channel-Name: sofia/default/8138902220%40192.168.8.6 Caller-Profile-Index: 1 Caller-Profile-Created-Time: 1605793049910318 Caller-Channel-Created-Time: 1605793049910318 Caller-Channel-Answered-Time: 0 Caller-Channel-Progress-Time: 0 Caller-Channel-Progress-Media-Time: 0 Caller-Channel-Hangup-Time: 0 Caller-Channel-Transfer-Time: 0 Caller-Channel-Resurrect-Time: 0 Caller-Channel-Bridged-Time: 0 Caller-Channel-Last-Hold: 0 Caller-Channel-Hold-Accum: 0 Caller-Screen-Bit: true Caller-Privacy-Hide-Name: false Caller-Privacy-Hide-Number: false variable_direction: inbound variable_uuid: 5c18286f-5ad9-4a3f-a129-a79f09917d30 variable_session_id: 28510 variable_sip_from_user: 8138902220 variable_sip_from_uri: 8138902220%40192.168.8.6 variable_sip_from_host: 192.168.8.6 variable_video_media_flow: disabled variable_text_media_flow: disabled variable_channel_name: sofia/default/8138902220%40192.168.8.6 variable_sip_call_id: a2b73d1d-26d9-4a65-b280-1c62b2d98c30 variable_sip_local_network_addr: 192.168.8.3 variable_sip_network_ip: 192.168.8.6 variable_sip_network_port: 5060 variable_sip_invite_stamp: 1605793049910318 variable_sip_received_ip: 192.168.8.6 variable_sip_received_port: 5060 variable_sip_via_protocol: udp variable_sip_authorized: true variable_sip_acl_authed_by: default variable_sip_from_user_stripped: 8138902220 variable_sip_from_tag: a251beb8-e6dd-4c47-b493-aba69df9be3c variable_sofia_profile_name: default variable_sofia_profile_url: sip%3Amod_sofia%40192.168.8.3%3A5060 variable_recovery_profile_name: default variable_sip_full_via: SIP/2.0/UDP%20192.168.8.6%3A5060%3Brport%3D5060%3Bbranch%3Dz9hG4bKPj3ea88895-62a2-4c68-9a9e-54489e70cdb3 variable_sip_from_display: 8138902220 variable_sip_full_from: %228138902220%22%20%3Csip%3A8138902220%40192.168.8.6%3E%3Btag%3Da251beb8-e6dd-4c47-b493-aba69df9be3c variable_sip_full_to: %3Csip%3A9088999989%40192.168.8.3%3E variable_sip_allow: OPTIONS,%20SUBSCRIBE,%20NOTIFY,%20PUBLISH,%20INVITE,%20ACK,%20BYE,%20CANCEL,%20UPDATE,%20PRACK,%20REGISTER,%20MESSAGE,%20REFER variable_sip_req_user: 9088999989 variable_sip_req_uri: 9088999989%40192.168.8.3 variable_sip_req_host: 192.168.8.3 variable_sip_to_user: 9088999989 variable_sip_to_uri: 9088999989%40192.168.8.3 variable_sip_to_host: 192.168.8.3 variable_sip_contact_user: asterisk variable_sip_contact_port: 5060 variable_sip_contact_uri: asterisk%40192.168.8.6%3A5060 variable_sip_contact_host: 192.168.8.6 variable_sip_user_agent: FPBX-14.0.13.40(13.29.2) variable_sip_via_host: 192.168.8.6 variable_sip_via_port: 5060 variable_sip_via_rport: 5060 variable_max_forwards: 70 variable_presence_id: 8138902220%40192.168.8.6 variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%201054601244%201054601244%20IN%20IP4%20192.168.8.6%0D%0As%3DAsterisk%0D%0Ac%3DIN%20IP4%20192.168.8.6%0D%0At%3D0%200%0D%0Am%3Daudio%2016050%20RTP/AVP%200%208%203%20111%209%20101%0D%0Aa%3Drtpmap%3A0%20PCMU/8000%0D%0Aa%3Drtpmap%3A8%20PCMA/8000%0D%0Aa%3Drtpmap%3A3%20GSM/8000%0D%0Aa%3Drtpmap%3A111%20G726-32/8000%0D%0Aa%3Drtpmap%3A9%20G722/8000%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dfmtp%3A101%200-16%0D%0Aa%3Dptime%3A20%0D%0Aa%3Dmaxptime%3A150%0D%0A variable_ep_codec_string: CORE_PCM_MODULE.PCMU%408000h%4020i%4064000b,CORE_PCM_MODULE.PCMA%408000h%4020i%4064000b variable_rtp_use_codec_string: PCMA,PCMU variable_remote_video_media_flow: inactive variable_remote_text_media_flow: inactive variable_remote_audio_media_flow: sendrecv variable_audio_media_flow: sendrecv variable_remote_media_ip: 192.168.8.6 variable_remote_media_port: 16050 variable_rtp_audio_recv_pt: 0 variable_rtp_use_codec_name: PCMU variable_rtp_use_codec_rate: 8000 variable_rtp_use_codec_ptime: 20 variable_rtp_use_codec_channels: 1 variable_rtp_last_audio_codec_string: PCMU%408000h%4020i%401c variable_read_codec: PCMU variable_original_read_codec: PCMU variable_read_rate: 8000 variable_original_read_rate: 8000 variable_write_codec: PCMU variable_write_rate: 8000 variable_dtmf_type: rfc2833 variable_endpoint_disposition: RECEIVED variable_call_uuid: 5c18286f-5ad9-4a3f-a129-a79f09917d30 Hunt-Direction: inbound Hunt-Logical-Direction: inbound Hunt-Username: 8138902220 Hunt-Dialplan: XML Hunt-Caller-ID-Name: 8138902220 Hunt-Caller-ID-Number: 8138902220 Hunt-Orig-Caller-ID-Name: 8138902220 Hunt-Orig-Caller-ID-Number: 8138902220 Hunt-Network-Addr: 192.168.8.6 Hunt-ANI: 8138902220 Hunt-Destination-Number: 9088999989 Hunt-Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30 Hunt-Source: mod_sofia Hunt-Context: default Hunt-Channel-Name: sofia/default/8138902220%40192.168.8.6 Hunt-Profile-Index: 1 Hunt-Profile-Created-Time: 1605793049910318 Hunt-Channel-Created-Time: 1605793049910318 Hunt-Channel-Answered-Time: 0 Hunt-Channel-Progress-Time: 0 Hunt-Channel-Progress-Media-Time: 0 Hunt-Channel-Hangup-Time: 0 Hunt-Channel-Transfer-Time: 0 Hunt-Channel-Resurrect-Time: 0 Hunt-Channel-Bridged-Time: 0 Hunt-Channel-Last-Hold: 0 Hunt-Channel-Hold-Accum: 0 Hunt-Screen-Bit: true Hunt-Privacy-Hide-Name: false Hunt-Privacy-Hide-Number: false 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] tag_name: 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_value: 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_name: 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] section: dialplan 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] blind_flag: 0 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Dialed number : 9088999989 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '9088999989' limit 1 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '9088999989' AND status=0 limit 1 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '9088999989' and status=0 LIMIT 1 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Caller Id name / number : 8138902220 / 8138902220 2020-11-19 14:37:29.950325 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9088999989" LIMIT 1 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Call direction : inbound 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("192.168.8.6") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "9088999989" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [Accountcode : 1135674299] 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_SPEEDDIAL] Query :SELECT A.number FROM speed_dial as A,accounts as B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.speed_num ="9088999989" AND A.accountid = '123' limit 1 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 9088999989 2020-11-19 14:37:29.950325 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9088999989" LIMIT 1 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] New Call direction : inbound 2020-11-19 14:37:29.950325 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="9088999989" AND (accountid = 0 OR status = 1) LIMIT 1 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] call_direction :inbound 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] DID_ACCOUNTID :138 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE (patterns = '^9088999989.*' OR patterns = '^908899998.*' OR patterns = '^90889999.*' OR patterns = '^9088999.*' OR patterns = '^908899.*' OR patterns = '^90889.*' OR patterns = '^9088.*' OR patterns = '^908.*' OR patterns = '^90.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 138 ORDER BY LENGTH(PKGPTR.patterns) DESC 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '9088999989' OR number = '908899998' OR number = '90889999' OR number = '9088999' OR number = '908899' OR number = '90889' OR number = '9088' OR number = '908' OR number = '90' OR number = '9' OR number ='--') OR (number = '9088999989*' OR number = '908899998*' OR number = '90889999*' OR number = '9088999*' OR number = '908899*' OR number = '90889*' OR number = '9088*' OR number = '908*' OR number = '90*' OR number = '9*' OR number ='--') OR (number = '8138902220' OR number = '813890222' OR number = '81389022' OR number = '8138902' OR number = '813890' OR number = '81389' OR number = '8138' OR number = '813' OR number = '81' OR number = '8' OR number ='--') OR (number = '8138902220*' OR number = '813890222*' OR number = '81389022*' OR number = '8138902*' OR number = '813890*' OR number = '81389*' OR number = '8138*' OR number = '813*' OR number = '81*' OR number = '8*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Call Barring Status : -1 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '9088999989' OR routing_prefix = '908899998' OR routing_prefix = '90889999' OR routing_prefix = '9088999' OR routing_prefix = '908899' OR routing_prefix = '90889' OR routing_prefix = '9088' OR routing_prefix = '908' OR routing_prefix = '90' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] =============== Account Information =================== 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] User id : 123 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Account code : 1135674299 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Balance : 6856.66 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Ratecard id : 1 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] CID Pool : 0 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] ======================================================== 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_RATES] call_direction :inbound 2020-11-19 14:37:29.990251 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9088999989" LIMIT 1 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] call_direction:::::: inbound 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] =============== Rates Information =================== 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] ID : 47 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Connectcost : 0.00000 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Includedseconds : 0 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Cost : 10.00000 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] comment : 9088999989 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Country Id : 141 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Accid : 123 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] ================================================================ 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [FIND_MAXLENGTH] Your6856.66 balance Accountid 123 !!! 2020-11-19 14:37:29.990251 [NOTICE] switch_cpp.cpp:1443 [ASTPP] [FIND_MAXLENGTH] Limiting call to config max length 100 mins! 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Call Max length duration : 100 minutes 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] INB_FREE:TRUE 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] free_inbound:1 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 123 AND status=0 LIMIT 1 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Actual CustomerInfo XML:123 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Userinfo XML:123 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Actual CustomerInfo XML : 123 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] timecondition_id : 3 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '3' and status =0 LIMIT 1 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] failover_timecondition : [{"extensions":"6350951709","no_answer_call_type":"11"}] 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] timecondition : [{"hour":"00-23","minute":"00-59","wday":"2-2","mday":"1-31","mon":"1-12","year":"2020-2020","extensions":"6350951709","no_answer_call_type":"11","priority":"1"}] 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] failover_timecondition_str : 6350951709 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] priority : 1 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] condition_str : time-of-day= "00:00-23:59" wday= "2-2" mday= "1-31" mon= "1-12" year= "2020-2020" 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] maxlength::::::::: 100 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET domains] Query :SELECT * FROM domains WHERE accountid = 138 limit 1 2020-11-19 14:37:29.990251 [WARNING] switch_cpp.cpp:1443 [ASTPP] [user_domain] user_domaintest446.9mobile.nativetalk.com.ng 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] custom_function_name:::::::::::::::::::::::::custom_inbound_11 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] timecondition_id : 3 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '3' and status =0 LIMIT 1 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] time_condition::::::::::::::::::::::::47 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] custom_function_name::::::::::::::::::::::::47 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Generated XML:
Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->TimeTC] continue=true Dialplan: sofia/default/8138902220@192.168.8.6 Date/Time Match (PASS) [TimeTC] break=never Dialplan: sofia/default/8138902220@192.168.8.6 Action set(office_status=open) INLINE EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(office_status=open) 2020-11-19 14:37:29.990251 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [office_status]=[open] Dialplan: sofia/default/8138902220@192.168.8.6 Action set(extensions=6350951709) INLINE EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(extensions=6350951709) 2020-11-19 14:37:29.990251 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [extensions]=[6350951709] Dialplan: sofia/default/8138902220@192.168.8.6 Action set(no_answer_call_type=11) INLINE EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(no_answer_call_type=11) 2020-11-19 14:37:29.990251 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [no_answer_call_type]=[11] Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->TimeTC] continue=true Dialplan: sofia/default/8138902220@192.168.8.6 Date/TimeMatch (FAIL) [TimeTC] break=never Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->tod route, x9088999989] continue=false Dialplan: sofia/default/8138902220@192.168.8.6 Regex (PASS) [tod route, x9088999989] destination_number(9088999989) =~ /^(9088999989)$/ break=on-false Dialplan: sofia/default/8138902220@192.168.8.6 Action execute_extension(9088999989_${office_status}) 2020-11-19 14:37:29.990251 [DEBUG] switch_core_state_machine.c:287 (sofia/default/8138902220@192.168.8.6) State Change CS_ROUTING -> CS_EXECUTE 2020-11-19 14:37:29.990251 [DEBUG] switch_core_state_machine.c:644 (sofia/default/8138902220@192.168.8.6) State ROUTING going to sleep 2020-11-19 14:37:29.990251 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_EXECUTE (Cur 1 Tot 28510) 2020-11-19 14:37:29.990251 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE 2020-11-19 14:37:29.990251 [DEBUG] mod_sofia.c:209 sofia/default/8138902220@192.168.8.6 SOFIA EXECUTE 2020-11-19 14:37:29.990251 [DEBUG] switch_core_state_machine.c:329 sofia/default/8138902220@192.168.8.6 Standard EXECUTE EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 execute_extension(9088999989_open) 2020-11-19 14:37:29.990251 [INFO] mod_dialplan_xml.c:637 Processing 8138902220 <8138902220>->9088999989_open in context default 2020-11-19 14:37:30.010248 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2020-11-19 14:37:30.010248 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2020-11-19 14:37:30.030263 [NOTICE] switch_cpp.cpp:1443 [ASTPP] [xml_handler] Params: Event-Name: REQUEST_PARAMS Core-UUID: ab3e105f-e6f4-458f-b102-a4065f4859ae FreeSWITCH-Hostname: soultech FreeSWITCH-Switchname: soultech FreeSWITCH-IPv4: 192.168.8.3 FreeSWITCH-IPv6: %3A%3A1 Event-Date-Local: 2020-11-19%2014%3A37%3A29 Event-Date-GMT: Thu,%2019%20Nov%202020%2013%3A37%3A29%20GMT Event-Date-Timestamp: 1605793049990251 Event-Calling-File: mod_dialplan_xml.c Event-Calling-Function: dialplan_xml_locate Event-Calling-Line-Number: 608 Event-Sequence: 555759 Channel-State: CS_EXECUTE Channel-Call-State: RINGING Channel-State-Number: 4 Channel-Name: sofia/default/8138902220%40192.168.8.6 Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30 Call-Direction: inbound Presence-Call-Direction: inbound Channel-HIT-Dialplan: true Channel-Presence-ID: 8138902220%40192.168.8.6 Channel-Call-UUID: 5c18286f-5ad9-4a3f-a129-a79f09917d30 Answer-State: ringing Channel-Read-Codec-Name: PCMU Channel-Read-Codec-Rate: 8000 Channel-Read-Codec-Bit-Rate: 64000 Channel-Write-Codec-Name: PCMU Channel-Write-Codec-Rate: 8000 Channel-Write-Codec-Bit-Rate: 64000 Caller-Direction: inbound Caller-Logical-Direction: inbound Caller-Username: 8138902220 Caller-Dialplan: XML Caller-Caller-ID-Name: 8138902220 Caller-Caller-ID-Number: 8138902220 Caller-Orig-Caller-ID-Name: 8138902220 Caller-Orig-Caller-ID-Number: 8138902220 Caller-Network-Addr: 192.168.8.6 Caller-ANI: 8138902220 Caller-Destination-Number: 9088999989 Caller-Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30 Caller-Source: mod_sofia Caller-Context: default Caller-Channel-Name: sofia/default/8138902220%40192.168.8.6 Caller-Profile-Index: 1 Caller-Profile-Created-Time: 1605793049910318 Caller-Channel-Created-Time: 1605793049910318 Caller-Channel-Answered-Time: 0 Caller-Channel-Progress-Time: 0 Caller-Channel-Progress-Media-Time: 0 Caller-Channel-Hangup-Time: 0 Caller-Channel-Transfer-Time: 0 Caller-Channel-Resurrect-Time: 0 Caller-Channel-Bridged-Time: 0 Caller-Channel-Last-Hold: 0 Caller-Channel-Hold-Accum: 0 Caller-Screen-Bit: true Caller-Privacy-Hide-Name: false Caller-Privacy-Hide-Number: false variable_direction: inbound variable_uuid: 5c18286f-5ad9-4a3f-a129-a79f09917d30 variable_session_id: 28510 variable_sip_from_user: 8138902220 variable_sip_from_uri: 8138902220%40192.168.8.6 variable_sip_from_host: 192.168.8.6 variable_video_media_flow: disabled variable_text_media_flow: disabled variable_channel_name: sofia/default/8138902220%40192.168.8.6 variable_sip_call_id: a2b73d1d-26d9-4a65-b280-1c62b2d98c30 variable_sip_local_network_addr: 192.168.8.3 variable_sip_network_ip: 192.168.8.6 variable_sip_network_port: 5060 variable_sip_invite_stamp: 1605793049910318 variable_sip_received_ip: 192.168.8.6 variable_sip_received_port: 5060 variable_sip_via_protocol: udp variable_sip_authorized: true variable_sip_acl_authed_by: default variable_sip_from_user_stripped: 8138902220 variable_sip_from_tag: a251beb8-e6dd-4c47-b493-aba69df9be3c variable_sofia_profile_name: default variable_sofia_profile_url: sip%3Amod_sofia%40192.168.8.3%3A5060 variable_recovery_profile_name: default variable_sip_full_via: SIP/2.0/UDP%20192.168.8.6%3A5060%3Brport%3D5060%3Bbranch%3Dz9hG4bKPj3ea88895-62a2-4c68-9a9e-54489e70cdb3 variable_sip_from_display: 8138902220 variable_sip_full_from: %228138902220%22%20%3Csip%3A8138902220%40192.168.8.6%3E%3Btag%3Da251beb8-e6dd-4c47-b493-aba69df9be3c variable_sip_full_to: %3Csip%3A9088999989%40192.168.8.3%3E variable_sip_allow: OPTIONS,%20SUBSCRIBE,%20NOTIFY,%20PUBLISH,%20INVITE,%20ACK,%20BYE,%20CANCEL,%20UPDATE,%20PRACK,%20REGISTER,%20MESSAGE,%20REFER variable_sip_req_user: 9088999989 variable_sip_req_uri: 9088999989%40192.168.8.3 variable_sip_req_host: 192.168.8.3 variable_sip_to_user: 9088999989 variable_sip_to_uri: 9088999989%40192.168.8.3 variable_sip_to_host: 192.168.8.3 variable_sip_contact_user: asterisk variable_sip_contact_port: 5060 variable_sip_contact_uri: asterisk%40192.168.8.6%3A5060 variable_sip_contact_host: 192.168.8.6 variable_sip_user_agent: FPBX-14.0.13.40(13.29.2) variable_sip_via_host: 192.168.8.6 variable_sip_via_port: 5060 variable_sip_via_rport: 5060 variable_max_forwards: 70 variable_presence_id: 8138902220%40192.168.8.6 variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%201054601244%201054601244%20IN%20IP4%20192.168.8.6%0D%0As%3DAsterisk%0D%0Ac%3DIN%20IP4%20192.168.8.6%0D%0At%3D0%200%0D%0Am%3Daudio%2016050%20RTP/AVP%200%208%203%20111%209%20101%0D%0Aa%3Drtpmap%3A0%20PCMU/8000%0D%0Aa%3Drtpmap%3A8%20PCMA/8000%0D%0Aa%3Drtpmap%3A3%20GSM/8000%0D%0Aa%3Drtpmap%3A111%20G726-32/8000%0D%0Aa%3Drtpmap%3A9%20G722/8000%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dfmtp%3A101%200-16%0D%0Aa%3Dptime%3A20%0D%0Aa%3Dmaxptime%3A150%0D%0A variable_ep_codec_string: CORE_PCM_MODULE.PCMU%408000h%4020i%4064000b,CORE_PCM_MODULE.PCMA%408000h%4020i%4064000b variable_rtp_use_codec_string: PCMA,PCMU variable_remote_video_media_flow: inactive variable_remote_text_media_flow: inactive variable_remote_audio_media_flow: sendrecv variable_audio_media_flow: sendrecv variable_remote_media_ip: 192.168.8.6 variable_remote_media_port: 16050 variable_rtp_audio_recv_pt: 0 variable_rtp_use_codec_name: PCMU variable_rtp_use_codec_rate: 8000 variable_rtp_use_codec_ptime: 20 variable_rtp_use_codec_channels: 1 variable_rtp_last_audio_codec_string: PCMU%408000h%4020i%401c variable_read_codec: PCMU variable_original_read_codec: PCMU variable_read_rate: 8000 variable_original_read_rate: 8000 variable_write_codec: PCMU variable_write_rate: 8000 variable_dtmf_type: rfc2833 variable_endpoint_disposition: RECEIVED variable_office_status: open variable_extensions: 6350951709 variable_no_answer_call_type: 11 variable_DP_MATCH: ARRAY%3A%3A9088999989%7C%3A9088999989 variable_call_uuid: 5c18286f-5ad9-4a3f-a129-a79f09917d30 variable_current_application_data: 9088999989_open variable_current_application: execute_extension Hunt-Direction: inbound Hunt-Logical-Direction: inbound Hunt-Username: 8138902220 Hunt-Dialplan: XML Hunt-Caller-ID-Name: 8138902220 Hunt-Caller-ID-Number: 8138902220 Hunt-Orig-Caller-ID-Name: 8138902220 Hunt-Orig-Caller-ID-Number: 8138902220 Hunt-Network-Addr: 192.168.8.6 Hunt-ANI: 8138902220 Hunt-Destination-Number: 9088999989_open Hunt-Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30 Hunt-Source: mod_sofia Hunt-Context: default Hunt-Channel-Name: sofia/default/8138902220%40192.168.8.6 Hunt-Profile-Created-Time: 1605793049910318 Hunt-Channel-Created-Time: 1605793049910318 Hunt-Channel-Answered-Time: 0 Hunt-Channel-Progress-Time: 0 Hunt-Channel-Progress-Media-Time: 0 Hunt-Channel-Hangup-Time: 0 Hunt-Channel-Transfer-Time: 0 Hunt-Channel-Resurrect-Time: 0 Hunt-Channel-Bridged-Time: 0 Hunt-Channel-Last-Hold: 0 Hunt-Channel-Hold-Accum: 0 Hunt-Screen-Bit: true Hunt-Privacy-Hide-Name: false Hunt-Privacy-Hide-Number: false 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] tag_name: 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_value: 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_name: 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] section: dialplan 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] blind_flag: 0 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Dialed number : 9088999989 2020-11-19 14:37:30.030263 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '9088999989' limit 1 2020-11-19 14:37:30.030263 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '9088999989' AND status=0 limit 1 2020-11-19 14:37:30.030263 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '9088999989' and status=0 LIMIT 1 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Caller Id name / number : 8138902220 / 8138902220 2020-11-19 14:37:30.030263 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-11-19 14:37:30.030263 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1 2020-11-19 14:37:30.030263 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9088999989" LIMIT 1 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Call direction : inbound 2020-11-19 14:37:30.030263 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("192.168.8.6") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "9088999989" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [Accountcode : 1135674299] 2020-11-19 14:37:30.030263 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_SPEEDDIAL] Query :SELECT A.number FROM speed_dial as A,accounts as B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.speed_num ="9088999989" AND A.accountid = '123' limit 1 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 9088999989 2020-11-19 14:37:30.050254 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9088999989" LIMIT 1 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] New Call direction : inbound 2020-11-19 14:37:30.050254 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="9088999989" AND (accountid = 0 OR status = 1) LIMIT 1 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] call_direction :inbound 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] DID_ACCOUNTID :138 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE (patterns = '^9088999989.*' OR patterns = '^908899998.*' OR patterns = '^90889999.*' OR patterns = '^9088999.*' OR patterns = '^908899.*' OR patterns = '^90889.*' OR patterns = '^9088.*' OR patterns = '^908.*' OR patterns = '^90.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 138 ORDER BY LENGTH(PKGPTR.patterns) DESC 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '9088999989' OR number = '908899998' OR number = '90889999' OR number = '9088999' OR number = '908899' OR number = '90889' OR number = '9088' OR number = '908' OR number = '90' OR number = '9' OR number ='--') OR (number = '9088999989*' OR number = '908899998*' OR number = '90889999*' OR number = '9088999*' OR number = '908899*' OR number = '90889*' OR number = '9088*' OR number = '908*' OR number = '90*' OR number = '9*' OR number ='--') OR (number = '8138902220' OR number = '813890222' OR number = '81389022' OR number = '8138902' OR number = '813890' OR number = '81389' OR number = '8138' OR number = '813' OR number = '81' OR number = '8' OR number ='--') OR (number = '8138902220*' OR number = '813890222*' OR number = '81389022*' OR number = '8138902*' OR number = '813890*' OR number = '81389*' OR number = '8138*' OR number = '813*' OR number = '81*' OR number = '8*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Call Barring Status : -1 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '9088999989' OR routing_prefix = '908899998' OR routing_prefix = '90889999' OR routing_prefix = '9088999' OR routing_prefix = '908899' OR routing_prefix = '90889' OR routing_prefix = '9088' OR routing_prefix = '908' OR routing_prefix = '90' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] =============== Account Information =================== 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] User id : 123 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Account code : 1135674299 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Balance : 6856.66 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Ratecard id : 1 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] CID Pool : 0 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] ======================================================== 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_RATES] call_direction :inbound 2020-11-19 14:37:30.050254 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9088999989" LIMIT 1 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] call_direction:::::: inbound 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] =============== Rates Information =================== 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] ID : 47 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Connectcost : 0.00000 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Includedseconds : 0 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Cost : 10.00000 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] comment : 9088999989 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Country Id : 141 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Accid : 123 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] ================================================================ 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] [FIND_MAXLENGTH] Your6856.66 balance Accountid 123 !!! 2020-11-19 14:37:30.050254 [NOTICE] switch_cpp.cpp:1443 [ASTPP] [FIND_MAXLENGTH] Limiting call to config max length 100 mins! 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Call Max length duration : 100 minutes 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] INB_FREE:TRUE 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] free_inbound:1 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 123 AND status=0 LIMIT 1 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Actual CustomerInfo XML:123 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Userinfo XML:123 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Actual CustomerInfo XML : 123 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] timecondition_id : 3 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '3' and status =0 LIMIT 1 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] failover_timecondition : [{"extensions":"6350951709","no_answer_call_type":"11"}] 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] timecondition : [{"hour":"00-23","minute":"00-59","wday":"2-2","mday":"1-31","mon":"1-12","year":"2020-2020","extensions":"6350951709","no_answer_call_type":"11","priority":"1"}] 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] failover_timecondition_str : 6350951709 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] priority : 1 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] condition_str : time-of-day= "00:00-23:59" wday= "2-2" mday= "1-31" mon= "1-12" year= "2020-2020" 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] maxlength::::::::: 100 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET domains] Query :SELECT * FROM domains WHERE accountid = 138 limit 1 2020-11-19 14:37:30.070249 [WARNING] switch_cpp.cpp:1443 [ASTPP] [user_domain] user_domaintest446.9mobile.nativetalk.com.ng 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] custom_function_name:::::::::::::::::::::::::custom_inbound_11 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] timecondition_id : 3 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '3' and status =0 LIMIT 1 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] time_condition::::::::::::::::::::::::47 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] custom_function_name::::::::::::::::::::::::47 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Generated XML:
Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->TimeTC] continue=true Dialplan: sofia/default/8138902220@192.168.8.6 Date/Time Match (PASS) [TimeTC] break=never Dialplan: sofia/default/8138902220@192.168.8.6 Action set(office_status=open) INLINE EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 set(office_status=open) 2020-11-19 14:37:30.070249 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [office_status]=[open] Dialplan: sofia/default/8138902220@192.168.8.6 Action set(extensions=6350951709) INLINE EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 set(extensions=6350951709) 2020-11-19 14:37:30.070249 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [extensions]=[6350951709] Dialplan: sofia/default/8138902220@192.168.8.6 Action set(no_answer_call_type=11) INLINE EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 set(no_answer_call_type=11) 2020-11-19 14:37:30.070249 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [no_answer_call_type]=[11] Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->TimeTC] continue=true Dialplan: sofia/default/8138902220@192.168.8.6 Date/TimeMatch (FAIL) [TimeTC] break=never Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->tod route, x9088999989] continue=false Dialplan: sofia/default/8138902220@192.168.8.6 Regex (FAIL) [tod route, x9088999989] destination_number(9088999989_open) =~ /^(9088999989)$/ break=on-false Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->office is open] continue=false Dialplan: sofia/default/8138902220@192.168.8.6 Regex (PASS) [office is open] destination_number(9088999989_open) =~ /^(9088999989_open)$/ break=on-false Dialplan: sofia/default/8138902220@192.168.8.6 Action set(set_extensions=${extensions}) Dialplan: sofia/default/8138902220@192.168.8.6 Action set(no_answer_flag=true) Dialplan: sofia/default/8138902220@192.168.8.6 Action set(no_answer_call_type=${no_answer_call_type}) Dialplan: sofia/default/8138902220@192.168.8.6 Action set(no_answer_number=${extensions}) Dialplan: sofia/default/8138902220@192.168.8.6 Action transfer(138 XML default) 2020-11-19 14:37:30.070249 [NOTICE] switch_core_session.c:3017 Execute [depth=1] set(set_extensions=${extensions}) EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 set(set_extensions=6350951709) 2020-11-19 14:37:30.070249 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [set_extensions]=[6350951709] 2020-11-19 14:37:30.070249 [NOTICE] switch_core_session.c:3017 Execute [depth=1] set(no_answer_flag=true) EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 set(no_answer_flag=true) 2020-11-19 14:37:30.070249 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [no_answer_flag]=[true] 2020-11-19 14:37:30.070249 [NOTICE] switch_core_session.c:3017 Execute [depth=1] set(no_answer_call_type=${no_answer_call_type}) EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 set(no_answer_call_type=11) 2020-11-19 14:37:30.070249 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [no_answer_call_type]=[11] 2020-11-19 14:37:30.070249 [NOTICE] switch_core_session.c:3017 Execute [depth=1] set(no_answer_number=${extensions}) EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 set(no_answer_number=6350951709) 2020-11-19 14:37:30.070249 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [no_answer_number]=[6350951709] 2020-11-19 14:37:30.070249 [NOTICE] switch_core_session.c:3017 Execute [depth=1] transfer(138 XML default) EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 transfer(138 XML default) 2020-11-19 14:37:30.070249 [DEBUG] switch_ivr.c:2231 (sofia/default/8138902220@192.168.8.6) State Change CS_EXECUTE -> CS_ROUTING 2020-11-19 14:37:30.070249 [NOTICE] switch_ivr.c:2238 Transfer sofia/default/8138902220@192.168.8.6 to XML[138@default] 2020-11-19 14:37:30.070249 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE going to sleep 2020-11-19 14:37:30.070249 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_ROUTING (Cur 1 Tot 28510) 2020-11-19 14:37:30.070249 [DEBUG] switch_core_state_machine.c:644 (sofia/default/8138902220@192.168.8.6) State ROUTING 2020-11-19 14:37:30.070249 [DEBUG] mod_sofia.c:145 Call appears to be already acknowledged 2020-11-19 14:37:30.070249 [DEBUG] mod_sofia.c:154 sofia/default/8138902220@192.168.8.6 SOFIA ROUTING 2020-11-19 14:37:30.070249 [DEBUG] switch_core_state_machine.c:236 sofia/default/8138902220@192.168.8.6 Standard ROUTING 2020-11-19 14:37:30.070249 [INFO] mod_dialplan_xml.c:637 Processing 8138902220 <8138902220>->138 in context default 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2020-11-19 14:37:30.090247 [NOTICE] switch_cpp.cpp:1443 [ASTPP] [xml_handler] Params: Event-Name: REQUEST_PARAMS Core-UUID: ab3e105f-e6f4-458f-b102-a4065f4859ae FreeSWITCH-Hostname: soultech FreeSWITCH-Switchname: soultech FreeSWITCH-IPv4: 192.168.8.3 FreeSWITCH-IPv6: %3A%3A1 Event-Date-Local: 2020-11-19%2014%3A37%3A30 Event-Date-GMT: Thu,%2019%20Nov%202020%2013%3A37%3A30%20GMT Event-Date-Timestamp: 1605793050070249 Event-Calling-File: mod_dialplan_xml.c Event-Calling-Function: dialplan_xml_locate Event-Calling-Line-Number: 608 Event-Sequence: 555778 Channel-State: CS_ROUTING Channel-Call-State: RINGING Channel-State-Number: 2 Channel-Name: sofia/default/8138902220%40192.168.8.6 Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30 Call-Direction: inbound Presence-Call-Direction: inbound Channel-HIT-Dialplan: true Channel-Presence-ID: 8138902220%40192.168.8.6 Channel-Call-UUID: 5c18286f-5ad9-4a3f-a129-a79f09917d30 Answer-State: ringing Channel-Read-Codec-Name: PCMU Channel-Read-Codec-Rate: 8000 Channel-Read-Codec-Bit-Rate: 64000 Channel-Write-Codec-Name: PCMU Channel-Write-Codec-Rate: 8000 Channel-Write-Codec-Bit-Rate: 64000 Caller-Direction: inbound Caller-Logical-Direction: inbound Caller-Username: 8138902220 Caller-Dialplan: XML Caller-Caller-ID-Name: 8138902220 Caller-Caller-ID-Number: 8138902220 Caller-Orig-Caller-ID-Name: 8138902220 Caller-Orig-Caller-ID-Number: 8138902220 Caller-Network-Addr: 192.168.8.6 Caller-ANI: 8138902220 Caller-Destination-Number: 138 Caller-Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30 Caller-Source: mod_sofia Caller-Transfer-Source: 1605793050%3A6de6e9a9-e580-433b-a2e6-96b37b72018b%3Abl_xfer%3A138/default/XML Caller-Context: default Caller-RDNIS: 9088999989_open Caller-Channel-Name: sofia/default/8138902220%40192.168.8.6 Caller-Profile-Index: 2 Caller-Profile-Created-Time: 1605793050070249 Caller-Channel-Created-Time: 1605793049910318 Caller-Channel-Answered-Time: 0 Caller-Channel-Progress-Time: 0 Caller-Channel-Progress-Media-Time: 0 Caller-Channel-Hangup-Time: 0 Caller-Channel-Transfer-Time: 0 Caller-Channel-Resurrect-Time: 0 Caller-Channel-Bridged-Time: 0 Caller-Channel-Last-Hold: 0 Caller-Channel-Hold-Accum: 0 Caller-Screen-Bit: true Caller-Privacy-Hide-Name: false Caller-Privacy-Hide-Number: false variable_direction: inbound variable_uuid: 5c18286f-5ad9-4a3f-a129-a79f09917d30 variable_session_id: 28510 variable_sip_from_user: 8138902220 variable_sip_from_uri: 8138902220%40192.168.8.6 variable_sip_from_host: 192.168.8.6 variable_video_media_flow: disabled variable_text_media_flow: disabled variable_channel_name: sofia/default/8138902220%40192.168.8.6 variable_sip_call_id: a2b73d1d-26d9-4a65-b280-1c62b2d98c30 variable_sip_local_network_addr: 192.168.8.3 variable_sip_network_ip: 192.168.8.6 variable_sip_network_port: 5060 variable_sip_invite_stamp: 1605793049910318 variable_sip_received_ip: 192.168.8.6 variable_sip_received_port: 5060 variable_sip_via_protocol: udp variable_sip_authorized: true variable_sip_acl_authed_by: default variable_sip_from_user_stripped: 8138902220 variable_sip_from_tag: a251beb8-e6dd-4c47-b493-aba69df9be3c variable_sofia_profile_name: default variable_sofia_profile_url: sip%3Amod_sofia%40192.168.8.3%3A5060 variable_recovery_profile_name: default variable_sip_full_via: SIP/2.0/UDP%20192.168.8.6%3A5060%3Brport%3D5060%3Bbranch%3Dz9hG4bKPj3ea88895-62a2-4c68-9a9e-54489e70cdb3 variable_sip_from_display: 8138902220 variable_sip_full_from: %228138902220%22%20%3Csip%3A8138902220%40192.168.8.6%3E%3Btag%3Da251beb8-e6dd-4c47-b493-aba69df9be3c variable_sip_full_to: %3Csip%3A9088999989%40192.168.8.3%3E variable_sip_allow: OPTIONS,%20SUBSCRIBE,%20NOTIFY,%20PUBLISH,%20INVITE,%20ACK,%20BYE,%20CANCEL,%20UPDATE,%20PRACK,%20REGISTER,%20MESSAGE,%20REFER variable_sip_req_user: 9088999989 variable_sip_req_uri: 9088999989%40192.168.8.3 variable_sip_req_host: 192.168.8.3 variable_sip_to_user: 9088999989 variable_sip_to_uri: 9088999989%40192.168.8.3 variable_sip_to_host: 192.168.8.3 variable_sip_contact_user: asterisk variable_sip_contact_port: 5060 variable_sip_contact_uri: asterisk%40192.168.8.6%3A5060 variable_sip_contact_host: 192.168.8.6 variable_sip_user_agent: FPBX-14.0.13.40(13.29.2) variable_sip_via_host: 192.168.8.6 variable_sip_via_port: 5060 variable_sip_via_rport: 5060 variable_presence_id: 8138902220%40192.168.8.6 variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%201054601244%201054601244%20IN%20IP4%20192.168.8.6%0D%0As%3DAsterisk%0D%0Ac%3DIN%20IP4%20192.168.8.6%0D%0At%3D0%200%0D%0Am%3Daudio%2016050%20RTP/AVP%200%208%203%20111%209%20101%0D%0Aa%3Drtpmap%3A0%20PCMU/8000%0D%0Aa%3Drtpmap%3A8%20PCMA/8000%0D%0Aa%3Drtpmap%3A3%20GSM/8000%0D%0Aa%3Drtpmap%3A111%20G726-32/8000%0D%0Aa%3Drtpmap%3A9%20G722/8000%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dfmtp%3A101%200-16%0D%0Aa%3Dptime%3A20%0D%0Aa%3Dmaxptime%3A150%0D%0A variable_ep_codec_string: CORE_PCM_MODULE.PCMU%408000h%4020i%4064000b,CORE_PCM_MODULE.PCMA%408000h%4020i%4064000b variable_rtp_use_codec_string: PCMA,PCMU variable_remote_video_media_flow: inactive variable_remote_text_media_flow: inactive variable_remote_audio_media_flow: sendrecv variable_audio_media_flow: sendrecv variable_remote_media_ip: 192.168.8.6 variable_remote_media_port: 16050 variable_rtp_audio_recv_pt: 0 variable_rtp_use_codec_name: PCMU variable_rtp_use_codec_rate: 8000 variable_rtp_use_codec_ptime: 20 variable_rtp_use_codec_channels: 1 variable_rtp_last_audio_codec_string: PCMU%408000h%4020i%401c variable_read_codec: PCMU variable_original_read_codec: PCMU variable_read_rate: 8000 variable_original_read_rate: 8000 variable_write_codec: PCMU variable_write_rate: 8000 variable_dtmf_type: rfc2833 variable_endpoint_disposition: RECEIVED variable_office_status: open variable_extensions: 6350951709 variable_DP_MATCH: ARRAY%3A%3A9088999989_open%7C%3A9088999989_open variable_set_extensions: 6350951709 variable_no_answer_flag: true variable_no_answer_call_type: 11 variable_no_answer_number: 6350951709 variable_current_application_data: 138%20XML%20default variable_current_application: transfer variable_max_forwards: 69 variable_transfer_history: 1605793050%3A6de6e9a9-e580-433b-a2e6-96b37b72018b%3Abl_xfer%3A138/default/XML variable_transfer_source: 1605793050%3A6de6e9a9-e580-433b-a2e6-96b37b72018b%3Abl_xfer%3A138/default/XML variable_call_uuid: 5c18286f-5ad9-4a3f-a129-a79f09917d30 Hunt-Direction: inbound Hunt-Logical-Direction: inbound Hunt-Username: 8138902220 Hunt-Dialplan: XML Hunt-Caller-ID-Name: 8138902220 Hunt-Caller-ID-Number: 8138902220 Hunt-Orig-Caller-ID-Name: 8138902220 Hunt-Orig-Caller-ID-Number: 8138902220 Hunt-Network-Addr: 192.168.8.6 Hunt-ANI: 8138902220 Hunt-Destination-Number: 138 Hunt-Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30 Hunt-Source: mod_sofia Hunt-Transfer-Source: 1605793050%3A6de6e9a9-e580-433b-a2e6-96b37b72018b%3Abl_xfer%3A138/default/XML Hunt-Context: default Hunt-RDNIS: 9088999989_open Hunt-Channel-Name: sofia/default/8138902220%40192.168.8.6 Hunt-Profile-Index: 2 Hunt-Profile-Created-Time: 1605793050070249 Hunt-Channel-Created-Time: 1605793049910318 Hunt-Channel-Answered-Time: 0 Hunt-Channel-Progress-Time: 0 Hunt-Channel-Progress-Media-Time: 0 Hunt-Channel-Hangup-Time: 0 Hunt-Channel-Transfer-Time: 0 Hunt-Channel-Resurrect-Time: 0 Hunt-Channel-Bridged-Time: 0 Hunt-Channel-Last-Hold: 0 Hunt-Channel-Hold-Accum: 0 Hunt-Screen-Bit: true Hunt-Privacy-Hide-Name: false Hunt-Privacy-Hide-Number: false 2020-11-19 14:37:30.090247 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] tag_name: 2020-11-19 14:37:30.090247 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_name: 2020-11-19 14:37:30.090247 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] section: dialplan 2020-11-19 14:37:30.090247 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_value: 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] blind_flag: 0 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Dialed number : 138 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '138' limit 1 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '138' AND status=0 limit 1 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '138' and status=0 LIMIT 1 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Caller Id name / number : 8138902220 / 8138902220 2020-11-19 14:37:30.110327 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="138" LIMIT 1 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="138" AND domains.domain="192.168.8.3" limit 1 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Call direction : outbound 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("192.168.8.6") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "138" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [Accountcode : 1135674299] 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^138.*' OR blocked_patterns = '^13.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 123 limit 1 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_SPEEDDIAL] Query :SELECT A.number FROM speed_dial as A,accounts as B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.speed_num ="138" AND A.accountid = '123' limit 1 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 138 2020-11-19 14:37:30.110327 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="138" LIMIT 1 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="138" AND domains.domain="192.168.8.3" limit 1 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] New Call direction : outbound 2020-11-19 14:37:30.110327 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="138" AND (accountid = 0 OR status = 1) LIMIT 1 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET domains] Query :SELECT * FROM domains WHERE accountid = 138 limit 1 2020-11-19 14:37:30.110327 [WARNING] switch_cpp.cpp:1443 [ASTPP] [user_domain] user_domaintest446.9mobile.nativetalk.com.ng 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^138.*' OR blocked_patterns = '^13.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 138 limit 1 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Generated ringgroup_no_answer_forward:138 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [PBX] call_type : 11 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Generated XML:
Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->138] continue=false Dialplan: sofia/default/8138902220@192.168.8.6 Regex (PASS) [138] destination_number(138) =~ /138/ break=on-false Dialplan: sofia/default/8138902220@192.168.8.6 Action export(bypass_media=true) Dialplan: sofia/default/8138902220@192.168.8.6 Action export(did_user_domain=test446.9mobile.nativetalk.com.ng) Dialplan: sofia/default/8138902220@192.168.8.6 Action set(continue_on_fail=TRUE) Dialplan: sofia/default/8138902220@192.168.8.6 Action set(ignore_early_media=true) Dialplan: sofia/default/8138902220@192.168.8.6 Action set(no_answer_flag=false) Dialplan: sofia/default/8138902220@192.168.8.6 Action set(did_calltype=11) Dialplan: sofia/default/8138902220@192.168.8.6 Action set(did_extensions=6350951709) Dialplan: sofia/default/8138902220@192.168.8.6 Action bridge(user/6350951709@test446.9mobile.nativetalk.com.ng) 2020-11-19 14:37:30.110327 [DEBUG] switch_core_state_machine.c:287 (sofia/default/8138902220@192.168.8.6) State Change CS_ROUTING -> CS_EXECUTE 2020-11-19 14:37:30.110327 [DEBUG] switch_core_state_machine.c:644 (sofia/default/8138902220@192.168.8.6) State ROUTING going to sleep 2020-11-19 14:37:30.110327 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_EXECUTE (Cur 1 Tot 28510) 2020-11-19 14:37:30.110327 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE 2020-11-19 14:37:30.110327 [DEBUG] mod_sofia.c:209 sofia/default/8138902220@192.168.8.6 SOFIA EXECUTE 2020-11-19 14:37:30.110327 [DEBUG] switch_core_state_machine.c:329 sofia/default/8138902220@192.168.8.6 Standard EXECUTE EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 export(bypass_media=true) 2020-11-19 14:37:30.110327 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [bypass_media]=[true] EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 export(did_user_domain=test446.9mobile.nativetalk.com.ng) 2020-11-19 14:37:30.110327 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [did_user_domain]=[test446.9mobile.nativetalk.com.ng] EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(continue_on_fail=TRUE) 2020-11-19 14:37:30.110327 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [continue_on_fail]=[TRUE] EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(ignore_early_media=true) 2020-11-19 14:37:30.110327 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [ignore_early_media]=[true] EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(no_answer_flag=false) 2020-11-19 14:37:30.110327 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [no_answer_flag]=[false] EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(did_calltype=11) 2020-11-19 14:37:30.110327 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [did_calltype]=[11] EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(did_extensions=6350951709) 2020-11-19 14:37:30.110327 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [did_extensions]=[6350951709] EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 bridge(user/6350951709@test446.9mobile.nativetalk.com.ng) 2020-11-19 14:37:30.110327 [DEBUG] switch_channel.c:1264 sofia/default/8138902220@192.168.8.6 EXPORTING[export_vars] [bypass_media]=[true] to event 2020-11-19 14:37:30.110327 [DEBUG] switch_channel.c:1264 sofia/default/8138902220@192.168.8.6 EXPORTING[export_vars] [did_user_domain]=[test446.9mobile.nativetalk.com.ng] to event 2020-11-19 14:37:30.110327 [DEBUG] switch_ivr_originate.c:2212 Parsing global variables 2020-11-19 14:37:30.150253 [DEBUG] switch_channel.c:1264 sofia/default/8138902220@192.168.8.6 EXPORTING[export_vars] [bypass_media]=[true] to event 2020-11-19 14:37:30.150253 [DEBUG] switch_channel.c:1264 sofia/default/8138902220@192.168.8.6 EXPORTING[export_vars] [did_user_domain]=[test446.9mobile.nativetalk.com.ng] to event 2020-11-19 14:37:30.150253 [DEBUG] switch_ivr_originate.c:2212 Parsing global variables 2020-11-19 14:37:30.150253 [NOTICE] switch_channel.c:1118 New Channel sofia/default/6350951709@197.156.235.60:39572 [1357859f-1159-4416-8535-ecfdb786db2c] 2020-11-19 14:37:30.150253 [DEBUG] mod_sofia.c:5096 (sofia/default/6350951709@197.156.235.60:39572) State Change CS_NEW -> CS_INIT 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:585 (sofia/default/6350951709@197.156.235.60:39572) Running State Change CS_INIT (Cur 2 Tot 28511) 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:628 (sofia/default/6350951709@197.156.235.60:39572) State INIT 2020-11-19 14:37:30.150253 [DEBUG] mod_sofia.c:93 sofia/default/6350951709@197.156.235.60:39572 SOFIA INIT 2020-11-19 14:37:30.150253 [DEBUG] sofia_glue.c:1618 sofia/default/6350951709@197.156.235.60:39572 sending invite version: 1.10.1 -release-12-f9990221e6 64bit Local SDP: v=0 o=- 1054601244 1054601244 IN IP4 192.168.8.6 s=Asterisk c=IN IP4 192.168.8.6 t=0 0 m=audio 16050 RTP/AVP 0 8 3 111 9 101 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:3 GSM/8000 a=rtpmap:111 G726-32/8000 a=rtpmap:9 G722/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=ptime:20 a=maxptime:150 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:40 sofia/default/6350951709@197.156.235.60:39572 Standard INIT 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:48 (sofia/default/6350951709@197.156.235.60:39572) State Change CS_INIT -> CS_ROUTING 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:628 (sofia/default/6350951709@197.156.235.60:39572) State INIT going to sleep 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:585 (sofia/default/6350951709@197.156.235.60:39572) Running State Change CS_ROUTING (Cur 2 Tot 28511) 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:644 (sofia/default/6350951709@197.156.235.60:39572) State ROUTING 2020-11-19 14:37:30.150253 [DEBUG] mod_sofia.c:154 sofia/default/6350951709@197.156.235.60:39572 SOFIA ROUTING 2020-11-19 14:37:30.150253 [DEBUG] switch_ivr_originate.c:67 (sofia/default/6350951709@197.156.235.60:39572) State Change CS_ROUTING -> CS_CONSUME_MEDIA 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:644 (sofia/default/6350951709@197.156.235.60:39572) State ROUTING going to sleep 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:585 (sofia/default/6350951709@197.156.235.60:39572) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 28511) 2020-11-19 14:37:30.150253 [DEBUG] sofia.c:7290 Channel sofia/default/6350951709@197.156.235.60:39572 entering state [calling][0] 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:663 (sofia/default/6350951709@197.156.235.60:39572) State CONSUME_MEDIA 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:663 (sofia/default/6350951709@197.156.235.60:39572) State CONSUME_MEDIA going to sleep 2020-11-19 14:37:30.650250 [DEBUG] sofia.c:7290 Channel sofia/default/6350951709@197.156.235.60:39572 entering state [proceeding][180] 2020-11-19 14:37:30.650250 [NOTICE] sofia.c:7401 Ring-Ready sofia/default/6350951709@197.156.235.60:39572! 2020-11-19 14:37:30.650250 [DEBUG] switch_channel.c:3437 (sofia/default/6350951709@197.156.235.60:39572) Callstate Change DOWN -> RINGING 2020-11-19 14:37:30.650250 [NOTICE] mod_sofia.c:2505 Ring-Ready sofia/default/8138902220@192.168.8.6! 2020-11-19 14:37:30.650250 [DEBUG] sofia.c:7290 Channel sofia/default/8138902220@192.168.8.6 entering state [early][180] 2020-11-19 14:37:30.650250 [NOTICE] switch_ivr_originate.c:553 Ring Ready sofia/default/8138902220@192.168.8.6! 2020-11-19 14:37:38.190317 [DEBUG] sofia.c:7290 Channel sofia/default/6350951709@197.156.235.60:39572 entering state [completing][200] 2020-11-19 14:37:38.190317 [DEBUG] sofia.c:7300 Remote SDP: v=0 o=- 8 2 IN IP4 197.156.235.60 s=CounterPath eyeBeam 1.5 c=IN IP4 197.156.235.60 t=0 0 m=audio 26728 RTP/AVP 0 8 101 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-15 2020-11-19 14:37:38.190317 [DEBUG] sofia.c:7290 Channel sofia/default/6350951709@197.156.235.60:39572 entering state [ready][200] 2020-11-19 14:37:38.190317 [NOTICE] sofia.c:8430 Channel [sofia/default/6350951709@197.156.235.60:39572] has been answered 2020-11-19 14:37:38.190317 [DEBUG] switch_channel.c:3865 (sofia/default/6350951709@197.156.235.60:39572) Callstate Change RINGING -> ACTIVE 2020-11-19 14:37:38.190317 [DEBUG] switch_ivr_originate.c:3806 Originate Resulted in Success: [sofia/default/6350951709@197.156.235.60:39572] 2020-11-19 14:37:38.190317 [NOTICE] switch_ivr.c:820 Channel [sofia/default/8138902220@192.168.8.6] has been answered 2020-11-19 14:37:38.190317 [DEBUG] switch_channel.c:3865 (sofia/default/8138902220@192.168.8.6) Callstate Change RINGING -> ACTIVE 2020-11-19 14:37:38.190317 [DEBUG] sofia.c:7290 Channel sofia/default/8138902220@192.168.8.6 entering state [completed][200] 2020-11-19 14:37:38.190317 [DEBUG] sofia.c:7290 Channel sofia/default/8138902220@192.168.8.6 entering state [ready][200] 2020-11-19 14:37:38.190317 [DEBUG] switch_ivr_originate.c:3806 Originate Resulted in Success: [sofia/default/6350951709@197.156.235.60:39572] 2020-11-19 14:37:38.190317 [DEBUG] switch_ivr_bridge.c:1590 (sofia/default/8138902220@192.168.8.6) State Change CS_EXECUTE -> CS_HIBERNATE 2020-11-19 14:37:38.190317 [DEBUG] switch_ivr_bridge.c:1591 (sofia/default/6350951709@197.156.235.60:39572) State Change CS_CONSUME_MEDIA -> CS_HIBERNATE 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE going to sleep 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:585 (sofia/default/6350951709@197.156.235.60:39572) Running State Change CS_HIBERNATE (Cur 2 Tot 28511) 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_HIBERNATE (Cur 2 Tot 28511) 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:666 (sofia/default/6350951709@197.156.235.60:39572) State HIBERNATE 2020-11-19 14:37:38.190317 [DEBUG] mod_sofia.c:191 sofia/default/6350951709@197.156.235.60:39572 SOFIA HIBERNATE 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:421 sofia/default/6350951709@197.156.235.60:39572 Standard HIBERNATE 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:666 (sofia/default/6350951709@197.156.235.60:39572) State HIBERNATE going to sleep 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:666 (sofia/default/8138902220@192.168.8.6) State HIBERNATE 2020-11-19 14:37:38.190317 [DEBUG] mod_sofia.c:191 sofia/default/8138902220@192.168.8.6 SOFIA HIBERNATE 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:421 sofia/default/8138902220@192.168.8.6 Standard HIBERNATE 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:666 (sofia/default/8138902220@192.168.8.6) State HIBERNATE going to sleep 2020-11-19 14:37:43.410316 [NOTICE] sofia.c:1084 Hangup sofia/default/6350951709@197.156.235.60:39572 [CS_HIBERNATE] [NORMAL_CLEARING] 2020-11-19 14:37:43.410316 [DEBUG] switch_ivr_bridge.c:1337 sofia/default/6350951709@197.156.235.60:39572 skip receive message [UNBRIDGE] (channel is hungup already) 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:585 (sofia/default/6350951709@197.156.235.60:39572) Running State Change CS_HANGUP (Cur 2 Tot 28511) 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:848 (sofia/default/6350951709@197.156.235.60:39572) Callstate Change ACTIVE -> HANGUP 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:850 (sofia/default/6350951709@197.156.235.60:39572) State HANGUP 2020-11-19 14:37:43.410316 [DEBUG] mod_sofia.c:460 Channel sofia/default/6350951709@197.156.235.60:39572 hanging up, cause: NORMAL_CLEARING 2020-11-19 14:37:43.410316 [DEBUG] switch_ivr_bridge.c:1473 (sofia/default/8138902220@192.168.8.6) State Change CS_HIBERNATE -> CS_EXECUTE 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_EXECUTE (Cur 2 Tot 28511) 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:60 sofia/default/6350951709@197.156.235.60:39572 Standard HANGUP, cause: NORMAL_CLEARING 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:850 (sofia/default/6350951709@197.156.235.60:39572) State HANGUP going to sleep 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:620 (sofia/default/6350951709@197.156.235.60:39572) State Change CS_HANGUP -> CS_REPORTING 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE 2020-11-19 14:37:43.410316 [DEBUG] mod_sofia.c:209 sofia/default/8138902220@192.168.8.6 SOFIA EXECUTE 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:329 sofia/default/8138902220@192.168.8.6 Standard EXECUTE 2020-11-19 14:37:43.410316 [NOTICE] switch_core_state_machine.c:386 sofia/default/8138902220@192.168.8.6 has executed the last dialplan instruction, hanging up. 2020-11-19 14:37:43.410316 [NOTICE] switch_core_state_machine.c:388 Hangup sofia/default/8138902220@192.168.8.6 [CS_EXECUTE] [NORMAL_CLEARING] 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:585 (sofia/default/6350951709@197.156.235.60:39572) Running State Change CS_REPORTING (Cur 2 Tot 28511) 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:936 (sofia/default/6350951709@197.156.235.60:39572) State REPORTING 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE going to sleep 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_HANGUP (Cur 2 Tot 28511) 2020-11-19 14:37:43.410316 [INFO] mod_json_cdr.c:271 Process [1357859f-1159-4416-8535-ecfdb786db2c.cdr.json] 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:848 (sofia/default/8138902220@192.168.8.6) Callstate Change ACTIVE -> HANGUP 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:850 (sofia/default/8138902220@192.168.8.6) State HANGUP 2020-11-19 14:37:43.410316 [DEBUG] mod_sofia.c:454 sofia/default/8138902220@192.168.8.6 Overriding SIP cause 480 with 200 from the other leg 2020-11-19 14:37:43.410316 [DEBUG] mod_sofia.c:460 Channel sofia/default/8138902220@192.168.8.6 hanging up, cause: NORMAL_CLEARING 2020-11-19 14:37:43.410316 [DEBUG] mod_sofia.c:514 Sending BYE to sofia/default/8138902220@192.168.8.6 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:60 sofia/default/8138902220@192.168.8.6 Standard HANGUP, cause: NORMAL_CLEARING 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:850 (sofia/default/8138902220@192.168.8.6) State HANGUP going to sleep 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:620 (sofia/default/8138902220@192.168.8.6) State Change CS_HANGUP -> CS_REPORTING 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_REPORTING (Cur 2 Tot 28511) 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:936 (sofia/default/8138902220@192.168.8.6) State REPORTING 2020-11-19 14:37:43.410316 [INFO] mod_json_cdr.c:271 Process [5c18286f-5ad9-4a3f-a129-a79f09917d30.cdr.json] 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:174 sofia/default/6350951709@197.156.235.60:39572 Standard REPORTING, cause: NORMAL_CLEARING 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:936 (sofia/default/6350951709@197.156.235.60:39572) State REPORTING going to sleep 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:611 (sofia/default/6350951709@197.156.235.60:39572) State Change CS_REPORTING -> CS_DESTROY 2020-11-19 14:37:43.410316 [DEBUG] switch_core_session.c:1726 Session 28511 (sofia/default/6350951709@197.156.235.60:39572) Locked, Waiting on external entities 2020-11-19 14:37:43.410316 [NOTICE] switch_core_session.c:1744 Session 28511 (sofia/default/6350951709@197.156.235.60:39572) Ended 2020-11-19 14:37:43.410316 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/6350951709@197.156.235.60:39572 [CS_DESTROY] 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:739 (sofia/default/6350951709@197.156.235.60:39572) Running State Change CS_DESTROY (Cur 1 Tot 28511) 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:749 (sofia/default/6350951709@197.156.235.60:39572) State DESTROY 2020-11-19 14:37:43.410316 [DEBUG] mod_sofia.c:365 sofia/default/6350951709@197.156.235.60:39572 SOFIA DESTROY 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:181 sofia/default/6350951709@197.156.235.60:39572 Standard DESTROY 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:749 (sofia/default/6350951709@197.156.235.60:39572) State DESTROY going to sleep 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:174 sofia/default/8138902220@192.168.8.6 Standard REPORTING, cause: NORMAL_CLEARING 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:936 (sofia/default/8138902220@192.168.8.6) State REPORTING going to sleep 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:611 (sofia/default/8138902220@192.168.8.6) State Change CS_REPORTING -> CS_DESTROY 2020-11-19 14:37:43.410316 [DEBUG] switch_core_session.c:1726 Session 28510 (sofia/default/8138902220@192.168.8.6) Locked, Waiting on external entities 2020-11-19 14:37:43.410316 [NOTICE] switch_core_session.c:1744 Session 28510 (sofia/default/8138902220@192.168.8.6) Ended 2020-11-19 14:37:43.410316 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/8138902220@192.168.8.6 [CS_DESTROY] 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:739 (sofia/default/8138902220@192.168.8.6) Running State Change CS_DESTROY (Cur 0 Tot 28511) 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:749 (sofia/default/8138902220@192.168.8.6) State DESTROY 2020-11-19 14:37:43.410316 [DEBUG] mod_sofia.c:365 sofia/default/8138902220@192.168.8.6 SOFIA DESTROY 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:181 sofia/default/8138902220@192.168.8.6 Standard DESTROY 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:749 (sofia/default/8138902220@192.168.8.6) State DESTROY going to sleep 2020-11-19 14:41:21.270318 [NOTICE] switch_channel.c:1118 New Channel sofia/default/200@41.190.24.110 [6441c73a-6690-4d21-99a6-030e4e0fd66a] 2020-11-19 14:41:21.270318 [DEBUG] switch_core_state_machine.c:585 (sofia/default/200@41.190.24.110) Running State Change CS_NEW (Cur 1 Tot 28512) 2020-11-19 14:41:21.270318 [DEBUG] sofia.c:10243 sofia/default/200@41.190.24.110 receiving invite from 156.96.150.42:60515 version: 1.10.1 -release-12-f9990221e6 64bit 2020-11-19 14:41:21.270318 [DEBUG] sofia.c:10337 verifying acl "default" for ip/port 156.96.150.42:0. 2020-11-19 14:41:21.270318 [WARNING] sofia_reg.c:1793 SIP auth challenge (INVITE) on sofia profile 'default' for [900442037690895@41.190.24.110] from ip 156.96.150.42 2020-11-19 14:41:21.270318 [DEBUG] switch_core_state_machine.c:604 (sofia/default/200@41.190.24.110) State NEW 2020-11-19 14:41:21.270318 [DEBUG] sofia.c:2426 detaching session 6441c73a-6690-4d21-99a6-030e4e0fd66a 2020-11-19 14:41:31.330308 [WARNING] switch_core_state_machine.c:688 6441c73a-6690-4d21-99a6-030e4e0fd66a sofia/default/200@41.190.24.110 Abandoned 2020-11-19 14:41:31.330308 [NOTICE] switch_core_state_machine.c:691 Hangup sofia/default/200@41.190.24.110 [CS_NEW] [WRONG_CALL_STATE] 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:585 (sofia/default/200@41.190.24.110) Running State Change CS_HANGUP (Cur 1 Tot 28512) 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:848 (sofia/default/200@41.190.24.110) Callstate Change DOWN -> HANGUP 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:850 (sofia/default/200@41.190.24.110) State HANGUP 2020-11-19 14:41:31.330308 [DEBUG] mod_sofia.c:460 Channel sofia/default/200@41.190.24.110 hanging up, cause: WRONG_CALL_STATE 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:60 sofia/default/200@41.190.24.110 Standard HANGUP, cause: WRONG_CALL_STATE 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:850 (sofia/default/200@41.190.24.110) State HANGUP going to sleep 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:620 (sofia/default/200@41.190.24.110) State Change CS_HANGUP -> CS_REPORTING 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:585 (sofia/default/200@41.190.24.110) Running State Change CS_REPORTING (Cur 1 Tot 28512) 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:936 (sofia/default/200@41.190.24.110) State REPORTING 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:174 sofia/default/200@41.190.24.110 Standard REPORTING, cause: WRONG_CALL_STATE 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:936 (sofia/default/200@41.190.24.110) State REPORTING going to sleep 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:611 (sofia/default/200@41.190.24.110) State Change CS_REPORTING -> CS_DESTROY 2020-11-19 14:41:31.330308 [DEBUG] switch_core_session.c:1726 Session 28512 (sofia/default/200@41.190.24.110) Locked, Waiting on external entities 2020-11-19 14:41:31.330308 [NOTICE] switch_core_session.c:1744 Session 28512 (sofia/default/200@41.190.24.110) Ended 2020-11-19 14:41:31.330308 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/200@41.190.24.110 [CS_DESTROY] 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:739 (sofia/default/200@41.190.24.110) Running State Change CS_DESTROY (Cur 0 Tot 28512) 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:749 (sofia/default/200@41.190.24.110) State DESTROY 2020-11-19 14:41:31.330308 [DEBUG] mod_sofia.c:365 sofia/default/200@41.190.24.110 SOFIA DESTROY 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:181 sofia/default/200@41.190.24.110 Standard DESTROY 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:749 (sofia/default/200@41.190.24.110) State DESTROY going to sleep