2024-10-21 08:03:32.246442 99.93% [DEBUG] mod_nibblebill.c:695 Received request via SESSION_HEARTBEAT!
2024-10-21 08:03:32.246442 99.93% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.00000 per minute to account 10401
2024-10-21 08:03:32.246442 99.93% [DEBUG] mod_nibblebill.c:573 59 seconds passed since last bill time of 2024-10-21 08:02:33
2024-10-21 08:03:32.246442 99.93% [DEBUG] mod_nibblebill.c:590 Billing $0.000000 to 10401 (Call: 9efbada1-f4ac-4478-9f88-aef0ba33056b / 0.000000 so far)
2024-10-21 08:03:32.246442 99.93% [DEBUG] mod_nibblebill.c:395 Doing update query
[Update accounts SET balance=IF(posttoexternal=1,balance+0.000000,balance-0.000000) WHERE id='10401']
2024-10-21 08:03:32.326445 99.93% [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='10401']
2024-10-21 08:03:32.386438 99.93% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 10401 (balance = 1.988000)
2024-10-21 08:03:35.906429 99.97% [NOTICE] switch_channel.c:1123 New Channel sofia/default/6089139952@Tal4812.newsip.israelnumber.com [686e5f00-7d8d-433a-b743-e73a1976a934]
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_state_machine.c:581 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) Running State Change CS_NEW (Cur 3 Tot 228326)
2024-10-21 08:03:35.906429 99.97% [INFO] sofia.c:10462 sofia/default/6089139952@Tal4812.newsip.israelnumber.com receiving invite from 195.201.136.94:5060 version: 1.10.7 -release-19-883d2cb662 64bit call-id: nf6CLqk44F7u3_35xQZjsw..
2024-10-21 08:03:35.906429 99.97% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 195.201.136.94:0.
2024-10-21 08:03:35.906429 99.97% [DEBUG] sofia.c:10585 IP 195.201.136.94 Approved by acl "default[]". Access Granted.
2024-10-21 08:03:35.906429 99.97% [DEBUG] sofia.c:7499 Channel sofia/default/6089139952@Tal4812.newsip.israelnumber.com entering state [received][100]
2024-10-21 08:03:35.906429 99.97% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=Z 0 141507250 IN IP4 5.9.133.123
s=Z
c=IN IP4 5.9.133.123
t=0 0
m=audio 55787 RTP/AVP 106 9 0 8 3
a=rtpmap:106 opus/48000/2
a=fmtp:106 sprop-maxcapturerate=16000; minptime=20; useinbandfec=1
a=rtcp-mux
a=oldoip:10.7.0.7
a=oldcip:10.7.0.7
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMA:8:8000:20:64000:1]
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMU:0:8000:20:64000:1]
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1]
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/6089139952@Tal4812.newsip.israelnumber.com PCMU/8000 20 ms 160 samples 64000 bits 1 channels
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_codec.c:111 sofia/default/6089139952@Tal4812.newsip.israelnumber.com Original read codec set to PCMU:0
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_media.c:5944 No 2833 in SDP. Liberal DTMF mode adding 101 as telephone-event.
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_media.c:5973 sofia/default/6089139952@Tal4812.newsip.israelnumber.com Set 2833 dtmf send payload to 101 recv payload to 101
2024-10-21 08:03:35.906429 99.97% [DEBUG] sofia.c:7933 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State Change CS_NEW -> CS_INIT
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_state_machine.c:600 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State NEW
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_state_machine.c:581 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) Running State Change CS_INIT (Cur 3 Tot 228326)
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_state_machine.c:624 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State INIT
2024-10-21 08:03:35.906429 99.97% [DEBUG] mod_sofia.c:97 sofia/default/6089139952@Tal4812.newsip.israelnumber.com SOFIA INIT
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_state_machine.c:40 sofia/default/6089139952@Tal4812.newsip.israelnumber.com Standard INIT
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_state_machine.c:48 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State Change CS_INIT -> CS_ROUTING
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_state_machine.c:624 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State INIT going to sleep
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_state_machine.c:581 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) Running State Change CS_ROUTING (Cur 3 Tot 228326)
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_channel.c:2380 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) Callstate Change DOWN -> RINGING
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_state_machine.c:640 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State ROUTING
2024-10-21 08:03:35.906429 99.97% [DEBUG] mod_sofia.c:158 sofia/default/6089139952@Tal4812.newsip.israelnumber.com SOFIA ROUTING
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_core_state_machine.c:230 sofia/default/6089139952@Tal4812.newsip.israelnumber.com Standard ROUTING
2024-10-21 08:03:35.906429 99.97% [INFO] mod_dialplan_xml.c:639 Processing 6089139952 <6089139952>->982181000 in context default
2024-10-21 08:03:35.906429 99.97% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
2024-10-21 08:03:35.986445 99.97% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2024-10-21 08:03:36.066438 99.93% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [xml_handler] Params:
Event-Name: REQUEST_PARAMS
Core-UUID: faa4212a-3e04-40df-af96-0ad775555638
FreeSWITCH-Hostname: fs-slave
FreeSWITCH-Switchname: fs-slave
FreeSWITCH-IPv4: 95.217.164.101
FreeSWITCH-IPv6: 2a01%3A4f9%3Ac011%3A94fe%3A%3A1
Event-Date-Local: 2024-10-21%2008%3A03%3A35
Event-Date-GMT: Mon,%2021%20Oct%202024%2008%3A03%3A35%20GMT
Event-Date-Timestamp: 1729497815906429
Event-Calling-File: mod_dialplan_xml.c
Event-Calling-Function: dialplan_xml_locate
Event-Calling-Line-Number: 610
Event-Sequence: 17474756
Channel-State: CS_ROUTING
Channel-Call-State: RINGING
Channel-State-Number: 2
Channel-Name: sofia/default/6089139952%40Tal4812.newsip.israelnumber.com
Unique-ID: 686e5f00-7d8d-433a-b743-e73a1976a934
Call-Direction: inbound
Presence-Call-Direction: inbound
Channel-HIT-Dialplan: true
Channel-Presence-ID: 6089139952%40Tal4812.newsip.israelnumber.com
Channel-Call-UUID: 686e5f00-7d8d-433a-b743-e73a1976a934
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: 6089139952
Caller-Dialplan: XML
Caller-Caller-ID-Name: 6089139952
Caller-Caller-ID-Number: 6089139952
Caller-Orig-Caller-ID-Name: 6089139952
Caller-Orig-Caller-ID-Number: 6089139952
Caller-Network-Addr: 195.201.136.94
Caller-ANI: 6089139952
Caller-Destination-Number: 982181000
Caller-Unique-ID: 686e5f00-7d8d-433a-b743-e73a1976a934
Caller-Source: mod_sofia
Caller-Context: default
Caller-Channel-Name: sofia/default/6089139952%40Tal4812.newsip.israelnumber.com
Caller-Profile-Index: 1
Caller-Profile-Created-Time: 1729497815906429
Caller-Channel-Created-Time: 1729497815906429
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: 686e5f00-7d8d-433a-b743-e73a1976a934
variable_session_id: 228326
variable_sip_from_params: transport%3DUDP
variable_sip_from_user: 6089139952
variable_sip_from_uri: 6089139952%40Tal4812.newsip.israelnumber.com
variable_sip_from_host: Tal4812.newsip.israelnumber.com
variable_video_media_flow: disabled
variable_text_media_flow: disabled
variable_channel_name: sofia/default/6089139952%40Tal4812.newsip.israelnumber.com
variable_sip_call_id: nf6CLqk44F7u3_35xQZjsw..
variable_sip_local_network_addr: 95.217.164.101
variable_sip_network_ip: 195.201.136.94
variable_sip_network_port: 5060
variable_sip_invite_stamp: 1729497815906429
variable_sip_received_ip: 195.201.136.94
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: 6089139952
variable_sip_from_tag: e0009d6f
variable_sofia_profile_name: default
variable_sofia_profile_url: sip%3Amod_sofia%4095.217.164.101%3A5060
variable_recovery_profile_name: default
variable_sip_invite_route_uri: %3Csip%3A195.201.136.94%3Blr%3Bdid%3D96.63bf65e%3E
variable_sip_invite_record_route: %3Csip%3A195.201.136.94%3Blr%3Bdid%3D96.63bf65e%3E
variable_sip_full_via: SIP/2.0/UDP%20195.201.136.94%3A5060%3Bbranch%3Dz9hG4bK0a03.910f69f6.0,SIP/2.0/UDP%2010.7.0.7%3A49634%3Breceived%3D5.9.133.123%3Bbranch%3Dz9hG4bK-524287-1---3f64dd53948c4734%3Brport%3D49634
variable_sip_full_from: %3Csip%3A6089139952%40Tal4812.newsip.israelnumber.com%3Btransport%3DUDP%3E%3Btag%3De0009d6f
variable_sip_full_to: %3Csip%3A982181000%40Tal4812.newsip.israelnumber.com%3E
variable_sip_allow: INVITE,%20ACK,%20CANCEL,%20BYE,%20NOTIFY,%20REFER,%20MESSAGE,%20OPTIONS,%20INFO,%20SUBSCRIBE
variable_sip_req_params: transport%3DUDP
variable_sip_req_user: 982181000
variable_sip_req_uri: 982181000%40Tal4812.newsip.israelnumber.com
variable_sip_req_host: Tal4812.newsip.israelnumber.com
variable_sip_to_user: 982181000
variable_sip_to_uri: 982181000%40Tal4812.newsip.israelnumber.com
variable_sip_to_host: Tal4812.newsip.israelnumber.com
variable_sip_contact_params: transport%3DUDP
variable_sip_contact_user: 6089139952
variable_sip_contact_port: 49634
variable_sip_contact_uri: 6089139952%405.9.133.123%3A49634
variable_sip_contact_host: 5.9.133.123
variable_sip_user_agent: Z%205.6.1%20v2.10.19.9
variable_sip_via_host: 195.201.136.94
variable_sip_via_port: 5060
variable_max_forwards: 30
variable_presence_id: 6089139952%40Tal4812.newsip.israelnumber.com
variable_sip_h_X-AUTH-IP: 5.9.133.123
variable_sip_h_P-Accountcode: 972702853016465
variable_sip_h_P-effective_caller_id_name: 6089139952
variable_sip_h_P-effective_caller_id_number: 6089139952
variable_switch_r_sdp: v%3D0%0D%0Ao%3DZ%200%20141507250%20IN%20IP4%205.9.133.123%0D%0As%3DZ%0D%0Ac%3DIN%20IP4%205.9.133.123%0D%0At%3D0%200%0D%0Am%3Daudio%2055787%20RTP/AVP%20106%209%200%208%203%0D%0Aa%3Drtpmap%3A106%20opus/48000/2%0D%0Aa%3Dfmtp%3A106%20sprop-maxcapturerate%3D16000%3B%20minptime%3D20%3B%20useinbandfec%3D1%0D%0Aa%3Drtcp-mux%0D%0Aa%3Doldoip%3A10.7.0.7%0D%0Aa%3Doldcip%3A10.7.0.7%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: 5.9.133.123
variable_remote_media_port: 55787
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: 686e5f00-7d8d-433a-b743-e73a1976a934
Hunt-Direction: inbound
Hunt-Logical-Direction: inbound
Hunt-Username: 6089139952
Hunt-Dialplan: XML
Hunt-Caller-ID-Name: 6089139952
Hunt-Caller-ID-Number: 6089139952
Hunt-Orig-Caller-ID-Name: 6089139952
Hunt-Orig-Caller-ID-Number: 6089139952
Hunt-Network-Addr: 195.201.136.94
Hunt-ANI: 6089139952
Hunt-Destination-Number: 982181000
Hunt-Unique-ID: 686e5f00-7d8d-433a-b743-e73a1976a934
Hunt-Source: mod_sofia
Hunt-Context: default
Hunt-Channel-Name: sofia/default/6089139952%40Tal4812.newsip.israelnumber.com
Hunt-Profile-Index: 1
Hunt-Profile-Created-Time: 1729497815906429
Hunt-Channel-Created-Time: 1729497815906429
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
2024-10-21 08:03:36.066438 99.93% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] key_name:
2024-10-21 08:03:36.066438 99.93% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] key_value:
2024-10-21 08:03:36.066438 99.93% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] section: dialplan
2024-10-21 08:03:36.066438 99.93% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] tag_name:
2024-10-21 08:03:36.066438 99.93% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] blind_flag: 0
2024-10-21 08:03:36.066438 99.93% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 982181000
2024-10-21 08:03:36.066438 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '982181000' limit 1
2024-10-21 08:03:36.126473 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '982181000' AND status=0 limit 1
2024-10-21 08:03:36.206471 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET domains] Query :SELECT * FROM domains WHERE domain = 'Tal4812.newsip.israelnumber.com' limit 1
2024-10-21 08:03:36.286461 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '982181000' and account_id = '5374' and status=0 LIMIT 1
2024-10-21 08:03:36.366441 99.93% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] in custom Caller ID
2024-10-21 08:03:36.366441 99.93% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 6089139952 / 6089139952
2024-10-21 08:03:36.366441 99.93% [NOTICE] switch_cpp.cpp:1465 [ASTPP] DID global translation id: 13
2024-10-21 08:03:36.366441 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 13 AND status=0 limit 1
2024-10-21 08:03:36.426440 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:36.426440 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:36.426440 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:36.426440 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:36.426440 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:36.426440 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:36.426440 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:36.426440 99.93% [DEBUG] switch_cpp.cpp:1465 [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.buy_minutes,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,A.call_type_callerid_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="982181000" LIMIT 1
2024-10-21 08:03:36.506446 99.93% [DEBUG] switch_cpp.cpp:1465 [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="982181000" AND domains.domain="Tal4812.newsip.israelnumber.com" limit 1
2024-10-21 08:03:36.586458 99.93% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
2024-10-21 08:03:36.586458 99.93% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 972702853016465]
2024-10-21 08:03:36.586458 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "972702853016465" AND deleted = 0 limit 1
2024-10-21 08:03:36.646460 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^982181000.*' OR blocked_patterns = '^98218100.*' OR blocked_patterns = '^9821810.*' OR blocked_patterns = '^982181.*' OR blocked_patterns = '^98218.*' OR blocked_patterns = '^9821.*' OR blocked_patterns = '^982.*' OR blocked_patterns = '^98.*' OR blocked_patterns = '^9.*' OR blocked_patterns ='--') AND accountid = 5374 limit 1
2024-10-21 08:03:36.726450 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX_CALLERID] Query :SELECT * FROM `block_patterns_callerid` WHERE (blocked_patterns = '^982181000.*' OR blocked_patterns = '^98218100.*' OR blocked_patterns = '^9821810.*' OR blocked_patterns = '^982181.*' OR blocked_patterns = '^98218.*' OR blocked_patterns = '^9821.*' OR blocked_patterns = '^982.*' OR blocked_patterns = '^98.*' OR blocked_patterns = '^9.*' OR blocked_patterns ='--') AND callerid = 6089139952 AND accountid = 5374 limit 1
2024-10-21 08:03:36.806436 99.93% [NOTICE] switch_cpp.cpp:1465 [ASTPP] DID global translation id: 13
2024-10-21 08:03:36.806436 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 13 AND status=0 limit 1
2024-10-21 08:03:36.866443 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:36.866443 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:36.866443 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:36.866443 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:36.866443 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:36.866443 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:36.866443 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:36.866443 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="982181000" AND (accountid = 0 OR status = 1) LIMIT 1
2024-10-21 08:03:36.946440 99.93% [NOTICE] switch_cpp.cpp:1465 [ASTPP] DID global translation id: 13
2024-10-21 08:03:36.946440 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 13 AND status=0 limit 1
2024-10-21 08:03:37.006437 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:37.006437 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:37.006437 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:37.006437 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:37.006437 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:37.006437 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:37.006437 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:37.006437 99.93% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="982181000" AND (accountid = 0 OR status = 1) LIMIT 1
2024-10-21 08:03:37.086442 99.90% [DEBUG] switch_cpp.cpp:1465 [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 ="982181000" AND A.accountid = '5374' limit 1
2024-10-21 08:03:37.166445 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 982181000
2024-10-21 08:03:37.166445 99.90% [NOTICE] switch_cpp.cpp:1465 [ASTPP] DID global translation id: 13
2024-10-21 08:03:37.166445 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 13 AND status=0 limit 1
2024-10-21 08:03:37.226446 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:37.226446 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:37.226446 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:37.226446 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:37.226446 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:37.226446 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:37.226446 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"+/*,03/9723,073/97273,09/9729,02/9722,04/9724,077/97277".....982181000
2024-10-21 08:03:37.226446 99.90% [DEBUG] switch_cpp.cpp:1465 [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.buy_minutes,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,A.call_type_callerid_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="982181000" LIMIT 1
2024-10-21 08:03:37.306440 99.90% [DEBUG] switch_cpp.cpp:1465 [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="982181000" AND domains.domain="Tal4812.newsip.israelnumber.com" limit 1
2024-10-21 08:03:37.366442 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call direction : outbound
2024-10-21 08:03:37.366442 99.90% [DEBUG] switch_cpp.cpp:1465 [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 = '^982181000.*' OR patterns = '^98218100.*' OR patterns = '^9821810.*' OR patterns = '^982181.*' OR patterns = '^98218.*' OR patterns = '^9821.*' OR patterns = '^982.*' OR patterns = '^98.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 5374 ORDER BY LENGTH(PKGPTR.patterns) DESC
2024-10-21 08:03:37.446430 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '982181000' OR number = '98218100' OR number = '9821810' OR number = '982181' OR number = '98218' OR number = '9821' OR number = '982' OR number = '98' OR number = '9' OR number ='--') OR (number = '982181000*' OR number = '98218100*' OR number = '9821810*' OR number = '982181*' OR number = '98218*' OR number = '9821*' OR number = '982*' OR number = '98*' OR number = '9*' OR number ='--') OR (number = '6089139952' OR number = '608913995' OR number = '60891399' OR number = '6089139' OR number = '608913' OR number = '60891' OR number = '6089' OR number = '608' OR number = '60' OR number = '6' OR number ='--') OR (number = '6089139952*' OR number = '608913995*' OR number = '60891399*' OR number = '6089139*' OR number = '608913*' OR number = '60891*' OR number = '6089*' OR number = '608*' OR number = '60*' OR number = '6*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
2024-10-21 08:03:37.526441 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
2024-10-21 08:03:37.526441 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '982181000' OR routing_prefix = '98218100' OR routing_prefix = '9821810' OR routing_prefix = '982181' OR routing_prefix = '98218' OR routing_prefix = '9821' OR routing_prefix = '982' OR routing_prefix = '98' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
2024-10-21 08:03:37.606452 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
2024-10-21 08:03:37.606452 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 5374
2024-10-21 08:03:37.606452 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 972702853016465
2024-10-21 08:03:37.606452 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 45.70808
2024-10-21 08:03:37.606452 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
2024-10-21 08:03:37.606452 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 169
2024-10-21 08:03:37.606452 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
2024-10-21 08:03:37.606452 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
2024-10-21 08:03:37.606452 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 169 AND status = 0
2024-10-21 08:03:37.666440 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :outbound
2024-10-21 08:03:37.666440 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 169 AND status = 0
2024-10-21 08:03:37.746433 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^982181000.*' OR pattern = '^98218100.*' OR pattern = '^9821810.*' OR pattern = '^982181.*' OR pattern = '^98218.*' OR pattern = '^9821.*' OR pattern = '^982.*' OR pattern = '^98.*' OR pattern = '^9.*' OR pattern ='--') AND status = 0 AND (pricelist_id = 169 OR accountid=5374) ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC LIMIT 1
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] call_direction:::::: outbound
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 48035449
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.27000
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] comment : IranTehran
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 0
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 5374
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] Trunk ID: 0
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] Routing type:
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your45.70808 balance Accountid 5374 !!!
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE ID 5374
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE RATE 0.27000
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE PROVIDER 0
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE CONNECT COST 0.00000
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE INITIAL INC 30
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE INC 10
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max length duration : 169.28918518519 minutes
2024-10-21 08:03:37.846429 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [DIALPLAN] User Rate ID : 48035449
2024-10-21 08:03:37.846429 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES]123131 Query rate_carrier_id :0
2024-10-21 08:03:37.846429 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES_TRUNKS] Query :SELECT GROUP_CONCAT(trunk_id) as ids FROM routing WHERE pricelist_id=169 ORDER by id asc
2024-10-21 08:03:37.906425 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query :SELECT TK.id as trunk_id,TK.name as trunk_name,TK.codec,GW.name as path,GW.dialplan_variable,TK.provider_id,TR.init_inc,TK.status,TK.maxchannels,TK.cps,TK.leg_timeout,TR.pattern,TR.id as outbound_route_id,TR.connectcost,TR.comment,TR.includedseconds,TR.cost,TR.inc,TR.prepend,TR.strip,(select name from gateways where status=0 AND id = TK.failover_gateway_id) as path1,(select name from gateways where status=0 AND id = TK.failover_gateway_id1) as path2 FROM outbound_routes as TR,trunks as TK,gateways as GW WHERE GW.status=0 AND GW.id= TK.gateway_id AND TK.status=0 AND TK.id= TR.trunk_id AND (pattern = '^982181000.*' OR pattern = '^98218100.*' OR pattern = '^9821810.*' OR pattern = '^982181.*' OR pattern = '^98218.*' OR pattern = '^9821.*' OR pattern = '^982.*' OR pattern = '^98.*' OR pattern = '^9.*' OR pattern ='--') AND TR.status = 0 AND TR.trunk_id IN (25,51) ORDER by LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC, TK.precedence
2024-10-21 08:03:38.066432 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [HYBRID_ROUTING]LCR with Cost in 2nd stage
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Termination Rates Information ===================
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 1743913
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Code : ^9821.*
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Destination : IranTehran
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Free Seconds : 0
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Prefix : ^9821.*
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Strip : 0
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Prepend : 0
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Carrier id : 51
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] carrier_name : tata3
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] dialplan_variable :
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Failover gateway :
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Vendor id : 587
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Max channels : 0
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Trunk Name : high_tata_37113_110821
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================END OF TERMINATION RATES=======================
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Termination Rates Information ===================
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 28031697
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Code : ^9821.*
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Destination : IranTehran
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Free Seconds : 0
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Prefix : ^9821.*
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Strip : 0
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Prepend : 0
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Carrier id : 25
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] carrier_name : tata3
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] dialplan_variable :
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Failover gateway : tata4
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Vendor id : 587
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Max channels : 0
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Trunk Name : high_tata_37113_prime_1-1
2024-10-21 08:03:38.066432 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================END OF TERMINATION RATES=======================
2024-10-21 08:03:38.066432 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 5374 AND status= '0' LIMIT 1
2024-10-21 08:03:38.146426 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX_CALLERID] Query :SELECT * FROM `block_patterns_callerid` WHERE (blocked_patterns = '^982181000.*' OR blocked_patterns = '^98218100.*' OR blocked_patterns = '^9821810.*' OR blocked_patterns = '^982181.*' OR blocked_patterns = '^98218.*' OR blocked_patterns = '^9821.*' OR blocked_patterns = '^982.*' OR blocked_patterns = '^98.*' OR blocked_patterns = '^9.*' OR blocked_patterns ='--') AND callerid = 6089139952 AND accountid = 5374 limit 1
2024-10-21 08:03:38.206442 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] maxlength::::::::: 169.28918518519
2024-10-21 08:03:38.206442 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] call_direction : outbound
2024-10-21 08:03:38.206442 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 169 AND status = 0
2024-10-21 08:03:38.286435 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,out_caller_id_terminate,number_terminate FROM localization WHERE id=(SELECT localization_id from accounts where id = 587) AND status=0 limit 1
2024-10-21 08:03:38.366440 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :0/0.....982181000
2024-10-21 08:03:38.366440 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 169 AND status = 0
2024-10-21 08:03:38.426432 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,out_caller_id_terminate,number_terminate FROM localization WHERE id=(SELECT localization_id from accounts where id = 587) AND status=0 limit 1
2024-10-21 08:03:38.506437 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :0/0.....982181000
2024-10-21 08:03:38.506437 99.87% [DEBUG] switch_cpp.cpp:1465 [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="982181000">
<condition field="destination_number" expression="982181000">
<action application="set" data="effective_destination_number=982181000"/>
<action application="set" data="execute_on_answer=sched_hangup +10157.351111111 normal_clearing"/>
<action application="set" data="nibble_account=5374"/>
<action application="set" data="nibble_rate=0.27000"/>
<action application="set" data="nibble_increment=10"/>
<action application="set" data="nibble_minimum=0.00000"/>
<action application="nibblebill" data="heartbeat 10"/>
<action application="set" data="callstart=2024-10-21 08:03:39"/>
<action application="set" data="hangup_after_bridge=true"/>
<action application="set" data="continue_on_fail=TRUE"/>
<action application="set" data="account_id=5374"/>
<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=outbound"/>
<action application="set" data="accountname=default"/>
<action application="set" data="filename1=astpp.pbx.lua"/>
<action application="set" data="origination_rates=ID:48035449|CODE:^9821.*|DESTINATION:IranTehran|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.27000|INC:10|INITIALBLOCK:30|RATEGROUP:169|MARKUP:0|CI:0|ACCID:5374"/>
<action application="set" data="original_caller_id_name=6089139952"/>
<action application="set" data="original_caller_id_number=6089139952"/>
<action application="limit" data="db 972702853016465 user_972702853016465 10 !SWITCH_CONGESTION"/>
<action application="limit" data="hash CPS_972702853016465 CPS_user_972702853016465 10/1 !SWITCH_CONGESTION"/>
<action application="export" data="is_recording=1"/>
<action application="export" data="media_bug_answer_req=true"/>
<action application="export" data="RECORD_STEREO=true"/>
<action application="export" data="record_sample_rate=8000"/>
<action application="export" data="execute_on_answer=record_session $${recordings_dir}/${uuid}.wav"/>
<action application="set" data="effective_caller_id_name=6089139952"/>
<action application="set" data="effective_caller_id_number=6089139952"/>
<action application="set" data="calltype=STANDARD"/>
<action application="set" data="termination_rates=ID:1743913|CODE:^9821.*|DESTINATION:IranTehran|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.12590|INC:1|INITIALBLOCK:1|TRUNK:51|PROVIDER:587"/>
<action application="set" data="trunk_id=51"/>
<action application="set" data="provider_id=587"/>
<action application="set" data="rate_flag=0"/>
<action application="set" data="force_trunk_flag=48035449"/>
<action application="export" data="presence_data=trunk_id=51"/>
<action application="set" data="intcall=0"/>
<action application="export" data="presence_data=x|||Tal(972702853016465)|||^9821.* // IranTehran // 0.27000 // trunk_id=0|||high_tata_37113_110821 // ^9821.* // IranTehran // 0.12590 // trunk_id=51|||STD|||5.9.133.123"/>
<action application="bridge" data="{sip_cid_type=pid}[leg_timeout=0]sofia/gateway/tata3/982181000;fs_path=sip:195.201.136.94:5060"/>
<action application="set" data="effective_caller_id_name=6089139952"/>
<action application="set" data="effective_caller_id_number=6089139952"/>
<action application="set" data="calltype=STANDARD"/>
<action application="set" data="termination_rates=ID:28031697|CODE:^9821.*|DESTINATION:IranTehran|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.13500|INC:1|INITIALBLOCK:1|TRUNK:25|PROVIDER:587"/>
<action application="set" data="trunk_id=25"/>
<action application="set" data="provider_id=587"/>
<action application="set" data="rate_flag=0"/>
<action application="set" data="force_trunk_flag=48035449"/>
<action application="export" data="presence_data=trunk_id=25"/>
<action application="set" data="intcall=0"/>
<action application="export" data="presence_data=x|||Tal(972702853016465)|||^9821.* // IranTehran // 0.27000 // trunk_id=0|||high_tata_37113_prime_1-1 // ^9821.* // IranTehran // 0.13500 // trunk_id=25|||STD|||5.9.133.123"/>
<action application="bridge" data="{sip_cid_type=pid}[leg_timeout=0]sofia/gateway/tata3/982181000;fs_path=sip:195.201.136.94:5060"/>
<action application="bridge" data="{sip_cid_type=pid}[leg_timeout=0]sofia/gateway/tata4/982181000;fs_path=sip:195.201.136.94:5060"/>
</condition>
</extension>
</context>
</document>
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com parsing [default->982181000] continue=false
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Regex (PASS) [982181000] destination_number(982181000) =~ /982181000/ break=on-false
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(effective_destination_number=982181000)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(execute_on_answer=sched_hangup +10157.351111111 normal_clearing)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(nibble_account=5374)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(nibble_rate=0.27000)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(nibble_increment=10)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(nibble_minimum=0.00000)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action nibblebill(heartbeat 10)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(callstart=2024-10-21 08:03:39)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(hangup_after_bridge=true)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(continue_on_fail=TRUE)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(account_id=5374)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(parent_id=0)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(entity_id=0)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(call_processed=internal)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(call_direction=outbound)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(accountname=default)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(filename1=astpp.pbx.lua)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(origination_rates=ID:48035449|CODE:^9821.*|DESTINATION:IranTehran|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.27000|INC:10|INITIALBLOCK:30|RATEGROUP:169|MARKUP:0|CI:0|ACCID:5374)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(original_caller_id_name=6089139952)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(original_caller_id_number=6089139952)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action limit(db 972702853016465 user_972702853016465 10 !SWITCH_CONGESTION)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action limit(hash CPS_972702853016465 CPS_user_972702853016465 10/1 !SWITCH_CONGESTION)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action export(is_recording=1)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action export(media_bug_answer_req=true)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action export(RECORD_STEREO=true)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action export(record_sample_rate=8000)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action export(execute_on_answer=record_session $${recordings_dir}/${uuid}.wav)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(effective_caller_id_name=6089139952)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(effective_caller_id_number=6089139952)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(calltype=STANDARD)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(termination_rates=ID:1743913|CODE:^9821.*|DESTINATION:IranTehran|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.12590|INC:1|INITIALBLOCK:1|TRUNK:51|PROVIDER:587)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(trunk_id=51)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(provider_id=587)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(rate_flag=0)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(force_trunk_flag=48035449)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action export(presence_data=trunk_id=51)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(intcall=0)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action export(presence_data=x|||Tal(972702853016465)|||^9821.* // IranTehran // 0.27000 // trunk_id=0|||high_tata_37113_110821 // ^9821.* // IranTehran // 0.12590 // trunk_id=51|||STD|||5.9.133.123)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action bridge({sip_cid_type=pid}[leg_timeout=0]sofia/gateway/tata3/982181000;fs_path=sip:195.201.136.94:5060)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(effective_caller_id_name=6089139952)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(effective_caller_id_number=6089139952)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(calltype=STANDARD)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(termination_rates=ID:28031697|CODE:^9821.*|DESTINATION:IranTehran|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.13500|INC:1|INITIALBLOCK:1|TRUNK:25|PROVIDER:587)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(trunk_id=25)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(provider_id=587)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(rate_flag=0)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(force_trunk_flag=48035449)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action export(presence_data=trunk_id=25)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action set(intcall=0)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action export(presence_data=x|||Tal(972702853016465)|||^9821.* // IranTehran // 0.27000 // trunk_id=0|||high_tata_37113_prime_1-1 // ^9821.* // IranTehran // 0.13500 // trunk_id=25|||STD|||5.9.133.123)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action bridge({sip_cid_type=pid}[leg_timeout=0]sofia/gateway/tata3/982181000;fs_path=sip:195.201.136.94:5060)
Dialplan: sofia/default/6089139952@Tal4812.newsip.israelnumber.com Action bridge({sip_cid_type=pid}[leg_timeout=0]sofia/gateway/tata4/982181000;fs_path=sip:195.201.136.94:5060)
2024-10-21 08:03:38.506437 99.87% [DEBUG] switch_core_state_machine.c:281 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State Change CS_ROUTING -> CS_EXECUTE
2024-10-21 08:03:38.506437 99.87% [DEBUG] switch_core_state_machine.c:640 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State ROUTING going to sleep
2024-10-21 08:03:38.506437 99.87% [DEBUG] switch_core_state_machine.c:581 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) Running State Change CS_EXECUTE (Cur 3 Tot 228326)
2024-10-21 08:03:38.506437 99.87% [DEBUG] switch_core_state_machine.c:647 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State EXECUTE
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_sofia.c:213 sofia/default/6089139952@Tal4812.newsip.israelnumber.com SOFIA EXECUTE
2024-10-21 08:03:38.506437 99.87% [DEBUG] switch_core_state_machine.c:323 sofia/default/6089139952@Tal4812.newsip.israelnumber.com Standard EXECUTE
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(effective_destination_number=982181000)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [effective_destination_number]=[982181000]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(execute_on_answer=sched_hangup +10157.351111111 normal_clearing)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [execute_on_answer]=[sched_hangup +10157.351111111 normal_clearing]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(nibble_account=5374)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [nibble_account]=[5374]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(nibble_rate=0.27000)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [nibble_rate]=[0.27000]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(nibble_increment=10)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [nibble_increment]=[10]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(nibble_minimum=0.00000)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [nibble_minimum]=[0.00000]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com nibblebill(heartbeat 10)
2024-10-21 08:03:38.506437 99.87% [WARNING] switch_core_session.c:1693 sofia/default/6089139952@Tal4812.newsip.israelnumber.com using scheduler due to bypass media or media is not established.
2024-10-21 08:03:38.506437 99.87% [DEBUG] switch_scheduler.c:263 Added task 167719 switch_core_session_sched_heartbeat (686e5f00-7d8d-433a-b743-e73a1976a934) to run at 1729497828
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(callstart=2024-10-21 08:03:39)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [callstart]=[2024-10-21 08:03:39]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(hangup_after_bridge=true)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [hangup_after_bridge]=[true]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(continue_on_fail=TRUE)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [continue_on_fail]=[TRUE]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(account_id=5374)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [account_id]=[5374]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(parent_id=0)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [parent_id]=[0]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(entity_id=0)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [entity_id]=[0]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(call_processed=internal)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [call_processed]=[internal]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(call_direction=outbound)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [call_direction]=[outbound]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(accountname=default)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [accountname]=[default]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(filename1=astpp.pbx.lua)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [filename1]=[astpp.pbx.lua]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(origination_rates=ID:48035449|CODE:^9821.*|DESTINATION:IranTehran|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.27000|INC:10|INITIALBLOCK:30|RATEGROUP:169|MARKUP:0|CI:0|ACCID:5374)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [origination_rates]=[ID:48035449|CODE:^9821.*|DESTINATION:IranTehran|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.27000|INC:10|INITIALBLOCK:30|RATEGROUP:169|MARKUP:0|CI:0|ACCID:5374]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(original_caller_id_name=6089139952)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [original_caller_id_name]=[6089139952]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(original_caller_id_number=6089139952)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [original_caller_id_number]=[6089139952]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com limit(db 972702853016465 user_972702853016465 10 !SWITCH_CONGESTION)
2024-10-21 08:03:38.506437 99.87% [DEBUG] switch_limit.c:124 incr called: 972702853016465_user_972702853016465 max:10, interval:0
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_db.c:194 Usage for 972702853016465_user_972702853016465 is now 1/10
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com limit(hash CPS_972702853016465 CPS_user_972702853016465 10/1 !SWITCH_CONGESTION)
2024-10-21 08:03:38.506437 99.87% [DEBUG] switch_limit.c:124 incr called: CPS_972702853016465_CPS_user_972702853016465 max:10, interval:1
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_hash.c:195 Usage for CPS_972702853016465_CPS_user_972702853016465 is now 1/10 for the last 1 seconds
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com export(is_recording=1)
2024-10-21 08:03:38.506437 99.87% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [is_recording]=[1]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com export(media_bug_answer_req=true)
2024-10-21 08:03:38.506437 99.87% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [media_bug_answer_req]=[true]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com export(RECORD_STEREO=true)
2024-10-21 08:03:38.506437 99.87% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [RECORD_STEREO]=[true]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com export(record_sample_rate=8000)
2024-10-21 08:03:38.506437 99.87% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [record_sample_rate]=[8000]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com export(execute_on_answer=record_session /var/lib/freeswitch/recordings/686e5f00-7d8d-433a-b743-e73a1976a934.wav)
2024-10-21 08:03:38.506437 99.87% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [execute_on_answer]=[record_session /var/lib/freeswitch/recordings/686e5f00-7d8d-433a-b743-e73a1976a934.wav]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(effective_caller_id_name=6089139952)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [effective_caller_id_name]=[6089139952]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(effective_caller_id_number=6089139952)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [effective_caller_id_number]=[6089139952]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(calltype=STANDARD)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [calltype]=[STANDARD]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(termination_rates=ID:1743913|CODE:^9821.*|DESTINATION:IranTehran|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.12590|INC:1|INITIALBLOCK:1|TRUNK:51|PROVIDER:587)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [termination_rates]=[ID:1743913|CODE:^9821.*|DESTINATION:IranTehran|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.12590|INC:1|INITIALBLOCK:1|TRUNK:51|PROVIDER:587]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(trunk_id=51)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [trunk_id]=[51]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(provider_id=587)
2024-10-21 08:03:38.506437 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [provider_id]=[587]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(rate_flag=0)
2024-10-21 08:03:38.526433 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [rate_flag]=[0]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(force_trunk_flag=48035449)
2024-10-21 08:03:38.526433 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [force_trunk_flag]=[48035449]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com export(presence_data=trunk_id=51)
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[trunk_id=51]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com set(intcall=0)
2024-10-21 08:03:38.526433 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/6089139952@Tal4812.newsip.israelnumber.com [intcall]=[0]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com export(presence_data=x|||Tal(972702853016465)|||^9821.* // IranTehran // 0.27000 // trunk_id=0|||high_tata_37113_110821 // ^9821.* // IranTehran // 0.12590 // trunk_id=51|||STD|||5.9.133.123)
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[x|||Tal(972702853016465)|||^9821.* // IranTehran // 0.27000 // trunk_id=0|||high_tata_37113_110821 // ^9821.* // IranTehran // 0.12590 // trunk_id=51|||STD|||5.9.133.123]
EXECUTE [depth=0] sofia/default/6089139952@Tal4812.newsip.israelnumber.com bridge({sip_cid_type=pid}[leg_timeout=0]sofia/gateway/tata3/982181000;fs_path=sip:195.201.136.94:5060)
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_channel.c:1269 sofia/default/6089139952@Tal4812.newsip.israelnumber.com EXPORTING[export_vars] [is_recording]=[1] to event
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_channel.c:1269 sofia/default/6089139952@Tal4812.newsip.israelnumber.com EXPORTING[export_vars] [media_bug_answer_req]=[true] to event
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_channel.c:1269 sofia/default/6089139952@Tal4812.newsip.israelnumber.com EXPORTING[export_vars] [RECORD_STEREO]=[true] to event
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_channel.c:1269 sofia/default/6089139952@Tal4812.newsip.israelnumber.com EXPORTING[export_vars] [record_sample_rate]=[8000] to event
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_channel.c:1269 sofia/default/6089139952@Tal4812.newsip.israelnumber.com EXPORTING[export_vars] [execute_on_answer]=[record_session /var/lib/freeswitch/recordings/686e5f00-7d8d-433a-b743-e73a1976a934.wav] to event
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_channel.c:1269 sofia/default/6089139952@Tal4812.newsip.israelnumber.com EXPORTING[export_vars] [presence_data]=[x|||Tal(972702853016465)|||^9821.* // IranTehran // 0.27000 // trunk_id=0|||high_tata_37113_110821 // ^9821.* // IranTehran // 0.12590 // trunk_id=51|||STD|||5.9.133.123] to event
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_channel.c:1269 sofia/default/6089139952@Tal4812.newsip.israelnumber.com EXPORTING[export_vars] [presence_data]=[x|||Tal(972702853016465)|||^9821.* // IranTehran // 0.27000 // trunk_id=0|||high_tata_37113_110821 // ^9821.* // IranTehran // 0.12590 // trunk_id=51|||STD|||5.9.133.123] to event
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_ivr_originate.c:2843 Parsing session specific variables
2024-10-21 08:03:38.526433 99.87% [NOTICE] switch_channel.c:1123 New Channel sofia/default/982181000 [697736c5-e56f-4352-9990-643b990bb96d]
2024-10-21 08:03:38.526433 99.87% [DEBUG] mod_sofia.c:5121 (sofia/default/982181000) State Change CS_NEW -> CS_INIT
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_core_state_machine.c:581 (sofia/default/982181000) Running State Change CS_INIT (Cur 4 Tot 228327)
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_core_state_machine.c:624 (sofia/default/982181000) State INIT
2024-10-21 08:03:38.526433 99.87% [DEBUG] mod_sofia.c:97 sofia/default/982181000 SOFIA INIT
2024-10-21 08:03:38.526433 99.87% [DEBUG] sofia_glue.c:1620 sip:195.201.136.94:5060 Setting proxy route to sofia/default/982181000
2024-10-21 08:03:38.526433 99.87% [INFO] sofia_glue.c:1651 sofia/default/982181000 sending invite call-id: (null)
2024-10-21 08:03:38.526433 99.87% [DEBUG] sofia_glue.c:1654 sofia/default/982181000 sending invite version: 1.10.7 -release-19-883d2cb662 64bit
Local SDP:
v=0
o=FreeSWITCH 1729474316 1729474317 IN IP4 95.217.164.101
s=FreeSWITCH
c=IN IP4 95.217.164.101
t=0 0
m=audio 23502 RTP/AVP 0 101
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
a=sendrecv
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_core_state_machine.c:40 sofia/default/982181000 Standard INIT
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_core_state_machine.c:48 (sofia/default/982181000) State Change CS_INIT -> CS_ROUTING
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_core_state_machine.c:624 (sofia/default/982181000) State INIT going to sleep
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_core_state_machine.c:581 (sofia/default/982181000) Running State Change CS_ROUTING (Cur 4 Tot 228327)
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_core_state_machine.c:640 (sofia/default/982181000) State ROUTING
2024-10-21 08:03:38.526433 99.87% [DEBUG] mod_sofia.c:158 sofia/default/982181000 SOFIA ROUTING
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_ivr_originate.c:67 (sofia/default/982181000) State Change CS_ROUTING -> CS_CONSUME_MEDIA
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_core_state_machine.c:640 (sofia/default/982181000) State ROUTING going to sleep
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_core_state_machine.c:581 (sofia/default/982181000) Running State Change CS_CONSUME_MEDIA (Cur 4 Tot 228327)
2024-10-21 08:03:38.526433 99.87% [DEBUG] sofia.c:7499 Channel sofia/default/982181000 entering state [calling][0]
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_core_state_machine.c:659 (sofia/default/982181000) State CONSUME_MEDIA
2024-10-21 08:03:38.526433 99.87% [DEBUG] switch_core_state_machine.c:659 (sofia/default/982181000) State CONSUME_MEDIA going to sleep
2024-10-21 08:03:39.566428 99.80% [DEBUG] sofia.c:7499 Channel sofia/default/982181000 entering state [proceeding][180]
2024-10-21 08:03:39.566428 99.80% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=Sonus_UAC 25715 8929 IN IP4 209.58.46.110
s=SIP Media Capabilities
c=IN IP4 209.58.46.102
t=0 0
m=audio 5092 RTP/AVP 0 101
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=maxptime:20
2024-10-21 08:03:39.566428 99.80% [NOTICE] sofia.c:7512 Pre-Answer sofia/default/982181000!
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_channel.c:3622 (sofia/default/982181000) Callstate Change DOWN -> EARLY
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/982181000 PCMU/8000 20 ms 160 samples 64000 bits 1 channels
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_codec.c:111 sofia/default/982181000 Original read codec set to PCMU:0
2024-10-21 08:03:39.566428 99.80% [INFO] switch_ivr_originate.c:3841 Sending early media
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_media.c:8777 AUDIO RTP [sofia/default/6089139952@Tal4812.newsip.israelnumber.com] 95.217.164.101 port 32674 -> 5.9.133.123 port 55787 codec: 0 ms: 20
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_media.c:5973 sofia/default/982181000 Set 2833 dtmf send payload to 101 recv payload to 101
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_media.c:8777 AUDIO RTP [sofia/default/982181000] 95.217.164.101 port 23502 -> 209.58.46.102 port 5092 codec: 0 ms: 20
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_rtp.c:4619 Starting timer [soft] 160 bytes per 20ms
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_rtp.c:4619 Starting timer [soft] 160 bytes per 20ms
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_media.c:8997 Activating RTCP PORT 55787
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_rtp.c:5017 RTCP send rate is: 1000 and packet rate is: 20000 Remote Port: 55787
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_media.c:9089 sofia/default/982181000 Set 2833 dtmf send payload to 101
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_media.c:9096 sofia/default/982181000 Set 2833 dtmf receive payload to 101
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_media.c:9119 sofia/default/982181000 Set rtp dtmf delay to 40
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_media.c:9089 sofia/default/6089139952@Tal4812.newsip.israelnumber.com Set 2833 dtmf send payload to 101
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_media.c:9096 sofia/default/6089139952@Tal4812.newsip.israelnumber.com Set 2833 dtmf receive payload to 101
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_media.c:9119 sofia/default/6089139952@Tal4812.newsip.israelnumber.com Set rtp dtmf delay to 40
2024-10-21 08:03:39.566428 99.80% [DEBUG] mod_sofia.c:2610 Ring SDP:
v=0
o=FreeSWITCH 1729465145 1729465146 IN IP4 95.217.164.101
s=FreeSWITCH
c=IN IP4 95.217.164.101
t=0 0
m=audio 32674 RTP/AVP 0 101
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
a=sendrecv
a=rtcp-mux
a=rtcp:32674 IN IP4 95.217.164.101
2024-10-21 08:03:39.566428 99.80% [NOTICE] mod_sofia.c:2613 Pre-Answer sofia/default/6089139952@Tal4812.newsip.israelnumber.com!
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_channel.c:3622 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) Callstate Change RINGING -> EARLY
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_ivr_originate.c:3892 Originate Resulted in Success: [sofia/default/982181000] Peer UUID: 697736c5-e56f-4352-9990-643b990bb96d
2024-10-21 08:03:39.566428 99.80% [DEBUG] sofia.c:7499 Channel sofia/default/6089139952@Tal4812.newsip.israelnumber.com entering state [early][183]
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_ivr_bridge.c:1793 (sofia/default/982181000) State Change CS_CONSUME_MEDIA -> CS_EXCHANGE_MEDIA
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/982181000) Running State Change CS_EXCHANGE_MEDIA (Cur 4 Tot 228327)
2024-10-21 08:03:39.566428 99.80% [DEBUG] switch_core_state_machine.c:650 (sofia/default/982181000) State EXCHANGE_MEDIA
2024-10-21 08:03:39.566428 99.80% [DEBUG] mod_sofia.c:671 SOFIA EXCHANGE_MEDIA
2024-10-21 08:03:39.626434 99.80% [DEBUG] switch_rtp.c:7934 Correct audio ip/port confirmed.
2024-10-21 08:03:39.926430 99.80% [DEBUG] switch_rtp.c:7934 Correct audio ip/port confirmed.
2024-10-21 08:03:39.966433 99.80% [DEBUG] switch_rtp.c:1982 rtcp_stats_init: audio ssrc[304259036] base_seq[39692]
2024-10-21 08:03:48.006460 99.80% [DEBUG] mod_nibblebill.c:695 Received request via SESSION_HEARTBEAT!
2024-10-21 08:03:48.006460 99.80% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.27000 per minute to account 5374
2024-10-21 08:03:48.006460 99.80% [DEBUG] mod_nibblebill.c:518 Not billing 5374 - call is not in answered state
2024-10-21 08:03:48.006460 99.80% [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='5374']
2024-10-21 08:03:48.086445 99.83% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 5374 (balance = 45.708080)
2024-10-21 08:03:48.086445 99.83% [DEBUG] mod_nibblebill.c:523 Comparing 45.708080 to hangup balance of 0.100000, taking into account minimum charge of 0.000000
2024-10-21 08:03:58.006454 99.83% [DEBUG] mod_nibblebill.c:695 Received request via SESSION_HEARTBEAT!
2024-10-21 08:03:58.006454 99.83% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.27000 per minute to account 5374
2024-10-21 08:03:58.006454 99.83% [DEBUG] mod_nibblebill.c:518 Not billing 5374 - call is not in answered state
2024-10-21 08:03:58.006454 99.83% [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='5374']
2024-10-21 08:03:58.086457 99.83% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 5374 (balance = 45.708080)
2024-10-21 08:03:58.086457 99.83% [DEBUG] mod_nibblebill.c:523 Comparing 45.708080 to hangup balance of 0.100000, taking into account minimum charge of 0.000000
2024-10-21 08:04:08.006431 99.90% [DEBUG] mod_nibblebill.c:695 Received request via SESSION_HEARTBEAT!
2024-10-21 08:04:08.006431 99.90% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.27000 per minute to account 5374
2024-10-21 08:04:08.006431 99.90% [DEBUG] mod_nibblebill.c:518 Not billing 5374 - call is not in answered state
2024-10-21 08:04:08.006431 99.90% [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='5374']
2024-10-21 08:04:08.086445 99.93% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 5374 (balance = 45.708080)
2024-10-21 08:04:08.086445 99.93% [DEBUG] mod_nibblebill.c:523 Comparing 45.708080 to hangup balance of 0.100000, taking into account minimum charge of 0.000000
2024-10-21 08:04:18.026441 100.00% [DEBUG] mod_nibblebill.c:695 Received request via SESSION_HEARTBEAT!
2024-10-21 08:04:18.026441 100.00% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.27000 per minute to account 5374
2024-10-21 08:04:18.026441 100.00% [DEBUG] mod_nibblebill.c:518 Not billing 5374 - call is not in answered state
2024-10-21 08:04:18.026441 100.00% [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='5374']
2024-10-21 08:04:18.086438 100.00% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 5374 (balance = 45.708080)
2024-10-21 08:04:18.086438 100.00% [DEBUG] mod_nibblebill.c:523 Comparing 45.708080 to hangup balance of 0.100000, taking into account minimum charge of 0.000000
2024-10-21 08:04:28.026438 100.00% [DEBUG] mod_nibblebill.c:695 Received request via SESSION_HEARTBEAT!
2024-10-21 08:04:28.026438 100.00% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.27000 per minute to account 5374
2024-10-21 08:04:28.026438 100.00% [DEBUG] mod_nibblebill.c:518 Not billing 5374 - call is not in answered state
2024-10-21 08:04:28.026438 100.00% [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='5374']
2024-10-21 08:04:28.086431 100.00% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 5374 (balance = 45.708080)
2024-10-21 08:04:28.086431 100.00% [DEBUG] mod_nibblebill.c:523 Comparing 45.708080 to hangup balance of 0.100000, taking into account minimum charge of 0.000000
2024-10-21 08:04:32.026446 100.00% [DEBUG] mod_nibblebill.c:695 Received request via SESSION_HEARTBEAT!
2024-10-21 08:04:32.026446 100.00% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.00000 per minute to account 10401
2024-10-21 08:04:32.026446 100.00% [DEBUG] mod_nibblebill.c:573 58 seconds passed since last bill time of 2024-10-21 08:03:33
2024-10-21 08:04:32.026446 100.00% [DEBUG] mod_nibblebill.c:590 Billing $0.000000 to 10401 (Call: 9efbada1-f4ac-4478-9f88-aef0ba33056b / 0.000000 so far)
2024-10-21 08:04:32.026446 100.00% [DEBUG] mod_nibblebill.c:395 Doing update query
[Update accounts SET balance=IF(posttoexternal=1,balance+0.000000,balance-0.000000) WHERE id='10401']
2024-10-21 08:04:32.086452 100.00% [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='10401']
2024-10-21 08:04:32.166448 100.00% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 10401 (balance = 1.988000)
2024-10-21 08:04:38.026450 100.00% [DEBUG] mod_nibblebill.c:695 Received request via SESSION_HEARTBEAT!
2024-10-21 08:04:38.026450 100.00% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.27000 per minute to account 5374
2024-10-21 08:04:38.026450 100.00% [DEBUG] mod_nibblebill.c:518 Not billing 5374 - call is not in answered state
2024-10-21 08:04:38.026450 100.00% [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='5374']
2024-10-21 08:04:38.086429 100.00% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 5374 (balance = 45.708080)
2024-10-21 08:04:38.086429 100.00% [DEBUG] mod_nibblebill.c:523 Comparing 45.708080 to hangup balance of 0.100000, taking into account minimum charge of 0.000000
2024-10-21 08:04:40.226455 100.00% [DEBUG] sofia.c:7499 Channel sofia/default/982181000 entering state [proceeding][180]
2024-10-21 08:04:40.226455 100.00% [NOTICE] sofia.c:7610 Ring-Ready sofia/default/982181000!
2024-10-21 08:04:40.226455 100.00% [DEBUG] switch_channel.c:3494 (sofia/default/982181000) Callstate Change EARLY -> RINGING
2024-10-21 08:04:40.366444 100.00% [DEBUG] sofia.c:7499 Channel sofia/default/982181000 entering state [proceeding][180]
2024-10-21 08:04:48.026427 100.00% [DEBUG] mod_nibblebill.c:695 Received request via SESSION_HEARTBEAT!
2024-10-21 08:04:48.026427 100.00% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.27000 per minute to account 5374
2024-10-21 08:04:48.026427 100.00% [DEBUG] mod_nibblebill.c:518 Not billing 5374 - call is not in answered state
2024-10-21 08:04:48.026427 100.00% [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='5374']
2024-10-21 08:04:48.086425 100.00% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 5374 (balance = 45.708080)
2024-10-21 08:04:48.086425 100.00% [DEBUG] mod_nibblebill.c:523 Comparing 45.708080 to hangup balance of 0.100000, taking into account minimum charge of 0.000000
2024-10-21 08:04:52.526432 100.00% [DEBUG] sofia.c:7499 Channel sofia/default/6089139952@Tal4812.newsip.israelnumber.com entering state [terminated][487]
2024-10-21 08:04:52.526432 100.00% [NOTICE] sofia.c:8738 Hangup sofia/default/6089139952@Tal4812.newsip.israelnumber.com [CS_EXECUTE] [ORIGINATOR_CANCEL]
2024-10-21 08:04:52.526432 100.00% [DEBUG] mod_hash.c:293 Usage for CPS_972702853016465_CPS_user_972702853016465 is now 0
2024-10-21 08:04:52.526432 100.00% [DEBUG] switch_ivr_bridge.c:826 sofia/default/6089139952@Tal4812.newsip.israelnumber.com ending bridge by request from read function
2024-10-21 08:04:52.526432 100.00% [DEBUG] switch_ivr_bridge.c:912 BRIDGE THREAD DONE [sofia/default/6089139952@Tal4812.newsip.israelnumber.com]
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_ivr_bridge.c:820 sofia/default/6089139952@Tal4812.newsip.israelnumber.com ending bridge by request from write function
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_ivr_bridge.c:912 BRIDGE THREAD DONE [sofia/default/982181000]
2024-10-21 08:04:52.546431 100.00% [NOTICE] switch_ivr_bridge.c:1025 Hangup sofia/default/982181000 [CS_EXCHANGE_MEDIA] [ORIGINATOR_CANCEL]
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_core_state_machine.c:650 (sofia/default/982181000) State EXCHANGE_MEDIA going to sleep
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/982181000) Running State Change CS_HANGUP (Cur 4 Tot 228327)
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_core_state_machine.c:844 (sofia/default/982181000) Callstate Change RINGING -> HANGUP
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_core_state_machine.c:846 (sofia/default/982181000) State HANGUP
2024-10-21 08:04:52.546431 100.00% [DEBUG] mod_sofia.c:462 sofia/default/982181000 Overriding SIP cause 487 with 487 from the other leg
2024-10-21 08:04:52.546431 100.00% [DEBUG] mod_sofia.c:468 Channel sofia/default/982181000 hanging up, cause: ORIGINATOR_CANCEL
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_ivr_bridge.c:1892 sofia/default/982181000 skip receive message [UNBRIDGE] (channel is hungup already)
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_ivr_bridge.c:1895 sofia/default/6089139952@Tal4812.newsip.israelnumber.com skip receive message [UNBRIDGE] (channel is hungup already)
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_core_session.c:2983 sofia/default/6089139952@Tal4812.newsip.israelnumber.com skip receive message [PHONE_EVENT] (channel is hungup already)
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_core_state_machine.c:647 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State EXECUTE going to sleep
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) Running State Change CS_HANGUP (Cur 4 Tot 228327)
2024-10-21 08:04:52.546431 100.00% [DEBUG] mod_sofia.c:536 Sending CANCEL to sofia/default/982181000
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_core_state_machine.c:844 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) Callstate Change EARLY -> HANGUP
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_core_state_machine.c:59 sofia/default/982181000 Standard HANGUP, cause: ORIGINATOR_CANCEL
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_core_state_machine.c:846 (sofia/default/982181000) State HANGUP going to sleep
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_core_state_machine.c:846 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State HANGUP
2024-10-21 08:04:52.546431 100.00% [DEBUG] mod_sofia.c:468 Channel sofia/default/6089139952@Tal4812.newsip.israelnumber.com hanging up, cause: ORIGINATOR_CANCEL
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_core_state_machine.c:616 (sofia/default/982181000) State Change CS_HANGUP -> CS_REPORTING
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/982181000) Running State Change CS_REPORTING (Cur 4 Tot 228327)
2024-10-21 08:04:52.546431 100.00% [DEBUG] switch_core_state_machine.c:932 (sofia/default/982181000) State REPORTING
2024-10-21 08:04:52.546431 100.00% [INFO] mod_json_cdr.c:271 Process [697736c5-e56f-4352-9990-643b990bb96d.cdr.json]
2024-10-21 08:04:52.546431 100.00% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.27000 per minute to account 5374
2024-10-21 08:04:52.546431 100.00% [DEBUG] mod_nibblebill.c:518 Not billing 5374 - call is not in answered state
2024-10-21 08:04:52.546431 100.00% [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='5374']
2024-10-21 08:04:52.626443 100.00% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 5374 (balance = 45.708080)
2024-10-21 08:04:52.626443 100.00% [DEBUG] mod_nibblebill.c:523 Comparing 45.708080 to hangup balance of 0.100000, taking into account minimum charge of 0.000000
2024-10-21 08:04:52.626443 100.00% [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='5374']
2024-10-21 08:04:52.626443 100.00% [DEBUG] switch_core_state_machine.c:168 sofia/default/982181000 Standard REPORTING, cause: ORIGINATOR_CANCEL
2024-10-21 08:04:52.626443 100.00% [DEBUG] switch_core_state_machine.c:932 (sofia/default/982181000) State REPORTING going to sleep
2024-10-21 08:04:52.626443 100.00% [DEBUG] switch_core_state_machine.c:607 (sofia/default/982181000) State Change CS_REPORTING -> CS_DESTROY
2024-10-21 08:04:52.626443 100.00% [DEBUG] switch_core_session.c:1753 Session 228327 (sofia/default/982181000) Locked, Waiting on external entities
2024-10-21 08:04:52.626443 100.00% [NOTICE] switch_core_session.c:1771 Session 228327 (sofia/default/982181000) Ended
2024-10-21 08:04:52.626443 100.00% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/982181000 [CS_DESTROY]
2024-10-21 08:04:52.626443 100.00% [DEBUG] switch_core_state_machine.c:735 (sofia/default/982181000) Running State Change CS_DESTROY (Cur 3 Tot 228327)
2024-10-21 08:04:52.626443 100.00% [DEBUG] switch_core_state_machine.c:745 (sofia/default/982181000) State DESTROY
2024-10-21 08:04:52.626443 100.00% [DEBUG] mod_sofia.c:379 sofia/default/982181000 SOFIA DESTROY
2024-10-21 08:04:52.626443 100.00% [DEBUG] switch_core_state_machine.c:175 sofia/default/982181000 Standard DESTROY
2024-10-21 08:04:52.626443 100.00% [DEBUG] switch_core_state_machine.c:745 (sofia/default/982181000) State DESTROY going to sleep
2024-10-21 08:04:52.686436 100.00% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 5374 (balance = 45.708080)
2024-10-21 08:04:52.686436 100.00% [DEBUG] switch_core_state_machine.c:59 sofia/default/6089139952@Tal4812.newsip.israelnumber.com Standard HANGUP, cause: ORIGINATOR_CANCEL
2024-10-21 08:04:52.686436 100.00% [DEBUG] switch_core_state_machine.c:846 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State HANGUP going to sleep
2024-10-21 08:04:52.686436 100.00% [DEBUG] switch_core_state_machine.c:616 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State Change CS_HANGUP -> CS_REPORTING
2024-10-21 08:04:52.686436 100.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) Running State Change CS_REPORTING (Cur 3 Tot 228327)
2024-10-21 08:04:52.686436 100.00% [DEBUG] switch_core_state_machine.c:932 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State REPORTING
2024-10-21 08:04:52.686436 100.00% [INFO] mod_json_cdr.c:271 Process [686e5f00-7d8d-433a-b743-e73a1976a934.cdr.json]
2024-10-21 08:04:52.826436 100.00% [DEBUG] switch_core_state_machine.c:168 sofia/default/6089139952@Tal4812.newsip.israelnumber.com Standard REPORTING, cause: ORIGINATOR_CANCEL
2024-10-21 08:04:52.826436 100.00% [DEBUG] switch_core_state_machine.c:932 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State REPORTING going to sleep
2024-10-21 08:04:52.826436 100.00% [DEBUG] switch_core_state_machine.c:607 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State Change CS_REPORTING -> CS_DESTROY
2024-10-21 08:04:52.826436 100.00% [DEBUG] switch_core_session.c:1753 Session 228326 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) Locked, Waiting on external entities
2024-10-21 08:04:52.826436 100.00% [NOTICE] switch_core_session.c:1771 Session 228326 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) Ended
2024-10-21 08:04:52.826436 100.00% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/6089139952@Tal4812.newsip.israelnumber.com [CS_DESTROY]
2024-10-21 08:04:52.826436 100.00% [DEBUG] switch_core_state_machine.c:735 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) Running State Change CS_DESTROY (Cur 2 Tot 228327)
2024-10-21 08:04:52.826436 100.00% [DEBUG] switch_core_state_machine.c:745 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State DESTROY
2024-10-21 08:04:52.826436 100.00% [DEBUG] mod_sofia.c:379 sofia/default/6089139952@Tal4812.newsip.israelnumber.com SOFIA DESTROY
2024-10-21 08:04:52.826436 100.00% [DEBUG] switch_core_state_machine.c:175 sofia/default/6089139952@Tal4812.newsip.israelnumber.com Standard DESTROY
2024-10-21 08:04:52.826436 100.00% [DEBUG] switch_core_state_machine.c:745 (sofia/default/6089139952@Tal4812.newsip.israelnumber.com) State DESTROY going to sleep
2024-10-21 08:04:53.026440 100.00% [DEBUG] switch_scheduler.c:147 Deleting task 167719 switch_core_session_sched_heartbeat (686e5f00-7d8d-433a-b743-e73a1976a934)