span style="color: cornflowerblue; font-weight: bold;"> 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