OK log level [7]
freeswitch@AlphaQA>
freeswitch@AlphaQA>
2023-03-17 12:13:59.454741 93.53% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [45459@alpha.astppbilling.org] from ip 103.240.35.46
2023-03-17 12:13:59.774766 93.53% [WARNING] sofia_reg.c:3223 Can't find user [45459@alpha.astppbilling.org] from 103.240.35.46
You must define a domain called 'alpha.astppbilling.org' in your directory and add a user with the id="45459" attribute
and you must configure your device to use the proper domain in its authentication credentials.
2023-03-17 12:14:01.774737 92.77% [INFO] switch_stun.c:897 External ip address detected using STUN: 95.217.238.195
2023-03-17 12:14:01.994744 92.77% [INFO] switch_stun.c:897 External ip address detected using STUN: 95.217.238.195
2023-03-17 12:14:02.054741 92.77% [NOTICE] switch_loadable_module.c:1228 Deleting Application 'nibblebill'
2023-03-17 12:14:02.054741 92.77% [DEBUG] switch_loadable_module.c:1230 Write lock interface 'nibblebill' to wait for existing references.
2023-03-17 12:14:02.054741 92.77% [NOTICE] switch_loadable_module.c:1283 Deleting API Function 'nibblebill'
2023-03-17 12:14:02.054741 92.77% [DEBUG] switch_loadable_module.c:1285 Write lock interface 'nibblebill' to wait for existing references.
2023-03-17 12:14:02.054741 92.77% [CONSOLE] switch_loadable_module.c:2349 Stopping: mod_nibblebill
2023-03-17 12:14:02.074743 92.77% [INFO] switch_time.c:1430 Timezone reloaded 1750 definitions
2023-03-17 12:14:02.074743 92.77% [DEBUG] switch_event.c:2178 Event Binding deleted for mod_nibblebill:SESSION_HEARTBEAT
2023-03-17 12:14:02.074743 92.77% [CONSOLE] switch_loadable_module.c:2369 mod_nibblebill unloaded.
2023-03-17 12:14:02.094734 92.77% [INFO] mod_nibblebill.c:224 odbc_dsn is ASTPP:astppuser:tztR*eTWTIOX7aL7eDHe
2023-03-17 12:14:02.094734 92.77% [DEBUG] mod_nibblebill.c:284 dsn is "ASTPP:astppuser:tztR*eTWTIOX7aL7eDHe"
2023-03-17 12:14:02.094734 92.77% [CONSOLE] switch_loadable_module.c:1768 Successfully Loaded [mod_nibblebill]
2023-03-17 12:14:02.094734 92.77% [NOTICE] switch_loadable_module.c:329 Adding Application 'nibblebill'
2023-03-17 12:14:02.094734 92.77% [NOTICE] switch_loadable_module.c:389 Adding API Function 'nibblebill'
2023-03-17 12:14:04.854745 90.67% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [4455007@alpha.astppbilling.org] from ip 103.240.35.46
2023-03-17 12:14:05.154757 90.67% [WARNING] sofia_reg.c:3223 Can't find user [4455007@alpha.astppbilling.org] from 103.240.35.46
You must define a domain called 'alpha.astppbilling.org' in your directory and add a user with the id="4455007" attribute
and you must configure your device to use the proper domain in its authentication credentials.
2023-03-17 12:14:12.494744 91.17% [WARNING] sofia_reg.c:1861 SIP auth challenge (REGISTER) on sofia profile 'default' for [086860@alpha3.astppbilling.org] from ip 103.240.35.46
2023-03-17 12:14:13.214737 91.13% [WARNING] sofia_reg.c:3223 Can't find user [086860@alpha3.astppbilling.org] from 103.240.35.46
You must define a domain called 'alpha3.astppbilling.org' in your directory and add a user with the id="086860" attribute
and you must configure your device to use the proper domain in its authentication credentials.
2023-03-17 12:14:13.514755 91.13% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [086860@alpha3.astppbilling.org] from ip 103.240.35.46
2023-03-17 12:14:15.734753 91.20% [NOTICE] switch_channel.c:1123 New Channel sofia/default/990004@142.132.184.134 [03d333e6-a67f-494f-8cb1-29db0959dc23]
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990004@142.132.184.134) Running State Change CS_NEW (Cur 1 Tot 41)
2023-03-17 12:14:15.734753 91.20% [INFO] sofia.c:10462 sofia/default/990004@142.132.184.134 receiving invite from 142.132.184.134:5076 version: 1.10.7 -release 64bit call-id: 13a2dd39-3f60-123c-e281-9600013c8d14
2023-03-17 12:14:15.734753 91.20% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 142.132.184.134:0.
2023-03-17 12:14:15.734753 91.20% [DEBUG] sofia.c:10585 IP 142.132.184.134 Approved by acl "default[]". Access Granted.
2023-03-17 12:14:15.734753 91.20% [DEBUG] sofia.c:7499 Channel sofia/default/990004@142.132.184.134 entering state [received][100]
2023-03-17 12:14:15.734753 91.20% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=FreeSWITCH 1679035901 1679035902 IN IP4 142.132.184.134
s=FreeSWITCH
c=IN IP4 142.132.184.134
t=0 0
m=audio 19354 RTP/AVP 8 18 101
a=rtpmap:8 PCMA/8000
a=rtpmap:18 G729/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMA:8:8000:20:64000:1]
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMU:0:8000:20:64000:1]
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/990004@142.132.184.134 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_codec.c:111 sofia/default/990004@142.132.184.134 Original read codec set to PCMA:8
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_media.c:5973 sofia/default/990004@142.132.184.134 Set 2833 dtmf send payload to 101 recv payload to 101
2023-03-17 12:14:15.734753 91.20% [DEBUG] sofia.c:7933 (sofia/default/990004@142.132.184.134) State Change CS_NEW -> CS_INIT
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_state_machine.c:600 (sofia/default/990004@142.132.184.134) State NEW
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990004@142.132.184.134) Running State Change CS_INIT (Cur 1 Tot 41)
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_state_machine.c:624 (sofia/default/990004@142.132.184.134) State INIT
2023-03-17 12:14:15.734753 91.20% [DEBUG] mod_sofia.c:97 sofia/default/990004@142.132.184.134 SOFIA INIT
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_state_machine.c:40 sofia/default/990004@142.132.184.134 Standard INIT
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_state_machine.c:48 (sofia/default/990004@142.132.184.134) State Change CS_INIT -> CS_ROUTING
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_state_machine.c:624 (sofia/default/990004@142.132.184.134) State INIT going to sleep
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990004@142.132.184.134) Running State Change CS_ROUTING (Cur 1 Tot 41)
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_channel.c:2380 (sofia/default/990004@142.132.184.134) Callstate Change DOWN -> RINGING
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_state_machine.c:640 (sofia/default/990004@142.132.184.134) State ROUTING
2023-03-17 12:14:15.734753 91.20% [DEBUG] mod_sofia.c:158 sofia/default/990004@142.132.184.134 SOFIA ROUTING
2023-03-17 12:14:15.734753 91.20% [DEBUG] switch_core_state_machine.c:230 sofia/default/990004@142.132.184.134 Standard ROUTING
2023-03-17 12:14:15.734753 91.20% [INFO] mod_dialplan_xml.c:639 Processing 990004 <990004>->144 in context default
2023-03-17 12:14:15.754763 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
2023-03-17 12:14:15.754763 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2023-03-17 12:14:15.754763 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2023-03-17 12:14:15.754763 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-03-17 12:14:15.774748 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
2023-03-17 12:14:15.774748 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 144
2023-03-17 12:14:15.774748 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '144' limit 1
2023-03-17 12:14:15.774748 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0
2023-03-17 12:14:15.774748 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '144' and status=0 LIMIT 1
2023-03-17 12:14:15.774748 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBERUSERNAME
2023-03-17 12:14:15.774748 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-03-17 12:14:15.774748 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT accountid FROM sip_devices WHERE username = '144' limit 1
2023-03-17 12:14:15.774748 91.20% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
2023-03-17 12:14:15.774748 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 990004 / 990004
2023-03-17 12:14:15.774748 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number
2023-03-17 12:14:15.774748 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 144 AND status=0 limit 1
2023-03-17 12:14:15.774748 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
2023-03-17 12:14:15.774748 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1
2023-03-17 12:14:15.774748 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID
2023-03-17 12:14:15.774748 91.20% [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, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="144" LIMIT 1
2023-03-17 12:14:15.774748 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_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,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="144" LIMIT 1
2023-03-17 12:14:15.774748 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-03-17 12:14:15.774748 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="133" and did_id ="16" and number ="990004" and status = '0' LIMIT 1
2023-03-17 12:14:15.774748 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
2023-03-17 12:14:15.774748 91.20% [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("142.132.184.134") 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 "144" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
2023-03-17 12:14:15.774748 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 058762]
2023-03-17 12:14:15.774748 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =144
2023-03-17 12:14:15.774748 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "058762" AND deleted = 0 limit 1
2023-03-17 12:14:15.794765 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Ashish account call balance :SELECT * FROM accounts WHERE id =133
2023-03-17 12:14:15.794765 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0
2023-03-17 12:14:15.794765 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]1
2023-03-17 12:14:15.794765 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
2023-03-17 12:14:15.794765 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 133
2023-03-17 12:14:15.794765 91.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 = '^144.*' OR patterns = '^14.*' OR patterns = '^1.*' OR patterns ='--') AND accountid = 133 ORDER BY LENGTH(PKGPTR.patterns) DESC
2023-03-17 12:14:15.794765 91.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 ="144" AND A.accountid = '133' limit 1
2023-03-17 12:14:15.794765 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 144
2023-03-17 12:14:15.794765 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
2023-03-17 12:14:15.794765 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1
2023-03-17 12:14:15.794765 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID
2023-03-17 12:14:15.794765 91.20% [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, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="144" LIMIT 1
2023-03-17 12:14:15.794765 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_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,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="144" LIMIT 1
2023-03-17 12:14:15.794765 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-03-17 12:14:15.794765 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="133" and did_id ="16" and number ="990004" and status = '0' LIMIT 1
2023-03-17 12:14:15.794765 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
2023-03-17 12:14:15.794765 91.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 = '144' OR number = '14' OR number = '1' OR number ='--') OR (number = '144*' OR number = '14*' OR number = '1*' OR number ='--') OR (number = '990004' OR number = '99000' OR number = '9900' OR number = '990' OR number = '99' OR number = '9' OR number ='--') OR (number = '990004*' OR number = '99000*' OR number = '9900*' OR number = '990*' OR number = '99*' OR number = '9*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
2023-03-17 12:14:15.794765 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
2023-03-17 12:14:15.794765 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '144' OR routing_prefix = '14' OR routing_prefix = '1' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 133
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 058762
2023-03-17 12:14:15.814752 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Ashish account call balance :SELECT * FROM accounts WHERE id =133
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 21.85
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 1
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
2023-03-17 12:14:15.814752 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0
2023-03-17 12:14:15.814752 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::1
2023-03-17 12:14:15.814752 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
2023-03-17 12:14:15.814752 91.20% [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, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="144" LIMIT 1
2023-03-17 12:14:15.814752 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_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,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="144" LIMIT 1
2023-03-17 12:14:15.814752 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-03-17 12:14:15.814752 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="133" and did_id ="16" and number ="990004" and status = '0' LIMIT 1
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Direction : inbound
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.60000
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:1
2023-03-17 12:14:15.814752 91.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 = '1' and status=0
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.60000
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 16
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.60000
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 144
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 133
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
2023-03-17 12:14:15.814752 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Ashish account call balance :SELECT * FROM accounts WHERE id =133
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your21.85 balance Accountid 133 !!!
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE ID 133
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE RATE 0.60000
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE CONNECT COST 0.00000
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE INITIAL INC 0
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE INC 0
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 36.416666666667 minutes
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
2023-03-17 12:14:15.814752 91.20% [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 = 133 AND status=0 LIMIT 1
2023-03-17 12:14:15.814752 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "133" AND deleted = 0 limit 1
2023-03-17 12:14:15.814752 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Ashish account call balance :SELECT * FROM accounts WHERE id =133
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:133
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:133
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 133
2023-03-17 12:14:15.814752 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 133 limit 1
2023-03-17 12:14:15.814752 91.20% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : alpha4.astppbilling.org
2023-03-17 12:14:15.814752 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] Maxlength : 36.416666666667
2023-03-17 12:14:15.814752 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-03-17 12:14:15.834733 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
2023-03-17 12:14:15.834733 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound
2023-03-17 12:14:15.834733 91.20% [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 = "372397" AND accounts.status = 0
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 133 limit 1
2023-03-17 12:14:15.834733 91.20% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : alpha4.astppbilling.org
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 133 and status = 0 limit 1
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_0
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET MOH] Query :SELECT music_on_hold_type FROM sip_devices WHERE username = '372397' and accountid = '133'LIMIT 1
2023-03-17 12:14:15.834733 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] DESTINATION : 372397
2023-03-17 12:14:15.834733 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] moh_name : 0
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET MOH] Query :SELECT music_on_hold,music_on_hold_type FROM sip_devices WHERE username = '372397' and accountid = '133'LIMIT 1
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET MOH] Query :0
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET MOH] Query :0
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET MOH for global Query :SELECT name FROM pbx_music_on_hold WHERE id = '0' LIMIT 1
2023-03-17 12:14:15.834733 91.20% [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,sip_devices.codec as sip_codec 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="372397" AND domains.domain="alpha4.astppbilling.org" limit 1
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [PBX_SIP_ROUTING] [GET_ROUTING_INFO] Query :SELECT * from sip_device_routing WHERE sip_device_id = 171 limit 1
2023-03-17 12:14:15.834733 91.20% [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-03-17 12:14:15.834733 91.20% [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-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [NOTIFY] START:
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [NOTIFY] Query :SELECT apns_token,callkit_token,mobile_type FROM dialer_device_info WHERE username='372397'
2023-03-17 12:14:15.834733 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [SIP_CODEC10]
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [sip_codec_for_outbound] Query :SELECT sip_devices.codec as sip_codec 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="372397" AND domains.domain="alpha4.astppbilling.org" limit 1
2023-03-17 12:14:15.834733 91.20% [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,sip_devices.codec as sip_codec 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="372397" AND domains.domain="alpha4.astppbilling.org" limit 1
2023-03-17 12:14:15.834733 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX_SIP_ROUTING] SIP ID : 171
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [PBX_SIP_ROUTING] [GET_ROUTING_INFO] Query :SELECT * from sip_device_routing WHERE sip_device_id = 171 limit 1
2023-03-17 12:14:15.834733 91.20% [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-03-17 12:14:15.834733 91.20% [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-03-17 12:14:15.834733 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX_SIP_ROUTING] Call Forwarding Flag : 1
2023-03-17 12:14:15.834733 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX_SIP_ROUTING] SIP Call Forwarding Disable
2023-03-17 12:14:15.834733 91.20% [INFO] switch_cpp.cpp:1465 [ASTPP] [SIP_CODEC8]
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [sip_codec_for_outbound] Query :SELECT sip_devices.codec as sip_codec 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="372397" AND domains.domain="alpha4.astppbilling.org" limit 1
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [NOTIFY] START:
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [NOTIFY] Query :SELECT apns_token,callkit_token,mobile_type FROM dialer_device_info WHERE username='372397'
2023-03-17 12:14:15.834733 91.20% [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,sip_devices.codec as sip_codec 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="372397" AND domains.domain="alpha4.astppbilling.org" limit 1
2023-03-17 12:14:15.834733 91.20% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [PBX_SIP_ROUTING] [GET_ROUTING_INFO] Query :SELECT * from sip_device_routing WHERE sip_device_id = 171 limit 1
2023-03-17 12:14:15.834733 91.20% [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="144">
<condition field="destination_number" expression="144">
<action application="set" data="effective_destination_number=144"/>
<action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
<action application="set" data="bridge_pre_execute_bleg_data=+2185 normal_clearing"/>
<action application="set" data="type=0"/>
<action application="set" data="nibble_account=133"/>
<action application="set" data="nibble_rate=0.60000"/>
<action application="set" data="nibble_minimum=0.00000"/>
<action application="set" data="nibble_increment=5"/>
<action application="nibblebill" data="heartbeat 5"/>
<action application="set" data="callstart=2023-03-17 12:14:15"/>
<action application="set" data="hangup_after_bridge=true"/>
<action application="set" data="continue_on_fail=TRUE"/>
<action application="set" data="account_id=133"/>
<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=ASTPPQA"/>
<action application="set" data="filename1=astpp.pbx.lua"/>
<action application="set" data="origination_rates_did=ID:16|CODE:^144.*|DESTINATION:144|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:0|COST:0.60000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:133"/>
<action application="set" data="origination_rates=0"/>
<action application="set" data="original_caller_id_name=990004"/>
<action application="set" data="original_caller_id_number=990004"/>
<action application="set" data="effective_caller_id_name=990004"/>
<action application="set" data="effective_caller_id_number=990004"/>
<action application="set" data="receiver_accid=133"/>
<action application="set" data="did_id=16"/>
<action application="set" data="transfer_call_type=4"/>
<action application="set" data="transfer_extensions="/>
<action application="set" data="busy_status=1"/>
<action application="set" data="no_answer_status=1"/>
<action application="set" data="always_status=1"/>
<action application="set" data="transfer_status=1"/>
<action application="set" data="variable_sip_to_host=${domain_name}"/>
<action application="set" data="variable_sip_network_ip=142.132.184.134"/>
<action application="set" data="variable_sip_network_port=5076"/>
<action application="export" data="domain_name=alpha4.astppbilling.org"/>
<action application="export" data="sip_to_host=alpha4.astppbilling.org"/>
<action application="export" data="presence_data=x|||Niralidata(058762)|||||||||DID|||142.132.184.134"/>
<action application="export" data="call_type=0"/>
<action application="set" data="calltype=DID-LOCAL"/>
<action application="set" data="daily_call_credit_limit=500.00000"/>
<action application="set" data="monthly_call_credit_limit=700.00000"/>
<action application="set" data="daily_call_used_limit=8.15000"/>
<action application="set" data="monthly_call_used_limit=8.15000"/>
<action application="db" data="insert/pickup_any_group_${callgroup}/372397/${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=alpha4.astppbilling.org"/>
<action application="ring_ready"/>
<action application="sleep" data="5000"/>
<action application="db" data="insert/pickup_any_group_${callgroup}/372397/${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="bridge" data="{sip_invite_params=user=LOCAL,ignore_early_media=true,sip_h_P-call_type='custom_forward',sip_h_P-Accountcode=133}[leg_timeout=0 ] user/372397@alpha4.astppbilling.org"/>
<action application="ring_ready"/>
<action application="sleep" data="5000"/>
<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=alpha4.astppbilling.org"/>
<action application="set" data="opensips_domain=27.0.0."/>
<action application="set" data="leg_timeout=0"/>
<action application="set" data="userinfo_id=133"/>
<action application="set" data="sip_destination_number=372397"/>
<action application="set" data="did_number=372397"/>
<action application="set" data="user_domain=alpha4.astppbilling.org"/>
<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=alpha4.astppbilling.org"/>
<action application="set" data="opensips_domain=27.0.0."/>
<action application="set" data="leg_timeout=0"/>
<action application="set" data="userinfo_id=133"/>
<action application="set" data="sip_destination_number=372397"/>
<action application="set" data="destination_number=372397"/>
<action application="set" data="did_number=144"/>
<action application="set" data="user_domain=alpha4.astppbilling.org"/>
<action application="lua" data="astpp/lib/pbx/astpp-sipdevice-routing.lua"/>
<condition field="${cond(${user_data 372397@${domain_name} param vm-enabled} == true ? YES : NO)}" expression="^YES$">
<action application="answer"/>
<action application="export" data="voicemail_alternate_greet_id=372397"/>
<action application="voicemail" data="default $${domain_name} 372397"/>
<anti-action application="hangup" data="${originate_disposition}"/>
</condition>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/default/990004@142.132.184.134 parsing [default->144] continue=false
Dialplan: sofia/default/990004@142.132.184.134 Regex (PASS) [144] destination_number(144) =~ /144/ break=on-false
Dialplan: sofia/default/990004@142.132.184.134 Action set(effective_destination_number=144)
Dialplan: sofia/default/990004@142.132.184.134 Action set(bridge_pre_execute_bleg_app=sched_hangup)
Dialplan: sofia/default/990004@142.132.184.134 Action set(bridge_pre_execute_bleg_data=+2185 normal_clearing)
Dialplan: sofia/default/990004@142.132.184.134 Action set(type=0)
Dialplan: sofia/default/990004@142.132.184.134 Action set(nibble_account=133)
Dialplan: sofia/default/990004@142.132.184.134 Action set(nibble_rate=0.60000)
Dialplan: sofia/default/990004@142.132.184.134 Action set(nibble_minimum=0.00000)
Dialplan: sofia/default/990004@142.132.184.134 Action set(nibble_increment=5)
Dialplan: sofia/default/990004@142.132.184.134 Action nibblebill(heartbeat 5)
Dialplan: sofia/default/990004@142.132.184.134 Action set(callstart=2023-03-17 12:14:15)
Dialplan: sofia/default/990004@142.132.184.134 Action set(hangup_after_bridge=true)
Dialplan: sofia/default/990004@142.132.184.134 Action set(continue_on_fail=TRUE)
Dialplan: sofia/default/990004@142.132.184.134 Action set(account_id=133)
Dialplan: sofia/default/990004@142.132.184.134 Action set(parent_id=0)
Dialplan: sofia/default/990004@142.132.184.134 Action set(entity_id=0)
Dialplan: sofia/default/990004@142.132.184.134 Action set(call_processed=internal)
Dialplan: sofia/default/990004@142.132.184.134 Action set(call_direction=inbound)
Dialplan: sofia/default/990004@142.132.184.134 Action set(accountname=ASTPPQA)
Dialplan: sofia/default/990004@142.132.184.134 Action set(filename1=astpp.pbx.lua)
Dialplan: sofia/default/990004@142.132.184.134 Action set(origination_rates_did=ID:16|CODE:^144.*|DESTINATION:144|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:0|COST:0.60000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:133)
Dialplan: sofia/default/990004@142.132.184.134 Action set(origination_rates=0)
Dialplan: sofia/default/990004@142.132.184.134 Action set(original_caller_id_name=990004)
Dialplan: sofia/default/990004@142.132.184.134 Action set(original_caller_id_number=990004)
Dialplan: sofia/default/990004@142.132.184.134 Action set(effective_caller_id_name=990004)
Dialplan: sofia/default/990004@142.132.184.134 Action set(effective_caller_id_number=990004)
Dialplan: sofia/default/990004@142.132.184.134 Action set(receiver_accid=133)
Dialplan: sofia/default/990004@142.132.184.134 Action set(did_id=16)
Dialplan: sofia/default/990004@142.132.184.134 Action set(transfer_call_type=4)
Dialplan: sofia/default/990004@142.132.184.134 Action set(transfer_extensions=)
Dialplan: sofia/default/990004@142.132.184.134 Action set(busy_status=1)
Dialplan: sofia/default/990004@142.132.184.134 Action set(no_answer_status=1)
Dialplan: sofia/default/990004@142.132.184.134 Action set(always_status=1)
Dialplan: sofia/default/990004@142.132.184.134 Action set(transfer_status=1)
Dialplan: sofia/default/990004@142.132.184.134 Action set(variable_sip_to_host=${domain_name})
Dialplan: sofia/default/990004@142.132.184.134 Action set(variable_sip_network_ip=142.132.184.134)
Dialplan: sofia/default/990004@142.132.184.134 Action set(variable_sip_network_port=5076)
Dialplan: sofia/default/990004@142.132.184.134 Action export(domain_name=alpha4.astppbilling.org)
Dialplan: sofia/default/990004@142.132.184.134 Action export(sip_to_host=alpha4.astppbilling.org)
Dialplan: sofia/default/990004@142.132.184.134 Action export(presence_data=x|||Niralidata(058762)|||||||||DID|||142.132.184.134)
Dialplan: sofia/default/990004@142.132.184.134 Action export(call_type=0)
Dialplan: sofia/default/990004@142.132.184.134 Action set(calltype=DID-LOCAL)
Dialplan: sofia/default/990004@142.132.184.134 Action set(daily_call_credit_limit=500.00000)
Dialplan: sofia/default/990004@142.132.184.134 Action set(monthly_call_credit_limit=700.00000)
Dialplan: sofia/default/990004@142.132.184.134 Action set(daily_call_used_limit=8.15000)
Dialplan: sofia/default/990004@142.132.184.134 Action set(monthly_call_used_limit=8.15000)
Dialplan: sofia/default/990004@142.132.184.134 Action db(insert/pickup_any_group_${callgroup}/372397/${uuid})
Dialplan: sofia/default/990004@142.132.184.134 Action set(dialed_extension=transfer_call)
Dialplan: sofia/default/990004@142.132.184.134 Action export(dialed_extension=transfer_call)
Dialplan: sofia/default/990004@142.132.184.134 Action bind_meta_app(3 b s execute_extension::transfer_call_3 XML default)
Dialplan: sofia/default/990004@142.132.184.134 Action bind_meta_app(2 b s execute_extension::transfer_call_2 XML default)
Dialplan: sofia/default/990004@142.132.184.134 Action set(hangup_after_bridge=true)
Dialplan: sofia/default/990004@142.132.184.134 Action export(did_user_domain=alpha4.astppbilling.org)
Dialplan: sofia/default/990004@142.132.184.134 Action ring_ready()
Dialplan: sofia/default/990004@142.132.184.134 Action sleep(5000)
Dialplan: sofia/default/990004@142.132.184.134 Action db(insert/pickup_any_group_${callgroup}/372397/${uuid})
Dialplan: sofia/default/990004@142.132.184.134 Action set(dialed_extension=transfer_call)
Dialplan: sofia/default/990004@142.132.184.134 Action export(dialed_extension=transfer_call)
Dialplan: sofia/default/990004@142.132.184.134 Action bind_meta_app(3 b s execute_extension::transfer_call_3 XML default)
Dialplan: sofia/default/990004@142.132.184.134 Action bind_meta_app(2 b s execute_extension::transfer_call_2 XML default)
Dialplan: sofia/default/990004@142.132.184.134 Action set(hangup_after_bridge=true)
Dialplan: sofia/default/990004@142.132.184.134 Action bridge({sip_invite_params=user=LOCAL,ignore_early_media=true,sip_h_P-call_type='custom_forward',sip_h_P-Accountcode=133}[leg_timeout=0 ] user/372397@alpha4.astppbilling.org)
Dialplan: sofia/default/990004@142.132.184.134 Action ring_ready()
Dialplan: sofia/default/990004@142.132.184.134 Action sleep(5000)
Dialplan: sofia/default/990004@142.132.184.134 Action set(on_busy_flag=1)
Dialplan: sofia/default/990004@142.132.184.134 Action set(on_busy_destination=)
Dialplan: sofia/default/990004@142.132.184.134 Action set(no_answer_flag=1)
Dialplan: sofia/default/990004@142.132.184.134 Action set(no_answer_destination=)
Dialplan: sofia/default/990004@142.132.184.134 Action set(not_register_flag=1)
Dialplan: sofia/default/990004@142.132.184.134 Action set(not_register_destination=)
Dialplan: sofia/default/990004@142.132.184.134 Action set(opensips_flag=1)
Dialplan: sofia/default/990004@142.132.184.134 Action set(variable_sip_to_host=alpha4.astppbilling.org)
Dialplan: sofia/default/990004@142.132.184.134 Action set(opensips_domain=27.0.0.)
Dialplan: sofia/default/990004@142.132.184.134 Action set(leg_timeout=0)
Dialplan: sofia/default/990004@142.132.184.134 Action set(userinfo_id=133)
Dialplan: sofia/default/990004@142.132.184.134 Action set(sip_destination_number=372397)
Dialplan: sofia/default/990004@142.132.184.134 Action set(did_number=372397)
Dialplan: sofia/default/990004@142.132.184.134 Action set(user_domain=alpha4.astppbilling.org)
Dialplan: sofia/default/990004@142.132.184.134 Action lua(astpp/lib/pbx/astpp-sipdevice-routing.lua)
Dialplan: sofia/default/990004@142.132.184.134 Action set(on_busy_flag=1)
Dialplan: sofia/default/990004@142.132.184.134 Action set(on_busy_destination=)
Dialplan: sofia/default/990004@142.132.184.134 Action set(no_answer_flag=1)
Dialplan: sofia/default/990004@142.132.184.134 Action set(no_answer_destination=)
Dialplan: sofia/default/990004@142.132.184.134 Action set(not_register_flag=1)
Dialplan: sofia/default/990004@142.132.184.134 Action set(not_register_destination=)
Dialplan: sofia/default/990004@142.132.184.134 Action set(opensips_flag=1)
Dialplan: sofia/default/990004@142.132.184.134 Action set(variable_sip_to_host=alpha4.astppbilling.org)
Dialplan: sofia/default/990004@142.132.184.134 Action set(opensips_domain=27.0.0.)
Dialplan: sofia/default/990004@142.132.184.134 Action set(leg_timeout=0)
Dialplan: sofia/default/990004@142.132.184.134 Action set(userinfo_id=133)
Dialplan: sofia/default/990004@142.132.184.134 Action set(sip_destination_number=372397)
Dialplan: sofia/default/990004@142.132.184.134 Action set(destination_number=372397)
Dialplan: sofia/default/990004@142.132.184.134 Action set(did_number=144)
Dialplan: sofia/default/990004@142.132.184.134 Action set(user_domain=alpha4.astppbilling.org)
Dialplan: sofia/default/990004@142.132.184.134 Action lua(astpp/lib/pbx/astpp-sipdevice-routing.lua)
|--- Dialplan: Processing recursive conditions level:1 [144_recur_1] require-nested=TRUE
|--- Dialplan: sofia/default/990004@142.132.184.134 Regex (FAIL) [144_recur_1] ${cond(${user_data 372397@${domain_name} param vm-enabled} == true ? YES : NO)}(-ERR) =~ /^YES$/ break=on-false
|--- Dialplan: sofia/default/990004@142.132.184.134 ANTI-Action hangup(${originate_disposition})
2023-03-17 12:14:15.854736 91.20% [DEBUG] switch_core_state_machine.c:281 (sofia/default/990004@142.132.184.134) State Change CS_ROUTING -> CS_EXECUTE
2023-03-17 12:14:15.854736 91.20% [DEBUG] switch_core_state_machine.c:640 (sofia/default/990004@142.132.184.134) State ROUTING going to sleep
2023-03-17 12:14:15.854736 91.20% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990004@142.132.184.134) Running State Change CS_EXECUTE (Cur 1 Tot 41)
2023-03-17 12:14:15.854736 91.20% [DEBUG] switch_core_state_machine.c:647 (sofia/default/990004@142.132.184.134) State EXECUTE
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_sofia.c:213 sofia/default/990004@142.132.184.134 SOFIA EXECUTE
2023-03-17 12:14:15.854736 91.20% [DEBUG] switch_core_state_machine.c:323 sofia/default/990004@142.132.184.134 Standard EXECUTE
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(effective_destination_number=144)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [effective_destination_number]=[144]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(bridge_pre_execute_bleg_app=sched_hangup)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [bridge_pre_execute_bleg_app]=[sched_hangup]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(bridge_pre_execute_bleg_data=+2185 normal_clearing)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [bridge_pre_execute_bleg_data]=[+2185 normal_clearing]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(type=0)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [type]=[0]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(nibble_account=133)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [nibble_account]=[133]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(nibble_rate=0.60000)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [nibble_rate]=[0.60000]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(nibble_minimum=0.00000)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [nibble_minimum]=[0.00000]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(nibble_increment=5)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [nibble_increment]=[5]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 nibblebill(heartbeat 5)
2023-03-17 12:14:15.854736 91.20% [WARNING] switch_core_session.c:1693 sofia/default/990004@142.132.184.134 using scheduler due to bypass media or media is not established.
2023-03-17 12:14:15.854736 91.20% [DEBUG] switch_scheduler.c:263 Added task 28 switch_core_session_sched_heartbeat (03d333e6-a67f-494f-8cb1-29db0959dc23) to run at 1679055260
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(callstart=2023-03-17 12:14:15)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [callstart]=[2023-03-17 12:14:15]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(hangup_after_bridge=true)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [hangup_after_bridge]=[true]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(continue_on_fail=TRUE)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [continue_on_fail]=[TRUE]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(account_id=133)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [account_id]=[133]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(parent_id=0)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [parent_id]=[0]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(entity_id=0)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [entity_id]=[0]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(call_processed=internal)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [call_processed]=[internal]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(call_direction=inbound)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [call_direction]=[inbound]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(accountname=ASTPPQA)
2023-03-17 12:14:15.854736 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [accountname]=[ASTPPQA]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(filename1=astpp.pbx.lua)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [filename1]=[astpp.pbx.lua]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(origination_rates_did=ID:16|CODE:^144.*|DESTINATION:144|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:0|COST:0.60000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:133)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [origination_rates_did]=[ID:16|CODE:^144.*|DESTINATION:144|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:0|COST:0.60000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:133]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(origination_rates=0)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [origination_rates]=[0]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(original_caller_id_name=990004)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [original_caller_id_name]=[990004]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(original_caller_id_number=990004)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [original_caller_id_number]=[990004]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(effective_caller_id_name=990004)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [effective_caller_id_name]=[990004]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(effective_caller_id_number=990004)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [effective_caller_id_number]=[990004]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(receiver_accid=133)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [receiver_accid]=[133]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(did_id=16)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [did_id]=[16]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(transfer_call_type=4)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [transfer_call_type]=[4]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(transfer_extensions=)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [transfer_extensions]=[UNDEF]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(busy_status=1)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [busy_status]=[1]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(no_answer_status=1)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [no_answer_status]=[1]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(always_status=1)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [always_status]=[1]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(transfer_status=1)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [transfer_status]=[1]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(variable_sip_to_host=95.217.238.195)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [variable_sip_to_host]=[95.217.238.195]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(variable_sip_network_ip=142.132.184.134)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [variable_sip_network_ip]=[142.132.184.134]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(variable_sip_network_port=5076)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [variable_sip_network_port]=[5076]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 export(domain_name=alpha4.astppbilling.org)
2023-03-17 12:14:15.874738 91.20% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [domain_name]=[alpha4.astppbilling.org]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 export(sip_to_host=alpha4.astppbilling.org)
2023-03-17 12:14:15.874738 91.20% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [sip_to_host]=[alpha4.astppbilling.org]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 export(presence_data=x|||Niralidata(058762)|||||||||DID|||142.132.184.134)
2023-03-17 12:14:15.874738 91.20% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[x|||Niralidata(058762)|||||||||DID|||142.132.184.134]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 export(call_type=0)
2023-03-17 12:14:15.874738 91.20% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [call_type]=[0]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(calltype=DID-LOCAL)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [calltype]=[DID-LOCAL]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(daily_call_credit_limit=500.00000)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [daily_call_credit_limit]=[500.00000]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(monthly_call_credit_limit=700.00000)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [monthly_call_credit_limit]=[700.00000]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(daily_call_used_limit=8.15000)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [daily_call_used_limit]=[8.15000]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(monthly_call_used_limit=8.15000)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [monthly_call_used_limit]=[8.15000]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 db(insert/pickup_any_group_/372397/03d333e6-a67f-494f-8cb1-29db0959dc23)
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(dialed_extension=transfer_call)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [dialed_extension]=[transfer_call]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 export(dialed_extension=transfer_call)
2023-03-17 12:14:15.874738 91.20% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [dialed_extension]=[transfer_call]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 bind_meta_app(3 b s execute_extension::transfer_call_3 XML default)
2023-03-17 12:14:15.874738 91.20% [INFO] switch_ivr_async.c:4774 Bound B-Leg: *3 execute_extension::transfer_call_3 XML default
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 bind_meta_app(2 b s execute_extension::transfer_call_2 XML default)
2023-03-17 12:14:15.874738 91.20% [INFO] switch_ivr_async.c:4774 Bound B-Leg: *2 execute_extension::transfer_call_2 XML default
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 set(hangup_after_bridge=true)
2023-03-17 12:14:15.874738 91.20% [DEBUG] mod_dptools.c:1685 SET sofia/default/990004@142.132.184.134 [hangup_after_bridge]=[true]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 export(did_user_domain=alpha4.astppbilling.org)
2023-03-17 12:14:15.874738 91.20% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [did_user_domain]=[alpha4.astppbilling.org]
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 ring_ready()
2023-03-17 12:14:15.874738 91.20% [NOTICE] mod_sofia.c:2515 Ring-Ready sofia/default/990004@142.132.184.134!
2023-03-17 12:14:15.874738 91.20% [DEBUG] sofia.c:7499 Channel sofia/default/990004@142.132.184.134 entering state [early][180]
2023-03-17 12:14:15.874738 91.20% [NOTICE] mod_dptools.c:1122 Ring Ready sofia/default/990004@142.132.184.134!
EXECUTE [depth=0] sofia/default/990004@142.132.184.134 sleep(5000)
2023-03-17 12:14:20.354736 91.07% [DEBUG] mod_nibblebill.c:695 Received request via SESSION_HEARTBEAT!
2023-03-17 12:14:20.354736 91.07% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.60000 per minute to account 133
2023-03-17 12:14:20.354736 91.07% [DEBUG] mod_nibblebill.c:518 Not billing 133 - call is not in answered state
2023-03-17 12:14:20.354736 91.07% [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=,credit_limit+(balance*-),balance) AS nibble_balance FROM accounts WHERE id='133']
2023-03-17 12:14:20.374730 91.07% [ERR] switch_core_sqldb.c:1310 ERR: [SELECT if(posttoexternal=,credit_limit+(balance*-),balance) AS nibble_balance FROM accounts WHERE id='133']
[STATE: 42000 CODE 1064 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.32]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',credit_limit+(balance*-),balance) AS nibble_balance FROM accounts WHERE id='133' at line 1
]
2023-03-17 12:14:20.374730 91.07% [ERR] mod_nibblebill.c:424 Error running this query: [SELECT if(posttoexternal=,credit_limit+(balance*-),balance) AS nibble_balance FROM accounts WHERE id='133']
2023-03-17 12:14:20.374730 91.07% [DEBUG] mod_nibblebill.c:523 Comparing -1.000000 to hangup balance of 0.000000, taking into account minimum charge of 0.000000
2023-03-17 12:14:20.374730 91.07% [DEBUG] mod_nibblebill.c:526 Balance of -1.000000 fell below allowed amount of 0.000000! (Account 133)
2023-03-17 12:14:20.374730 91.07% [INFO] mod_dialplan_xml.c:639 Processing 990004 <990004>->hangup in context default
2023-03-17 12:14:20.374730 91.07% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
2023-03-17 12:14:20.374730 91.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2023-03-17 12:14:20.374730 91.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2023-03-17 12:14:20.374730 91.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-03-17 12:14:20.394752 91.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated XML:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<document type="freeswitch/xml">
<section name="dialplan" description="ASTPP Dialplan">
<context name="default">
<extension name="hangup">
<condition field="destination_number" expression="hangup">
<action application="log" data="INFO REALTIME BILLING - Account out of credit!!"/>
<action application="hangup"/>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/default/990004@142.132.184.134 parsing [default->hangup] continue=false
Dialplan: sofia/default/990004@142.132.184.134 Regex (PASS) [hangup] destination_number(hangup) =~ /hangup/ break=on-false
Dialplan: sofia/default/990004@142.132.184.134 Action log(INFO REALTIME BILLING - Account out of credit!!)
Dialplan: sofia/default/990004@142.132.184.134 Action hangup()
2023-03-17 12:14:20.394752 91.07% [NOTICE] switch_core_session.c:3095 Execute [depth=1] log(INFO REALTIME BILLING - Account out of credit!!)
EXECUTE [depth=1] sofia/default/990004@142.132.184.134 log(INFO REALTIME BILLING - Account out of credit!!)
2023-03-17 12:14:20.394752 91.07% [INFO] mod_dptools.c:1879 REALTIME BILLING - Account out of credit!!
2023-03-17 12:14:20.394752 91.07% [NOTICE] switch_core_session.c:3095 Execute [depth=1] hangup()
EXECUTE [depth=1] sofia/default/990004@142.132.184.134 hangup()
2023-03-17 12:14:20.394752 91.07% [NOTICE] mod_dptools.c:1387 Hangup sofia/default/990004@142.132.184.134 [CS_EXECUTE] [NORMAL_CLEARING]
2023-03-17 12:14:20.394752 91.07% [DEBUG] switch_core_session.c:2983 sofia/default/990004@142.132.184.134 skip receive message [PHONE_EVENT] (channel is hungup already)
2023-03-17 12:14:20.394752 91.07% [WARNING] sofia_reg.c:1861 SIP auth challenge (REGISTER) on sofia profile 'default' for [086860@alpha3.astppbilling.org] from ip 103.240.35.46
2023-03-17 12:14:20.394752 91.07% [DEBUG] switch_core_session.c:2983 sofia/default/990004@142.132.184.134 skip receive message [PHONE_EVENT] (channel is hungup already)
2023-03-17 12:14:20.394752 91.07% [DEBUG] switch_core_state_machine.c:647 (sofia/default/990004@142.132.184.134) State EXECUTE going to sleep
2023-03-17 12:14:20.394752 91.07% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990004@142.132.184.134) Running State Change CS_HANGUP (Cur 1 Tot 41)
2023-03-17 12:14:20.394752 91.07% [DEBUG] switch_core_state_machine.c:844 (sofia/default/990004@142.132.184.134) Callstate Change RINGING -> HANGUP
2023-03-17 12:14:20.394752 91.07% [DEBUG] switch_core_state_machine.c:846 (sofia/default/990004@142.132.184.134) State HANGUP
2023-03-17 12:14:20.394752 91.07% [DEBUG] mod_sofia.c:468 Channel sofia/default/990004@142.132.184.134 hanging up, cause: NORMAL_CLEARING
2023-03-17 12:14:20.394752 91.07% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 480
2023-03-17 12:14:20.394752 91.07% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.60000 per minute to account 133
2023-03-17 12:14:20.394752 91.07% [DEBUG] mod_nibblebill.c:518 Not billing 133 - call is not in answered state
2023-03-17 12:14:20.394752 91.07% [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=,credit_limit+(balance*-),balance) AS nibble_balance FROM accounts WHERE id='133']
2023-03-17 12:14:20.394752 91.07% [ERR] switch_core_sqldb.c:1310 ERR: [SELECT if(posttoexternal=,credit_limit+(balance*-),balance) AS nibble_balance FROM accounts WHERE id='133']
[STATE: 42000 CODE 1064 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.32]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',credit_limit+(balance*-),balance) AS nibble_balance FROM accounts WHERE id='133' at line 1
]
2023-03-17 12:14:20.394752 91.07% [ERR] mod_nibblebill.c:424 Error running this query: [SELECT if(posttoexternal=,credit_limit+(balance*-),balance) AS nibble_balance FROM accounts WHERE id='133']
2023-03-17 12:14:20.394752 91.07% [DEBUG] mod_nibblebill.c:523 Comparing -1.000000 to hangup balance of 0.000000, taking into account minimum charge of 0.000000
2023-03-17 12:14:20.394752 91.07% [DEBUG] mod_nibblebill.c:526 Balance of -1.000000 fell below allowed amount of 0.000000! (Account 133)
2023-03-17 12:14:20.394752 91.07% [INFO] mod_dialplan_xml.c:639 Processing 990004 <990004>->hangup in context default
2023-03-17 12:14:20.414777 91.07% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
2023-03-17 12:14:20.414777 91.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2023-03-17 12:14:20.414777 91.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2023-03-17 12:14:20.414777 91.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-03-17 12:14:20.414777 91.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated XML:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<document type="freeswitch/xml">
<section name="dialplan" description="ASTPP Dialplan">
<context name="default">
<extension name="hangup">
<condition field="destination_number" expression="hangup">
<action application="log" data="INFO REALTIME BILLING - Account out of credit!!"/>
<action application="hangup"/>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/default/990004@142.132.184.134 parsing [default->hangup] continue=false
Dialplan: sofia/default/990004@142.132.184.134 Regex (PASS) [hangup] destination_number(hangup) =~ /hangup/ break=on-false
Dialplan: sofia/default/990004@142.132.184.134 Action log(INFO REALTIME BILLING - Account out of credit!!)
Dialplan: sofia/default/990004@142.132.184.134 Action hangup()
2023-03-17 12:14:20.414777 91.07% [DEBUG] mod_nibblebill.c:422 Doing lookup query
[SELECT if(posttoexternal=,credit_limit+(balance*-),balance) AS nibble_balance FROM accounts WHERE id='133']
2023-03-17 12:14:20.414777 91.07% [ERR] switch_core_sqldb.c:1310 ERR: [SELECT if(posttoexternal=,credit_limit+(balance*-),balance) AS nibble_balance FROM accounts WHERE id='133']
[STATE: 42000 CODE 1064 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.32]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',credit_limit+(balance*-),balance) AS nibble_balance FROM accounts WHERE id='133' at line 1
]
2023-03-17 12:14:20.414777 91.07% [ERR] mod_nibblebill.c:424 Error running this query: [SELECT if(posttoexternal=,credit_limit+(balance*-),balance) AS nibble_balance FROM accounts WHERE id='133']
2023-03-17 12:14:20.414777 91.07% [DEBUG] switch_core_state_machine.c:59 sofia/default/990004@142.132.184.134 Standard HANGUP, cause: NORMAL_CLEARING
2023-03-17 12:14:20.414777 91.07% [DEBUG] switch_core_state_machine.c:846 (sofia/default/990004@142.132.184.134) State HANGUP going to sleep
2023-03-17 12:14:20.414777 91.07% [DEBUG] switch_core_state_machine.c:616 (sofia/default/990004@142.132.184.134) State Change CS_HANGUP -> CS_REPORTING
2023-03-17 12:14:20.414777 91.07% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990004@142.132.184.134) Running State Change CS_REPORTING (Cur 1 Tot 41)
2023-03-17 12:14:20.414777 91.07% [DEBUG] switch_core_state_machine.c:932 (sofia/default/990004@142.132.184.134) State REPORTING
2023-03-17 12:14:20.414777 91.07% [INFO] mod_json_cdr.c:271 Process [03d333e6-a67f-494f-8cb1-29db0959dc23.cdr.json]
2023-03-17 12:14:20.474743 91.07% [DEBUG] switch_core_state_machine.c:168 sofia/default/990004@142.132.184.134 Standard REPORTING, cause: NORMAL_CLEARING
2023-03-17 12:14:20.474743 91.07% [DEBUG] switch_core_state_machine.c:932 (sofia/default/990004@142.132.184.134) State REPORTING going to sleep
2023-03-17 12:14:20.474743 91.07% [DEBUG] switch_core_state_machine.c:607 (sofia/default/990004@142.132.184.134) State Change CS_REPORTING -> CS_DESTROY
2023-03-17 12:14:20.474743 91.07% [DEBUG] switch_core_session.c:1753 Session 41 (sofia/default/990004@142.132.184.134) Locked, Waiting on external entities
2023-03-17 12:14:20.474743 91.07% [NOTICE] switch_core_session.c:1771 Session 41 (sofia/default/990004@142.132.184.134) Ended
2023-03-17 12:14:20.474743 91.07% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/990004@142.132.184.134 [CS_DESTROY]
2023-03-17 12:14:20.474743 91.07% [DEBUG] switch_core_state_machine.c:735 (sofia/default/990004@142.132.184.134) Running State Change CS_DESTROY (Cur 0 Tot 41)
2023-03-17 12:14:20.474743 91.07% [DEBUG] switch_core_state_machine.c:745 (sofia/default/990004@142.132.184.134) State DESTROY
2023-03-17 12:14:20.474743 91.07% [DEBUG] mod_sofia.c:379 sofia/default/990004@142.132.184.134 SOFIA DESTROY
2023-03-17 12:14:20.474743 91.07% [DEBUG] switch_core_state_machine.c:175 sofia/default/990004@142.132.184.134 Standard DESTROY
2023-03-17 12:14:20.474743 91.07% [DEBUG] switch_core_state_machine.c:745 (sofia/default/990004@142.132.184.134) State DESTROY going to sleep
2023-03-17 12:14:20.854750 90.93% [DEBUG] switch_scheduler.c:147 Deleting task 28 switch_core_session_sched_heartbeat (03d333e6-a67f-494f-8cb1-29db0959dc23)
2023-03-17 12:14:21.034760 90.93% [WARNING] sofia_reg.c:3223 Can't find user [086860@alpha3.astppbilling.org] from 103.240.35.46
You must define a domain called 'alpha3.astppbilling.org' in your directory and add a user with the id="086860" attribute
and you must configure your device to use the proper domain in its authentication credentials.