2022-01-04 07:05:33.982559 99.87% [NOTICE] switch_channel.c:1123 New Channel sofia/external_sip/6974108809@voips.modulus.gr [9b455614-7032-4d78-991a-a39461de205c]
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_state_machine.c:581 (sofia/external_sip/6974108809@voips.modulus.gr) Running State Change CS_NEW (Cur 1 Tot 3293)
2022-01-04 07:05:33.982559 99.87% [INFO] sofia.c:10462 sofia/external_sip/6974108809@voips.modulus.gr receiving invite from 185.73.43.250:5060 version: 1.10.7 -release-19-883d2cb662 64bit call-id: 0ae7bb652227c4cf1eee4bec35ad3f34@voips.modulus.gr
2022-01-04 07:05:33.982559 99.87% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 185.73.43.250:0.
2022-01-04 07:05:33.982559 99.87% [DEBUG] sofia.c:7499 Channel sofia/external_sip/6974108809@voips.modulus.gr entering state [received][100]
2022-01-04 07:05:33.982559 99.87% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=root 2044131157 2044131157 IN IP4 185.73.42.252
s=modCOM v2 Media Gateway
c=IN IP4 185.73.42.252
t=0 0
m=audio 38216 RTP/AVP 8 9 0 18 101
a=rtpmap:8 PCMA/8000
a=rtpmap:9 G722/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:18 G729/8000
a=fmtp:18 annexb=no
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-16
a=rtcp:38217
a=ptime:20

2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:20:8000:1]
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [G722:9:8000:20:64000:1]/[G729:18:8000:20:8000:1]
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:20:8000:1]
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMA:8:8000:20:64000:1]
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [G729:18:8000:20:8000:1]/[G729:18:8000:20:8000:1]
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [G729:18:8000:20:8000:1] ++++ is saved as a match
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_media.c:3870 Set Codec sofia/external_sip/6974108809@voips.modulus.gr PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_codec.c:111 sofia/external_sip/6974108809@voips.modulus.gr Original read codec set to PCMA:8
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_media.c:5973 sofia/external_sip/6974108809@voips.modulus.gr Set 2833 dtmf send payload to 101 recv payload to 101
2022-01-04 07:05:33.982559 99.87% [DEBUG] sofia.c:7933 (sofia/external_sip/6974108809@voips.modulus.gr) State Change CS_NEW -> CS_INIT
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_state_machine.c:600 (sofia/external_sip/6974108809@voips.modulus.gr) State NEW
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_state_machine.c:581 (sofia/external_sip/6974108809@voips.modulus.gr) Running State Change CS_INIT (Cur 1 Tot 3293)
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_state_machine.c:624 (sofia/external_sip/6974108809@voips.modulus.gr) State INIT
2022-01-04 07:05:33.982559 99.87% [DEBUG] mod_sofia.c:97 sofia/external_sip/6974108809@voips.modulus.gr SOFIA INIT
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_state_machine.c:40 sofia/external_sip/6974108809@voips.modulus.gr Standard INIT
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_state_machine.c:48 (sofia/external_sip/6974108809@voips.modulus.gr) State Change CS_INIT -> CS_ROUTING
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_state_machine.c:624 (sofia/external_sip/6974108809@voips.modulus.gr) State INIT going to sleep
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_state_machine.c:581 (sofia/external_sip/6974108809@voips.modulus.gr) Running State Change CS_ROUTING (Cur 1 Tot 3293)
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_channel.c:2380 (sofia/external_sip/6974108809@voips.modulus.gr) Callstate Change DOWN -> RINGING
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_state_machine.c:640 (sofia/external_sip/6974108809@voips.modulus.gr) State ROUTING
2022-01-04 07:05:33.982559 99.87% [DEBUG] mod_sofia.c:158 sofia/external_sip/6974108809@voips.modulus.gr SOFIA ROUTING
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_core_state_machine.c:230 sofia/external_sip/6974108809@voips.modulus.gr Standard ROUTING
2022-01-04 07:05:33.982559 99.87% [INFO] mod_dialplan_xml.c:639 Processing 6974108809 <6974108809>->2102202732 in context default
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2022-01-04 07:05:33.982559 99.87% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [xml_handler] Params:
Event-Name: REQUEST_PARAMS
Core-UUID: 7c1eed07-34ee-474f-964d-a5cb6e2e7c68
FreeSWITCH-Hostname: billing
FreeSWITCH-Switchname: billing
FreeSWITCH-IPv4: 172.16.0.30
FreeSWITCH-IPv6: %3A%3A1
Event-Date-Local: 2022-01-04%2007%3A05%3A33
Event-Date-GMT: Tue,%2004%20Jan%202022%2007%3A05%3A33%20GMT
Event-Date-Timestamp: 1641279933982559
Event-Calling-File: mod_dialplan_xml.c
Event-Calling-Function: dialplan_xml_locate
Event-Calling-Line-Number: 610
Event-Sequence: 488085
Channel-State: CS_ROUTING
Channel-Call-State: RINGING
Channel-State-Number: 2
Channel-Name: sofia/external_sip/6974108809%40voips.modulus.gr
Unique-ID: 9b455614-7032-4d78-991a-a39461de205c
Call-Direction: inbound
Presence-Call-Direction: inbound
Channel-HIT-Dialplan: true
Channel-Call-UUID: 9b455614-7032-4d78-991a-a39461de205c
Answer-State: ringing
Channel-Read-Codec-Name: PCMA
Channel-Read-Codec-Rate: 8000
Channel-Read-Codec-Bit-Rate: 64000
Channel-Write-Codec-Name: PCMA
Channel-Write-Codec-Rate: 8000
Channel-Write-Codec-Bit-Rate: 64000
Caller-Direction: inbound
Caller-Logical-Direction: inbound
Caller-Username: 6974108809
Caller-Dialplan: XML
Caller-Caller-ID-Name: 6974108809
Caller-Caller-ID-Number: 6974108809
Caller-Orig-Caller-ID-Name: 6974108809
Caller-Orig-Caller-ID-Number: 6974108809
Caller-Network-Addr: 185.73.43.250
Caller-ANI: 6974108809
Caller-Destination-Number: 2102202732
Caller-Unique-ID: 9b455614-7032-4d78-991a-a39461de205c
Caller-Source: mod_sofia
Caller-Context: default
Caller-Channel-Name: sofia/external_sip/6974108809%40voips.modulus.gr
Caller-Profile-Index: 1
Caller-Profile-Created-Time: 1641279933982559
Caller-Channel-Created-Time: 1641279933982559
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: false
Caller-Privacy-Hide-Name: false
Caller-Privacy-Hide-Number: false
variable_direction: inbound
variable_uuid: 9b455614-7032-4d78-991a-a39461de205c
variable_session_id: 3293
variable_sip_from_user: 6974108809
variable_sip_from_uri: 6974108809%40voips.modulus.gr
variable_sip_from_host: voips.modulus.gr
variable_video_media_flow: disabled
variable_text_media_flow: disabled
variable_channel_name: sofia/external_sip/6974108809%40voips.modulus.gr
variable_sip_call_id: 0ae7bb652227c4cf1eee4bec35ad3f34%40voips.modulus.gr
variable_sip_local_network_addr: 94.130.242.106
variable_sip_network_ip: 185.73.43.250
variable_sip_network_port: 5060
variable_sip_invite_stamp: 1641279933982559
variable_sip_received_ip: 185.73.43.250
variable_sip_received_port: 5060
variable_sip_via_protocol: udp
variable_sip_from_user_stripped: 6974108809
variable_sip_from_tag: as7e2b932e
variable_sofia_profile_name: external_sip
variable_sofia_profile_url: sip%3Amod_sofia%4094.130.242.106%3A6080
variable_recovery_profile_name: external_sip
variable_sip_Remote-Party-ID: %226974108809%22%20%3Csip%3A6974108809%40voips.modulus.gr%3E%3Bparty%3Dcalling%3Bprivacy%3Doff%3Bscreen%3Dno
variable_sip_cid_type: rpid
variable_sip_full_via: SIP/2.0/UDP%20185.73.43.250%3Bbranch%3Dz9hG4bK3088.973d47132483419dbfa1ef46c466b82a.0
variable_sip_full_from: %3Csip%3A6974108809%40voips.modulus.gr%3E%3Btag%3Das7e2b932e
variable_sip_full_to: %3Csip%3A2102202732%40voips.modulus.gr%3E
variable_sip_allow: INVITE,%20ACK,%20CANCEL,%20OPTIONS,%20BYE,%20REFER,%20SUBSCRIBE,%20NOTIFY,%20INFO,%20PUBLISH,%20MESSAGE
variable_sip_req_user: 2102202732
variable_sip_req_uri: 2102202732%40voips.modulus.gr
variable_sip_req_host: voips.modulus.gr
variable_sip_to_user: 2102202732
variable_sip_to_uri: 2102202732%40voips.modulus.gr
variable_sip_to_host: voips.modulus.gr
variable_sip_contact_user: btpsh-61d3a5e9-2958-aa0b5
variable_sip_contact_uri: btpsh-61d3a5e9-2958-aa0b5%40185.73.43.250
variable_sip_contact_host: 185.73.43.250
variable_sip_user_agent: modCOM%20v2%20SIP%20Server
variable_sip_via_host: 185.73.43.250
variable_max_forwards: 68
variable_sip_date_epoch_time: 1641279933
variable_switch_r_sdp: v%3D0%0D%0Ao%3Droot%202044131157%202044131157%20IN%20IP4%20185.73.42.252%0D%0As%3DmodCOM%20v2%20Media%20Gateway%0D%0Ac%3DIN%20IP4%20185.73.42.252%0D%0At%3D0%200%0D%0Am%3Daudio%2038216%20RTP/AVP%208%209%200%2018%20101%0D%0Aa%3Drtpmap%3A8%20PCMA/8000%0D%0Aa%3Drtpmap%3A9%20G722/8000%0D%0Aa%3Drtpmap%3A0%20PCMU/8000%0D%0Aa%3Drtpmap%3A18%20G729/8000%0D%0Aa%3Dfmtp%3A18%20annexb%3Dno%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dfmtp%3A101%200-16%0D%0Aa%3Drtcp%3A38217%0D%0Aa%3Dptime%3A20%0D%0A
variable_ep_codec_string: CORE_PCM_MODULE.PCMA%408000h%4020i%4064000b,mod_g729.G729%408000h%4020i%408000b
variable_rtp_use_codec_string: PCMA,OPUS,G729
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_remote_audio_rtcp_port: 38217
variable_remote_media_ip: 185.73.42.252
variable_remote_media_port: 38216
variable_rtp_audio_recv_pt: 8
variable_rtp_use_codec_name: PCMA
variable_rtp_use_codec_rate: 8000
variable_rtp_use_codec_ptime: 20
variable_rtp_use_codec_channels: 1
variable_rtp_last_audio_codec_string: PCMA%408000h%4020i%401c
variable_read_codec: PCMA
variable_original_read_codec: PCMA
variable_read_rate: 8000
variable_original_read_rate: 8000
variable_write_codec: PCMA
variable_write_rate: 8000
variable_dtmf_type: rfc2833
variable_endpoint_disposition: RECEIVED
variable_call_uuid: 9b455614-7032-4d78-991a-a39461de205c
Hunt-Direction: inbound
Hunt-Logical-Direction: inbound
Hunt-Username: 6974108809
Hunt-Dialplan: XML
Hunt-Caller-ID-Name: 6974108809
Hunt-Caller-ID-Number: 6974108809
Hunt-Orig-Caller-ID-Name: 6974108809
Hunt-Orig-Caller-ID-Number: 6974108809
Hunt-Network-Addr: 185.73.43.250
Hunt-ANI: 6974108809
Hunt-Destination-Number: 2102202732
Hunt-Unique-ID: 9b455614-7032-4d78-991a-a39461de205c
Hunt-Source: mod_sofia
Hunt-Context: default
Hunt-Channel-Name: sofia/external_sip/6974108809%40voips.modulus.gr
Hunt-Profile-Index: 1
Hunt-Profile-Created-Time: 1641279933982559
Hunt-Channel-Created-Time: 1641279933982559
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: false
Hunt-Privacy-Hide-Name: false
Hunt-Privacy-Hide-Number: false


2022-01-04 07:05:33.982559 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] section: dialplan
2022-01-04 07:05:33.982559 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] key_name: 
2022-01-04 07:05:33.982559 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] tag_name: 
2022-01-04 07:05:33.982559 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] key_value: 
2022-01-04 07:05:33.982559 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 2102202732
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '2102202732' AND status=0 limit 1
2022-01-04 07:05:33.982559 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 6974108809 / 6974108809
2022-01-04 07:05:33.982559 99.87% [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.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 ="2102202732" LIMIT 1
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT 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 WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="2102202732" limit 1
2022-01-04 07:05:33.982559 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_cpp.cpp:1465 [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("185.73.43.250") 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 "2102202732"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
2022-01-04 07:05:33.982559 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 2976257734]
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "2976257734" AND deleted = 0 limit 1
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^2102202732.*' OR blocked_patterns = '^210220273.*' OR blocked_patterns = '^21022027.*' OR blocked_patterns = '^2102202.*' OR blocked_patterns = '^210220.*' OR blocked_patterns = '^21022.*' OR blocked_patterns = '^2102.*' OR blocked_patterns = '^210.*' OR blocked_patterns = '^21.*' OR blocked_patterns = '^2.*' OR blocked_patterns ='--') AND accountid = 9 limit 1 
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="2102202732" AND (accountid = 0 OR status = 1) LIMIT 1
2022-01-04 07:05:33.982559 99.87% [NOTICE] switch_cpp.cpp:1465 [ASTPP] Localization Id: 1
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 1 AND status=0 limit 1 
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"00/*,2/302,6/306,1/301,7/307,8/308".....2102202732
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"00/*,2/302,6/306,1/301,7/307,8/308".....2102202732
2022-01-04 07:05:33.982559 99.87% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] Before Localization CLI/DST : 2102202732
2022-01-04 07:05:33.982559 99.87% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] After Localization CLI/DST : 302102202732
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"00/*,2/302,6/306,1/301,7/307,8/308".....302102202732
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"00/*,2/302,6/306,1/301,7/307,8/308".....302102202732
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"00/*,2/302,6/306,1/301,7/307,8/308".....302102202732
2022-01-04 07:05:33.982559 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"00/*,2/302,6/306,1/301,7/307,8/308".....302102202732
2022-01-04 07:05:33.982559 99.87% [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 = '^302102202732.*' OR patterns = '^30210220273.*' OR patterns = '^3021022027.*' OR patterns = '^302102202.*' OR patterns = '^30210220.*' OR patterns = '^3021022.*' OR patterns = '^302102.*' OR patterns = '^30210.*' OR patterns = '^3021.*' OR patterns = '^302.*' OR patterns = '^30.*' OR patterns = '^3.*' OR patterns ='--') AND accountid = 9 ORDER BY LENGTH(PKGPTR.patterns) DESC
2022-01-04 07:05:33.982559 99.87% [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 ="302102202732" AND A.accountid = '9' limit 1
2022-01-04 07:05:33.982559 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 302102202732
2022-01-04 07:05:33.982559 99.87% [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.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 ="302102202732" LIMIT 1
2022-01-04 07:05:33.982559 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
2022-01-04 07:05:33.982559 99.87% [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 = '302102202732' OR number = '30210220273' OR number = '3021022027' OR number = '302102202' OR number = '30210220' OR number = '3021022' OR number = '302102' OR number = '30210' OR number = '3021' OR number = '302' OR number = '30' OR number = '3' OR number ='--') OR (number = '302102202732*' OR number = '30210220273*' OR number = '3021022027*' OR number = '302102202*' OR number = '30210220*' OR number = '3021022*' OR number = '302102*' OR number = '30210*' OR number = '3021*' OR number = '302*' OR number = '30*' OR number = '3*' OR number ='--') OR (number = '6974108809' OR number = '697410880' OR number = '69741088' OR number = '6974108' OR number = '697410' OR number = '69741' OR number = '6974' OR number = '697' OR number = '69' OR number = '6' OR number ='--') OR (number = '6974108809*' OR number = '697410880*' OR number = '69741088*' OR number = '6974108*' OR number = '697410*' OR number = '69741*' OR number = '6974*' OR number = '697*' OR number = '69*' OR number = '6*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '302102202732' OR routing_prefix = '30210220273' OR routing_prefix = '3021022027' OR routing_prefix = '302102202' OR routing_prefix = '30210220' OR routing_prefix = '3021022' OR routing_prefix = '302102' OR routing_prefix = '30210' OR routing_prefix = '3021' OR routing_prefix = '302' OR routing_prefix = '30' OR routing_prefix = '3' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 9
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 2976257734
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 10000
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 2
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 6
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 2 AND status = 0
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
2022-01-04 07:05:34.002571 99.87% [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.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 ="302102202732" LIMIT 1
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 1
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 302102202732
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 75
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 9
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your10000 balance Accountid 9 !!!
2022-01-04 07:05:34.002571 99.87% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE ID 9
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE RATE 0.00000
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE CONNECT COST 0.00000
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE INITIAL INC 0
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE INC 0
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
2022-01-04 07:05:34.002571 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 = 9 AND status=0 LIMIT 1
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "11" AND deleted = 0 limit 1
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:9
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:9
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 9
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2022-01-04 07:05:34.002571 99.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"2/302,6/306".....6974108809
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"2/302,6/306".....6974108809
2022-01-04 07:05:34.002571 99.87% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] Before Localization CLI/DST : 6974108809
2022-01-04 07:05:34.002571 99.87% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] After Localization CLI/DST : 306974108809
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"2/302,6/306".....6974108809
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"2/302,6/306".....6974108809
2022-01-04 07:05:34.002571 99.87% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] Before Localization CLI/DST : 6974108809
2022-01-04 07:05:34.002571 99.87% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] After Localization CLI/DST : 306974108809
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 11  and status = 0 limit 1
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_5
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [NOTIFY] START:
2022-01-04 07:05:34.002571 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="302102202732">
<condition field="destination_number" expression="2102202732">
<action application="set" data="effective_destination_number=302102202732"/>
<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="nibble_account=9"/>
<action application="set" data="nibble_rate=0.00000"/>
<action application="set" data="nibble_increment=0"/>
<action application="set" data="nibble_minimum=0.00000"/>
<action application="nibblebill" data="heartbeat 30"/>
<action application="set" data="callstart=2022-01-04 07:05:34"/>
<action application="set" data="hangup_after_bridge=true"/>
<action application="set" data="continue_on_fail=TRUE"/>
<action application="set" data="account_id=9"/>
<action application="set" data="parent_id=0"/>
<action application="set" data="entity_id=3"/>
<action application="set" data="call_processed=internal"/>
<action application="set" data="call_direction=inbound"/>
<action application="set" data="accountname=ModulusIncoming"/>
<action application="set" data="origination_rates_did=ID:1|CODE:^302102202732.*|DESTINATION:302102202732|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:5|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:75|ACCID:11"/>
<action application="set" data="origination_rates=0"/>
<action application="set" data="original_caller_id_name=6974108809"/>
<action application="set" data="original_caller_id_number=6974108809"/>
<action application="limit" data="db 2976257734 user_2976257734 60 "/>
<action application="limit" data="db 11 user_11 2 "/>
<action application="set" data="effective_caller_id_name=306974108809"/>
<action application="set" data="effective_caller_id_number=306974108809"/>
<action application="set" data="receiver_accid=11"/>
<action application="export" data="domain_name="/>
<action application="export" data="sip_to_host="/>
<action application="limit" data="db 302102202732 did_302102202732 2 "/>
<action application="export" data="presence_data=x|||Martha(7772615170)|||||||||DID|||185.73.43.250"/>
<action application="export" data="call_type=5"/>
<action application="set" data="calltype=SIP-DID"/>
<action application="bridge" data="{sip_contact_user=302102202732}[leg_timeout=0]sofia/${sofia_profile_name}/302102202732${regex(${sofia_contact(7772615170@${domain_name})}|^[^@]+(.*)|%1)}"/>
<condition field="${cond(${user_data 7772615170@${domain_name} param vm-enabled} == true ? YES : NO)}" expression="^YES$">
<action application="answer"/>
<action application="export" data="voicemail_alternate_greet_id=302102202732"/>
<action application="voicemail" data="default $${domain_name} 7772615170"/>
<anti-action application="hangup" data="${originate_disposition}"/>
</condition>
<action application="set" data="did_id=1"/>
<action application="set" data="destination_number=302102202732"/>
<action application="set" data="leg_timeout=0"/>
<action application="set" data="call_type_vm_flag=1"/>
<action application="set" data="is_local_extension=1"/>
<action application="lua" data="did_call_forwarding.lua"/>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr parsing [default->302102202732] continue=false
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Regex (PASS) [302102202732] destination_number(2102202732) =~ /2102202732/ break=on-false
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(effective_destination_number=302102202732) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(bridge_pre_execute_bleg_app=sched_hangup) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(nibble_account=9) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(nibble_rate=0.00000) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(nibble_increment=0) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(nibble_minimum=0.00000) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action nibblebill(heartbeat 30) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(callstart=2022-01-04 07:05:34) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(hangup_after_bridge=true) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(continue_on_fail=TRUE) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(account_id=9) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(parent_id=0) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(entity_id=3) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(call_processed=internal) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(call_direction=inbound) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(accountname=ModulusIncoming) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(origination_rates_did=ID:1|CODE:^302102202732.*|DESTINATION:302102202732|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:5|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:75|ACCID:11) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(origination_rates=0) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(original_caller_id_name=6974108809) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(original_caller_id_number=6974108809) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action limit(db 2976257734 user_2976257734 60 ) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action limit(db 11 user_11 2 ) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(effective_caller_id_name=306974108809) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(effective_caller_id_number=306974108809) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(receiver_accid=11) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action export(domain_name=) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action export(sip_to_host=) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action limit(db 302102202732 did_302102202732 2 ) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action export(presence_data=x|||Martha(7772615170)|||||||||DID|||185.73.43.250) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action export(call_type=5) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(calltype=SIP-DID) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action bridge({sip_contact_user=302102202732}[leg_timeout=0]sofia/${sofia_profile_name}/302102202732${regex(${sofia_contact(7772615170@${domain_name})}|^[^@]+(.*)|%1)}) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(did_id=1) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(destination_number=302102202732) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(leg_timeout=0) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(call_type_vm_flag=1) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(is_local_extension=1) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action lua(did_call_forwarding.lua) 
|--- Dialplan: Processing recursive conditions level:1 [302102202732_recur_1] require-nested=TRUE
|--- Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Regex (PASS) [302102202732_recur_1] ${cond(${user_data 7772615170@${domain_name} param vm-enabled} == true ? YES : NO)}(YES) =~ /^YES$/ break=on-false
|--- Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action answer() 
|--- Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action export(voicemail_alternate_greet_id=302102202732) 
|--- Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action voicemail(default $${domain_name} 7772615170) 
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_core_state_machine.c:281 (sofia/external_sip/6974108809@voips.modulus.gr) State Change CS_ROUTING -> CS_EXECUTE
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_core_state_machine.c:640 (sofia/external_sip/6974108809@voips.modulus.gr) State ROUTING going to sleep
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_core_state_machine.c:581 (sofia/external_sip/6974108809@voips.modulus.gr) Running State Change CS_EXECUTE (Cur 1 Tot 3293)
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_core_state_machine.c:647 (sofia/external_sip/6974108809@voips.modulus.gr) State EXECUTE
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_sofia.c:213 sofia/external_sip/6974108809@voips.modulus.gr SOFIA EXECUTE
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_core_state_machine.c:323 sofia/external_sip/6974108809@voips.modulus.gr Standard EXECUTE
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(effective_destination_number=302102202732)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [effective_destination_number]=[302102202732]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(bridge_pre_execute_bleg_app=sched_hangup)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [bridge_pre_execute_bleg_app]=[sched_hangup]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [bridge_pre_execute_bleg_data]=[+6000 normal_clearing]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(nibble_account=9)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [nibble_account]=[9]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(nibble_rate=0.00000)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [nibble_rate]=[0.00000]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(nibble_increment=0)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [nibble_increment]=[0]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(nibble_minimum=0.00000)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [nibble_minimum]=[0.00000]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr nibblebill(heartbeat 30)
2022-01-04 07:05:34.002571 99.87% [WARNING] switch_core_session.c:1693 sofia/external_sip/6974108809@voips.modulus.gr using scheduler due to bypass media or media is not established.
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_scheduler.c:263 Added task 1896 switch_core_session_sched_heartbeat (9b455614-7032-4d78-991a-a39461de205c) to run at 1641279964
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(callstart=2022-01-04 07:05:34)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [callstart]=[2022-01-04 07:05:34]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(hangup_after_bridge=true)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [hangup_after_bridge]=[true]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(continue_on_fail=TRUE)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [continue_on_fail]=[TRUE]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(account_id=9)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [account_id]=[9]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(parent_id=0)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [parent_id]=[0]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(entity_id=3)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [entity_id]=[3]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(call_processed=internal)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [call_processed]=[internal]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(call_direction=inbound)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [call_direction]=[inbound]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(accountname=ModulusIncoming)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [accountname]=[ModulusIncoming]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(origination_rates_did=ID:1|CODE:^302102202732.*|DESTINATION:302102202732|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:5|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:75|ACCID:11)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [origination_rates_did]=[ID:1|CODE:^302102202732.*|DESTINATION:302102202732|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:5|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:75|ACCID:11]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(origination_rates=0)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [origination_rates]=[0]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(original_caller_id_name=6974108809)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [original_caller_id_name]=[6974108809]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(original_caller_id_number=6974108809)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [original_caller_id_number]=[6974108809]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr limit(db 2976257734 user_2976257734 60 )
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_limit.c:124 incr called: 2976257734_user_2976257734 max:60, interval:0
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_db.c:194 Usage for 2976257734_user_2976257734 is now 1/60
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr limit(db 11 user_11 2 )
2022-01-04 07:05:34.002571 99.87% [DEBUG] switch_limit.c:124 incr called: 11_user_11 max:2, interval:0
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_db.c:194 Usage for 11_user_11 is now 1/2
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(effective_caller_id_name=306974108809)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [effective_caller_id_name]=[306974108809]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(effective_caller_id_number=306974108809)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [effective_caller_id_number]=[306974108809]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(receiver_accid=11)
2022-01-04 07:05:34.002571 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [receiver_accid]=[11]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr export(domain_name=)
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [domain_name]=[UNDEF]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr export(sip_to_host=)
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [sip_to_host]=[UNDEF]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr limit(db 302102202732 did_302102202732 2 )
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_limit.c:124 incr called: 302102202732_did_302102202732 max:2, interval:0
2022-01-04 07:05:34.022564 99.87% [DEBUG] mod_db.c:194 Usage for 302102202732_did_302102202732 is now 1/2
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr export(presence_data=x|||Martha(7772615170)|||||||||DID|||185.73.43.250)
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[x|||Martha(7772615170)|||||||||DID|||185.73.43.250]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr export(call_type=5)
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [call_type]=[5]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(calltype=SIP-DID)
2022-01-04 07:05:34.022564 99.87% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [calltype]=[SIP-DID]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr bridge({sip_contact_user=302102202732}[leg_timeout=0]sofia/external_sip/302102202732@194.219.29.89:6060;rinstance=0689c485a096b61c;fs_nat=yes;fs_path=sip%3A7772615170%40194.219.29.89%3A6060%3Brinstance%3D0689c485a096b61c)
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_channel.c:1269 sofia/external_sip/6974108809@voips.modulus.gr EXPORTING[export_vars] [presence_data]=[x|||Martha(7772615170)|||||||||DID|||185.73.43.250] to event
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_channel.c:1269 sofia/external_sip/6974108809@voips.modulus.gr EXPORTING[export_vars] [call_type]=[5] to event
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_ivr_originate.c:2843 Parsing session specific variables
2022-01-04 07:05:34.022564 99.87% [NOTICE] switch_channel.c:1123 New Channel sofia/external_sip/302102202732@194.219.29.89:6060 [8a068e3b-80b6-438f-88b7-9ed36af7217a]
2022-01-04 07:05:34.022564 99.87% [DEBUG] mod_sofia.c:5121 (sofia/external_sip/302102202732@194.219.29.89:6060) State Change CS_NEW -> CS_INIT
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_core_state_machine.c:581 (sofia/external_sip/302102202732@194.219.29.89:6060) Running State Change CS_INIT (Cur 2 Tot 3294)
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_core_state_machine.c:624 (sofia/external_sip/302102202732@194.219.29.89:6060) State INIT
2022-01-04 07:05:34.022564 99.87% [DEBUG] mod_sofia.c:97 sofia/external_sip/302102202732@194.219.29.89:6060 SOFIA INIT
2022-01-04 07:05:34.022564 99.87% [DEBUG] sofia_glue.c:1620 sip:7772615170@194.219.29.89:6060;rinstance=0689c485a096b61c Setting proxy route to sofia/external_sip/302102202732@194.219.29.89:6060
2022-01-04 07:05:34.022564 99.87% [INFO] sofia_glue.c:1651 sofia/external_sip/302102202732@194.219.29.89:6060 sending invite call-id: (null)
2022-01-04 07:05:34.022564 99.87% [DEBUG] sofia_glue.c:1654 sofia/external_sip/302102202732@194.219.29.89:6060 sending invite version: 1.10.7 -release-19-883d2cb662 64bit
Local SDP:
v=0
o=FreeSWITCH 1641259102 1641259103 IN IP4 94.130.242.106
s=FreeSWITCH
c=IN IP4 94.130.242.106
t=0 0
m=audio 20832 RTP/AVP 8 101
a=rtpmap:8 PCMA/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
a=sendrecv

2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_core_state_machine.c:40 sofia/external_sip/302102202732@194.219.29.89:6060 Standard INIT
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_core_state_machine.c:48 (sofia/external_sip/302102202732@194.219.29.89:6060) State Change CS_INIT -> CS_ROUTING
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_core_state_machine.c:624 (sofia/external_sip/302102202732@194.219.29.89:6060) State INIT going to sleep
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_core_state_machine.c:581 (sofia/external_sip/302102202732@194.219.29.89:6060) Running State Change CS_ROUTING (Cur 2 Tot 3294)
2022-01-04 07:05:34.022564 99.87% [DEBUG] sofia.c:7499 Channel sofia/external_sip/302102202732@194.219.29.89:6060 entering state [calling][0]
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_core_state_machine.c:640 (sofia/external_sip/302102202732@194.219.29.89:6060) State ROUTING
2022-01-04 07:05:34.022564 99.87% [DEBUG] mod_sofia.c:158 sofia/external_sip/302102202732@194.219.29.89:6060 SOFIA ROUTING
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_ivr_originate.c:67 (sofia/external_sip/302102202732@194.219.29.89:6060) State Change CS_ROUTING -> CS_CONSUME_MEDIA
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_core_state_machine.c:640 (sofia/external_sip/302102202732@194.219.29.89:6060) State ROUTING going to sleep
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_core_state_machine.c:581 (sofia/external_sip/302102202732@194.219.29.89:6060) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 3294)
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_core_state_machine.c:659 (sofia/external_sip/302102202732@194.219.29.89:6060) State CONSUME_MEDIA
2022-01-04 07:05:34.022564 99.87% [DEBUG] switch_core_state_machine.c:659 (sofia/external_sip/302102202732@194.219.29.89:6060) State CONSUME_MEDIA going to sleep
2022-01-04 07:05:34.322557 99.87% [DEBUG] sofia.c:7499 Channel sofia/external_sip/302102202732@194.219.29.89:6060 entering state [proceeding][180]
2022-01-04 07:05:34.322557 99.87% [NOTICE] sofia.c:7610 Ring-Ready sofia/external_sip/302102202732@194.219.29.89:6060!
2022-01-04 07:05:34.322557 99.87% [DEBUG] switch_channel.c:3494 (sofia/external_sip/302102202732@194.219.29.89:6060) Callstate Change DOWN -> RINGING
2022-01-04 07:05:34.342559 99.87% [NOTICE] mod_sofia.c:2515 Ring-Ready sofia/external_sip/6974108809@voips.modulus.gr!
2022-01-04 07:05:34.342559 99.87% [DEBUG] sofia.c:7499 Channel sofia/external_sip/6974108809@voips.modulus.gr entering state [early][180]
2022-01-04 07:05:34.342559 99.87% [NOTICE] switch_ivr_originate.c:565 Ring Ready sofia/external_sip/6974108809@voips.modulus.gr!
2022-01-04 07:06:04.022564 98.97% [DEBUG] mod_nibblebill.c:695 Received request via SESSION_HEARTBEAT!
2022-01-04 07:06:04.022564 98.97% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.00000 per minute to account 9
2022-01-04 07:06:04.022564 98.97% [DEBUG] mod_nibblebill.c:518 Not billing 9 - call is not in answered state
2022-01-04 07:06:04.022564 98.97% [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='9']
2022-01-04 07:06:04.022564 98.97% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 9 (balance = 19.247050)
2022-01-04 07:06:04.022564 98.97% [DEBUG] mod_nibblebill.c:523 Comparing 19.247050 to hangup balance of 0.000000, taking into account minimum charge of 0.000000
2022-01-04 07:06:27.602583 99.13% [DEBUG] sofia_reg.c:2665 Changing expire time to 264 by request of proxy sip:voips.modulus.gr:5060
2022-01-04 07:06:34.002567 99.90% [NOTICE] switch_ivr_originate.c:3799 Hangup sofia/external_sip/302102202732@194.219.29.89:6060 [CS_CONSUME_MEDIA] [NO_ANSWER]
2022-01-04 07:06:34.002567 99.90% [DEBUG] switch_core_state_machine.c:581 (sofia/external_sip/302102202732@194.219.29.89:6060) Running State Change CS_HANGUP (Cur 2 Tot 3294)
2022-01-04 07:06:34.002567 99.90% [DEBUG] switch_core_state_machine.c:844 (sofia/external_sip/302102202732@194.219.29.89:6060) Callstate Change RINGING -> HANGUP
2022-01-04 07:06:34.002567 99.90% [DEBUG] switch_core_state_machine.c:846 (sofia/external_sip/302102202732@194.219.29.89:6060) State HANGUP
2022-01-04 07:06:34.002567 99.90% [DEBUG] mod_sofia.c:468 Channel sofia/external_sip/302102202732@194.219.29.89:6060 hanging up, cause: NO_ANSWER
2022-01-04 07:06:34.002567 99.90% [DEBUG] mod_sofia.c:536 Sending CANCEL to sofia/external_sip/302102202732@194.219.29.89:6060
2022-01-04 07:06:34.002567 99.90% [INFO] mod_dptools.c:3653 Originate Failed.  Cause: NO_ANSWER
2022-01-04 07:06:34.002567 99.90% [DEBUG] switch_core_state_machine.c:59 sofia/external_sip/302102202732@194.219.29.89:6060 Standard HANGUP, cause: NO_ANSWER
2022-01-04 07:06:34.002567 99.90% [DEBUG] switch_core_state_machine.c:846 (sofia/external_sip/302102202732@194.219.29.89:6060) State HANGUP going to sleep
2022-01-04 07:06:34.002567 99.90% [DEBUG] switch_core_state_machine.c:616 (sofia/external_sip/302102202732@194.219.29.89:6060) State Change CS_HANGUP -> CS_REPORTING
2022-01-04 07:06:34.002567 99.90% [DEBUG] switch_core_state_machine.c:581 (sofia/external_sip/302102202732@194.219.29.89:6060) Running State Change CS_REPORTING (Cur 2 Tot 3294)
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(did_id=1)
2022-01-04 07:06:34.002567 99.90% [DEBUG] switch_core_state_machine.c:932 (sofia/external_sip/302102202732@194.219.29.89:6060) State REPORTING
2022-01-04 07:06:34.002567 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [did_id]=[1]
2022-01-04 07:06:34.002567 99.90% [INFO] mod_json_cdr.c:271 Process [8a068e3b-80b6-438f-88b7-9ed36af7217a.cdr.json]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(destination_number=302102202732)
2022-01-04 07:06:34.002567 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [destination_number]=[302102202732]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(leg_timeout=0)
2022-01-04 07:06:34.002567 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [leg_timeout]=[0]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(call_type_vm_flag=1)
2022-01-04 07:06:34.002567 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [call_type_vm_flag]=[1]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(is_local_extension=1)
2022-01-04 07:06:34.002567 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [is_local_extension]=[1]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr lua(did_call_forwarding.lua)
2022-01-04 07:06:34.002567 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
2022-01-04 07:06:34.002567 99.90% [NOTICE] switch_cpp.cpp:1465 [ASTPP] SECTION 
2022-01-04 07:06:34.002567 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DID_Call_Forwading] This Is Last Opensips 1 This Is DiD Id : 
2022-01-04 07:06:34.002567 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DID_Call_Forwading] This Is Last Dispositions NO_ANSWER This Is DiD Id : 1
2022-01-04 07:06:34.002567 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP]  SQL : select number,extensions,always,always_destination,always_vm_flag,no_answer,no_answer_destination,no_answer_vm_flag from dids where id='1' and status='0' 
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr sleep(500)
2022-01-04 07:06:34.022570 99.90% [DEBUG] switch_core_state_machine.c:168 sofia/external_sip/302102202732@194.219.29.89:6060 Standard REPORTING, cause: NO_ANSWER
2022-01-04 07:06:34.022570 99.90% [DEBUG] switch_core_state_machine.c:932 (sofia/external_sip/302102202732@194.219.29.89:6060) State REPORTING going to sleep
2022-01-04 07:06:34.022570 99.90% [DEBUG] switch_core_state_machine.c:607 (sofia/external_sip/302102202732@194.219.29.89:6060) State Change CS_REPORTING -> CS_DESTROY
2022-01-04 07:06:34.022570 99.90% [DEBUG] switch_core_session.c:1753 Session 3294 (sofia/external_sip/302102202732@194.219.29.89:6060) Locked, Waiting on external entities
2022-01-04 07:06:34.022570 99.90% [NOTICE] switch_core_session.c:1771 Session 3294 (sofia/external_sip/302102202732@194.219.29.89:6060) Ended
2022-01-04 07:06:34.022570 99.90% [NOTICE] switch_core_session.c:1775 Close Channel sofia/external_sip/302102202732@194.219.29.89:6060 [CS_DESTROY]
2022-01-04 07:06:34.022570 99.90% [DEBUG] switch_core_state_machine.c:735 (sofia/external_sip/302102202732@194.219.29.89:6060) Running State Change CS_DESTROY (Cur 1 Tot 3294)
2022-01-04 07:06:34.022570 99.90% [DEBUG] switch_core_state_machine.c:745 (sofia/external_sip/302102202732@194.219.29.89:6060) State DESTROY
2022-01-04 07:06:34.022570 99.90% [DEBUG] mod_sofia.c:379 sofia/external_sip/302102202732@194.219.29.89:6060 SOFIA DESTROY
2022-01-04 07:06:34.022570 99.90% [DEBUG] switch_core_state_machine.c:175 sofia/external_sip/302102202732@194.219.29.89:6060 Standard DESTROY
2022-01-04 07:06:34.022570 99.90% [DEBUG] switch_core_state_machine.c:745 (sofia/external_sip/302102202732@194.219.29.89:6060) State DESTROY going to sleep
2022-01-04 07:06:34.022570 99.90% [DEBUG] mod_nibblebill.c:695 Received request via SESSION_HEARTBEAT!
2022-01-04 07:06:34.022570 99.90% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.00000 per minute to account 9
2022-01-04 07:06:34.022570 99.90% [DEBUG] mod_nibblebill.c:518 Not billing 9 - call is not in answered state
2022-01-04 07:06:34.022570 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='9']
2022-01-04 07:06:34.022570 99.90% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 9 (balance = 19.247050)
2022-01-04 07:06:34.022570 99.90% [DEBUG] mod_nibblebill.c:523 Comparing 19.247050 to hangup balance of 0.000000, taking into account minimum charge of 0.000000
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP]  This Is Calltype : 4And Destination : 2105762903
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:773 CoreSession::setVariable('DID_NUMBER', '(null)')
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:773 CoreSession::setVariable('call_forwarding', 'true')
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:773 CoreSession::setVariable('last_did_rates', '(null)')
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:773 CoreSession::setVariable('calltype', 'STANDARD')
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr transfer(2105762903 XML default)
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_ivr.c:2289 (sofia/external_sip/6974108809@voips.modulus.gr) State Change CS_EXECUTE -> CS_ROUTING
2022-01-04 07:06:34.522564 99.90% [NOTICE] switch_ivr.c:2296 Transfer sofia/external_sip/6974108809@voips.modulus.gr to XML[2105762903@default]
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1209 sofia/external_sip/6974108809@voips.modulus.gr destroy/unlink session from object
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:647 (sofia/external_sip/6974108809@voips.modulus.gr) State EXECUTE going to sleep
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:581 (sofia/external_sip/6974108809@voips.modulus.gr) Running State Change CS_ROUTING (Cur 1 Tot 3294)
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:640 (sofia/external_sip/6974108809@voips.modulus.gr) State ROUTING
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_sofia.c:149 Call appears to be already acknowledged
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_sofia.c:158 sofia/external_sip/6974108809@voips.modulus.gr SOFIA ROUTING
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.00000 per minute to account 9
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_nibblebill.c:518 Not billing 9 - call is not in answered state
2022-01-04 07:06:34.522564 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='9']
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 9 (balance = 19.247050)
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_nibblebill.c:523 Comparing 19.247050 to hangup balance of 0.000000, taking into account minimum charge of 0.000000
2022-01-04 07:06:34.522564 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='9']
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 9 (balance = 19.247050)
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:230 sofia/external_sip/6974108809@voips.modulus.gr Standard ROUTING
2022-01-04 07:06:34.522564 99.90% [INFO] mod_dialplan_xml.c:639 Processing 6974108809 <6974108809>->2105762903 in context default
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2022-01-04 07:06:34.522564 99.90% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [xml_handler] Params:
Event-Name: REQUEST_PARAMS
Core-UUID: 7c1eed07-34ee-474f-964d-a5cb6e2e7c68
FreeSWITCH-Hostname: billing
FreeSWITCH-Switchname: billing
FreeSWITCH-IPv4: 172.16.0.30
FreeSWITCH-IPv6: %3A%3A1
Event-Date-Local: 2022-01-04%2007%3A06%3A34
Event-Date-GMT: Tue,%2004%20Jan%202022%2007%3A06%3A34%20GMT
Event-Date-Timestamp: 1641279994522564
Event-Calling-File: mod_dialplan_xml.c
Event-Calling-Function: dialplan_xml_locate
Event-Calling-Line-Number: 610
Event-Sequence: 488215
Channel-State: CS_ROUTING
Channel-Call-State: RINGING
Channel-State-Number: 2
Channel-Name: sofia/external_sip/6974108809%40voips.modulus.gr
Unique-ID: 9b455614-7032-4d78-991a-a39461de205c
Call-Direction: inbound
Presence-Call-Direction: inbound
Channel-HIT-Dialplan: true
Channel-Presence-Data: x%7C%7C%7CMartha(7772615170)%7C%7C%7C%7C%7C%7C%7C%7C%7CDID%7C%7C%7C185.73.43.250
Channel-Call-UUID: 9b455614-7032-4d78-991a-a39461de205c
Answer-State: ringing
Channel-Read-Codec-Name: PCMA
Channel-Read-Codec-Rate: 8000
Channel-Read-Codec-Bit-Rate: 64000
Channel-Write-Codec-Name: PCMA
Channel-Write-Codec-Rate: 8000
Channel-Write-Codec-Bit-Rate: 64000
Caller-Direction: inbound
Caller-Logical-Direction: inbound
Caller-Username: 6974108809
Caller-Dialplan: XML
Caller-Caller-ID-Name: 6974108809
Caller-Caller-ID-Number: 6974108809
Caller-Orig-Caller-ID-Name: 6974108809
Caller-Orig-Caller-ID-Number: 6974108809
Caller-Callee-ID-Name: Outbound%20Call
Caller-Callee-ID-Number: 302102202732
Caller-Network-Addr: 185.73.43.250
Caller-ANI: 6974108809
Caller-Destination-Number: 2105762903
Caller-Unique-ID: 9b455614-7032-4d78-991a-a39461de205c
Caller-Source: mod_sofia
Caller-Transfer-Source: 1641279994%3A5436057f-b663-4554-8780-d4b698e8087f%3Abl_xfer%3A2105762903/default/XML
Caller-Context: default
Caller-RDNIS: 2102202732
Caller-Channel-Name: sofia/external_sip/6974108809%40voips.modulus.gr
Caller-Profile-Index: 2
Caller-Profile-Created-Time: 1641279994522564
Caller-Channel-Created-Time: 1641279933982559
Caller-Channel-Answered-Time: 0
Caller-Channel-Progress-Time: 1641279934322557
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: false
Caller-Privacy-Hide-Name: false
Caller-Privacy-Hide-Number: false
variable_direction: inbound
variable_uuid: 9b455614-7032-4d78-991a-a39461de205c
variable_session_id: 3293
variable_sip_from_user: 6974108809
variable_sip_from_uri: 6974108809%40voips.modulus.gr
variable_sip_from_host: voips.modulus.gr
variable_video_media_flow: disabled
variable_text_media_flow: disabled
variable_channel_name: sofia/external_sip/6974108809%40voips.modulus.gr
variable_sip_call_id: 0ae7bb652227c4cf1eee4bec35ad3f34%40voips.modulus.gr
variable_sip_local_network_addr: 94.130.242.106
variable_sip_network_ip: 185.73.43.250
variable_sip_network_port: 5060
variable_sip_invite_stamp: 1641279933982559
variable_sip_received_ip: 185.73.43.250
variable_sip_received_port: 5060
variable_sip_via_protocol: udp
variable_sip_from_user_stripped: 6974108809
variable_sip_from_tag: as7e2b932e
variable_sofia_profile_name: external_sip
variable_sofia_profile_url: sip%3Amod_sofia%4094.130.242.106%3A6080
variable_recovery_profile_name: external_sip
variable_sip_Remote-Party-ID: %226974108809%22%20%3Csip%3A6974108809%40voips.modulus.gr%3E%3Bparty%3Dcalling%3Bprivacy%3Doff%3Bscreen%3Dno
variable_sip_cid_type: rpid
variable_sip_full_via: SIP/2.0/UDP%20185.73.43.250%3Bbranch%3Dz9hG4bK3088.973d47132483419dbfa1ef46c466b82a.0
variable_sip_full_from: %3Csip%3A6974108809%40voips.modulus.gr%3E%3Btag%3Das7e2b932e
variable_sip_full_to: %3Csip%3A2102202732%40voips.modulus.gr%3E
variable_sip_allow: INVITE,%20ACK,%20CANCEL,%20OPTIONS,%20BYE,%20REFER,%20SUBSCRIBE,%20NOTIFY,%20INFO,%20PUBLISH,%20MESSAGE
variable_sip_req_user: 2102202732
variable_sip_req_uri: 2102202732%40voips.modulus.gr
variable_sip_req_host: voips.modulus.gr
variable_sip_to_user: 2102202732
variable_sip_to_uri: 2102202732%40voips.modulus.gr
variable_sip_contact_user: btpsh-61d3a5e9-2958-aa0b5
variable_sip_contact_uri: btpsh-61d3a5e9-2958-aa0b5%40185.73.43.250
variable_sip_contact_host: 185.73.43.250
variable_sip_user_agent: modCOM%20v2%20SIP%20Server
variable_sip_via_host: 185.73.43.250
variable_sip_date_epoch_time: 1641279933
variable_switch_r_sdp: v%3D0%0D%0Ao%3Droot%202044131157%202044131157%20IN%20IP4%20185.73.42.252%0D%0As%3DmodCOM%20v2%20Media%20Gateway%0D%0Ac%3DIN%20IP4%20185.73.42.252%0D%0At%3D0%200%0D%0Am%3Daudio%2038216%20RTP/AVP%208%209%200%2018%20101%0D%0Aa%3Drtpmap%3A8%20PCMA/8000%0D%0Aa%3Drtpmap%3A9%20G722/8000%0D%0Aa%3Drtpmap%3A0%20PCMU/8000%0D%0Aa%3Drtpmap%3A18%20G729/8000%0D%0Aa%3Dfmtp%3A18%20annexb%3Dno%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dfmtp%3A101%200-16%0D%0Aa%3Drtcp%3A38217%0D%0Aa%3Dptime%3A20%0D%0A
variable_ep_codec_string: CORE_PCM_MODULE.PCMA%408000h%4020i%4064000b,mod_g729.G729%408000h%4020i%408000b
variable_rtp_use_codec_string: PCMA,OPUS,G729
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_remote_audio_rtcp_port: 38217
variable_remote_media_ip: 185.73.42.252
variable_remote_media_port: 38216
variable_rtp_audio_recv_pt: 8
variable_rtp_use_codec_name: PCMA
variable_rtp_use_codec_rate: 8000
variable_rtp_use_codec_ptime: 20
variable_rtp_use_codec_channels: 1
variable_rtp_last_audio_codec_string: PCMA%408000h%4020i%401c
variable_read_codec: PCMA
variable_original_read_codec: PCMA
variable_read_rate: 8000
variable_original_read_rate: 8000
variable_write_codec: PCMA
variable_write_rate: 8000
variable_dtmf_type: rfc2833
variable_endpoint_disposition: RECEIVED
variable_effective_destination_number: 302102202732
variable_bridge_pre_execute_bleg_app: sched_hangup
variable_bridge_pre_execute_bleg_data: %2B6000%20normal_clearing
variable_nibble_account: 9
variable_nibble_rate: 0.00000
variable_nibble_increment: 0
variable_nibble_minimum: 0.00000
variable_callstart: 2022-01-04%2007%3A05%3A34
variable_hangup_after_bridge: true
variable_continue_on_fail: TRUE
variable_account_id: 9
variable_parent_id: 0
variable_entity_id: 3
variable_call_processed: internal
variable_call_direction: inbound
variable_accountname: ModulusIncoming
variable_origination_rates_did: ID%3A1%7CCODE%3A%5E302102202732.*%7CDESTINATION%3A302102202732%7CCONNECTIONCOST%3A0.00000%7CINCLUDEDSECONDS%3A0%7CCT%3A5%7CCOST%3A0.00000%7CINC%3A0%7CINITIALBLOCK%3A0%7CRATEGROUP%3A0%7CMARKUP%3A0%7CCI%3A75%7CACCID%3A11
variable_origination_rates: 0
variable_original_caller_id_name: 6974108809
variable_original_caller_id_number: 6974108809
variable_limit_usage_2976257734_user_2976257734: 1
variable_limit_usage_11_user_11: 1
variable_effective_caller_id_name: 306974108809
variable_effective_caller_id_number: 306974108809
variable_receiver_accid: 11
variable_limit_realm: 302102202732
variable_limit_id: did_302102202732
variable_limit_max: 2
variable_limit_usage: 1
variable_limit_usage_302102202732_did_302102202732: 1
variable_presence_data: x%7C%7C%7CMartha(7772615170)%7C%7C%7C%7C%7C%7C%7C%7C%7CDID%7C%7C%7C185.73.43.250
variable_call_type: 5
variable_export_vars: presence_data,call_type
variable_originate_signal_bond: 8a068e3b-80b6-438f-88b7-9ed36af7217a
variable_originated_legs: 8a068e3b-80b6-438f-88b7-9ed36af7217a%3BOutbound%20Call%3B302102202732
variable_sip_to_tag: 5HeKNZ8Dy6p0S
variable_last_bridge_hangup_cause: NO_ANSWER
variable_originate_disposition: NO_ANSWER
variable_DIALSTATUS: NOANSWER
variable_originate_causes: 8a068e3b-80b6-438f-88b7-9ed36af7217a%3BNO_ANSWER
variable_originate_failed_cause: NO_ANSWER
variable_did_id: 1
variable_destination_number: 302102202732
variable_leg_timeout: 0
variable_call_type_vm_flag: 1
variable_is_local_extension: 1
variable_call_forwarding: true
variable_calltype: STANDARD
variable_current_application_data: 2105762903%20XML%20default
variable_current_application: transfer
variable_max_forwards: 67
variable_transfer_history: 1641279994%3A5436057f-b663-4554-8780-d4b698e8087f%3Abl_xfer%3A2105762903/default/XML
variable_transfer_source: 1641279994%3A5436057f-b663-4554-8780-d4b698e8087f%3Abl_xfer%3A2105762903/default/XML
variable_nibble_current_balance: 19.247050
variable_call_uuid: 9b455614-7032-4d78-991a-a39461de205c
Hunt-Direction: inbound
Hunt-Logical-Direction: inbound
Hunt-Username: 6974108809
Hunt-Dialplan: XML
Hunt-Caller-ID-Name: 6974108809
Hunt-Caller-ID-Number: 6974108809
Hunt-Orig-Caller-ID-Name: 6974108809
Hunt-Orig-Caller-ID-Number: 6974108809
Hunt-Callee-ID-Name: Outbound%20Call
Hunt-Callee-ID-Number: 302102202732
Hunt-Network-Addr: 185.73.43.250
Hunt-ANI: 6974108809
Hunt-Destination-Number: 2105762903
Hunt-Unique-ID: 9b455614-7032-4d78-991a-a39461de205c
Hunt-Source: mod_sofia
Hunt-Transfer-Source: 1641279994%3A5436057f-b663-4554-8780-d4b698e8087f%3Abl_xfer%3A2105762903/default/XML
Hunt-Context: default
Hunt-RDNIS: 2102202732
Hunt-Channel-Name: sofia/external_sip/6974108809%40voips.modulus.gr
Hunt-Profile-Index: 2
Hunt-Profile-Created-Time: 1641279994522564
Hunt-Channel-Created-Time: 1641279933982559
Hunt-Channel-Answered-Time: 0
Hunt-Channel-Progress-Time: 1641279934322557
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: false
Hunt-Privacy-Hide-Name: false
Hunt-Privacy-Hide-Number: false


2022-01-04 07:06:34.522564 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] tag_name: 
2022-01-04 07:06:34.522564 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] section: dialplan
2022-01-04 07:06:34.522564 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] key_value: 
2022-01-04 07:06:34.522564 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] key_name: 
2022-01-04 07:06:34.522564 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 2105762903
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '2105762903' AND status=0 limit 1
2022-01-04 07:06:34.522564 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 306974108809 / 306974108809
2022-01-04 07:06:34.522564 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.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 ="2105762903" LIMIT 1
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT 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 WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="2105762903" limit 1
2022-01-04 07:06:34.522564 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [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("185.73.43.250") 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 "2105762903"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
2022-01-04 07:06:34.522564 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 2976257734]
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "2976257734" AND deleted = 0 limit 1
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^2105762903.*' OR blocked_patterns = '^210576290.*' OR blocked_patterns = '^21057629.*' OR blocked_patterns = '^2105762.*' OR blocked_patterns = '^210576.*' OR blocked_patterns = '^21057.*' OR blocked_patterns = '^2105.*' OR blocked_patterns = '^210.*' OR blocked_patterns = '^21.*' OR blocked_patterns = '^2.*' OR blocked_patterns ='--') AND accountid = 9 limit 1 
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="2105762903" AND (accountid = 0 OR status = 1) LIMIT 1
2022-01-04 07:06:34.522564 99.90% [NOTICE] switch_cpp.cpp:1465 [ASTPP] Localization Id: 1
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 1 AND status=0 limit 1 
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"00/*,2/302,6/306,1/301,7/307,8/308".....2105762903
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"00/*,2/302,6/306,1/301,7/307,8/308".....2105762903
2022-01-04 07:06:34.522564 99.90% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] Before Localization CLI/DST : 2105762903
2022-01-04 07:06:34.522564 99.90% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] After Localization CLI/DST : 302105762903
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"00/*,2/302,6/306,1/301,7/307,8/308".....302105762903
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"00/*,2/302,6/306,1/301,7/307,8/308".....302105762903
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"00/*,2/302,6/306,1/301,7/307,8/308".....302105762903
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"00/*,2/302,6/306,1/301,7/307,8/308".....302105762903
2022-01-04 07:06:34.522564 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 = '^302105762903.*' OR patterns = '^30210576290.*' OR patterns = '^3021057629.*' OR patterns = '^302105762.*' OR patterns = '^30210576.*' OR patterns = '^3021057.*' OR patterns = '^302105.*' OR patterns = '^30210.*' OR patterns = '^3021.*' OR patterns = '^302.*' OR patterns = '^30.*' OR patterns = '^3.*' OR patterns ='--') AND accountid = 9 ORDER BY LENGTH(PKGPTR.patterns) DESC
2022-01-04 07:06:34.522564 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 ="302105762903" AND A.accountid = '9' limit 1
2022-01-04 07:06:34.522564 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 302105762903
2022-01-04 07:06:34.522564 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.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 ="302105762903" LIMIT 1
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT 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 WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="302105762903" limit 1
2022-01-04 07:06:34.522564 99.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : outbound
2022-01-04 07:06:34.522564 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 = '302105762903' OR number = '30210576290' OR number = '3021057629' OR number = '302105762' OR number = '30210576' OR number = '3021057' OR number = '302105' OR number = '30210' OR number = '3021' OR number = '302' OR number = '30' OR number = '3' OR number ='--') OR (number = '302105762903*' OR number = '30210576290*' OR number = '3021057629*' OR number = '302105762*' OR number = '30210576*' OR number = '3021057*' OR number = '302105*' OR number = '30210*' OR number = '3021*' OR number = '302*' OR number = '30*' OR number = '3*' OR number ='--') OR (number = '306974108809' OR number = '30697410880' OR number = '3069741088' OR number = '306974108' OR number = '30697410' OR number = '3069741' OR number = '306974' OR number = '30697' OR number = '3069' OR number = '306' OR number = '30' OR number = '3' OR number ='--') OR (number = '306974108809*' OR number = '30697410880*' OR number = '3069741088*' OR number = '306974108*' OR number = '30697410*' OR number = '3069741*' OR number = '306974*' OR number = '30697*' OR number = '3069*' OR number = '306*' OR number = '30*' OR number = '3*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CLI_POOL] Caller Id : 306974108809
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CLI_POOL] CLI Pool Id : 6
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CLI_POOL] Query :Select count(*) as count from dids where number='306974108809' and accountid = "9" and status=0
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CLI_POOL] COUNT :0
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP]  Post Cdrs : 0
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET RESELLERID] Query :SELECT reseller_id FROM accounts WHERE id = 9
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] 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="2105762903">
<condition field="destination_number" expression="2105762903">
<action application="log" data="WARNING CALLERID_NOT_FOUND 9"/>
<action application="set" data="original_caller_id_name=306974108809"/>
<action application="set" data="original_caller_id_number=306974108809"/>
<action application="set" data="error_cdr=1"/>
<action application="set" data="callstart=2022-01-04 07:06:34"/>
<action application="set" data="account_id=9"/>
<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=302105762903"/>
<action application="set" data="last_bridge_hangup_cause=CALLERID_NOT_FOUND"/>
<action application="hangup" data="CALLERID_NOT_FOUND"/>
</condition>
</extension>
</context>
</section>
</document>
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP]  Post Cdrs : 0
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET RESELLERID] Query :SELECT reseller_id FROM accounts WHERE id = 9
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] 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="2105762903">
<condition field="destination_number" expression="2105762903">
<action application="log" data="WARNING Accountcode . Dialed number (302105762903) is blocked for account!!"/>
<action application="set" data="original_caller_id_name=306974108809"/>
<action application="set" data="original_caller_id_number=306974108809"/>
<action application="set" data="error_cdr=1"/>
<action application="set" data="callstart=2022-01-04 07:06:34"/>
<action application="set" data="account_id=9"/>
<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=302105762903"/>
<action application="set" data="last_bridge_hangup_cause=DESTINATION_BLOCKED"/>
<action application="hangup" data="DESTINATION_BLOCKED"/>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr parsing [default->2105762903] continue=false
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Regex (PASS) [2105762903] destination_number(2105762903) =~ /2105762903/ break=on-false
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action log(WARNING Accountcode . Dialed number (302105762903) is blocked for account!!) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(original_caller_id_name=306974108809) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(original_caller_id_number=306974108809) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(error_cdr=1) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(callstart=2022-01-04 07:06:34) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(account_id=9) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(parent_id=0) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(call_direction=outbound) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(sip_ignore_remote_cause=true) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(call_processed=internal) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(effective_destination_number=302105762903) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action set(last_bridge_hangup_cause=DESTINATION_BLOCKED) 
Dialplan: sofia/external_sip/6974108809@voips.modulus.gr Action hangup(DESTINATION_BLOCKED) 
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:281 (sofia/external_sip/6974108809@voips.modulus.gr) State Change CS_ROUTING -> CS_EXECUTE
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:640 (sofia/external_sip/6974108809@voips.modulus.gr) State ROUTING going to sleep
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:581 (sofia/external_sip/6974108809@voips.modulus.gr) Running State Change CS_EXECUTE (Cur 1 Tot 3294)
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:647 (sofia/external_sip/6974108809@voips.modulus.gr) State EXECUTE
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_sofia.c:213 sofia/external_sip/6974108809@voips.modulus.gr SOFIA EXECUTE
2022-01-04 07:06:34.522564 99.90% [WARNING] switch_core_session.c:1693 sofia/external_sip/6974108809@voips.modulus.gr using scheduler due to bypass media or media is not established.
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_scheduler.c:263 Added task 1897 switch_core_session_sched_heartbeat (9b455614-7032-4d78-991a-a39461de205c) to run at 1641280024
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:323 sofia/external_sip/6974108809@voips.modulus.gr Standard EXECUTE
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_scheduler.c:147 Deleting task 1896 switch_core_session_sched_heartbeat (9b455614-7032-4d78-991a-a39461de205c)
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr log(WARNING Accountcode . Dialed number (302105762903) is blocked for account!!)
2022-01-04 07:06:34.522564 99.90% [WARNING] mod_dptools.c:1879 Accountcode . Dialed number (302105762903) is blocked for account!!
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(original_caller_id_name=306974108809)
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [original_caller_id_name]=[306974108809]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(original_caller_id_number=306974108809)
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [original_caller_id_number]=[306974108809]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(error_cdr=1)
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [error_cdr]=[1]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(callstart=2022-01-04 07:06:34)
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [callstart]=[2022-01-04 07:06:34]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(account_id=9)
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [account_id]=[9]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(parent_id=0)
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [parent_id]=[0]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(call_direction=outbound)
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [call_direction]=[outbound]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(sip_ignore_remote_cause=true)
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [sip_ignore_remote_cause]=[true]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(call_processed=internal)
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [call_processed]=[internal]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(effective_destination_number=302105762903)
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [effective_destination_number]=[302105762903]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr set(last_bridge_hangup_cause=DESTINATION_BLOCKED)
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_dptools.c:1685 SET sofia/external_sip/6974108809@voips.modulus.gr [last_bridge_hangup_cause]=[DESTINATION_BLOCKED]
EXECUTE [depth=0] sofia/external_sip/6974108809@voips.modulus.gr hangup(DESTINATION_BLOCKED)
2022-01-04 07:06:34.522564 99.90% [NOTICE] mod_dptools.c:1387 Hangup sofia/external_sip/6974108809@voips.modulus.gr [CS_EXECUTE] [NORMAL_CLEARING]
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_session.c:2983 sofia/external_sip/6974108809@voips.modulus.gr skip receive message [PHONE_EVENT] (channel is hungup already)
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:647 (sofia/external_sip/6974108809@voips.modulus.gr) State EXECUTE going to sleep
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:581 (sofia/external_sip/6974108809@voips.modulus.gr) Running State Change CS_HANGUP (Cur 1 Tot 3294)
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:844 (sofia/external_sip/6974108809@voips.modulus.gr) Callstate Change RINGING -> HANGUP
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:846 (sofia/external_sip/6974108809@voips.modulus.gr) State HANGUP
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_sofia.c:468 Channel sofia/external_sip/6974108809@voips.modulus.gr hanging up, cause: NORMAL_CLEARING
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 480
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.00000 per minute to account 9
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_nibblebill.c:518 Not billing 9 - call is not in answered state
2022-01-04 07:06:34.522564 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='9']
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 9 (balance = 19.247050)
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_nibblebill.c:523 Comparing 19.247050 to hangup balance of 0.000000, taking into account minimum charge of 0.000000
2022-01-04 07:06:34.522564 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='9']
2022-01-04 07:06:34.522564 99.90% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 9 (balance = 19.247050)
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:59 sofia/external_sip/6974108809@voips.modulus.gr Standard HANGUP, cause: NORMAL_CLEARING
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:846 (sofia/external_sip/6974108809@voips.modulus.gr) State HANGUP going to sleep
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:616 (sofia/external_sip/6974108809@voips.modulus.gr) State Change CS_HANGUP -> CS_REPORTING
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:581 (sofia/external_sip/6974108809@voips.modulus.gr) Running State Change CS_REPORTING (Cur 1 Tot 3294)
2022-01-04 07:06:34.522564 99.90% [DEBUG] switch_core_state_machine.c:932 (sofia/external_sip/6974108809@voips.modulus.gr) State REPORTING
2022-01-04 07:06:34.522564 99.90% [INFO] mod_json_cdr.c:271 Process [9b455614-7032-4d78-991a-a39461de205c.cdr.json]
2022-01-04 07:06:34.562560 99.90% [DEBUG] switch_core_state_machine.c:168 sofia/external_sip/6974108809@voips.modulus.gr Standard REPORTING, cause: NORMAL_CLEARING
2022-01-04 07:06:34.562560 99.90% [DEBUG] switch_core_state_machine.c:932 (sofia/external_sip/6974108809@voips.modulus.gr) State REPORTING going to sleep
2022-01-04 07:06:34.562560 99.90% [DEBUG] switch_core_state_machine.c:607 (sofia/external_sip/6974108809@voips.modulus.gr) State Change CS_REPORTING -> CS_DESTROY
2022-01-04 07:06:34.562560 99.90% [DEBUG] switch_core_session.c:1753 Session 3293 (sofia/external_sip/6974108809@voips.modulus.gr) Locked, Waiting on external entities
2022-01-04 07:06:34.562560 99.90% [NOTICE] switch_core_session.c:1771 Session 3293 (sofia/external_sip/6974108809@voips.modulus.gr) Ended
2022-01-04 07:06:34.562560 99.90% [NOTICE] switch_core_session.c:1775 Close Channel sofia/external_sip/6974108809@voips.modulus.gr [CS_DESTROY]
2022-01-04 07:06:34.562560 99.90% [DEBUG] switch_core_state_machine.c:735 (sofia/external_sip/6974108809@voips.modulus.gr) Running State Change CS_DESTROY (Cur 0 Tot 3294)
2022-01-04 07:06:34.562560 99.90% [DEBUG] switch_core_state_machine.c:745 (sofia/external_sip/6974108809@voips.modulus.gr) State DESTROY
2022-01-04 07:06:34.562560 99.90% [DEBUG] mod_sofia.c:379 sofia/external_sip/6974108809@voips.modulus.gr SOFIA DESTROY
2022-01-04 07:06:34.562560 99.90% [DEBUG] switch_core_state_machine.c:175 sofia/external_sip/6974108809@voips.modulus.gr Standard DESTROY
2022-01-04 07:06:34.562560 99.90% [DEBUG] switch_core_state_machine.c:745 (sofia/external_sip/6974108809@voips.modulus.gr) State DESTROY going to sleep
2022-01-04 07:06:35.022561 99.77% [DEBUG] switch_scheduler.c:147 Deleting task 1897 switch_core_session_sched_heartbeat (9b455614-7032-4d78-991a-a39461de205c)
freeswitch@billing>