2020-10-27 11:23:17.765810 [WARNING] switch_core_file.c:410 File has 2 channels, muxing to 1 channel will occur. 2020-10-27 11:23:25.485807 [WARNING] switch_core_file.c:410 File has 2 channels, muxing to 1 channel will occur. 2020-10-27 11:23:32.185821 [WARNING] switch_core_file.c:410 File has 2 channels, muxing to 1 channel will occur. 2020-10-27 11:23:41.925812 [WARNING] switch_core_file.c:410 File has 2 channels, muxing to 1 channel will occur. 2020-10-27 11:23:47.665809 [NOTICE] switch_channel.c:1118 New Channel sofia/default/018888388@192.168.8.6 [bc6ca164-db08-42c8-895e-df1d47d4fd44] 2020-10-27 11:23:47.665809 [DEBUG] switch_core_state_machine.c:585 (sofia/default/018888388@192.168.8.6) Running State Change CS_NEW (Cur 1 Tot 8860) 2020-10-27 11:23:47.665809 [DEBUG] sofia.c:10243 sofia/default/018888388@192.168.8.6 receiving invite from 192.168.8.6:5060 version: 1.10.1 -release-12-f9990221e6 64bit 2020-10-27 11:23:47.665809 [DEBUG] sofia.c:10337 verifying acl "default" for ip/port 192.168.8.6:0. 2020-10-27 11:23:47.665809 [DEBUG] sofia.c:10366 IP 192.168.8.6 Approved by acl "default[]". Access Granted. 2020-10-27 11:23:47.665809 [DEBUG] sofia.c:7290 Channel sofia/default/018888388@192.168.8.6 entering state [received][100] 2020-10-27 11:23:47.665809 [DEBUG] sofia.c:7300 Remote SDP: v=0 o=- 1083192432 1083192432 IN IP4 192.168.8.6 s=Asterisk c=IN IP4 192.168.8.6 t=0 0 m=audio 18272 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-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2020-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2020-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:5645 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2020-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2020-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:5645 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2020-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2020-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1] 2020-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1] 2020-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [G726-32:111:8000:20:0:1]/[PCMA:8:8000:20:64000:1] 2020-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [G726-32:111:8000:20:0:1]/[PCMU:0:8000:20:64000:1] 2020-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2020-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2020-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:5506 Set telephone-event payload to 101@8000 2020-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:3834 Set Codec sofia/default/018888388@192.168.8.6 PCMU/8000 20 ms 160 samples 64000 bits 1 channels 2020-10-27 11:23:47.665809 [DEBUG] switch_core_codec.c:111 sofia/default/018888388@192.168.8.6 Original read codec set to PCMU:0 2020-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:5849 Set telephone-event payload to 101@8000 2020-10-27 11:23:47.665809 [DEBUG] switch_core_media.c:5907 sofia/default/018888388@192.168.8.6 Set 2833 dtmf send payload to 101 recv payload to 101 2020-10-27 11:23:47.665809 [DEBUG] sofia.c:7724 (sofia/default/018888388@192.168.8.6) State Change CS_NEW -> CS_INIT 2020-10-27 11:23:47.665809 [DEBUG] switch_core_state_machine.c:604 (sofia/default/018888388@192.168.8.6) State NEW 2020-10-27 11:23:47.665809 [DEBUG] switch_core_state_machine.c:585 (sofia/default/018888388@192.168.8.6) Running State Change CS_INIT (Cur 1 Tot 8860) 2020-10-27 11:23:47.665809 [DEBUG] switch_core_state_machine.c:628 (sofia/default/018888388@192.168.8.6) State INIT 2020-10-27 11:23:47.665809 [DEBUG] mod_sofia.c:93 sofia/default/018888388@192.168.8.6 SOFIA INIT 2020-10-27 11:23:47.665809 [DEBUG] switch_core_state_machine.c:40 sofia/default/018888388@192.168.8.6 Standard INIT 2020-10-27 11:23:47.665809 [DEBUG] switch_core_state_machine.c:48 (sofia/default/018888388@192.168.8.6) State Change CS_INIT -> CS_ROUTING 2020-10-27 11:23:47.665809 [DEBUG] switch_core_state_machine.c:628 (sofia/default/018888388@192.168.8.6) State INIT going to sleep 2020-10-27 11:23:47.665809 [DEBUG] switch_core_state_machine.c:585 (sofia/default/018888388@192.168.8.6) Running State Change CS_ROUTING (Cur 1 Tot 8860) 2020-10-27 11:23:47.665809 [DEBUG] switch_channel.c:2332 (sofia/default/018888388@192.168.8.6) Callstate Change DOWN -> RINGING 2020-10-27 11:23:47.665809 [DEBUG] switch_core_state_machine.c:644 (sofia/default/018888388@192.168.8.6) State ROUTING 2020-10-27 11:23:47.665809 [DEBUG] mod_sofia.c:154 sofia/default/018888388@192.168.8.6 SOFIA ROUTING 2020-10-27 11:23:47.665809 [DEBUG] switch_core_state_machine.c:236 sofia/default/018888388@192.168.8.6 Standard ROUTING 2020-10-27 11:23:47.665809 [INFO] mod_dialplan_xml.c:637 Processing 018888388 <018888388>->9088999989 in context default 2020-10-27 11:23:47.685813 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2020-10-27 11:23:47.685813 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2020-10-27 11:23:47.745817 [NOTICE] switch_cpp.cpp:1443 [ASTPP] [xml_handler] Params: Event-Name: REQUEST_PARAMS Core-UUID: f0e00936-3fce-4a2b-af76-c25556ae0e1a FreeSWITCH-Hostname: soultech FreeSWITCH-Switchname: soultech FreeSWITCH-IPv4: 192.168.8.3 FreeSWITCH-IPv6: %3A%3A1 Event-Date-Local: 2020-10-27%2011%3A23%3A47 Event-Date-GMT: Tue,%2027%20Oct%202020%2010%3A23%3A47%20GMT Event-Date-Timestamp: 1603794227665809 Event-Calling-File: mod_dialplan_xml.c Event-Calling-Function: dialplan_xml_locate Event-Calling-Line-Number: 608 Event-Sequence: 453422 Channel-State: CS_ROUTING Channel-Call-State: RINGING Channel-State-Number: 2 Channel-Name: sofia/default/018888388%40192.168.8.6 Unique-ID: bc6ca164-db08-42c8-895e-df1d47d4fd44 Call-Direction: inbound Presence-Call-Direction: inbound Channel-HIT-Dialplan: true Channel-Presence-ID: 018888388%40192.168.8.6 Channel-Call-UUID: bc6ca164-db08-42c8-895e-df1d47d4fd44 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: 018888388 Caller-Dialplan: XML Caller-Caller-ID-Name: 018888388 Caller-Caller-ID-Number: 018888388 Caller-Orig-Caller-ID-Name: 018888388 Caller-Orig-Caller-ID-Number: 018888388 Caller-Network-Addr: 192.168.8.6 Caller-ANI: 018888388 Caller-Destination-Number: 9088999989 Caller-Unique-ID: bc6ca164-db08-42c8-895e-df1d47d4fd44 Caller-Source: mod_sofia Caller-Context: default Caller-Channel-Name: sofia/default/018888388%40192.168.8.6 Caller-Profile-Index: 1 Caller-Profile-Created-Time: 1603794227665809 Caller-Channel-Created-Time: 1603794227665809 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: bc6ca164-db08-42c8-895e-df1d47d4fd44 variable_session_id: 8860 variable_sip_from_user: 018888388 variable_sip_from_uri: 018888388%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/018888388%40192.168.8.6 variable_sip_call_id: e5a9fcd0-d8f1-418b-97e1-e6691b3b0d00 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: 1603794227665809 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: 018888388 variable_sip_from_tag: 4d72185b-b608-4d97-af3f-857fe60aaaa6 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%3Dz9hG4bKPjbb9a22eb-1c3a-4d69-af1a-ede4e094b45f variable_sip_from_display: 018888388 variable_sip_full_from: %22018888388%22%20%3Csip%3A018888388%40192.168.8.6%3E%3Btag%3D4d72185b-b608-4d97-af3f-857fe60aaaa6 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: 018888388%40192.168.8.6 variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%201083192432%201083192432%20IN%20IP4%20192.168.8.6%0D%0As%3DAsterisk%0D%0Ac%3DIN%20IP4%20192.168.8.6%0D%0At%3D0%200%0D%0Am%3Daudio%2018272%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: 18272 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: bc6ca164-db08-42c8-895e-df1d47d4fd44 Hunt-Direction: inbound Hunt-Logical-Direction: inbound Hunt-Username: 018888388 Hunt-Dialplan: XML Hunt-Caller-ID-Name: 018888388 Hunt-Caller-ID-Number: 018888388 Hunt-Orig-Caller-ID-Name: 018888388 Hunt-Orig-Caller-ID-Number: 018888388 Hunt-Network-Addr: 192.168.8.6 Hunt-ANI: 018888388 Hunt-Destination-Number: 9088999989 Hunt-Unique-ID: bc6ca164-db08-42c8-895e-df1d47d4fd44 Hunt-Source: mod_sofia Hunt-Context: default Hunt-Channel-Name: sofia/default/018888388%40192.168.8.6 Hunt-Profile-Index: 1 Hunt-Profile-Created-Time: 1603794227665809 Hunt-Channel-Created-Time: 1603794227665809 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-10-27 11:23:47.745817 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] tag_name: 2020-10-27 11:23:47.745817 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_value: 2020-10-27 11:23:47.745817 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_name: 2020-10-27 11:23:47.745817 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] section: dialplan 2020-10-27 11:23:47.745817 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] blind_flag: 0 2020-10-27 11:23:47.745817 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Dialed number : 9088999989 2020-10-27 11:23:47.745817 [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-10-27 11:23:47.745817 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '9088999989' AND status=0 limit 1 2020-10-27 11:23:47.745817 [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-10-27 11:23:47.745817 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Caller Id name / number : 018888388 / 018888388 2020-10-27 11:23:47.745817 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-10-27 11:23:47.745817 [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-10-27 11:23:47.745817 [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-10-27 11:23:47.745817 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Call direction : inbound 2020-10-27 11:23:47.745817 [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-10-27 11:23:47.745817 [INFO] switch_cpp.cpp:1443 [ASTPP] [Accountcode : 1135674299] 2020-10-27 11:23:47.745817 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1 2020-10-27 11:23:47.765805 [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-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 9088999989 2020-10-27 11:23:47.765805 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-10-27 11:23:47.765805 [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-10-27 11:23:47.765805 [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-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] New Call direction : inbound 2020-10-27 11:23:47.765805 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-10-27 11:23:47.765805 [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-10-27 11:23:47.765805 [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-10-27 11:23:47.765805 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] call_direction :inbound 2020-10-27 11:23:47.765805 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] DID_ACCOUNTID :138 2020-10-27 11:23:47.765805 [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-10-27 11:23:47.765805 [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 = '018888388' OR number = '01888838' OR number = '0188883' OR number = '018888' OR number = '01888' OR number = '0188' OR number = '018' OR number = '01' OR number = '0' OR number ='--') OR (number = '018888388*' OR number = '01888838*' OR number = '0188883*' OR number = '018888*' OR number = '01888*' OR number = '0188*' OR number = '018*' OR number = '01*' OR number = '0*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2020-10-27 11:23:47.765805 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Call Barring Status : -1 2020-10-27 11:23:47.765805 [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-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] =============== Account Information =================== 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] User id : 123 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] Account code : 1135674299 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] Balance : 6856.66 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] Ratecard id : 1 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] CID Pool : 0 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] ======================================================== 2020-10-27 11:23:47.765805 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0 2020-10-27 11:23:47.765805 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_RATES] call_direction :inbound 2020-10-27 11:23:47.765805 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-10-27 11:23:47.765805 [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-10-27 11:23:47.765805 [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-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] call_direction:::::: inbound 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] =============== Rates Information =================== 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] ID : 40 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] Connectcost : 0.00000 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] Includedseconds : 0 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] Cost : 0.00000 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] comment : 9088999989 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] Country Id : 141 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] Accid : 123 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] ================================================================ 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] [FIND_MAXLENGTH] Your6856.66 balance Accountid 123 !!! 2020-10-27 11:23:47.765805 [NOTICE] switch_cpp.cpp:1443 [ASTPP] [FIND_MAXLENGTH] Call is free - assigning max length!!! :: 100 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] Call Max length duration : 100 minutes 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] INB_FREE:TRUE 2020-10-27 11:23:47.765805 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] free_inbound:1 2020-10-27 11:23:47.765805 [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-10-27 11:23:47.765805 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1 2020-10-27 11:23:47.785821 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1 2020-10-27 11:23:47.785821 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Actual CustomerInfo XML:123 2020-10-27 11:23:47.785821 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Userinfo XML:123 2020-10-27 11:23:47.785821 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Actual CustomerInfo XML : 123 2020-10-27 11:23:47.785821 [INFO] switch_cpp.cpp:1443 [ASTPP] maxlength::::::::: 100 2020-10-27 11:23:47.785821 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET domains] Query :SELECT * FROM domains WHERE accountid = 138 limit 1 2020-10-27 11:23:47.785821 [WARNING] switch_cpp.cpp:1443 [ASTPP] [user_domain] user_domaintest446.9mobile.nativetalk.com.ng 2020-10-27 11:23:47.785821 [DEBUG] switch_cpp.cpp:1443 [ASTPP] custom_function_name:::::::::::::::::::::::::custom_inbound_10 2020-10-27 11:23:47.785821 [DEBUG] switch_cpp.cpp:1443 [ASTPP] custom_function_name::::::::::1343:::::::::::::::40 2020-10-27 11:23:47.785821 [INFO] switch_cpp.cpp:1443 [ASTPP] [PBX] call_type : 10 2020-10-27 11:23:47.785821 [INFO] switch_cpp.cpp:1443 [ASTPP] [PBX] call_type : IVR 2020-10-27 11:23:47.785821 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_IVR_INFO] Query :SELECT * from pbx_ivr_specification WHERE id = 12 and status=0 LIMIT 1 2020-10-27 11:23:47.785821 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_RING_GROUP_INFO] Query :SELECT file_name from pbx_recording WHERE id = '' LIMIT 1 2020-10-27 11:23:47.785821 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Generated XML:
Dialplan: sofia/default/018888388@192.168.8.6 parsing [default->9088999989] continue=false Dialplan: sofia/default/018888388@192.168.8.6 Regex (PASS) [9088999989] destination_number(9088999989) =~ /9088999989/ break=on-false Dialplan: sofia/default/018888388@192.168.8.6 Action set(effective_destination_number=9088999989) Dialplan: sofia/default/018888388@192.168.8.6 Action set(bridge_pre_execute_bleg_app=sched_hangup) Dialplan: sofia/default/018888388@192.168.8.6 Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing) Dialplan: sofia/default/018888388@192.168.8.6 Action set(callstart=2020-10-27 10:23:47) Dialplan: sofia/default/018888388@192.168.8.6 Action set(hangup_after_bridge=true) Dialplan: sofia/default/018888388@192.168.8.6 Action set(continue_on_fail=TRUE) Dialplan: sofia/default/018888388@192.168.8.6 Action set(account_id=123) Dialplan: sofia/default/018888388@192.168.8.6 Action set(parent_id=0) Dialplan: sofia/default/018888388@192.168.8.6 Action set(entity_id=0) Dialplan: sofia/default/018888388@192.168.8.6 Action set(call_processed=internal) Dialplan: sofia/default/018888388@192.168.8.6 Action set(call_direction=inbound) Dialplan: sofia/default/018888388@192.168.8.6 Action set(accountname=HOD1) Dialplan: sofia/default/018888388@192.168.8.6 Action set(origination_rates_did=ID:40|CODE:^9088999989.*|DESTINATION:9088999989|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:141|ACCID:138) Dialplan: sofia/default/018888388@192.168.8.6 Action set(origination_rates=0) Dialplan: sofia/default/018888388@192.168.8.6 Action set(original_caller_id_name=9088999989) Dialplan: sofia/default/018888388@192.168.8.6 Action set(original_caller_id_number=9088999989) Dialplan: sofia/default/018888388@192.168.8.6 Action set(effective_caller_id_name=9088999989) Dialplan: sofia/default/018888388@192.168.8.6 Action set(effective_caller_id_number=9088999989) Dialplan: sofia/default/018888388@192.168.8.6 Action set(receiver_accid=138) Dialplan: sofia/default/018888388@192.168.8.6 Action export(presence_data=x|||martins(1135674299)|||^9088999989.* // 9088999989 // 0.00000||||||DID) Dialplan: sofia/default/018888388@192.168.8.6 Action export(call_type=10) Dialplan: sofia/default/018888388@192.168.8.6 Action set(did_calltype=10) Dialplan: sofia/default/018888388@192.168.8.6 Action set(did_extensions=12) Dialplan: sofia/default/018888388@192.168.8.6 Action set(ringback=) Dialplan: sofia/default/018888388@192.168.8.6 Action set(module_name=pbx) Dialplan: sofia/default/018888388@192.168.8.6 Action answer() Dialplan: sofia/default/018888388@192.168.8.6 Action ivr(iVRtest0) 2020-10-27 11:23:47.785821 [DEBUG] switch_core_state_machine.c:287 (sofia/default/018888388@192.168.8.6) State Change CS_ROUTING -> CS_EXECUTE 2020-10-27 11:23:47.785821 [DEBUG] switch_core_state_machine.c:644 (sofia/default/018888388@192.168.8.6) State ROUTING going to sleep 2020-10-27 11:23:47.785821 [DEBUG] switch_core_state_machine.c:585 (sofia/default/018888388@192.168.8.6) Running State Change CS_EXECUTE (Cur 1 Tot 8860) 2020-10-27 11:23:47.785821 [DEBUG] switch_core_state_machine.c:651 (sofia/default/018888388@192.168.8.6) State EXECUTE 2020-10-27 11:23:47.785821 [DEBUG] mod_sofia.c:209 sofia/default/018888388@192.168.8.6 SOFIA EXECUTE 2020-10-27 11:23:47.785821 [DEBUG] switch_core_state_machine.c:329 sofia/default/018888388@192.168.8.6 Standard EXECUTE EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(effective_destination_number=9088999989) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [effective_destination_number]=[9088999989] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(bridge_pre_execute_bleg_app=sched_hangup) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [bridge_pre_execute_bleg_app]=[sched_hangup] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(bridge_pre_execute_bleg_data=+6000 normal_clearing) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [bridge_pre_execute_bleg_data]=[+6000 normal_clearing] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(callstart=2020-10-27 10:23:47) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [callstart]=[2020-10-27 10:23:47] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(hangup_after_bridge=true) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [hangup_after_bridge]=[true] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(continue_on_fail=TRUE) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [continue_on_fail]=[TRUE] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(account_id=123) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [account_id]=[123] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(parent_id=0) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [parent_id]=[0] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(entity_id=0) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [entity_id]=[0] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(call_processed=internal) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [call_processed]=[internal] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(call_direction=inbound) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [call_direction]=[inbound] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(accountname=HOD1) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [accountname]=[HOD1] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(origination_rates_did=ID:40|CODE:^9088999989.*|DESTINATION:9088999989|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:141|ACCID:138) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [origination_rates_did]=[ID:40|CODE:^9088999989.*|DESTINATION:9088999989|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:141|ACCID:138] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(origination_rates=0) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [origination_rates]=[0] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(original_caller_id_name=9088999989) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [original_caller_id_name]=[9088999989] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(original_caller_id_number=9088999989) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [original_caller_id_number]=[9088999989] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(effective_caller_id_name=9088999989) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [effective_caller_id_name]=[9088999989] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(effective_caller_id_number=9088999989) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [effective_caller_id_number]=[9088999989] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(receiver_accid=138) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [receiver_accid]=[138] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 export(presence_data=x|||martins(1135674299)|||^9088999989.* // 9088999989 // 0.00000||||||DID) 2020-10-27 11:23:47.785821 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_data]=[x|||martins(1135674299)|||^9088999989.* // 9088999989 // 0.00000||||||DID] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 export(call_type=10) 2020-10-27 11:23:47.785821 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [call_type]=[10] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(did_calltype=10) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [did_calltype]=[10] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(did_extensions=12) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [did_extensions]=[12] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(ringback=) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [ringback]=[UNDEF] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(module_name=pbx) 2020-10-27 11:23:47.785821 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [module_name]=[pbx] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 answer() 2020-10-27 11:23:47.785821 [DEBUG] switch_core_media.c:8658 AUDIO RTP [sofia/default/018888388@192.168.8.6] 192.168.8.3 port 24596 -> 192.168.8.6 port 18272 codec: 0 ms: 20 2020-10-27 11:23:47.785821 [DEBUG] switch_rtp.c:4408 Starting timer [soft] 160 bytes per 20ms 2020-10-27 11:23:47.805809 [DEBUG] switch_core_media.c:8972 sofia/default/018888388@192.168.8.6 Set 2833 dtmf send payload to 101 2020-10-27 11:23:47.805809 [DEBUG] switch_core_media.c:8979 sofia/default/018888388@192.168.8.6 Set 2833 dtmf receive payload to 101 2020-10-27 11:23:47.805809 [DEBUG] switch_core_media.c:9002 sofia/default/018888388@192.168.8.6 Set rtp dtmf delay to 40 2020-10-27 11:23:47.805809 [DEBUG] mod_sofia.c:905 Local SDP sofia/default/018888388@192.168.8.6: v=0 o=FreeSWITCH 1603769631 1603769632 IN IP4 192.168.8.3 s=FreeSWITCH c=IN IP4 192.168.8.3 t=0 0 m=audio 24596 RTP/AVP 0 101 a=rtpmap:0 PCMU/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=ptime:20 a=sendrecv 2020-10-27 11:23:47.805809 [NOTICE] mod_dptools.c:1406 Channel [sofia/default/018888388@192.168.8.6] has been answered 2020-10-27 11:23:47.805809 [DEBUG] switch_channel.c:3865 (sofia/default/018888388@192.168.8.6) Callstate Change RINGING -> ACTIVE 2020-10-27 11:23:47.805809 [DEBUG] sofia.c:7290 Channel sofia/default/018888388@192.168.8.6 entering state [completed][200] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 ivr(iVRtest0) 2020-10-27 11:23:47.845813 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-exit' 2020-10-27 11:23:47.845813 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-sub' 2020-10-27 11:23:47.845813 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-exec-app' 2020-10-27 11:23:47.845813 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-play-sound' 2020-10-27 11:23:47.845813 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-back' 2020-10-27 11:23:47.845813 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-top' 2020-10-27 11:23:47.845813 [DEBUG] switch_ivr_menu.c:883 building menu 'iVRtest0' 2020-10-27 11:23:47.845813 [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '1' 2020-10-27 11:23:47.845813 [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '2' 2020-10-27 11:23:47.845813 [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '3' 2020-10-27 11:23:47.845813 [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '/^(\d{2,20})$/' 2020-10-27 11:23:47.845813 [DEBUG] switch_ivr_menu.c:486 Executing IVR menu iVRtest0 2020-10-27 11:23:47.845813 [DEBUG] sofia.c:7290 Channel sofia/default/018888388@192.168.8.6 entering state [ready][200] 2020-10-27 11:23:47.845813 [DEBUG] switch_ivr_play_say.c:1492 Codec Activated L16@8000hz 1 channels 20ms 2020-10-27 11:23:48.245813 [DEBUG] switch_rtp.c:7720 Correct audio ip/port confirmed. 2020-10-27 11:23:48.665802 [WARNING] switch_core_file.c:410 File has 2 channels, muxing to 1 channel will occur. 2020-10-27 11:23:54.365808 [WARNING] switch_core_file.c:410 File has 2 channels, muxing to 1 channel will occur. 2020-10-27 11:24:02.085803 [WARNING] switch_core_file.c:410 File has 2 channels, muxing to 1 channel will occur. 2020-10-27 11:24:05.465810 [DEBUG] switch_ivr_play_say.c:1933 done playing file /var/www/html/astpp/upload/pbx/ivr(2)_211020121726.wav 2020-10-27 11:24:05.485811 [DEBUG] switch_ivr_menu.c:378 waiting for 20/20 digits t/o 2000 2020-10-27 11:24:07.785813 [WARNING] switch_core_file.c:410 File has 2 channels, muxing to 1 channel will occur. 2020-10-27 11:24:11.485815 [DEBUG] switch_rtp.c:7963 RTP RECV DTMF 1:1768 2020-10-27 11:24:11.485815 [INFO] switch_channel.c:522 RECV DTMF 1:1768 2020-10-27 11:24:13.505812 [DEBUG] switch_ivr_menu.c:425 digits '1' 2020-10-27 11:24:13.505812 [DEBUG] switch_ivr_menu.c:580 IVR action on menu 'iVRtest0' matched '1' param 'transfer 6350951709 XML ${domain_name}' 2020-10-27 11:24:13.505812 [DEBUG] switch_ivr_menu.c:584 switch_ivr_menu_execute todo=[2] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 transfer(6350951709 XML 192.168.8.3) 2020-10-27 11:24:13.525809 [DEBUG] switch_ivr.c:2231 (sofia/default/018888388@192.168.8.6) State Change CS_EXECUTE -> CS_ROUTING 2020-10-27 11:24:13.525809 [NOTICE] switch_ivr.c:2238 Transfer sofia/default/018888388@192.168.8.6 to XML[6350951709@192.168.8.3] 2020-10-27 11:24:13.525809 [DEBUG] switch_ivr_menu.c:562 action regex [1] [/^(\d{2,20})$/] [0] 2020-10-27 11:24:13.525809 [DEBUG] switch_ivr_menu.c:676 exit-sound 'voicemail/vm-goodbye.wav' 2020-10-27 11:24:13.525809 [DEBUG] switch_core_state_machine.c:651 (sofia/default/018888388@192.168.8.6) State EXECUTE going to sleep 2020-10-27 11:24:13.525809 [DEBUG] switch_core_state_machine.c:585 (sofia/default/018888388@192.168.8.6) Running State Change CS_ROUTING (Cur 1 Tot 8860) 2020-10-27 11:24:13.525809 [DEBUG] switch_channel.c:2332 (sofia/default/018888388@192.168.8.6) Callstate Change ACTIVE -> RINGING 2020-10-27 11:24:13.525809 [DEBUG] switch_core_state_machine.c:644 (sofia/default/018888388@192.168.8.6) State ROUTING 2020-10-27 11:24:13.525809 [DEBUG] mod_sofia.c:154 sofia/default/018888388@192.168.8.6 SOFIA ROUTING 2020-10-27 11:24:13.525809 [DEBUG] switch_core_state_machine.c:236 sofia/default/018888388@192.168.8.6 Standard ROUTING 2020-10-27 11:24:13.525809 [INFO] mod_dialplan_xml.c:637 Processing 018888388 <018888388>->6350951709 in context 192.168.8.3 2020-10-27 11:24:13.525809 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2020-10-27 11:24:13.525809 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2020-10-27 11:24:13.565935 [NOTICE] switch_cpp.cpp:1443 [ASTPP] [xml_handler] Params: Event-Name: REQUEST_PARAMS Core-UUID: f0e00936-3fce-4a2b-af76-c25556ae0e1a FreeSWITCH-Hostname: soultech FreeSWITCH-Switchname: soultech FreeSWITCH-IPv4: 192.168.8.3 FreeSWITCH-IPv6: %3A%3A1 Event-Date-Local: 2020-10-27%2011%3A24%3A13 Event-Date-GMT: Tue,%2027%20Oct%202020%2010%3A24%3A13%20GMT Event-Date-Timestamp: 1603794253525809 Event-Calling-File: mod_dialplan_xml.c Event-Calling-Function: dialplan_xml_locate Event-Calling-Line-Number: 608 Event-Sequence: 453495 Channel-State: CS_ROUTING Channel-Call-State: RINGING Channel-State-Number: 2 Channel-Name: sofia/default/018888388%40192.168.8.6 Unique-ID: bc6ca164-db08-42c8-895e-df1d47d4fd44 Call-Direction: inbound Presence-Call-Direction: inbound Channel-HIT-Dialplan: true Channel-Presence-ID: 018888388%40192.168.8.6 Channel-Presence-Data: x%7C%7C%7Cmartins(1135674299)%7C%7C%7C%5E9088999989.*%20//%209088999989%20//%200.00000%7C%7C%7C%7C%7C%7CDID Channel-Call-UUID: bc6ca164-db08-42c8-895e-df1d47d4fd44 Answer-State: answered 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: 018888388 Caller-Dialplan: XML Caller-Caller-ID-Name: 018888388 Caller-Caller-ID-Number: 018888388 Caller-Orig-Caller-ID-Name: 018888388 Caller-Orig-Caller-ID-Number: 018888388 Caller-Network-Addr: 192.168.8.6 Caller-ANI: 018888388 Caller-Destination-Number: 6350951709 Caller-Unique-ID: bc6ca164-db08-42c8-895e-df1d47d4fd44 Caller-Source: mod_sofia Caller-Transfer-Source: 1603794253%3A9c6019e2-9381-40fd-bcfc-d1287f991ccf%3Abl_xfer%3A6350951709/192.168.8.3/XML Caller-Context: 192.168.8.3 Caller-RDNIS: 9088999989 Caller-Channel-Name: sofia/default/018888388%40192.168.8.6 Caller-Profile-Index: 2 Caller-Profile-Created-Time: 1603794253525809 Caller-Channel-Created-Time: 1603794227665809 Caller-Channel-Answered-Time: 1603794227805809 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: bc6ca164-db08-42c8-895e-df1d47d4fd44 variable_session_id: 8860 variable_sip_from_user: 018888388 variable_sip_from_uri: 018888388%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/018888388%40192.168.8.6 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: 1603794227665809 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: 018888388 variable_sofia_profile_name: default variable_sofia_profile_url: sip%3Amod_sofia%40192.168.8.3%3A5060 variable_recovery_profile_name: default 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: 018888388%40192.168.8.6 variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%201083192432%201083192432%20IN%20IP4%20192.168.8.6%0D%0As%3DAsterisk%0D%0Ac%3DIN%20IP4%20192.168.8.6%0D%0At%3D0%200%0D%0Am%3Daudio%2018272%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_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_effective_destination_number: 9088999989 variable_bridge_pre_execute_bleg_app: sched_hangup variable_bridge_pre_execute_bleg_data: %2B6000%20normal_clearing variable_callstart: 2020-10-27%2010%3A23%3A47 variable_hangup_after_bridge: true variable_continue_on_fail: TRUE variable_account_id: 123 variable_parent_id: 0 variable_entity_id: 0 variable_call_processed: internal variable_call_direction: inbound variable_accountname: HOD1 variable_origination_rates_did: ID%3A40%7CCODE%3A%5E9088999989.*%7CDESTINATION%3A9088999989%7CCONNECTIONCOST%3A0.00000%7CINCLUDEDSECONDS%3A0%7CCT%3A10%7CCOST%3A0.00000%7CINC%3A0%7CINITIALBLOCK%3A0%7CRATEGROUP%3A0%7CMARKUP%3A0%7CCI%3A141%7CACCID%3A138 variable_origination_rates: 0 variable_original_caller_id_name: 9088999989 variable_original_caller_id_number: 9088999989 variable_effective_caller_id_name: 9088999989 variable_effective_caller_id_number: 9088999989 variable_receiver_accid: 138 variable_presence_data: x%7C%7C%7Cmartins(1135674299)%7C%7C%7C%5E9088999989.*%20//%209088999989%20//%200.00000%7C%7C%7C%7C%7C%7CDID variable_call_type: 10 variable_export_vars: presence_data,call_type variable_did_calltype: 10 variable_did_extensions: 12 variable_module_name: pbx variable_rtp_local_sdp_str: v%3D0%0D%0Ao%3DFreeSWITCH%201603769631%201603769632%20IN%20IP4%20192.168.8.3%0D%0As%3DFreeSWITCH%0D%0Ac%3DIN%20IP4%20192.168.8.3%0D%0At%3D0%200%0D%0Am%3Daudio%2024596%20RTP/AVP%200%20101%0D%0Aa%3Drtpmap%3A0%20PCMU/8000%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dfmtp%3A101%200-16%0D%0Aa%3Dptime%3A20%0D%0Aa%3Dsendrecv%0D%0A variable_local_media_ip: 192.168.8.3 variable_local_media_port: 24596 variable_advertised_media_ip: 192.168.8.3 variable_rtp_use_timer_name: soft variable_rtp_use_pt: 0 variable_rtp_use_ssrc: 64064987 variable_rtp_2833_send_payload: 101 variable_rtp_2833_recv_payload: 101 variable_remote_media_ip: 192.168.8.6 variable_remote_media_port: 18272 variable_endpoint_disposition: ANSWER variable_ivr_menu_status: success variable_sip_to_tag: 1rZ9BZU863yBQ variable_sip_from_tag: 4d72185b-b608-4d97-af3f-857fe60aaaa6 variable_sip_cseq: 7712 variable_sip_call_id: e5a9fcd0-d8f1-418b-97e1-e6691b3b0d00 variable_sip_full_via: SIP/2.0/UDP%20192.168.8.6%3A5060%3Brport%3D5060%3Bbranch%3Dz9hG4bKPjeccf2f9c-cdd0-409a-bc83-822187edc7d8 variable_sip_from_display: 018888388 variable_sip_full_from: %22018888388%22%20%3Csip%3A018888388%40192.168.8.6%3E%3Btag%3D4d72185b-b608-4d97-af3f-857fe60aaaa6 variable_sip_full_to: %3Csip%3A9088999989%40192.168.8.3%3E%3Btag%3D1rZ9BZU863yBQ variable_RECORD_SOFTWARE: Lavf58.46.101 variable_playback_last_offset_pos: 141271 variable_playback_seconds: 17 variable_playback_ms: 17658 variable_playback_samples: 141271 variable_current_application_data: 6350951709%20XML%20192.168.8.3 variable_current_application: transfer variable_max_forwards: 69 variable_transfer_history: 1603794253%3A9c6019e2-9381-40fd-bcfc-d1287f991ccf%3Abl_xfer%3A6350951709/192.168.8.3/XML variable_transfer_source: 1603794253%3A9c6019e2-9381-40fd-bcfc-d1287f991ccf%3Abl_xfer%3A6350951709/192.168.8.3/XML variable_call_uuid: bc6ca164-db08-42c8-895e-df1d47d4fd44 Hunt-Direction: inbound Hunt-Logical-Direction: inbound Hunt-Username: 018888388 Hunt-Dialplan: XML Hunt-Caller-ID-Name: 018888388 Hunt-Caller-ID-Number: 018888388 Hunt-Orig-Caller-ID-Name: 018888388 Hunt-Orig-Caller-ID-Number: 018888388 Hunt-Network-Addr: 192.168.8.6 Hunt-ANI: 018888388 Hunt-Destination-Number: 6350951709 Hunt-Unique-ID: bc6ca164-db08-42c8-895e-df1d47d4fd44 Hunt-Source: mod_sofia Hunt-Transfer-Source: 1603794253%3A9c6019e2-9381-40fd-bcfc-d1287f991ccf%3Abl_xfer%3A6350951709/192.168.8.3/XML Hunt-Context: 192.168.8.3 Hunt-RDNIS: 9088999989 Hunt-Channel-Name: sofia/default/018888388%40192.168.8.6 Hunt-Profile-Index: 2 Hunt-Profile-Created-Time: 1603794253525809 Hunt-Channel-Created-Time: 1603794227665809 Hunt-Channel-Answered-Time: 1603794227805809 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-10-27 11:24:13.565935 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] tag_name: 2020-10-27 11:24:13.565935 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_name: 2020-10-27 11:24:13.565935 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_value: 2020-10-27 11:24:13.565935 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] section: dialplan 2020-10-27 11:24:13.565935 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] blind_flag: 0 2020-10-27 11:24:13.565935 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Dialed number : 6350951709 2020-10-27 11:24:13.565935 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '6350951709' limit 1 2020-10-27 11:24:13.565935 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '6350951709' AND status=0 limit 1 2020-10-27 11:24:13.565935 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '6350951709' and status=0 LIMIT 1 2020-10-27 11:24:13.565935 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Caller Id name / number : 9088999989 / 9088999989 2020-10-27 11:24:13.565935 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-10-27 11:24:13.565935 [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-10-27 11:24:13.565935 [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 ="6350951709" LIMIT 1 2020-10-27 11:24:13.565935 [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="6350951709" AND domains.domain="192.168.8.3" limit 1 2020-10-27 11:24:13.565935 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Call direction : outbound 2020-10-27 11:24:13.565935 [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 "6350951709" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1 2020-10-27 11:24:13.565935 [INFO] switch_cpp.cpp:1443 [ASTPP] [Accountcode : 1135674299] 2020-10-27 11:24:13.565935 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1 2020-10-27 11:24:13.605804 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1 2020-10-27 11:24:13.605804 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^6350951709.*' OR blocked_patterns = '^635095170.*' OR blocked_patterns = '^63509517.*' OR blocked_patterns = '^6350951.*' OR blocked_patterns = '^635095.*' OR blocked_patterns = '^63509.*' OR blocked_patterns = '^6350.*' OR blocked_patterns = '^635.*' OR blocked_patterns = '^63.*' OR blocked_patterns = '^6.*' OR blocked_patterns ='--') AND accountid = 123 limit 1 2020-10-27 11:24:13.605804 [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 ="6350951709" AND A.accountid = '123' limit 1 2020-10-27 11:24:13.605804 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 6350951709 2020-10-27 11:24:13.605804 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-10-27 11:24:13.605804 [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-10-27 11:24:13.605804 [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 ="6350951709" LIMIT 1 2020-10-27 11:24:13.605804 [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="6350951709" AND domains.domain="192.168.8.3" limit 1 2020-10-27 11:24:13.605804 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] New Call direction : outbound 2020-10-27 11:24:13.605804 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1 2020-10-27 11:24:13.605804 [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-10-27 11:24:13.605804 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="6350951709" AND (accountid = 0 OR status = 1) LIMIT 1 2020-10-27 11:24:13.605804 [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 = '^6350951709.*' OR patterns = '^635095170.*' OR patterns = '^63509517.*' OR patterns = '^6350951.*' OR patterns = '^635095.*' OR patterns = '^63509.*' OR patterns = '^6350.*' OR patterns = '^635.*' OR patterns = '^63.*' OR patterns = '^6.*' OR patterns ='--') AND accountid = 123 ORDER BY LENGTH(PKGPTR.patterns) DESC 2020-10-27 11:24:13.605804 [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 = '6350951709' OR number = '635095170' OR number = '63509517' OR number = '6350951' OR number = '635095' OR number = '63509' OR number = '6350' OR number = '635' OR number = '63' OR number = '6' OR number ='--') OR (number = '6350951709*' OR number = '635095170*' OR number = '63509517*' OR number = '6350951*' OR number = '635095*' OR number = '63509*' OR number = '6350*' OR number = '635*' OR number = '63*' OR number = '6*' 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 = '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 ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2020-10-27 11:24:13.605804 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Call Barring Status : -1 2020-10-27 11:24:13.605804 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '6350951709' OR routing_prefix = '635095170' OR routing_prefix = '63509517' OR routing_prefix = '6350951' OR routing_prefix = '635095' OR routing_prefix = '63509' OR routing_prefix = '6350' OR routing_prefix = '635' OR routing_prefix = '63' OR routing_prefix = '6' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1 2020-10-27 11:24:13.605804 [INFO] switch_cpp.cpp:1443 [ASTPP] =============== Account Information =================== 2020-10-27 11:24:13.605804 [INFO] switch_cpp.cpp:1443 [ASTPP] User id : 123 2020-10-27 11:24:13.605804 [INFO] switch_cpp.cpp:1443 [ASTPP] Account code : 1135674299 2020-10-27 11:24:13.605804 [INFO] switch_cpp.cpp:1443 [ASTPP] Balance : 6856.66 2020-10-27 11:24:13.605804 [INFO] switch_cpp.cpp:1443 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2020-10-27 11:24:13.605804 [INFO] switch_cpp.cpp:1443 [ASTPP] Ratecard id : 1 2020-10-27 11:24:13.605804 [INFO] switch_cpp.cpp:1443 [ASTPP] CID Pool : 0 2020-10-27 11:24:13.605804 [INFO] switch_cpp.cpp:1443 [ASTPP] ======================================================== 2020-10-27 11:24:13.605804 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0 2020-10-27 11:24:13.605804 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_RATES] call_direction :outbound 2020-10-27 11:24:13.605804 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^6350951709.*' OR pattern = '^635095170.*' OR pattern = '^63509517.*' OR pattern = '^6350951.*' OR pattern = '^635095.*' OR pattern = '^63509.*' OR pattern = '^6350.*' OR pattern = '^635.*' OR pattern = '^63.*' OR pattern = '^6.*' OR pattern ='--') AND status = 0 AND (pricelist_id = 1 OR accountid=123) ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC LIMIT 1 2020-10-27 11:24:13.625810 [INFO] switch_cpp.cpp:1443 [ASTPP] call_direction:::::: outbound 2020-10-27 11:24:13.625810 [WARNING] switch_cpp.cpp:1443 [ASTPP] [FIND_MAXLENGTH] Rates not found!!! 2020-10-27 11:24:13.625810 [DEBUG] switch_cpp.cpp:1443 [ASTPP] post_cdrs:::0 2020-10-27 11:24:13.625810 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET RESELLERID] Query :SELECT reseller_id FROM accounts WHERE id = 123 2020-10-27 11:24:13.625810 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Generated XML:
Dialplan: sofia/default/018888388@192.168.8.6 parsing [192.168.8.3->6350951709] continue=false Dialplan: sofia/default/018888388@192.168.8.6 Regex (PASS) [6350951709] destination_number(6350951709) =~ /6350951709/ break=on-false Dialplan: sofia/default/018888388@192.168.8.6 Action log(WARNING Accountcode . Dialed number (6350951709) origination rates not found!!) Dialplan: sofia/default/018888388@192.168.8.6 Action set(original_caller_id_name=9088999989) Dialplan: sofia/default/018888388@192.168.8.6 Action set(original_caller_id_number=9088999989) Dialplan: sofia/default/018888388@192.168.8.6 Action set(error_cdr=1) Dialplan: sofia/default/018888388@192.168.8.6 Action set(callstart=2020-10-27 10:24:13) Dialplan: sofia/default/018888388@192.168.8.6 Action set(account_id=123) Dialplan: sofia/default/018888388@192.168.8.6 Action set(parent_id=0) Dialplan: sofia/default/018888388@192.168.8.6 Action set(call_direction=outbound) Dialplan: sofia/default/018888388@192.168.8.6 Action set(sip_ignore_remote_cause=true) Dialplan: sofia/default/018888388@192.168.8.6 Action set(call_processed=internal) Dialplan: sofia/default/018888388@192.168.8.6 Action set(effective_destination_number=6350951709) Dialplan: sofia/default/018888388@192.168.8.6 Action set(last_bridge_hangup_cause=ORIGNATION_RATE_NOT_FOUND) Dialplan: sofia/default/018888388@192.168.8.6 Action hangup(ORIGNATION_RATE_NOT_FOUND) 2020-10-27 11:24:13.625810 [DEBUG] switch_core_state_machine.c:287 (sofia/default/018888388@192.168.8.6) State Change CS_ROUTING -> CS_EXECUTE 2020-10-27 11:24:13.625810 [DEBUG] switch_core_state_machine.c:644 (sofia/default/018888388@192.168.8.6) State ROUTING going to sleep 2020-10-27 11:24:13.625810 [DEBUG] switch_core_state_machine.c:585 (sofia/default/018888388@192.168.8.6) Running State Change CS_EXECUTE (Cur 1 Tot 8860) 2020-10-27 11:24:13.625810 [DEBUG] switch_channel.c:2334 (sofia/default/018888388@192.168.8.6) Callstate Change RINGING -> ACTIVE 2020-10-27 11:24:13.625810 [DEBUG] switch_core_state_machine.c:651 (sofia/default/018888388@192.168.8.6) State EXECUTE 2020-10-27 11:24:13.625810 [DEBUG] mod_sofia.c:209 sofia/default/018888388@192.168.8.6 SOFIA EXECUTE 2020-10-27 11:24:13.625810 [DEBUG] switch_core_state_machine.c:329 sofia/default/018888388@192.168.8.6 Standard EXECUTE EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 log(WARNING Accountcode . Dialed number (6350951709) origination rates not found!!) 2020-10-27 11:24:13.625810 [WARNING] mod_dptools.c:1866 Accountcode . Dialed number (6350951709) origination rates not found!! EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(original_caller_id_name=9088999989) 2020-10-27 11:24:13.625810 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [original_caller_id_name]=[9088999989] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(original_caller_id_number=9088999989) 2020-10-27 11:24:13.625810 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [original_caller_id_number]=[9088999989] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(error_cdr=1) 2020-10-27 11:24:13.625810 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [error_cdr]=[1] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(callstart=2020-10-27 10:24:13) 2020-10-27 11:24:13.625810 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [callstart]=[2020-10-27 10:24:13] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(account_id=123) 2020-10-27 11:24:13.625810 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [account_id]=[123] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(parent_id=0) 2020-10-27 11:24:13.625810 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [parent_id]=[0] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(call_direction=outbound) 2020-10-27 11:24:13.625810 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [call_direction]=[outbound] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(sip_ignore_remote_cause=true) 2020-10-27 11:24:13.625810 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [sip_ignore_remote_cause]=[true] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(call_processed=internal) 2020-10-27 11:24:13.625810 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [call_processed]=[internal] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(effective_destination_number=6350951709) 2020-10-27 11:24:13.625810 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [effective_destination_number]=[6350951709] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 set(last_bridge_hangup_cause=ORIGNATION_RATE_NOT_FOUND) 2020-10-27 11:24:13.625810 [DEBUG] mod_dptools.c:1672 SET sofia/default/018888388@192.168.8.6 [last_bridge_hangup_cause]=[ORIGNATION_RATE_NOT_FOUND] EXECUTE [depth=0] sofia/default/018888388@192.168.8.6 hangup(ORIGNATION_RATE_NOT_FOUND) 2020-10-27 11:24:13.625810 [NOTICE] mod_dptools.c:1380 Hangup sofia/default/018888388@192.168.8.6 [CS_EXECUTE] [NORMAL_CLEARING] 2020-10-27 11:24:13.625810 [DEBUG] switch_core_session.c:2905 sofia/default/018888388@192.168.8.6 skip receive message [APPLICATION_EXEC_COMPLETE] (channel is hungup already) 2020-10-27 11:24:13.625810 [DEBUG] switch_core_state_machine.c:651 (sofia/default/018888388@192.168.8.6) State EXECUTE going to sleep 2020-10-27 11:24:13.625810 [DEBUG] switch_core_state_machine.c:585 (sofia/default/018888388@192.168.8.6) Running State Change CS_HANGUP (Cur 1 Tot 8860) 2020-10-27 11:24:13.625810 [DEBUG] switch_core_state_machine.c:848 (sofia/default/018888388@192.168.8.6) Callstate Change ACTIVE -> HANGUP 2020-10-27 11:24:13.625810 [DEBUG] switch_core_state_machine.c:850 (sofia/default/018888388@192.168.8.6) State HANGUP 2020-10-27 11:24:13.625810 [DEBUG] mod_sofia.c:460 Channel sofia/default/018888388@192.168.8.6 hanging up, cause: NORMAL_CLEARING 2020-10-27 11:24:13.625810 [DEBUG] mod_sofia.c:514 Sending BYE to sofia/default/018888388@192.168.8.6 2020-10-27 11:24:13.625810 [DEBUG] switch_core_state_machine.c:60 sofia/default/018888388@192.168.8.6 Standard HANGUP, cause: NORMAL_CLEARING 2020-10-27 11:24:13.625810 [DEBUG] switch_core_state_machine.c:850 (sofia/default/018888388@192.168.8.6) State HANGUP going to sleep 2020-10-27 11:24:13.625810 [DEBUG] switch_core_state_machine.c:620 (sofia/default/018888388@192.168.8.6) State Change CS_HANGUP -> CS_REPORTING 2020-10-27 11:24:13.625810 [DEBUG] switch_core_state_machine.c:585 (sofia/default/018888388@192.168.8.6) Running State Change CS_REPORTING (Cur 1 Tot 8860) 2020-10-27 11:24:13.625810 [DEBUG] switch_core_state_machine.c:936 (sofia/default/018888388@192.168.8.6) State REPORTING 2020-10-27 11:24:13.625810 [INFO] mod_json_cdr.c:271 Process [bc6ca164-db08-42c8-895e-df1d47d4fd44.cdr.json] 2020-10-27 11:24:13.685802 [DEBUG] switch_core_state_machine.c:174 sofia/default/018888388@192.168.8.6 Standard REPORTING, cause: NORMAL_CLEARING 2020-10-27 11:24:13.685802 [DEBUG] switch_core_state_machine.c:936 (sofia/default/018888388@192.168.8.6) State REPORTING going to sleep 2020-10-27 11:24:13.685802 [DEBUG] switch_core_state_machine.c:611 (sofia/default/018888388@192.168.8.6) State Change CS_REPORTING -> CS_DESTROY 2020-10-27 11:24:13.685802 [DEBUG] switch_core_session.c:1726 Session 8860 (sofia/default/018888388@192.168.8.6) Locked, Waiting on external entities 2020-10-27 11:24:13.685802 [NOTICE] switch_core_session.c:1744 Session 8860 (sofia/default/018888388@192.168.8.6) Ended 2020-10-27 11:24:13.685802 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/018888388@192.168.8.6 [CS_DESTROY] 2020-10-27 11:24:13.685802 [DEBUG] switch_core_state_machine.c:739 (sofia/default/018888388@192.168.8.6) Running State Change CS_DESTROY (Cur 0 Tot 8860) 2020-10-27 11:24:13.685802 [DEBUG] switch_core_state_machine.c:749 (sofia/default/018888388@192.168.8.6) State DESTROY 2020-10-27 11:24:13.685802 [DEBUG] mod_sofia.c:365 sofia/default/018888388@192.168.8.6 SOFIA DESTROY 2020-10-27 11:24:13.685802 [DEBUG] switch_core_state_machine.c:181 sofia/default/018888388@192.168.8.6 Standard DESTROY 2020-10-27 11:24:13.685802 [DEBUG] switch_core_state_machine.c:749 (sofia/default/018888388@192.168.8.6) State DESTROY going to sleep