2021-01-13 08:04:35.021082 [NOTICE] switch_channel.c:1118 New Channel sofia/default/00000111323524114@13.235.24.114 [47f64e9c-f879-4dd8-bb70-9528e1d4edbc] 2021-01-13 08:04:35.021082 [DEBUG] switch_core_state_machine.c:585 (sofia/default/00000111323524114@13.235.24.114) Running State Change CS_NEW (Cur 1 Tot 404) 2021-01-13 08:04:35.041090 [DEBUG] sofia.c:10280 sofia/default/00000111323524114@13.235.24.114 receiving invite from 143.244.57.86:55826 version: 1.10.5 -release-17-25569c1631 64bit 2021-01-13 08:04:35.041090 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 143.244.57.86:0. 2021-01-13 08:04:35.041090 [DEBUG] sofia.c:2434 detaching session 47f64e9c-f879-4dd8-bb70-9528e1d4edbc 2021-01-13 08:04:35.041090 [WARNING] sofia_reg.c:1794 SIP auth challenge (INVITE) on sofia profile 'default' for [0000011972595725668@13.235.24.114] from ip 143.244.57.86 2021-01-13 08:04:35.041090 [DEBUG] switch_core_state_machine.c:604 (sofia/default/00000111323524114@13.235.24.114) State NEW 2021-01-13 08:04:45.101075 [WARNING] switch_core_state_machine.c:688 47f64e9c-f879-4dd8-bb70-9528e1d4edbc sofia/default/00000111323524114@13.235.24.114 Abandoned 2021-01-13 08:04:45.101075 [NOTICE] switch_core_state_machine.c:691 Hangup sofia/default/00000111323524114@13.235.24.114 [CS_NEW] [WRONG_CALL_STATE] 2021-01-13 08:04:45.101075 [DEBUG] switch_core_state_machine.c:585 (sofia/default/00000111323524114@13.235.24.114) Running State Change CS_HANGUP (Cur 1 Tot 404) 2021-01-13 08:04:45.101075 [DEBUG] switch_core_state_machine.c:848 (sofia/default/00000111323524114@13.235.24.114) Callstate Change DOWN -> HANGUP 2021-01-13 08:04:45.101075 [DEBUG] switch_core_state_machine.c:850 (sofia/default/00000111323524114@13.235.24.114) State HANGUP 2021-01-13 08:04:45.101075 [DEBUG] mod_sofia.c:453 Channel sofia/default/00000111323524114@13.235.24.114 hanging up, cause: WRONG_CALL_STATE 2021-01-13 08:04:45.101075 [DEBUG] switch_core_state_machine.c:60 sofia/default/00000111323524114@13.235.24.114 Standard HANGUP, cause: WRONG_CALL_STATE 2021-01-13 08:04:45.101075 [DEBUG] switch_core_state_machine.c:850 (sofia/default/00000111323524114@13.235.24.114) State HANGUP going to sleep 2021-01-13 08:04:45.101075 [DEBUG] switch_core_state_machine.c:620 (sofia/default/00000111323524114@13.235.24.114) State Change CS_HANGUP -> CS_REPORTING 2021-01-13 08:04:45.101075 [DEBUG] switch_core_state_machine.c:585 (sofia/default/00000111323524114@13.235.24.114) Running State Change CS_REPORTING (Cur 1 Tot 404) 2021-01-13 08:04:45.101075 [DEBUG] switch_core_state_machine.c:936 (sofia/default/00000111323524114@13.235.24.114) State REPORTING 2021-01-13 08:04:45.101075 [DEBUG] switch_core_state_machine.c:174 sofia/default/00000111323524114@13.235.24.114 Standard REPORTING, cause: WRONG_CALL_STATE 2021-01-13 08:04:45.101075 [DEBUG] switch_core_state_machine.c:936 (sofia/default/00000111323524114@13.235.24.114) State REPORTING going to sleep 2021-01-13 08:04:45.101075 [DEBUG] switch_core_state_machine.c:611 (sofia/default/00000111323524114@13.235.24.114) State Change CS_REPORTING -> CS_DESTROY 2021-01-13 08:04:45.101075 [DEBUG] switch_core_session.c:1726 Session 404 (sofia/default/00000111323524114@13.235.24.114) Locked, Waiting on external entities 2021-01-13 08:04:45.101075 [NOTICE] switch_core_session.c:1744 Session 404 (sofia/default/00000111323524114@13.235.24.114) Ended 2021-01-13 08:04:45.101075 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/00000111323524114@13.235.24.114 [CS_DESTROY] 2021-01-13 08:04:45.101075 [DEBUG] switch_core_state_machine.c:739 (sofia/default/00000111323524114@13.235.24.114) Running State Change CS_DESTROY (Cur 0 Tot 404) 2021-01-13 08:04:45.101075 [DEBUG] switch_core_state_machine.c:749 (sofia/default/00000111323524114@13.235.24.114) State DESTROY 2021-01-13 08:04:45.101075 [DEBUG] mod_sofia.c:364 sofia/default/00000111323524114@13.235.24.114 SOFIA DESTROY 2021-01-13 08:04:45.101075 [DEBUG] switch_core_state_machine.c:181 sofia/default/00000111323524114@13.235.24.114 Standard DESTROY 2021-01-13 08:04:45.101075 [DEBUG] switch_core_state_machine.c:749 (sofia/default/00000111323524114@13.235.24.114) State DESTROY going to sleep 2021-01-13 08:04:58.881076 [WARNING] sofia_reg.c:1794 SIP auth challenge (REGISTER) on sofia profile 'default' for [91212223@mobile.crestdial.com] from ip 49.34.57.10 2021-01-13 08:05:46.461128 [WARNING] sofia_reg.c:1794 SIP auth challenge (REGISTER) on sofia profile 'default' for [91212223@mobile.crestdial.com] from ip 49.34.57.10 2021-01-13 08:05:48.461105 [WARNING] sofia_reg.c:1794 SIP auth challenge (REGISTER) on sofia profile 'default' for [9161626364@mobile.crestdial.com] from ip 42.106.26.11 2021-01-13 08:05:48.521103 [WARNING] sofia_reg.c:1794 SIP auth challenge (REGISTER) on sofia profile 'default' for [9161626364@mobile.crestdial.com] from ip 42.106.26.11 2021-01-13 08:05:55.861099 [WARNING] sofia_reg.c:1794 SIP auth challenge (REGISTER) on sofia profile 'default' for [9161626364@mobile.crestdial.com] from ip 185.117.83.202 2021-01-13 08:05:57.081083 [WARNING] sofia_reg.c:1794 SIP auth challenge (REGISTER) on sofia profile 'default' for [9161626364@mobile.crestdial.com] from ip 185.117.83.202 2021-01-13 08:07:14.461083 [NOTICE] switch_channel.c:1118 New Channel sofia/default/9161626364@mobile.crestdial.com [e5ffc9c8-e256-49d7-8b01-73819486dc81] 2021-01-13 08:07:14.461083 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_NEW (Cur 1 Tot 405) 2021-01-13 08:07:14.461083 [DEBUG] sofia.c:10280 sofia/default/9161626364@mobile.crestdial.com receiving invite from 185.117.83.202:25080 version: 1.10.5 -release-17-25569c1631 64bit 2021-01-13 08:07:14.461083 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 185.117.83.202:0. 2021-01-13 08:07:14.461083 [DEBUG] sofia.c:2434 detaching session e5ffc9c8-e256-49d7-8b01-73819486dc81 2021-01-13 08:07:14.461083 [WARNING] sofia_reg.c:1794 SIP auth challenge (INVITE) on sofia profile 'default' for [91212223@mobile.crestdial.com] from ip 185.117.83.202 2021-01-13 08:07:14.461083 [DEBUG] switch_core_state_machine.c:604 (sofia/default/9161626364@mobile.crestdial.com) State NEW 2021-01-13 08:07:15.081085 [DEBUG] sofia.c:2544 Re-attaching to session e5ffc9c8-e256-49d7-8b01-73819486dc81 2021-01-13 08:07:15.101080 [DEBUG] sofia.c:10280 sofia/default/9161626364@mobile.crestdial.com receiving invite from 185.117.83.202:25080 version: 1.10.5 -release-17-25569c1631 64bit 2021-01-13 08:07:15.101080 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 185.117.83.202:0. 2021-01-13 08:07:15.121081 [DEBUG] sofia.c:7326 Channel sofia/default/9161626364@mobile.crestdial.com entering state [received][100] 2021-01-13 08:07:15.121081 [DEBUG] sofia.c:7336 Remote SDP: v=0 o=Zoiper 1610525233374 1 IN IP4 42.106.26.11 s=Z c=IN IP4 42.106.26.11 t=0 0 m=audio 15738 RTP/AVP 106 9 98 101 0 8 18 3 a=rtpmap:106 opus/48000/2 a=fmtp:106 sprop-maxcapturerate=16000; minptime=20; useinbandfec=1 a=rtpmap:98 telephone-event/48000 a=fmtp:98 0-16 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5510 Set telephone-event payload to 98@48000 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:3839 Set Codec sofia/default/9161626364@mobile.crestdial.com PCMU/8000 20 ms 160 samples 64000 bits 1 channels 2021-01-13 08:07:15.121081 [DEBUG] switch_core_codec.c:111 sofia/default/9161626364@mobile.crestdial.com Original read codec set to PCMU:0 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5853 Set telephone-event payload to 101@8000 2021-01-13 08:07:15.121081 [DEBUG] switch_core_media.c:5911 sofia/default/9161626364@mobile.crestdial.com Set 2833 dtmf send payload to 101 recv payload to 101 2021-01-13 08:07:15.121081 [DEBUG] sofia.c:7760 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_NEW -> CS_INIT 2021-01-13 08:07:15.121081 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_INIT (Cur 1 Tot 405) 2021-01-13 08:07:15.121081 [DEBUG] switch_core_state_machine.c:628 (sofia/default/9161626364@mobile.crestdial.com) State INIT 2021-01-13 08:07:15.121081 [DEBUG] mod_sofia.c:93 sofia/default/9161626364@mobile.crestdial.com SOFIA INIT 2021-01-13 08:07:15.121081 [DEBUG] switch_core_state_machine.c:40 sofia/default/9161626364@mobile.crestdial.com Standard INIT 2021-01-13 08:07:15.121081 [DEBUG] switch_core_state_machine.c:48 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_INIT -> CS_ROUTING 2021-01-13 08:07:15.121081 [DEBUG] switch_core_state_machine.c:628 (sofia/default/9161626364@mobile.crestdial.com) State INIT going to sleep 2021-01-13 08:07:15.121081 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_ROUTING (Cur 1 Tot 405) 2021-01-13 08:07:15.121081 [DEBUG] switch_channel.c:2332 (sofia/default/9161626364@mobile.crestdial.com) Callstate Change DOWN -> RINGING 2021-01-13 08:07:15.121081 [DEBUG] switch_core_state_machine.c:644 (sofia/default/9161626364@mobile.crestdial.com) State ROUTING 2021-01-13 08:07:15.121081 [DEBUG] mod_sofia.c:154 sofia/default/9161626364@mobile.crestdial.com SOFIA ROUTING 2021-01-13 08:07:15.121081 [DEBUG] switch_core_state_machine.c:236 sofia/default/9161626364@mobile.crestdial.com Standard ROUTING 2021-01-13 08:07:15.121081 [INFO] mod_dialplan_xml.c:637 Processing 9161626364 <9161626364>->91212223 in context default 2021-01-13 08:07:15.221080 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2021-01-13 08:07:15.241104 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-01-13 08:07:15.261081 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Dialed number : 91212223 2021-01-13 08:07:15.261081 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '91212223' AND status=0 limit 1 2021-01-13 08:07:15.281091 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Caller Id name / number : 9161626364 / 9161626364 2021-01-13 08:07:15.281091 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="91212223" LIMIT 1 2021-01-13 08:07:15.281091 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="91212223" limit 1 2021-01-13 08:07:15.281091 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Call direction : local 2021-01-13 08:07:15.281091 [INFO] switch_cpp.cpp:1447 [ASTPP] [Accountcode : 9161626364] 2021-01-13 08:07:15.281091 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "9161626364" AND deleted = 0 limit 1 2021-01-13 08:07:15.941080 [DEBUG] switch_cpp.cpp:1447 [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 ="91212223" AND A.accountid = '57' limit 1 2021-01-13 08:07:15.961087 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 91212223 2021-01-13 08:07:15.961087 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="91212223" LIMIT 1 2021-01-13 08:07:15.961087 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="91212223" limit 1 2021-01-13 08:07:15.961087 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] New Call direction : local 2021-01-13 08:07:15.961087 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="91212223" AND (accountid = 0 OR status = 1) LIMIT 1 2021-01-13 08:07:15.961087 [NOTICE] switch_cpp.cpp:1447 [ASTPP] Localization Id: 1 2021-01-13 08:07:15.961087 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 1 AND status=0 limit 1 2021-01-13 08:07:15.961087 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE (patterns = '^91212223.*' OR patterns = '^9121222.*' OR patterns = '^912122.*' OR patterns = '^91212.*' OR patterns = '^9121.*' OR patterns = '^912.*' OR patterns = '^91.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 57 ORDER BY LENGTH(PKGPTR.patterns) DESC 2021-01-13 08:07:16.001082 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '91212223' OR number = '9121222' OR number = '912122' OR number = '91212' OR number = '9121' OR number = '912' OR number = '91' OR number = '9' OR number ='--') OR (number = '91212223*' OR number = '9121222*' OR number = '912122*' OR number = '91212*' OR number = '9121*' OR number = '912*' OR number = '91*' OR number = '9*' OR number ='--') OR (number = '9161626364' OR number = '916162636' OR number = '91616263' OR number = '9161626' OR number = '916162' OR number = '91616' OR number = '9161' OR number = '916' OR number = '91' OR number = '9' OR number ='--') OR (number = '9161626364*' OR number = '916162636*' OR number = '91616263*' OR number = '9161626*' OR number = '916162*' OR number = '91616*' OR number = '9161*' OR number = '916*' OR number = '91*' OR number = '9*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2021-01-13 08:07:16.001082 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Call Barring Status : -1 2021-01-13 08:07:16.001082 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '91212223' OR routing_prefix = '9121222' OR routing_prefix = '912122' OR routing_prefix = '91212' OR routing_prefix = '9121' OR routing_prefix = '912' OR routing_prefix = '91' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1 2021-01-13 08:07:16.021080 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Account Information =================== 2021-01-13 08:07:16.021080 [INFO] switch_cpp.cpp:1447 [ASTPP] User id : 57 2021-01-13 08:07:16.021080 [INFO] switch_cpp.cpp:1447 [ASTPP] Account code : 9161626364 2021-01-13 08:07:16.021080 [INFO] switch_cpp.cpp:1447 [ASTPP] Balance : 100 2021-01-13 08:07:16.021080 [INFO] switch_cpp.cpp:1447 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2021-01-13 08:07:16.021080 [INFO] switch_cpp.cpp:1447 [ASTPP] Ratecard id : 1 2021-01-13 08:07:16.021080 [INFO] switch_cpp.cpp:1447 [ASTPP] CID Pool : 0 2021-01-13 08:07:16.021080 [INFO] switch_cpp.cpp:1447 [ASTPP] ======================================================== 2021-01-13 08:07:16.021080 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0 2021-01-13 08:07:16.021080 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] free_inbound!!!1 2021-01-13 08:07:16.021080 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] charge_per_min!!!0 2021-01-13 08:07:16.021080 [INFO] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Your100 balance Accountid 57 !!! 2021-01-13 08:07:16.021080 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Call is free - assigning max length!!! :: 100 2021-01-13 08:07:16.021080 [INFO] switch_cpp.cpp:1447 [ASTPP] Call Max length duration : 100 minutes 2021-01-13 08:07:16.021080 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="91212223" limit 1 2021-01-13 08:07:16.021080 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 57 AND status=0 LIMIT 1 2021-01-13 08:07:16.021080 [INFO] switch_cpp.cpp:1447 [ASTPP] maxlength::::::::: 100 2021-01-13 08:07:16.021080 [ERR] mod_lua.cpp:202 /usr/share/freeswitch/scripts/astpp/scripts/astpp.xml.lua:467: attempt to concatenate global 'from_ip' (a nil value) stack traceback: /usr/share/freeswitch/scripts/astpp/scripts/astpp.xml.lua:467: in function 'freeswitch_xml_local' ...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:686: in main chunk [C]: in function 'dofile' /usr/share/freeswitch/scripts/astpp/astpp.lua:86: in main chunk 2021-01-13 08:07:16.021080 [ERR] mod_lua.cpp:270 LUA script parse/execute error! 2021-01-13 08:07:16.021080 [WARNING] mod_dialplan_xml.c:667 Context default not found 2021-01-13 08:07:16.021080 [INFO] switch_core_state_machine.c:312 No Route, Aborting 2021-01-13 08:07:16.021080 [NOTICE] switch_core_state_machine.c:313 Hangup sofia/default/9161626364@mobile.crestdial.com [CS_ROUTING] [NO_ROUTE_DESTINATION] 2021-01-13 08:07:16.021080 [DEBUG] switch_core_state_machine.c:644 (sofia/default/9161626364@mobile.crestdial.com) State ROUTING going to sleep 2021-01-13 08:07:16.021080 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_HANGUP (Cur 1 Tot 405) 2021-01-13 08:07:16.021080 [DEBUG] switch_core_state_machine.c:848 (sofia/default/9161626364@mobile.crestdial.com) Callstate Change RINGING -> HANGUP 2021-01-13 08:07:16.021080 [DEBUG] switch_core_state_machine.c:850 (sofia/default/9161626364@mobile.crestdial.com) State HANGUP 2021-01-13 08:07:16.021080 [DEBUG] mod_sofia.c:453 Channel sofia/default/9161626364@mobile.crestdial.com hanging up, cause: NO_ROUTE_DESTINATION 2021-01-13 08:07:16.021080 [DEBUG] mod_sofia.c:598 Responding to INVITE with: 404 2021-01-13 08:07:16.021080 [DEBUG] switch_core_state_machine.c:60 sofia/default/9161626364@mobile.crestdial.com Standard HANGUP, cause: NO_ROUTE_DESTINATION 2021-01-13 08:07:16.021080 [DEBUG] switch_core_state_machine.c:850 (sofia/default/9161626364@mobile.crestdial.com) State HANGUP going to sleep 2021-01-13 08:07:16.021080 [DEBUG] switch_core_state_machine.c:620 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_HANGUP -> CS_REPORTING 2021-01-13 08:07:16.021080 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_REPORTING (Cur 1 Tot 405) 2021-01-13 08:07:16.021080 [DEBUG] switch_core_state_machine.c:936 (sofia/default/9161626364@mobile.crestdial.com) State REPORTING 2021-01-13 08:07:16.021080 [INFO] mod_json_cdr.c:271 Process [e5ffc9c8-e256-49d7-8b01-73819486dc81.cdr.json] 2021-01-13 08:07:16.041105 [DEBUG] switch_core_state_machine.c:174 sofia/default/9161626364@mobile.crestdial.com Standard REPORTING, cause: NO_ROUTE_DESTINATION 2021-01-13 08:07:16.041105 [DEBUG] switch_core_state_machine.c:936 (sofia/default/9161626364@mobile.crestdial.com) State REPORTING going to sleep 2021-01-13 08:07:16.041105 [DEBUG] switch_core_state_machine.c:611 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_REPORTING -> CS_DESTROY 2021-01-13 08:07:16.041105 [DEBUG] switch_core_session.c:1726 Session 405 (sofia/default/9161626364@mobile.crestdial.com) Locked, Waiting on external entities 2021-01-13 08:07:16.041105 [NOTICE] switch_core_session.c:1744 Session 405 (sofia/default/9161626364@mobile.crestdial.com) Ended 2021-01-13 08:07:16.041105 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/9161626364@mobile.crestdial.com [CS_DESTROY] 2021-01-13 08:07:16.041105 [DEBUG] switch_core_state_machine.c:739 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_DESTROY (Cur 0 Tot 405) 2021-01-13 08:07:16.041105 [DEBUG] switch_core_state_machine.c:749 (sofia/default/9161626364@mobile.crestdial.com) State DESTROY 2021-01-13 08:07:16.041105 [DEBUG] mod_sofia.c:364 sofia/default/9161626364@mobile.crestdial.com SOFIA DESTROY 2021-01-13 08:07:16.041105 [DEBUG] switch_core_state_machine.c:181 sofia/default/9161626364@mobile.crestdial.com Standard DESTROY 2021-01-13 08:07:16.041105 [DEBUG] switch_core_state_machine.c:749 (sofia/default/9161626364@mobile.crestdial.com) State DESTROY going to sleep 2021-01-13 08:07:51.561102 [NOTICE] switch_channel.c:1118 New Channel sofia/default/91212223@mobile.crestdial.com [41f665ba-4634-4e7d-b549-73fd8a2a2d81] 2021-01-13 08:07:51.561102 [DEBUG] switch_core_state_machine.c:585 (sofia/default/91212223@mobile.crestdial.com) Running State Change CS_NEW (Cur 1 Tot 406) 2021-01-13 08:07:51.561102 [DEBUG] sofia.c:10280 sofia/default/91212223@mobile.crestdial.com receiving invite from 49.34.57.10:52127 version: 1.10.5 -release-17-25569c1631 64bit 2021-01-13 08:07:51.561102 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 49.34.57.10:0. 2021-01-13 08:07:51.561102 [DEBUG] sofia.c:2434 detaching session 41f665ba-4634-4e7d-b549-73fd8a2a2d81 2021-01-13 08:07:51.561102 [WARNING] sofia_reg.c:1794 SIP auth challenge (INVITE) on sofia profile 'default' for [9161626364@mobile.crestdial.com] from ip 49.34.57.10 2021-01-13 08:07:51.561102 [DEBUG] switch_core_state_machine.c:604 (sofia/default/91212223@mobile.crestdial.com) State NEW 2021-01-13 08:07:52.321110 [DEBUG] sofia.c:2544 Re-attaching to session 41f665ba-4634-4e7d-b549-73fd8a2a2d81 2021-01-13 08:07:52.321110 [DEBUG] sofia.c:10280 sofia/default/91212223@mobile.crestdial.com receiving invite from 49.34.57.10:52127 version: 1.10.5 -release-17-25569c1631 64bit 2021-01-13 08:07:52.321110 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 49.34.57.10:0. 2021-01-13 08:07:52.341102 [DEBUG] sofia.c:11477 Setting NAT mode based on via received 2021-01-13 08:07:52.341102 [DEBUG] sofia.c:7326 Channel sofia/default/91212223@mobile.crestdial.com entering state [received][100] 2021-01-13 08:07:52.341102 [DEBUG] sofia.c:7336 Remote SDP: v=0 o=91212223 79 2126 IN IP4 192.168.234.188 s=Talk c=IN IP4 192.168.234.188 t=0 0 a=rtcp-xr:rcvr-rtt=all:10000 stat-summary=loss,dup,jitt,TTL voip-metrics m=audio 7078 RTP/AVP 96 97 98 0 8 18 101 99 100 a=rtpmap:96 opus/48000/2 a=fmtp:96 useinbandfec=1 a=rtpmap:97 speex/16000 a=fmtp:97 vbr=on a=rtpmap:98 speex/8000 a=fmtp:98 vbr=on a=fmtp:18 annexb=yes a=rtpmap:101 telephone-event/48000 a=rtpmap:99 telephone-event/16000 a=rtpmap:100 telephone-event/8000 a=rtcp-fb:* trr-int 1000 a=rtcp-fb:* ccm tmmbr 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [opus:96:48000:20:0:2]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [opus:96:48000:20:0:2]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [speex:97:16000:20:0:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [speex:97:16000:20:0:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [speex:98:8000:20:0:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [speex:98:8000:20:0:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5510 Set telephone-event payload to 101@48000 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:3839 Set Codec sofia/default/91212223@mobile.crestdial.com PCMU/8000 20 ms 160 samples 64000 bits 1 channels 2021-01-13 08:07:52.341102 [DEBUG] switch_core_codec.c:111 sofia/default/91212223@mobile.crestdial.com Original read codec set to PCMU:0 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5853 Set telephone-event payload to 100@8000 2021-01-13 08:07:52.341102 [DEBUG] switch_core_media.c:5911 sofia/default/91212223@mobile.crestdial.com Set 2833 dtmf send payload to 100 recv payload to 100 2021-01-13 08:07:52.341102 [DEBUG] sofia.c:7760 (sofia/default/91212223@mobile.crestdial.com) State Change CS_NEW -> CS_INIT 2021-01-13 08:07:52.341102 [DEBUG] switch_core_state_machine.c:585 (sofia/default/91212223@mobile.crestdial.com) Running State Change CS_INIT (Cur 1 Tot 406) 2021-01-13 08:07:52.341102 [DEBUG] switch_core_state_machine.c:628 (sofia/default/91212223@mobile.crestdial.com) State INIT 2021-01-13 08:07:52.341102 [DEBUG] mod_sofia.c:93 sofia/default/91212223@mobile.crestdial.com SOFIA INIT 2021-01-13 08:07:52.341102 [DEBUG] switch_core_state_machine.c:40 sofia/default/91212223@mobile.crestdial.com Standard INIT 2021-01-13 08:07:52.341102 [DEBUG] switch_core_state_machine.c:48 (sofia/default/91212223@mobile.crestdial.com) State Change CS_INIT -> CS_ROUTING 2021-01-13 08:07:52.341102 [DEBUG] switch_core_state_machine.c:628 (sofia/default/91212223@mobile.crestdial.com) State INIT going to sleep 2021-01-13 08:07:52.341102 [DEBUG] switch_core_state_machine.c:585 (sofia/default/91212223@mobile.crestdial.com) Running State Change CS_ROUTING (Cur 1 Tot 406) 2021-01-13 08:07:52.341102 [DEBUG] switch_channel.c:2332 (sofia/default/91212223@mobile.crestdial.com) Callstate Change DOWN -> RINGING 2021-01-13 08:07:52.341102 [DEBUG] switch_core_state_machine.c:644 (sofia/default/91212223@mobile.crestdial.com) State ROUTING 2021-01-13 08:07:52.341102 [DEBUG] mod_sofia.c:154 sofia/default/91212223@mobile.crestdial.com SOFIA ROUTING 2021-01-13 08:07:52.341102 [DEBUG] switch_core_state_machine.c:236 sofia/default/91212223@mobile.crestdial.com Standard ROUTING 2021-01-13 08:07:52.341102 [INFO] mod_dialplan_xml.c:637 Processing 91212223 <91212223>->9161626364 in context default 2021-01-13 08:07:52.381074 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2021-01-13 08:07:52.401100 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-01-13 08:07:52.401100 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Dialed number : 9161626364 2021-01-13 08:07:52.401100 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '9161626364' AND status=0 limit 1 2021-01-13 08:07:52.421077 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Caller Id name / number : 91212223 / 91212223 2021-01-13 08:07:52.421077 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9161626364" LIMIT 1 2021-01-13 08:07:52.421077 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="9161626364" limit 1 2021-01-13 08:07:52.421077 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Call direction : local 2021-01-13 08:07:52.421077 [INFO] switch_cpp.cpp:1447 [ASTPP] [Accountcode : 9161626364] 2021-01-13 08:07:52.421077 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "9161626364" AND deleted = 0 limit 1 2021-01-13 08:07:52.861076 [DEBUG] switch_cpp.cpp:1447 [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 ="9161626364" AND A.accountid = '57' limit 1 2021-01-13 08:07:52.861076 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 9161626364 2021-01-13 08:07:52.861076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9161626364" LIMIT 1 2021-01-13 08:07:52.861076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="9161626364" limit 1 2021-01-13 08:07:52.861076 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] New Call direction : local 2021-01-13 08:07:52.861076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="9161626364" AND (accountid = 0 OR status = 1) LIMIT 1 2021-01-13 08:07:52.861076 [NOTICE] switch_cpp.cpp:1447 [ASTPP] Localization Id: 1 2021-01-13 08:07:52.861076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 1 AND status=0 limit 1 2021-01-13 08:07:52.861076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE (patterns = '^9161626364.*' OR patterns = '^916162636.*' OR patterns = '^91616263.*' OR patterns = '^9161626.*' OR patterns = '^916162.*' OR patterns = '^91616.*' OR patterns = '^9161.*' OR patterns = '^916.*' OR patterns = '^91.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 57 ORDER BY LENGTH(PKGPTR.patterns) DESC 2021-01-13 08:07:52.881076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '9161626364' OR number = '916162636' OR number = '91616263' OR number = '9161626' OR number = '916162' OR number = '91616' OR number = '9161' OR number = '916' OR number = '91' OR number = '9' OR number ='--') OR (number = '9161626364*' OR number = '916162636*' OR number = '91616263*' OR number = '9161626*' OR number = '916162*' OR number = '91616*' OR number = '9161*' OR number = '916*' OR number = '91*' OR number = '9*' OR number ='--') OR (number = '91212223' OR number = '9121222' OR number = '912122' OR number = '91212' OR number = '9121' OR number = '912' OR number = '91' OR number = '9' OR number ='--') OR (number = '91212223*' OR number = '9121222*' OR number = '912122*' OR number = '91212*' OR number = '9121*' OR number = '912*' OR number = '91*' OR number = '9*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2021-01-13 08:07:52.881076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Call Barring Status : -1 2021-01-13 08:07:52.881076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '9161626364' OR routing_prefix = '916162636' OR routing_prefix = '91616263' OR routing_prefix = '9161626' OR routing_prefix = '916162' OR routing_prefix = '91616' OR routing_prefix = '9161' OR routing_prefix = '916' OR routing_prefix = '91' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1 2021-01-13 08:07:52.881076 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Account Information =================== 2021-01-13 08:07:52.881076 [INFO] switch_cpp.cpp:1447 [ASTPP] User id : 57 2021-01-13 08:07:52.881076 [INFO] switch_cpp.cpp:1447 [ASTPP] Account code : 9161626364 2021-01-13 08:07:52.881076 [INFO] switch_cpp.cpp:1447 [ASTPP] Balance : 100 2021-01-13 08:07:52.881076 [INFO] switch_cpp.cpp:1447 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2021-01-13 08:07:52.881076 [INFO] switch_cpp.cpp:1447 [ASTPP] Ratecard id : 1 2021-01-13 08:07:52.881076 [INFO] switch_cpp.cpp:1447 [ASTPP] CID Pool : 0 2021-01-13 08:07:52.881076 [INFO] switch_cpp.cpp:1447 [ASTPP] ======================================================== 2021-01-13 08:07:52.881076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0 2021-01-13 08:07:52.901078 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] free_inbound!!!1 2021-01-13 08:07:52.901078 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] charge_per_min!!!0 2021-01-13 08:07:52.901078 [INFO] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Your100 balance Accountid 57 !!! 2021-01-13 08:07:52.901078 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Call is free - assigning max length!!! :: 100 2021-01-13 08:07:52.901078 [INFO] switch_cpp.cpp:1447 [ASTPP] Call Max length duration : 100 minutes 2021-01-13 08:07:52.901078 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="9161626364" limit 1 2021-01-13 08:07:52.901078 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 57 AND status=0 LIMIT 1 2021-01-13 08:07:52.901078 [INFO] switch_cpp.cpp:1447 [ASTPP] maxlength::::::::: 100 2021-01-13 08:07:52.901078 [ERR] mod_lua.cpp:202 /usr/share/freeswitch/scripts/astpp/scripts/astpp.xml.lua:467: attempt to concatenate global 'from_ip' (a nil value) stack traceback: /usr/share/freeswitch/scripts/astpp/scripts/astpp.xml.lua:467: in function 'freeswitch_xml_local' ...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:686: in main chunk [C]: in function 'dofile' /usr/share/freeswitch/scripts/astpp/astpp.lua:86: in main chunk 2021-01-13 08:07:52.901078 [ERR] mod_lua.cpp:270 LUA script parse/execute error! 2021-01-13 08:07:52.901078 [WARNING] mod_dialplan_xml.c:667 Context default not found 2021-01-13 08:07:52.901078 [INFO] switch_core_state_machine.c:312 No Route, Aborting 2021-01-13 08:07:52.901078 [NOTICE] switch_core_state_machine.c:313 Hangup sofia/default/91212223@mobile.crestdial.com [CS_ROUTING] [NO_ROUTE_DESTINATION] 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:644 (sofia/default/91212223@mobile.crestdial.com) State ROUTING going to sleep 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:585 (sofia/default/91212223@mobile.crestdial.com) Running State Change CS_HANGUP (Cur 1 Tot 406) 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:848 (sofia/default/91212223@mobile.crestdial.com) Callstate Change RINGING -> HANGUP 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:850 (sofia/default/91212223@mobile.crestdial.com) State HANGUP 2021-01-13 08:07:52.901078 [DEBUG] mod_sofia.c:453 Channel sofia/default/91212223@mobile.crestdial.com hanging up, cause: NO_ROUTE_DESTINATION 2021-01-13 08:07:52.901078 [DEBUG] mod_sofia.c:598 Responding to INVITE with: 404 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:60 sofia/default/91212223@mobile.crestdial.com Standard HANGUP, cause: NO_ROUTE_DESTINATION 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:850 (sofia/default/91212223@mobile.crestdial.com) State HANGUP going to sleep 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:620 (sofia/default/91212223@mobile.crestdial.com) State Change CS_HANGUP -> CS_REPORTING 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:585 (sofia/default/91212223@mobile.crestdial.com) Running State Change CS_REPORTING (Cur 1 Tot 406) 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:936 (sofia/default/91212223@mobile.crestdial.com) State REPORTING 2021-01-13 08:07:52.901078 [INFO] mod_json_cdr.c:271 Process [41f665ba-4634-4e7d-b549-73fd8a2a2d81.cdr.json] 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:174 sofia/default/91212223@mobile.crestdial.com Standard REPORTING, cause: NO_ROUTE_DESTINATION 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:936 (sofia/default/91212223@mobile.crestdial.com) State REPORTING going to sleep 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:611 (sofia/default/91212223@mobile.crestdial.com) State Change CS_REPORTING -> CS_DESTROY 2021-01-13 08:07:52.901078 [DEBUG] switch_core_session.c:1726 Session 406 (sofia/default/91212223@mobile.crestdial.com) Locked, Waiting on external entities 2021-01-13 08:07:52.901078 [NOTICE] switch_core_session.c:1744 Session 406 (sofia/default/91212223@mobile.crestdial.com) Ended 2021-01-13 08:07:52.901078 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/91212223@mobile.crestdial.com [CS_DESTROY] 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:739 (sofia/default/91212223@mobile.crestdial.com) Running State Change CS_DESTROY (Cur 0 Tot 406) 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:749 (sofia/default/91212223@mobile.crestdial.com) State DESTROY 2021-01-13 08:07:52.901078 [DEBUG] mod_sofia.c:364 sofia/default/91212223@mobile.crestdial.com SOFIA DESTROY 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:181 sofia/default/91212223@mobile.crestdial.com Standard DESTROY 2021-01-13 08:07:52.901078 [DEBUG] switch_core_state_machine.c:749 (sofia/default/91212223@mobile.crestdial.com) State DESTROY going to sleep 2021-01-13 08:09:04.581162 [NOTICE] switch_channel.c:1118 New Channel sofia/default/1001@13.235.24.114 [ea73d209-0b5e-4c0d-ab14-472d32af162f] 2021-01-13 08:09:04.581162 [DEBUG] switch_core_state_machine.c:585 (sofia/default/1001@13.235.24.114) Running State Change CS_NEW (Cur 1 Tot 407) 2021-01-13 08:09:04.581162 [DEBUG] sofia.c:10280 sofia/default/1001@13.235.24.114 receiving invite from 185.16.38.4:55497 version: 1.10.5 -release-17-25569c1631 64bit 2021-01-13 08:09:04.581162 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 185.16.38.4:0. 2021-01-13 08:09:04.581162 [DEBUG] sofia.c:2434 detaching session ea73d209-0b5e-4c0d-ab14-472d32af162f 2021-01-13 08:09:04.581162 [WARNING] sofia_reg.c:1794 SIP auth challenge (INVITE) on sofia profile 'default' for [0046812420242@13.235.24.114] from ip 185.16.38.4 2021-01-13 08:09:04.581162 [DEBUG] switch_core_state_machine.c:604 (sofia/default/1001@13.235.24.114) State NEW 2021-01-13 08:09:04.741100 [DEBUG] sofia.c:2544 Re-attaching to session ea73d209-0b5e-4c0d-ab14-472d32af162f 2021-01-13 08:09:04.741100 [DEBUG] sofia.c:10280 sofia/default/1001@13.235.24.114 receiving invite from 185.16.38.4:55497 version: 1.10.5 -release-17-25569c1631 64bit 2021-01-13 08:09:04.741100 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 185.16.38.4:0. 2021-01-13 08:09:04.741100 [WARNING] sofia_reg.c:2930 Can't find user [1001@13.235.24.114] from 185.16.38.4 You must define a domain called '13.235.24.114' in your directory and add a user with the id="1001" attribute and you must configure your device to use the proper domain in its authentication credentials. 2021-01-13 08:09:04.741100 [NOTICE] sofia.c:2432 Hangup sofia/default/1001@13.235.24.114 [CS_NEW] [CALL_REJECTED] 2021-01-13 08:09:04.741100 [WARNING] sofia_reg.c:1739 SIP auth failure (INVITE) on sofia profile 'default' for [0046812420242@13.235.24.114] from ip 185.16.38.4 2021-01-13 08:09:04.741100 [DEBUG] sofia.c:1548 Channel is already hungup. 2021-01-13 08:09:04.741100 [DEBUG] sofia.c:1548 Channel is already hungup. 2021-01-13 08:09:04.741100 [DEBUG] switch_core_state_machine.c:585 (sofia/default/1001@13.235.24.114) Running State Change CS_HANGUP (Cur 1 Tot 407) 2021-01-13 08:09:04.741100 [DEBUG] switch_core_state_machine.c:848 (sofia/default/1001@13.235.24.114) Callstate Change DOWN -> HANGUP 2021-01-13 08:09:04.741100 [DEBUG] switch_core_state_machine.c:850 (sofia/default/1001@13.235.24.114) State HANGUP 2021-01-13 08:09:04.741100 [DEBUG] mod_sofia.c:453 Channel sofia/default/1001@13.235.24.114 hanging up, cause: CALL_REJECTED 2021-01-13 08:09:04.741100 [DEBUG] switch_core_state_machine.c:60 sofia/default/1001@13.235.24.114 Standard HANGUP, cause: CALL_REJECTED 2021-01-13 08:09:04.741100 [DEBUG] switch_core_state_machine.c:850 (sofia/default/1001@13.235.24.114) State HANGUP going to sleep 2021-01-13 08:09:04.741100 [DEBUG] switch_core_state_machine.c:620 (sofia/default/1001@13.235.24.114) State Change CS_HANGUP -> CS_REPORTING 2021-01-13 08:09:04.741100 [DEBUG] switch_core_state_machine.c:585 (sofia/default/1001@13.235.24.114) Running State Change CS_REPORTING (Cur 1 Tot 407) 2021-01-13 08:09:04.741100 [DEBUG] switch_core_state_machine.c:936 (sofia/default/1001@13.235.24.114) State REPORTING 2021-01-13 08:09:04.741100 [DEBUG] switch_core_state_machine.c:174 sofia/default/1001@13.235.24.114 Standard REPORTING, cause: CALL_REJECTED 2021-01-13 08:09:04.741100 [DEBUG] switch_core_state_machine.c:936 (sofia/default/1001@13.235.24.114) State REPORTING going to sleep 2021-01-13 08:09:04.741100 [DEBUG] switch_core_state_machine.c:611 (sofia/default/1001@13.235.24.114) State Change CS_REPORTING -> CS_DESTROY 2021-01-13 08:09:04.741100 [DEBUG] switch_core_session.c:1726 Session 407 (sofia/default/1001@13.235.24.114) Locked, Waiting on external entities 2021-01-13 08:09:04.741100 [NOTICE] switch_core_session.c:1744 Session 407 (sofia/default/1001@13.235.24.114) Ended 2021-01-13 08:09:04.741100 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/1001@13.235.24.114 [CS_DESTROY] 2021-01-13 08:09:04.741100 [DEBUG] switch_core_state_machine.c:739 (sofia/default/1001@13.235.24.114) Running State Change CS_DESTROY (Cur 0 Tot 407) 2021-01-13 08:09:04.741100 [DEBUG] switch_core_state_machine.c:749 (sofia/default/1001@13.235.24.114) State DESTROY 2021-01-13 08:09:04.741100 [DEBUG] mod_sofia.c:364 sofia/default/1001@13.235.24.114 SOFIA DESTROY 2021-01-13 08:09:04.741100 [DEBUG] switch_core_state_machine.c:181 sofia/default/1001@13.235.24.114 Standard DESTROY 2021-01-13 08:09:04.741100 [DEBUG] switch_core_state_machine.c:749 (sofia/default/1001@13.235.24.114) State DESTROY going to sleep 2021-01-13 08:09:16.221111 [NOTICE] switch_channel.c:1118 New Channel sofia/default/9161626364@mobile.crestdial.com [6356401f-9127-4e92-857a-36aea8752757] 2021-01-13 08:09:16.221111 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_NEW (Cur 1 Tot 408) 2021-01-13 08:09:16.221111 [DEBUG] sofia.c:10280 sofia/default/9161626364@mobile.crestdial.com receiving invite from 185.117.83.202:25080 version: 1.10.5 -release-17-25569c1631 64bit 2021-01-13 08:09:16.221111 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 185.117.83.202:0. 2021-01-13 08:09:16.221111 [DEBUG] sofia.c:2434 detaching session 6356401f-9127-4e92-857a-36aea8752757 2021-01-13 08:09:16.221111 [WARNING] sofia_reg.c:1794 SIP auth challenge (INVITE) on sofia profile 'default' for [91212223@mobile.crestdial.com] from ip 185.117.83.202 2021-01-13 08:09:16.221111 [DEBUG] switch_core_state_machine.c:604 (sofia/default/9161626364@mobile.crestdial.com) State NEW 2021-01-13 08:09:16.841099 [DEBUG] sofia.c:2544 Re-attaching to session 6356401f-9127-4e92-857a-36aea8752757 2021-01-13 08:09:16.861108 [DEBUG] sofia.c:10280 sofia/default/9161626364@mobile.crestdial.com receiving invite from 185.117.83.202:25080 version: 1.10.5 -release-17-25569c1631 64bit 2021-01-13 08:09:16.861108 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 185.117.83.202:0. 2021-01-13 08:09:16.881116 [DEBUG] sofia.c:7326 Channel sofia/default/9161626364@mobile.crestdial.com entering state [received][100] 2021-01-13 08:09:16.881116 [DEBUG] sofia.c:7336 Remote SDP: v=0 o=Zoiper 1610525355163 1 IN IP4 42.106.26.11 s=Z c=IN IP4 42.106.26.11 t=0 0 m=audio 15738 RTP/AVP 106 9 98 101 0 8 18 3 a=rtpmap:106 opus/48000/2 a=fmtp:106 sprop-maxcapturerate=16000; minptime=20; useinbandfec=1 a=rtpmap:98 telephone-event/48000 a=fmtp:98 0-16 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5510 Set telephone-event payload to 98@48000 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:3839 Set Codec sofia/default/9161626364@mobile.crestdial.com PCMU/8000 20 ms 160 samples 64000 bits 1 channels 2021-01-13 08:09:16.881116 [DEBUG] switch_core_codec.c:111 sofia/default/9161626364@mobile.crestdial.com Original read codec set to PCMU:0 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5853 Set telephone-event payload to 101@8000 2021-01-13 08:09:16.881116 [DEBUG] switch_core_media.c:5911 sofia/default/9161626364@mobile.crestdial.com Set 2833 dtmf send payload to 101 recv payload to 101 2021-01-13 08:09:16.881116 [DEBUG] sofia.c:7760 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_NEW -> CS_INIT 2021-01-13 08:09:16.881116 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_INIT (Cur 1 Tot 408) 2021-01-13 08:09:16.881116 [DEBUG] switch_core_state_machine.c:628 (sofia/default/9161626364@mobile.crestdial.com) State INIT 2021-01-13 08:09:16.881116 [DEBUG] mod_sofia.c:93 sofia/default/9161626364@mobile.crestdial.com SOFIA INIT 2021-01-13 08:09:16.881116 [DEBUG] switch_core_state_machine.c:40 sofia/default/9161626364@mobile.crestdial.com Standard INIT 2021-01-13 08:09:16.881116 [DEBUG] switch_core_state_machine.c:48 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_INIT -> CS_ROUTING 2021-01-13 08:09:16.881116 [DEBUG] switch_core_state_machine.c:628 (sofia/default/9161626364@mobile.crestdial.com) State INIT going to sleep 2021-01-13 08:09:16.881116 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_ROUTING (Cur 1 Tot 408) 2021-01-13 08:09:16.881116 [DEBUG] switch_channel.c:2332 (sofia/default/9161626364@mobile.crestdial.com) Callstate Change DOWN -> RINGING 2021-01-13 08:09:16.881116 [DEBUG] switch_core_state_machine.c:644 (sofia/default/9161626364@mobile.crestdial.com) State ROUTING 2021-01-13 08:09:16.881116 [DEBUG] mod_sofia.c:154 sofia/default/9161626364@mobile.crestdial.com SOFIA ROUTING 2021-01-13 08:09:16.881116 [DEBUG] switch_core_state_machine.c:236 sofia/default/9161626364@mobile.crestdial.com Standard ROUTING 2021-01-13 08:09:16.881116 [INFO] mod_dialplan_xml.c:637 Processing 9161626364 <9161626364>->91212223 in context default 2021-01-13 08:09:16.901086 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2021-01-13 08:09:16.901086 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-01-13 08:09:16.921077 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Dialed number : 91212223 2021-01-13 08:09:16.921077 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '91212223' AND status=0 limit 1 2021-01-13 08:09:16.921077 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Caller Id name / number : 9161626364 / 9161626364 2021-01-13 08:09:16.921077 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="91212223" LIMIT 1 2021-01-13 08:09:16.921077 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="91212223" limit 1 2021-01-13 08:09:16.921077 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Call direction : local 2021-01-13 08:09:16.921077 [INFO] switch_cpp.cpp:1447 [ASTPP] [Accountcode : 9161626364] 2021-01-13 08:09:16.921077 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "9161626364" AND deleted = 0 limit 1 2021-01-13 08:09:17.261079 [DEBUG] switch_cpp.cpp:1447 [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 ="91212223" AND A.accountid = '57' limit 1 2021-01-13 08:09:17.261079 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 91212223 2021-01-13 08:09:17.261079 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="91212223" LIMIT 1 2021-01-13 08:09:17.261079 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="91212223" limit 1 2021-01-13 08:09:17.261079 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] New Call direction : local 2021-01-13 08:09:17.261079 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="91212223" AND (accountid = 0 OR status = 1) LIMIT 1 2021-01-13 08:09:17.261079 [NOTICE] switch_cpp.cpp:1447 [ASTPP] Localization Id: 1 2021-01-13 08:09:17.261079 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 1 AND status=0 limit 1 2021-01-13 08:09:17.261079 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE (patterns = '^91212223.*' OR patterns = '^9121222.*' OR patterns = '^912122.*' OR patterns = '^91212.*' OR patterns = '^9121.*' OR patterns = '^912.*' OR patterns = '^91.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 57 ORDER BY LENGTH(PKGPTR.patterns) DESC 2021-01-13 08:09:17.261079 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '91212223' OR number = '9121222' OR number = '912122' OR number = '91212' OR number = '9121' OR number = '912' OR number = '91' OR number = '9' OR number ='--') OR (number = '91212223*' OR number = '9121222*' OR number = '912122*' OR number = '91212*' OR number = '9121*' OR number = '912*' OR number = '91*' OR number = '9*' OR number ='--') OR (number = '9161626364' OR number = '916162636' OR number = '91616263' OR number = '9161626' OR number = '916162' OR number = '91616' OR number = '9161' OR number = '916' OR number = '91' OR number = '9' OR number ='--') OR (number = '9161626364*' OR number = '916162636*' OR number = '91616263*' OR number = '9161626*' OR number = '916162*' OR number = '91616*' OR number = '9161*' OR number = '916*' OR number = '91*' OR number = '9*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2021-01-13 08:09:17.261079 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Call Barring Status : -1 2021-01-13 08:09:17.261079 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '91212223' OR routing_prefix = '9121222' OR routing_prefix = '912122' OR routing_prefix = '91212' OR routing_prefix = '9121' OR routing_prefix = '912' OR routing_prefix = '91' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1 2021-01-13 08:09:17.261079 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Account Information =================== 2021-01-13 08:09:17.261079 [INFO] switch_cpp.cpp:1447 [ASTPP] User id : 57 2021-01-13 08:09:17.261079 [INFO] switch_cpp.cpp:1447 [ASTPP] Account code : 9161626364 2021-01-13 08:09:17.261079 [INFO] switch_cpp.cpp:1447 [ASTPP] Balance : 100 2021-01-13 08:09:17.261079 [INFO] switch_cpp.cpp:1447 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2021-01-13 08:09:17.261079 [INFO] switch_cpp.cpp:1447 [ASTPP] Ratecard id : 1 2021-01-13 08:09:17.261079 [INFO] switch_cpp.cpp:1447 [ASTPP] CID Pool : 0 2021-01-13 08:09:17.261079 [INFO] switch_cpp.cpp:1447 [ASTPP] ======================================================== 2021-01-13 08:09:17.261079 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0 2021-01-13 08:09:17.261079 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] free_inbound!!!1 2021-01-13 08:09:17.261079 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] charge_per_min!!!0 2021-01-13 08:09:17.261079 [INFO] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Your100 balance Accountid 57 !!! 2021-01-13 08:09:17.261079 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Call is free - assigning max length!!! :: 100 2021-01-13 08:09:17.261079 [INFO] switch_cpp.cpp:1447 [ASTPP] Call Max length duration : 100 minutes 2021-01-13 08:09:17.261079 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="91212223" limit 1 2021-01-13 08:09:17.261079 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 57 AND status=0 LIMIT 1 2021-01-13 08:09:17.261079 [INFO] switch_cpp.cpp:1447 [ASTPP] maxlength::::::::: 100 2021-01-13 08:09:17.261079 [ERR] mod_lua.cpp:202 /usr/share/freeswitch/scripts/astpp/scripts/astpp.xml.lua:467: attempt to concatenate global 'from_ip' (a nil value) stack traceback: /usr/share/freeswitch/scripts/astpp/scripts/astpp.xml.lua:467: in function 'freeswitch_xml_local' ...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:686: in main chunk [C]: in function 'dofile' /usr/share/freeswitch/scripts/astpp/astpp.lua:86: in main chunk 2021-01-13 08:09:17.261079 [ERR] mod_lua.cpp:270 LUA script parse/execute error! 2021-01-13 08:09:17.261079 [WARNING] mod_dialplan_xml.c:667 Context default not found 2021-01-13 08:09:17.261079 [INFO] switch_core_state_machine.c:312 No Route, Aborting 2021-01-13 08:09:17.261079 [NOTICE] switch_core_state_machine.c:313 Hangup sofia/default/9161626364@mobile.crestdial.com [CS_ROUTING] [NO_ROUTE_DESTINATION] 2021-01-13 08:09:17.261079 [DEBUG] switch_core_state_machine.c:644 (sofia/default/9161626364@mobile.crestdial.com) State ROUTING going to sleep 2021-01-13 08:09:17.261079 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_HANGUP (Cur 1 Tot 408) 2021-01-13 08:09:17.261079 [DEBUG] switch_core_state_machine.c:848 (sofia/default/9161626364@mobile.crestdial.com) Callstate Change RINGING -> HANGUP 2021-01-13 08:09:17.261079 [DEBUG] switch_core_state_machine.c:850 (sofia/default/9161626364@mobile.crestdial.com) State HANGUP 2021-01-13 08:09:17.261079 [DEBUG] mod_sofia.c:453 Channel sofia/default/9161626364@mobile.crestdial.com hanging up, cause: NO_ROUTE_DESTINATION 2021-01-13 08:09:17.261079 [DEBUG] mod_sofia.c:598 Responding to INVITE with: 404 2021-01-13 08:09:17.261079 [DEBUG] switch_core_state_machine.c:60 sofia/default/9161626364@mobile.crestdial.com Standard HANGUP, cause: NO_ROUTE_DESTINATION 2021-01-13 08:09:17.261079 [DEBUG] switch_core_state_machine.c:850 (sofia/default/9161626364@mobile.crestdial.com) State HANGUP going to sleep 2021-01-13 08:09:17.261079 [DEBUG] switch_core_state_machine.c:620 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_HANGUP -> CS_REPORTING 2021-01-13 08:09:17.261079 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_REPORTING (Cur 1 Tot 408) 2021-01-13 08:09:17.261079 [DEBUG] switch_core_state_machine.c:936 (sofia/default/9161626364@mobile.crestdial.com) State REPORTING 2021-01-13 08:09:17.261079 [INFO] mod_json_cdr.c:271 Process [6356401f-9127-4e92-857a-36aea8752757.cdr.json] 2021-01-13 08:09:17.281091 [DEBUG] switch_core_state_machine.c:174 sofia/default/9161626364@mobile.crestdial.com Standard REPORTING, cause: NO_ROUTE_DESTINATION 2021-01-13 08:09:17.281091 [DEBUG] switch_core_state_machine.c:936 (sofia/default/9161626364@mobile.crestdial.com) State REPORTING going to sleep 2021-01-13 08:09:17.281091 [DEBUG] switch_core_state_machine.c:611 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_REPORTING -> CS_DESTROY 2021-01-13 08:09:17.281091 [DEBUG] switch_core_session.c:1726 Session 408 (sofia/default/9161626364@mobile.crestdial.com) Locked, Waiting on external entities 2021-01-13 08:09:17.281091 [NOTICE] switch_core_session.c:1744 Session 408 (sofia/default/9161626364@mobile.crestdial.com) Ended 2021-01-13 08:09:17.281091 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/9161626364@mobile.crestdial.com [CS_DESTROY] 2021-01-13 08:09:17.281091 [DEBUG] switch_core_state_machine.c:739 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_DESTROY (Cur 0 Tot 408) 2021-01-13 08:09:17.281091 [DEBUG] switch_core_state_machine.c:749 (sofia/default/9161626364@mobile.crestdial.com) State DESTROY 2021-01-13 08:09:17.281091 [DEBUG] mod_sofia.c:364 sofia/default/9161626364@mobile.crestdial.com SOFIA DESTROY 2021-01-13 08:09:17.281091 [DEBUG] switch_core_state_machine.c:181 sofia/default/9161626364@mobile.crestdial.com Standard DESTROY 2021-01-13 08:09:17.281091 [DEBUG] switch_core_state_machine.c:749 (sofia/default/9161626364@mobile.crestdial.com) State DESTROY going to sleep 2021-01-13 08:10:01.381082 [NOTICE] switch_channel.c:1118 New Channel sofia/default/000000111323524114@13.235.24.114 [985cfa53-d79b-43d4-b78a-8b3c6a40993f] 2021-01-13 08:10:01.381082 [DEBUG] switch_core_state_machine.c:585 (sofia/default/000000111323524114@13.235.24.114) Running State Change CS_NEW (Cur 1 Tot 409) 2021-01-13 08:10:01.381082 [DEBUG] sofia.c:10280 sofia/default/000000111323524114@13.235.24.114 receiving invite from 143.244.57.86:60707 version: 1.10.5 -release-17-25569c1631 64bit 2021-01-13 08:10:01.381082 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 143.244.57.86:0. 2021-01-13 08:10:01.381082 [DEBUG] sofia.c:2434 detaching session 985cfa53-d79b-43d4-b78a-8b3c6a40993f 2021-01-13 08:10:01.381082 [WARNING] sofia_reg.c:1794 SIP auth challenge (INVITE) on sofia profile 'default' for [00000011972595725668@13.235.24.114] from ip 143.244.57.86 2021-01-13 08:10:01.381082 [DEBUG] switch_core_state_machine.c:604 (sofia/default/000000111323524114@13.235.24.114) State NEW 2021-01-13 08:10:11.441099 [WARNING] switch_core_state_machine.c:688 985cfa53-d79b-43d4-b78a-8b3c6a40993f sofia/default/000000111323524114@13.235.24.114 Abandoned 2021-01-13 08:10:11.441099 [NOTICE] switch_core_state_machine.c:691 Hangup sofia/default/000000111323524114@13.235.24.114 [CS_NEW] [WRONG_CALL_STATE] 2021-01-13 08:10:11.441099 [DEBUG] switch_core_state_machine.c:585 (sofia/default/000000111323524114@13.235.24.114) Running State Change CS_HANGUP (Cur 1 Tot 409) 2021-01-13 08:10:11.441099 [DEBUG] switch_core_state_machine.c:848 (sofia/default/000000111323524114@13.235.24.114) Callstate Change DOWN -> HANGUP 2021-01-13 08:10:11.441099 [DEBUG] switch_core_state_machine.c:850 (sofia/default/000000111323524114@13.235.24.114) State HANGUP 2021-01-13 08:10:11.441099 [DEBUG] mod_sofia.c:453 Channel sofia/default/000000111323524114@13.235.24.114 hanging up, cause: WRONG_CALL_STATE 2021-01-13 08:10:11.441099 [DEBUG] switch_core_state_machine.c:60 sofia/default/000000111323524114@13.235.24.114 Standard HANGUP, cause: WRONG_CALL_STATE 2021-01-13 08:10:11.441099 [DEBUG] switch_core_state_machine.c:850 (sofia/default/000000111323524114@13.235.24.114) State HANGUP going to sleep 2021-01-13 08:10:11.441099 [DEBUG] switch_core_state_machine.c:620 (sofia/default/000000111323524114@13.235.24.114) State Change CS_HANGUP -> CS_REPORTING 2021-01-13 08:10:11.441099 [DEBUG] switch_core_state_machine.c:585 (sofia/default/000000111323524114@13.235.24.114) Running State Change CS_REPORTING (Cur 1 Tot 409) 2021-01-13 08:10:11.441099 [DEBUG] switch_core_state_machine.c:936 (sofia/default/000000111323524114@13.235.24.114) State REPORTING 2021-01-13 08:10:11.441099 [DEBUG] switch_core_state_machine.c:174 sofia/default/000000111323524114@13.235.24.114 Standard REPORTING, cause: WRONG_CALL_STATE 2021-01-13 08:10:11.441099 [DEBUG] switch_core_state_machine.c:936 (sofia/default/000000111323524114@13.235.24.114) State REPORTING going to sleep 2021-01-13 08:10:11.441099 [DEBUG] switch_core_state_machine.c:611 (sofia/default/000000111323524114@13.235.24.114) State Change CS_REPORTING -> CS_DESTROY 2021-01-13 08:10:11.441099 [DEBUG] switch_core_session.c:1726 Session 409 (sofia/default/000000111323524114@13.235.24.114) Locked, Waiting on external entities 2021-01-13 08:10:11.441099 [NOTICE] switch_core_session.c:1744 Session 409 (sofia/default/000000111323524114@13.235.24.114) Ended 2021-01-13 08:10:11.441099 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/000000111323524114@13.235.24.114 [CS_DESTROY] 2021-01-13 08:10:11.441099 [DEBUG] switch_core_state_machine.c:739 (sofia/default/000000111323524114@13.235.24.114) Running State Change CS_DESTROY (Cur 0 Tot 409) 2021-01-13 08:10:11.441099 [DEBUG] switch_core_state_machine.c:749 (sofia/default/000000111323524114@13.235.24.114) State DESTROY 2021-01-13 08:10:11.441099 [DEBUG] mod_sofia.c:364 sofia/default/000000111323524114@13.235.24.114 SOFIA DESTROY 2021-01-13 08:10:11.441099 [DEBUG] switch_core_state_machine.c:181 sofia/default/000000111323524114@13.235.24.114 Standard DESTROY 2021-01-13 08:10:11.441099 [DEBUG] switch_core_state_machine.c:749 (sofia/default/000000111323524114@13.235.24.114) State DESTROY going to sleep 2021-01-13 08:12:00.161079 [NOTICE] switch_channel.c:1118 New Channel sofia/default/9161626364@mobile.crestdial.com [61d58f69-e4f1-4391-a027-3aa364c6e0e9] 2021-01-13 08:12:00.161079 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_NEW (Cur 1 Tot 410) 2021-01-13 08:12:00.161079 [DEBUG] sofia.c:10280 sofia/default/9161626364@mobile.crestdial.com receiving invite from 185.117.83.202:25080 version: 1.10.5 -release-17-25569c1631 64bit 2021-01-13 08:12:00.161079 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 185.117.83.202:0. 2021-01-13 08:12:00.161079 [DEBUG] sofia.c:2434 detaching session 61d58f69-e4f1-4391-a027-3aa364c6e0e9 2021-01-13 08:12:00.161079 [WARNING] sofia_reg.c:1794 SIP auth challenge (INVITE) on sofia profile 'default' for [91212223@mobile.crestdial.com] from ip 185.117.83.202 2021-01-13 08:12:00.161079 [DEBUG] switch_core_state_machine.c:604 (sofia/default/9161626364@mobile.crestdial.com) State NEW 2021-01-13 08:12:00.761079 [DEBUG] sofia.c:2544 Re-attaching to session 61d58f69-e4f1-4391-a027-3aa364c6e0e9 2021-01-13 08:12:00.781111 [DEBUG] sofia.c:10280 sofia/default/9161626364@mobile.crestdial.com receiving invite from 185.117.83.202:25080 version: 1.10.5 -release-17-25569c1631 64bit 2021-01-13 08:12:00.781111 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 185.117.83.202:0. 2021-01-13 08:12:00.801090 [DEBUG] sofia.c:7326 Channel sofia/default/9161626364@mobile.crestdial.com entering state [received][100] 2021-01-13 08:12:00.801090 [DEBUG] sofia.c:7336 Remote SDP: v=0 o=Zoiper 1610525519089 1 IN IP4 42.106.26.11 s=Z c=IN IP4 42.106.26.11 t=0 0 m=audio 15738 RTP/AVP 106 9 98 101 0 8 18 3 a=rtpmap:106 opus/48000/2 a=fmtp:106 sprop-maxcapturerate=16000; minptime=20; useinbandfec=1 a=rtpmap:98 telephone-event/48000 a=fmtp:98 0-16 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5510 Set telephone-event payload to 98@48000 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:3839 Set Codec sofia/default/9161626364@mobile.crestdial.com PCMU/8000 20 ms 160 samples 64000 bits 1 channels 2021-01-13 08:12:00.801090 [DEBUG] switch_core_codec.c:111 sofia/default/9161626364@mobile.crestdial.com Original read codec set to PCMU:0 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5853 Set telephone-event payload to 101@8000 2021-01-13 08:12:00.801090 [DEBUG] switch_core_media.c:5911 sofia/default/9161626364@mobile.crestdial.com Set 2833 dtmf send payload to 101 recv payload to 101 2021-01-13 08:12:00.801090 [DEBUG] sofia.c:7760 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_NEW -> CS_INIT 2021-01-13 08:12:00.801090 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_INIT (Cur 1 Tot 410) 2021-01-13 08:12:00.801090 [DEBUG] switch_core_state_machine.c:628 (sofia/default/9161626364@mobile.crestdial.com) State INIT 2021-01-13 08:12:00.801090 [DEBUG] mod_sofia.c:93 sofia/default/9161626364@mobile.crestdial.com SOFIA INIT 2021-01-13 08:12:00.801090 [DEBUG] switch_core_state_machine.c:40 sofia/default/9161626364@mobile.crestdial.com Standard INIT 2021-01-13 08:12:00.801090 [DEBUG] switch_core_state_machine.c:48 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_INIT -> CS_ROUTING 2021-01-13 08:12:00.801090 [DEBUG] switch_core_state_machine.c:628 (sofia/default/9161626364@mobile.crestdial.com) State INIT going to sleep 2021-01-13 08:12:00.801090 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_ROUTING (Cur 1 Tot 410) 2021-01-13 08:12:00.801090 [DEBUG] switch_channel.c:2332 (sofia/default/9161626364@mobile.crestdial.com) Callstate Change DOWN -> RINGING 2021-01-13 08:12:00.801090 [DEBUG] switch_core_state_machine.c:644 (sofia/default/9161626364@mobile.crestdial.com) State ROUTING 2021-01-13 08:12:00.801090 [DEBUG] mod_sofia.c:154 sofia/default/9161626364@mobile.crestdial.com SOFIA ROUTING 2021-01-13 08:12:00.801090 [DEBUG] switch_core_state_machine.c:236 sofia/default/9161626364@mobile.crestdial.com Standard ROUTING 2021-01-13 08:12:00.801090 [INFO] mod_dialplan_xml.c:637 Processing 9161626364 <9161626364>->91212223 in context default 2021-01-13 08:12:00.821075 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2021-01-13 08:12:00.821075 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-01-13 08:12:00.821075 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Dialed number : 91212223 2021-01-13 08:12:00.821075 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '91212223' AND status=0 limit 1 2021-01-13 08:12:00.841085 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Caller Id name / number : 9161626364 / 9161626364 2021-01-13 08:12:00.841085 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="91212223" LIMIT 1 2021-01-13 08:12:00.841085 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="91212223" limit 1 2021-01-13 08:12:00.841085 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Call direction : local 2021-01-13 08:12:00.841085 [INFO] switch_cpp.cpp:1447 [ASTPP] [Accountcode : 9161626364] 2021-01-13 08:12:00.841085 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "9161626364" AND deleted = 0 limit 1 2021-01-13 08:12:01.301083 [DEBUG] switch_cpp.cpp:1447 [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 ="91212223" AND A.accountid = '57' limit 1 2021-01-13 08:12:01.301083 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 91212223 2021-01-13 08:12:01.301083 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="91212223" LIMIT 1 2021-01-13 08:12:01.301083 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="91212223" limit 1 2021-01-13 08:12:01.301083 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] New Call direction : local 2021-01-13 08:12:01.301083 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="91212223" AND (accountid = 0 OR status = 1) LIMIT 1 2021-01-13 08:12:01.301083 [NOTICE] switch_cpp.cpp:1447 [ASTPP] Localization Id: 1 2021-01-13 08:12:01.301083 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 1 AND status=0 limit 1 2021-01-13 08:12:01.301083 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE (patterns = '^91212223.*' OR patterns = '^9121222.*' OR patterns = '^912122.*' OR patterns = '^91212.*' OR patterns = '^9121.*' OR patterns = '^912.*' OR patterns = '^91.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 57 ORDER BY LENGTH(PKGPTR.patterns) DESC 2021-01-13 08:12:01.321116 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '91212223' OR number = '9121222' OR number = '912122' OR number = '91212' OR number = '9121' OR number = '912' OR number = '91' OR number = '9' OR number ='--') OR (number = '91212223*' OR number = '9121222*' OR number = '912122*' OR number = '91212*' OR number = '9121*' OR number = '912*' OR number = '91*' OR number = '9*' OR number ='--') OR (number = '9161626364' OR number = '916162636' OR number = '91616263' OR number = '9161626' OR number = '916162' OR number = '91616' OR number = '9161' OR number = '916' OR number = '91' OR number = '9' OR number ='--') OR (number = '9161626364*' OR number = '916162636*' OR number = '91616263*' OR number = '9161626*' OR number = '916162*' OR number = '91616*' OR number = '9161*' OR number = '916*' OR number = '91*' OR number = '9*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2021-01-13 08:12:01.321116 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Call Barring Status : -1 2021-01-13 08:12:01.321116 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '91212223' OR routing_prefix = '9121222' OR routing_prefix = '912122' OR routing_prefix = '91212' OR routing_prefix = '9121' OR routing_prefix = '912' OR routing_prefix = '91' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1 2021-01-13 08:12:01.321116 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Account Information =================== 2021-01-13 08:12:01.321116 [INFO] switch_cpp.cpp:1447 [ASTPP] User id : 57 2021-01-13 08:12:01.321116 [INFO] switch_cpp.cpp:1447 [ASTPP] Account code : 9161626364 2021-01-13 08:12:01.321116 [INFO] switch_cpp.cpp:1447 [ASTPP] Balance : 100 2021-01-13 08:12:01.321116 [INFO] switch_cpp.cpp:1447 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2021-01-13 08:12:01.321116 [INFO] switch_cpp.cpp:1447 [ASTPP] Ratecard id : 1 2021-01-13 08:12:01.321116 [INFO] switch_cpp.cpp:1447 [ASTPP] CID Pool : 0 2021-01-13 08:12:01.321116 [INFO] switch_cpp.cpp:1447 [ASTPP] ======================================================== 2021-01-13 08:12:01.321116 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0 2021-01-13 08:12:01.321116 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] free_inbound!!!1 2021-01-13 08:12:01.321116 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] charge_per_min!!!0 2021-01-13 08:12:01.321116 [INFO] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Your100 balance Accountid 57 !!! 2021-01-13 08:12:01.321116 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Call is free - assigning max length!!! :: 100 2021-01-13 08:12:01.321116 [INFO] switch_cpp.cpp:1447 [ASTPP] Call Max length duration : 100 minutes 2021-01-13 08:12:01.321116 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="91212223" limit 1 2021-01-13 08:12:01.321116 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 57 AND status=0 LIMIT 1 2021-01-13 08:12:01.321116 [INFO] switch_cpp.cpp:1447 [ASTPP] maxlength::::::::: 100 2021-01-13 08:12:01.321116 [ERR] mod_lua.cpp:202 /usr/share/freeswitch/scripts/astpp/scripts/astpp.xml.lua:467: attempt to concatenate global 'from_ip' (a nil value) stack traceback: /usr/share/freeswitch/scripts/astpp/scripts/astpp.xml.lua:467: in function 'freeswitch_xml_local' ...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:686: in main chunk [C]: in function 'dofile' /usr/share/freeswitch/scripts/astpp/astpp.lua:86: in main chunk 2021-01-13 08:12:01.321116 [ERR] mod_lua.cpp:270 LUA script parse/execute error! 2021-01-13 08:12:01.321116 [WARNING] mod_dialplan_xml.c:667 Context default not found 2021-01-13 08:12:01.321116 [INFO] switch_core_state_machine.c:312 No Route, Aborting 2021-01-13 08:12:01.321116 [NOTICE] switch_core_state_machine.c:313 Hangup sofia/default/9161626364@mobile.crestdial.com [CS_ROUTING] [NO_ROUTE_DESTINATION] 2021-01-13 08:12:01.321116 [DEBUG] switch_core_state_machine.c:644 (sofia/default/9161626364@mobile.crestdial.com) State ROUTING going to sleep 2021-01-13 08:12:01.321116 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_HANGUP (Cur 1 Tot 410) 2021-01-13 08:12:01.321116 [DEBUG] switch_core_state_machine.c:848 (sofia/default/9161626364@mobile.crestdial.com) Callstate Change RINGING -> HANGUP 2021-01-13 08:12:01.321116 [DEBUG] switch_core_state_machine.c:850 (sofia/default/9161626364@mobile.crestdial.com) State HANGUP 2021-01-13 08:12:01.321116 [DEBUG] mod_sofia.c:453 Channel sofia/default/9161626364@mobile.crestdial.com hanging up, cause: NO_ROUTE_DESTINATION 2021-01-13 08:12:01.321116 [DEBUG] mod_sofia.c:598 Responding to INVITE with: 404 2021-01-13 08:12:01.321116 [DEBUG] switch_core_state_machine.c:60 sofia/default/9161626364@mobile.crestdial.com Standard HANGUP, cause: NO_ROUTE_DESTINATION 2021-01-13 08:12:01.321116 [DEBUG] switch_core_state_machine.c:850 (sofia/default/9161626364@mobile.crestdial.com) State HANGUP going to sleep 2021-01-13 08:12:01.321116 [DEBUG] switch_core_state_machine.c:620 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_HANGUP -> CS_REPORTING 2021-01-13 08:12:01.321116 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_REPORTING (Cur 1 Tot 410) 2021-01-13 08:12:01.321116 [DEBUG] switch_core_state_machine.c:936 (sofia/default/9161626364@mobile.crestdial.com) State REPORTING 2021-01-13 08:12:01.321116 [INFO] mod_json_cdr.c:271 Process [61d58f69-e4f1-4391-a027-3aa364c6e0e9.cdr.json] 2021-01-13 08:12:01.341088 [DEBUG] switch_core_state_machine.c:174 sofia/default/9161626364@mobile.crestdial.com Standard REPORTING, cause: NO_ROUTE_DESTINATION 2021-01-13 08:12:01.341088 [DEBUG] switch_core_state_machine.c:936 (sofia/default/9161626364@mobile.crestdial.com) State REPORTING going to sleep 2021-01-13 08:12:01.341088 [DEBUG] switch_core_state_machine.c:611 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_REPORTING -> CS_DESTROY 2021-01-13 08:12:01.341088 [DEBUG] switch_core_session.c:1726 Session 410 (sofia/default/9161626364@mobile.crestdial.com) Locked, Waiting on external entities 2021-01-13 08:12:01.341088 [NOTICE] switch_core_session.c:1744 Session 410 (sofia/default/9161626364@mobile.crestdial.com) Ended 2021-01-13 08:12:01.341088 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/9161626364@mobile.crestdial.com [CS_DESTROY] 2021-01-13 08:12:01.341088 [DEBUG] switch_core_state_machine.c:739 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_DESTROY (Cur 0 Tot 410) 2021-01-13 08:12:01.341088 [DEBUG] switch_core_state_machine.c:749 (sofia/default/9161626364@mobile.crestdial.com) State DESTROY 2021-01-13 08:12:01.341088 [DEBUG] mod_sofia.c:364 sofia/default/9161626364@mobile.crestdial.com SOFIA DESTROY 2021-01-13 08:12:01.341088 [DEBUG] switch_core_state_machine.c:181 sofia/default/9161626364@mobile.crestdial.com Standard DESTROY 2021-01-13 08:12:01.341088 [DEBUG] switch_core_state_machine.c:749 (sofia/default/9161626364@mobile.crestdial.com) State DESTROY going to sleep 2021-01-13 08:12:44.381097 [NOTICE] switch_channel.c:1118 New Channel sofia/default/9161626364@mobile.crestdial.com [21dcd52f-78c2-4894-83f1-deeb9689ce9b] 2021-01-13 08:12:44.381097 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_NEW (Cur 1 Tot 411) 2021-01-13 08:12:44.381097 [DEBUG] sofia.c:10280 sofia/default/9161626364@mobile.crestdial.com receiving invite from 185.117.83.202:25080 version: 1.10.5 -release-17-25569c1631 64bit 2021-01-13 08:12:44.381097 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 185.117.83.202:0. 2021-01-13 08:12:44.381097 [DEBUG] sofia.c:2434 detaching session 21dcd52f-78c2-4894-83f1-deeb9689ce9b 2021-01-13 08:12:44.381097 [WARNING] sofia_reg.c:1794 SIP auth challenge (INVITE) on sofia profile 'default' for [91212223@mobile.crestdial.com] from ip 185.117.83.202 2021-01-13 08:12:44.381097 [DEBUG] switch_core_state_machine.c:604 (sofia/default/9161626364@mobile.crestdial.com) State NEW 2021-01-13 08:12:44.981098 [DEBUG] sofia.c:2544 Re-attaching to session 21dcd52f-78c2-4894-83f1-deeb9689ce9b 2021-01-13 08:12:45.001105 [DEBUG] sofia.c:10280 sofia/default/9161626364@mobile.crestdial.com receiving invite from 185.117.83.202:25080 version: 1.10.5 -release-17-25569c1631 64bit 2021-01-13 08:12:45.001105 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 185.117.83.202:0. 2021-01-13 08:12:45.001105 [DEBUG] sofia.c:7326 Channel sofia/default/9161626364@mobile.crestdial.com entering state [received][100] 2021-01-13 08:12:45.001105 [DEBUG] sofia.c:7336 Remote SDP: v=0 o=Zoiper 1610525563343 1 IN IP4 42.106.26.11 s=Z c=IN IP4 42.106.26.11 t=0 0 m=audio 15738 RTP/AVP 106 9 98 101 0 8 18 3 a=rtpmap:106 opus/48000/2 a=fmtp:106 sprop-maxcapturerate=16000; minptime=20; useinbandfec=1 a=rtpmap:98 telephone-event/48000 a=fmtp:98 0-16 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5510 Set telephone-event payload to 98@48000 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1] 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1] 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:3839 Set Codec sofia/default/9161626364@mobile.crestdial.com PCMU/8000 20 ms 160 samples 64000 bits 1 channels 2021-01-13 08:12:45.001105 [DEBUG] switch_core_codec.c:111 sofia/default/9161626364@mobile.crestdial.com Original read codec set to PCMU:0 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5853 Set telephone-event payload to 101@8000 2021-01-13 08:12:45.001105 [DEBUG] switch_core_media.c:5911 sofia/default/9161626364@mobile.crestdial.com Set 2833 dtmf send payload to 101 recv payload to 101 2021-01-13 08:12:45.001105 [DEBUG] sofia.c:7760 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_NEW -> CS_INIT 2021-01-13 08:12:45.001105 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_INIT (Cur 1 Tot 411) 2021-01-13 08:12:45.001105 [DEBUG] switch_core_state_machine.c:628 (sofia/default/9161626364@mobile.crestdial.com) State INIT 2021-01-13 08:12:45.001105 [DEBUG] mod_sofia.c:93 sofia/default/9161626364@mobile.crestdial.com SOFIA INIT 2021-01-13 08:12:45.001105 [DEBUG] switch_core_state_machine.c:40 sofia/default/9161626364@mobile.crestdial.com Standard INIT 2021-01-13 08:12:45.001105 [DEBUG] switch_core_state_machine.c:48 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_INIT -> CS_ROUTING 2021-01-13 08:12:45.001105 [DEBUG] switch_core_state_machine.c:628 (sofia/default/9161626364@mobile.crestdial.com) State INIT going to sleep 2021-01-13 08:12:45.001105 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_ROUTING (Cur 1 Tot 411) 2021-01-13 08:12:45.001105 [DEBUG] switch_channel.c:2332 (sofia/default/9161626364@mobile.crestdial.com) Callstate Change DOWN -> RINGING 2021-01-13 08:12:45.001105 [DEBUG] switch_core_state_machine.c:644 (sofia/default/9161626364@mobile.crestdial.com) State ROUTING 2021-01-13 08:12:45.001105 [DEBUG] mod_sofia.c:154 sofia/default/9161626364@mobile.crestdial.com SOFIA ROUTING 2021-01-13 08:12:45.001105 [DEBUG] switch_core_state_machine.c:236 sofia/default/9161626364@mobile.crestdial.com Standard ROUTING 2021-01-13 08:12:45.001105 [INFO] mod_dialplan_xml.c:637 Processing 9161626364 <9161626364>->91212223 in context default 2021-01-13 08:12:45.001105 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2021-01-13 08:12:45.021081 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-01-13 08:12:45.021081 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Dialed number : 91212223 2021-01-13 08:12:45.021081 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '91212223' AND status=0 limit 1 2021-01-13 08:12:45.021081 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Caller Id name / number : 9161626364 / 9161626364 2021-01-13 08:12:45.021081 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="91212223" LIMIT 1 2021-01-13 08:12:45.021081 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="91212223" limit 1 2021-01-13 08:12:45.021081 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Call direction : local 2021-01-13 08:12:45.021081 [INFO] switch_cpp.cpp:1447 [ASTPP] [Accountcode : 9161626364] 2021-01-13 08:12:45.021081 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "9161626364" AND deleted = 0 limit 1 2021-01-13 08:12:45.041076 [DEBUG] switch_cpp.cpp:1447 [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 ="91212223" AND A.accountid = '57' limit 1 2021-01-13 08:12:45.041076 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 91212223 2021-01-13 08:12:45.041076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="91212223" LIMIT 1 2021-01-13 08:12:45.041076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="91212223" limit 1 2021-01-13 08:12:45.041076 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] New Call direction : local 2021-01-13 08:12:45.041076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="91212223" AND (accountid = 0 OR status = 1) LIMIT 1 2021-01-13 08:12:45.041076 [NOTICE] switch_cpp.cpp:1447 [ASTPP] Localization Id: 1 2021-01-13 08:12:45.041076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 1 AND status=0 limit 1 2021-01-13 08:12:45.041076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE (patterns = '^91212223.*' OR patterns = '^9121222.*' OR patterns = '^912122.*' OR patterns = '^91212.*' OR patterns = '^9121.*' OR patterns = '^912.*' OR patterns = '^91.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 57 ORDER BY LENGTH(PKGPTR.patterns) DESC 2021-01-13 08:12:45.041076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '91212223' OR number = '9121222' OR number = '912122' OR number = '91212' OR number = '9121' OR number = '912' OR number = '91' OR number = '9' OR number ='--') OR (number = '91212223*' OR number = '9121222*' OR number = '912122*' OR number = '91212*' OR number = '9121*' OR number = '912*' OR number = '91*' OR number = '9*' OR number ='--') OR (number = '9161626364' OR number = '916162636' OR number = '91616263' OR number = '9161626' OR number = '916162' OR number = '91616' OR number = '9161' OR number = '916' OR number = '91' OR number = '9' OR number ='--') OR (number = '9161626364*' OR number = '916162636*' OR number = '91616263*' OR number = '9161626*' OR number = '916162*' OR number = '91616*' OR number = '9161*' OR number = '916*' OR number = '91*' OR number = '9*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2021-01-13 08:12:45.041076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Call Barring Status : -1 2021-01-13 08:12:45.041076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '91212223' OR routing_prefix = '9121222' OR routing_prefix = '912122' OR routing_prefix = '91212' OR routing_prefix = '9121' OR routing_prefix = '912' OR routing_prefix = '91' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1 2021-01-13 08:12:45.041076 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Account Information =================== 2021-01-13 08:12:45.041076 [INFO] switch_cpp.cpp:1447 [ASTPP] User id : 57 2021-01-13 08:12:45.041076 [INFO] switch_cpp.cpp:1447 [ASTPP] Account code : 9161626364 2021-01-13 08:12:45.041076 [INFO] switch_cpp.cpp:1447 [ASTPP] Balance : 100 2021-01-13 08:12:45.041076 [INFO] switch_cpp.cpp:1447 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2021-01-13 08:12:45.041076 [INFO] switch_cpp.cpp:1447 [ASTPP] Ratecard id : 1 2021-01-13 08:12:45.041076 [INFO] switch_cpp.cpp:1447 [ASTPP] CID Pool : 0 2021-01-13 08:12:45.041076 [INFO] switch_cpp.cpp:1447 [ASTPP] ======================================================== 2021-01-13 08:12:45.041076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0 2021-01-13 08:12:45.041076 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] free_inbound!!!1 2021-01-13 08:12:45.041076 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] charge_per_min!!!0 2021-01-13 08:12:45.041076 [INFO] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Your100 balance Accountid 57 !!! 2021-01-13 08:12:45.041076 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Call is free - assigning max length!!! :: 100 2021-01-13 08:12:45.041076 [INFO] switch_cpp.cpp:1447 [ASTPP] Call Max length duration : 100 minutes 2021-01-13 08:12:45.041076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="91212223" limit 1 2021-01-13 08:12:45.041076 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 57 AND status=0 LIMIT 1 2021-01-13 08:12:45.041076 [INFO] switch_cpp.cpp:1447 [ASTPP] maxlength::::::::: 100 2021-01-13 08:12:45.041076 [ERR] mod_lua.cpp:202 /usr/share/freeswitch/scripts/astpp/scripts/astpp.xml.lua:467: attempt to concatenate global 'from_ip' (a nil value) stack traceback: /usr/share/freeswitch/scripts/astpp/scripts/astpp.xml.lua:467: in function 'freeswitch_xml_local' ...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:686: in main chunk [C]: in function 'dofile' /usr/share/freeswitch/scripts/astpp/astpp.lua:86: in main chunk 2021-01-13 08:12:45.041076 [ERR] mod_lua.cpp:270 LUA script parse/execute error! 2021-01-13 08:12:45.041076 [WARNING] mod_dialplan_xml.c:667 Context default not found 2021-01-13 08:12:45.041076 [INFO] switch_core_state_machine.c:312 No Route, Aborting 2021-01-13 08:12:45.041076 [NOTICE] switch_core_state_machine.c:313 Hangup sofia/default/9161626364@mobile.crestdial.com [CS_ROUTING] [NO_ROUTE_DESTINATION] 2021-01-13 08:12:45.041076 [DEBUG] switch_core_state_machine.c:644 (sofia/default/9161626364@mobile.crestdial.com) State ROUTING going to sleep 2021-01-13 08:12:45.041076 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_HANGUP (Cur 1 Tot 411) 2021-01-13 08:12:45.041076 [DEBUG] switch_core_state_machine.c:848 (sofia/default/9161626364@mobile.crestdial.com) Callstate Change RINGING -> HANGUP 2021-01-13 08:12:45.041076 [DEBUG] switch_core_state_machine.c:850 (sofia/default/9161626364@mobile.crestdial.com) State HANGUP 2021-01-13 08:12:45.041076 [DEBUG] mod_sofia.c:453 Channel sofia/default/9161626364@mobile.crestdial.com hanging up, cause: NO_ROUTE_DESTINATION 2021-01-13 08:12:45.041076 [DEBUG] mod_sofia.c:598 Responding to INVITE with: 404 2021-01-13 08:12:45.041076 [DEBUG] switch_core_state_machine.c:60 sofia/default/9161626364@mobile.crestdial.com Standard HANGUP, cause: NO_ROUTE_DESTINATION 2021-01-13 08:12:45.041076 [DEBUG] switch_core_state_machine.c:850 (sofia/default/9161626364@mobile.crestdial.com) State HANGUP going to sleep 2021-01-13 08:12:45.041076 [DEBUG] switch_core_state_machine.c:620 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_HANGUP -> CS_REPORTING 2021-01-13 08:12:45.041076 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_REPORTING (Cur 1 Tot 411) 2021-01-13 08:12:45.041076 [DEBUG] switch_core_state_machine.c:936 (sofia/default/9161626364@mobile.crestdial.com) State REPORTING 2021-01-13 08:12:45.041076 [INFO] mod_json_cdr.c:271 Process [21dcd52f-78c2-4894-83f1-deeb9689ce9b.cdr.json] 2021-01-13 08:12:45.061113 [DEBUG] switch_core_state_machine.c:174 sofia/default/9161626364@mobile.crestdial.com Standard REPORTING, cause: NO_ROUTE_DESTINATION 2021-01-13 08:12:45.061113 [DEBUG] switch_core_state_machine.c:936 (sofia/default/9161626364@mobile.crestdial.com) State REPORTING going to sleep 2021-01-13 08:12:45.061113 [DEBUG] switch_core_state_machine.c:611 (sofia/default/9161626364@mobile.crestdial.com) State Change CS_REPORTING -> CS_DESTROY 2021-01-13 08:12:45.061113 [DEBUG] switch_core_session.c:1726 Session 411 (sofia/default/9161626364@mobile.crestdial.com) Locked, Waiting on external entities 2021-01-13 08:12:45.061113 [NOTICE] switch_core_session.c:1744 Session 411 (sofia/default/9161626364@mobile.crestdial.com) Ended 2021-01-13 08:12:45.061113 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/9161626364@mobile.crestdial.com [CS_DESTROY] 2021-01-13 08:12:45.061113 [DEBUG] switch_core_state_machine.c:739 (sofia/default/9161626364@mobile.crestdial.com) Running State Change CS_DESTROY (Cur 0 Tot 411) 2021-01-13 08:12:45.061113 [DEBUG] switch_core_state_machine.c:749 (sofia/default/9161626364@mobile.crestdial.com) State DESTROY 2021-01-13 08:12:45.061113 [DEBUG] mod_sofia.c:364 sofia/default/9161626364@mobile.crestdial.com SOFIA DESTROY 2021-01-13 08:12:45.061113 [DEBUG] switch_core_state_machine.c:181 sofia/default/9161626364@mobile.crestdial.com Standard DESTROY 2021-01-13 08:12:45.061113 [DEBUG] switch_core_state_machine.c:749 (sofia/default/9161626364@mobile.crestdial.com) State DESTROY going to sleep