2022-02-11 07:40:43.481316 98.80% [NOTICE] switch_channel.c:1123 New Channel sofia/default/8741933851@w02version62.astppbilling.org:5074 [e6061c01-9c82-4591-b0da-8d24afe09001] 2022-02-11 07:40:43.481316 98.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8741933851@w02version62.astppbilling.org:5074) Running State Change CS_NEW (Cur 1 Tot 16) 2022-02-11 07:40:43.481316 98.80% [INFO] sofia.c:10462 sofia/default/8741933851@w02version62.astppbilling.org:5074 receiving invite from 150.129.107.251:53170 version: 1.10.7 -release-19-883d2cb662 64bit call-id: kWmCPUI-tMTUnQ_IEKFn5Q.. 2022-02-11 07:40:43.481316 98.80% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 150.129.107.251:0. 2022-02-11 07:40:43.481316 98.80% [DEBUG] sofia.c:2419 detaching session e6061c01-9c82-4591-b0da-8d24afe09001 2022-02-11 07:40:43.481316 98.80% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [1997940044@w02version62.astppbilling.org] from ip 150.129.107.251 2022-02-11 07:40:43.481316 98.80% [DEBUG] switch_core_state_machine.c:600 (sofia/default/8741933851@w02version62.astppbilling.org:5074) State NEW 2022-02-11 07:40:43.561322 98.80% [DEBUG] sofia.c:2532 Re-attaching to session e6061c01-9c82-4591-b0da-8d24afe09001 2022-02-11 07:40:43.581335 98.80% [INFO] sofia.c:10462 sofia/default/8741933851@w02version62.astppbilling.org:5074 receiving invite from 150.129.107.251:53170 version: 1.10.7 -release-19-883d2cb662 64bit call-id: kWmCPUI-tMTUnQ_IEKFn5Q.. 2022-02-11 07:40:43.581335 98.80% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 150.129.107.251:0. 2022-02-11 07:40:43.601298 98.80% [DEBUG] sofia.c:11672 Setting NAT mode based on via port 2022-02-11 07:40:43.601298 98.80% [DEBUG] sofia.c:7499 Channel sofia/default/8741933851@w02version62.astppbilling.org:5074 entering state [received][100] 2022-02-11 07:40:43.601298 98.80% [DEBUG] sofia.c:7509 Remote SDP: v=0 o=Z 0 0 IN IP4 150.129.107.251 s=Z c=IN IP4 150.129.107.251 t=0 0 m=audio 8000 RTP/AVP 3 110 8 0 97 101 a=rtpmap:110 speex/8000 a=rtpmap:97 iLBC/8000 a=fmtp:97 mode=30 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1] 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1] 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMA:8:8000:20:64000:1] 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMU:0:8000:20:64000:1] 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:97:8000:30:0:1]/[PCMA:8:8000:20:64000:1] 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:97:8000:30:0:1]/[PCMU:0:8000:20:64000:1] 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/8741933851@w02version62.astppbilling.org:5074 PCMA/8000 20 ms 160 samples 64000 bits 1 channels 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_codec.c:111 sofia/default/8741933851@w02version62.astppbilling.org:5074 Original read codec set to PCMA:8 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_media.c:5973 sofia/default/8741933851@w02version62.astppbilling.org:5074 Set 2833 dtmf send payload to 101 recv payload to 101 2022-02-11 07:40:43.601298 98.80% [DEBUG] sofia.c:7933 (sofia/default/8741933851@w02version62.astppbilling.org:5074) State Change CS_NEW -> CS_INIT 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8741933851@w02version62.astppbilling.org:5074) Running State Change CS_INIT (Cur 1 Tot 16) 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_state_machine.c:624 (sofia/default/8741933851@w02version62.astppbilling.org:5074) State INIT 2022-02-11 07:40:43.601298 98.80% [DEBUG] mod_sofia.c:97 sofia/default/8741933851@w02version62.astppbilling.org:5074 SOFIA INIT 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_state_machine.c:40 sofia/default/8741933851@w02version62.astppbilling.org:5074 Standard INIT 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_state_machine.c:48 (sofia/default/8741933851@w02version62.astppbilling.org:5074) State Change CS_INIT -> CS_ROUTING 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_state_machine.c:624 (sofia/default/8741933851@w02version62.astppbilling.org:5074) State INIT going to sleep 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8741933851@w02version62.astppbilling.org:5074) Running State Change CS_ROUTING (Cur 1 Tot 16) 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_channel.c:2380 (sofia/default/8741933851@w02version62.astppbilling.org:5074) Callstate Change DOWN -> RINGING 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8741933851@w02version62.astppbilling.org:5074) State ROUTING 2022-02-11 07:40:43.601298 98.80% [DEBUG] mod_sofia.c:158 sofia/default/8741933851@w02version62.astppbilling.org:5074 SOFIA ROUTING 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_core_state_machine.c:230 sofia/default/8741933851@w02version62.astppbilling.org:5074 Standard ROUTING 2022-02-11 07:40:43.601298 98.80% [INFO] mod_dialplan_xml.c:639 Processing 8741933851 <8741933851>->1997940044 in context default 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code') 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-02-11 07:40:43.601298 98.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0 2022-02-11 07:40:43.601298 98.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 1997940044 2022-02-11 07:40:43.601298 98.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '1997940044' limit 1 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '1997940044' AND status=0 limit 1 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '1997940044' and status=0 LIMIT 1 2022-02-11 07:40:43.621294 98.80% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER8741933851 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'w02version62.astppbilling.org' limit 1 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '4' and username = '1997940044' limit 1 2022-02-11 07:40:43.621294 98.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 8741933851 / 8741933851 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 40044 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 19979 limit 1 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_per_accountid_info] Query :SELECT domain FROM domains WHERE accountid = limit 1 2022-02-11 07:40:43.621294 98.80% [ERR] switch_core_sqldb.c:1310 ERR: [SELECT domain FROM domains WHERE accountid = limit 1] [STATE: 42000 CODE 1064 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.25]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 1' at line 1 ] 2022-02-11 07:40:43.621294 98.80% [ERR] mod_lua.cpp:202 ...itch/scripts/astpp/lib/addons/astpp.interconnectcode.lua:24: assertion failed! stack traceback: [C]: in function 'assert' ...itch/scripts/astpp/lib/addons/astpp.interconnectcode.lua:24: in function 'get_interconnectcode_info' ...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:190: in main chunk [C]: in function 'dofile' /usr/share/freeswitch/scripts/astpp/astpp.lua:94: in main chunk 2022-02-11 07:40:43.621294 98.80% [ERR] mod_lua.cpp:270 LUA script parse/execute error! 2022-02-11 07:40:43.621294 98.80% [WARNING] mod_dialplan_xml.c:669 Context default not found 2022-02-11 07:40:43.621294 98.80% [INFO] switch_core_state_machine.c:306 No Route, Aborting 2022-02-11 07:40:43.621294 98.80% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/8741933851@w02version62.astppbilling.org:5074 [CS_ROUTING] [NO_ROUTE_DESTINATION] 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8741933851@w02version62.astppbilling.org:5074) State ROUTING going to sleep 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8741933851@w02version62.astppbilling.org:5074) Running State Change CS_HANGUP (Cur 1 Tot 16) 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_core_state_machine.c:844 (sofia/default/8741933851@w02version62.astppbilling.org:5074) Callstate Change RINGING -> HANGUP 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_core_state_machine.c:846 (sofia/default/8741933851@w02version62.astppbilling.org:5074) State HANGUP 2022-02-11 07:40:43.621294 98.80% [DEBUG] mod_sofia.c:468 Channel sofia/default/8741933851@w02version62.astppbilling.org:5074 hanging up, cause: NO_ROUTE_DESTINATION 2022-02-11 07:40:43.621294 98.80% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_core_state_machine.c:59 sofia/default/8741933851@w02version62.astppbilling.org:5074 Standard HANGUP, cause: NO_ROUTE_DESTINATION 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_core_state_machine.c:846 (sofia/default/8741933851@w02version62.astppbilling.org:5074) State HANGUP going to sleep 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_core_state_machine.c:616 (sofia/default/8741933851@w02version62.astppbilling.org:5074) State Change CS_HANGUP -> CS_REPORTING 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8741933851@w02version62.astppbilling.org:5074) Running State Change CS_REPORTING (Cur 1 Tot 16) 2022-02-11 07:40:43.621294 98.80% [DEBUG] switch_core_state_machine.c:932 (sofia/default/8741933851@w02version62.astppbilling.org:5074) State REPORTING 2022-02-11 07:40:43.621294 98.80% [INFO] mod_json_cdr.c:271 Process [e6061c01-9c82-4591-b0da-8d24afe09001.cdr.json] 2022-02-11 07:40:43.641297 98.80% [DEBUG] switch_core_state_machine.c:168 sofia/default/8741933851@w02version62.astppbilling.org:5074 Standard REPORTING, cause: NO_ROUTE_DESTINATION 2022-02-11 07:40:43.641297 98.80% [DEBUG] switch_core_state_machine.c:932 (sofia/default/8741933851@w02version62.astppbilling.org:5074) State REPORTING going to sleep 2022-02-11 07:40:43.641297 98.80% [DEBUG] switch_core_state_machine.c:607 (sofia/default/8741933851@w02version62.astppbilling.org:5074) State Change CS_REPORTING -> CS_DESTROY 2022-02-11 07:40:43.641297 98.80% [DEBUG] switch_core_session.c:1753 Session 16 (sofia/default/8741933851@w02version62.astppbilling.org:5074) Locked, Waiting on external entities 2022-02-11 07:40:43.641297 98.80% [NOTICE] switch_core_session.c:1771 Session 16 (sofia/default/8741933851@w02version62.astppbilling.org:5074) Ended 2022-02-11 07:40:43.641297 98.80% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/8741933851@w02version62.astppbilling.org:5074 [CS_DESTROY] 2022-02-11 07:40:43.641297 98.80% [DEBUG] switch_core_state_machine.c:735 (sofia/default/8741933851@w02version62.astppbilling.org:5074) Running State Change CS_DESTROY (Cur 0 Tot 16) 2022-02-11 07:40:43.641297 98.80% [DEBUG] switch_core_state_machine.c:745 (sofia/default/8741933851@w02version62.astppbilling.org:5074) State DESTROY 2022-02-11 07:40:43.641297 98.80% [DEBUG] mod_sofia.c:379 sofia/default/8741933851@w02version62.astppbilling.org:5074 SOFIA DESTROY 2022-02-11 07:40:43.641297 98.80% [DEBUG] switch_core_state_machine.c:175 sofia/default/8741933851@w02version62.astppbilling.org:5074 Standard DESTROY 2022-02-11 07:40:43.641297 98.80% [DEBUG] switch_core_state_machine.c:745 (sofia/default/8741933851@w02version62.astppbilling.org:5074) State DESTROY going to sleep