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:
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:
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:
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.