span style="color: cornflowerblue; font-weight: bold;"> 023-08-18 09:51:47.135862 [NOTICE] switch_channel.c:1118 New Channel sofia/default/2349037542994@116.203.52.230 [b427a3f8-aba1-45f1-8f4b-e5ec6985f181]
2023-08-18 09:51:47.135862 [DEBUG] switch_core_state_machine.c:585 (sofia/default/2349037542994@116.203.52.230) Running State Change CS_NEW (Cur 1 Tot 171)
2023-08-18 09:51:47.135862 [INFO] sofia.c:10362 sofia/default/2349037542994@116.203.52.230 receiving invite from 157.230.210.216:5060 version: 1.10.6 -release-18-1ff9d0a60e 64bit call-id: 0801e60666ea01ec037c0edc65c51dc9@116.203.52.230
2023-08-18 09:51:47.135862 [DEBUG] sofia.c:10456 verifying acl "default" for ip/port 157.230.210.216:0.
2023-08-18 09:51:47.135862 [DEBUG] sofia.c:10485 IP 157.230.210.216 Approved by acl "default[]". Access Granted.
2023-08-18 09:51:47.135862 [DEBUG] sofia.c:7406 Channel sofia/default/2349037542994@116.203.52.230 entering state [received][100]
2023-08-18 09:51:47.135862 [DEBUG] sofia.c:7416 Remote SDP:
v=0
o=root 415724884 415724884 IN IP4 157.230.210.216
s=Asterisk PBX 13.38.2
c=IN IP4 157.230.210.216
t=0 0
m=audio 11252 RTP/AVP 0 8 18 101
a=rtpmap:0 PCMU/8000
a=rtpmap:8 PCMA/8000
a=rtpmap:18 G729/8000
a=fmtp:18 annexb=no
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-16
a=maxptime:150
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:5601 Audio Codec Compare [PCMU:0:8000:150:64000:1]/[PCMA:8:8000:20:64000:1]
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:5601 Audio Codec Compare [PCMU:0:8000:150:64000:1]/[PCMU:0:8000:20:64000:1]
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:5656 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:5601 Audio Codec Compare [PCMU:0:8000:150:64000:1]/[G729:18:8000:20:8000:1]
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:5601 Audio Codec Compare [PCMA:8:8000:150:64000:1]/[PCMA:8:8000:20:64000:1]
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:5656 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:5601 Audio Codec Compare [PCMA:8:8000:150:64000:1]/[PCMU:0:8000:20:64000:1]
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:5601 Audio Codec Compare [PCMA:8:8000:150:64000:1]/[G729:18:8000:20:8000:1]
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:5601 Audio Codec Compare [G729:18:8000:150:8000:1]/[PCMA:8:8000:20:64000:1]
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:5601 Audio Codec Compare [G729:18:8000:150:8000:1]/[PCMU:0:8000:20:64000:1]
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:5601 Audio Codec Compare [G729:18:8000:150:8000:1]/[G729:18:8000:20:8000:1]
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:5656 Audio Codec Compare [G729:18:8000:20:8000:1] ++++ is saved as a match
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:5517 Set telephone-event payload to 101@8000
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:3847 Set Codec sofia/default/2349037542994@116.203.52.230 PCMU/8000 20 ms 160 samples 64000 bits 1 channels
2023-08-18 09:51:47.135862 [DEBUG] switch_core_codec.c:111 sofia/default/2349037542994@116.203.52.230 Original read codec set to PCMU:0
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:5860 Set telephone-event payload to 101@8000
2023-08-18 09:51:47.135862 [DEBUG] switch_core_media.c:5918 sofia/default/2349037542994@116.203.52.230 Set 2833 dtmf send payload to 101 recv payload to 101
2023-08-18 09:51:47.135862 [DEBUG] sofia.c:7840 (sofia/default/2349037542994@116.203.52.230) State Change CS_NEW -> CS_INIT
2023-08-18 09:51:47.135862 [DEBUG] switch_core_state_machine.c:604 (sofia/default/2349037542994@116.203.52.230) State NEW
2023-08-18 09:51:47.135862 [DEBUG] switch_core_state_machine.c:585 (sofia/default/2349037542994@116.203.52.230) Running State Change CS_INIT (Cur 1 Tot 171)
2023-08-18 09:51:47.135862 [DEBUG] switch_core_state_machine.c:628 (sofia/default/2349037542994@116.203.52.230) State INIT
2023-08-18 09:51:47.135862 [DEBUG] mod_sofia.c:93 sofia/default/2349037542994@116.203.52.230 SOFIA INIT
2023-08-18 09:51:47.135862 [DEBUG] switch_core_state_machine.c:40 sofia/default/2349037542994@116.203.52.230 Standard INIT
2023-08-18 09:51:47.135862 [DEBUG] switch_core_state_machine.c:48 (sofia/default/2349037542994@116.203.52.230) State Change CS_INIT -> CS_ROUTING
2023-08-18 09:51:47.135862 [DEBUG] switch_core_state_machine.c:628 (sofia/default/2349037542994@116.203.52.230) State INIT going to sleep
2023-08-18 09:51:47.135862 [DEBUG] switch_core_state_machine.c:585 (sofia/default/2349037542994@116.203.52.230) Running State Change CS_ROUTING (Cur 1 Tot 171)
2023-08-18 09:51:47.135862 [DEBUG] switch_channel.c:2332 (sofia/default/2349037542994@116.203.52.230) Callstate Change DOWN -> RINGING
2023-08-18 09:51:47.135862 [DEBUG] switch_core_state_machine.c:644 (sofia/default/2349037542994@116.203.52.230) State ROUTING
2023-08-18 09:51:47.135862 [DEBUG] mod_sofia.c:154 sofia/default/2349037542994@116.203.52.230 SOFIA ROUTING
2023-08-18 09:51:47.135862 [DEBUG] switch_core_state_machine.c:236 sofia/default/2349037542994@116.203.52.230 Standard ROUTING
2023-08-18 09:51:47.135862 [INFO] mod_dialplan_xml.c:637 Processing 2349037542994 <2349037542994>->018887075 in context default
2023-08-18 09:51:47.135862 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
2023-08-18 09:51:47.135862 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 018887075
2023-08-18 09:51:47.155851 [WARNING] switch_cpp.cpp:1465 [ASTPP] [DIALPLAN] ASH CHANGES: 018887075
2023-08-18 09:51:47.155851 [WARNING] switch_cpp.cpp:1465 [ASTPP] [DIALPLAN] ASH CHANGES1: 018887075
2023-08-18 09:51:47.155851 [WARNING] switch_cpp.cpp:1465 [ASTPP] [DIALPLAN] ASH CHANGES2: 018887075
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '018887075' limit 1
2023-08-18 09:51:47.155851 [WARNING] switch_cpp.cpp:1465 [ASTPP] [DIALPLAN] ASH CHANGES3: 018887075
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '018887075' AND status=0 limit 1
2023-08-18 09:51:47.155851 [WARNING] switch_cpp.cpp:1465 [ASTPP] [DIALPLAN] ASH CHANGES4: 018887075
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '018887075' and status=0 LIMIT 1
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 2349037542994 / 2349037542994
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [DIALPLAN] ANKIT CHANGES
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [DIALPLAN] ANKIT CHANGES DONE
2023-08-18 09:51:47.155851 [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 ="018887075" LIMIT 1
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
2023-08-18 09:51:47.155851 [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("157.230.210.216") 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 "018887075" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 8612965]
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =018887075
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "8612965" AND deleted = 0 limit 1
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="018887075" AND (accountid = 0 OR status = 1) LIMIT 1
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 5
2023-08-18 09:51:47.155851 [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 = '^018887075.*' OR patterns = '^01888707.*' OR patterns = '^0188870.*' OR patterns = '^018887.*' OR patterns = '^01888.*' OR patterns = '^0188.*' OR patterns = '^018.*' OR patterns = '^01.*' OR patterns = '^0.*' OR patterns ='--') AND accountid = 5 ORDER BY LENGTH(PKGPTR.patterns) DESC
2023-08-18 09:51:47.155851 [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 ="018887075" AND A.accountid = '12' limit 1
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 018887075
2023-08-18 09:51:47.155851 [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 ="018887075" LIMIT 1
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
2023-08-18 09:51:47.155851 [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 = '018887075' OR number = '01888707' OR number = '0188870' OR number = '018887' OR number = '01888' OR number = '0188' OR number = '018' OR number = '01' OR number = '0' OR number ='--') OR (number = '018887075*' OR number = '01888707*' OR number = '0188870*' OR number = '018887*' OR number = '01888*' OR number = '0188*' OR number = '018*' OR number = '01*' OR number = '0*' OR number ='--') OR (number = '2349037542994' OR number = '234903754299' OR number = '23490375429' OR number = '2349037542' OR number = '234903754' OR number = '23490375' OR number = '2349037' OR number = '234903' OR number = '23490' OR number = '2349' OR number = '234' OR number = '23' OR number = '2' OR number ='--') OR (number = '2349037542994*' OR number = '234903754299*' OR number = '23490375429*' OR number = '2349037542*' OR number = '234903754*' OR number = '23490375*' OR number = '2349037*' OR number = '234903*' OR number = '23490*' OR number = '2349*' OR number = '234*' OR number = '23*' OR number = '2*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '018887075' OR routing_prefix = '01888707' OR routing_prefix = '0188870' OR routing_prefix = '018887' OR routing_prefix = '01888' OR routing_prefix = '0188' OR routing_prefix = '018' OR routing_prefix = '01' OR routing_prefix = '0' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 12
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 8612965
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 8.8704
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 5
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 5 AND status = 0
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
2023-08-18 09:51:47.155851 [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 ="018887075" LIMIT 1
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] Call Direction : inbound
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 582
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 018887075
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 141
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 12
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your8.8704 balance Accountid 12 !!!
2023-08-18 09:51:47.155851 [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length :: 100
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE ID 12
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE RATE 0.00000
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE CONNECT COST 0.00000
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE INITIAL INC 0
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE INC 0
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
2023-08-18 09:51:47.155851 [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 = 12 AND status=0 LIMIT 1
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "5" AND deleted = 0 limit 1
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:12
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:12
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 12
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 5 limit 1
2023-08-18 09:51:47.155851 [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : hq.ubx.univasa.com
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] Maxlength : 100
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
2023-08-18 09:51:47.155851 [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_record_info] Query :SELECT sip_device_routing.is_recording FROM sip_devices AS sip_devices, accounts AS accounts ,sip_device_routing AS sip_device_routing WHERE sip_devices.accountid = accounts.id AND sip_devices.id = sip_device_routing.sip_device_id AND sip_devices.username = "002" AND accounts.status = 0
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 5 limit 1
2023-08-18 09:51:47.155851 [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : hq.ubx.univasa.com
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 5 and status = 0 limit 1
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_0
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="002" AND domains.domain="hq.ubx.univasa.com" limit 1
2023-08-18 09:51:47.155851 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [PBX_SIP_ROUTING] [GET_ROUTING_INFO] Query :SELECT * from sip_device_routing WHERE sip_device_id = 113 limit 1
2023-08-18 09:51:47.175849 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_action = 'call_transfer_attended' limit 1
2023-08-18 09:51:47.175849 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_action = 'call_transfer' limit 1
2023-08-18 09:51:47.175849 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [NOTIFY] START:
2023-08-18 09:51:47.175849 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="002" AND domains.domain="hq.ubx.univasa.com" limit 1
2023-08-18 09:51:47.175849 [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX_SIP_ROUTING] SIP ID : 113
2023-08-18 09:51:47.175849 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [PBX_SIP_ROUTING] [GET_ROUTING_INFO] Query :SELECT * from sip_device_routing WHERE sip_device_id = 113 limit 1
2023-08-18 09:51:47.175849 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_action = 'call_transfer_attended' limit 1
2023-08-18 09:51:47.175849 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_action = 'call_transfer' limit 1
2023-08-18 09:51:47.175849 [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX_SIP_ROUTING] Call Forwarding Flag : 1
2023-08-18 09:51:47.175849 [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX_SIP_ROUTING] SIP Call Forwarding Disable
2023-08-18 09:51:47.175849 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [NOTIFY] START:
2023-08-18 09:51:47.175849 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="002" AND domains.domain="hq.ubx.univasa.com" limit 1
2023-08-18 09:51:47.175849 [DEBUG] switch_cpp.cpp:1465 [ASTPP] [PBX_SIP_ROUTING] [GET_ROUTING_INFO] Query :SELECT * from sip_device_routing WHERE sip_device_id = 113 limit 1
2023-08-18 09:51:47.175849 [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="018887075">
<condition field="destination_number" expression="018887075">
<action application="set" data="effective_destination_number=018887075"/>
<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=12"/>
<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=2023-08-18 09:51:47"/>
<action application="set" data="hangup_after_bridge=true"/>
<action application="set" data="continue_on_fail=TRUE"/>
<action application="set" data="account_id=12"/>
<action application="set" data="parent_id=0"/>
<action application="set" data="entity_id=0"/>
<action application="set" data="call_processed=internal"/>
<action application="set" data="call_direction=inbound"/>
<action application="set" data="accountname=Phresh"/>
<action application="set" data="origination_rates_did=ID:582|CODE:^018887075.*|DESTINATION:018887075|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:0|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:141|ACCID:5"/>
<action application="set" data="origination_rates=0"/>
<action application="set" data="original_caller_id_name=2349037542994"/>
<action application="set" data="original_caller_id_number=2349037542994"/>
<action application="limit" data="db 8612965 user_8612965 90 "/>
<action application="set" data="effective_caller_id_name=2349037542994"/>
<action application="set" data="effective_caller_id_number=2349037542994"/>
<action application="set" data="receiver_accid=5"/>
<action application="export" data="domain_name=hq.ubx.univasa.com"/>
<action application="export" data="sip_to_host=hq.ubx.univasa.com"/>
<action application="export" data="presence_data=x|||Tumi(2330223285)|||||||||DID|||157.230.210.216"/>
<action application="export" data="call_type=0"/>
<action application="set" data="calltype=DID-LOCAL"/>
<action application="db" data="insert/pickup_any_group_${callgroup}/002/${uuid}"/>
<action application="set" data="dialed_extension=transfer_call"/>
<action application="export" data="dialed_extension=transfer_call"/>
<action application="bind_meta_app" data="3 b s execute_extension::transfer_call_3 XML default"/>
<action application="bind_meta_app" data="2 b s execute_extension::transfer_call_2 XML default"/>
<action application="set" data="hangup_after_bridge=true"/>
<action application="export" data="did_user_domain=hq.ubx.univasa.com"/>
<action application="db" data="insert/pickup_any_group_${callgroup}/002/${uuid}"/>
<action application="set" data="dialed_extension=transfer_call"/>
<action application="export" data="dialed_extension=transfer_call"/>
<action application="bind_meta_app" data="3 b s execute_extension::transfer_call_3 XML default"/>
<action application="bind_meta_app" data="2 b s execute_extension::transfer_call_2 XML default"/>
<action application="set" data="transfer_ringback=$${hold_music}"/>
<action application="set" data="hangup_after_bridge=true"/>
<action application="bridge" data="{sip_invite_params=user=LOCAL,ignore_early_media=true,sip_h_P-call_type='custom_forward',sip_h_P-Accountcode=5}[leg_timeout=60 ] user/002@hq.ubx.univasa.com"/>
<action application="set" data="on_busy_flag=1"/>
<action application="set" data="on_busy_destination="/>
<action application="set" data="no_answer_flag=1"/>
<action application="set" data="no_answer_destination="/>
<action application="set" data="not_register_flag=1"/>
<action application="set" data="not_register_destination="/>
<action application="set" data="opensips_flag=1"/>
<action application="set" data="variable_sip_to_host=hq.ubx.univasa.com"/>
<action application="set" data="opensips_domain=127.0.0.1"/>
<action application="set" data="leg_timeout=60"/>
<action application="set" data="userinfo_id=5"/>
<action application="set" data="sip_destination_number=002"/>
<action application="set" data="did_number=002"/>
<action application="set" data="user_domain=hq.ubx.univasa.com"/>
<action application="lua" data="astpp/lib/pbx/astpp-sipdevice-routing.lua"/>
<action application="set" data="on_busy_flag=1"/>
<action application="set" data="on_busy_destination="/>
<action application="set" data="no_answer_flag=1"/>
<action application="set" data="no_answer_destination="/>
<action application="set" data="not_register_flag=1"/>
<action application="set" data="not_register_destination="/>
<action application="set" data="opensips_flag=1"/>
<action application="set" data="variable_sip_to_host=hq.ubx.univasa.com"/>
<action application="set" data="opensips_domain=127.0.0.1"/>
<action application="set" data="leg_timeout=60"/>
<action application="set" data="userinfo_id=5"/>
<action application="set" data="sip_destination_number=002"/>
<action application="set" data="destination_number=018887075"/>
<action application="set" data="did_number=018887075"/>
<action application="set" data="user_domain=hq.ubx.univasa.com"/>
<action application="lua" data="astpp/lib/pbx/astpp-sipdevice-routing.lua"/>
<condition field="${cond(${user_data 002@${domain_name} param vm-enabled} == true ? YES : NO)}" expression="^YES$">
<action application="answer"/>
<action application="export" data="voicemail_alternate_greet_id=018887075"/>
<action application="voicemail" data="default $${domain_name} 002"/>
<anti-action application="hangup" data="${originate_disposition}"/>
</condition>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/default/2349037542994@116.203.52.230 parsing [default->018887075] continue=false
Dialplan: sofia/default/2349037542994@116.203.52.230 Regex (PASS) [018887075] destination_number(018887075) =~ /018887075/ break=on-false
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(effective_destination_number=018887075)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(bridge_pre_execute_bleg_app=sched_hangup)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(nibble_account=12)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(nibble_rate=0.00000)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(nibble_increment=0)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(nibble_minimum=0.00000)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action nibblebill(heartbeat 30)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(callstart=2023-08-18 09:51:47)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(hangup_after_bridge=true)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(continue_on_fail=TRUE)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(account_id=12)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(parent_id=0)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(entity_id=0)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(call_processed=internal)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(call_direction=inbound)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(accountname=Phresh)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(origination_rates_did=ID:582|CODE:^018887075.*|DESTINATION:018887075|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:0|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:141|ACCID:5)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(origination_rates=0)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(original_caller_id_name=2349037542994)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(original_caller_id_number=2349037542994)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action limit(db 8612965 user_8612965 90 )
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(effective_caller_id_name=2349037542994)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(effective_caller_id_number=2349037542994)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(receiver_accid=5)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action export(domain_name=hq.ubx.univasa.com)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action export(sip_to_host=hq.ubx.univasa.com)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action export(presence_data=x|||Tumi(2330223285)|||||||||DID|||157.230.210.216)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action export(call_type=0)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(calltype=DID-LOCAL)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action db(insert/pickup_any_group_${callgroup}/002/${uuid})
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(dialed_extension=transfer_call)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action export(dialed_extension=transfer_call)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action bind_meta_app(3 b s execute_extension::transfer_call_3 XML default)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action bind_meta_app(2 b s execute_extension::transfer_call_2 XML default)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(hangup_after_bridge=true)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action export(did_user_domain=hq.ubx.univasa.com)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action db(insert/pickup_any_group_${callgroup}/002/${uuid})
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(dialed_extension=transfer_call)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action export(dialed_extension=transfer_call)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action bind_meta_app(3 b s execute_extension::transfer_call_3 XML default)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action bind_meta_app(2 b s execute_extension::transfer_call_2 XML default)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(transfer_ringback=$${hold_music})
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(hangup_after_bridge=true)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action bridge({sip_invite_params=user=LOCAL,ignore_early_media=true,sip_h_P-call_type='custom_forward',sip_h_P-Accountcode=5}[leg_timeout=60 ] user/002@hq.ubx.univasa.com)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(on_busy_flag=1)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(on_busy_destination=)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(no_answer_flag=1)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(no_answer_destination=)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(not_register_flag=1)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(not_register_destination=)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(opensips_flag=1)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(variable_sip_to_host=hq.ubx.univasa.com)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(opensips_domain=127.0.0.1)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(leg_timeout=60)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(userinfo_id=5)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(sip_destination_number=002)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(did_number=002)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(user_domain=hq.ubx.univasa.com)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action lua(astpp/lib/pbx/astpp-sipdevice-routing.lua)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(on_busy_flag=1)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(on_busy_destination=)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(no_answer_flag=1)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(no_answer_destination=)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(not_register_flag=1)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(not_register_destination=)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(opensips_flag=1)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(variable_sip_to_host=hq.ubx.univasa.com)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(opensips_domain=127.0.0.1)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(leg_timeout=60)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(userinfo_id=5)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(sip_destination_number=002)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(destination_number=018887075)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(did_number=018887075)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action set(user_domain=hq.ubx.univasa.com)
Dialplan: sofia/default/2349037542994@116.203.52.230 Action lua(astpp/lib/pbx/astpp-sipdevice-routing.lua)
|--- Dialplan: Processing recursive conditions level:1 [018887075_recur_1] require-nested=TRUE
|--- Dialplan: sofia/default/2349037542994@116.203.52.230 Regex (FAIL) [018887075_recur_1] ${cond(${user_data 002@${domain_name} param vm-enabled} == true ? YES : NO)}(-ERR) =~ /^YES$/ break=on-false
|--- Dialplan: sofia/default/2349037542994@116.203.52.230 ANTI-Action hangup(${originate_disposition})
2023-08-18 09:51:47.195849 [DEBUG] switch_core_state_machine.c:287 (sofia/default/2349037542994@116.203.52.230) State Change CS_ROUTING -> CS_EXECUTE
2023-08-18 09:51:47.195849 [DEBUG] switch_core_state_machine.c:644 (sofia/default/2349037542994@116.203.52.230) State ROUTING going to sleep
2023-08-18 09:51:47.195849 [DEBUG] switch_core_state_machine.c:585 (sofia/default/2349037542994@116.203.52.230) Running State Change CS_EXECUTE (Cur 1 Tot 171)
2023-08-18 09:51:47.195849 [DEBUG] switch_core_state_machine.c:651 (sofia/default/2349037542994@116.203.52.230) State EXECUTE
2023-08-18 09:51:47.195849 [DEBUG] mod_sofia.c:209 sofia/default/2349037542994@116.203.52.230 SOFIA EXECUTE
2023-08-18 09:51:47.195849 [DEBUG] switch_core_state_machine.c:329 sofia/default/2349037542994@116.203.52.230 Standard EXECUTE
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(effective_destination_number=018887075)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [effective_destination_number]=[018887075]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(bridge_pre_execute_bleg_app=sched_hangup)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [bridge_pre_execute_bleg_app]=[sched_hangup]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [bridge_pre_execute_bleg_data]=[+6000 normal_clearing]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(nibble_account=12)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [nibble_account]=[12]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(nibble_rate=0.00000)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [nibble_rate]=[0.00000]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(nibble_increment=0)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [nibble_increment]=[0]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(nibble_minimum=0.00000)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [nibble_minimum]=[0.00000]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 nibblebill(heartbeat 30)
2023-08-18 09:51:47.195849 [WARNING] switch_core_session.c:1676 sofia/default/2349037542994@116.203.52.230 using scheduler due to bypass media or media is not established.
2023-08-18 09:51:47.195849 [DEBUG] switch_scheduler.c:263 Added task 63 switch_core_session_sched_heartbeat (b427a3f8-aba1-45f1-8f4b-e5ec6985f181) to run at 1692352337
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(callstart=2023-08-18 09:51:47)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [callstart]=[2023-08-18 09:51:47]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(hangup_after_bridge=true)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [hangup_after_bridge]=[true]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(continue_on_fail=TRUE)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [continue_on_fail]=[TRUE]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(account_id=12)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [account_id]=[12]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(parent_id=0)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [parent_id]=[0]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(entity_id=0)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [entity_id]=[0]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(call_processed=internal)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [call_processed]=[internal]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(call_direction=inbound)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [call_direction]=[inbound]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(accountname=Phresh)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [accountname]=[Phresh]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(origination_rates_did=ID:582|CODE:^018887075.*|DESTINATION:018887075|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:0|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:141|ACCID:5)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [origination_rates_did]=[ID:582|CODE:^018887075.*|DESTINATION:018887075|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:0|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:141|ACCID:5]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(origination_rates=0)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [origination_rates]=[0]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(original_caller_id_name=2349037542994)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [original_caller_id_name]=[2349037542994]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(original_caller_id_number=2349037542994)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [original_caller_id_number]=[2349037542994]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 limit(db 8612965 user_8612965 90 )
2023-08-18 09:51:47.195849 [DEBUG] switch_limit.c:124 incr called: 8612965_user_8612965 max:90, interval:0
2023-08-18 09:51:47.195849 [DEBUG] mod_db.c:194 Usage for 8612965_user_8612965 is now 1/90
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(effective_caller_id_name=2349037542994)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [effective_caller_id_name]=[2349037542994]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(effective_caller_id_number=2349037542994)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [effective_caller_id_number]=[2349037542994]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(receiver_accid=5)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [receiver_accid]=[5]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 export(domain_name=hq.ubx.univasa.com)
2023-08-18 09:51:47.195849 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [domain_name]=[hq.ubx.univasa.com]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 export(sip_to_host=hq.ubx.univasa.com)
2023-08-18 09:51:47.195849 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [sip_to_host]=[hq.ubx.univasa.com]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 export(presence_data=x|||Tumi(2330223285)|||||||||DID|||157.230.210.216)
2023-08-18 09:51:47.195849 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_data]=[x|||Tumi(2330223285)|||||||||DID|||157.230.210.216]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 export(call_type=0)
2023-08-18 09:51:47.195849 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [call_type]=[0]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(calltype=DID-LOCAL)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [calltype]=[DID-LOCAL]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 db(insert/pickup_any_group_/002/b427a3f8-aba1-45f1-8f4b-e5ec6985f181)
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(dialed_extension=transfer_call)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [dialed_extension]=[transfer_call]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 export(dialed_extension=transfer_call)
2023-08-18 09:51:47.195849 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [dialed_extension]=[transfer_call]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 bind_meta_app(3 b s execute_extension::transfer_call_3 XML default)
2023-08-18 09:51:47.195849 [INFO] switch_ivr_async.c:4678 Bound B-Leg: *3 execute_extension::transfer_call_3 XML default
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 bind_meta_app(2 b s execute_extension::transfer_call_2 XML default)
2023-08-18 09:51:47.195849 [INFO] switch_ivr_async.c:4678 Bound B-Leg: *2 execute_extension::transfer_call_2 XML default
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(hangup_after_bridge=true)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [hangup_after_bridge]=[true]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 export(did_user_domain=hq.ubx.univasa.com)
2023-08-18 09:51:47.195849 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [did_user_domain]=[hq.ubx.univasa.com]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 db(insert/pickup_any_group_/002/b427a3f8-aba1-45f1-8f4b-e5ec6985f181)
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(dialed_extension=transfer_call)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [dialed_extension]=[transfer_call]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 export(dialed_extension=transfer_call)
2023-08-18 09:51:47.195849 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [dialed_extension]=[transfer_call]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 bind_meta_app(3 b s execute_extension::transfer_call_3 XML default)
2023-08-18 09:51:47.195849 [INFO] switch_ivr_async.c:4678 Bound B-Leg: *3 execute_extension::transfer_call_3 XML default
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 bind_meta_app(2 b s execute_extension::transfer_call_2 XML default)
2023-08-18 09:51:47.195849 [INFO] switch_ivr_async.c:4678 Bound B-Leg: *2 execute_extension::transfer_call_2 XML default
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(transfer_ringback=local_stream://moh)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [transfer_ringback]=[local_stream://moh]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 set(hangup_after_bridge=true)
2023-08-18 09:51:47.195849 [DEBUG] mod_dptools.c:1685 SET sofia/default/2349037542994@116.203.52.230 [hangup_after_bridge]=[true]
EXECUTE [depth=0] sofia/default/2349037542994@116.203.52.230 bridge({sip_invite_params=user=LOCAL,ignore_early_media=true,sip_h_P-call_type='custom_forward',sip_h_P-Accountcode=5}[leg_timeout=60 ] user/002@hq.ubx.univasa.com)
2023-08-18 09:51:47.195849 [DEBUG] switch_channel.c:1264 sofia/default/2349037542994@116.203.52.230 EXPORTING[export_vars] [domain_name]=[hq.ubx.univasa.com] to event
2023-08-18 09:51:47.195849 [DEBUG] switch_channel.c:1264 sofia/default/2349037542994@116.203.52.230 EXPORTING[export_vars] [sip_to_host]=[hq.ubx.univasa.com] to event
2023-08-18 09:51:47.195849 [DEBUG] switch_channel.c:1264 sofia/default/2349037542994@116.203.52.230 EXPORTING[export_vars] [presence_data]=[x|||Tumi(2330223285)|||||||||DID|||157.230.210.216] to event
2023-08-18 09:51:47.195849 [DEBUG] switch_channel.c:1264 sofia/default/2349037542994@116.203.52.230 EXPORTING[export_vars] [call_type]=[0] to event
2023-08-18 09:51:47.195849 [DEBUG] switch_channel.c:1264 sofia/default/2349037542994@116.203.52.230 EXPORTING[export_vars] [dialed_extension]=[transfer_call] to event
2023-08-18 09:51:47.195849 [DEBUG] switch_channel.c:1264 sofia/default/2349037542994@116.203.52.230 EXPORTING[export_vars] [did_user_domain]=[hq.ubx.univasa.com] to event
2023-08-18 09:51:47.195849 [DEBUG] switch_channel.c:1264 sofia/default/2349037542994@116.203.52.230 EXPORTING[export_vars] [dialed_extension]=[transfer_call] to event
2023-08-18 09:51:47.195849 [DEBUG] switch_ivr_originate.c:2272 Parsing global variables
2023-08-18 09:51:47.195849 [DEBUG] switch_ivr_originate.c:2834 Parsing session specific variables
2023-08-18 09:51:47.215852 [DEBUG] switch_channel.c:1264 sofia/default/2349037542994@116.203.52.230 EXPORTING[export_vars] [domain_name]=[hq.ubx.univasa.com] to event
2023-08-18 09:51:47.215852 [DEBUG] switch_channel.c:1264 sofia/default/2349037542994@116.203.52.230 EXPORTING[export_vars] [sip_to_host]=[hq.ubx.univasa.com] to event
2023-08-18 09:51:47.215852 [DEBUG] switch_channel.c:1264 sofia/default/2349037542994@116.203.52.230 EXPORTING[export_vars] [presence_data]=[x|||Tumi(2330223285)|||||||||DID|||157.230.210.216] to event
2023-08-18 09:51:47.215852 [DEBUG] switch_channel.c:1264 sofia/default/2349037542994@116.203.52.230 EXPORTING[export_vars] [call_type]=[0] to event
2023-08-18 09:51:47.215852 [DEBUG] switch_channel.c:1264 sofia/default/2349037542994@116.203.52.230 EXPORTING[export_vars] [dialed_extension]=[transfer_call] to event
2023-08-18 09:51:47.215852 [DEBUG] switch_channel.c:1264 sofia/default/2349037542994@116.203.52.230 EXPORTING[export_vars] [did_user_domain]=[hq.ubx.univasa.com] to event
2023-08-18 09:51:47.215852 [DEBUG] switch_channel.c:1264 sofia/default/2349037542994@116.203.52.230 EXPORTING[export_vars] [dialed_extension]=[transfer_call] to event
2023-08-18 09:51:47.215852 [DEBUG] switch_ivr_originate.c:2272 Parsing global variables
2023-08-18 09:51:47.215852 [NOTICE] switch_channel.c:1118 New Channel sofia/default/002@114.31.164.97:59751 [3e85a4e7-70f2-4370-8c14-53bd56f9d5d5]
2023-08-18 09:51:47.215852 [DEBUG] mod_sofia.c:5102 (sofia/default/002@114.31.164.97:59751) State Change CS_NEW -> CS_INIT
2023-08-18 09:51:47.215852 [DEBUG] switch_ivr_originate.c:3142 sofia/default/002@114.31.164.97:59751 Setting leg timeout to 60
2023-08-18 09:51:47.215852 [DEBUG] switch_core_state_machine.c:585 (sofia/default/002@114.31.164.97:59751) Running State Change CS_INIT (Cur 2 Tot 172)
2023-08-18 09:51:47.215852 [DEBUG] switch_core_state_machine.c:628 (sofia/default/002@114.31.164.97:59751) State INIT
2023-08-18 09:51:47.215852 [DEBUG] mod_sofia.c:93 sofia/default/002@114.31.164.97:59751 SOFIA INIT
2023-08-18 09:51:47.215852 [DEBUG] sofia_glue.c:1590 sip:002@114.31.164.97:26360;rinstance=c302e02bd5d0d837;transport=TCP Setting proxy route to sofia/default/002@114.31.164.97:59751
2023-08-18 09:51:47.215852 [INFO] sofia_glue.c:1621 sofia/default/002@114.31.164.97:59751 sending invite call-id: (null)
2023-08-18 09:51:47.215852 [DEBUG] sofia_glue.c:1624 sofia/default/002@114.31.164.97:59751 sending invite version: 1.10.6 -release-18-1ff9d0a60e 64bit
Local SDP:
v=0
o=FreeSWITCH 1692335203 1692335204 IN IP4 116.203.52.230
s=FreeSWITCH
c=IN IP4 116.203.52.230
t=0 0
m=audio 17104 RTP/AVP 0 101
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-16
a=ptime:20
a=sendrecv
2023-08-18 09:51:47.215852 [DEBUG] switch_core_state_machine.c:40 sofia/default/002@114.31.164.97:59751 Standard INIT
2023-08-18 09:51:47.215852 [DEBUG] switch_core_state_machine.c:48 (sofia/default/002@114.31.164.97:59751) State Change CS_INIT -> CS_ROUTING
2023-08-18 09:51:47.215852 [DEBUG] switch_core_state_machine.c:628 (sofia/default/002@114.31.164.97:59751) State INIT going to sleep
2023-08-18 09:51:47.215852 [DEBUG] switch_core_state_machine.c:585 (sofia/default/002@114.31.164.97:59751) Running State Change CS_ROUTING (Cur 2 Tot 172)
2023-08-18 09:51:47.215852 [DEBUG] sofia.c:7406 Channel sofia/default/002@114.31.164.97:59751 entering state [calling][0]
2023-08-18 09:51:47.215852 [DEBUG] switch_core_state_machine.c:644 (sofia/default/002@114.31.164.97:59751) State ROUTING
2023-08-18 09:51:47.215852 [DEBUG] mod_sofia.c:154 sofia/default/002@114.31.164.97:59751 SOFIA ROUTING
2023-08-18 09:51:47.215852 [DEBUG] switch_ivr_originate.c:67 (sofia/default/002@114.31.164.97:59751) State Change CS_ROUTING -> CS_CONSUME_MEDIA
2023-08-18 09:51:47.215852 [DEBUG] switch_core_state_machine.c:644 (sofia/default/002@114.31.164.97:59751) State ROUTING going to sleep
2023-08-18 09:51:47.215852 [DEBUG] switch_core_state_machine.c:585 (sofia/default/002@114.31.164.97:59751) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 172)
2023-08-18 09:51:47.215852 [DEBUG] switch_core_state_machine.c:663 (sofia/default/002@114.31.164.97:59751) State CONSUME_MEDIA
2023-08-18 09:51:47.215852 [DEBUG] switch_core_state_machine.c:663 (sofia/default/002@114.31.164.97:59751) State CONSUME_MEDIA going to sleep
2023-08-18 09:51:49.055847 [WARNING] sofia_reg.c:1795 SIP auth challenge (REGISTER) on sofia profile 'default' for [6664@hq.ubx.univasa.com] from ip 50.62.182.251
2023-08-18 09:51:49.235860 [WARNING] sofia_reg.c:2932 Can't find user [6664@hq.ubx.univasa.com] from 50.62.182.251
You must define a domain called 'hq.ubx.univasa.com' in your directory and add a user with the id="6664" attribute
and you must configure your device to use the proper domain in its authentication credentials.
2023-08-18 09:51:49.235860 [WARNING] sofia_reg.c:1740 SIP auth failure (REGISTER) on sofia profile 'default' for [6664@hq.ubx.univasa.com] from ip 50.62.182.251
2023-08-18 09:51:50.615852 [WARNING] sofia_reg.c:1795 SIP auth challenge (REGISTER) on sofia profile 'default' for [4778@hq.ubx.univasa.com] from ip 184.168.28.1
2023-08-18 09:51:50.775852 [WARNING] sofia_reg.c:2932 Can't find user [4778@hq.ubx.univasa.com] from 184.168.28.1
You must define a domain called 'hq.ubx.univasa.com' in your directory and add a user with the id="4778" attribute
and you must configure your device to use the proper domain in its authentication credentials.
2023-08-18 09:51:50.775852 [WARNING] sofia_reg.c:1740 SIP auth failure (REGISTER) on sofia profile 'default' for [4778@hq.ubx.univasa.com] from ip 184.168.28.1
2023-08-18 09:51:51.735851 [WARNING] sofia_reg.c:1795 SIP auth challenge (REGISTER) on sofia profile 'default' for [9054@test.ubx.univasa.com] from ip 184.168.30.222
2023-08-18 09:51:51.875847 [WARNING] sofia_reg.c:2932 Can't find user [9054@test.ubx.univasa.com] from 184.168.30.222
You must define a domain called 'test.ubx.univasa.com' in your directory and add a user with the id="9054" attribute
and you must configure your device to use the proper domain in its authentication credentials.
2023-08-18 09:51:51.875847 [WARNING] sofia_reg.c:1740 SIP auth failure (REGISTER) on sofia profile 'default' for [9054@test.ubx.univasa.com] from ip 184.168.30.222
2023-08-18 09:51:52.695857 [DEBUG] sofia.c:7406 Channel sofia/default/2349037542994@116.203.52.230 entering state [terminated][487]
2023-08-18 09:51:52.695857 [NOTICE] sofia.c:8641 Hangup sofia/default/2349037542994@116.203.52.230 [CS_EXECUTE] [ORIGINATOR_CANCEL]
2023-08-18 09:51:52.715857 [NOTICE] switch_ivr_originate.c:3790 Hangup sofia/default/002@114.31.164.97:59751 [CS_CONSUME_MEDIA] [ORIGINATOR_CANCEL]
2023-08-18 09:51:52.715857 [DEBUG] switch_ivr_originate.c:4015 Originate Cancelled by originator termination Cause: 487 [ORIGINATOR_CANCEL]
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:585 (sofia/default/002@114.31.164.97:59751) Running State Change CS_HANGUP (Cur 2 Tot 172)
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:848 (sofia/default/002@114.31.164.97:59751) Callstate Change DOWN -> HANGUP
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:850 (sofia/default/002@114.31.164.97:59751) State HANGUP
2023-08-18 09:51:52.715857 [DEBUG] mod_sofia.c:447 sofia/default/002@114.31.164.97:59751 Overriding SIP cause 487 with 487 from the other leg
2023-08-18 09:51:52.715857 [DEBUG] mod_sofia.c:453 Channel sofia/default/002@114.31.164.97:59751 hanging up, cause: ORIGINATOR_CANCEL
2023-08-18 09:51:52.715857 [NOTICE] switch_ivr_originate.c:3030 Cannot create outgoing channel of type [user] cause: [ORIGINATOR_CANCEL]
2023-08-18 09:51:52.715857 [DEBUG] switch_ivr_originate.c:4026 Originate Resulted in Error Cause: 487 [ORIGINATOR_CANCEL]
2023-08-18 09:51:52.715857 [DEBUG] mod_sofia.c:521 Sending CANCEL to sofia/default/002@114.31.164.97:59751
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:60 sofia/default/002@114.31.164.97:59751 Standard HANGUP, cause: ORIGINATOR_CANCEL
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:850 (sofia/default/002@114.31.164.97:59751) State HANGUP going to sleep
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:620 (sofia/default/002@114.31.164.97:59751) State Change CS_HANGUP -> CS_REPORTING
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:585 (sofia/default/002@114.31.164.97:59751) Running State Change CS_REPORTING (Cur 2 Tot 172)
2023-08-18 09:51:52.715857 [INFO] mod_dptools.c:3643 Originate Failed. Cause: ORIGINATOR_CANCEL
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:936 (sofia/default/002@114.31.164.97:59751) State REPORTING
2023-08-18 09:51:52.715857 [DEBUG] switch_core_session.c:2914 sofia/default/2349037542994@116.203.52.230 skip receive message [APPLICATION_EXEC_COMPLETE] (channel is hungup already)
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:651 (sofia/default/2349037542994@116.203.52.230) State EXECUTE going to sleep
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:585 (sofia/default/2349037542994@116.203.52.230) Running State Change CS_HANGUP (Cur 2 Tot 172)
2023-08-18 09:51:52.715857 [INFO] mod_json_cdr.c:271 Process [3e85a4e7-70f2-4370-8c14-53bd56f9d5d5.cdr.json]
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:848 (sofia/default/2349037542994@116.203.52.230) Callstate Change RINGING -> HANGUP
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:850 (sofia/default/2349037542994@116.203.52.230) State HANGUP
2023-08-18 09:51:52.715857 [DEBUG] mod_sofia.c:453 Channel sofia/default/2349037542994@116.203.52.230 hanging up, cause: ORIGINATOR_CANCEL
2023-08-18 09:51:52.715857 [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.00000 per minute to account 12
2023-08-18 09:51:52.715857 [DEBUG] mod_nibblebill.c:518 Not billing 12 - call is not in answered state
2023-08-18 09:51:52.715857 [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='12']
2023-08-18 09:51:52.715857 [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 12 (balance = 8.870400)
2023-08-18 09:51:52.715857 [DEBUG] mod_nibblebill.c:523 Comparing 8.870400 to hangup balance of 0.000000, taking into account minimum charge of 0.000000
2023-08-18 09:51:52.715857 [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='12']
2023-08-18 09:51:52.715857 [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 12 (balance = 8.870400)
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:60 sofia/default/2349037542994@116.203.52.230 Standard HANGUP, cause: ORIGINATOR_CANCEL
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:850 (sofia/default/2349037542994@116.203.52.230) State HANGUP going to sleep
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:620 (sofia/default/2349037542994@116.203.52.230) State Change CS_HANGUP -> CS_REPORTING
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:585 (sofia/default/2349037542994@116.203.52.230) Running State Change CS_REPORTING (Cur 2 Tot 172)
2023-08-18 09:51:52.715857 [DEBUG] switch_core_state_machine.c:936 (sofia/default/2349037542994@116.203.52.230) State REPORTING
2023-08-18 09:51:52.715857 [INFO] mod_json_cdr.c:271 Process [b427a3f8-aba1-45f1-8f4b-e5ec6985f181.cdr.json]
2023-08-18 09:51:52.735853 [DEBUG] switch_core_state_machine.c:174 sofia/default/002@114.31.164.97:59751 Standard REPORTING, cause: ORIGINATOR_CANCEL
2023-08-18 09:51:52.735853 [DEBUG] switch_core_state_machine.c:936 (sofia/default/002@114.31.164.97:59751) State REPORTING going to sleep
2023-08-18 09:51:52.735853 [DEBUG] switch_core_state_machine.c:611 (sofia/default/002@114.31.164.97:59751) State Change CS_REPORTING -> CS_DESTROY
2023-08-18 09:51:52.735853 [DEBUG] switch_core_session.c:1736 Session 172 (sofia/default/002@114.31.164.97:59751) Locked, Waiting on external entities
2023-08-18 09:51:52.735853 [NOTICE] switch_core_session.c:1754 Session 172 (sofia/default/002@114.31.164.97:59751) Ended
2023-08-18 09:51:52.735853 [NOTICE] switch_core_session.c:1758 Close Channel sofia/default/002@114.31.164.97:59751 [CS_DESTROY]
2023-08-18 09:51:52.735853 [DEBUG] switch_core_state_machine.c:739 (sofia/default/002@114.31.164.97:59751) Running State Change CS_DESTROY (Cur 1 Tot 172)
2023-08-18 09:51:52.735853 [DEBUG] switch_core_state_machine.c:749 (sofia/default/002@114.31.164.97:59751) State DESTROY
2023-08-18 09:51:52.735853 [DEBUG] mod_sofia.c:364 sofia/default/002@114.31.164.97:59751 SOFIA DESTROY
2023-08-18 09:51:52.735853 [DEBUG] switch_core_state_machine.c:181 sofia/default/002@114.31.164.97:59751 Standard DESTROY
2023-08-18 09:51:52.735853 [DEBUG] switch_core_state_machine.c:749 (sofia/default/002@114.31.164.97:59751) State DESTROY going to sleep
2023-08-18 09:51:52.735853 [DEBUG] switch_core_state_machine.c:174 sofia/default/2349037542994@116.203.52.230 Standard REPORTING, cause: ORIGINATOR_CANCEL
2023-08-18 09:51:52.735853 [DEBUG] switch_core_state_machine.c:936 (sofia/default/2349037542994@116.203.52.230) State REPORTING going to sleep
2023-08-18 09:51:52.735853 [DEBUG] switch_core_state_machine.c:611 (sofia/default/2349037542994@116.203.52.230) State Change CS_REPORTING -> CS_DESTROY
2023-08-18 09:51:52.735853 [DEBUG] switch_core_session.c:1736 Session 171 (sofia/default/2349037542994@116.203.52.230) Locked, Waiting on external entities
2023-08-18 09:51:52.735853 [NOTICE] switch_core_session.c:1754 Session 171 (sofia/default/2349037542994@116.203.52.230) Ended
2023-08-18 09:51:52.735853 [NOTICE] switch_core_session.c:1758 Close Channel sofia/default/2349037542994@116.203.52.230 [CS_DESTROY]
2023-08-18 09:51:52.735853 [DEBUG] switch_core_state_machine.c:739 (sofia/default/2349037542994@116.203.52.230) Running State Change CS_DESTROY (Cur 0 Tot 172)
2023-08-18 09:51:52.735853 [DEBUG] switch_core_state_machine.c:749 (sofia/default/2349037542994@116.203.52.230) State DESTROY
2023-08-18 09:51:52.735853 [DEBUG] mod_sofia.c:364 sofia/default/2349037542994@116.203.52.230 SOFIA DESTROY
2023-08-18 09:51:52.735853 [DEBUG] switch_core_state_machine.c:181 sofia/default/2349037542994@116.203.52.230 Standard DESTROY
2023-08-18 09:51:52.735853 [DEBUG] switch_core_state_machine.c:749 (sofia/default/2349037542994@116.203.52.230) State DESTROY going to sleep
2023-08-18 09:51:53.195852 [DEBUG] switch_scheduler.c:147 Deleting task 63 switch_core_session_sched_heartbeat (b427a3f8-aba1-45f1-8f4b-e5ec6985f181)