2020-10-27 12:10:38.205813 [DEBUG] switch_ivr_play_say.c:1933 done playing file /var/www/html/astpp/upload/pbx/ivr(2)_211020121726.wav
2020-10-27 12:10:38.205813 [DEBUG] switch_ivr_menu.c:378 waiting for 20/20 digits t/o 2000
2020-10-27 12:10:40.725806 [WARNING] switch_core_file.c:410 File has 2 channels, muxing to 1 channel will occur.
2020-10-27 12:10:41.805800 [DEBUG] switch_rtp.c:7963 RTP RECV DTMF 2:968
2020-10-27 12:10:41.805800 [INFO] switch_channel.c:522 RECV DTMF 2:968
2020-10-27 12:10:43.805809 [DEBUG] switch_ivr_menu.c:425 digits '2'
2020-10-27 12:10:43.805809 [DEBUG] switch_ivr_menu.c:580 IVR action on menu 'iVRtest0' matched '2' param 'transfer 9566364151 XML ${domain_name}'
2020-10-27 12:10:43.805809 [DEBUG] switch_ivr_menu.c:584 switch_ivr_menu_execute todo=[2]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 transfer(9566364151 XML 192.168.8.3)
2020-10-27 12:10:43.805809 [DEBUG] switch_ivr.c:2231 (sofia/default/8138902220@192.168.8.6) State Change CS_EXECUTE -> CS_ROUTING
2020-10-27 12:10:43.805809 [NOTICE] switch_ivr.c:2238 Transfer sofia/default/8138902220@192.168.8.6 to XML[9566364151@192.168.8.3]
2020-10-27 12:10:43.805809 [DEBUG] switch_ivr_menu.c:562 action regex [2] [/^(\d{2,20})$/] [0]
2020-10-27 12:10:43.805809 [DEBUG] switch_ivr_menu.c:676 exit-sound 'voicemail/vm-goodbye.wav'
2020-10-27 12:10:43.805809 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE going to sleep
2020-10-27 12:10:43.805809 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_ROUTING (Cur 1 Tot 8877)
2020-10-27 12:10:43.805809 [DEBUG] switch_channel.c:2332 (sofia/default/8138902220@192.168.8.6) Callstate Change ACTIVE -> RINGING
2020-10-27 12:10:43.805809 [DEBUG] switch_core_state_machine.c:644 (sofia/default/8138902220@192.168.8.6) State ROUTING
2020-10-27 12:10:43.805809 [DEBUG] mod_sofia.c:154 sofia/default/8138902220@192.168.8.6 SOFIA ROUTING
2020-10-27 12:10:43.805809 [DEBUG] switch_core_state_machine.c:236 sofia/default/8138902220@192.168.8.6 Standard ROUTING
2020-10-27 12:10:43.805809 [INFO] mod_dialplan_xml.c:637 Processing 8138902220 <8138902220>->9566364151 in context 192.168.8.3
2020-10-27 12:10:43.825807 [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 12:10:43.825807 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2020-10-27 12:10:43.850728 [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%2012%3A10%3A43
Event-Date-GMT: Tue,%2027%20Oct%202020%2011%3A10%3A43%20GMT
Event-Date-Timestamp: 1603797043805809
Event-Calling-File: mod_dialplan_xml.c
Event-Calling-Function: dialplan_xml_locate
Event-Calling-Line-Number: 608
Event-Sequence: 454458
Channel-State: CS_ROUTING
Channel-Call-State: RINGING
Channel-State-Number: 2
Channel-Name: sofia/default/8138902220%40192.168.8.6
Unique-ID: ae154372-5007-45fa-978b-09c67b2e0b10
Call-Direction: inbound
Presence-Call-Direction: inbound
Channel-HIT-Dialplan: true
Channel-Presence-ID: 8138902220%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: ae154372-5007-45fa-978b-09c67b2e0b10
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: 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: 9566364151
Caller-Unique-ID: ae154372-5007-45fa-978b-09c67b2e0b10
Caller-Source: mod_sofia
Caller-Transfer-Source: 1603797043%3A125a69b4-dd4b-4dd7-ac81-465fd23b5081%3Abl_xfer%3A9566364151/192.168.8.3/XML
Caller-Context: 192.168.8.3
Caller-RDNIS: 9088999989
Caller-Channel-Name: sofia/default/8138902220%40192.168.8.6
Caller-Profile-Index: 2
Caller-Profile-Created-Time: 1603797043805809
Caller-Channel-Created-Time: 1603797020385805
Caller-Channel-Answered-Time: 1603797020525804
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: ae154372-5007-45fa-978b-09c67b2e0b10
variable_session_id: 8876
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_local_network_addr: 192.168.8.3
variable_sip_network_ip: 192.168.8.6
variable_sip_network_port: 5060
variable_sip_invite_stamp: 1603797020385805
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_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: 8138902220%40192.168.8.6
variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%20702233995%20702233995%20IN%20IP4%20192.168.8.6%0D%0As%3DAsterisk%0D%0Ac%3DIN%20IP4%20192.168.8.6%0D%0At%3D0%200%0D%0Am%3Daudio%2013572%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%2011%3A10%3A20
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%201603776934%201603776935%20IN%20IP4%20192.168.8.3%0D%0As%3DFreeSWITCH%0D%0Ac%3DIN%20IP4%20192.168.8.3%0D%0At%3D0%200%0D%0Am%3Daudio%2020086%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: 20086
variable_advertised_media_ip: 192.168.8.3
variable_rtp_use_timer_name: soft
variable_rtp_use_pt: 0
variable_rtp_use_ssrc: 64067780
variable_rtp_2833_send_payload: 101
variable_rtp_2833_recv_payload: 101
variable_remote_media_ip: 192.168.8.6
variable_remote_media_port: 13572
variable_endpoint_disposition: ANSWER
variable_sip_to_tag: U6Bt432p62vmc
variable_sip_from_tag: 6c25189e-9233-41e4-8de0-fb50700f273b
variable_sip_cseq: 28281
variable_sip_call_id: fd577983-79e4-4dc7-bf96-31cd59a2eb70
variable_sip_full_via: SIP/2.0/UDP%20192.168.8.6%3A5060%3Brport%3D5060%3Bbranch%3Dz9hG4bKPjb39079ba-0d9f-4212-8cf5-369dbb799560
variable_sip_from_display: 8138902220
variable_sip_full_from: %228138902220%22%20%3Csip%3A8138902220%40192.168.8.6%3E%3Btag%3D6c25189e-9233-41e4-8de0-fb50700f273b
variable_sip_full_to: %3Csip%3A9088999989%40192.168.8.3%3E%3Btag%3DU6Bt432p62vmc
variable_ivr_menu_status: success
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: 9566364151%20XML%20192.168.8.3
variable_current_application: transfer
variable_max_forwards: 69
variable_transfer_history: 1603797043%3A125a69b4-dd4b-4dd7-ac81-465fd23b5081%3Abl_xfer%3A9566364151/192.168.8.3/XML
variable_transfer_source: 1603797043%3A125a69b4-dd4b-4dd7-ac81-465fd23b5081%3Abl_xfer%3A9566364151/192.168.8.3/XML
variable_call_uuid: ae154372-5007-45fa-978b-09c67b2e0b10
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: 9566364151
Hunt-Unique-ID: ae154372-5007-45fa-978b-09c67b2e0b10
Hunt-Source: mod_sofia
Hunt-Transfer-Source: 1603797043%3A125a69b4-dd4b-4dd7-ac81-465fd23b5081%3Abl_xfer%3A9566364151/192.168.8.3/XML
Hunt-Context: 192.168.8.3
Hunt-RDNIS: 9088999989
Hunt-Channel-Name: sofia/default/8138902220%40192.168.8.6
Hunt-Profile-Index: 2
Hunt-Profile-Created-Time: 1603797043805809
Hunt-Channel-Created-Time: 1603797020385805
Hunt-Channel-Answered-Time: 1603797020525804
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 12:10:43.850728 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_name: 
2020-10-27 12:10:43.850728 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] tag_name: 
2020-10-27 12:10:43.850728 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] section: dialplan
2020-10-27 12:10:43.850728 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_value: 
2020-10-27 12:10:43.850728 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] blind_flag: 0
2020-10-27 12:10:43.850728 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Dialed number : 9566364151
2020-10-27 12:10:43.850728 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '9566364151' limit 1
2020-10-27 12:10:43.850728 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '9566364151' AND status=0 limit 1
2020-10-27 12:10:43.850728 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '9566364151' and status=0 LIMIT 1
2020-10-27 12:10:43.850728 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Caller Id name / number  : 9088999989 / 9088999989
2020-10-27 12:10:43.885802 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
2020-10-27 12:10:43.885802 [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 12:10:43.885802 [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 ="9566364151" LIMIT 1
2020-10-27 12:10:43.885802 [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="9566364151"  AND domains.domain="192.168.8.3" limit 1
2020-10-27 12:10:43.885802 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Call direction : outbound
2020-10-27 12:10:43.885802 [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 "9566364151"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
2020-10-27 12:10:43.885802 [INFO] switch_cpp.cpp:1443 [ASTPP] [Accountcode : 1135674299]
2020-10-27 12:10:43.885802 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1
2020-10-27 12:10:43.885802 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1
2020-10-27 12:10:43.885802 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^9566364151.*' OR blocked_patterns = '^956636415.*' OR blocked_patterns = '^95663641.*' OR blocked_patterns = '^9566364.*' OR blocked_patterns = '^956636.*' OR blocked_patterns = '^95663.*' OR blocked_patterns = '^9566.*' OR blocked_patterns = '^956.*' OR blocked_patterns = '^95.*' OR blocked_patterns = '^9.*' OR blocked_patterns ='--') AND accountid = 123 limit 1 
2020-10-27 12:10:43.905808 [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 ="9566364151" AND A.accountid = '123' limit 1
2020-10-27 12:10:43.905900 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 9566364151
2020-10-27 12:10:43.905900 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
2020-10-27 12:10:43.905900 [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 12:10:43.905900 [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 ="9566364151" LIMIT 1
2020-10-27 12:10:43.905900 [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="9566364151"  AND domains.domain="192.168.8.3" limit 1
2020-10-27 12:10:43.905900 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] New Call direction : outbound
2020-10-27 12:10:43.905900 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
2020-10-27 12:10:43.905900 [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 12:10:43.905900 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="9566364151" AND (accountid = 0 OR status = 1) LIMIT 1
2020-10-27 12:10:43.905900 [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 = '^9566364151.*' OR patterns = '^956636415.*' OR patterns = '^95663641.*' OR patterns = '^9566364.*' OR patterns = '^956636.*' OR patterns = '^95663.*' OR patterns = '^9566.*' OR patterns = '^956.*' OR patterns = '^95.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 123 ORDER BY LENGTH(PKGPTR.patterns) DESC
2020-10-27 12:10:43.905900 [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 = '9566364151' OR number = '956636415' OR number = '95663641' OR number = '9566364' OR number = '956636' OR number = '95663' OR number = '9566' OR number = '956' OR number = '95' OR number = '9' OR number ='--') OR (number = '9566364151*' OR number = '956636415*' OR number = '95663641*' OR number = '9566364*' OR number = '956636*' OR number = '95663*' OR number = '9566*' OR number = '956*' OR number = '95*' 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 = '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 12:10:43.905900 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Call Barring Status : -1
2020-10-27 12:10:43.905900 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '9566364151' OR routing_prefix = '956636415' OR routing_prefix = '95663641' OR routing_prefix = '9566364' OR routing_prefix = '956636' OR routing_prefix = '95663' OR routing_prefix = '9566' OR routing_prefix = '956' OR routing_prefix = '95' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
2020-10-27 12:10:43.905900 [INFO] switch_cpp.cpp:1443 [ASTPP] =============== Account Information ===================
2020-10-27 12:10:43.905900 [INFO] switch_cpp.cpp:1443 [ASTPP] User id : 123
2020-10-27 12:10:43.905900 [INFO] switch_cpp.cpp:1443 [ASTPP] Account code : 1135674299
2020-10-27 12:10:43.905900 [INFO] switch_cpp.cpp:1443 [ASTPP] Balance : 6856.66
2020-10-27 12:10:43.905900 [INFO] switch_cpp.cpp:1443 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
2020-10-27 12:10:43.905900 [INFO] switch_cpp.cpp:1443 [ASTPP] Ratecard id : 1
2020-10-27 12:10:43.905900 [INFO] switch_cpp.cpp:1443 [ASTPP] CID Pool : 0
2020-10-27 12:10:43.905900 [INFO] switch_cpp.cpp:1443 [ASTPP] ========================================================
2020-10-27 12:10:43.905900 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
2020-10-27 12:10:43.905900 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_RATES] call_direction :outbound
2020-10-27 12:10:43.905900 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^9566364151.*' OR pattern = '^956636415.*' OR pattern = '^95663641.*' OR pattern = '^9566364.*' OR pattern = '^956636.*' OR pattern = '^95663.*' OR pattern = '^9566.*' OR pattern = '^956.*' OR pattern = '^95.*' OR pattern = '^9.*' 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 12:10:43.905900 [INFO] switch_cpp.cpp:1443 [ASTPP] call_direction:::::: outbound
2020-10-27 12:10:43.905900 [WARNING] switch_cpp.cpp:1443 [ASTPP] [FIND_MAXLENGTH] Rates not found!!!
2020-10-27 12:10:43.905900 [DEBUG] switch_cpp.cpp:1443 [ASTPP] post_cdrs:::0
2020-10-27 12:10:43.905900 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET RESELLERID] Query :SELECT reseller_id FROM accounts WHERE id = 123
2020-10-27 12:10:43.905900 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Generated XML:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<document type="freeswitch/xml">
<section name="dialplan" description="ASTPP Dialplan">
<context name="192.168.8.3">
<extension name="9566364151">
<condition field="destination_number" expression="9566364151">
<action application="log" data="WARNING Accountcode . Dialed number (9566364151)  origination rates not found!!"/>
<action application="set" data="original_caller_id_name=9088999989"/>
<action application="set" data="original_caller_id_number=9088999989"/>
<action application="set" data="error_cdr=1"/>
<action application="set" data="callstart=2020-10-27 11:10:43"/>
<action application="set" data="account_id=123"/>
<action application="set" data="parent_id=0"/>
<action application="set" data="call_direction=outbound"/>
<action application="set" data="sip_ignore_remote_cause=true"/>
<action application="set" data="call_processed=internal"/>
<action application="set" data="effective_destination_number=9566364151"/>
<action application="set" data="last_bridge_hangup_cause=ORIGNATION_RATE_NOT_FOUND"/>
<action application="hangup" data="ORIGNATION_RATE_NOT_FOUND"/>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/default/8138902220@192.168.8.6 parsing [192.168.8.3->9566364151] continue=false
Dialplan: sofia/default/8138902220@192.168.8.6 Regex (PASS) [9566364151] destination_number(9566364151) =~ /9566364151/ break=on-false
Dialplan: sofia/default/8138902220@192.168.8.6 Action log(WARNING Accountcode . Dialed number (9566364151)  origination rates not found!!) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(original_caller_id_name=9088999989) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(original_caller_id_number=9088999989) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(error_cdr=1) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(callstart=2020-10-27 11:10:43) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(account_id=123) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(parent_id=0) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(call_direction=outbound) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(sip_ignore_remote_cause=true) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(call_processed=internal) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(effective_destination_number=9566364151) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(last_bridge_hangup_cause=ORIGNATION_RATE_NOT_FOUND) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action hangup(ORIGNATION_RATE_NOT_FOUND) 
2020-10-27 12:10:43.905900 [DEBUG] switch_core_state_machine.c:287 (sofia/default/8138902220@192.168.8.6) State Change CS_ROUTING -> CS_EXECUTE
2020-10-27 12:10:43.905900 [DEBUG] switch_core_state_machine.c:644 (sofia/default/8138902220@192.168.8.6) State ROUTING going to sleep
2020-10-27 12:10:43.905900 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_EXECUTE (Cur 1 Tot 8877)
2020-10-27 12:10:43.905900 [DEBUG] switch_channel.c:2334 (sofia/default/8138902220@192.168.8.6) Callstate Change RINGING -> ACTIVE
2020-10-27 12:10:43.905900 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE
2020-10-27 12:10:43.905900 [DEBUG] mod_sofia.c:209 sofia/default/8138902220@192.168.8.6 SOFIA EXECUTE
2020-10-27 12:10:43.905900 [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 log(WARNING Accountcode . Dialed number (9566364151)  origination rates not found!!)
2020-10-27 12:10:43.905900 [WARNING] mod_dptools.c:1866 Accountcode . Dialed number (9566364151)  origination rates not found!!
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(original_caller_id_name=9088999989)
2020-10-27 12:10:43.905900 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [original_caller_id_name]=[9088999989]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(original_caller_id_number=9088999989)
2020-10-27 12:10:43.905900 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [original_caller_id_number]=[9088999989]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(error_cdr=1)
2020-10-27 12:10:43.905900 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [error_cdr]=[1]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(callstart=2020-10-27 11:10:43)
2020-10-27 12:10:43.905900 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [callstart]=[2020-10-27 11:10:43]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(account_id=123)
2020-10-27 12:10:43.905900 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [account_id]=[123]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(parent_id=0)
2020-10-27 12:10:43.905900 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [parent_id]=[0]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(call_direction=outbound)
2020-10-27 12:10:43.905900 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [call_direction]=[outbound]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(sip_ignore_remote_cause=true)
2020-10-27 12:10:43.905900 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [sip_ignore_remote_cause]=[true]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(call_processed=internal)
2020-10-27 12:10:43.905900 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [call_processed]=[internal]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(effective_destination_number=9566364151)
2020-10-27 12:10:43.905900 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [effective_destination_number]=[9566364151]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(last_bridge_hangup_cause=ORIGNATION_RATE_NOT_FOUND)
2020-10-27 12:10:43.905900 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [last_bridge_hangup_cause]=[ORIGNATION_RATE_NOT_FOUND]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 hangup(ORIGNATION_RATE_NOT_FOUND)
2020-10-27 12:10:43.905900 [NOTICE] mod_dptools.c:1380 Hangup sofia/default/8138902220@192.168.8.6 [CS_EXECUTE] [NORMAL_CLEARING]
2020-10-27 12:10:43.905900 [DEBUG] switch_core_session.c:2905 sofia/default/8138902220@192.168.8.6 skip receive message [APPLICATION_EXEC_COMPLETE] (channel is hungup already)
2020-10-27 12:10:43.905900 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE going to sleep
2020-10-27 12:10:43.905900 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_HANGUP (Cur 1 Tot 8877)
2020-10-27 12:10:43.905900 [DEBUG] switch_core_state_machine.c:848 (sofia/default/8138902220@192.168.8.6) Callstate Change ACTIVE -> HANGUP
2020-10-27 12:10:43.905900 [DEBUG] switch_core_state_machine.c:850 (sofia/default/8138902220@192.168.8.6) State HANGUP
2020-10-27 12:10:43.905900 [DEBUG] mod_sofia.c:460 Channel sofia/default/8138902220@192.168.8.6 hanging up, cause: NORMAL_CLEARING
2020-10-27 12:10:43.905900 [DEBUG] mod_sofia.c:514 Sending BYE to sofia/default/8138902220@192.168.8.6
2020-10-27 12:10:43.905900 [DEBUG] switch_core_state_machine.c:60 sofia/default/8138902220@192.168.8.6 Standard HANGUP, cause: NORMAL_CLEARING
2020-10-27 12:10:43.905900 [DEBUG] switch_core_state_machine.c:850 (sofia/default/8138902220@192.168.8.6) State HANGUP going to sleep
2020-10-27 12:10:43.905900 [DEBUG] switch_core_state_machine.c:620 (sofia/default/8138902220@192.168.8.6) State Change CS_HANGUP -> CS_REPORTING
2020-10-27 12:10:43.905900 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_REPORTING (Cur 1 Tot 8877)
2020-10-27 12:10:43.905900 [DEBUG] switch_core_state_machine.c:936 (sofia/default/8138902220@192.168.8.6) State REPORTING
2020-10-27 12:10:43.905900 [INFO] mod_json_cdr.c:271 Process [ae154372-5007-45fa-978b-09c67b2e0b10.cdr.json]
2020-10-27 12:10:43.985802 [DEBUG] switch_core_state_machine.c:174 sofia/default/8138902220@192.168.8.6 Standard REPORTING, cause: NORMAL_CLEARING
2020-10-27 12:10:43.985802 [DEBUG] switch_core_state_machine.c:936 (sofia/default/8138902220@192.168.8.6) State REPORTING going to sleep
2020-10-27 12:10:43.985802 [DEBUG] switch_core_state_machine.c:611 (sofia/default/8138902220@192.168.8.6) State Change CS_REPORTING -> CS_DESTROY
2020-10-27 12:10:43.985802 [DEBUG] switch_core_session.c:1726 Session 8876 (sofia/default/8138902220@192.168.8.6) Locked, Waiting on external entities
2020-10-27 12:10:43.985802 [NOTICE] switch_core_session.c:1744 Session 8876 (sofia/default/8138902220@192.168.8.6) Ended
2020-10-27 12:10:43.985802 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/8138902220@192.168.8.6 [CS_DESTROY]
2020-10-27 12:10:43.985802 [DEBUG] switch_core_state_machine.c:739 (sofia/default/8138902220@192.168.8.6) Running State Change CS_DESTROY (Cur 0 Tot 8877)
2020-10-27 12:10:43.985802 [DEBUG] switch_core_state_machine.c:749 (sofia/default/8138902220@192.168.8.6) State DESTROY
2020-10-27 12:10:43.985802 [DEBUG] mod_sofia.c:365 sofia/default/8138902220@192.168.8.6 SOFIA DESTROY
2020-10-27 12:10:43.985802 [DEBUG] switch_core_state_machine.c:181 sofia/default/8138902220@192.168.8.6 Standard DESTROY
2020-10-27 12:10:43.985802 [DEBUG] switch_core_state_machine.c:749 (sofia/default/8138902220@192.168.8.6) State DESTROY going to sleep
2020-10-27 12:10:47.465802 [WARNING] switch_core_file.c:410 File has 2 channels, muxing to 1 channel will occur.
2020-10-27 12:10:53.165802 [WARNING] switch_core_file.c:410 File has 2 channels, muxing to 1 channel will occur.
2020-10-27 12:11:03.905802 [WARNING] switch_core_file.c:410 File has 2 channels, muxing to 1 channel will occur.
freeswitch@soultech> 
freeswitch@soultech> 
freeswitch@soultech> 
freeswitch@soultech> 
2020-10-27 12:11:05.565800 [NOTICE] switch_channel.c:1118 New Channel sofia/default/8138902220@192.168.8.6 [d96a1153-e817-46ae-a3bd-61b2d6bbcd0d]
2020-10-27 12:11:05.565800 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_NEW (Cur 1 Tot 8878)
2020-10-27 12:11:05.565800 [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-10-27 12:11:05.565800 [DEBUG] sofia.c:10337 verifying acl "default" for ip/port 192.168.8.6:0.
2020-10-27 12:11:05.565800 [DEBUG] sofia.c:10366 IP 192.168.8.6 Approved by acl "default[]". Access Granted.
2020-10-27 12:11:05.565800 [DEBUG] sofia.c:7290 Channel sofia/default/8138902220@192.168.8.6 entering state [received][100]
2020-10-27 12:11:05.565800 [DEBUG] sofia.c:7300 Remote SDP:
v=0
o=- 49732651 49732651 IN IP4 192.168.8.6
s=Asterisk
c=IN IP4 192.168.8.6
t=0 0
m=audio 13976 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 12:11:05.565800 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2020-10-27 12:11:05.565800 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2020-10-27 12:11:05.565800 [DEBUG] switch_core_media.c:5645 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
2020-10-27 12:11:05.565800 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2020-10-27 12:11:05.565800 [DEBUG] switch_core_media.c:5645 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2020-10-27 12:11:05.565800 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2020-10-27 12:11:05.565800 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
2020-10-27 12:11:05.565800 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1]
2020-10-27 12:11:05.565800 [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 12:11:05.565800 [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 12:11:05.565800 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2020-10-27 12:11:05.565800 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2020-10-27 12:11:05.565800 [DEBUG] switch_core_media.c:5506 Set telephone-event payload to 101@8000
2020-10-27 12:11:05.565800 [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-10-27 12:11:05.565800 [DEBUG] switch_core_codec.c:111 sofia/default/8138902220@192.168.8.6 Original read codec set to PCMU:0
2020-10-27 12:11:05.565800 [DEBUG] switch_core_media.c:5849 Set telephone-event payload to 101@8000
2020-10-27 12:11:05.565800 [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-10-27 12:11:05.565800 [DEBUG] sofia.c:7724 (sofia/default/8138902220@192.168.8.6) State Change CS_NEW -> CS_INIT
2020-10-27 12:11:05.565800 [DEBUG] switch_core_state_machine.c:604 (sofia/default/8138902220@192.168.8.6) State NEW
2020-10-27 12:11:05.565800 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_INIT (Cur 1 Tot 8878)
2020-10-27 12:11:05.565800 [DEBUG] switch_core_state_machine.c:628 (sofia/default/8138902220@192.168.8.6) State INIT
2020-10-27 12:11:05.565800 [DEBUG] mod_sofia.c:93 sofia/default/8138902220@192.168.8.6 SOFIA INIT
2020-10-27 12:11:05.565800 [DEBUG] switch_core_state_machine.c:40 sofia/default/8138902220@192.168.8.6 Standard INIT
2020-10-27 12:11:05.565800 [DEBUG] switch_core_state_machine.c:48 (sofia/default/8138902220@192.168.8.6) State Change CS_INIT -> CS_ROUTING
2020-10-27 12:11:05.565800 [DEBUG] switch_core_state_machine.c:628 (sofia/default/8138902220@192.168.8.6) State INIT going to sleep
2020-10-27 12:11:05.565800 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_ROUTING (Cur 1 Tot 8878)
2020-10-27 12:11:05.565800 [DEBUG] switch_channel.c:2332 (sofia/default/8138902220@192.168.8.6) Callstate Change DOWN -> RINGING
2020-10-27 12:11:05.565800 [DEBUG] switch_core_state_machine.c:644 (sofia/default/8138902220@192.168.8.6) State ROUTING
2020-10-27 12:11:05.565800 [DEBUG] mod_sofia.c:154 sofia/default/8138902220@192.168.8.6 SOFIA ROUTING
2020-10-27 12:11:05.565800 [DEBUG] switch_core_state_machine.c:236 sofia/default/8138902220@192.168.8.6 Standard ROUTING
2020-10-27 12:11:05.565800 [INFO] mod_dialplan_xml.c:637 Processing 8138902220 <8138902220>->9088999989 in context default
2020-10-27 12:11:05.565800 [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 12:11:05.585798 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
freeswitch@soultech> 
2020-10-27 12:11:05.625803 [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%2012%3A11%3A05
Event-Date-GMT: Tue,%2027%20Oct%202020%2011%3A11%3A05%20GMT
Event-Date-Timestamp: 1603797065565800
Event-Calling-File: mod_dialplan_xml.c
Event-Calling-Function: dialplan_xml_locate
Event-Calling-Line-Number: 608
Event-Sequence: 454506
Channel-State: CS_ROUTING
Channel-Call-State: RINGING
Channel-State-Number: 2
Channel-Name: sofia/default/8138902220%40192.168.8.6
Unique-ID: d96a1153-e817-46ae-a3bd-61b2d6bbcd0d
Call-Direction: inbound
Presence-Call-Direction: inbound
Channel-HIT-Dialplan: true
Channel-Presence-ID: 8138902220%40192.168.8.6
Channel-Call-UUID: d96a1153-e817-46ae-a3bd-61b2d6bbcd0d
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: d96a1153-e817-46ae-a3bd-61b2d6bbcd0d
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: 1603797065565800
Caller-Channel-Created-Time: 1603797065565800
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: d96a1153-e817-46ae-a3bd-61b2d6bbcd0d
variable_session_id: 8878
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: cb76c3b5-2f4e-46d5-b10d-777c42fb6183
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: 1603797065565800
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: 0c4f9baa-7528-4f59-8898-957434b5e5ab
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%3Dz9hG4bKPjbcec0b43-403a-4b9a-a6c8-45e106277d66
variable_sip_from_display: 8138902220
variable_sip_full_from: %228138902220%22%20%3Csip%3A8138902220%40192.168.8.6%3E%3Btag%3D0c4f9baa-7528-4f59-8898-957434b5e5ab
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-%2049732651%2049732651%20IN%20IP4%20192.168.8.6%0D%0As%3DAsterisk%0D%0Ac%3DIN%20IP4%20192.168.8.6%0D%0At%3D0%200%0D%0Am%3Daudio%2013976%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: 13976
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: d96a1153-e817-46ae-a3bd-61b2d6bbcd0d
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: d96a1153-e817-46ae-a3bd-61b2d6bbcd0d
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: 1603797065565800
Hunt-Channel-Created-Time: 1603797065565800
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 12:11:05.625803 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] section: dialplan
2020-10-27 12:11:05.625803 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_value: 
2020-10-27 12:11:05.625803 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_name: 
2020-10-27 12:11:05.625803 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] tag_name: 
2020-10-27 12:11:05.625803 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] blind_flag: 0
2020-10-27 12:11:05.625803 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Dialed number : 9088999989
2020-10-27 12:11:05.625803 [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 12:11:05.625803 [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 12:11:05.625803 [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 12:11:05.625803 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Caller Id name / number  : 8138902220 / 8138902220
2020-10-27 12:11:05.625803 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
2020-10-27 12:11:05.625803 [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 12:11:05.625803 [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 12:11:05.625803 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Call direction : inbound
2020-10-27 12:11:05.625803 [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 12:11:05.625803 [INFO] switch_cpp.cpp:1443 [ASTPP] [Accountcode : 1135674299]
2020-10-27 12:11:05.625803 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1
freeswitch@soultech> 
2020-10-27 12:11:05.645799 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1
2020-10-27 12:11:05.645799 [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 12:11:05.645799 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 9088999989
2020-10-27 12:11:05.645799 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
2020-10-27 12:11:05.645799 [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 12:11:05.645799 [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 12:11:05.645799 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] New Call direction : inbound
2020-10-27 12:11:05.645799 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
2020-10-27 12:11:05.645799 [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 12:11:05.645799 [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 12:11:05.645799 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] call_direction :inbound
2020-10-27 12:11:05.645799 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] DID_ACCOUNTID :138
2020-10-27 12:11:05.645799 [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 12:11:05.645799 [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-10-27 12:11:05.645799 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Call Barring Status : -1
2020-10-27 12:11:05.645799 [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 12:11:05.645799 [INFO] switch_cpp.cpp:1443 [ASTPP] =============== Account Information ===================
2020-10-27 12:11:05.645799 [INFO] switch_cpp.cpp:1443 [ASTPP] User id : 123
2020-10-27 12:11:05.645799 [INFO] switch_cpp.cpp:1443 [ASTPP] Account code : 1135674299
2020-10-27 12:11:05.645799 [INFO] switch_cpp.cpp:1443 [ASTPP] Balance : 6856.66
2020-10-27 12:11:05.645799 [INFO] switch_cpp.cpp:1443 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
2020-10-27 12:11:05.645799 [INFO] switch_cpp.cpp:1443 [ASTPP] Ratecard id : 1
2020-10-27 12:11:05.645799 [INFO] switch_cpp.cpp:1443 [ASTPP] CID Pool : 0
2020-10-27 12:11:05.645799 [INFO] switch_cpp.cpp:1443 [ASTPP] ========================================================
2020-10-27 12:11:05.645799 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
2020-10-27 12:11:05.645799 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_RATES] call_direction :inbound
2020-10-27 12:11:05.645799 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
2020-10-27 12:11:05.645799 [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 12:11:05.665803 [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 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] call_direction:::::: inbound
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] =============== Rates Information ===================
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] ID : 40
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] Connectcost : 0.00000
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] Includedseconds : 0
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] Cost : 0.00000
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] comment : 9088999989
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] Country Id : 141
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] Accid : 123
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] ================================================================
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] [FIND_MAXLENGTH] Your6856.66 balance Accountid 123 !!!
2020-10-27 12:11:05.665803 [NOTICE] switch_cpp.cpp:1443 [ASTPP] [FIND_MAXLENGTH] Call is free - assigning max length!!! :: 100
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] Call Max length duration : 100 minutes
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] INB_FREE:TRUE
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] free_inbound:1
2020-10-27 12:11:05.665803 [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 12:11:05.665803 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1
freeswitch@soultech> 
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1
freeswitch@soultech> 
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Actual CustomerInfo XML:123
freeswitch@soultech> 
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Userinfo XML:123
freeswitch@soultech> 
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Actual CustomerInfo XML : 123
freeswitch@soultech> 
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] maxlength::::::::: 100
freeswitch@soultech> 
2020-10-27 12:11:05.665803 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET domains] Query :SELECT * FROM domains WHERE accountid = 138 limit 1
freeswitch@soultech> 
2020-10-27 12:11:05.665803 [WARNING] switch_cpp.cpp:1443 [ASTPP] [user_domain] user_domaintest446.9mobile.nativetalk.com.ng
freeswitch@soultech> 
2020-10-27 12:11:05.665803 [DEBUG] switch_cpp.cpp:1443 [ASTPP] custom_function_name:::::::::::::::::::::::::custom_inbound_10
freeswitch@soultech> 
2020-10-27 12:11:05.665803 [DEBUG] switch_cpp.cpp:1443 [ASTPP] custom_function_name::::::::::1343:::::::::::::::40
freeswitch@soultech> 
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] [PBX] call_type : 10
freeswitch@soultech> 
2020-10-27 12:11:05.665803 [INFO] switch_cpp.cpp:1443 [ASTPP] [PBX] call_type : IVR
freeswitch@soultech> 
2020-10-27 12:11:05.665803 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_IVR_INFO] Query :SELECT * from pbx_ivr_specification WHERE id = 12 and status=0 LIMIT 1
freeswitch@soultech> 
2020-10-27 12:11:05.665803 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_RING_GROUP_INFO] Query :SELECT file_name from pbx_recording WHERE id = '' LIMIT 1
freeswitch@soultech> 
2020-10-27 12:11:05.665803 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<document type="freeswitch/xml">
<section name="dialplan" description="ASTPP Dialplan">
<context name="default">
<extension name="9088999989">
<condition field="destination_number" expression="9088999989">
<action application="set" data="effective_destination_number=9088999989"/>
<action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
<action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
<action application="set" data="callstart=2020-10-27 11:11:05"/>
<action application="set" data="hangup_after_bridge=true"/>
<action application="set" data="continue_on_fail=TRUE"/>
<action application="set" data="account_id=123"/>
<action application="set" data="parent_id=0"/>
<action application="set" data="entity_id=0"/>
<action application="set" data="call_processed=internal"/>
<action application="set" data="call_direction=inbound"/>
<action application="set" data="accountname=HOD1"/>
<action application="set" data="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"/>
<action application="set" data="origination_rates=0"/>
<action application="set" data="original_caller_id_name=9088999989"/>
<action application="set" data="original_caller_id_number=9088999989"/>
<action application="set" data="effective_caller_id_name=9088999989"/>
<action application="set" data="effective_caller_id_number=9088999989"/>
<action application="set" data="receiver_accid=138"/>
<action application="export" data="presence_data=x|||martins(1135674299)|||^9088999989.* // 9088999989 // 0.00000||||||DID"/>
<action application="export" data="call_type=10"/>
<action application="set" data="did_calltype=10"/>
<action application="set" data="did_extensions=12"/>
<action application="set" data="ringback="/>
<action application="set" data="module_name=pbx"/>
    <action application="answer"/>
<action application="ivr" data="iVRtest0"/>
</condition>
</extension>
</context>
</section>
</document>
freeswitch@soultech> 
Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->9088999989] continue=false
freeswitch@soultech> 
Dialplan: sofia/default/8138902220@192.168.8.6 Regex (PASS) [9088999989] destination_number(9088999989) =~ /9088999989/ break=on-false
freeswitch@soultech> 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(effective_destination_number=9088999989) 
freeswitch@soultech> 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(bridge_pre_execute_bleg_app=sched_hangup) 
freeswitch@soultech> 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing) 
freeswitch@soultech> 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(callstart=2020-10-27 11:11:05) 
freeswitch@soultech> 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(hangup_after_bridge=true) 
freeswitch@soultech> 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(continue_on_fail=TRUE) 
freeswitch@soultech> 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(account_id=123) 
freeswitch@soultech> 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(parent_id=0) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(entity_id=0) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(call_processed=internal) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(call_direction=inbound) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(accountname=HOD1) 
Dialplan: sofia/default/8138902220@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/8138902220@192.168.8.6 Action set(origination_rates=0) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(original_caller_id_name=9088999989) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(original_caller_id_number=9088999989) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(effective_caller_id_name=9088999989) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(effective_caller_id_number=9088999989) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(receiver_accid=138) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action export(presence_data=x|||martins(1135674299)|||^9088999989.* // 9088999989 // 0.00000||||||DID) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action export(call_type=10) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(did_calltype=10) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(did_extensions=12) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(ringback=) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(module_name=pbx) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action answer() 
Dialplan: sofia/default/8138902220@192.168.8.6 Action ivr(iVRtest0) 
2020-10-27 12:11:05.665803 [DEBUG] switch_core_state_machine.c:287 (sofia/default/8138902220@192.168.8.6) State Change CS_ROUTING -> CS_EXECUTE
2020-10-27 12:11:05.665803 [DEBUG] switch_core_state_machine.c:644 (sofia/default/8138902220@192.168.8.6) State ROUTING going to sleep
2020-10-27 12:11:05.665803 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_EXECUTE (Cur 1 Tot 8878)
2020-10-27 12:11:05.665803 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE
2020-10-27 12:11:05.665803 [DEBUG] mod_sofia.c:209 sofia/default/8138902220@192.168.8.6 SOFIA EXECUTE
2020-10-27 12:11:05.665803 [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 set(effective_destination_number=9088999989)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [effective_destination_number]=[9088999989]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(bridge_pre_execute_bleg_app=sched_hangup)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [bridge_pre_execute_bleg_app]=[sched_hangup]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [bridge_pre_execute_bleg_data]=[+6000 normal_clearing]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(callstart=2020-10-27 11:11:05)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [callstart]=[2020-10-27 11:11:05]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(hangup_after_bridge=true)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [hangup_after_bridge]=[true]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(continue_on_fail=TRUE)
2020-10-27 12:11:05.665803 [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(account_id=123)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [account_id]=[123]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(parent_id=0)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [parent_id]=[0]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(entity_id=0)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [entity_id]=[0]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(call_processed=internal)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [call_processed]=[internal]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(call_direction=inbound)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [call_direction]=[inbound]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(accountname=HOD1)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [accountname]=[HOD1]
EXECUTE [depth=0] sofia/default/8138902220@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 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@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/8138902220@192.168.8.6 set(origination_rates=0)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [origination_rates]=[0]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(original_caller_id_name=9088999989)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [original_caller_id_name]=[9088999989]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(original_caller_id_number=9088999989)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [original_caller_id_number]=[9088999989]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(effective_caller_id_name=9088999989)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [effective_caller_id_name]=[9088999989]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(effective_caller_id_number=9088999989)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [effective_caller_id_number]=[9088999989]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(receiver_accid=138)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [receiver_accid]=[138]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 export(presence_data=x|||martins(1135674299)|||^9088999989.* // 9088999989 // 0.00000||||||DID)
2020-10-27 12:11:05.665803 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_data]=[x|||martins(1135674299)|||^9088999989.* // 9088999989 // 0.00000||||||DID]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 export(call_type=10)
2020-10-27 12:11:05.665803 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [call_type]=[10]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(did_calltype=10)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [did_calltype]=[10]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(did_extensions=12)
2020-10-27 12:11:05.665803 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [did_extensions]=[12]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(ringback=)
2020-10-27 12:11:05.685813 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [ringback]=[UNDEF]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(module_name=pbx)
2020-10-27 12:11:05.685813 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [module_name]=[pbx]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 answer()
2020-10-27 12:11:05.685813 [DEBUG] switch_core_media.c:8658 AUDIO RTP [sofia/default/8138902220@192.168.8.6] 192.168.8.3 port 16826 -> 192.168.8.6 port 13976 codec: 0 ms: 20
2020-10-27 12:11:05.685813 [DEBUG] switch_rtp.c:4408 Starting timer [soft] 160 bytes per 20ms
2020-10-27 12:11:05.685813 [DEBUG] switch_core_media.c:8972 sofia/default/8138902220@192.168.8.6 Set 2833 dtmf send payload to 101
2020-10-27 12:11:05.685813 [DEBUG] switch_core_media.c:8979 sofia/default/8138902220@192.168.8.6 Set 2833 dtmf receive payload to 101
2020-10-27 12:11:05.685813 [DEBUG] switch_core_media.c:9002 sofia/default/8138902220@192.168.8.6 Set rtp dtmf delay to 40
2020-10-27 12:11:05.685813 [DEBUG] mod_sofia.c:905 Local SDP sofia/default/8138902220@192.168.8.6:
v=0
o=FreeSWITCH 1603780239 1603780240 IN IP4 192.168.8.3
s=FreeSWITCH
c=IN IP4 192.168.8.3
t=0 0
m=audio 16826 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 12:11:05.685813 [NOTICE] mod_dptools.c:1406 Channel [sofia/default/8138902220@192.168.8.6] has been answered
2020-10-27 12:11:05.685813 [DEBUG] switch_channel.c:3865 (sofia/default/8138902220@192.168.8.6) Callstate Change RINGING -> ACTIVE
2020-10-27 12:11:05.685813 [DEBUG] sofia.c:7290 Channel sofia/default/8138902220@192.168.8.6 entering state [completed][200]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 ivr(iVRtest0)
freeswitch@soultech> 
2020-10-27 12:11:05.725796 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-exit'
2020-10-27 12:11:05.725796 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-sub'
2020-10-27 12:11:05.725796 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-exec-app'
2020-10-27 12:11:05.725796 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-play-sound'
2020-10-27 12:11:05.725796 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-back'
2020-10-27 12:11:05.725796 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-top'
2020-10-27 12:11:05.725796 [DEBUG] switch_ivr_menu.c:883 building menu 'iVRtest0'
2020-10-27 12:11:05.725796 [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '1'
2020-10-27 12:11:05.725796 [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '2'
2020-10-27 12:11:05.725796 [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '3'
2020-10-27 12:11:05.725796 [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '/^(\d{2,20})$/'
2020-10-27 12:11:05.725796 [DEBUG] switch_ivr_menu.c:486 Executing IVR menu iVRtest0
2020-10-27 12:11:05.725796 [DEBUG] sofia.c:7290 Channel sofia/default/8138902220@192.168.8.6 entering state [ready][200]
2020-10-27 12:11:05.725796 [DEBUG] switch_ivr_play_say.c:1492 Codec Activated L16@8000hz 1 channels 20ms
freeswitch@soultech> 
freeswitch@soultech> 
freeswitch@soultech> 
freeswitch@soultech> 
freeswitch@soultech> 
2020-10-27 12:11:06.065802 [DEBUG] switch_rtp.c:7720 Correct audio ip/port confirmed.
2020-10-27 12:11:11.625801 [WARNING] switch_core_file.c:410 File has 2 channels, muxing to 1 channel will occur.
2020-10-27 12:11:17.325813 [WARNING] switch_core_file.c:410 File has 2 channels, muxing to 1 channel will occur.
2020-10-27 12:11:23.365800 [DEBUG] switch_ivr_play_say.c:1933 done playing file /var/www/html/astpp/upload/pbx/ivr(2)_211020121726.wav
2020-10-27 12:11:23.365800 [DEBUG] switch_ivr_menu.c:378 waiting for 20/20 digits t/o 2000
2020-10-27 12:11:24.905896 [DEBUG] switch_rtp.c:7963 RTP RECV DTMF 1:1448
2020-10-27 12:11:24.905896 [INFO] switch_channel.c:522 RECV DTMF 1:1448
2020-10-27 12:11:26.925800 [DEBUG] switch_ivr_menu.c:425 digits '1'
2020-10-27 12:11:26.925800 [DEBUG] switch_ivr_menu.c:580 IVR action on menu 'iVRtest0' matched '1' param 'transfer 6350951709 XML ${domain_name}'
2020-10-27 12:11:26.925800 [DEBUG] switch_ivr_menu.c:584 switch_ivr_menu_execute todo=[2]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 transfer(6350951709 XML 192.168.8.3)
2020-10-27 12:11:26.925800 [DEBUG] switch_ivr.c:2231 (sofia/default/8138902220@192.168.8.6) State Change CS_EXECUTE -> CS_ROUTING
2020-10-27 12:11:26.925800 [NOTICE] switch_ivr.c:2238 Transfer sofia/default/8138902220@192.168.8.6 to XML[6350951709@192.168.8.3]
2020-10-27 12:11:26.925800 [DEBUG] switch_ivr_menu.c:562 action regex [1] [/^(\d{2,20})$/] [0]
2020-10-27 12:11:26.925800 [DEBUG] switch_ivr_menu.c:676 exit-sound 'voicemail/vm-goodbye.wav'
2020-10-27 12:11:26.925800 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE going to sleep
2020-10-27 12:11:26.925800 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_ROUTING (Cur 1 Tot 8878)
2020-10-27 12:11:26.925800 [DEBUG] switch_channel.c:2332 (sofia/default/8138902220@192.168.8.6) Callstate Change ACTIVE -> RINGING
2020-10-27 12:11:26.925800 [DEBUG] switch_core_state_machine.c:644 (sofia/default/8138902220@192.168.8.6) State ROUTING
2020-10-27 12:11:26.925800 [DEBUG] mod_sofia.c:154 sofia/default/8138902220@192.168.8.6 SOFIA ROUTING
2020-10-27 12:11:26.925800 [DEBUG] switch_core_state_machine.c:236 sofia/default/8138902220@192.168.8.6 Standard ROUTING
2020-10-27 12:11:26.925800 [INFO] mod_dialplan_xml.c:637 Processing 8138902220 <8138902220>->6350951709 in context 192.168.8.3
2020-10-27 12:11:26.925800 [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 12:11:26.925800 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2020-10-27 12:11:26.965835 [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%2012%3A11%3A26
Event-Date-GMT: Tue,%2027%20Oct%202020%2011%3A11%3A26%20GMT
Event-Date-Timestamp: 1603797086925800
Event-Calling-File: mod_dialplan_xml.c
Event-Calling-Function: dialplan_xml_locate
Event-Calling-Line-Number: 608
Event-Sequence: 454581
Channel-State: CS_ROUTING
Channel-Call-State: RINGING
Channel-State-Number: 2
Channel-Name: sofia/default/8138902220%40192.168.8.6
Unique-ID: d96a1153-e817-46ae-a3bd-61b2d6bbcd0d
Call-Direction: inbound
Presence-Call-Direction: inbound
Channel-HIT-Dialplan: true
Channel-Presence-ID: 8138902220%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: d96a1153-e817-46ae-a3bd-61b2d6bbcd0d
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: 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: 6350951709
Caller-Unique-ID: d96a1153-e817-46ae-a3bd-61b2d6bbcd0d
Caller-Source: mod_sofia
Caller-Transfer-Source: 1603797086%3Ae66f24eb-b321-4e34-bbc5-e1c2a7201d2e%3Abl_xfer%3A6350951709/192.168.8.3/XML
Caller-Context: 192.168.8.3
Caller-RDNIS: 9088999989
Caller-Channel-Name: sofia/default/8138902220%40192.168.8.6
Caller-Profile-Index: 2
Caller-Profile-Created-Time: 1603797086925800
Caller-Channel-Created-Time: 1603797065565800
Caller-Channel-Answered-Time: 1603797065685813
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: d96a1153-e817-46ae-a3bd-61b2d6bbcd0d
variable_session_id: 8878
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_local_network_addr: 192.168.8.3
variable_sip_network_ip: 192.168.8.6
variable_sip_network_port: 5060
variable_sip_invite_stamp: 1603797065565800
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_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: 8138902220%40192.168.8.6
variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%2049732651%2049732651%20IN%20IP4%20192.168.8.6%0D%0As%3DAsterisk%0D%0Ac%3DIN%20IP4%20192.168.8.6%0D%0At%3D0%200%0D%0Am%3Daudio%2013976%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%2011%3A11%3A05
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%201603780239%201603780240%20IN%20IP4%20192.168.8.3%0D%0As%3DFreeSWITCH%0D%0Ac%3DIN%20IP4%20192.168.8.3%0D%0At%3D0%200%0D%0Am%3Daudio%2016826%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: 16826
variable_advertised_media_ip: 192.168.8.3
variable_rtp_use_timer_name: soft
variable_rtp_use_pt: 0
variable_rtp_use_ssrc: 64039153
variable_rtp_2833_send_payload: 101
variable_rtp_2833_recv_payload: 101
variable_remote_media_ip: 192.168.8.6
variable_remote_media_port: 13976
variable_endpoint_disposition: ANSWER
variable_ivr_menu_status: success
variable_sip_to_tag: 3ep0jv9jFaFaS
variable_sip_from_tag: 0c4f9baa-7528-4f59-8898-957434b5e5ab
variable_sip_cseq: 24960
variable_sip_call_id: cb76c3b5-2f4e-46d5-b10d-777c42fb6183
variable_sip_full_via: SIP/2.0/UDP%20192.168.8.6%3A5060%3Brport%3D5060%3Bbranch%3Dz9hG4bKPjf39f7ed4-cb6b-4c0a-b7ec-a38ebad02edf
variable_sip_from_display: 8138902220
variable_sip_full_from: %228138902220%22%20%3Csip%3A8138902220%40192.168.8.6%3E%3Btag%3D0c4f9baa-7528-4f59-8898-957434b5e5ab
variable_sip_full_to: %3Csip%3A9088999989%40192.168.8.3%3E%3Btag%3D3ep0jv9jFaFaS
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: 1603797086%3Ae66f24eb-b321-4e34-bbc5-e1c2a7201d2e%3Abl_xfer%3A6350951709/192.168.8.3/XML
variable_transfer_source: 1603797086%3Ae66f24eb-b321-4e34-bbc5-e1c2a7201d2e%3Abl_xfer%3A6350951709/192.168.8.3/XML
variable_call_uuid: d96a1153-e817-46ae-a3bd-61b2d6bbcd0d
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: 6350951709
Hunt-Unique-ID: d96a1153-e817-46ae-a3bd-61b2d6bbcd0d
Hunt-Source: mod_sofia
Hunt-Transfer-Source: 1603797086%3Ae66f24eb-b321-4e34-bbc5-e1c2a7201d2e%3Abl_xfer%3A6350951709/192.168.8.3/XML
Hunt-Context: 192.168.8.3
Hunt-RDNIS: 9088999989
Hunt-Channel-Name: sofia/default/8138902220%40192.168.8.6
Hunt-Profile-Index: 2
Hunt-Profile-Created-Time: 1603797086925800
Hunt-Channel-Created-Time: 1603797065565800
Hunt-Channel-Answered-Time: 1603797065685813
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 12:11:26.965835 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_value: 
2020-10-27 12:11:26.965835 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_name: 
2020-10-27 12:11:26.965835 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] tag_name: 
2020-10-27 12:11:26.965835 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] section: dialplan
2020-10-27 12:11:26.985806 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] blind_flag: 0
2020-10-27 12:11:26.985806 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Dialed number : 6350951709
2020-10-27 12:11:26.985806 [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 12:11:26.985806 [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 12:11:26.985806 [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 12:11:26.985806 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Caller Id name / number  : 9088999989 / 9088999989
2020-10-27 12:11:26.985806 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
2020-10-27 12:11:26.985806 [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 12:11:26.985806 [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 12:11:26.985806 [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 12:11:26.985806 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Call direction : outbound
2020-10-27 12:11:26.985806 [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 12:11:26.985806 [INFO] switch_cpp.cpp:1443 [ASTPP] [Accountcode : 1135674299]
2020-10-27 12:11:26.985806 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1
2020-10-27 12:11:27.005813 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1
2020-10-27 12:11:27.005813 [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 12:11:27.005813 [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 12:11:27.005813 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 6350951709
2020-10-27 12:11:27.005813 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
2020-10-27 12:11:27.005813 [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 12:11:27.005813 [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 12:11:27.005813 [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 12:11:27.005813 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] New Call direction : outbound
2020-10-27 12:11:27.005813 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
2020-10-27 12:11:27.005813 [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 12:11:27.005813 [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 12:11:27.005813 [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 12:11:27.005813 [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 12:11:27.005813 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Call Barring Status : -1
2020-10-27 12:11:27.005813 [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 12:11:27.005813 [INFO] switch_cpp.cpp:1443 [ASTPP] =============== Account Information ===================
2020-10-27 12:11:27.005813 [INFO] switch_cpp.cpp:1443 [ASTPP] User id : 123
2020-10-27 12:11:27.005813 [INFO] switch_cpp.cpp:1443 [ASTPP] Account code : 1135674299
2020-10-27 12:11:27.005813 [INFO] switch_cpp.cpp:1443 [ASTPP] Balance : 6856.66
2020-10-27 12:11:27.005813 [INFO] switch_cpp.cpp:1443 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
2020-10-27 12:11:27.005813 [INFO] switch_cpp.cpp:1443 [ASTPP] Ratecard id : 1
2020-10-27 12:11:27.005813 [INFO] switch_cpp.cpp:1443 [ASTPP] CID Pool : 0
2020-10-27 12:11:27.005813 [INFO] switch_cpp.cpp:1443 [ASTPP] ========================================================
2020-10-27 12:11:27.005813 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
2020-10-27 12:11:27.005813 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_RATES] call_direction :outbound
2020-10-27 12:11:27.005813 [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 12:11:27.005813 [INFO] switch_cpp.cpp:1443 [ASTPP] call_direction:::::: outbound
2020-10-27 12:11:27.005813 [WARNING] switch_cpp.cpp:1443 [ASTPP] [FIND_MAXLENGTH] Rates not found!!!
2020-10-27 12:11:27.005813 [DEBUG] switch_cpp.cpp:1443 [ASTPP] post_cdrs:::0
2020-10-27 12:11:27.005813 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET RESELLERID] Query :SELECT reseller_id FROM accounts WHERE id = 123
2020-10-27 12:11:27.005813 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Generated XML:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<document type="freeswitch/xml">
<section name="dialplan" description="ASTPP Dialplan">
<context name="192.168.8.3">
<extension name="6350951709">
<condition field="destination_number" expression="6350951709">
<action application="log" data="WARNING Accountcode . Dialed number (6350951709)  origination rates not found!!"/>
<action application="set" data="original_caller_id_name=9088999989"/>
<action application="set" data="original_caller_id_number=9088999989"/>
<action application="set" data="error_cdr=1"/>
<action application="set" data="callstart=2020-10-27 11:11:27"/>
<action application="set" data="account_id=123"/>
<action application="set" data="parent_id=0"/>
<action application="set" data="call_direction=outbound"/>
<action application="set" data="sip_ignore_remote_cause=true"/>
<action application="set" data="call_processed=internal"/>
<action application="set" data="effective_destination_number=6350951709"/>
<action application="set" data="last_bridge_hangup_cause=ORIGNATION_RATE_NOT_FOUND"/>
<action application="hangup" data="ORIGNATION_RATE_NOT_FOUND"/>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/default/8138902220@192.168.8.6 parsing [192.168.8.3->6350951709] continue=false
Dialplan: sofia/default/8138902220@192.168.8.6 Regex (PASS) [6350951709] destination_number(6350951709) =~ /6350951709/ break=on-false
Dialplan: sofia/default/8138902220@192.168.8.6 Action log(WARNING Accountcode . Dialed number (6350951709)  origination rates not found!!) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(original_caller_id_name=9088999989) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(original_caller_id_number=9088999989) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(error_cdr=1) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(callstart=2020-10-27 11:11:27) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(account_id=123) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(parent_id=0) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(call_direction=outbound) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(sip_ignore_remote_cause=true) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(call_processed=internal) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(effective_destination_number=6350951709) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action set(last_bridge_hangup_cause=ORIGNATION_RATE_NOT_FOUND) 
Dialplan: sofia/default/8138902220@192.168.8.6 Action hangup(ORIGNATION_RATE_NOT_FOUND) 
2020-10-27 12:11:27.005813 [DEBUG] switch_core_state_machine.c:287 (sofia/default/8138902220@192.168.8.6) State Change CS_ROUTING -> CS_EXECUTE
2020-10-27 12:11:27.005813 [DEBUG] switch_core_state_machine.c:644 (sofia/default/8138902220@192.168.8.6) State ROUTING going to sleep
2020-10-27 12:11:27.005813 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_EXECUTE (Cur 1 Tot 8878)
2020-10-27 12:11:27.005813 [DEBUG] switch_channel.c:2334 (sofia/default/8138902220@192.168.8.6) Callstate Change RINGING -> ACTIVE
2020-10-27 12:11:27.005813 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE
2020-10-27 12:11:27.005813 [DEBUG] mod_sofia.c:209 sofia/default/8138902220@192.168.8.6 SOFIA EXECUTE
2020-10-27 12:11:27.005813 [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 log(WARNING Accountcode . Dialed number (6350951709)  origination rates not found!!)
2020-10-27 12:11:27.005813 [WARNING] mod_dptools.c:1866 Accountcode . Dialed number (6350951709)  origination rates not found!!
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(original_caller_id_name=9088999989)
2020-10-27 12:11:27.005813 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [original_caller_id_name]=[9088999989]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(original_caller_id_number=9088999989)
2020-10-27 12:11:27.005813 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [original_caller_id_number]=[9088999989]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(error_cdr=1)
2020-10-27 12:11:27.005813 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [error_cdr]=[1]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(callstart=2020-10-27 11:11:27)
2020-10-27 12:11:27.005813 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [callstart]=[2020-10-27 11:11:27]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(account_id=123)
2020-10-27 12:11:27.025811 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [account_id]=[123]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(parent_id=0)
2020-10-27 12:11:27.025811 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [parent_id]=[0]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(call_direction=outbound)
2020-10-27 12:11:27.025811 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [call_direction]=[outbound]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(sip_ignore_remote_cause=true)
2020-10-27 12:11:27.025811 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [sip_ignore_remote_cause]=[true]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(call_processed=internal)
2020-10-27 12:11:27.025811 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [call_processed]=[internal]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(effective_destination_number=6350951709)
2020-10-27 12:11:27.025811 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [effective_destination_number]=[6350951709]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(last_bridge_hangup_cause=ORIGNATION_RATE_NOT_FOUND)
2020-10-27 12:11:27.025811 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [last_bridge_hangup_cause]=[ORIGNATION_RATE_NOT_FOUND]
EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 hangup(ORIGNATION_RATE_NOT_FOUND)
2020-10-27 12:11:27.025811 [NOTICE] mod_dptools.c:1380 Hangup sofia/default/8138902220@192.168.8.6 [CS_EXECUTE] [NORMAL_CLEARING]
2020-10-27 12:11:27.025811 [DEBUG] switch_core_session.c:2905 sofia/default/8138902220@192.168.8.6 skip receive message [APPLICATION_EXEC_COMPLETE] (channel is hungup already)
2020-10-27 12:11:27.025811 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE going to sleep
2020-10-27 12:11:27.025811 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_HANGUP (Cur 1 Tot 8878)
2020-10-27 12:11:27.025811 [DEBUG] switch_core_state_machine.c:848 (sofia/default/8138902220@192.168.8.6) Callstate Change ACTIVE -> HANGUP
2020-10-27 12:11:27.025811 [DEBUG] switch_core_state_machine.c:850 (sofia/default/8138902220@192.168.8.6) State HANGUP
2020-10-27 12:11:27.025811 [DEBUG] mod_sofia.c:460 Channel sofia/default/8138902220@192.168.8.6 hanging up, cause: NORMAL_CLEARING
2020-10-27 12:11:27.025811 [DEBUG] mod_sofia.c:514 Sending BYE to sofia/default/8138902220@192.168.8.6
2020-10-27 12:11:27.025811 [DEBUG] switch_core_state_machine.c:60 sofia/default/8138902220@192.168.8.6 Standard HANGUP, cause: NORMAL_CLEARING
2020-10-27 12:11:27.025811 [DEBUG] switch_core_state_machine.c:850 (sofia/default/8138902220@192.168.8.6) State HANGUP going to sleep
2020-10-27 12:11:27.025811 [DEBUG] switch_core_state_machine.c:620 (sofia/default/8138902220@192.168.8.6) State Change CS_HANGUP -> CS_REPORTING
2020-10-27 12:11:27.025811 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_REPORTING (Cur 1 Tot 8878)
2020-10-27 12:11:27.025811 [DEBUG] switch_core_state_machine.c:936 (sofia/default/8138902220@192.168.8.6) State REPORTING
2020-10-27 12:11:27.025811 [INFO] mod_json_cdr.c:271 Process [d96a1153-e817-46ae-a3bd-61b2d6bbcd0d.cdr.json]
2020-10-27 12:11:27.065827 [WARNING] switch_core_file.c:410 File has 2 channels, muxing to 1 channel will occur.
2020-10-27 12:11:27.085813 [DEBUG] switch_core_state_machine.c:174 sofia/default/8138902220@192.168.8.6 Standard REPORTING, cause: NORMAL_CLEARING
2020-10-27 12:11:27.085813 [DEBUG] switch_core_state_machine.c:936 (sofia/default/8138902220@192.168.8.6) State REPORTING going to sleep
2020-10-27 12:11:27.085813 [DEBUG] switch_core_state_machine.c:611 (sofia/default/8138902220@192.168.8.6) State Change CS_REPORTING -> CS_DESTROY
2020-10-27 12:11:27.085813 [DEBUG] switch_core_session.c:1726 Session 8878 (sofia/default/8138902220@192.168.8.6) Locked, Waiting on external entities
2020-10-27 12:11:27.085813 [NOTICE] switch_core_session.c:1744 Session 8878 (sofia/default/8138902220@192.168.8.6) Ended
2020-10-27 12:11:27.085813 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/8138902220@192.168.8.6 [CS_DESTROY]
2020-10-27 12:11:27.085813 [DEBUG] switch_core_state_machine.c:739 (sofia/default/8138902220@192.168.8.6) Running State Change CS_DESTROY (Cur 0 Tot 8878)
2020-10-27 12:11:27.085813 [DEBUG] switch_core_state_machine.c:749 (sofia/default/8138902220@192.168.8.6) State DESTROY
2020-10-27 12:11:27.085813 [DEBUG] mod_sofia.c:365 sofia/default/8138902220@192.168.8.6 SOFIA DESTROY
2020-10-27 12:11:27.085813 [DEBUG] switch_core_state_machine.c:181 sofia/default/8138902220@192.168.8.6 Standard DESTROY
2020-10-27 12:11:27.085813 [DEBUG] switch_core_state_machine.c:749 (sofia/default/8138902220@192.168.8.6) State DESTROY going to sleep