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