freeswitch@devangASTPP>
freeswitch@devangASTPP>
freeswitch@devangASTPP>
2022-05-30 07:56:23.517528 95.20% [NOTICE] switch_channel.c:1123 New Channel sofia/default/9148867777@astppqa606.astppbilling.org:5064 [05718ab7-a651-4b00-98c8-37dfaa181d99]
2022-05-30 07:56:23.517528 95.20% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) Running State Change CS_NEW (Cur 1 Tot 39)
2022-05-30 07:56:23.517528 95.20% [INFO] sofia.c:10462 sofia/default/9148867777@astppqa606.astppbilling.org:5064 receiving invite from 103.240.35.46:56488 version: 1.10.7 -release 64bit call-id: pF79MMxMbL1Y-pNFANperg..
2022-05-30 07:56:23.517528 95.20% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 103.240.35.46:0.
2022-05-30 07:56:23.517528 95.20% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [110054054@astppqa606.astppbilling.org] from ip 103.240.35.46
2022-05-30 07:56:23.517528 95.20% [DEBUG] switch_core_state_machine.c:600 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) State NEW
2022-05-30 07:56:23.517528 95.20% [DEBUG] sofia.c:2419 detaching session 05718ab7-a651-4b00-98c8-37dfaa181d99
2022-05-30 07:56:23.897519 95.20% [DEBUG] sofia.c:2532 Re-attaching to session 05718ab7-a651-4b00-98c8-37dfaa181d99
2022-05-30 07:56:23.897519 95.20% [INFO] sofia.c:10462 sofia/default/9148867777@astppqa606.astppbilling.org:5064 receiving invite from 103.240.35.46:56488 version: 1.10.7 -release 64bit call-id: pF79MMxMbL1Y-pNFANperg..
2022-05-30 07:56:23.897519 95.20% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 103.240.35.46:0.
2022-05-30 07:56:23.917515 95.20% [DEBUG] sofia.c:11672 Setting NAT mode based on via port
2022-05-30 07:56:23.917515 95.20% [DEBUG] sofia.c:7499 Channel sofia/default/9148867777@astppqa606.astppbilling.org:5064 entering state [received][100]
2022-05-30 07:56:23.917515 95.20% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=Z 0 0 IN IP4 103.240.35.46
s=Z
c=IN IP4 103.240.35.46
t=0 0
m=audio 8000 RTP/AVP 3 110 8 0 97 101
a=rtpmap:110 speex/8000
a=rtpmap:97 iLBC/8000
a=fmtp:97 mode=30
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-16
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1]
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMA:8:8000:20:64000:1]
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMU:0:8000:20:64000:1]
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:97:8000:30:0:1]/[PCMA:8:8000:20:64000:1]
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:97:8000:30:0:1]/[PCMU:0:8000:20:64000:1]
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/9148867777@astppqa606.astppbilling.org:5064 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_codec.c:111 sofia/default/9148867777@astppqa606.astppbilling.org:5064 Original read codec set to PCMA:8
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_media.c:5973 sofia/default/9148867777@astppqa606.astppbilling.org:5064 Set 2833 dtmf send payload to 101 recv payload to 101
2022-05-30 07:56:23.917515 95.20% [DEBUG] sofia.c:7933 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) State Change CS_NEW -> CS_INIT
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) Running State Change CS_INIT (Cur 1 Tot 39)
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_state_machine.c:624 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) State INIT
2022-05-30 07:56:23.917515 95.20% [DEBUG] mod_sofia.c:97 sofia/default/9148867777@astppqa606.astppbilling.org:5064 SOFIA INIT
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_state_machine.c:40 sofia/default/9148867777@astppqa606.astppbilling.org:5064 Standard INIT
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_state_machine.c:48 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) State Change CS_INIT -> CS_ROUTING
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_state_machine.c:624 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) State INIT going to sleep
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) Running State Change CS_ROUTING (Cur 1 Tot 39)
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_channel.c:2380 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) Callstate Change DOWN -> RINGING
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_state_machine.c:640 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) State ROUTING
2022-05-30 07:56:23.917515 95.20% [DEBUG] mod_sofia.c:158 sofia/default/9148867777@astppqa606.astppbilling.org:5064 SOFIA ROUTING
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_core_state_machine.c:230 sofia/default/9148867777@astppqa606.astppbilling.org:5064 Standard ROUTING
2022-05-30 07:56:23.917515 95.20% [INFO] mod_dialplan_xml.c:639 Processing 9148867777 <9148867777>->110054054 in context default
2022-05-30 07:56:23.917515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2022-05-30 07:56:23.917515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 110054054
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0
2022-05-30 07:56:23.917515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER9148867777
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT accountid FROM sip_devices WHERE username = '110054054' limit 1
2022-05-30 07:56:23.917515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 9148867777 / 9148867777
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
2022-05-30 07:56:23.917515 95.20% [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,sip_devices.codec as sip_codec 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="110054054" limit 1
2022-05-30 07:56:23.917515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
2022-05-30 07:56:23.917515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 9148867339]
2022-05-30 07:56:23.917515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "9148867339" AND deleted = 0 limit 1
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^110054054.*' OR blocked_patterns = '^11005405.*' OR blocked_patterns = '^1100540.*' OR blocked_patterns = '^110054.*' OR blocked_patterns = '^11005.*' OR blocked_patterns = '^1100.*' OR blocked_patterns = '^110.*' OR blocked_patterns = '^11.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 8 limit 1
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0
2022-05-30 07:56:23.937515 95.20% [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 P.is_terminated = 0 AND (patterns = '^110054054.*' OR patterns = '^11005405.*' OR patterns = '^1100540.*' OR patterns = '^110054.*' OR patterns = '^11005.*' OR patterns = '^1100.*' OR patterns = '^110.*' OR patterns = '^11.*' OR patterns = '^1.*' OR patterns ='--') AND accountid = 8 ORDER BY LENGTH(PKGPTR.patterns) DESC
2022-05-30 07:56:23.937515 95.20% [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 ="110054054" AND A.accountid = '8' limit 1
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 110054054
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
2022-05-30 07:56:23.937515 95.20% [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,sip_devices.codec as sip_codec 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="110054054" limit 1
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : outbound
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type,accountid FROM call_barring WHERE ((number = '110054054' OR number = '11005405' OR number = '1100540' OR number = '110054' OR number = '11005' OR number = '1100' OR number = '110' OR number = '11' OR number = '1' OR number ='--') OR (number = '110054054*' OR number = '11005405*' OR number = '1100540*' OR number = '110054*' OR number = '11005*' OR number = '1100*' OR number = '110*' OR number = '11*' OR number = '1*' OR number ='--') OR (number = '9148867777' OR number = '914886777' OR number = '91488677' OR number = '9148867' OR number = '914886' OR number = '91488' OR number = '9148' OR number = '914' OR number = '91' OR number = '9' OR number ='--') OR (number = '9148867777*' OR number = '914886777*' OR number = '91488677*' OR number = '9148867*' OR number = '914886*' OR number = '91488*' OR number = '9148*' OR number = '914*' OR number = '91*' OR number = '9*' OR number ='--')) AND status=0 AND accountid = 0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '110054054' OR routing_prefix = '11005405' OR routing_prefix = '1100540' OR routing_prefix = '110054' OR routing_prefix = '11005' OR routing_prefix = '1100' OR routing_prefix = '110' OR routing_prefix = '11' OR routing_prefix = '1' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 8
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 9148867339
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 171
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 7
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::7
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :outbound
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::7
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :my-rates-7
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :my-rates-7
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :my-rates-7
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]0 GOT___SUCCESS2022-05-30 07:56:23
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]1=GOT___SUCCESS=pattern::^667.*
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]1=GOT___SUCCESS=caller_id_pattern::^.*
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]0 GOT___SUCCESS2022-05-30 07:56:23
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]1=GOT___SUCCESS=pattern::^333.*
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]1=GOT___SUCCESS=caller_id_pattern::^.*
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]0 GOT___SUCCESS2022-05-30 07:56:23
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]1=GOT___SUCCESS=pattern::^44.*
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]1=GOT___SUCCESS=caller_id_pattern::^.*
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]0 GOT___SUCCESS2022-05-30 07:56:23
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]1=GOT___SUCCESS=pattern::^11.*
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]1=GOT___SUCCESS=caller_id_pattern::^.*
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]0 GOT___SUCCESS2022-05-30 07:56:23
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]1=GOT___SUCCESS=pattern::^11.*
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]1=GOT___SUCCESS=caller_id_pattern::^.*
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Direction : outbound
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:2.00000
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:7
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday,timezone_name from demand_based_routing where pricelist_id = '7' and status=0
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] holiday_based_routing :
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Holiday Query :SELECT gmttime from timezone where id = '309'
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Holiday Data :GMT+12:00
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Holiday Plus timezone
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]If Holiday timezone like = -05:00 :
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Converted Holiday current_time_date:30
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Converted Holiday current_time_month:May
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Hliday today_date :30-5
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Hliday today_date :3
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] demand_based_condition :
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT gmttime from timezone where id = '309'
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Data :GMT+12:00
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Plus timezone
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]If timezone like = +05:00 :
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Converted current_time: 19.56
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] BEFORE current_wday :Mon
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]If Holiday timezone like = -00:00 :
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Converted DAY current_wday:Mon
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] AFTER current_wday :Mon
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Current Day Number2
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Demand based routing Match emand_based_condition_value['wday'][1] :5-5
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Demand based routing Match emand_based_condition_value['wday'][1] :4-4
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Demand based routing Match emand_based_condition_value['wday'][1] :5-5
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Demand based routing Match emand_based_condition_value['wday'][1] :6-6
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:2.00000
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 16
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 2.00000
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : Admin-India
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 98
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 8
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Trunk ID:
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Routing type:
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Shadow_billing_rates]SHADOWBILLING:0|ID:16|CODE:^11.*|DESTINATION:Admin-India|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:2.00000|INC:60|INITIALBLOCK:60|RATEGROUP:7|MARKUP:0|CI:98|ACCID:8!!!
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your171 balance Accountid 8 !!!
2022-05-30 07:56:23.937515 95.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 85.5 minutes
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query Rate Carrier Id :
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES_TRUNKS] Query :SELECT GROUP_CONCAT(trunk_id) as ids FROM routing WHERE pricelist_id=7 ORDER by id asc
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query :SELECT TK.id as trunk_id,TK.name as trunk_name,TK.sip_cid_type,TK.codec,GW.name as path,GW.dialplan_variable,TK.provider_id,TR.init_inc,TK.status,TK.maxchannels,TK.cps,TK.leg_timeout,TR.pattern,TR.id as outbound_route_id,TR.connectcost,TR.comment,TR.includedseconds,TR.cost,TR.inc,TR.prepend,TR.strip,(select name from gateways where status=0 AND id = TK.failover_gateway_id) as path1,(select name from gateways where status=0 AND id = TK.failover_gateway_id1) as path2 FROM outbound_routes as TR,trunks as TK,gateways as GW WHERE GW.status=0 AND GW.id= TK.gateway_id AND TK.status=0 AND TK.id= TR.trunk_id AND (pattern = '^110054054.*' OR pattern = '^11005405.*' OR pattern = '^1100540.*' OR pattern = '^110054.*' OR pattern = '^11005.*' OR pattern = '^1100.*' OR pattern = '^110.*' OR pattern = '^11.*' OR pattern = '^1.*' OR pattern ='--') AND TR.status = 0 AND TR.trunk_id IN (5) AND TR.effective_date <= UTC_TIMESTAMP() ORDER by LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC, TK.precedence,TR.effective_date DESC
2022-05-30 07:56:23.937515 95.20% [ERR] mod_lua.cpp:202 ...ocal/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:854: attempt to concatenate global 'quality_trunk_seq' (a nil value)
stack traceback:
...ocal/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:854: in main chunk
[C]: in function 'dofile'
/usr/local/freeswitch/scripts/astpp/astpp.lua:138: in main chunk
2022-05-30 07:56:23.937515 95.20% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
2022-05-30 07:56:23.937515 95.20% [WARNING] mod_dialplan_xml.c:669 Context default not found
2022-05-30 07:56:23.937515 95.20% [INFO] switch_core_state_machine.c:306 No Route, Aborting
2022-05-30 07:56:23.937515 95.20% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/9148867777@astppqa606.astppbilling.org:5064 [CS_ROUTING] [NO_ROUTE_DESTINATION]
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:640 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) State ROUTING going to sleep
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) Running State Change CS_HANGUP (Cur 1 Tot 39)
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:844 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) Callstate Change RINGING -> HANGUP
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:846 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) State HANGUP
2022-05-30 07:56:23.937515 95.20% [DEBUG] mod_sofia.c:468 Channel sofia/default/9148867777@astppqa606.astppbilling.org:5064 hanging up, cause: NO_ROUTE_DESTINATION
2022-05-30 07:56:23.937515 95.20% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:59 sofia/default/9148867777@astppqa606.astppbilling.org:5064 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:846 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) State HANGUP going to sleep
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:616 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) State Change CS_HANGUP -> CS_REPORTING
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) Running State Change CS_REPORTING (Cur 1 Tot 39)
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:932 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) State REPORTING
2022-05-30 07:56:23.937515 95.20% [INFO] mod_json_cdr.c:271 Process [05718ab7-a651-4b00-98c8-37dfaa181d99.cdr.json]
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:168 sofia/default/9148867777@astppqa606.astppbilling.org:5064 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:932 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) State REPORTING going to sleep
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:607 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) State Change CS_REPORTING -> CS_DESTROY
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_session.c:1753 Session 39 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) Locked, Waiting on external entities
2022-05-30 07:56:23.937515 95.20% [NOTICE] switch_core_session.c:1771 Session 39 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) Ended
2022-05-30 07:56:23.937515 95.20% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/9148867777@astppqa606.astppbilling.org:5064 [CS_DESTROY]
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:735 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) Running State Change CS_DESTROY (Cur 0 Tot 39)
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:745 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) State DESTROY
2022-05-30 07:56:23.937515 95.20% [DEBUG] mod_sofia.c:379 sofia/default/9148867777@astppqa606.astppbilling.org:5064 SOFIA DESTROY
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:175 sofia/default/9148867777@astppqa606.astppbilling.org:5064 Standard DESTROY
2022-05-30 07:56:23.937515 95.20% [DEBUG] switch_core_state_machine.c:745 (sofia/default/9148867777@astppqa606.astppbilling.org:5064) State DESTROY going to sleep
2022-05-30 07:56:39.437520 98.90% [WARNING] sofia_reg.c:1861 SIP auth challenge (REGISTER) on sofia profile 'default' for [9140336004@astppqa606.astppbilling.org] from ip 117.247.91.162
2022-05-30 07:56:39.657531 98.87% [WARNING] sofia_reg.c:3223 Can't find user [9140336004@astppqa606.astppbilling.org] from 117.247.91.162
You must define a domain called 'astppqa606.astppbilling.org' in your directory and add a user with the id="9140336004" attribute
and you must configure your device to use the proper domain in its authentication credentials.
2022-05-30 07:56:39.657531 98.87% [WARNING] sofia_reg.c:1806 SIP auth failure (REGISTER) on sofia profile 'default' for [9140336004@astppqa606.astppbilling.org] from ip 117.247.91.162
2022-05-30 07:58:47.437529 99.73% [WARNING] sofia_reg.c:1861 SIP auth challenge (REGISTER) on sofia profile 'default' for [9140336004@astppqa606.astppbilling.org] from ip 117.247.91.162
2022-05-30 07:58:48.697524 99.27% [WARNING] sofia_reg.c:3223 Can't find user [9140336004@astppqa606.astppbilling.org] from 117.247.91.162
You must define a domain called 'astppqa606.astppbilling.org' in your directory and add a user with the id="9140336004" attribute
and you must configure your device to use the proper domain in its authentication credentials.
2022-05-30 07:58:48.697524 99.27% [WARNING] sofia_reg.c:1806 SIP auth failure (REGISTER) on sofia profile 'default' for [9140336004@astppqa606.astppbilling.org] from ip 117.247.91.162
2022-05-30 08:00:55.537514 99.47% [WARNING] sofia_reg.c:1861 SIP auth challenge (REGISTER) on sofia profile 'default' for [9140336004@astppqa606.astppbilling.org] from ip 117.247.91.162
2022-05-30 08:00:55.757520 99.50% [WARNING] sofia_reg.c:3223 Can't find user [9140336004@astppqa606.astppbilling.org] from 117.247.91.162
You must define a domain called 'astppqa606.astppbilling.org' in your directory and add a user with the id="9140336004" attribute
and you must configure your device to use the proper domain in its authentication credentials.
2022-05-30 08:00:55.757520 99.50% [WARNING] sofia_reg.c:1806 SIP auth failure (REGISTER) on sofia profile 'default' for [9140336004@astppqa606.astppbilling.org] from ip 117.247.91.162
2022-05-30 08:02:03.557514 99.53% [NOTICE] switch_channel.c:1123 New Channel sofia/default/714933@astppqa601.astppbilling.org:5064 [03abdc53-9bd3-4bde-8395-88e9fe9af4e9]
2022-05-30 08:02:03.557514 99.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/714933@astppqa601.astppbilling.org:5064) Running State Change CS_NEW (Cur 1 Tot 40)
2022-05-30 08:02:03.557514 99.53% [INFO] sofia.c:10462 sofia/default/714933@astppqa601.astppbilling.org:5064 receiving invite from 103.240.35.46:40184 version: 1.10.7 -release 64bit call-id: ZTViZWZmYmRkZThkNTY1OWI1NGU5ZTdmZmVlZTU5NDg.
2022-05-30 08:02:03.557514 99.53% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 103.240.35.46:0.
2022-05-30 08:02:03.557514 99.53% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [1009724940629@astppqa601.astppbilling.org] from ip 103.240.35.46
2022-05-30 08:02:03.557514 99.53% [DEBUG] switch_core_state_machine.c:600 (sofia/default/714933@astppqa601.astppbilling.org:5064) State NEW
2022-05-30 08:02:03.557514 99.53% [DEBUG] sofia.c:2419 detaching session 03abdc53-9bd3-4bde-8395-88e9fe9af4e9
2022-05-30 08:02:03.897528 99.50% [DEBUG] sofia.c:2532 Re-attaching to session 03abdc53-9bd3-4bde-8395-88e9fe9af4e9
2022-05-30 08:02:03.917552 99.50% [INFO] sofia.c:10462 sofia/default/714933@astppqa601.astppbilling.org:5064 receiving invite from 103.240.35.46:40184 version: 1.10.7 -release 64bit call-id: ZTViZWZmYmRkZThkNTY1OWI1NGU5ZTdmZmVlZTU5NDg.
2022-05-30 08:02:03.917552 99.50% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 103.240.35.46:0.
2022-05-30 08:02:03.917552 99.50% [DEBUG] sofia.c:11672 Setting NAT mode based on via received
2022-05-30 08:02:03.917552 99.50% [DEBUG] sofia.c:7499 Channel sofia/default/714933@astppqa601.astppbilling.org:5064 entering state [received][100]
2022-05-30 08:02:03.917552 99.50% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=Z 0 0 IN IP4 103.240.35.46
s=Z
c=IN IP4 103.240.35.46
t=0 0
m=audio 8000 RTP/AVP 3 110 8 0 98 101
a=rtpmap:110 speex/8000
a=rtpmap:98 iLBC/8000
a=fmtp:98 mode=20
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1]
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMA:8:8000:20:64000:1]
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMU:0:8000:20:64000:1]
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMA:8:8000:20:64000:1]
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMU:0:8000:20:64000:1]
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/714933@astppqa601.astppbilling.org:5064 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_codec.c:111 sofia/default/714933@astppqa601.astppbilling.org:5064 Original read codec set to PCMA:8
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_media.c:5973 sofia/default/714933@astppqa601.astppbilling.org:5064 Set 2833 dtmf send payload to 101 recv payload to 101
2022-05-30 08:02:03.917552 99.50% [DEBUG] sofia.c:7933 (sofia/default/714933@astppqa601.astppbilling.org:5064) State Change CS_NEW -> CS_INIT
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_state_machine.c:581 (sofia/default/714933@astppqa601.astppbilling.org:5064) Running State Change CS_INIT (Cur 1 Tot 40)
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_state_machine.c:624 (sofia/default/714933@astppqa601.astppbilling.org:5064) State INIT
2022-05-30 08:02:03.917552 99.50% [DEBUG] mod_sofia.c:97 sofia/default/714933@astppqa601.astppbilling.org:5064 SOFIA INIT
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_state_machine.c:40 sofia/default/714933@astppqa601.astppbilling.org:5064 Standard INIT
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_state_machine.c:48 (sofia/default/714933@astppqa601.astppbilling.org:5064) State Change CS_INIT -> CS_ROUTING
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_state_machine.c:624 (sofia/default/714933@astppqa601.astppbilling.org:5064) State INIT going to sleep
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_state_machine.c:581 (sofia/default/714933@astppqa601.astppbilling.org:5064) Running State Change CS_ROUTING (Cur 1 Tot 40)
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_channel.c:2380 (sofia/default/714933@astppqa601.astppbilling.org:5064) Callstate Change DOWN -> RINGING
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_state_machine.c:640 (sofia/default/714933@astppqa601.astppbilling.org:5064) State ROUTING
2022-05-30 08:02:03.917552 99.50% [DEBUG] mod_sofia.c:158 sofia/default/714933@astppqa601.astppbilling.org:5064 SOFIA ROUTING
2022-05-30 08:02:03.917552 99.50% [DEBUG] switch_core_state_machine.c:230 sofia/default/714933@astppqa601.astppbilling.org:5064 Standard ROUTING
2022-05-30 08:02:03.917552 99.50% [INFO] mod_dialplan_xml.c:639 Processing 714933 <714933>->1009724940629 in context default
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 1009724940629
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER714933
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT accountid FROM sip_devices WHERE username = '1009724940629' limit 1
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 714933 / 714933
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
2022-05-30 08:02:03.937523 99.50% [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,sip_devices.codec as sip_codec 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="1009724940629" limit 1
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 714933]
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "714933" AND deleted = 0 limit 1
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^1009724940629.*' OR blocked_patterns = '^100972494062.*' OR blocked_patterns = '^10097249406.*' OR blocked_patterns = '^1009724940.*' OR blocked_patterns = '^100972494.*' OR blocked_patterns = '^10097249.*' OR blocked_patterns = '^1009724.*' OR blocked_patterns = '^100972.*' OR blocked_patterns = '^10097.*' OR blocked_patterns = '^1009.*' OR blocked_patterns = '^100.*' OR blocked_patterns = '^10.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 27 limit 1
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0
2022-05-30 08:02:03.937523 99.50% [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 P.is_terminated = 0 AND (patterns = '^1009724940629.*' OR patterns = '^100972494062.*' OR patterns = '^10097249406.*' OR patterns = '^1009724940.*' OR patterns = '^100972494.*' OR patterns = '^10097249.*' OR patterns = '^1009724.*' OR patterns = '^100972.*' OR patterns = '^10097.*' OR patterns = '^1009.*' OR patterns = '^100.*' OR patterns = '^10.*' OR patterns = '^1.*' OR patterns ='--') AND accountid = 27 ORDER BY LENGTH(PKGPTR.patterns) DESC
2022-05-30 08:02:03.937523 99.50% [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 ="1009724940629" AND A.accountid = '27' limit 1
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 1009724940629
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
2022-05-30 08:02:03.937523 99.50% [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,sip_devices.codec as sip_codec 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="1009724940629" limit 1
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : outbound
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type,accountid FROM call_barring WHERE ((number = '1009724940629' OR number = '100972494062' OR number = '10097249406' OR number = '1009724940' OR number = '100972494' OR number = '10097249' OR number = '1009724' OR number = '100972' OR number = '10097' OR number = '1009' OR number = '100' OR number = '10' OR number = '1' OR number ='--') OR (number = '1009724940629*' OR number = '100972494062*' OR number = '10097249406*' OR number = '1009724940*' OR number = '100972494*' OR number = '10097249*' OR number = '1009724*' OR number = '100972*' OR number = '10097*' OR number = '1009*' OR number = '100*' OR number = '10*' OR number = '1*' OR number ='--') OR (number = '714933' OR number = '71493' OR number = '7149' OR number = '714' OR number = '71' OR number = '7' OR number ='--') OR (number = '714933*' OR number = '71493*' OR number = '7149*' OR number = '714*' OR number = '71*' OR number = '7*' OR number ='--')) AND status=0 AND accountid = 0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '1009724940629' OR routing_prefix = '100972494062' OR routing_prefix = '10097249406' OR routing_prefix = '1009724940' OR routing_prefix = '100972494' OR routing_prefix = '10097249' OR routing_prefix = '1009724' OR routing_prefix = '100972' OR routing_prefix = '10097' OR routing_prefix = '1009' OR routing_prefix = '100' OR routing_prefix = '10' OR routing_prefix = '1' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 27
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 714933
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 89.6401
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 13
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::13
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :outbound
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::13
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :my-rates-13
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :my-rates-13
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :my-rates-13
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]0 GOT___SUCCESS2022-05-30 08:02:03
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]1=GOT___SUCCESS=pattern::^100.*
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]1=GOT___SUCCESS=caller_id_pattern::^.*
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]0 GOT___SUCCESS2022-05-30 08:02:03
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]1=GOT___SUCCESS=pattern::^100.*
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]1=GOT___SUCCESS=caller_id_pattern::^.*
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Direction : outbound
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:5.00000
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:13
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday,timezone_name from demand_based_routing where pricelist_id = '13' and status=0
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:5.00000
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 24
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 5.00000
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : USA airtel
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 0
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 27
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] Trunk ID:
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] Routing type:
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] [Shadow_billing_rates]SHADOWBILLING:0|ID:24|CODE:^100.*|DESTINATION:USA airtel|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:5.00000|INC:1|INITIALBLOCK:1|RATEGROUP:13|MARKUP:0|CI:0|ACCID:27!!!
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your89.6401 balance Accountid 27 !!!
2022-05-30 08:02:03.937523 99.50% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 17.92802 minutes
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query Rate Carrier Id :
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES_TRUNKS] Query :SELECT GROUP_CONCAT(trunk_id) as ids FROM routing WHERE pricelist_id=13 ORDER by id asc
2022-05-30 08:02:03.937523 99.50% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query :SELECT TK.id as trunk_id,TK.name as trunk_name,TK.sip_cid_type,TK.codec,GW.name as path,GW.dialplan_variable,TK.provider_id,TR.init_inc,TK.status,TK.maxchannels,TK.cps,TK.leg_timeout,TR.pattern,TR.id as outbound_route_id,TR.connectcost,TR.comment,TR.includedseconds,TR.cost,TR.inc,TR.prepend,TR.strip,(select name from gateways where status=0 AND id = TK.failover_gateway_id) as path1,(select name from gateways where status=0 AND id = TK.failover_gateway_id1) as path2 FROM outbound_routes as TR,trunks as TK,gateways as GW WHERE GW.status=0 AND GW.id= TK.gateway_id AND TK.status=0 AND TK.id= TR.trunk_id AND (pattern = '^1009724940629.*' OR pattern = '^100972494062.*' OR pattern = '^10097249406.*' OR pattern = '^1009724940.*' OR pattern = '^100972494.*' OR pattern = '^10097249.*' OR pattern = '^1009724.*' OR pattern = '^100972.*' OR pattern = '^10097.*' OR pattern = '^1009.*' OR pattern = '^100.*' OR pattern = '^10.*' OR pattern = '^1.*' OR pattern ='--') AND TR.status = 0 AND TR.trunk_id IN (8) AND TR.effective_date <= UTC_TIMESTAMP() ORDER by LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC, TK.precedence,TR.effective_date DESC
2022-05-30 08:02:03.957521 99.50% [ERR] mod_lua.cpp:202 ...ocal/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:854: attempt to concatenate global 'quality_trunk_seq' (a nil value)
stack traceback:
...ocal/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:854: in main chunk
[C]: in function 'dofile'
/usr/local/freeswitch/scripts/astpp/astpp.lua:138: in main chunk
2022-05-30 08:02:03.957521 99.50% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
2022-05-30 08:02:03.957521 99.50% [WARNING] mod_dialplan_xml.c:669 Context default not found
2022-05-30 08:02:03.957521 99.50% [INFO] switch_core_state_machine.c:306 No Route, Aborting
2022-05-30 08:02:03.957521 99.50% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/714933@astppqa601.astppbilling.org:5064 [CS_ROUTING] [NO_ROUTE_DESTINATION]
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:640 (sofia/default/714933@astppqa601.astppbilling.org:5064) State ROUTING going to sleep
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:581 (sofia/default/714933@astppqa601.astppbilling.org:5064) Running State Change CS_HANGUP (Cur 1 Tot 40)
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:844 (sofia/default/714933@astppqa601.astppbilling.org:5064) Callstate Change RINGING -> HANGUP
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:846 (sofia/default/714933@astppqa601.astppbilling.org:5064) State HANGUP
2022-05-30 08:02:03.957521 99.50% [DEBUG] mod_sofia.c:468 Channel sofia/default/714933@astppqa601.astppbilling.org:5064 hanging up, cause: NO_ROUTE_DESTINATION
2022-05-30 08:02:03.957521 99.50% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:59 sofia/default/714933@astppqa601.astppbilling.org:5064 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:846 (sofia/default/714933@astppqa601.astppbilling.org:5064) State HANGUP going to sleep
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:616 (sofia/default/714933@astppqa601.astppbilling.org:5064) State Change CS_HANGUP -> CS_REPORTING
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:581 (sofia/default/714933@astppqa601.astppbilling.org:5064) Running State Change CS_REPORTING (Cur 1 Tot 40)
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:932 (sofia/default/714933@astppqa601.astppbilling.org:5064) State REPORTING
2022-05-30 08:02:03.957521 99.50% [INFO] mod_json_cdr.c:271 Process [03abdc53-9bd3-4bde-8395-88e9fe9af4e9.cdr.json]
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:168 sofia/default/714933@astppqa601.astppbilling.org:5064 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:932 (sofia/default/714933@astppqa601.astppbilling.org:5064) State REPORTING going to sleep
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:607 (sofia/default/714933@astppqa601.astppbilling.org:5064) State Change CS_REPORTING -> CS_DESTROY
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_session.c:1753 Session 40 (sofia/default/714933@astppqa601.astppbilling.org:5064) Locked, Waiting on external entities
2022-05-30 08:02:03.957521 99.50% [NOTICE] switch_core_session.c:1771 Session 40 (sofia/default/714933@astppqa601.astppbilling.org:5064) Ended
2022-05-30 08:02:03.957521 99.50% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/714933@astppqa601.astppbilling.org:5064 [CS_DESTROY]
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:735 (sofia/default/714933@astppqa601.astppbilling.org:5064) Running State Change CS_DESTROY (Cur 0 Tot 40)
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:745 (sofia/default/714933@astppqa601.astppbilling.org:5064) State DESTROY
2022-05-30 08:02:03.957521 99.50% [DEBUG] mod_sofia.c:379 sofia/default/714933@astppqa601.astppbilling.org:5064 SOFIA DESTROY
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:175 sofia/default/714933@astppqa601.astppbilling.org:5064 Standard DESTROY
2022-05-30 08:02:03.957521 99.50% [DEBUG] switch_core_state_machine.c:745 (sofia/default/714933@astppqa601.astppbilling.org:5064) State DESTROY going to sleep