span style="color: goldenrod; font-weight: bold;"> 2022-10-03 12:49:03.188834 76.47% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
2022-10-03 12:49:03.208900 76.47% [NOTICE] switch_channel.c:1123 New Channel sofia/default/1515121325@172.31.40.49:5074 [91d771dc-94b0-4ecb-9ce3-929e0cb7ec7e]
2022-10-03 12:49:03.208900 76.47% [DEBUG] mod_sofia.c:5121 (sofia/default/1515121325@172.31.40.49:5074) State Change CS_NEW -> CS_INIT
2022-10-03 12:49:03.208900 76.47% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1515121325@172.31.40.49:5074) Running State Change CS_INIT (Cur 1 Tot 178)
2022-10-03 12:49:03.208900 76.47% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1515121325@172.31.40.49:5074) State INIT
2022-10-03 12:49:03.208900 76.47% [DEBUG] mod_sofia.c:97 sofia/default/1515121325@172.31.40.49:5074 SOFIA INIT
2022-10-03 12:49:03.208900 76.47% [INFO] sofia_glue.c:1651 sofia/default/1515121325@172.31.40.49:5074 sending invite call-id: (null)
2022-10-03 12:49:03.208900 76.47% [DEBUG] sofia_glue.c:1654 sofia/default/1515121325@172.31.40.49:5074 sending invite version: 1.10.7 -release-19-883d2cb662 64bit
Local SDP:
v=0
o=FreeSWITCH 1664769281 1664769282 IN IP4 172.31.40.49
s=FreeSWITCH
c=IN IP4 172.31.40.49
t=0 0
m=audio 32062 RTP/AVP 8 0 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
a=sendrecv
2022-10-03 12:49:03.208900 76.47% [DEBUG] switch_core_state_machine.c:40 sofia/default/1515121325@172.31.40.49:5074 Standard INIT
2022-10-03 12:49:03.208900 76.47% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1515121325@172.31.40.49:5074) State Change CS_INIT -> CS_ROUTING
2022-10-03 12:49:03.208900 76.47% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1515121325@172.31.40.49:5074) State INIT going to sleep
2022-10-03 12:49:03.208900 76.47% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1515121325@172.31.40.49:5074) Running State Change CS_ROUTING (Cur 1 Tot 178)
2022-10-03 12:49:03.208900 76.47% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1515121325@172.31.40.49:5074) State ROUTING
2022-10-03 12:49:03.208900 76.47% [DEBUG] mod_sofia.c:158 sofia/default/1515121325@172.31.40.49:5074 SOFIA ROUTING
2022-10-03 12:49:03.208900 76.47% [DEBUG] switch_ivr_originate.c:67 (sofia/default/1515121325@172.31.40.49:5074) State Change CS_ROUTING -> CS_CONSUME_MEDIA
2022-10-03 12:49:03.208900 76.47% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1515121325@172.31.40.49:5074) State ROUTING going to sleep
2022-10-03 12:49:03.208900 76.47% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1515121325@172.31.40.49:5074) Running State Change CS_CONSUME_MEDIA (Cur 1 Tot 178)
2022-10-03 12:49:03.208900 76.47% [DEBUG] switch_core_state_machine.c:659 (sofia/default/1515121325@172.31.40.49:5074) State CONSUME_MEDIA
2022-10-03 12:49:03.208900 76.47% [DEBUG] switch_core_state_machine.c:659 (sofia/default/1515121325@172.31.40.49:5074) State CONSUME_MEDIA going to sleep
2022-10-03 12:49:03.208900 76.47% [DEBUG] sofia.c:7499 Channel sofia/default/1515121325@172.31.40.49:5074 entering state [calling][0]
2022-10-03 12:49:03.208900 76.47% [NOTICE] switch_channel.c:1123 New Channel sofia/default/1515121325@172.31.40.49 [28262aab-007e-4552-ac2f-c6b654a059ac]
2022-10-03 12:49:03.208900 76.47% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1515121325@172.31.40.49) Running State Change CS_NEW (Cur 2 Tot 179)
2022-10-03 12:49:03.208900 76.47% [INFO] sofia.c:10462 sofia/default/1515121325@172.31.40.49 receiving invite from 172.31.40.49:5074 version: 1.10.7 -release-19-883d2cb662 64bit call-id: 99b6e811-bdbc-123b-66b8-026398ac7998
2022-10-03 12:49:03.208900 76.47% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 172.31.40.49:0.
2022-10-03 12:49:03.228829 76.47% [DEBUG] sofia.c:11672 Setting NAT mode based on via received
2022-10-03 12:49:03.228829 76.47% [DEBUG] sofia.c:7499 Channel sofia/default/1515121325@172.31.40.49 entering state [received][100]
2022-10-03 12:49:03.228829 76.47% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=FreeSWITCH 1664769281 1664769282 IN IP4 172.31.40.49
s=FreeSWITCH
c=IN IP4 172.31.40.49
t=0 0
m=audio 32062 RTP/AVP 8 0 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/1515121325@172.31.40.49 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_codec.c:111 sofia/default/1515121325@172.31.40.49 Original read codec set to PCMA:8
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_media.c:5973 sofia/default/1515121325@172.31.40.49 Set 2833 dtmf send payload to 101 recv payload to 101
2022-10-03 12:49:03.228829 76.47% [DEBUG] sofia.c:7933 (sofia/default/1515121325@172.31.40.49) State Change CS_NEW -> CS_INIT
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_state_machine.c:600 (sofia/default/1515121325@172.31.40.49) State NEW
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1515121325@172.31.40.49) Running State Change CS_INIT (Cur 2 Tot 179)
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1515121325@172.31.40.49) State INIT
2022-10-03 12:49:03.228829 76.47% [DEBUG] mod_sofia.c:97 sofia/default/1515121325@172.31.40.49 SOFIA INIT
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_state_machine.c:40 sofia/default/1515121325@172.31.40.49 Standard INIT
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1515121325@172.31.40.49) State Change CS_INIT -> CS_ROUTING
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1515121325@172.31.40.49) State INIT going to sleep
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1515121325@172.31.40.49) Running State Change CS_ROUTING (Cur 2 Tot 179)
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_channel.c:2380 (sofia/default/1515121325@172.31.40.49) Callstate Change DOWN -> RINGING
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1515121325@172.31.40.49) State ROUTING
2022-10-03 12:49:03.228829 76.47% [DEBUG] mod_sofia.c:158 sofia/default/1515121325@172.31.40.49 SOFIA ROUTING
2022-10-03 12:49:03.228829 76.47% [DEBUG] switch_core_state_machine.c:230 sofia/default/1515121325@172.31.40.49 Standard ROUTING
2022-10-03 12:49:03.228829 76.47% [INFO] mod_dialplan_xml.c:639 Processing 9497482480 <1515121325>->1515121325 in context default
2022-10-03 12:49:03.288877 76.47% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
2022-10-03 12:49:03.288877 76.47% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2022-10-03 12:49:03.328834 76.47% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 1515121325
2022-10-03 12:49:03.328834 76.47% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Clicktocall Destination Number 1515121325
2022-10-03 12:49:03.328834 76.47% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '1515121325' AND status=0 limit 1
2022-10-03 12:49:03.328834 76.47% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 9497482480 / 1515121325
2022-10-03 12:49:03.328834 76.47% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1515121325" LIMIT 1
2022-10-03 12:49:03.328834 76.47% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="1515121325" limit 1
2022-10-03 12:49:03.328834 76.47% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
2022-10-03 12:49:03.328834 76.47% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("172.31.40.49") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "1515121325" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
2022-10-03 12:49:03.348863 76.47% [ERR] switch_core_sqldb.c:1310 ERR: [SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("172.31.40.49") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "1515121325" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1]
[STATE: HY000 CODE 1690 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.30]BIGINT UNSIGNED value is out of range in '((0x01 << (32 - substring_index(`astpp`.`ip_map`.`ip`,'/',<cache>(-(1))))) - 1)'
]
2022-10-03 12:49:03.348863 76.47% [ERR] mod_lua.cpp:202 /usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:154: assertion failed!
stack traceback:
[C]: in function 'assert'
/usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:154: in function </usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:150>
(...tail calls...)
...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:119: in main chunk
[C]: in function 'dofile'
/usr/share/freeswitch/scripts/astpp/astpp.lua:85: in main chunk
2022-10-03 12:49:03.348863 76.47% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
2022-10-03 12:49:03.348863 76.47% [WARNING] mod_dialplan_xml.c:669 Context default not found
2022-10-03 12:49:03.348863 76.47% [INFO] switch_core_state_machine.c:306 No Route, Aborting
2022-10-03 12:49:03.348863 76.47% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/1515121325@172.31.40.49 [CS_ROUTING] [NO_ROUTE_DESTINATION]
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1515121325@172.31.40.49) State ROUTING going to sleep
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1515121325@172.31.40.49) Running State Change CS_HANGUP (Cur 2 Tot 179)
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1515121325@172.31.40.49) Callstate Change RINGING -> HANGUP
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1515121325@172.31.40.49) State HANGUP
2022-10-03 12:49:03.348863 76.47% [DEBUG] mod_sofia.c:468 Channel sofia/default/1515121325@172.31.40.49 hanging up, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:03.348863 76.47% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:59 sofia/default/1515121325@172.31.40.49 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1515121325@172.31.40.49) State HANGUP going to sleep
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1515121325@172.31.40.49) State Change CS_HANGUP -> CS_REPORTING
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1515121325@172.31.40.49) Running State Change CS_REPORTING (Cur 2 Tot 179)
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1515121325@172.31.40.49) State REPORTING
2022-10-03 12:49:03.348863 76.47% [DEBUG] sofia.c:6678 Remote Reason: 3
2022-10-03 12:49:03.348863 76.47% [DEBUG] sofia.c:7499 Channel sofia/default/1515121325@172.31.40.49:5074 entering state [terminated][404]
2022-10-03 12:49:03.348863 76.47% [NOTICE] sofia.c:8738 Hangup sofia/default/1515121325@172.31.40.49:5074 [CS_CONSUME_MEDIA] [NO_ROUTE_DESTINATION]
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1515121325@172.31.40.49:5074) Running State Change CS_HANGUP (Cur 2 Tot 179)
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1515121325@172.31.40.49:5074) Callstate Change DOWN -> HANGUP
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1515121325@172.31.40.49:5074) State HANGUP
2022-10-03 12:49:03.348863 76.47% [DEBUG] mod_sofia.c:468 Channel sofia/default/1515121325@172.31.40.49:5074 hanging up, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:59 sofia/default/1515121325@172.31.40.49:5074 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1515121325@172.31.40.49:5074) State HANGUP going to sleep
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1515121325@172.31.40.49:5074) State Change CS_HANGUP -> CS_REPORTING
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1515121325@172.31.40.49:5074) Running State Change CS_REPORTING (Cur 2 Tot 179)
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1515121325@172.31.40.49:5074) State REPORTING
2022-10-03 12:49:03.348863 76.47% [DEBUG] switch_ivr_originate.c:4035 Originate Resulted in Error Cause: 3 [NO_ROUTE_DESTINATION]
2022-10-03 12:49:03.348863 76.47% [INFO] mod_json_cdr.c:271 Process [28262aab-007e-4552-ac2f-c6b654a059ac.cdr.json]
2022-10-03 12:49:03.348863 76.47% [INFO] mod_json_cdr.c:271 Process [91d771dc-94b0-4ecb-9ce3-929e0cb7ec7e.cdr.json]
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_state_machine.c:168 sofia/default/1515121325@172.31.40.49:5074 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1515121325@172.31.40.49:5074) State REPORTING going to sleep
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_state_machine.c:607 (sofia/default/1515121325@172.31.40.49:5074) State Change CS_REPORTING -> CS_DESTROY
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_session.c:1753 Session 178 (sofia/default/1515121325@172.31.40.49:5074) Locked, Waiting on external entities
2022-10-03 12:49:03.368838 76.47% [NOTICE] switch_core_session.c:1771 Session 178 (sofia/default/1515121325@172.31.40.49:5074) Ended
2022-10-03 12:49:03.368838 76.47% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/1515121325@172.31.40.49:5074 [CS_DESTROY]
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_state_machine.c:735 (sofia/default/1515121325@172.31.40.49:5074) Running State Change CS_DESTROY (Cur 1 Tot 179)
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1515121325@172.31.40.49:5074) State DESTROY
2022-10-03 12:49:03.368838 76.47% [DEBUG] mod_sofia.c:379 sofia/default/1515121325@172.31.40.49:5074 SOFIA DESTROY
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_state_machine.c:175 sofia/default/1515121325@172.31.40.49:5074 Standard DESTROY
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1515121325@172.31.40.49:5074) State DESTROY going to sleep
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_state_machine.c:168 sofia/default/1515121325@172.31.40.49 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1515121325@172.31.40.49) State REPORTING going to sleep
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_state_machine.c:607 (sofia/default/1515121325@172.31.40.49) State Change CS_REPORTING -> CS_DESTROY
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_session.c:1753 Session 179 (sofia/default/1515121325@172.31.40.49) Locked, Waiting on external entities
2022-10-03 12:49:03.368838 76.47% [NOTICE] switch_core_session.c:1771 Session 179 (sofia/default/1515121325@172.31.40.49) Ended
2022-10-03 12:49:03.368838 76.47% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/1515121325@172.31.40.49 [CS_DESTROY]
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_state_machine.c:735 (sofia/default/1515121325@172.31.40.49) Running State Change CS_DESTROY (Cur 0 Tot 179)
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1515121325@172.31.40.49) State DESTROY
2022-10-03 12:49:03.368838 76.47% [DEBUG] mod_sofia.c:379 sofia/default/1515121325@172.31.40.49 SOFIA DESTROY
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_state_machine.c:175 sofia/default/1515121325@172.31.40.49 Standard DESTROY
2022-10-03 12:49:03.368838 76.47% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1515121325@172.31.40.49) State DESTROY going to sleep
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
2022-10-03 12:49:05.368836 76.90% [NOTICE] switch_channel.c:1123 New Channel sofia/default/2536854752@172.31.40.49:5074 [d689c65e-6cca-46f9-ac45-49cb3de8b52e]
2022-10-03 12:49:05.368836 76.90% [DEBUG] mod_sofia.c:5121 (sofia/default/2536854752@172.31.40.49:5074) State Change CS_NEW -> CS_INIT
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/2536854752@172.31.40.49:5074) Running State Change CS_INIT (Cur 1 Tot 180)
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:624 (sofia/default/2536854752@172.31.40.49:5074) State INIT
2022-10-03 12:49:05.368836 76.90% [DEBUG] mod_sofia.c:97 sofia/default/2536854752@172.31.40.49:5074 SOFIA INIT
2022-10-03 12:49:05.368836 76.90% [INFO] sofia_glue.c:1651 sofia/default/2536854752@172.31.40.49:5074 sending invite call-id: (null)
2022-10-03 12:49:05.368836 76.90% [DEBUG] sofia_glue.c:1654 sofia/default/2536854752@172.31.40.49:5074 sending invite version: 1.10.7 -release-19-883d2cb662 64bit
Local SDP:
v=0
o=FreeSWITCH 1664783359 1664783360 IN IP4 172.31.40.49
s=FreeSWITCH
c=IN IP4 172.31.40.49
t=0 0
m=audio 17986 RTP/AVP 8 0 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
a=sendrecv
2022-10-03 12:49:05.368836 76.90% [NOTICE] switch_channel.c:1123 New Channel sofia/default/2536854752@172.31.40.49 [37c0ee26-e612-40a7-860b-25fbef9dd33a]
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:40 sofia/default/2536854752@172.31.40.49:5074 Standard INIT
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:48 (sofia/default/2536854752@172.31.40.49:5074) State Change CS_INIT -> CS_ROUTING
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:624 (sofia/default/2536854752@172.31.40.49:5074) State INIT going to sleep
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/2536854752@172.31.40.49:5074) Running State Change CS_ROUTING (Cur 2 Tot 181)
2022-10-03 12:49:05.368836 76.90% [DEBUG] sofia.c:7499 Channel sofia/default/2536854752@172.31.40.49:5074 entering state [calling][0]
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:640 (sofia/default/2536854752@172.31.40.49:5074) State ROUTING
2022-10-03 12:49:05.368836 76.90% [DEBUG] mod_sofia.c:158 sofia/default/2536854752@172.31.40.49:5074 SOFIA ROUTING
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_ivr_originate.c:67 (sofia/default/2536854752@172.31.40.49:5074) State Change CS_ROUTING -> CS_CONSUME_MEDIA
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:640 (sofia/default/2536854752@172.31.40.49:5074) State ROUTING going to sleep
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/2536854752@172.31.40.49:5074) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 181)
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:659 (sofia/default/2536854752@172.31.40.49:5074) State CONSUME_MEDIA
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:659 (sofia/default/2536854752@172.31.40.49:5074) State CONSUME_MEDIA going to sleep
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/2536854752@172.31.40.49) Running State Change CS_NEW (Cur 2 Tot 181)
2022-10-03 12:49:05.368836 76.90% [INFO] sofia.c:10462 sofia/default/2536854752@172.31.40.49 receiving invite from 172.31.40.49:5074 version: 1.10.7 -release-19-883d2cb662 64bit call-id: 9b005ada-bdbc-123b-66b8-026398ac7998
2022-10-03 12:49:05.368836 76.90% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 172.31.40.49:0.
2022-10-03 12:49:05.368836 76.90% [DEBUG] sofia.c:11672 Setting NAT mode based on via received
2022-10-03 12:49:05.368836 76.90% [DEBUG] sofia.c:7499 Channel sofia/default/2536854752@172.31.40.49 entering state [received][100]
2022-10-03 12:49:05.368836 76.90% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=FreeSWITCH 1664783359 1664783360 IN IP4 172.31.40.49
s=FreeSWITCH
c=IN IP4 172.31.40.49
t=0 0
m=audio 17986 RTP/AVP 8 0 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/2536854752@172.31.40.49 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_codec.c:111 sofia/default/2536854752@172.31.40.49 Original read codec set to PCMA:8
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_media.c:5973 sofia/default/2536854752@172.31.40.49 Set 2833 dtmf send payload to 101 recv payload to 101
2022-10-03 12:49:05.368836 76.90% [DEBUG] sofia.c:7933 (sofia/default/2536854752@172.31.40.49) State Change CS_NEW -> CS_INIT
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:600 (sofia/default/2536854752@172.31.40.49) State NEW
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/2536854752@172.31.40.49) Running State Change CS_INIT (Cur 2 Tot 181)
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:624 (sofia/default/2536854752@172.31.40.49) State INIT
2022-10-03 12:49:05.368836 76.90% [DEBUG] mod_sofia.c:97 sofia/default/2536854752@172.31.40.49 SOFIA INIT
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:40 sofia/default/2536854752@172.31.40.49 Standard INIT
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:48 (sofia/default/2536854752@172.31.40.49) State Change CS_INIT -> CS_ROUTING
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:624 (sofia/default/2536854752@172.31.40.49) State INIT going to sleep
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/2536854752@172.31.40.49) Running State Change CS_ROUTING (Cur 2 Tot 181)
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_channel.c:2380 (sofia/default/2536854752@172.31.40.49) Callstate Change DOWN -> RINGING
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:640 (sofia/default/2536854752@172.31.40.49) State ROUTING
2022-10-03 12:49:05.368836 76.90% [DEBUG] mod_sofia.c:158 sofia/default/2536854752@172.31.40.49 SOFIA ROUTING
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_core_state_machine.c:230 sofia/default/2536854752@172.31.40.49 Standard ROUTING
2022-10-03 12:49:05.368836 76.90% [INFO] mod_dialplan_xml.c:639 Processing 9497482480 <2536854752>->2536854752 in context default
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
2022-10-03 12:49:05.368836 76.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2022-10-03 12:49:05.388838 76.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 2536854752
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Clicktocall Destination Number 2536854752
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '2536854752' AND status=0 limit 1
2022-10-03 12:49:05.388838 76.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 9497482480 / 2536854752
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="2536854752" LIMIT 1
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="2536854752" limit 1
2022-10-03 12:49:05.388838 76.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("172.31.40.49") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "2536854752" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
2022-10-03 12:49:05.388838 76.90% [ERR] switch_core_sqldb.c:1310 ERR: [SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("172.31.40.49") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "2536854752" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1]
[STATE: HY000 CODE 1690 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.30]BIGINT UNSIGNED value is out of range in '((0x01 << (32 - substring_index(`astpp`.`ip_map`.`ip`,'/',<cache>(-(1))))) - 1)'
]
2022-10-03 12:49:05.388838 76.90% [ERR] mod_lua.cpp:202 /usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:154: assertion failed!
stack traceback:
[C]: in function 'assert'
/usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:154: in function </usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:150>
(...tail calls...)
...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:119: in main chunk
[C]: in function 'dofile'
/usr/share/freeswitch/scripts/astpp/astpp.lua:85: in main chunk
2022-10-03 12:49:05.388838 76.90% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
2022-10-03 12:49:05.388838 76.90% [WARNING] mod_dialplan_xml.c:669 Context default not found
2022-10-03 12:49:05.388838 76.90% [INFO] switch_core_state_machine.c:306 No Route, Aborting
2022-10-03 12:49:05.388838 76.90% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/2536854752@172.31.40.49 [CS_ROUTING] [NO_ROUTE_DESTINATION]
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:640 (sofia/default/2536854752@172.31.40.49) State ROUTING going to sleep
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/2536854752@172.31.40.49) Running State Change CS_HANGUP (Cur 2 Tot 181)
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:844 (sofia/default/2536854752@172.31.40.49) Callstate Change RINGING -> HANGUP
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:846 (sofia/default/2536854752@172.31.40.49) State HANGUP
2022-10-03 12:49:05.388838 76.90% [DEBUG] mod_sofia.c:468 Channel sofia/default/2536854752@172.31.40.49 hanging up, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:05.388838 76.90% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:59 sofia/default/2536854752@172.31.40.49 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:846 (sofia/default/2536854752@172.31.40.49) State HANGUP going to sleep
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:616 (sofia/default/2536854752@172.31.40.49) State Change CS_HANGUP -> CS_REPORTING
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/2536854752@172.31.40.49) Running State Change CS_REPORTING (Cur 2 Tot 181)
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:932 (sofia/default/2536854752@172.31.40.49) State REPORTING
2022-10-03 12:49:05.388838 76.90% [INFO] mod_json_cdr.c:271 Process [37c0ee26-e612-40a7-860b-25fbef9dd33a.cdr.json]
2022-10-03 12:49:05.388838 76.90% [DEBUG] sofia.c:6678 Remote Reason: 3
2022-10-03 12:49:05.388838 76.90% [DEBUG] sofia.c:7499 Channel sofia/default/2536854752@172.31.40.49:5074 entering state [terminated][404]
2022-10-03 12:49:05.388838 76.90% [NOTICE] sofia.c:8738 Hangup sofia/default/2536854752@172.31.40.49:5074 [CS_CONSUME_MEDIA] [NO_ROUTE_DESTINATION]
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/2536854752@172.31.40.49:5074) Running State Change CS_HANGUP (Cur 2 Tot 181)
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:844 (sofia/default/2536854752@172.31.40.49:5074) Callstate Change DOWN -> HANGUP
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:846 (sofia/default/2536854752@172.31.40.49:5074) State HANGUP
2022-10-03 12:49:05.388838 76.90% [DEBUG] mod_sofia.c:468 Channel sofia/default/2536854752@172.31.40.49:5074 hanging up, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:59 sofia/default/2536854752@172.31.40.49:5074 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:846 (sofia/default/2536854752@172.31.40.49:5074) State HANGUP going to sleep
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:616 (sofia/default/2536854752@172.31.40.49:5074) State Change CS_HANGUP -> CS_REPORTING
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/2536854752@172.31.40.49:5074) Running State Change CS_REPORTING (Cur 2 Tot 181)
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_core_state_machine.c:932 (sofia/default/2536854752@172.31.40.49:5074) State REPORTING
2022-10-03 12:49:05.388838 76.90% [INFO] mod_json_cdr.c:271 Process [d689c65e-6cca-46f9-ac45-49cb3de8b52e.cdr.json]
2022-10-03 12:49:05.388838 76.90% [DEBUG] switch_ivr_originate.c:4035 Originate Resulted in Error Cause: 3 [NO_ROUTE_DESTINATION]
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:168 sofia/default/2536854752@172.31.40.49:5074 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:932 (sofia/default/2536854752@172.31.40.49:5074) State REPORTING going to sleep
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:607 (sofia/default/2536854752@172.31.40.49:5074) State Change CS_REPORTING -> CS_DESTROY
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_session.c:1753 Session 180 (sofia/default/2536854752@172.31.40.49:5074) Locked, Waiting on external entities
2022-10-03 12:49:05.408834 76.90% [NOTICE] switch_core_session.c:1771 Session 180 (sofia/default/2536854752@172.31.40.49:5074) Ended
2022-10-03 12:49:05.408834 76.90% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/2536854752@172.31.40.49:5074 [CS_DESTROY]
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:735 (sofia/default/2536854752@172.31.40.49:5074) Running State Change CS_DESTROY (Cur 1 Tot 181)
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:745 (sofia/default/2536854752@172.31.40.49:5074) State DESTROY
2022-10-03 12:49:05.408834 76.90% [DEBUG] mod_sofia.c:379 sofia/default/2536854752@172.31.40.49:5074 SOFIA DESTROY
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:175 sofia/default/2536854752@172.31.40.49:5074 Standard DESTROY
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:745 (sofia/default/2536854752@172.31.40.49:5074) State DESTROY going to sleep
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:168 sofia/default/2536854752@172.31.40.49 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:932 (sofia/default/2536854752@172.31.40.49) State REPORTING going to sleep
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:607 (sofia/default/2536854752@172.31.40.49) State Change CS_REPORTING -> CS_DESTROY
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_session.c:1753 Session 181 (sofia/default/2536854752@172.31.40.49) Locked, Waiting on external entities
2022-10-03 12:49:05.408834 76.90% [NOTICE] switch_core_session.c:1771 Session 181 (sofia/default/2536854752@172.31.40.49) Ended
2022-10-03 12:49:05.408834 76.90% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/2536854752@172.31.40.49 [CS_DESTROY]
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:735 (sofia/default/2536854752@172.31.40.49) Running State Change CS_DESTROY (Cur 0 Tot 181)
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:745 (sofia/default/2536854752@172.31.40.49) State DESTROY
2022-10-03 12:49:05.408834 76.90% [DEBUG] mod_sofia.c:379 sofia/default/2536854752@172.31.40.49 SOFIA DESTROY
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:175 sofia/default/2536854752@172.31.40.49 Standard DESTROY
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:745 (sofia/default/2536854752@172.31.40.49) State DESTROY going to sleep
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
2022-10-03 12:49:05.408834 76.90% [NOTICE] switch_channel.c:1123 New Channel sofia/default/1554856322@172.31.40.49:5074 [d0521ed0-4417-4c59-9e4b-87fee9b532a7]
2022-10-03 12:49:05.408834 76.90% [DEBUG] mod_sofia.c:5121 (sofia/default/1554856322@172.31.40.49:5074) State Change CS_NEW -> CS_INIT
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1554856322@172.31.40.49:5074) Running State Change CS_INIT (Cur 1 Tot 182)
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1554856322@172.31.40.49:5074) State INIT
2022-10-03 12:49:05.408834 76.90% [DEBUG] mod_sofia.c:97 sofia/default/1554856322@172.31.40.49:5074 SOFIA INIT
2022-10-03 12:49:05.408834 76.90% [INFO] sofia_glue.c:1651 sofia/default/1554856322@172.31.40.49:5074 sending invite call-id: (null)
2022-10-03 12:49:05.408834 76.90% [DEBUG] sofia_glue.c:1654 sofia/default/1554856322@172.31.40.49:5074 sending invite version: 1.10.7 -release-19-883d2cb662 64bit
Local SDP:
v=0
o=FreeSWITCH 1664776951 1664776952 IN IP4 172.31.40.49
s=FreeSWITCH
c=IN IP4 172.31.40.49
t=0 0
m=audio 24394 RTP/AVP 8 0 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
a=sendrecv
2022-10-03 12:49:05.408834 76.90% [NOTICE] switch_channel.c:1123 New Channel sofia/default/1554856322@172.31.40.49 [0de87b40-98c0-40ba-afb4-a65b20f24e3c]
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:40 sofia/default/1554856322@172.31.40.49:5074 Standard INIT
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1554856322@172.31.40.49:5074) State Change CS_INIT -> CS_ROUTING
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1554856322@172.31.40.49:5074) State INIT going to sleep
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1554856322@172.31.40.49:5074) Running State Change CS_ROUTING (Cur 2 Tot 183)
2022-10-03 12:49:05.408834 76.90% [DEBUG] sofia.c:7499 Channel sofia/default/1554856322@172.31.40.49:5074 entering state [calling][0]
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1554856322@172.31.40.49:5074) State ROUTING
2022-10-03 12:49:05.408834 76.90% [DEBUG] mod_sofia.c:158 sofia/default/1554856322@172.31.40.49:5074 SOFIA ROUTING
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_ivr_originate.c:67 (sofia/default/1554856322@172.31.40.49:5074) State Change CS_ROUTING -> CS_CONSUME_MEDIA
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1554856322@172.31.40.49:5074) State ROUTING going to sleep
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1554856322@172.31.40.49:5074) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 183)
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:659 (sofia/default/1554856322@172.31.40.49:5074) State CONSUME_MEDIA
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:659 (sofia/default/1554856322@172.31.40.49:5074) State CONSUME_MEDIA going to sleep
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1554856322@172.31.40.49) Running State Change CS_NEW (Cur 2 Tot 183)
2022-10-03 12:49:05.408834 76.90% [INFO] sofia.c:10462 sofia/default/1554856322@172.31.40.49 receiving invite from 172.31.40.49:5074 version: 1.10.7 -release-19-883d2cb662 64bit call-id: 9b05e229-bdbc-123b-66b8-026398ac7998
2022-10-03 12:49:05.408834 76.90% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 172.31.40.49:0.
2022-10-03 12:49:05.408834 76.90% [DEBUG] sofia.c:11672 Setting NAT mode based on via received
2022-10-03 12:49:05.408834 76.90% [DEBUG] sofia.c:7499 Channel sofia/default/1554856322@172.31.40.49 entering state [received][100]
2022-10-03 12:49:05.408834 76.90% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=FreeSWITCH 1664776951 1664776952 IN IP4 172.31.40.49
s=FreeSWITCH
c=IN IP4 172.31.40.49
t=0 0
m=audio 24394 RTP/AVP 8 0 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/1554856322@172.31.40.49 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_codec.c:111 sofia/default/1554856322@172.31.40.49 Original read codec set to PCMA:8
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_media.c:5973 sofia/default/1554856322@172.31.40.49 Set 2833 dtmf send payload to 101 recv payload to 101
2022-10-03 12:49:05.408834 76.90% [DEBUG] sofia.c:7933 (sofia/default/1554856322@172.31.40.49) State Change CS_NEW -> CS_INIT
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:600 (sofia/default/1554856322@172.31.40.49) State NEW
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1554856322@172.31.40.49) Running State Change CS_INIT (Cur 2 Tot 183)
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1554856322@172.31.40.49) State INIT
2022-10-03 12:49:05.408834 76.90% [DEBUG] mod_sofia.c:97 sofia/default/1554856322@172.31.40.49 SOFIA INIT
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:40 sofia/default/1554856322@172.31.40.49 Standard INIT
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1554856322@172.31.40.49) State Change CS_INIT -> CS_ROUTING
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1554856322@172.31.40.49) State INIT going to sleep
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1554856322@172.31.40.49) Running State Change CS_ROUTING (Cur 2 Tot 183)
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_channel.c:2380 (sofia/default/1554856322@172.31.40.49) Callstate Change DOWN -> RINGING
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1554856322@172.31.40.49) State ROUTING
2022-10-03 12:49:05.408834 76.90% [DEBUG] mod_sofia.c:158 sofia/default/1554856322@172.31.40.49 SOFIA ROUTING
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_core_state_machine.c:230 sofia/default/1554856322@172.31.40.49 Standard ROUTING
2022-10-03 12:49:05.408834 76.90% [INFO] mod_dialplan_xml.c:639 Processing 9497482480 <1554856322>->1554856322 in context default
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
2022-10-03 12:49:05.408834 76.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2022-10-03 12:49:05.428835 76.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 1554856322
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Clicktocall Destination Number 1554856322
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '1554856322' AND status=0 limit 1
2022-10-03 12:49:05.428835 76.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 9497482480 / 1554856322
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1554856322" LIMIT 1
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="1554856322" limit 1
2022-10-03 12:49:05.428835 76.90% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("172.31.40.49") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "1554856322" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
2022-10-03 12:49:05.428835 76.90% [ERR] switch_core_sqldb.c:1310 ERR: [SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("172.31.40.49") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "1554856322" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1]
[STATE: HY000 CODE 1690 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.30]BIGINT UNSIGNED value is out of range in '((0x01 << (32 - substring_index(`astpp`.`ip_map`.`ip`,'/',<cache>(-(1))))) - 1)'
]
2022-10-03 12:49:05.428835 76.90% [ERR] mod_lua.cpp:202 /usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:154: assertion failed!
stack traceback:
[C]: in function 'assert'
/usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:154: in function </usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:150>
(...tail calls...)
...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:119: in main chunk
[C]: in function 'dofile'
/usr/share/freeswitch/scripts/astpp/astpp.lua:85: in main chunk
2022-10-03 12:49:05.428835 76.90% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
2022-10-03 12:49:05.428835 76.90% [WARNING] mod_dialplan_xml.c:669 Context default not found
2022-10-03 12:49:05.428835 76.90% [INFO] switch_core_state_machine.c:306 No Route, Aborting
2022-10-03 12:49:05.428835 76.90% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/1554856322@172.31.40.49 [CS_ROUTING] [NO_ROUTE_DESTINATION]
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1554856322@172.31.40.49) State ROUTING going to sleep
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1554856322@172.31.40.49) Running State Change CS_HANGUP (Cur 2 Tot 183)
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1554856322@172.31.40.49) Callstate Change RINGING -> HANGUP
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1554856322@172.31.40.49) State HANGUP
2022-10-03 12:49:05.428835 76.90% [DEBUG] mod_sofia.c:468 Channel sofia/default/1554856322@172.31.40.49 hanging up, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:05.428835 76.90% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:59 sofia/default/1554856322@172.31.40.49 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1554856322@172.31.40.49) State HANGUP going to sleep
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1554856322@172.31.40.49) State Change CS_HANGUP -> CS_REPORTING
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1554856322@172.31.40.49) Running State Change CS_REPORTING (Cur 2 Tot 183)
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1554856322@172.31.40.49) State REPORTING
2022-10-03 12:49:05.428835 76.90% [INFO] mod_json_cdr.c:271 Process [0de87b40-98c0-40ba-afb4-a65b20f24e3c.cdr.json]
2022-10-03 12:49:05.428835 76.90% [DEBUG] sofia.c:6678 Remote Reason: 3
2022-10-03 12:49:05.428835 76.90% [DEBUG] sofia.c:7499 Channel sofia/default/1554856322@172.31.40.49:5074 entering state [terminated][404]
2022-10-03 12:49:05.428835 76.90% [NOTICE] sofia.c:8738 Hangup sofia/default/1554856322@172.31.40.49:5074 [CS_CONSUME_MEDIA] [NO_ROUTE_DESTINATION]
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1554856322@172.31.40.49:5074) Running State Change CS_HANGUP (Cur 2 Tot 183)
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1554856322@172.31.40.49:5074) Callstate Change DOWN -> HANGUP
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1554856322@172.31.40.49:5074) State HANGUP
2022-10-03 12:49:05.428835 76.90% [DEBUG] mod_sofia.c:468 Channel sofia/default/1554856322@172.31.40.49:5074 hanging up, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:59 sofia/default/1554856322@172.31.40.49:5074 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1554856322@172.31.40.49:5074) State HANGUP going to sleep
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1554856322@172.31.40.49:5074) State Change CS_HANGUP -> CS_REPORTING
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1554856322@172.31.40.49:5074) Running State Change CS_REPORTING (Cur 2 Tot 183)
2022-10-03 12:49:05.428835 76.90% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1554856322@172.31.40.49:5074) State REPORTING
2022-10-03 12:49:05.428835 76.90% [INFO] mod_json_cdr.c:271 Process [d0521ed0-4417-4c59-9e4b-87fee9b532a7.cdr.json]
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_state_machine.c:168 sofia/default/1554856322@172.31.40.49:5074 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1554856322@172.31.40.49:5074) State REPORTING going to sleep
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_state_machine.c:607 (sofia/default/1554856322@172.31.40.49:5074) State Change CS_REPORTING -> CS_DESTROY
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_session.c:1753 Session 182 (sofia/default/1554856322@172.31.40.49:5074) Locked, Waiting on external entities
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_state_machine.c:168 sofia/default/1554856322@172.31.40.49 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1554856322@172.31.40.49) State REPORTING going to sleep
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_state_machine.c:607 (sofia/default/1554856322@172.31.40.49) State Change CS_REPORTING -> CS_DESTROY
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_session.c:1753 Session 183 (sofia/default/1554856322@172.31.40.49) Locked, Waiting on external entities
2022-10-03 12:49:05.448826 76.90% [NOTICE] switch_core_session.c:1771 Session 183 (sofia/default/1554856322@172.31.40.49) Ended
2022-10-03 12:49:05.448826 76.90% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/1554856322@172.31.40.49 [CS_DESTROY]
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_state_machine.c:735 (sofia/default/1554856322@172.31.40.49) Running State Change CS_DESTROY (Cur 1 Tot 183)
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1554856322@172.31.40.49) State DESTROY
2022-10-03 12:49:05.448826 76.90% [DEBUG] mod_sofia.c:379 sofia/default/1554856322@172.31.40.49 SOFIA DESTROY
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_state_machine.c:175 sofia/default/1554856322@172.31.40.49 Standard DESTROY
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1554856322@172.31.40.49) State DESTROY going to sleep
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_ivr_originate.c:4035 Originate Resulted in Error Cause: 3 [NO_ROUTE_DESTINATION]
2022-10-03 12:49:05.448826 76.90% [NOTICE] switch_core_session.c:1771 Session 182 (sofia/default/1554856322@172.31.40.49:5074) Ended
2022-10-03 12:49:05.448826 76.90% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/1554856322@172.31.40.49:5074 [CS_DESTROY]
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_state_machine.c:735 (sofia/default/1554856322@172.31.40.49:5074) Running State Change CS_DESTROY (Cur 0 Tot 183)
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1554856322@172.31.40.49:5074) State DESTROY
2022-10-03 12:49:05.448826 76.90% [DEBUG] mod_sofia.c:379 sofia/default/1554856322@172.31.40.49:5074 SOFIA DESTROY
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_state_machine.c:175 sofia/default/1554856322@172.31.40.49:5074 Standard DESTROY
2022-10-03 12:49:05.448826 76.90% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1554856322@172.31.40.49:5074) State DESTROY going to sleep
2022-10-03 12:49:06.328836 77.30% [WARNING] sofia_reg.c:1861 SIP auth challenge (REGISTER) on sofia profile 'default' for [9497482480@13.127.15.161] from ip 103.240.35.46
2022-10-03 12:49:06.488835 77.30% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [9497482480@13.127.15.161] from ip 103.240.35.46
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
2022-10-03 12:49:07.448857 78.13% [NOTICE] switch_channel.c:1123 New Channel sofia/default/1547964325@172.31.40.49:5074 [38854f90-12d0-463d-9836-20987ed63d52]
2022-10-03 12:49:07.448857 78.13% [DEBUG] mod_sofia.c:5121 (sofia/default/1547964325@172.31.40.49:5074) State Change CS_NEW -> CS_INIT
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1547964325@172.31.40.49:5074) Running State Change CS_INIT (Cur 1 Tot 184)
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1547964325@172.31.40.49:5074) State INIT
2022-10-03 12:49:07.448857 78.13% [DEBUG] mod_sofia.c:97 sofia/default/1547964325@172.31.40.49:5074 SOFIA INIT
2022-10-03 12:49:07.448857 78.13% [INFO] sofia_glue.c:1651 sofia/default/1547964325@172.31.40.49:5074 sending invite call-id: (null)
2022-10-03 12:49:07.448857 78.13% [DEBUG] sofia_glue.c:1654 sofia/default/1547964325@172.31.40.49:5074 sending invite version: 1.10.7 -release-19-883d2cb662 64bit
Local SDP:
v=0
o=FreeSWITCH 1664775683 1664775684 IN IP4 172.31.40.49
s=FreeSWITCH
c=IN IP4 172.31.40.49
t=0 0
m=audio 25664 RTP/AVP 8 0 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
a=sendrecv
2022-10-03 12:49:07.448857 78.13% [NOTICE] switch_channel.c:1123 New Channel sofia/default/1547964325@172.31.40.49 [76901768-0bc6-4014-87ab-e29677786de8]
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:40 sofia/default/1547964325@172.31.40.49:5074 Standard INIT
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1547964325@172.31.40.49:5074) State Change CS_INIT -> CS_ROUTING
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1547964325@172.31.40.49:5074) State INIT going to sleep
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1547964325@172.31.40.49:5074) Running State Change CS_ROUTING (Cur 2 Tot 185)
2022-10-03 12:49:07.448857 78.13% [DEBUG] sofia.c:7499 Channel sofia/default/1547964325@172.31.40.49:5074 entering state [calling][0]
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1547964325@172.31.40.49:5074) State ROUTING
2022-10-03 12:49:07.448857 78.13% [DEBUG] mod_sofia.c:158 sofia/default/1547964325@172.31.40.49:5074 SOFIA ROUTING
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_ivr_originate.c:67 (sofia/default/1547964325@172.31.40.49:5074) State Change CS_ROUTING -> CS_CONSUME_MEDIA
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1547964325@172.31.40.49:5074) State ROUTING going to sleep
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1547964325@172.31.40.49:5074) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 185)
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:659 (sofia/default/1547964325@172.31.40.49:5074) State CONSUME_MEDIA
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:659 (sofia/default/1547964325@172.31.40.49:5074) State CONSUME_MEDIA going to sleep
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1547964325@172.31.40.49) Running State Change CS_NEW (Cur 2 Tot 185)
2022-10-03 12:49:07.448857 78.13% [INFO] sofia.c:10462 sofia/default/1547964325@172.31.40.49 receiving invite from 172.31.40.49:5074 version: 1.10.7 -release-19-883d2cb662 64bit call-id: 9c3e8d20-bdbc-123b-66b8-026398ac7998
2022-10-03 12:49:07.448857 78.13% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 172.31.40.49:0.
2022-10-03 12:49:07.448857 78.13% [DEBUG] sofia.c:11672 Setting NAT mode based on via received
2022-10-03 12:49:07.448857 78.13% [DEBUG] sofia.c:7499 Channel sofia/default/1547964325@172.31.40.49 entering state [received][100]
2022-10-03 12:49:07.448857 78.13% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=FreeSWITCH 1664775683 1664775684 IN IP4 172.31.40.49
s=FreeSWITCH
c=IN IP4 172.31.40.49
t=0 0
m=audio 25664 RTP/AVP 8 0 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/1547964325@172.31.40.49 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_codec.c:111 sofia/default/1547964325@172.31.40.49 Original read codec set to PCMA:8
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_media.c:5973 sofia/default/1547964325@172.31.40.49 Set 2833 dtmf send payload to 101 recv payload to 101
2022-10-03 12:49:07.448857 78.13% [DEBUG] sofia.c:7933 (sofia/default/1547964325@172.31.40.49) State Change CS_NEW -> CS_INIT
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:600 (sofia/default/1547964325@172.31.40.49) State NEW
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1547964325@172.31.40.49) Running State Change CS_INIT (Cur 2 Tot 185)
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1547964325@172.31.40.49) State INIT
2022-10-03 12:49:07.448857 78.13% [DEBUG] mod_sofia.c:97 sofia/default/1547964325@172.31.40.49 SOFIA INIT
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:40 sofia/default/1547964325@172.31.40.49 Standard INIT
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1547964325@172.31.40.49) State Change CS_INIT -> CS_ROUTING
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1547964325@172.31.40.49) State INIT going to sleep
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1547964325@172.31.40.49) Running State Change CS_ROUTING (Cur 2 Tot 185)
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_channel.c:2380 (sofia/default/1547964325@172.31.40.49) Callstate Change DOWN -> RINGING
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1547964325@172.31.40.49) State ROUTING
2022-10-03 12:49:07.448857 78.13% [DEBUG] mod_sofia.c:158 sofia/default/1547964325@172.31.40.49 SOFIA ROUTING
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_core_state_machine.c:230 sofia/default/1547964325@172.31.40.49 Standard ROUTING
2022-10-03 12:49:07.448857 78.13% [INFO] mod_dialplan_xml.c:639 Processing 9497482480 <1547964325>->1547964325 in context default
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
2022-10-03 12:49:07.448857 78.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2022-10-03 12:49:07.468834 78.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 1547964325
2022-10-03 12:49:07.468834 78.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Clicktocall Destination Number 1547964325
2022-10-03 12:49:07.468834 78.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '1547964325' AND status=0 limit 1
2022-10-03 12:49:07.468834 78.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 9497482480 / 1547964325
2022-10-03 12:49:07.468834 78.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1547964325" LIMIT 1
2022-10-03 12:49:07.468834 78.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="1547964325" limit 1
2022-10-03 12:49:07.468834 78.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
2022-10-03 12:49:07.468834 78.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("172.31.40.49") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "1547964325" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
2022-10-03 12:49:07.468834 78.13% [ERR] switch_core_sqldb.c:1310 ERR: [SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("172.31.40.49") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "1547964325" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1]
[STATE: HY000 CODE 1690 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.30]BIGINT UNSIGNED value is out of range in '((0x01 << (32 - substring_index(`astpp`.`ip_map`.`ip`,'/',<cache>(-(1))))) - 1)'
]
2022-10-03 12:49:07.468834 78.13% [ERR] mod_lua.cpp:202 /usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:154: assertion failed!
stack traceback:
[C]: in function 'assert'
/usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:154: in function </usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:150>
(...tail calls...)
...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:119: in main chunk
[C]: in function 'dofile'
/usr/share/freeswitch/scripts/astpp/astpp.lua:85: in main chunk
2022-10-03 12:49:07.468834 78.13% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
2022-10-03 12:49:07.468834 78.13% [WARNING] mod_dialplan_xml.c:669 Context default not found
2022-10-03 12:49:07.468834 78.13% [INFO] switch_core_state_machine.c:306 No Route, Aborting
2022-10-03 12:49:07.468834 78.13% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/1547964325@172.31.40.49 [CS_ROUTING] [NO_ROUTE_DESTINATION]
2022-10-03 12:49:07.468834 78.13% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1547964325@172.31.40.49) State ROUTING going to sleep
2022-10-03 12:49:07.468834 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1547964325@172.31.40.49) Running State Change CS_HANGUP (Cur 2 Tot 185)
2022-10-03 12:49:07.468834 78.13% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1547964325@172.31.40.49) Callstate Change RINGING -> HANGUP
2022-10-03 12:49:07.468834 78.13% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1547964325@172.31.40.49) State HANGUP
2022-10-03 12:49:07.468834 78.13% [DEBUG] mod_sofia.c:468 Channel sofia/default/1547964325@172.31.40.49 hanging up, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:07.468834 78.13% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
2022-10-03 12:49:07.468834 78.13% [DEBUG] switch_core_state_machine.c:59 sofia/default/1547964325@172.31.40.49 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:07.468834 78.13% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1547964325@172.31.40.49) State HANGUP going to sleep
2022-10-03 12:49:07.468834 78.13% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1547964325@172.31.40.49) State Change CS_HANGUP -> CS_REPORTING
2022-10-03 12:49:07.468834 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1547964325@172.31.40.49) Running State Change CS_REPORTING (Cur 2 Tot 185)
2022-10-03 12:49:07.468834 78.13% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1547964325@172.31.40.49) State REPORTING
2022-10-03 12:49:07.468834 78.13% [INFO] mod_json_cdr.c:271 Process [76901768-0bc6-4014-87ab-e29677786de8.cdr.json]
2022-10-03 12:49:07.488862 78.13% [DEBUG] sofia.c:6678 Remote Reason: 3
2022-10-03 12:49:07.488862 78.13% [DEBUG] sofia.c:7499 Channel sofia/default/1547964325@172.31.40.49:5074 entering state [terminated][404]
2022-10-03 12:49:07.488862 78.13% [NOTICE] sofia.c:8738 Hangup sofia/default/1547964325@172.31.40.49:5074 [CS_CONSUME_MEDIA] [NO_ROUTE_DESTINATION]
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1547964325@172.31.40.49:5074) Running State Change CS_HANGUP (Cur 2 Tot 185)
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1547964325@172.31.40.49:5074) Callstate Change DOWN -> HANGUP
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1547964325@172.31.40.49:5074) State HANGUP
2022-10-03 12:49:07.488862 78.13% [DEBUG] mod_sofia.c:468 Channel sofia/default/1547964325@172.31.40.49:5074 hanging up, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:59 sofia/default/1547964325@172.31.40.49:5074 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1547964325@172.31.40.49:5074) State HANGUP going to sleep
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1547964325@172.31.40.49:5074) State Change CS_HANGUP -> CS_REPORTING
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1547964325@172.31.40.49:5074) Running State Change CS_REPORTING (Cur 2 Tot 185)
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1547964325@172.31.40.49:5074) State REPORTING
2022-10-03 12:49:07.488862 78.13% [INFO] mod_json_cdr.c:271 Process [38854f90-12d0-463d-9836-20987ed63d52.cdr.json]
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_ivr_originate.c:4035 Originate Resulted in Error Cause: 3 [NO_ROUTE_DESTINATION]
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:168 sofia/default/1547964325@172.31.40.49:5074 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1547964325@172.31.40.49:5074) State REPORTING going to sleep
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:607 (sofia/default/1547964325@172.31.40.49:5074) State Change CS_REPORTING -> CS_DESTROY
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_session.c:1753 Session 184 (sofia/default/1547964325@172.31.40.49:5074) Locked, Waiting on external entities
2022-10-03 12:49:07.488862 78.13% [NOTICE] switch_core_session.c:1771 Session 184 (sofia/default/1547964325@172.31.40.49:5074) Ended
2022-10-03 12:49:07.488862 78.13% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/1547964325@172.31.40.49:5074 [CS_DESTROY]
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:735 (sofia/default/1547964325@172.31.40.49:5074) Running State Change CS_DESTROY (Cur 1 Tot 185)
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1547964325@172.31.40.49:5074) State DESTROY
2022-10-03 12:49:07.488862 78.13% [DEBUG] mod_sofia.c:379 sofia/default/1547964325@172.31.40.49:5074 SOFIA DESTROY
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:175 sofia/default/1547964325@172.31.40.49:5074 Standard DESTROY
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1547964325@172.31.40.49:5074) State DESTROY going to sleep
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:168 sofia/default/1547964325@172.31.40.49 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1547964325@172.31.40.49) State REPORTING going to sleep
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:607 (sofia/default/1547964325@172.31.40.49) State Change CS_REPORTING -> CS_DESTROY
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_session.c:1753 Session 185 (sofia/default/1547964325@172.31.40.49) Locked, Waiting on external entities
2022-10-03 12:49:07.488862 78.13% [NOTICE] switch_core_session.c:1771 Session 185 (sofia/default/1547964325@172.31.40.49) Ended
2022-10-03 12:49:07.488862 78.13% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/1547964325@172.31.40.49 [CS_DESTROY]
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:735 (sofia/default/1547964325@172.31.40.49) Running State Change CS_DESTROY (Cur 0 Tot 185)
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1547964325@172.31.40.49) State DESTROY
2022-10-03 12:49:07.488862 78.13% [DEBUG] mod_sofia.c:379 sofia/default/1547964325@172.31.40.49 SOFIA DESTROY
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:175 sofia/default/1547964325@172.31.40.49 Standard DESTROY
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1547964325@172.31.40.49) State DESTROY going to sleep
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
2022-10-03 12:49:07.488862 78.13% [NOTICE] switch_channel.c:1123 New Channel sofia/default/1030303044@172.31.40.49:5074 [3ba30323-0066-4d65-be18-e922b63b5e5e]
2022-10-03 12:49:07.488862 78.13% [DEBUG] mod_sofia.c:5121 (sofia/default/1030303044@172.31.40.49:5074) State Change CS_NEW -> CS_INIT
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1030303044@172.31.40.49:5074) Running State Change CS_INIT (Cur 1 Tot 186)
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1030303044@172.31.40.49:5074) State INIT
2022-10-03 12:49:07.488862 78.13% [DEBUG] mod_sofia.c:97 sofia/default/1030303044@172.31.40.49:5074 SOFIA INIT
2022-10-03 12:49:07.488862 78.13% [INFO] sofia_glue.c:1651 sofia/default/1030303044@172.31.40.49:5074 sending invite call-id: (null)
2022-10-03 12:49:07.488862 78.13% [DEBUG] sofia_glue.c:1654 sofia/default/1030303044@172.31.40.49:5074 sending invite version: 1.10.7 -release-19-883d2cb662 64bit
Local SDP:
v=0
o=FreeSWITCH 1664778969 1664778970 IN IP4 172.31.40.49
s=FreeSWITCH
c=IN IP4 172.31.40.49
t=0 0
m=audio 22378 RTP/AVP 8 0 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
a=sendrecv
2022-10-03 12:49:07.488862 78.13% [NOTICE] switch_channel.c:1123 New Channel sofia/default/1030303044@172.31.40.49 [12e3d2d1-cd31-473d-b9fb-b15ca0275789]
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:40 sofia/default/1030303044@172.31.40.49:5074 Standard INIT
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1030303044@172.31.40.49:5074) State Change CS_INIT -> CS_ROUTING
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1030303044@172.31.40.49:5074) State INIT going to sleep
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1030303044@172.31.40.49:5074) Running State Change CS_ROUTING (Cur 2 Tot 187)
2022-10-03 12:49:07.488862 78.13% [DEBUG] sofia.c:7499 Channel sofia/default/1030303044@172.31.40.49:5074 entering state [calling][0]
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1030303044@172.31.40.49:5074) State ROUTING
2022-10-03 12:49:07.488862 78.13% [DEBUG] mod_sofia.c:158 sofia/default/1030303044@172.31.40.49:5074 SOFIA ROUTING
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_ivr_originate.c:67 (sofia/default/1030303044@172.31.40.49:5074) State Change CS_ROUTING -> CS_CONSUME_MEDIA
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1030303044@172.31.40.49:5074) State ROUTING going to sleep
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1030303044@172.31.40.49:5074) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 187)
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:659 (sofia/default/1030303044@172.31.40.49:5074) State CONSUME_MEDIA
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:659 (sofia/default/1030303044@172.31.40.49:5074) State CONSUME_MEDIA going to sleep
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1030303044@172.31.40.49) Running State Change CS_NEW (Cur 2 Tot 187)
2022-10-03 12:49:07.488862 78.13% [INFO] sofia.c:10462 sofia/default/1030303044@172.31.40.49 receiving invite from 172.31.40.49:5074 version: 1.10.7 -release-19-883d2cb662 64bit call-id: 9c448368-bdbc-123b-66b8-026398ac7998
2022-10-03 12:49:07.488862 78.13% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 172.31.40.49:0.
2022-10-03 12:49:07.488862 78.13% [DEBUG] sofia.c:11672 Setting NAT mode based on via received
2022-10-03 12:49:07.488862 78.13% [DEBUG] sofia.c:7499 Channel sofia/default/1030303044@172.31.40.49 entering state [received][100]
2022-10-03 12:49:07.488862 78.13% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=FreeSWITCH 1664778969 1664778970 IN IP4 172.31.40.49
s=FreeSWITCH
c=IN IP4 172.31.40.49
t=0 0
m=audio 22378 RTP/AVP 8 0 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/1030303044@172.31.40.49 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_codec.c:111 sofia/default/1030303044@172.31.40.49 Original read codec set to PCMA:8
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_media.c:5973 sofia/default/1030303044@172.31.40.49 Set 2833 dtmf send payload to 101 recv payload to 101
2022-10-03 12:49:07.488862 78.13% [DEBUG] sofia.c:7933 (sofia/default/1030303044@172.31.40.49) State Change CS_NEW -> CS_INIT
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:600 (sofia/default/1030303044@172.31.40.49) State NEW
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1030303044@172.31.40.49) Running State Change CS_INIT (Cur 2 Tot 187)
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1030303044@172.31.40.49) State INIT
2022-10-03 12:49:07.488862 78.13% [DEBUG] mod_sofia.c:97 sofia/default/1030303044@172.31.40.49 SOFIA INIT
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:40 sofia/default/1030303044@172.31.40.49 Standard INIT
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1030303044@172.31.40.49) State Change CS_INIT -> CS_ROUTING
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1030303044@172.31.40.49) State INIT going to sleep
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1030303044@172.31.40.49) Running State Change CS_ROUTING (Cur 2 Tot 187)
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_channel.c:2380 (sofia/default/1030303044@172.31.40.49) Callstate Change DOWN -> RINGING
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1030303044@172.31.40.49) State ROUTING
2022-10-03 12:49:07.488862 78.13% [DEBUG] mod_sofia.c:158 sofia/default/1030303044@172.31.40.49 SOFIA ROUTING
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_core_state_machine.c:230 sofia/default/1030303044@172.31.40.49 Standard ROUTING
2022-10-03 12:49:07.488862 78.13% [INFO] mod_dialplan_xml.c:639 Processing 9497482480 <1030303044>->1030303044 in context default
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
2022-10-03 12:49:07.488862 78.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2022-10-03 12:49:07.508832 78.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 1030303044
2022-10-03 12:49:07.508832 78.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Clicktocall Destination Number 1030303044
2022-10-03 12:49:07.508832 78.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '1030303044' AND status=0 limit 1
2022-10-03 12:49:07.508832 78.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 9497482480 / 1030303044
2022-10-03 12:49:07.508832 78.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1030303044" LIMIT 1
2022-10-03 12:49:07.508832 78.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="1030303044" limit 1
2022-10-03 12:49:07.508832 78.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
2022-10-03 12:49:07.508832 78.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("172.31.40.49") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "1030303044" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
2022-10-03 12:49:07.508832 78.13% [ERR] switch_core_sqldb.c:1310 ERR: [SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("172.31.40.49") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "1030303044" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1]
[STATE: HY000 CODE 1690 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.30]BIGINT UNSIGNED value is out of range in '((0x01 << (32 - substring_index(`astpp`.`ip_map`.`ip`,'/',<cache>(-(1))))) - 1)'
]
2022-10-03 12:49:07.508832 78.13% [ERR] mod_lua.cpp:202 /usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:154: assertion failed!
stack traceback:
[C]: in function 'assert'
/usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:154: in function </usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:150>
(...tail calls...)
...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:119: in main chunk
[C]: in function 'dofile'
/usr/share/freeswitch/scripts/astpp/astpp.lua:85: in main chunk
2022-10-03 12:49:07.508832 78.13% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
2022-10-03 12:49:07.508832 78.13% [WARNING] mod_dialplan_xml.c:669 Context default not found
2022-10-03 12:49:07.508832 78.13% [INFO] switch_core_state_machine.c:306 No Route, Aborting
2022-10-03 12:49:07.508832 78.13% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/1030303044@172.31.40.49 [CS_ROUTING] [NO_ROUTE_DESTINATION]
2022-10-03 12:49:07.508832 78.13% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1030303044@172.31.40.49) State ROUTING going to sleep
2022-10-03 12:49:07.508832 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1030303044@172.31.40.49) Running State Change CS_HANGUP (Cur 2 Tot 187)
2022-10-03 12:49:07.508832 78.13% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1030303044@172.31.40.49) Callstate Change RINGING -> HANGUP
2022-10-03 12:49:07.508832 78.13% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1030303044@172.31.40.49) State HANGUP
2022-10-03 12:49:07.508832 78.13% [DEBUG] mod_sofia.c:468 Channel sofia/default/1030303044@172.31.40.49 hanging up, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:07.508832 78.13% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
2022-10-03 12:49:07.508832 78.13% [DEBUG] switch_core_state_machine.c:59 sofia/default/1030303044@172.31.40.49 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:07.508832 78.13% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1030303044@172.31.40.49) State HANGUP going to sleep
2022-10-03 12:49:07.508832 78.13% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1030303044@172.31.40.49) State Change CS_HANGUP -> CS_REPORTING
2022-10-03 12:49:07.508832 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1030303044@172.31.40.49) Running State Change CS_REPORTING (Cur 2 Tot 187)
2022-10-03 12:49:07.508832 78.13% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1030303044@172.31.40.49) State REPORTING
2022-10-03 12:49:07.508832 78.13% [INFO] mod_json_cdr.c:271 Process [12e3d2d1-cd31-473d-b9fb-b15ca0275789.cdr.json]
2022-10-03 12:49:07.528836 78.13% [DEBUG] sofia.c:6678 Remote Reason: 3
2022-10-03 12:49:07.528836 78.13% [DEBUG] sofia.c:7499 Channel sofia/default/1030303044@172.31.40.49:5074 entering state [terminated][404]
2022-10-03 12:49:07.528836 78.13% [NOTICE] sofia.c:8738 Hangup sofia/default/1030303044@172.31.40.49:5074 [CS_CONSUME_MEDIA] [NO_ROUTE_DESTINATION]
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1030303044@172.31.40.49:5074) Running State Change CS_HANGUP (Cur 2 Tot 187)
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1030303044@172.31.40.49:5074) Callstate Change DOWN -> HANGUP
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1030303044@172.31.40.49:5074) State HANGUP
2022-10-03 12:49:07.528836 78.13% [DEBUG] mod_sofia.c:468 Channel sofia/default/1030303044@172.31.40.49:5074 hanging up, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:59 sofia/default/1030303044@172.31.40.49:5074 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1030303044@172.31.40.49:5074) State HANGUP going to sleep
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1030303044@172.31.40.49:5074) State Change CS_HANGUP -> CS_REPORTING
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1030303044@172.31.40.49:5074) Running State Change CS_REPORTING (Cur 2 Tot 187)
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1030303044@172.31.40.49:5074) State REPORTING
2022-10-03 12:49:07.528836 78.13% [INFO] mod_json_cdr.c:271 Process [3ba30323-0066-4d65-be18-e922b63b5e5e.cdr.json]
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:168 sofia/default/1030303044@172.31.40.49:5074 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1030303044@172.31.40.49:5074) State REPORTING going to sleep
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:607 (sofia/default/1030303044@172.31.40.49:5074) State Change CS_REPORTING -> CS_DESTROY
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_session.c:1753 Session 186 (sofia/default/1030303044@172.31.40.49:5074) Locked, Waiting on external entities
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:168 sofia/default/1030303044@172.31.40.49 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1030303044@172.31.40.49) State REPORTING going to sleep
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:607 (sofia/default/1030303044@172.31.40.49) State Change CS_REPORTING -> CS_DESTROY
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_session.c:1753 Session 187 (sofia/default/1030303044@172.31.40.49) Locked, Waiting on external entities
2022-10-03 12:49:07.528836 78.13% [NOTICE] switch_core_session.c:1771 Session 187 (sofia/default/1030303044@172.31.40.49) Ended
2022-10-03 12:49:07.528836 78.13% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/1030303044@172.31.40.49 [CS_DESTROY]
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:735 (sofia/default/1030303044@172.31.40.49) Running State Change CS_DESTROY (Cur 1 Tot 187)
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1030303044@172.31.40.49) State DESTROY
2022-10-03 12:49:07.528836 78.13% [DEBUG] mod_sofia.c:379 sofia/default/1030303044@172.31.40.49 SOFIA DESTROY
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:175 sofia/default/1030303044@172.31.40.49 Standard DESTROY
2022-10-03 12:49:07.528836 78.13% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1030303044@172.31.40.49) State DESTROY going to sleep
2022-10-03 12:49:07.548831 78.13% [DEBUG] switch_ivr_originate.c:4035 Originate Resulted in Error Cause: 3 [NO_ROUTE_DESTINATION]
2022-10-03 12:49:07.548831 78.13% [NOTICE] switch_core_session.c:1771 Session 186 (sofia/default/1030303044@172.31.40.49:5074) Ended
2022-10-03 12:49:07.548831 78.13% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/1030303044@172.31.40.49:5074 [CS_DESTROY]
2022-10-03 12:49:07.548831 78.13% [DEBUG] switch_core_state_machine.c:735 (sofia/default/1030303044@172.31.40.49:5074) Running State Change CS_DESTROY (Cur 0 Tot 187)
2022-10-03 12:49:07.548831 78.13% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1030303044@172.31.40.49:5074) State DESTROY
2022-10-03 12:49:07.548831 78.13% [DEBUG] mod_sofia.c:379 sofia/default/1030303044@172.31.40.49:5074 SOFIA DESTROY
2022-10-03 12:49:07.548831 78.13% [DEBUG] switch_core_state_machine.c:175 sofia/default/1030303044@172.31.40.49:5074 Standard DESTROY
2022-10-03 12:49:07.548831 78.13% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1030303044@172.31.40.49:5074) State DESTROY going to sleep
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
2022-10-03 12:49:09.548861 80.27% [NOTICE] switch_channel.c:1123 New Channel sofia/default/1039999999@172.31.40.49:5074 [c1a7f36b-59f4-4706-9696-ca59997ed5de]
2022-10-03 12:49:09.548861 80.27% [DEBUG] mod_sofia.c:5121 (sofia/default/1039999999@172.31.40.49:5074) State Change CS_NEW -> CS_INIT
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1039999999@172.31.40.49:5074) Running State Change CS_INIT (Cur 1 Tot 188)
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1039999999@172.31.40.49:5074) State INIT
2022-10-03 12:49:09.548861 80.27% [DEBUG] mod_sofia.c:97 sofia/default/1039999999@172.31.40.49:5074 SOFIA INIT
2022-10-03 12:49:09.548861 80.27% [INFO] sofia_glue.c:1651 sofia/default/1039999999@172.31.40.49:5074 sending invite call-id: (null)
2022-10-03 12:49:09.548861 80.27% [DEBUG] sofia_glue.c:1654 sofia/default/1039999999@172.31.40.49:5074 sending invite version: 1.10.7 -release-19-883d2cb662 64bit
Local SDP:
v=0
o=FreeSWITCH 1664775047 1664775048 IN IP4 172.31.40.49
s=FreeSWITCH
c=IN IP4 172.31.40.49
t=0 0
m=audio 26302 RTP/AVP 8 0 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
a=sendrecv
2022-10-03 12:49:09.548861 80.27% [NOTICE] switch_channel.c:1123 New Channel sofia/default/1039999999@172.31.40.49 [84248f1c-5e21-4da7-8f6f-b87222884931]
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:40 sofia/default/1039999999@172.31.40.49:5074 Standard INIT
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1039999999@172.31.40.49:5074) State Change CS_INIT -> CS_ROUTING
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1039999999@172.31.40.49:5074) State INIT going to sleep
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1039999999@172.31.40.49:5074) Running State Change CS_ROUTING (Cur 2 Tot 189)
2022-10-03 12:49:09.548861 80.27% [DEBUG] sofia.c:7499 Channel sofia/default/1039999999@172.31.40.49:5074 entering state [calling][0]
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1039999999@172.31.40.49:5074) State ROUTING
2022-10-03 12:49:09.548861 80.27% [DEBUG] mod_sofia.c:158 sofia/default/1039999999@172.31.40.49:5074 SOFIA ROUTING
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_ivr_originate.c:67 (sofia/default/1039999999@172.31.40.49:5074) State Change CS_ROUTING -> CS_CONSUME_MEDIA
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1039999999@172.31.40.49:5074) State ROUTING going to sleep
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1039999999@172.31.40.49:5074) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 189)
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:659 (sofia/default/1039999999@172.31.40.49:5074) State CONSUME_MEDIA
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:659 (sofia/default/1039999999@172.31.40.49:5074) State CONSUME_MEDIA going to sleep
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1039999999@172.31.40.49) Running State Change CS_NEW (Cur 2 Tot 189)
2022-10-03 12:49:09.548861 80.27% [INFO] sofia.c:10462 sofia/default/1039999999@172.31.40.49 receiving invite from 172.31.40.49:5074 version: 1.10.7 -release-19-883d2cb662 64bit call-id: 9d7e18af-bdbc-123b-66b8-026398ac7998
2022-10-03 12:49:09.548861 80.27% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 172.31.40.49:0.
2022-10-03 12:49:09.548861 80.27% [DEBUG] sofia.c:11672 Setting NAT mode based on via received
2022-10-03 12:49:09.548861 80.27% [DEBUG] sofia.c:7499 Channel sofia/default/1039999999@172.31.40.49 entering state [received][100]
2022-10-03 12:49:09.548861 80.27% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=FreeSWITCH 1664775047 1664775048 IN IP4 172.31.40.49
s=FreeSWITCH
c=IN IP4 172.31.40.49
t=0 0
m=audio 26302 RTP/AVP 8 0 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/1039999999@172.31.40.49 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_codec.c:111 sofia/default/1039999999@172.31.40.49 Original read codec set to PCMA:8
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_media.c:5973 sofia/default/1039999999@172.31.40.49 Set 2833 dtmf send payload to 101 recv payload to 101
2022-10-03 12:49:09.548861 80.27% [DEBUG] sofia.c:7933 (sofia/default/1039999999@172.31.40.49) State Change CS_NEW -> CS_INIT
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:600 (sofia/default/1039999999@172.31.40.49) State NEW
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1039999999@172.31.40.49) Running State Change CS_INIT (Cur 2 Tot 189)
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1039999999@172.31.40.49) State INIT
2022-10-03 12:49:09.548861 80.27% [DEBUG] mod_sofia.c:97 sofia/default/1039999999@172.31.40.49 SOFIA INIT
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:40 sofia/default/1039999999@172.31.40.49 Standard INIT
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1039999999@172.31.40.49) State Change CS_INIT -> CS_ROUTING
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1039999999@172.31.40.49) State INIT going to sleep
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1039999999@172.31.40.49) Running State Change CS_ROUTING (Cur 2 Tot 189)
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_channel.c:2380 (sofia/default/1039999999@172.31.40.49) Callstate Change DOWN -> RINGING
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1039999999@172.31.40.49) State ROUTING
2022-10-03 12:49:09.548861 80.27% [DEBUG] mod_sofia.c:158 sofia/default/1039999999@172.31.40.49 SOFIA ROUTING
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_core_state_machine.c:230 sofia/default/1039999999@172.31.40.49 Standard ROUTING
2022-10-03 12:49:09.548861 80.27% [INFO] mod_dialplan_xml.c:639 Processing 9497482480 <1039999999>->1039999999 in context default
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
2022-10-03 12:49:09.548861 80.27% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2022-10-03 12:49:09.568837 80.27% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 1039999999
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Clicktocall Destination Number 1039999999
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '1039999999' AND status=0 limit 1
2022-10-03 12:49:09.568837 80.27% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 9497482480 / 1039999999
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1039999999" LIMIT 1
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="1039999999" limit 1
2022-10-03 12:49:09.568837 80.27% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("172.31.40.49") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "1039999999" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
2022-10-03 12:49:09.568837 80.27% [ERR] switch_core_sqldb.c:1310 ERR: [SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("172.31.40.49") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "1039999999" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1]
[STATE: HY000 CODE 1690 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.30]BIGINT UNSIGNED value is out of range in '((0x01 << (32 - substring_index(`astpp`.`ip_map`.`ip`,'/',<cache>(-(1))))) - 1)'
]
2022-10-03 12:49:09.568837 80.27% [ERR] mod_lua.cpp:202 /usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:154: assertion failed!
stack traceback:
[C]: in function 'assert'
/usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:154: in function </usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:150>
(...tail calls...)
...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:119: in main chunk
[C]: in function 'dofile'
/usr/share/freeswitch/scripts/astpp/astpp.lua:85: in main chunk
2022-10-03 12:49:09.568837 80.27% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
2022-10-03 12:49:09.568837 80.27% [WARNING] mod_dialplan_xml.c:669 Context default not found
2022-10-03 12:49:09.568837 80.27% [INFO] switch_core_state_machine.c:306 No Route, Aborting
2022-10-03 12:49:09.568837 80.27% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/1039999999@172.31.40.49 [CS_ROUTING] [NO_ROUTE_DESTINATION]
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1039999999@172.31.40.49) State ROUTING going to sleep
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1039999999@172.31.40.49) Running State Change CS_HANGUP (Cur 2 Tot 189)
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1039999999@172.31.40.49) Callstate Change RINGING -> HANGUP
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1039999999@172.31.40.49) State HANGUP
2022-10-03 12:49:09.568837 80.27% [DEBUG] mod_sofia.c:468 Channel sofia/default/1039999999@172.31.40.49 hanging up, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:09.568837 80.27% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:59 sofia/default/1039999999@172.31.40.49 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1039999999@172.31.40.49) State HANGUP going to sleep
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1039999999@172.31.40.49) State Change CS_HANGUP -> CS_REPORTING
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1039999999@172.31.40.49) Running State Change CS_REPORTING (Cur 2 Tot 189)
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1039999999@172.31.40.49) State REPORTING
2022-10-03 12:49:09.568837 80.27% [INFO] mod_json_cdr.c:271 Process [84248f1c-5e21-4da7-8f6f-b87222884931.cdr.json]
2022-10-03 12:49:09.568837 80.27% [DEBUG] sofia.c:6678 Remote Reason: 3
2022-10-03 12:49:09.568837 80.27% [DEBUG] sofia.c:7499 Channel sofia/default/1039999999@172.31.40.49:5074 entering state [terminated][404]
2022-10-03 12:49:09.568837 80.27% [NOTICE] sofia.c:8738 Hangup sofia/default/1039999999@172.31.40.49:5074 [CS_CONSUME_MEDIA] [NO_ROUTE_DESTINATION]
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1039999999@172.31.40.49:5074) Running State Change CS_HANGUP (Cur 2 Tot 189)
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1039999999@172.31.40.49:5074) Callstate Change DOWN -> HANGUP
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1039999999@172.31.40.49:5074) State HANGUP
2022-10-03 12:49:09.568837 80.27% [DEBUG] mod_sofia.c:468 Channel sofia/default/1039999999@172.31.40.49:5074 hanging up, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:59 sofia/default/1039999999@172.31.40.49:5074 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1039999999@172.31.40.49:5074) State HANGUP going to sleep
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1039999999@172.31.40.49:5074) State Change CS_HANGUP -> CS_REPORTING
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1039999999@172.31.40.49:5074) Running State Change CS_REPORTING (Cur 2 Tot 189)
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1039999999@172.31.40.49:5074) State REPORTING
2022-10-03 12:49:09.568837 80.27% [INFO] mod_json_cdr.c:271 Process [c1a7f36b-59f4-4706-9696-ca59997ed5de.cdr.json]
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_ivr_originate.c:4035 Originate Resulted in Error Cause: 3 [NO_ROUTE_DESTINATION]
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:168 sofia/default/1039999999@172.31.40.49:5074 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1039999999@172.31.40.49:5074) State REPORTING going to sleep
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:607 (sofia/default/1039999999@172.31.40.49:5074) State Change CS_REPORTING -> CS_DESTROY
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_session.c:1753 Session 188 (sofia/default/1039999999@172.31.40.49:5074) Locked, Waiting on external entities
2022-10-03 12:49:09.568837 80.27% [NOTICE] switch_core_session.c:1771 Session 188 (sofia/default/1039999999@172.31.40.49:5074) Ended
2022-10-03 12:49:09.568837 80.27% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/1039999999@172.31.40.49:5074 [CS_DESTROY]
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:735 (sofia/default/1039999999@172.31.40.49:5074) Running State Change CS_DESTROY (Cur 1 Tot 189)
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1039999999@172.31.40.49:5074) State DESTROY
2022-10-03 12:49:09.568837 80.27% [DEBUG] mod_sofia.c:379 sofia/default/1039999999@172.31.40.49:5074 SOFIA DESTROY
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:175 sofia/default/1039999999@172.31.40.49:5074 Standard DESTROY
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1039999999@172.31.40.49:5074) State DESTROY going to sleep
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:168 sofia/default/1039999999@172.31.40.49 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1039999999@172.31.40.49) State REPORTING going to sleep
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_state_machine.c:607 (sofia/default/1039999999@172.31.40.49) State Change CS_REPORTING -> CS_DESTROY
2022-10-03 12:49:09.568837 80.27% [DEBUG] switch_core_session.c:1753 Session 189 (sofia/default/1039999999@172.31.40.49) Locked, Waiting on external entities
2022-10-03 12:49:09.568837 80.27% [NOTICE] switch_core_session.c:1771 Session 189 (sofia/default/1039999999@172.31.40.49) Ended
2022-10-03 12:49:09.568837 80.27% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/1039999999@172.31.40.49 [CS_DESTROY]
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:735 (sofia/default/1039999999@172.31.40.49) Running State Change CS_DESTROY (Cur 0 Tot 189)
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1039999999@172.31.40.49) State DESTROY
2022-10-03 12:49:09.588833 80.27% [DEBUG] mod_sofia.c:379 sofia/default/1039999999@172.31.40.49 SOFIA DESTROY
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:175 sofia/default/1039999999@172.31.40.49 Standard DESTROY
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1039999999@172.31.40.49) State DESTROY going to sleep
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
2022-10-03 12:49:09.588833 80.27% [NOTICE] switch_channel.c:1123 New Channel sofia/default/1077777777@172.31.40.49:5074 [0dec4fc7-972e-4bd8-a2a5-99863c14e60f]
2022-10-03 12:49:09.588833 80.27% [DEBUG] mod_sofia.c:5121 (sofia/default/1077777777@172.31.40.49:5074) State Change CS_NEW -> CS_INIT
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1077777777@172.31.40.49:5074) Running State Change CS_INIT (Cur 1 Tot 190)
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1077777777@172.31.40.49:5074) State INIT
2022-10-03 12:49:09.588833 80.27% [DEBUG] mod_sofia.c:97 sofia/default/1077777777@172.31.40.49:5074 SOFIA INIT
2022-10-03 12:49:09.588833 80.27% [INFO] sofia_glue.c:1651 sofia/default/1077777777@172.31.40.49:5074 sending invite call-id: (null)
2022-10-03 12:49:09.588833 80.27% [DEBUG] sofia_glue.c:1654 sofia/default/1077777777@172.31.40.49:5074 sending invite version: 1.10.7 -release-19-883d2cb662 64bit
Local SDP:
v=0
o=FreeSWITCH 1664773063 1664773064 IN IP4 172.31.40.49
s=FreeSWITCH
c=IN IP4 172.31.40.49
t=0 0
m=audio 28286 RTP/AVP 8 0 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
a=sendrecv
2022-10-03 12:49:09.588833 80.27% [NOTICE] switch_channel.c:1123 New Channel sofia/default/1077777777@172.31.40.49 [a911e019-fbcf-4f53-9ded-9d5c398c556b]
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:40 sofia/default/1077777777@172.31.40.49:5074 Standard INIT
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1077777777@172.31.40.49:5074) State Change CS_INIT -> CS_ROUTING
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1077777777@172.31.40.49:5074) State INIT going to sleep
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1077777777@172.31.40.49:5074) Running State Change CS_ROUTING (Cur 2 Tot 191)
2022-10-03 12:49:09.588833 80.27% [DEBUG] sofia.c:7499 Channel sofia/default/1077777777@172.31.40.49:5074 entering state [calling][0]
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1077777777@172.31.40.49:5074) State ROUTING
2022-10-03 12:49:09.588833 80.27% [DEBUG] mod_sofia.c:158 sofia/default/1077777777@172.31.40.49:5074 SOFIA ROUTING
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_ivr_originate.c:67 (sofia/default/1077777777@172.31.40.49:5074) State Change CS_ROUTING -> CS_CONSUME_MEDIA
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1077777777@172.31.40.49:5074) State ROUTING going to sleep
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1077777777@172.31.40.49:5074) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 191)
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:659 (sofia/default/1077777777@172.31.40.49:5074) State CONSUME_MEDIA
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:659 (sofia/default/1077777777@172.31.40.49:5074) State CONSUME_MEDIA going to sleep
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1077777777@172.31.40.49) Running State Change CS_NEW (Cur 2 Tot 191)
2022-10-03 12:49:09.588833 80.27% [INFO] sofia.c:10462 sofia/default/1077777777@172.31.40.49 receiving invite from 172.31.40.49:5074 version: 1.10.7 -release-19-883d2cb662 64bit call-id: 9d83951f-bdbc-123b-66b8-026398ac7998
2022-10-03 12:49:09.588833 80.27% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 172.31.40.49:0.
2022-10-03 12:49:09.588833 80.27% [DEBUG] sofia.c:11672 Setting NAT mode based on via received
2022-10-03 12:49:09.588833 80.27% [DEBUG] sofia.c:7499 Channel sofia/default/1077777777@172.31.40.49 entering state [received][100]
2022-10-03 12:49:09.588833 80.27% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=FreeSWITCH 1664773063 1664773064 IN IP4 172.31.40.49
s=FreeSWITCH
c=IN IP4 172.31.40.49
t=0 0
m=audio 28286 RTP/AVP 8 0 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/1077777777@172.31.40.49 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_codec.c:111 sofia/default/1077777777@172.31.40.49 Original read codec set to PCMA:8
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_media.c:5973 sofia/default/1077777777@172.31.40.49 Set 2833 dtmf send payload to 101 recv payload to 101
2022-10-03 12:49:09.588833 80.27% [DEBUG] sofia.c:7933 (sofia/default/1077777777@172.31.40.49) State Change CS_NEW -> CS_INIT
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:600 (sofia/default/1077777777@172.31.40.49) State NEW
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1077777777@172.31.40.49) Running State Change CS_INIT (Cur 2 Tot 191)
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1077777777@172.31.40.49) State INIT
2022-10-03 12:49:09.588833 80.27% [DEBUG] mod_sofia.c:97 sofia/default/1077777777@172.31.40.49 SOFIA INIT
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:40 sofia/default/1077777777@172.31.40.49 Standard INIT
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1077777777@172.31.40.49) State Change CS_INIT -> CS_ROUTING
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1077777777@172.31.40.49) State INIT going to sleep
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1077777777@172.31.40.49) Running State Change CS_ROUTING (Cur 2 Tot 191)
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_channel.c:2380 (sofia/default/1077777777@172.31.40.49) Callstate Change DOWN -> RINGING
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1077777777@172.31.40.49) State ROUTING
2022-10-03 12:49:09.588833 80.27% [DEBUG] mod_sofia.c:158 sofia/default/1077777777@172.31.40.49 SOFIA ROUTING
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_core_state_machine.c:230 sofia/default/1077777777@172.31.40.49 Standard ROUTING
2022-10-03 12:49:09.588833 80.27% [INFO] mod_dialplan_xml.c:639 Processing 9497482480 <1077777777>->1077777777 in context default
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2022-10-03 12:49:09.588833 80.27% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 1077777777
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Clicktocall Destination Number 1077777777
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '1077777777' AND status=0 limit 1
2022-10-03 12:49:09.588833 80.27% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 9497482480 / 1077777777
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1077777777" LIMIT 1
2022-10-03 12:49:09.588833 80.27% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="1077777777" limit 1
2022-10-03 12:49:09.608839 80.27% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("172.31.40.49") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "1077777777" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
2022-10-03 12:49:09.608839 80.27% [ERR] switch_core_sqldb.c:1310 ERR: [SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("172.31.40.49") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "1077777777" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1]
[STATE: HY000 CODE 1690 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.30]BIGINT UNSIGNED value is out of range in '((0x01 << (32 - substring_index(`astpp`.`ip_map`.`ip`,'/',<cache>(-(1))))) - 1)'
]
2022-10-03 12:49:09.608839 80.27% [ERR] mod_lua.cpp:202 /usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:154: assertion failed!
stack traceback:
[C]: in function 'assert'
/usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:154: in function </usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:150>
(...tail calls...)
...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:119: in main chunk
[C]: in function 'dofile'
/usr/share/freeswitch/scripts/astpp/astpp.lua:85: in main chunk
2022-10-03 12:49:09.608839 80.27% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
2022-10-03 12:49:09.608839 80.27% [WARNING] mod_dialplan_xml.c:669 Context default not found
2022-10-03 12:49:09.608839 80.27% [INFO] switch_core_state_machine.c:306 No Route, Aborting
2022-10-03 12:49:09.608839 80.27% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/1077777777@172.31.40.49 [CS_ROUTING] [NO_ROUTE_DESTINATION]
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1077777777@172.31.40.49) State ROUTING going to sleep
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1077777777@172.31.40.49) Running State Change CS_HANGUP (Cur 2 Tot 191)
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1077777777@172.31.40.49) Callstate Change RINGING -> HANGUP
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1077777777@172.31.40.49) State HANGUP
2022-10-03 12:49:09.608839 80.27% [DEBUG] mod_sofia.c:468 Channel sofia/default/1077777777@172.31.40.49 hanging up, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:09.608839 80.27% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:59 sofia/default/1077777777@172.31.40.49 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1077777777@172.31.40.49) State HANGUP going to sleep
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1077777777@172.31.40.49) State Change CS_HANGUP -> CS_REPORTING
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1077777777@172.31.40.49) Running State Change CS_REPORTING (Cur 2 Tot 191)
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1077777777@172.31.40.49) State REPORTING
2022-10-03 12:49:09.608839 80.27% [INFO] mod_json_cdr.c:271 Process [a911e019-fbcf-4f53-9ded-9d5c398c556b.cdr.json]
2022-10-03 12:49:09.608839 80.27% [DEBUG] sofia.c:6678 Remote Reason: 3
2022-10-03 12:49:09.608839 80.27% [DEBUG] sofia.c:7499 Channel sofia/default/1077777777@172.31.40.49:5074 entering state [terminated][404]
2022-10-03 12:49:09.608839 80.27% [NOTICE] sofia.c:8738 Hangup sofia/default/1077777777@172.31.40.49:5074 [CS_CONSUME_MEDIA] [NO_ROUTE_DESTINATION]
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1077777777@172.31.40.49:5074) Running State Change CS_HANGUP (Cur 2 Tot 191)
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1077777777@172.31.40.49:5074) Callstate Change DOWN -> HANGUP
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1077777777@172.31.40.49:5074) State HANGUP
2022-10-03 12:49:09.608839 80.27% [DEBUG] mod_sofia.c:468 Channel sofia/default/1077777777@172.31.40.49:5074 hanging up, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:59 sofia/default/1077777777@172.31.40.49:5074 Standard HANGUP, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1077777777@172.31.40.49:5074) State HANGUP going to sleep
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1077777777@172.31.40.49:5074) State Change CS_HANGUP -> CS_REPORTING
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1077777777@172.31.40.49:5074) Running State Change CS_REPORTING (Cur 2 Tot 191)
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1077777777@172.31.40.49:5074) State REPORTING
2022-10-03 12:49:09.608839 80.27% [INFO] mod_json_cdr.c:271 Process [0dec4fc7-972e-4bd8-a2a5-99863c14e60f.cdr.json]
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_ivr_originate.c:4035 Originate Resulted in Error Cause: 3 [NO_ROUTE_DESTINATION]
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:168 sofia/default/1077777777@172.31.40.49:5074 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1077777777@172.31.40.49:5074) State REPORTING going to sleep
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:607 (sofia/default/1077777777@172.31.40.49:5074) State Change CS_REPORTING -> CS_DESTROY
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_session.c:1753 Session 190 (sofia/default/1077777777@172.31.40.49:5074) Locked, Waiting on external entities
2022-10-03 12:49:09.608839 80.27% [NOTICE] switch_core_session.c:1771 Session 190 (sofia/default/1077777777@172.31.40.49:5074) Ended
2022-10-03 12:49:09.608839 80.27% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/1077777777@172.31.40.49:5074 [CS_DESTROY]
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:735 (sofia/default/1077777777@172.31.40.49:5074) Running State Change CS_DESTROY (Cur 1 Tot 191)
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1077777777@172.31.40.49:5074) State DESTROY
2022-10-03 12:49:09.608839 80.27% [DEBUG] mod_sofia.c:379 sofia/default/1077777777@172.31.40.49:5074 SOFIA DESTROY
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:175 sofia/default/1077777777@172.31.40.49:5074 Standard DESTROY
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1077777777@172.31.40.49:5074) State DESTROY going to sleep
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:168 sofia/default/1077777777@172.31.40.49 Standard REPORTING, cause: NO_ROUTE_DESTINATION
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1077777777@172.31.40.49) State REPORTING going to sleep
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:607 (sofia/default/1077777777@172.31.40.49) State Change CS_REPORTING -> CS_DESTROY
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_session.c:1753 Session 191 (sofia/default/1077777777@172.31.40.49) Locked, Waiting on external entities
2022-10-03 12:49:09.608839 80.27% [NOTICE] switch_core_session.c:1771 Session 191 (sofia/default/1077777777@172.31.40.49) Ended
2022-10-03 12:49:09.608839 80.27% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/1077777777@172.31.40.49 [CS_DESTROY]
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:735 (sofia/default/1077777777@172.31.40.49) Running State Change CS_DESTROY (Cur 0 Tot 191)
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1077777777@172.31.40.49) State DESTROY
2022-10-03 12:49:09.608839 80.27% [DEBUG] mod_sofia.c:379 sofia/default/1077777777@172.31.40.49 SOFIA DESTROY
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:175 sofia/default/1077777777@172.31.40.49 Standard DESTROY
2022-10-03 12:49:09.608839 80.27% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1077777777@172.31.40.49) State DESTROY going to sleep
2022-10-03 12:49:14.348861 83.07% [NOTICE] sofia_reg.c:459 Registering 8134791837
2022-10-03 12:49:14.468842 83.07% [ERR] sofia_reg.c:2677 8134791837 Failed Registration with status Service Unavailable [503]. failure #10952
2022-10-03 12:49:15.348845 83.47% [WARNING] sofia_reg.c:516 8134791837 Failed Registration [503], setting retry to 30 seconds.
2022-10-03 12:49:17.988831 84.83% [WARNING] sofia_reg.c:1861 SIP auth challenge (REGISTER) on sofia profile 'default' for [845296@13.127.15.161] from ip 103.240.35.46
2022-10-03 12:49:18.208836 84.83% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [845296@13.127.15.161] from ip 103.240.35.46
2022-10-03 12:49:18.648833 84.83% [WARNING] sofia_reg.c:1861 SIP auth challenge (REGISTER) on sofia profile 'default' for [9497482480@13.127.15.161] from ip 103.240.35.46
2022-10-03 12:49:18.828858 84.97% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [9497482480@13.127.15.161] from ip 103.240.35.46
2022-10-03 12:49:26.608858 88.40% [WARNING] sofia_reg.c:1861 SIP auth challenge (REGISTER) on sofia profile 'default' for [9497482480@13.127.15.161] from ip 103.240.35.46