2024-03-19 14:55:38.304174 [NOTICE] sofia.c:1012 Hangup sofia/default/0686637963 [CS_EXCHANGE_MEDIA] [NORMAL_CLEARING] 2024-03-19 14:55:38.304174 [DEBUG] switch_ivr_bridge.c:787 BRIDGE THREAD DONE [sofia/default/0686637963] 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:653 (sofia/default/0686637963) State EXCHANGE_MEDIA going to sleep 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0686637963) Running State Change CS_HANGUP (Cur 20 Tot 536009) 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:850 (sofia/default/0686637963) Callstate Change ACTIVE -> HANGUP 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:852 (sofia/default/0686637963) State HANGUP 2024-03-19 14:55:38.304174 [DEBUG] mod_sofia.c:438 Channel sofia/default/0686637963 hanging up, cause: NORMAL_CLEARING 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:60 sofia/default/0686637963 Standard HANGUP, cause: NORMAL_CLEARING 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:852 (sofia/default/0686637963) State HANGUP going to sleep 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:619 (sofia/default/0686637963) State Change CS_HANGUP -> CS_REPORTING 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0686637963) Running State Change CS_REPORTING (Cur 20 Tot 536009) 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:938 (sofia/default/0686637963) State REPORTING 2024-03-19 14:55:38.304174 [INFO] mod_json_cdr.c:271 Process [b2cac45a-e600-11ee-89aa-d17fbcf33421.cdr.json] 2024-03-19 14:55:38.304174 [DEBUG] switch_ivr_bridge.c:706 sofia/default/0686637963 ending bridge by request from write function 2024-03-19 14:55:38.304174 [DEBUG] switch_ivr_bridge.c:787 BRIDGE THREAD DONE [sofia/default/0117030026@legalaidsa.nebular.co.za:5060] 2024-03-19 14:55:38.304174 [DEBUG] switch_ivr_bridge.c:1712 sofia/default/0686637963 skip receive message [UNBRIDGE] (channel is hungup already) 2024-03-19 14:55:38.304174 [NOTICE] switch_ivr_bridge.c:1764 Hangup sofia/default/0117030026@legalaidsa.nebular.co.za:5060 [CS_EXECUTE] [NORMAL_CLEARING] 2024-03-19 14:55:38.304174 [DEBUG] switch_core_session.c:2815 sofia/default/0117030026@legalaidsa.nebular.co.za:5060 skip receive message [APPLICATION_EXEC_COMPLETE] (channel is hungup already) 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:650 (sofia/default/0117030026@legalaidsa.nebular.co.za:5060) State EXECUTE going to sleep 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0117030026@legalaidsa.nebular.co.za:5060) Running State Change CS_HANGUP (Cur 20 Tot 536009) 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:850 (sofia/default/0117030026@legalaidsa.nebular.co.za:5060) Callstate Change ACTIVE -> HANGUP 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:852 (sofia/default/0117030026@legalaidsa.nebular.co.za:5060) State HANGUP 2024-03-19 14:55:38.304174 [DEBUG] mod_sofia.c:432 sofia/default/0117030026@legalaidsa.nebular.co.za:5060 Overriding SIP cause 480 with 200 from the other leg 2024-03-19 14:55:38.304174 [DEBUG] mod_sofia.c:438 Channel sofia/default/0117030026@legalaidsa.nebular.co.za:5060 hanging up, cause: NORMAL_CLEARING 2024-03-19 14:55:38.304174 [DEBUG] mod_sofia.c:491 Sending BYE to sofia/default/0117030026@legalaidsa.nebular.co.za:5060 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:60 sofia/default/0117030026@legalaidsa.nebular.co.za:5060 Standard HANGUP, cause: NORMAL_CLEARING 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:852 (sofia/default/0117030026@legalaidsa.nebular.co.za:5060) State HANGUP going to sleep 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:619 (sofia/default/0117030026@legalaidsa.nebular.co.za:5060) State Change CS_HANGUP -> CS_REPORTING 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0117030026@legalaidsa.nebular.co.za:5060) Running State Change CS_REPORTING (Cur 20 Tot 536009) 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:938 (sofia/default/0117030026@legalaidsa.nebular.co.za:5060) State REPORTING 2024-03-19 14:55:38.304174 [INFO] mod_json_cdr.c:271 Process [b2bb55c4-e600-11ee-8987-d17fbcf33421.cdr.json] 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:174 sofia/default/0686637963 Standard REPORTING, cause: NORMAL_CLEARING 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:938 (sofia/default/0686637963) State REPORTING going to sleep 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:610 (sofia/default/0686637963) State Change CS_REPORTING -> CS_DESTROY 2024-03-19 14:55:38.304174 [DEBUG] switch_core_session.c:1665 Session 536007 (sofia/default/0686637963) Locked, Waiting on external entities 2024-03-19 14:55:38.304174 [NOTICE] switch_core_session.c:1683 Session 536007 (sofia/default/0686637963) Ended 2024-03-19 14:55:38.304174 [NOTICE] switch_core_session.c:1687 Close Channel sofia/default/0686637963 [CS_DESTROY] 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:741 (sofia/default/0686637963) Running State Change CS_DESTROY (Cur 19 Tot 536009) 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:751 (sofia/default/0686637963) State DESTROY 2024-03-19 14:55:38.304174 [DEBUG] mod_sofia.c:343 sofia/default/0686637963 SOFIA DESTROY 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:181 sofia/default/0686637963 Standard DESTROY 2024-03-19 14:55:38.304174 [DEBUG] switch_core_state_machine.c:751 (sofia/default/0686637963) State DESTROY going to sleep 2024-03-19 14:55:38.344159 [DEBUG] switch_core_state_machine.c:174 sofia/default/0117030026@legalaidsa.nebular.co.za:5060 Standard REPORTING, cause: NORMAL_CLEARING 2024-03-19 14:55:38.344159 [DEBUG] switch_core_state_machine.c:938 (sofia/default/0117030026@legalaidsa.nebular.co.za:5060) State REPORTING going to sleep 2024-03-19 14:55:38.344159 [DEBUG] switch_core_state_machine.c:610 (sofia/default/0117030026@legalaidsa.nebular.co.za:5060) State Change CS_REPORTING -> CS_DESTROY 2024-03-19 14:55:38.344159 [DEBUG] switch_core_session.c:1665 Session 536006 (sofia/default/0117030026@legalaidsa.nebular.co.za:5060) Locked, Waiting on external entities 2024-03-19 14:55:38.344159 [NOTICE] switch_core_session.c:1683 Session 536006 (sofia/default/0117030026@legalaidsa.nebular.co.za:5060) Ended 2024-03-19 14:55:38.344159 [NOTICE] switch_core_session.c:1687 Close Channel sofia/default/0117030026@legalaidsa.nebular.co.za:5060 [CS_DESTROY] 2024-03-19 14:55:38.344159 [DEBUG] switch_core_state_machine.c:741 (sofia/default/0117030026@legalaidsa.nebular.co.za:5060) Running State Change CS_DESTROY (Cur 18 Tot 536009) 2024-03-19 14:55:38.344159 [DEBUG] switch_core_state_machine.c:751 (sofia/default/0117030026@legalaidsa.nebular.co.za:5060) State DESTROY 2024-03-19 14:55:38.344159 [DEBUG] mod_sofia.c:343 sofia/default/0117030026@legalaidsa.nebular.co.za:5060 SOFIA DESTROY 2024-03-19 14:55:38.344159 [DEBUG] switch_core_state_machine.c:181 sofia/default/0117030026@legalaidsa.nebular.co.za:5060 Standard DESTROY 2024-03-19 14:55:38.344159 [DEBUG] switch_core_state_machine.c:751 (sofia/default/0117030026@legalaidsa.nebular.co.za:5060) State DESTROY going to sleep freeswitch@primary> 2024-03-19 14:55:38.404157 [DEBUG] switch_scheduler.c:144 Deleting task 216770 switch_ivr_schedule_hangup (b2cac45a-e600-11ee-89aa-d17fbcf33421) freeswitch@primary> freeswitch@primary> freeswitch@primary> 2024-03-19 14:55:47.644332 [DEBUG] sofia.c:7084 Channel sofia/default/6085507138@legalaidsa.nebular.co.za entering state [completing][200] 2024-03-19 14:55:47.644332 [DEBUG] sofia.c:7094 Remote SDP: v=0 o=3cxPS 120913395712 100042539009 IN IP4 156.38.150.6 s=3cxPS Audio call c=IN IP4 156.38.150.6 t=0 0 m=audio 9716 RTP/AVP 18 101 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no a=rtpmap:101 telephone-event/8000 2024-03-19 14:55:47.644332 [DEBUG] sofia.c:7084 Channel sofia/default/6085507138@legalaidsa.nebular.co.za entering state [ready][200] 2024-03-19 14:55:47.644332 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G729:18:8000:20:8000:1]/[G729:18:8000:20:8000:1] 2024-03-19 14:55:47.644332 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [G729:18:8000:20:8000:1] ++++ is saved as a match 2024-03-19 14:55:47.644332 [DEBUG] switch_core_media.c:4365 Set telephone-event payload to 101@8000 2024-03-19 14:55:47.644332 [DEBUG] switch_core_media.c:3061 Set Codec sofia/default/6085507138@legalaidsa.nebular.co.za G729/8000 20 ms 160 samples 8000 bits 1 channels 2024-03-19 14:55:47.644332 [DEBUG] switch_core_codec.c:111 sofia/default/6085507138@legalaidsa.nebular.co.za Original read codec set to G729:18 2024-03-19 14:55:47.644332 [DEBUG] switch_core_media.c:4708 Set telephone-event payload to 101@8000 2024-03-19 14:55:47.644332 [DEBUG] switch_core_media.c:4767 sofia/default/6085507138@legalaidsa.nebular.co.za Set 2833 dtmf send payload to 101 recv payload to 101 2024-03-19 14:55:47.644332 [DEBUG] switch_core_media.c:6878 AUDIO RTP [sofia/default/6085507138@legalaidsa.nebular.co.za] 156.38.231.107 port 27058 -> 156.38.150.6 port 9716 codec: 18 ms: 20 2024-03-19 14:55:47.644332 [DEBUG] switch_rtp.c:4137 Starting timer [soft] 160 bytes per 20ms 2024-03-19 14:55:47.644332 [DEBUG] switch_core_media.c:7180 sofia/default/6085507138@legalaidsa.nebular.co.za Set 2833 dtmf send payload to 101 2024-03-19 14:55:47.644332 [DEBUG] switch_core_media.c:7187 sofia/default/6085507138@legalaidsa.nebular.co.za Set 2833 dtmf receive payload to 101 2024-03-19 14:55:47.644332 [DEBUG] switch_core_media.c:7210 sofia/default/6085507138@legalaidsa.nebular.co.za Set rtp dtmf delay to 40 2024-03-19 14:55:47.644332 [NOTICE] sofia.c:8218 Channel [sofia/default/6085507138@legalaidsa.nebular.co.za] has been answered 2024-03-19 14:55:47.644332 [DEBUG] switch_channel.c:3773 (sofia/default/6085507138@legalaidsa.nebular.co.za) Callstate Change RINGING -> ACTIVE 2024-03-19 14:55:47.644332 [DEBUG] switch_core_media.c:6878 AUDIO RTP [sofia/default/027693695902@41.160.32.115:5060] 156.38.231.107 port 23398 -> 41.160.32.115 port 22226 codec: 18 ms: 20 2024-03-19 14:55:47.644332 [DEBUG] switch_rtp.c:4137 Starting timer [soft] 160 bytes per 20ms 2024-03-19 14:55:47.644332 [DEBUG] switch_core_media.c:7180 sofia/default/027693695902@41.160.32.115:5060 Set 2833 dtmf send payload to 101 2024-03-19 14:55:47.644332 [DEBUG] switch_core_media.c:7187 sofia/default/027693695902@41.160.32.115:5060 Set 2833 dtmf receive payload to 101 2024-03-19 14:55:47.644332 [DEBUG] switch_core_media.c:7210 sofia/default/027693695902@41.160.32.115:5060 Set rtp dtmf delay to 40 2024-03-19 14:55:47.644332 [DEBUG] mod_sofia.c:850 Local SDP sofia/default/027693695902@41.160.32.115:5060: v=0 o=FreeSWITCH 1710836749 1710836750 IN IP4 156.38.231.107 s=FreeSWITCH c=IN IP4 156.38.231.107 t=0 0 m=audio 23398 RTP/AVP 18 101 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=yes a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=ptime:20 a=sendrecv 2024-03-19 14:55:47.644332 [NOTICE] switch_ivr_originate.c:3647 Channel [sofia/default/027693695902@41.160.32.115:5060] has been answered 2024-03-19 14:55:47.644332 [DEBUG] switch_channel.c:3773 (sofia/default/027693695902@41.160.32.115:5060) Callstate Change RINGING -> ACTIVE 2024-03-19 14:55:47.644332 [DEBUG] sofia.c:7084 Channel sofia/default/027693695902@41.160.32.115:5060 entering state [completed][200] 2024-03-19 14:55:47.644332 [DEBUG] switch_ivr_originate.c:3705 Originate Resulted in Success: [sofia/default/6085507138@legalaidsa.nebular.co.za] 2024-03-19 14:55:47.644332 [DEBUG] switch_ivr_bridge.c:1614 (sofia/default/6085507138@legalaidsa.nebular.co.za) State Change CS_CONSUME_MEDIA -> CS_EXCHANGE_MEDIA 2024-03-19 14:55:47.644332 [DEBUG] switch_core_state_machine.c:584 (sofia/default/6085507138@legalaidsa.nebular.co.za) Running State Change CS_EXCHANGE_MEDIA (Cur 18 Tot 536009) 2024-03-19 14:55:47.644332 [DEBUG] switch_core_state_machine.c:653 (sofia/default/6085507138@legalaidsa.nebular.co.za) State EXCHANGE_MEDIA 2024-03-19 14:55:47.644332 [DEBUG] mod_sofia.c:631 SOFIA EXCHANGE_MEDIA 2024-03-19 14:55:47.764199 [DEBUG] switch_rtp.c:7308 Correct audio ip/port confirmed. 2024-03-19 14:55:47.844181 [DEBUG] switch_ivr_bridge.c:546 sofia/default/6085507138@legalaidsa.nebular.co.za Bridge execute app sched_hangup(+6000 normal_clearing) 2024-03-19 14:55:47.864169 [DEBUG] switch_ivr.c:623 sofia/default/6085507138@legalaidsa.nebular.co.za Command Execute sched_hangup(+6000 normal_clearing) EXECUTE sofia/default/6085507138@legalaidsa.nebular.co.za sched_hangup(+6000 normal_clearing) 2024-03-19 14:55:47.864169 [DEBUG] switch_scheduler.c:249 Added task 216771 switch_ivr_schedule_hangup (b916bc56-e600-11ee-89d8-d17fbcf33421) to run at 1710866147 2024-03-19 14:55:47.924177 [INFO] switch_rtp.c:7268 Auto Changing audio port from 156.38.150.6:9716 to 156.38.231.105:9716 2024-03-19 14:55:48.004179 [DEBUG] sofia.c:7084 Channel sofia/default/027693695902@41.160.32.115:5060 entering state [ready][200] 2024-03-19 14:55:49.204183 [NOTICE] switch_channel.c:1104 New Channel sofia/default/0734382646@41.160.32.115:5060 [c60bf002-e600-11ee-89de-d17fbcf33421] 2024-03-19 14:55:49.204183 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0734382646@41.160.32.115:5060) Running State Change CS_NEW (Cur 19 Tot 536010) 2024-03-19 14:55:49.204183 [DEBUG] sofia.c:9873 sofia/default/0734382646@41.160.32.115:5060 receiving invite from 156.38.231.106:5060 version: 1.6.20 64bit 2024-03-19 14:55:49.204183 [DEBUG] sofia.c:9989 IP 156.38.231.106 Approved by acl "default[]". Access Granted. 2024-03-19 14:55:49.204183 [DEBUG] sofia.c:7084 Channel sofia/default/0734382646@41.160.32.115:5060 entering state [received][100] 2024-03-19 14:55:49.204183 [DEBUG] sofia.c:7094 Remote SDP: v=0 o=HuaweiSoftX3000 111760388460017 111760388460017 IN IP4 41.160.32.115 s=- c=IN IP4 41.160.32.115 t=0 0 m=audio 22228 RTP/AVP 18 8 0 101 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no a=rtpmap:8 PCMA/8000 a=rtpmap:0 PCMU/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-15 a=ptime:20 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G729:18:8000:20:8000:1]/[G729:18:8000:60:8000:1] 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4485 Audio Codec Compare [G729:18:8000:60:8000:1] is saved as a near-match 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G729:18:8000:20:8000:1]/[G729:18:8000:20:8000:1] 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [G729:18:8000:20:8000:1] ++++ is saved as a match 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMA:8:8000:20:64000:1] 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMU:0:8000:20:64000:1] 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:60:8000:1] 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:60:8000:1] 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4365 Set telephone-event payload to 101@8000 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:3061 Set Codec sofia/default/0734382646@41.160.32.115:5060 G729/8000 20 ms 160 samples 8000 bits 1 channels 2024-03-19 14:55:49.204183 [DEBUG] switch_core_codec.c:111 sofia/default/0734382646@41.160.32.115:5060 Original read codec set to G729:18 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4708 Set telephone-event payload to 101@8000 2024-03-19 14:55:49.204183 [DEBUG] switch_core_media.c:4767 sofia/default/0734382646@41.160.32.115:5060 Set 2833 dtmf send payload to 101 recv payload to 101 2024-03-19 14:55:49.204183 [DEBUG] sofia.c:7507 (sofia/default/0734382646@41.160.32.115:5060) State Change CS_NEW -> CS_INIT 2024-03-19 14:55:49.204183 [DEBUG] switch_core_state_machine.c:603 (sofia/default/0734382646@41.160.32.115:5060) State NEW 2024-03-19 14:55:49.204183 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0734382646@41.160.32.115:5060) Running State Change CS_INIT (Cur 19 Tot 536010) 2024-03-19 14:55:49.204183 [DEBUG] switch_core_state_machine.c:627 (sofia/default/0734382646@41.160.32.115:5060) State INIT 2024-03-19 14:55:49.204183 [DEBUG] mod_sofia.c:90 sofia/default/0734382646@41.160.32.115:5060 SOFIA INIT 2024-03-19 14:55:49.204183 [DEBUG] switch_core_state_machine.c:40 sofia/default/0734382646@41.160.32.115:5060 Standard INIT 2024-03-19 14:55:49.204183 [DEBUG] switch_core_state_machine.c:48 (sofia/default/0734382646@41.160.32.115:5060) State Change CS_INIT -> CS_ROUTING 2024-03-19 14:55:49.204183 [DEBUG] switch_core_state_machine.c:627 (sofia/default/0734382646@41.160.32.115:5060) State INIT going to sleep 2024-03-19 14:55:49.204183 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0734382646@41.160.32.115:5060) Running State Change CS_ROUTING (Cur 19 Tot 536010) 2024-03-19 14:55:49.204183 [DEBUG] switch_channel.c:2249 (sofia/default/0734382646@41.160.32.115:5060) Callstate Change DOWN -> RINGING 2024-03-19 14:55:49.204183 [DEBUG] switch_core_state_machine.c:643 (sofia/default/0734382646@41.160.32.115:5060) State ROUTING 2024-03-19 14:55:49.204183 [DEBUG] mod_sofia.c:143 sofia/default/0734382646@41.160.32.115:5060 SOFIA ROUTING 2024-03-19 14:55:49.204183 [DEBUG] switch_core_state_machine.c:236 sofia/default/0734382646@41.160.32.115:5060 Standard ROUTING 2024-03-19 14:55:49.204183 [INFO] mod_dialplan_xml.c:637 Processing 0734382646 <0734382646>->0103130010 in context default 2024-03-19 14:55:49.204183 [DEBUG] freeswitch_lua.cpp:365 DBH handle 0x7fed500f71b0 Connected. 2024-03-19 14:55:49.204183 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2024-03-19 14:55:49.204183 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2024-03-19 14:55:49.224240 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] blind_flag: 0 2024-03-19 14:55:49.224240 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Dialed number : 0103130010 2024-03-19 14:55:49.224240 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '0103130010' limit 1 2024-03-19 14:55:49.224240 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '0103130010' AND status=0 limit 1 2024-03-19 14:55:49.224240 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '0103130010' and status=0 LIMIT 1 2024-03-19 14:55:49.224240 [WARNING] switch_cpp.cpp:1365 [ASTPP] [FAXER] Custom Caller ID 2024-03-19 14:55:49.224240 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Caller Id name / number : 0734382646 / 2024-03-19 14:55:49.224240 [DEBUG] switch_cpp.cpp:1365 [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 ="0103130010" LIMIT 1 2024-03-19 14:55:49.224240 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Call direction : inbound 2024-03-19 14:55:49.224240 [INFO] switch_cpp.cpp:1365 [ASTPP] [Accountcode : 3673942894] 2024-03-19 14:55:49.224240 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "3673942894" AND deleted = 0 limit 1 2024-03-19 14:55:49.224240 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="0103130010" AND (accountid = 0 OR status = 1) LIMIT 1 2024-03-19 14:55:49.224240 [NOTICE] switch_cpp.cpp:1365 [ASTPP] Localization Id: 5 2024-03-19 14:55:49.224240 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 5 AND status=0 limit 1 2024-03-19 14:55:49.224240 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound 2024-03-19 14:55:49.224240 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 15 2024-03-19 14:55:49.224240 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE (patterns = '^0103130010.*' OR patterns = '^010313001.*' OR patterns = '^01031300.*' OR patterns = '^0103130.*' OR patterns = '^010313.*' OR patterns = '^01031.*' OR patterns = '^0103.*' OR patterns = '^010.*' OR patterns = '^01.*' OR patterns = '^0.*' OR patterns ='--') AND accountid = 15 ORDER BY LENGTH(PKGPTR.patterns) DESC 2024-03-19 14:55:49.224240 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_SPEEDDIAL] Query :SELECT A.number FROM speed_dial as A,accounts as B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.speed_num ="0103130010" AND A.accountid = '3' limit 1 2024-03-19 14:55:49.224240 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 0103130010 2024-03-19 14:55:49.224240 [DEBUG] switch_cpp.cpp:1365 [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 ="0103130010" LIMIT 1 2024-03-19 14:55:49.224240 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] New Call Direction : inbound 2024-03-19 14:55:49.224240 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '0103130010' OR number = '010313001' OR number = '01031300' OR number = '0103130' OR number = '010313' OR number = '01031' OR number = '0103' OR number = '010' OR number = '01' OR number = '0' OR number ='--') OR (number = '0103130010*' OR number = '010313001*' OR number = '01031300*' OR number = '0103130*' OR number = '010313*' OR number = '01031*' OR number = '0103*' OR number = '010*' OR number = '01*' OR number = '0*' OR number ='--') OR (number = '' OR number = ' 2024-03-19 14:55:49.244184 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET domains] Query :SELECT * FROM domains WHERE accountid = 15 limit 1 2024-03-19 14:55:49.244184 [WARNING] switch_cpp.cpp:1365 [ASTPP] [XML] User Domain : karlovac.nebular.co.za 2024-03-19 14:55:49.244184 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [XML] Custom Function Name :: custom_inbound_10 2024-03-19 14:55:49.244184 [DEBUG] switch_cpp.cpp:1365 [ASTPP] custom_function_name::::::::::1343:::::::::::::::2025 2024-03-19 14:55:49.244184 [INFO] switch_cpp.cpp:1365 [ASTPP] [PBX] call_type : 10 2024-03-19 14:55:49.244184 [INFO] switch_cpp.cpp:1365 [ASTPP] [PBX] call_type : IVR 2024-03-19 14:55:49.244184 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Functions] [GET_IVR_INFO] Query :SELECT * from pbx_ivr_specification WHERE id = 13 and status=0 LIMIT 1 2024-03-19 14:55:49.244184 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Functions] [GET_RING_GROUP_INFO] Query :SELECT file_name from pbx_recording WHERE id = '37' LIMIT 1 2024-03-19 14:55:49.244184 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== announcement=File name==================ThistreeRe_.wav 2024-03-19 14:55:49.244184 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== sandip here=========================== 2024-03-19 14:55:49.244184 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Generated XML:
2024-03-19 14:55:49.244184 [DEBUG] freeswitch_lua.cpp:382 DBH handle 0x7fed500f71b0 released. Dialplan: sofia/default/0734382646@41.160.32.115:5060 parsing [default->0103130010] continue=false Dialplan: sofia/default/0734382646@41.160.32.115:5060 Regex (PASS) [0103130010] destination_number(0103130010) =~ /0103130010/ break=on-false Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(effective_destination_number=0103130010) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(bridge_pre_execute_bleg_app=sched_hangup) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(callstart=2024-03-19 14:55:49) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(hangup_after_bridge=true) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(continue_on_fail=TRUE) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(account_id=3) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(parent_id=0) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(entity_id=3) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(call_processed=internal) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(call_direction=inbound) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(accountname=default) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(filename1=astpp.pbx.lua) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(origination_rates_did=ID:2025|CODE:^0103130010.*|DESTINATION:0103130010|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:171|ACCID:15) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(origination_rates=0) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(original_caller_id_name=0734382646) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(effective_caller_id_name=27734382646) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(receiver_accid=15) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action export(domain_name=karlovac.nebular.co.za) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action export(sip_to_host=karlovac.nebular.co.za) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action export(presence_data=x|||default(3673942894)|||^0103130010.* // 0103130010 // 0.00000||||||DID|||41.160.32.115) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action export(call_type=10) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(did_calltype=10) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(did_extensions=13) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(ringback=/var/www/html/astpp//upload/pbx/ThistreeRe_.wav) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(module_name=pbx) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(sip_h_P-call_type=custom_forward) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(sip_h_P-Accountcode=15) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(no_answer_number=145) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action export(no_answer_number=145) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(no_answer_call_type=extension) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(no_answer_call_type_value=145) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(opensips_flag=0) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(originate_disposition=no_key_press) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(variable_sip_to_host=karlovac.nebular.co.za) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(userinfo_id=3) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(variable_sip_to_host=karlovac.nebular.co.za) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(original_did_number=0103130010) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action set(absolute_codec_string=PCMU,PCMA,G729) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action answer() Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action ivr(ThisTree IVR13) Dialplan: sofia/default/0734382646@41.160.32.115:5060 Action lua(astpp/lib/pbx/astpp-failover_ivr_destination.lua) 2024-03-19 14:55:49.244184 [DEBUG] switch_core_state_machine.c:286 (sofia/default/0734382646@41.160.32.115:5060) State Change CS_ROUTING -> CS_EXECUTE 2024-03-19 14:55:49.244184 [DEBUG] switch_core_state_machine.c:643 (sofia/default/0734382646@41.160.32.115:5060) State ROUTING going to sleep 2024-03-19 14:55:49.244184 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0734382646@41.160.32.115:5060) Running State Change CS_EXECUTE (Cur 19 Tot 536010) 2024-03-19 14:55:49.244184 [DEBUG] switch_core_state_machine.c:650 (sofia/default/0734382646@41.160.32.115:5060) State EXECUTE 2024-03-19 14:55:49.244184 [DEBUG] mod_sofia.c:198 sofia/default/0734382646@41.160.32.115:5060 SOFIA EXECUTE 2024-03-19 14:55:49.244184 [DEBUG] switch_core_state_machine.c:328 sofia/default/0734382646@41.160.32.115:5060 Standard EXECUTE EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(effective_destination_number=0103130010) 2024-03-19 14:55:49.244184 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [effective_destination_number]=[0103130010] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(bridge_pre_execute_bleg_app=sched_hangup) 2024-03-19 14:55:49.244184 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [bridge_pre_execute_bleg_app]=[sched_hangup] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(bridge_pre_execute_bleg_data=+6000 normal_clearing) 2024-03-19 14:55:49.244184 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [bridge_pre_execute_bleg_data]=[+6000 normal_clearing] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(callstart=2024-03-19 14:55:49) 2024-03-19 14:55:49.244184 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [callstart]=[2024-03-19 14:55:49] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(hangup_after_bridge=true) 2024-03-19 14:55:49.244184 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [hangup_after_bridge]=[true] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(continue_on_fail=TRUE) 2024-03-19 14:55:49.244184 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [continue_on_fail]=[TRUE] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(account_id=3) 2024-03-19 14:55:49.244184 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [account_id]=[3] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(parent_id=0) 2024-03-19 14:55:49.244184 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [parent_id]=[0] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(entity_id=3) 2024-03-19 14:55:49.244184 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [entity_id]=[3] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(call_processed=internal) 2024-03-19 14:55:49.244184 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [call_processed]=[internal] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(call_direction=inbound) 2024-03-19 14:55:49.244184 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [call_direction]=[inbound] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(accountname=default) 2024-03-19 14:55:49.244184 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [accountname]=[default] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(filename1=astpp.pbx.lua) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [filename1]=[astpp.pbx.lua] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(origination_rates_did=ID:2025|CODE:^0103130010.*|DESTINATION:0103130010|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:171|ACCID:15) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [origination_rates_did]=[ID:2025|CODE:^0103130010.*|DESTINATION:0103130010|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:171|ACCID:15] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(origination_rates=0) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [origination_rates]=[0] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(original_caller_id_name=0734382646) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [original_caller_id_name]=[0734382646] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(effective_caller_id_name=27734382646) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [effective_caller_id_name]=[27734382646] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(receiver_accid=15) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [receiver_accid]=[15] EXECUTE sofia/default/0734382646@41.160.32.115:5060 export(domain_name=karlovac.nebular.co.za) 2024-03-19 14:55:49.264189 [DEBUG] switch_channel.c:1296 EXPORT (export_vars) [domain_name]=[karlovac.nebular.co.za] EXECUTE sofia/default/0734382646@41.160.32.115:5060 export(sip_to_host=karlovac.nebular.co.za) 2024-03-19 14:55:49.264189 [DEBUG] switch_channel.c:1296 EXPORT (export_vars) [sip_to_host]=[karlovac.nebular.co.za] EXECUTE sofia/default/0734382646@41.160.32.115:5060 export(presence_data=x|||default(3673942894)|||^0103130010.* // 0103130010 // 0.00000||||||DID|||41.160.32.115) 2024-03-19 14:55:49.264189 [DEBUG] switch_channel.c:1296 EXPORT (export_vars) [presence_data]=[x|||default(3673942894)|||^0103130010.* // 0103130010 // 0.00000||||||DID|||41.160.32.115] EXECUTE sofia/default/0734382646@41.160.32.115:5060 export(call_type=10) 2024-03-19 14:55:49.264189 [DEBUG] switch_channel.c:1296 EXPORT (export_vars) [call_type]=[10] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(did_calltype=10) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [did_calltype]=[10] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(did_extensions=13) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [did_extensions]=[13] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(ringback=/var/www/html/astpp//upload/pbx/ThistreeRe_.wav) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [ringback]=[/var/www/html/astpp//upload/pbx/ThistreeRe_.wav] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(module_name=pbx) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [module_name]=[pbx] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(sip_h_P-call_type=custom_forward) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [sip_h_P-call_type]=[custom_forward] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(sip_h_P-Accountcode=15) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [sip_h_P-Accountcode]=[15] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(no_answer_number=145) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [no_answer_number]=[145] EXECUTE sofia/default/0734382646@41.160.32.115:5060 export(no_answer_number=145) 2024-03-19 14:55:49.264189 [DEBUG] switch_channel.c:1296 EXPORT (export_vars) [no_answer_number]=[145] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(no_answer_call_type=extension) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [no_answer_call_type]=[extension] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(no_answer_call_type_value=145) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [no_answer_call_type_value]=[145] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(opensips_flag=0) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [opensips_flag]=[0] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(originate_disposition=no_key_press) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [originate_disposition]=[no_key_press] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(variable_sip_to_host=karlovac.nebular.co.za) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [variable_sip_to_host]=[karlovac.nebular.co.za] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(userinfo_id=3) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [userinfo_id]=[3] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(variable_sip_to_host=karlovac.nebular.co.za) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [variable_sip_to_host]=[karlovac.nebular.co.za] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(original_did_number=0103130010) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [original_did_number]=[0103130010] EXECUTE sofia/default/0734382646@41.160.32.115:5060 set(absolute_codec_string=PCMU,PCMA,G729) 2024-03-19 14:55:49.264189 [DEBUG] mod_dptools.c:1548 SET sofia/default/0734382646@41.160.32.115:5060 [absolute_codec_string]=[PCMU,PCMA,G729] EXECUTE sofia/default/0734382646@41.160.32.115:5060 answer() 2024-03-19 14:55:49.264189 [DEBUG] switch_core_media.c:6878 AUDIO RTP [sofia/default/0734382646@41.160.32.115:5060] 156.38.231.107 port 22912 -> 41.160.32.115 port 22228 codec: 18 ms: 20 2024-03-19 14:55:49.264189 [DEBUG] switch_rtp.c:4137 Starting timer [soft] 160 bytes per 20ms 2024-03-19 14:55:49.264189 [DEBUG] switch_core_media.c:7180 sofia/default/0734382646@41.160.32.115:5060 Set 2833 dtmf send payload to 101 2024-03-19 14:55:49.264189 [DEBUG] switch_core_media.c:7187 sofia/default/0734382646@41.160.32.115:5060 Set 2833 dtmf receive payload to 101 2024-03-19 14:55:49.264189 [DEBUG] switch_core_media.c:7210 sofia/default/0734382646@41.160.32.115:5060 Set rtp dtmf delay to 40 2024-03-19 14:55:49.264189 [DEBUG] mod_sofia.c:850 Local SDP sofia/default/0734382646@41.160.32.115:5060: v=0 o=FreeSWITCH 1710837237 1710837238 IN IP4 156.38.231.107 s=FreeSWITCH c=IN IP4 156.38.231.107 t=0 0 m=audio 22912 RTP/AVP 18 101 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=ptime:20 a=sendrecv 2024-03-19 14:55:49.264189 [NOTICE] mod_dptools.c:1312 Channel [sofia/default/0734382646@41.160.32.115:5060] has been answered 2024-03-19 14:55:49.264189 [DEBUG] switch_channel.c:3773 (sofia/default/0734382646@41.160.32.115:5060) Callstate Change RINGING -> ACTIVE 2024-03-19 14:55:49.264189 [DEBUG] sofia.c:7084 Channel sofia/default/0734382646@41.160.32.115:5060 entering state [completed][200] EXECUTE sofia/default/0734382646@41.160.32.115:5060 ivr(ThisTree IVR13) 2024-03-19 14:55:49.284293 [DEBUG] switch_ivr_menu.c:743 switch_ivr_menu_stack_xml_add binding 'menu-exit' 2024-03-19 14:55:49.284293 [DEBUG] switch_ivr_menu.c:743 switch_ivr_menu_stack_xml_add binding 'menu-sub' 2024-03-19 14:55:49.284293 [DEBUG] switch_ivr_menu.c:743 switch_ivr_menu_stack_xml_add binding 'menu-exec-app' 2024-03-19 14:55:49.284293 [DEBUG] switch_ivr_menu.c:743 switch_ivr_menu_stack_xml_add binding 'menu-play-sound' 2024-03-19 14:55:49.284293 [DEBUG] switch_ivr_menu.c:743 switch_ivr_menu_stack_xml_add binding 'menu-back' 2024-03-19 14:55:49.284293 [DEBUG] switch_ivr_menu.c:743 switch_ivr_menu_stack_xml_add binding 'menu-top' 2024-03-19 14:55:49.284293 [DEBUG] switch_ivr_menu.c:880 building menu 'ThisTree IVR13' 2024-03-19 14:55:49.284293 [DEBUG] switch_ivr_menu.c:964 binding menu action 'menu-exec-app' to '1' 2024-03-19 14:55:49.284293 [DEBUG] switch_ivr_menu.c:964 binding menu action 'menu-exec-app' to '2' 2024-03-19 14:55:49.284293 [DEBUG] switch_ivr_menu.c:964 binding menu action 'menu-exec-app' to '/^(\d{2,20})$/' 2024-03-19 14:55:49.284293 [DEBUG] switch_ivr_menu.c:483 Executing IVR menu ThisTree IVR13 2024-03-19 14:55:49.284293 [DEBUG] switch_core_file.c:342 File /var/www/html/astpp/upload/pbx/ThistreeRe_.wav sample rate 44100 doesn't match requested rate 8000 2024-03-19 14:55:49.284293 [DEBUG] switch_ivr_play_say.c:1498 Codec Activated L16@8000hz 1 channels 20ms 2024-03-19 14:55:49.284293 [INFO] mod_com_g729.c:140 ENCODER LICENSE ALLOCATED--->0x7feda81b5118 0x7feda81b5118 2024-03-19 14:55:49.284293 [INFO] mod_com_g729.c:147 ENCODER CREATED------------->0x7feda81b5118 0x7feda81b5118 2024-03-19 14:55:49.424178 [DEBUG] switch_rtp.c:7308 Correct audio ip/port confirmed. 2024-03-19 14:55:49.424178 [DEBUG] sofia.c:7084 Channel sofia/default/0734382646@41.160.32.115:5060 entering state [ready][200] 2024-03-19 14:55:53.704170 [DEBUG] switch_rtp.c:7534 RTP RECV DTMF *:1280 2024-03-19 14:55:53.704170 [INFO] switch_channel.c:515 RECV DTMF *:1280 2024-03-19 14:55:53.724178 [DEBUG] switch_rtp.c:5261 Send start packet for [*] ts=2869928968 dur=160/160/1280 seq=43808 lw=2869928968 2024-03-19 14:55:53.744183 [DEBUG] switch_rtp.c:5160 Send middle packet for [*] ts=2869928968 dur=320/320/1280 seq=43809 lw=2869929128 2024-03-19 14:55:53.764180 [DEBUG] switch_rtp.c:5160 Send middle packet for [*] ts=2869928968 dur=480/480/1280 seq=43810 lw=2869929288 2024-03-19 14:55:53.784182 [DEBUG] switch_rtp.c:5160 Send middle packet for [*] ts=2869928968 dur=640/640/1280 seq=43811 lw=2869929448 2024-03-19 14:55:53.804174 [DEBUG] switch_rtp.c:5160 Send middle packet for [*] ts=2869928968 dur=800/800/1280 seq=43812 lw=2869929608 2024-03-19 14:55:53.824233 [DEBUG] switch_rtp.c:5160 Send middle packet for [*] ts=2869928968 dur=960/960/1280 seq=43813 lw=2869929768 2024-03-19 14:55:53.844171 [DEBUG] switch_rtp.c:5160 Send middle packet for [*] ts=2869928968 dur=1120/1120/1280 seq=43814 lw=2869929928 2024-03-19 14:55:53.864202 [DEBUG] switch_rtp.c:5160 Send end packet for [*] ts=2869928968 dur=1280/1280/1280 seq=43815 lw=2869929928 2024-03-19 14:55:53.864202 [DEBUG] switch_rtp.c:5160 Send end packet for [*] ts=2869928968 dur=1280/1280/1280 seq=43816 lw=2869929928 2024-03-19 14:55:53.864202 [DEBUG] switch_rtp.c:5160 Send end packet for [*] ts=2869928968 dur=1280/1280/1280 seq=43817 lw=2869929928 2024-03-19 14:55:53.864202 [DEBUG] switch_rtp.c:5108 Queue digit delay of 40ms 2024-03-19 14:55:53.984153 [DEBUG] sofia.c:7084 Channel sofia/default/6085507138@legalaidsa.nebular.co.za entering state [received][100] 2024-03-19 14:55:53.984153 [DEBUG] sofia.c:7094 Remote SDP: v=0 o=3cxPS 120913395712 100042539010 IN IP4 156.38.150.6 s=3cxPS Audio call c=IN IP4 156.38.150.6 t=0 0 m=audio 9716 RTP/AVP 18 101 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no a=rtpmap:101 telephone-event/8000 a=sendonly 2024-03-19 14:55:53.984153 [DEBUG] switch_channel.c:1844 (sofia/default/6085507138@legalaidsa.nebular.co.za) Callstate Change ACTIVE -> HELD 2024-03-19 14:55:54.164194 [DEBUG] switch_ivr.c:623 sofia/default/027693695902@41.160.32.115:5060 Command Execute playback(local_stream://moh) EXECUTE sofia/default/027693695902@41.160.32.115:5060 playback(local_stream://moh) 2024-03-19 14:55:54.164194 [DEBUG] mod_local_stream.c:871 Opening Stream [moh/8000] 8000hz 2024-03-19 14:55:54.164194 [DEBUG] switch_ivr_play_say.c:1498 Codec Activated L16@8000hz 1 channels 20ms 2024-03-19 14:55:54.184189 [INFO] mod_com_g729.c:140 ENCODER LICENSE ALLOCATED--->0x7feda8462df8 0x7feda8462df8 2024-03-19 14:55:54.184189 [INFO] mod_com_g729.c:147 ENCODER CREATED------------->0x7feda8462df8 0x7feda8462df8 2024-03-19 14:55:54.224173 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G729:18:8000:20:8000:1]/[G729:18:8000:20:8000:1] 2024-03-19 14:55:54.224173 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [G729:18:8000:20:8000:1] ++++ is saved as a match 2024-03-19 14:55:54.224173 [DEBUG] switch_core_media.c:4365 Set telephone-event payload to 101@8000 2024-03-19 14:55:54.224173 [DEBUG] switch_core_media.c:4708 Set telephone-event payload to 101@8000 2024-03-19 14:55:54.224173 [DEBUG] switch_core_media.c:4767 sofia/default/6085507138@legalaidsa.nebular.co.za Set 2833 dtmf send payload to 101 recv payload to 101 2024-03-19 14:55:54.224173 [DEBUG] switch_core_media.c:6861 Audio params are unchanged for sofia/default/6085507138@legalaidsa.nebular.co.za. 2024-03-19 14:55:54.224173 [DEBUG] sofia.c:7999 Processing updated SDP 2024-03-19 14:55:54.224173 [DEBUG] sofia.c:7084 Channel sofia/default/6085507138@legalaidsa.nebular.co.za entering state [completed][200] 2024-03-19 14:55:54.244189 [DEBUG] sofia.c:7084 Channel sofia/default/6085507138@legalaidsa.nebular.co.za entering state [ready][200] 2024-03-19 14:55:54.404344 [DEBUG] sofia.c:7084 Channel sofia/default/6085507138@legalaidsa.nebular.co.za entering state [received][100] 2024-03-19 14:55:54.404344 [DEBUG] sofia.c:7094 Remote SDP: v=0 o=3cxPS 120913395712 100042539011 IN IP4 156.38.150.6 s=3cxPS Audio call c=IN IP4 156.38.150.6 t=0 0 m=audio 9716 RTP/AVP 18 101 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no a=rtpmap:101 telephone-event/8000 2024-03-19 14:55:54.644183 [DEBUG] switch_ivr_play_say.c:1942 done playing file local_stream://moh 2024-03-19 14:55:54.644183 [DEBUG] switch_channel.c:2029 (sofia/default/6085507138@legalaidsa.nebular.co.za) Callstate Change HELD -> UNHELD 2024-03-19 14:55:54.644183 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G729:18:8000:20:8000:1]/[G729:18:8000:20:8000:1] 2024-03-19 14:55:54.644183 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [G729:18:8000:20:8000:1] ++++ is saved as a match 2024-03-19 14:55:54.644183 [DEBUG] switch_core_media.c:4365 Set telephone-event payload to 101@8000 2024-03-19 14:55:54.644183 [DEBUG] switch_core_media.c:4708 Set telephone-event payload to 101@8000 2024-03-19 14:55:54.644183 [DEBUG] switch_core_media.c:4767 sofia/default/6085507138@legalaidsa.nebular.co.za Set 2833 dtmf send payload to 101 recv payload to 101 2024-03-19 14:55:54.644183 [DEBUG] switch_core_media.c:6861 Audio params are unchanged for sofia/default/6085507138@legalaidsa.nebular.co.za. 2024-03-19 14:55:54.644183 [DEBUG] sofia.c:7999 Processing updated SDP 2024-03-19 14:55:54.644183 [DEBUG] switch_core_io.c:941 (sofia/default/6085507138@legalaidsa.nebular.co.za) Callstate Change UNHELD -> ACTIVE 2024-03-19 14:55:54.664208 [DEBUG] sofia.c:7084 Channel sofia/default/6085507138@legalaidsa.nebular.co.za entering state [completed][200] 2024-03-19 14:55:54.684182 [DEBUG] sofia.c:7084 Channel sofia/default/6085507138@legalaidsa.nebular.co.za entering state [ready][200] 2024-03-19 14:55:54.724181 [DEBUG] switch_rtp.c:7308 Correct audio ip/port confirmed. 2024-03-19 14:55:56.466850 [NOTICE] switch_channel.c:1104 New Channel sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [ca5f2390-e600-11ee-8a0b-d17fbcf33421] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0534740341@legalaidsa.nebular.co.za:5060) Running State Change CS_NEW (Cur 20 Tot 536011) 2024-03-19 14:55:56.466850 [DEBUG] sofia.c:9873 sofia/default/0534740341@legalaidsa.nebular.co.za:5060 receiving invite from 156.38.231.106:5060 version: 1.6.20 64bit 2024-03-19 14:55:56.466850 [DEBUG] sofia.c:9989 IP 156.38.231.106 Approved by acl "default[]". Access Granted. 2024-03-19 14:55:56.466850 [DEBUG] sofia.c:7084 Channel sofia/default/0534740341@legalaidsa.nebular.co.za:5060 entering state [received][100] 2024-03-19 14:55:56.466850 [DEBUG] sofia.c:7094 Remote SDP: v=0 o=3cxPS 57696845824 548430413825 IN IP4 156.38.150.6 s=3cxPS Audio call c=IN IP4 156.38.150.6 t=0 0 m=audio 9720 RTP/AVP 8 0 9 18 101 a=rtpmap:8 PCMA/8000 a=rtpmap:0 PCMU/8000 a=rtpmap:9 G722/8000 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no a=rtpmap:101 telephone-event/8000 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:60:8000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:60:8000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G722:9:8000:20:64000:1]/[G729:18:8000:60:8000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G722:9:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G729:18:8000:20:8000:1]/[G729:18:8000:60:8000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [G729:18:8000:60:8000:1] ++++ is saved as a match 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G729:18:8000:20:8000:1]/[G729:18:8000:20:8000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [G729:18:8000:20:8000:1] ++++ is saved as a match 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMA:8:8000:20:64000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMU:0:8000:20:64000:1] 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4365 Set telephone-event payload to 101@8000 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:3061 Set Codec sofia/default/0534740341@legalaidsa.nebular.co.za:5060 PCMA/8000 20 ms 160 samples 64000 bits 1 channels 2024-03-19 14:55:56.466850 [DEBUG] switch_core_codec.c:111 sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Original read codec set to PCMA:8 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4708 Set telephone-event payload to 101@8000 2024-03-19 14:55:56.466850 [DEBUG] switch_core_media.c:4767 sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Set 2833 dtmf send payload to 101 recv payload to 101 2024-03-19 14:55:56.466850 [DEBUG] sofia.c:7507 (sofia/default/0534740341@legalaidsa.nebular.co.za:5060) State Change CS_NEW -> CS_INIT 2024-03-19 14:55:56.466850 [DEBUG] switch_core_state_machine.c:603 (sofia/default/0534740341@legalaidsa.nebular.co.za:5060) State NEW 2024-03-19 14:55:56.466850 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0534740341@legalaidsa.nebular.co.za:5060) Running State Change CS_INIT (Cur 20 Tot 536011) 2024-03-19 14:55:56.466850 [DEBUG] switch_core_state_machine.c:627 (sofia/default/0534740341@legalaidsa.nebular.co.za:5060) State INIT 2024-03-19 14:55:56.466850 [DEBUG] mod_sofia.c:90 sofia/default/0534740341@legalaidsa.nebular.co.za:5060 SOFIA INIT 2024-03-19 14:55:56.466850 [DEBUG] switch_core_state_machine.c:40 sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Standard INIT 2024-03-19 14:55:56.466850 [DEBUG] switch_core_state_machine.c:48 (sofia/default/0534740341@legalaidsa.nebular.co.za:5060) State Change CS_INIT -> CS_ROUTING 2024-03-19 14:55:56.466850 [DEBUG] switch_core_state_machine.c:627 (sofia/default/0534740341@legalaidsa.nebular.co.za:5060) State INIT going to sleep 2024-03-19 14:55:56.466850 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0534740341@legalaidsa.nebular.co.za:5060) Running State Change CS_ROUTING (Cur 20 Tot 536011) 2024-03-19 14:55:56.466850 [DEBUG] switch_channel.c:2249 (sofia/default/0534740341@legalaidsa.nebular.co.za:5060) Callstate Change DOWN -> RINGING 2024-03-19 14:55:56.466850 [DEBUG] switch_core_state_machine.c:643 (sofia/default/0534740341@legalaidsa.nebular.co.za:5060) State ROUTING 2024-03-19 14:55:56.466850 [DEBUG] mod_sofia.c:143 sofia/default/0534740341@legalaidsa.nebular.co.za:5060 SOFIA ROUTING 2024-03-19 14:55:56.466850 [DEBUG] switch_core_state_machine.c:236 sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Standard ROUTING 2024-03-19 14:55:56.466850 [INFO] mod_dialplan_xml.c:637 Processing 0534740341 <0534740341>->0736001022 in context default 2024-03-19 14:55:56.466850 [DEBUG] freeswitch_lua.cpp:365 DBH handle 0x7fed500f71b0 Connected. 2024-03-19 14:55:56.466850 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2024-03-19 14:55:56.466850 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2024-03-19 14:55:56.466850 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] blind_flag: 0 2024-03-19 14:55:56.466850 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Dialed number : 0736001022 2024-03-19 14:55:56.466850 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '0736001022' limit 1 2024-03-19 14:55:56.466850 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '0736001022' AND status=0 limit 1 2024-03-19 14:55:56.466850 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '0736001022' and status=0 LIMIT 1 2024-03-19 14:55:56.466850 [WARNING] switch_cpp.cpp:1365 [ASTPP] [FAXER] Custom Caller ID 2024-03-19 14:55:56.466850 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Caller Id name / number : 0534740341 / 0534740341 2024-03-19 14:55:56.466850 [DEBUG] switch_cpp.cpp:1365 [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 ="0736001022" LIMIT 1 2024-03-19 14:55:56.466850 [DEBUG] switch_cpp.cpp:1365 [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 FROM sip_devices as sip_devices,accounts as accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="0736001022" AND domains.domain="legalaidsa.nebular.co.za" limit 1 2024-03-19 14:55:56.466850 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Call direction : outbound 2024-03-19 14:55:56.466850 [INFO] switch_cpp.cpp:1365 [ASTPP] [Accountcode : 196083] 2024-03-19 14:55:56.466850 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "196083" AND deleted = 0 limit 1 2024-03-19 14:55:56.466850 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^0736001022.*' OR blocked_patterns = '^073600102.*' OR blocked_patterns = '^07360010.*' OR blocked_patterns = '^0736001.*' OR blocked_patterns = '^073600.*' OR blocked_patterns = '^07360.*' OR blocked_patterns = '^0736.*' OR blocked_patterns = '^073.*' OR blocked_patterns = '^07.*' OR blocked_patterns = '^0.*' OR blocked_patterns ='--') AND accountid = 109 limit 1 2024-03-19 14:55:56.466850 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="0736001022" AND (accountid = 0 OR status = 1) LIMIT 1 2024-03-19 14:55:56.466850 [NOTICE] switch_cpp.cpp:1365 [ASTPP] Localization Id: 3 2024-03-19 14:55:56.466850 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 3 AND status=0 limit 1 2024-03-19 14:55:56.466850 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"27/0,00/99".....0736001022 2024-03-19 14:55:56.466850 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"27/0,00/99".....0736001022 2024-03-19 14:55:56.466850 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE (patterns = '^0736001022.*' OR patterns = '^073600102.*' OR patterns = '^07360010.*' OR patterns = '^0736001.*' OR patterns = '^073600.*' OR patterns = '^07360.*' OR patterns = '^0736.*' OR patterns = '^073.*' OR patterns = '^07.*' OR patterns = '^0.*' OR patterns ='--') AND accountid = 109 ORDER BY LENGTH(PKGPTR.patterns) DESC 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_SPEEDDIAL] Query :SELECT A.number FROM speed_dial as A,accounts as B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.speed_num ="0736001022" AND A.accountid = '109' limit 1 2024-03-19 14:55:56.504170 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 0736001022 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [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 ="0736001022" LIMIT 1 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [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 FROM sip_devices as sip_devices,accounts as accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="0736001022" AND domains.domain="legalaidsa.nebular.co.za" limit 1 2024-03-19 14:55:56.504170 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] New Call Direction : outbound 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '0736001022' OR number = '073600102' OR number = '07360010' OR number = '0736001' OR number = '073600' OR number = '07360' OR number = '0736' OR number = '073' OR number = '07' OR number = '0' OR number ='--') OR (number = '0736001022*' OR number = '073600102*' OR number = '07360010*' OR number = '0736001*' OR number = '073600*' OR number = '07360*' OR number = '0736*' OR number = '073*' OR number = '07*' OR number = '0*' OR number ='--') OR (number = '0534740341' OR number = '053474034' OR number = '05347403' OR number = '0534740' OR number = '053474' OR number = '05347' OR number = '0534' OR number = '053' OR number = '05' OR number = '0' OR number ='--') OR (number = '0534740341*' OR number = '053474034*' OR number = '05347403*' OR number = '0534740*' OR number = '053474*' OR number = '05347*' OR number = '0534*' OR number = '053*' OR number = '05*' OR number = '0*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] Call Barring Status : -1 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '0736001022' OR routing_prefix = '073600102' OR routing_prefix = '07360010' OR routing_prefix = '0736001' OR routing_prefix = '073600' OR routing_prefix = '07360' OR routing_prefix = '0736' OR routing_prefix = '073' OR routing_prefix = '07' OR routing_prefix = '0' OR routing_prefix ='--') AND status = 0 and reseller_id = 13 limit 1 2024-03-19 14:55:56.504170 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [PORTED_NUMBER] Get Destination Number (0736001022)!!!! 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [PORTED_NUMBER] Ported Number :27736001022 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [PORTED_NUMBER] Query :SELECT rnoroute FROM ported_number WHERE dnfrom ='27736001022' limit 1 2024-03-19 14:55:56.504170 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [PORTED_NUMBER] After Append Ported Number : (0736001022)!!!! 2024-03-19 14:55:56.504170 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Account Information =================== 2024-03-19 14:55:56.504170 [INFO] switch_cpp.cpp:1365 [ASTPP] User id : 109 2024-03-19 14:55:56.504170 [INFO] switch_cpp.cpp:1365 [ASTPP] Account code : 196083 2024-03-19 14:55:56.504170 [INFO] switch_cpp.cpp:1365 [ASTPP] Balance : 11176.1935 2024-03-19 14:55:56.504170 [INFO] switch_cpp.cpp:1365 [ASTPP] Type : 1 [0:prepaid,1:postpaid] 2024-03-19 14:55:56.504170 [INFO] switch_cpp.cpp:1365 [ASTPP] Ratecard id : 93 2024-03-19 14:55:56.504170 [INFO] switch_cpp.cpp:1365 [ASTPP] CID Pool : 0 2024-03-19 14:55:56.504170 [INFO] switch_cpp.cpp:1365 [ASTPP] ======================================================== 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0534740341 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0534740341 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0534740341 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0534740341 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0534740341 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0534740341 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0534740341 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0534740341 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0534740341 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0534740341 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0534740341 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0534740341 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 93 AND status = 0 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_RATES] call_direction :outbound 2024-03-19 14:55:56.504170 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 93 AND status = 0 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^0736001022.*' OR pattern = '^073600102.*' OR pattern = '^07360010.*' OR pattern = '^0736001.*' OR pattern = '^073600.*' OR pattern = '^07360.*' OR pattern = '^0736.*' OR pattern = '^073.*' OR pattern = '^07.*' OR pattern = '^0.*' OR pattern ='--') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 93 OR accountid=109) ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC,effective_date DESC LIMIT 1 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Call Direction : outbound 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Rates Information =================== 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 2148457 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Includedseconds : 0 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Cost : 0.44000 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Comment : SOUTH AFRICA - MTN - MOBILE 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Country Id : 0 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Accid : 109 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Trunk ID: 0 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Routing type: 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] ================================================================ 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] [FIND_MAXLENGTH] Your11176.1935 balance Accountid 109 !!! 2024-03-19 14:55:56.524192 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins! 2024-03-19 14:55:56.524192 [NOTICE] switch_cpp.cpp:1365 [ASTPP] FINDING LIMIT FOR RESELLER: 13 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "13" AND deleted = 0 limit 1 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^0736001022.*' OR blocked_patterns = '^073600102.*' OR blocked_patterns = '^07360010.*' OR blocked_patterns = '^0736001.*' OR blocked_patterns = '^073600.*' OR blocked_patterns = '^07360.*' OR blocked_patterns = '^0736.*' OR blocked_patterns = '^073.*' OR blocked_patterns = '^07.*' OR blocked_patterns = '^0.*' OR blocked_patterns ='--') AND accountid = 13 limit 1 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Reseller Information =================== 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] User id : 13 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Account code : 778509 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Balance : 10289.9683 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Ratecard id : 83 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 83 AND status = 0 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_RATES] call_direction :outbound 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 83 AND status = 0 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^0736001022.*' OR pattern = '^073600102.*' OR pattern = '^07360010.*' OR pattern = '^0736001.*' OR pattern = '^073600.*' OR pattern = '^07360.*' OR pattern = '^0736.*' OR pattern = '^073.*' OR pattern = '^07.*' OR pattern = '^0.*' OR pattern ='--') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 83 OR accountid=13) ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC,effective_date DESC LIMIT 1 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Call Direction : outbound 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Rates Information =================== 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 1426359 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Includedseconds : 0 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Cost : 0.29000 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Comment : D083-MTN 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Country Id : 0 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Accid : 13 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Trunk ID: 0 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Routing type: 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] ================================================================ 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] [FIND_MAXLENGTH] Your10289.9683 balance Accountid 13 !!! 2024-03-19 14:55:56.524192 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins! 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Reseller xml_user_rates : ID:2148457|CODE:^073.*|DESTINATION:SOUTH AFRICA - MTN - MOBILE|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.44000|INC:1|INITIALBLOCK:1|RATEGROUP:93|MARKUP:0|CI:0|ACCID:109||ID:1426359|CODE:^073.*|DESTINATION:D083-MTN|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.29000|INC:1|INITIALBLOCK:1|RATEGROUP:83|MARKUP:0|CI:0|ACCID:13 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] ======================================================== 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Lossless Routing Status : 1 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Call Max Length Duration : 100 minutes 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] [DIALPLAN] User Rate ID : 2148457 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_CARRIER_RATES] Query Rate Carrier Id :0 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_CARRIER_RATES_TRUNKS] Query :SELECT GROUP_CONCAT(trunk_id) as ids FROM routing WHERE pricelist_id=83 ORDER by id asc 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_CARRIER_RATES] Query :SELECT TK.id as trunk_id,TK.name as trunk_name,TK.codec,GW.name as path,GW.dialplan_variable,TK.provider_id,TR.init_inc,TK.status,TK.maxchannels,TK.cps,TK.leg_timeout,TR.pattern,TR.id as outbound_route_id,TR.connectcost,TR.comment,TR.includedseconds,TR.cost,TR.inc,TR.prepend,TR.strip,(select name from gateways where status=0 AND id = TK.failover_gateway_id) as path1,(select name from gateways where status=0 AND id = TK.failover_gateway_id1) as path2 FROM outbound_routes as TR,trunks as TK,gateways as GW WHERE GW.status=0 AND GW.id= TK.gateway_id AND TK.status=0 AND TK.id= TR.trunk_id AND (pattern = '^0736001022.*' OR pattern = '^073600102.*' OR pattern = '^07360010.*' OR pattern = '^0736001.*' OR pattern = '^073600.*' OR pattern = '^07360.*' OR pattern = '^0736.*' OR pattern = '^073.*' OR pattern = '^07.*' OR pattern = '^0.*' OR pattern ='--') AND TR.status = 0 AND TR.trunk_id IN (5,7) AND TR.effective_date <= UTC_TIMESTAMP() ORDER by LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC, TK.precedence,TR.effective_date DESC 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Termination Rates Information =================== 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 183 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Code : ^0.* 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Destination : SA 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Free Seconds : 0 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Prefix : ^0.* 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Strip : 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Prepend : 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Carrier id : 5 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] carrier_name : liquid_primary 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] dialplan_variable : 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Failover gateway : 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Vendor id : 3 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Max channels : 0 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Trunk Name : Liquid 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] ========================END OF TERMINATION RATES======================= 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 109 AND status=0 LIMIT 1 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] Maxlength : 100 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] [XML] Customer Recording Flag : 1 2024-03-19 14:55:56.524192 [INFO] switch_cpp.cpp:1365 [ASTPP] [PBX] call_direction : outbound 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 83 AND status = 0 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,out_caller_id_terminate,number_terminate,dst_base_cid FROM localization WHERE id=(SELECT localization_id from trunks where id = 5) AND status=0 limit 1 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"+27/0".....0736001022 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,out_caller_id_terminate,number_terminate,dst_base_cid FROM localization WHERE id=(SELECT localization_id from accounts where id = 3) AND status=0 limit 1 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [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 ="0736001022" LIMIT 1 2024-03-19 14:55:56.524192 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Generated XML:
2024-03-19 14:55:56.524192 [DEBUG] freeswitch_lua.cpp:382 DBH handle 0x7fed500f71b0 released. Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 parsing [default->0736001022] continue=false Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Regex (PASS) [0736001022] destination_number(0736001022) =~ /0736001022/ break=on-false Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(effective_destination_number=0736001022) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(bridge_pre_execute_bleg_app=sched_hangup) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(callstart=2024-03-19 14:55:56) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(hangup_after_bridge=true) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(continue_on_fail=TRUE) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(account_id=109) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(parent_id=13) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(entity_id=0) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(call_processed=internal) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(call_direction=outbound) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(accountname=default) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(filename1=astpp.pbx.lua) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(origination_rates=ID:2148457|CODE:^073.*|DESTINATION:SOUTH AFRICA - MTN - MOBILE|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.44000|INC:1|INITIALBLOCK:1|RATEGROUP:93|MARKUP:0|CI:0|ACCID:109||ID:1426359|CODE:^073.*|DESTINATION:D083-MTN|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.29000|INC:1|INITIALBLOCK:1|RATEGROUP:83|MARKUP:0|CI:0|ACCID:13) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(original_caller_id_name=0534740341) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(original_caller_id_number=0534740341) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action limit(db 196083 user_196083 200 ) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action limit(db 778509 user_778509 800 ) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(effective_caller_id_name=0534740341) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(effective_caller_id_number=0534740341) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(calltype=STANDARD) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(termination_rates=ID:183|CODE:^0.*|DESTINATION:SA|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00000|INC:1|INITIALBLOCK:1|TRUNK:5|PROVIDER:3) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(trunk_id=5) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(provider_id=3) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(rate_flag=0) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(force_trunk_flag=2148457) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action export(presence_data=trunk_id=5) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action set(intcall=0) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action export(presence_data=x//13|||Legal Aid South Africa(196083)|||^073.* // SOUTH AFRICA - MTN - MOBILE // 0.44000 // trunk_id=0|||Liquid // ^0.* // SA // 0.00000 // trunk_id=5|||STD|||156.38.231.105|||0.29000 // ^073.* // D083-MTN) Dialplan: sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Action bridge([leg_timeout=0,absolute_codec_string=^^:PCMA:PCMU:G729]sofia/gateway/liquid_primary/0736001022;fs_path=sip:156.38.231.106:5060) 2024-03-19 14:55:56.524192 [DEBUG] switch_core_state_machine.c:286 (sofia/default/0534740341@legalaidsa.nebular.co.za:5060) State Change CS_ROUTING -> CS_EXECUTE 2024-03-19 14:55:56.524192 [DEBUG] switch_core_state_machine.c:643 (sofia/default/0534740341@legalaidsa.nebular.co.za:5060) State ROUTING going to sleep 2024-03-19 14:55:56.524192 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0534740341@legalaidsa.nebular.co.za:5060) Running State Change CS_EXECUTE (Cur 20 Tot 536011) 2024-03-19 14:55:56.524192 [DEBUG] switch_core_state_machine.c:650 (sofia/default/0534740341@legalaidsa.nebular.co.za:5060) State EXECUTE 2024-03-19 14:55:56.524192 [DEBUG] mod_sofia.c:198 sofia/default/0534740341@legalaidsa.nebular.co.za:5060 SOFIA EXECUTE 2024-03-19 14:55:56.524192 [DEBUG] switch_core_state_machine.c:328 sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Standard EXECUTE EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(effective_destination_number=0736001022) 2024-03-19 14:55:56.524192 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [effective_destination_number]=[0736001022] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(bridge_pre_execute_bleg_app=sched_hangup) 2024-03-19 14:55:56.524192 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [bridge_pre_execute_bleg_app]=[sched_hangup] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(bridge_pre_execute_bleg_data=+6000 normal_clearing) 2024-03-19 14:55:56.524192 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [bridge_pre_execute_bleg_data]=[+6000 normal_clearing] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(callstart=2024-03-19 14:55:56) 2024-03-19 14:55:56.524192 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [callstart]=[2024-03-19 14:55:56] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(hangup_after_bridge=true) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [hangup_after_bridge]=[true] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(continue_on_fail=TRUE) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [continue_on_fail]=[TRUE] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(account_id=109) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [account_id]=[109] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(parent_id=13) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [parent_id]=[13] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(entity_id=0) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [entity_id]=[0] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(call_processed=internal) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [call_processed]=[internal] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(call_direction=outbound) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [call_direction]=[outbound] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(accountname=default) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [accountname]=[default] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(filename1=astpp.pbx.lua) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [filename1]=[astpp.pbx.lua] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(origination_rates=ID:2148457|CODE:^073.*|DESTINATION:SOUTH AFRICA - MTN - MOBILE|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.44000|INC:1|INITIALBLOCK:1|RATEGROUP:93|MARKUP:0|CI:0|ACCID:109||ID:1426359|CODE:^073.*|DESTINATION:D083-MTN|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.29000|INC:1|INITIALBLOCK:1|RATEGROUP:83|MARKUP:0|CI:0|ACCID:13) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [origination_rates]=[ID:2148457|CODE:^073.*|DESTINATION:SOUTH AFRICA - MTN - MOBILE|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.44000|INC:1|INITIALBLOCK:1|RATEGROUP:93|MARKUP:0|CI:0|ACCID:109||ID:1426359|CODE:^073.*|DESTINATION:D083-MTN|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.29000|INC:1|INITIALBLOCK:1|RATEGROUP:83|MARKUP:0|CI:0|ACCID:13] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(original_caller_id_name=0534740341) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [original_caller_id_name]=[0534740341] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(original_caller_id_number=0534740341) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [original_caller_id_number]=[0534740341] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 limit(db 196083 user_196083 200 ) 2024-03-19 14:55:56.544465 [DEBUG] switch_limit.c:126 incr called: 196083_user_196083 max:200, interval:0 2024-03-19 14:55:56.544465 [DEBUG] mod_db.c:194 Usage for 196083_user_196083 is now 9/200 EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 limit(db 778509 user_778509 800 ) 2024-03-19 14:55:56.544465 [DEBUG] switch_limit.c:126 incr called: 778509_user_778509 max:800, interval:0 2024-03-19 14:55:56.544465 [DEBUG] mod_db.c:194 Usage for 778509_user_778509 is now 9/800 EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(effective_caller_id_name=0534740341) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [effective_caller_id_name]=[0534740341] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(effective_caller_id_number=0534740341) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [effective_caller_id_number]=[0534740341] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(calltype=STANDARD) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [calltype]=[STANDARD] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(termination_rates=ID:183|CODE:^0.*|DESTINATION:SA|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00000|INC:1|INITIALBLOCK:1|TRUNK:5|PROVIDER:3) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [termination_rates]=[ID:183|CODE:^0.*|DESTINATION:SA|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00000|INC:1|INITIALBLOCK:1|TRUNK:5|PROVIDER:3] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(trunk_id=5) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [trunk_id]=[5] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(provider_id=3) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [provider_id]=[3] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(rate_flag=0) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [rate_flag]=[0] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(force_trunk_flag=2148457) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [force_trunk_flag]=[2148457] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 export(presence_data=trunk_id=5) 2024-03-19 14:55:56.544465 [DEBUG] switch_channel.c:1296 EXPORT (export_vars) [presence_data]=[trunk_id=5] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 set(intcall=0) 2024-03-19 14:55:56.544465 [DEBUG] mod_dptools.c:1548 SET sofia/default/0534740341@legalaidsa.nebular.co.za:5060 [intcall]=[0] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 export(presence_data=x//13|||Legal Aid South Africa(196083)|||^073.* // SOUTH AFRICA - MTN - MOBILE // 0.44000 // trunk_id=0|||Liquid // ^0.* // SA // 0.00000 // trunk_id=5|||STD|||156.38.231.105|||0.29000 // ^073.* // D083-MTN) 2024-03-19 14:55:56.544465 [DEBUG] switch_channel.c:1296 EXPORT (export_vars) [presence_data]=[x//13|||Legal Aid South Africa(196083)|||^073.* // SOUTH AFRICA - MTN - MOBILE // 0.44000 // trunk_id=0|||Liquid // ^0.* // SA // 0.00000 // trunk_id=5|||STD|||156.38.231.105|||0.29000 // ^073.* // D083-MTN] EXECUTE sofia/default/0534740341@legalaidsa.nebular.co.za:5060 bridge([leg_timeout=0,absolute_codec_string=^^:PCMA:PCMU:G729]sofia/gateway/liquid_primary/0736001022;fs_path=sip:156.38.231.106:5060) 2024-03-19 14:55:56.544465 [DEBUG] switch_channel.c:1250 sofia/default/0534740341@legalaidsa.nebular.co.za:5060 EXPORTING[export_vars] [presence_data]=[x//13|||Legal Aid South Africa(196083)|||^073.* // SOUTH AFRICA - MTN - MOBILE // 0.44000 // trunk_id=0|||Liquid // ^0.* // SA // 0.00000 // trunk_id=5|||STD|||156.38.231.105|||0.29000 // ^073.* // D083-MTN] to event 2024-03-19 14:55:56.544465 [DEBUG] switch_channel.c:1250 sofia/default/0534740341@legalaidsa.nebular.co.za:5060 EXPORTING[export_vars] [presence_data]=[x//13|||Legal Aid South Africa(196083)|||^073.* // SOUTH AFRICA - MTN - MOBILE // 0.44000 // trunk_id=0|||Liquid // ^0.* // SA // 0.00000 // trunk_id=5|||STD|||156.38.231.105|||0.29000 // ^073.* // D083-MTN] to event 2024-03-19 14:55:56.544465 [DEBUG] switch_ivr_originate.c:2142 Parsing global variables 2024-03-19 14:55:56.544465 [DEBUG] switch_ivr_originate.c:2669 Parsing session specific variables 2024-03-19 14:55:56.544465 [NOTICE] switch_channel.c:1104 New Channel sofia/default/0736001022 [ca6c0aba-e600-11ee-8a2e-d17fbcf33421] 2024-03-19 14:55:56.544465 [DEBUG] mod_sofia.c:4819 (sofia/default/0736001022) State Change CS_NEW -> CS_INIT 2024-03-19 14:55:56.544465 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0736001022) Running State Change CS_INIT (Cur 21 Tot 536012) 2024-03-19 14:55:56.544465 [DEBUG] switch_core_state_machine.c:627 (sofia/default/0736001022) State INIT 2024-03-19 14:55:56.544465 [DEBUG] mod_sofia.c:90 sofia/default/0736001022 SOFIA INIT 2024-03-19 14:55:56.544465 [DEBUG] sofia_glue.c:1264 sip:156.38.231.106:5060 Setting proxy route to sofia/default/0736001022 2024-03-19 14:55:56.544465 [DEBUG] sofia_glue.c:1295 sofia/default/0736001022 sending invite version: 1.6.20 64bit Local SDP: v=0 o=FreeSWITCH 1710839762 1710839763 IN IP4 156.38.231.107 s=FreeSWITCH c=IN IP4 156.38.231.107 t=0 0 m=audio 20394 RTP/AVP 8 0 18 101 a=rtpmap:8 PCMA/8000 a=rtpmap:0 PCMU/8000 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=ptime:20 a=sendrecv 2024-03-19 14:55:56.544465 [DEBUG] switch_core_state_machine.c:40 sofia/default/0736001022 Standard INIT 2024-03-19 14:55:56.544465 [DEBUG] switch_core_state_machine.c:48 (sofia/default/0736001022) State Change CS_INIT -> CS_ROUTING 2024-03-19 14:55:56.544465 [DEBUG] switch_core_state_machine.c:627 (sofia/default/0736001022) State INIT going to sleep 2024-03-19 14:55:56.544465 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0736001022) Running State Change CS_ROUTING (Cur 21 Tot 536012) 2024-03-19 14:55:56.544465 [DEBUG] switch_core_state_machine.c:643 (sofia/default/0736001022) State ROUTING 2024-03-19 14:55:56.544465 [DEBUG] mod_sofia.c:143 sofia/default/0736001022 SOFIA ROUTING 2024-03-19 14:55:56.544465 [DEBUG] switch_ivr_originate.c:67 (sofia/default/0736001022) State Change CS_ROUTING -> CS_CONSUME_MEDIA 2024-03-19 14:55:56.544465 [DEBUG] switch_core_state_machine.c:643 (sofia/default/0736001022) State ROUTING going to sleep 2024-03-19 14:55:56.544465 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0736001022) Running State Change CS_CONSUME_MEDIA (Cur 21 Tot 536012) 2024-03-19 14:55:56.544465 [DEBUG] switch_core_state_machine.c:662 (sofia/default/0736001022) State CONSUME_MEDIA 2024-03-19 14:55:56.544465 [DEBUG] switch_core_state_machine.c:662 (sofia/default/0736001022) State CONSUME_MEDIA going to sleep 2024-03-19 14:55:56.544465 [DEBUG] sofia.c:7084 Channel sofia/default/0736001022 entering state [calling][0] 2024-03-19 14:55:57.844192 [DEBUG] sofia.c:7084 Channel sofia/default/0736001022 entering state [proceeding][183] 2024-03-19 14:55:57.844192 [DEBUG] sofia.c:7094 Remote SDP: v=0 o=HuaweiSoftX3000 116961593864129 116961593864129 IN IP4 41.160.32.115 s=- c=IN IP4 41.160.32.115 t=0 0 m=audio 22230 RTP/AVP 8 101 a=rtpmap:8 PCMA/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-15 a=ptime:20 2024-03-19 14:55:57.844192 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2024-03-19 14:55:57.844192 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2024-03-19 14:55:57.844192 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2024-03-19 14:55:57.844192 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2024-03-19 14:55:57.844192 [DEBUG] switch_core_media.c:4365 Set telephone-event payload to 101@8000 2024-03-19 14:55:57.844192 [DEBUG] switch_core_media.c:3061 Set Codec sofia/default/0736001022 PCMA/8000 20 ms 160 samples 64000 bits 1 channels 2024-03-19 14:55:57.844192 [DEBUG] switch_core_codec.c:111 sofia/default/0736001022 Original read codec set to PCMA:8 2024-03-19 14:55:57.864165 [DEBUG] switch_core_media.c:4708 Set telephone-event payload to 101@8000 2024-03-19 14:55:57.864165 [DEBUG] switch_core_media.c:4767 sofia/default/0736001022 Set 2833 dtmf send payload to 101 recv payload to 101 2024-03-19 14:55:57.864165 [DEBUG] switch_core_media.c:6878 AUDIO RTP [sofia/default/0736001022] 156.38.231.107 port 20394 -> 41.160.32.115 port 22230 codec: 8 ms: 20 2024-03-19 14:55:57.864165 [DEBUG] switch_rtp.c:4137 Starting timer [soft] 160 bytes per 20ms 2024-03-19 14:55:57.864165 [DEBUG] switch_core_media.c:7180 sofia/default/0736001022 Set 2833 dtmf send payload to 101 2024-03-19 14:55:57.864165 [DEBUG] switch_core_media.c:7187 sofia/default/0736001022 Set 2833 dtmf receive payload to 101 2024-03-19 14:55:57.864165 [DEBUG] switch_core_media.c:7210 sofia/default/0736001022 Set rtp dtmf delay to 40 2024-03-19 14:55:57.864165 [NOTICE] sofia_media.c:92 Pre-Answer sofia/default/0736001022! 2024-03-19 14:55:57.864165 [DEBUG] switch_channel.c:3474 (sofia/default/0736001022) Callstate Change DOWN -> EARLY 2024-03-19 14:55:57.864165 [INFO] switch_ivr_originate.c:3654 Sending early media 2024-03-19 14:55:57.864165 [DEBUG] switch_core_media.c:6878 AUDIO RTP [sofia/default/0534740341@legalaidsa.nebular.co.za:5060] 156.38.231.107 port 28222 -> 156.38.150.6 port 9720 codec: 8 ms: 20 2024-03-19 14:55:57.886040 [DEBUG] switch_rtp.c:4137 Starting timer [soft] 160 bytes per 20ms 2024-03-19 14:55:57.886040 [DEBUG] switch_core_media.c:7180 sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Set 2833 dtmf send payload to 101 2024-03-19 14:55:57.886040 [DEBUG] switch_core_media.c:7187 sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Set 2833 dtmf receive payload to 101 2024-03-19 14:55:57.886040 [DEBUG] switch_core_media.c:7210 sofia/default/0534740341@legalaidsa.nebular.co.za:5060 Set rtp dtmf delay to 40 2024-03-19 14:55:57.886040 [DEBUG] mod_sofia.c:2364 Ring SDP: v=0 o=FreeSWITCH 1710831935 1710831936 IN IP4 156.38.231.107 s=FreeSWITCH c=IN IP4 156.38.231.107 t=0 0 m=audio 28222 RTP/AVP 8 101 a=rtpmap:8 PCMA/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=ptime:20 a=sendrecv 2024-03-19 14:55:57.886040 [NOTICE] mod_sofia.c:2367 Pre-Answer sofia/default/0534740341@legalaidsa.nebular.co.za:5060! 2024-03-19 14:55:57.886040 [DEBUG] switch_channel.c:3474 (sofia/default/0534740341@legalaidsa.nebular.co.za:5060) Callstate Change RINGING -> EARLY 2024-03-19 14:55:57.886040 [DEBUG] switch_ivr_originate.c:3705 Originate Resulted in Success: [sofia/default/0736001022] 2024-03-19 14:55:57.886040 [DEBUG] sofia.c:7084 Channel sofia/default/0534740341@legalaidsa.nebular.co.za:5060 entering state [early][183] 2024-03-19 14:55:57.886040 [DEBUG] switch_ivr_bridge.c:1614 (sofia/default/0736001022) State Change CS_CONSUME_MEDIA -> CS_EXCHANGE_MEDIA 2024-03-19 14:55:57.886040 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0736001022) Running State Change CS_EXCHANGE_MEDIA (Cur 21 Tot 536012) 2024-03-19 14:55:57.886040 [DEBUG] switch_core_state_machine.c:653 (sofia/default/0736001022) State EXCHANGE_MEDIA 2024-03-19 14:55:57.886040 [DEBUG] mod_sofia.c:631 SOFIA EXCHANGE_MEDIA 2024-03-19 14:55:57.924178 [DEBUG] sofia.c:7084 Channel sofia/default/0736001022 entering state [proceeding][180] 2024-03-19 14:55:57.924178 [NOTICE] sofia.c:7192 Ring-Ready sofia/default/0736001022! 2024-03-19 14:55:57.924178 [DEBUG] switch_channel.c:3346 (sofia/default/0736001022) Callstate Change EARLY -> RINGING 2024-03-19 14:55:58.064315 [DEBUG] switch_ivr_bridge.c:546 sofia/default/0736001022 Bridge execute app sched_hangup(+6000 normal_clearing) 2024-03-19 14:55:58.084190 [DEBUG] switch_ivr.c:623 sofia/default/0736001022 Command Execute sched_hangup(+6000 normal_clearing) EXECUTE sofia/default/0736001022 sched_hangup(+6000 normal_clearing) 2024-03-19 14:55:58.084190 [DEBUG] switch_scheduler.c:249 Added task 216772 switch_ivr_schedule_hangup (ca6c0aba-e600-11ee-8a2e-d17fbcf33421) to run at 1710866158 2024-03-19 14:55:58.144185 [DEBUG] switch_rtp.c:7308 Correct audio ip/port confirmed. 2024-03-19 14:55:58.144185 [INFO] switch_rtp.c:7268 Auto Changing audio port from 156.38.150.6:9720 to 156.38.231.105:9720 2024-03-19 14:56:02.584158 [NOTICE] switch_channel.c:1104 New Channel sofia/default/0159626206@legalaidsa.nebular.co.za:5060 [ce06acd4-e600-11ee-8a34-d17fbcf33421] 2024-03-19 14:56:02.584158 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0159626206@legalaidsa.nebular.co.za:5060) Running State Change CS_NEW (Cur 22 Tot 536013) 2024-03-19 14:56:02.584158 [DEBUG] sofia.c:9873 sofia/default/0159626206@legalaidsa.nebular.co.za:5060 receiving invite from 156.38.231.106:5060 version: 1.6.20 64bit 2024-03-19 14:56:02.584158 [DEBUG] sofia.c:9989 IP 156.38.231.106 Approved by acl "default[]". Access Granted. 2024-03-19 14:56:02.584158 [DEBUG] sofia.c:7084 Channel sofia/default/0159626206@legalaidsa.nebular.co.za:5060 entering state [received][100] 2024-03-19 14:56:02.584158 [DEBUG] sofia.c:7094 Remote SDP: v=0 o=3cxPS 392721072128 314807681025 IN IP4 156.38.150.6 s=3cxPS Audio call c=IN IP4 156.38.150.6 t=0 0 m=audio 9722 RTP/AVP 8 0 9 101 a=rtpmap:8 PCMA/8000 a=rtpmap:0 PCMU/8000 a=rtpmap:9 G722/8000 a=rtpmap:101 telephone-event/8000 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:60:8000:1] 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:60:8000:1] 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G722:9:8000:20:64000:1]/[G729:18:8000:60:8000:1] 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G722:9:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4365 Set telephone-event payload to 101@8000 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:3061 Set Codec sofia/default/0159626206@legalaidsa.nebular.co.za:5060 PCMA/8000 20 ms 160 samples 64000 bits 1 channels 2024-03-19 14:56:02.584158 [DEBUG] switch_core_codec.c:111 sofia/default/0159626206@legalaidsa.nebular.co.za:5060 Original read codec set to PCMA:8 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4708 Set telephone-event payload to 101@8000 2024-03-19 14:56:02.584158 [DEBUG] switch_core_media.c:4767 sofia/default/0159626206@legalaidsa.nebular.co.za:5060 Set 2833 dtmf send payload to 101 recv payload to 101 2024-03-19 14:56:02.584158 [DEBUG] sofia.c:7507 (sofia/default/0159626206@legalaidsa.nebular.co.za:5060) State Change CS_NEW -> CS_INIT 2024-03-19 14:56:02.584158 [DEBUG] switch_core_state_machine.c:603 (sofia/default/0159626206@legalaidsa.nebular.co.za:5060) State NEW 2024-03-19 14:56:02.584158 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0159626206@legalaidsa.nebular.co.za:5060) Running State Change CS_INIT (Cur 22 Tot 536013) 2024-03-19 14:56:02.584158 [DEBUG] switch_core_state_machine.c:627 (sofia/default/0159626206@legalaidsa.nebular.co.za:5060) State INIT 2024-03-19 14:56:02.584158 [DEBUG] mod_sofia.c:90 sofia/default/0159626206@legalaidsa.nebular.co.za:5060 SOFIA INIT 2024-03-19 14:56:02.584158 [DEBUG] switch_core_state_machine.c:40 sofia/default/0159626206@legalaidsa.nebular.co.za:5060 Standard INIT 2024-03-19 14:56:02.584158 [DEBUG] switch_core_state_machine.c:48 (sofia/default/0159626206@legalaidsa.nebular.co.za:5060) State Change CS_INIT -> CS_ROUTING 2024-03-19 14:56:02.584158 [DEBUG] switch_core_state_machine.c:627 (sofia/default/0159626206@legalaidsa.nebular.co.za:5060) State INIT going to sleep 2024-03-19 14:56:02.584158 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0159626206@legalaidsa.nebular.co.za:5060) Running State Change CS_ROUTING (Cur 22 Tot 536013) 2024-03-19 14:56:02.584158 [DEBUG] switch_channel.c:2249 (sofia/default/0159626206@legalaidsa.nebular.co.za:5060) Callstate Change DOWN -> RINGING 2024-03-19 14:56:02.584158 [DEBUG] switch_core_state_machine.c:643 (sofia/default/0159626206@legalaidsa.nebular.co.za:5060) State ROUTING 2024-03-19 14:56:02.584158 [DEBUG] mod_sofia.c:143 sofia/default/0159626206@legalaidsa.nebular.co.za:5060 SOFIA ROUTING 2024-03-19 14:56:02.584158 [DEBUG] switch_core_state_machine.c:236 sofia/default/0159626206@legalaidsa.nebular.co.za:5060 Standard ROUTING 2024-03-19 14:56:02.584158 [INFO] mod_dialplan_xml.c:637 Processing 0159626206 <0159626206>->0710575002 in context default 2024-03-19 14:56:02.584158 [DEBUG] freeswitch_lua.cpp:365 DBH handle 0x7fed500f71b0 Connected. 2024-03-19 14:56:02.584158 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2024-03-19 14:56:02.604237 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2024-03-19 14:56:02.604237 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] blind_flag: 0 2024-03-19 14:56:02.604237 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Dialed number : 0710575002 2024-03-19 14:56:02.604237 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '0710575002' limit 1 2024-03-19 14:56:02.604237 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '0710575002' AND status=0 limit 1 2024-03-19 14:56:02.604237 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '0710575002' and status=0 LIMIT 1 2024-03-19 14:56:02.604237 [WARNING] switch_cpp.cpp:1365 [ASTPP] [FAXER] Custom Caller ID 2024-03-19 14:56:02.604237 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Caller Id name / number : 0159626206 / 0159626206 2024-03-19 14:56:02.604237 [DEBUG] switch_cpp.cpp:1365 [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 ="0710575002" LIMIT 1 2024-03-19 14:56:02.604237 [DEBUG] switch_cpp.cpp:1365 [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 FROM sip_devices as sip_devices,accounts as accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="0710575002" AND domains.domain="legalaidsa.nebular.co.za" limit 1 2024-03-19 14:56:02.604237 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Call direction : outbound 2024-03-19 14:56:02.604237 [INFO] switch_cpp.cpp:1365 [ASTPP] [Accountcode : 196083] 2024-03-19 14:56:02.604237 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "196083" AND deleted = 0 limit 1 2024-03-19 14:56:02.624305 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^0710575002.*' OR blocked_patterns = '^071057500.*' OR blocked_patterns = '^07105750.*' OR blocked_patterns = '^0710575.*' OR blocked_patterns = '^071057.*' OR blocked_patterns = '^07105.*' OR blocked_patterns = '^0710.*' OR blocked_patterns = '^071.*' OR blocked_patterns = '^07.*' OR blocked_patterns = '^0.*' OR blocked_patterns ='--') AND accountid = 109 limit 1 2024-03-19 14:56:02.624305 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="0710575002" AND (accountid = 0 OR status = 1) LIMIT 1 2024-03-19 14:56:02.624305 [NOTICE] switch_cpp.cpp:1365 [ASTPP] Localization Id: 3 2024-03-19 14:56:02.624305 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 3 AND status=0 limit 1 2024-03-19 14:56:02.624305 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"27/0,00/99".....0710575002 2024-03-19 14:56:02.624305 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"27/0,00/99".....0710575002 2024-03-19 14:56:02.624305 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE (patterns = '^0710575002.*' OR patterns = '^071057500.*' OR patterns = '^07105750.*' OR patterns = '^0710575.*' OR patterns = '^071057.*' OR patterns = '^07105.*' OR patterns = '^0710.*' OR patterns = '^071.*' OR patterns = '^07.*' OR patterns = '^0.*' OR patterns ='--') AND accountid = 109 ORDER BY LENGTH(PKGPTR.patterns) DESC 2024-03-19 14:56:02.624305 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_SPEEDDIAL] Query :SELECT A.number FROM speed_dial as A,accounts as B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.speed_num ="0710575002" AND A.accountid = '109' limit 1 2024-03-19 14:56:02.624305 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 0710575002 2024-03-19 14:56:02.624305 [DEBUG] switch_cpp.cpp:1365 [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 ="0710575002" LIMIT 1 2024-03-19 14:56:02.624305 [DEBUG] switch_cpp.cpp:1365 [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 FROM sip_devices as sip_devices,accounts as accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="0710575002" AND domains.domain="legalaidsa.nebular.co.za" limit 1 2024-03-19 14:56:02.624305 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] New Call Direction : outbound 2024-03-19 14:56:02.624305 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '0710575002' OR number = '071057500' OR number = '07105750' OR number = '0710575' OR number = '071057' OR number = '07105' OR number = '0710' OR number = '071' OR number = '07' OR number = '0' OR number ='--') OR (number = '0710575002*' OR number = '071057500*' OR number = '07105750*' OR number = '0710575*' OR number = '071057*' OR number = '07105*' OR number = '0710*' OR number = '071*' OR number = '07*' OR number = '0*' OR number ='--') OR (number = '0159626206' OR number = '015962620' OR number = '01596262' OR number = '0159626' OR number = '015962' OR number = '01596' OR number = '0159' OR number = '015' OR number = '01' OR number = '0' OR number ='--') OR (number = '0159626206*' OR number = '015962620*' OR number = '01596262*' OR number = '0159626*' OR number = '015962*' OR number = '01596*' OR number = '0159*' OR number = '015*' OR number = '01*' OR number = '0*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2024-03-19 14:56:02.624305 [DEBUG] switch_cpp.cpp:1365 [ASTPP] Call Barring Status : -1 2024-03-19 14:56:02.624305 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '0710575002' OR routing_prefix = '071057500' OR routing_prefix = '07105750' OR routing_prefix = '0710575' OR routing_prefix = '071057' OR routing_prefix = '07105' OR routing_prefix = '0710' OR routing_prefix = '071' OR routing_prefix = '07' OR routing_prefix = '0' OR routing_prefix ='--') AND status = 0 and reseller_id = 13 limit 1 2024-03-19 14:56:02.624305 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [PORTED_NUMBER] Get Destination Number (0710575002)!!!! 2024-03-19 14:56:02.624305 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [PORTED_NUMBER] Ported Number :27710575002 2024-03-19 14:56:02.624305 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [PORTED_NUMBER] Query :SELECT rnoroute FROM ported_number WHERE dnfrom ='27710575002' limit 1 2024-03-19 14:56:02.624305 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [PORTED_NUMBER] After Append Ported Number : (0710575002)!!!! 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Account Information =================== 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] User id : 109 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Account code : 196083 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Balance : 11176.1935 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Type : 1 [0:prepaid,1:postpaid] 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Ratecard id : 93 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] CID Pool : 0 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] ======================================================== 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0159626206 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0159626206 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0159626206 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0159626206 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0159626206 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0159626206 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0159626206 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0159626206 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0159626206 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0159626206 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0159626206 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"D871/,D874/,D912/".....0159626206 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 93 AND status = 0 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_RATES] call_direction :outbound 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 93 AND status = 0 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^0710575002.*' OR pattern = '^071057500.*' OR pattern = '^07105750.*' OR pattern = '^0710575.*' OR pattern = '^071057.*' OR pattern = '^07105.*' OR pattern = '^0710.*' OR pattern = '^071.*' OR pattern = '^07.*' OR pattern = '^0.*' OR pattern ='--') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 93 OR accountid=109) ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC,effective_date DESC LIMIT 1 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Call Direction : outbound 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Rates Information =================== 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 2148435 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Includedseconds : 0 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Cost : 0.44000 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Comment : SOUTH AFRICA - MTN - MOBILE 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Country Id : 0 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Accid : 109 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Trunk ID: 0 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Routing type: 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] ================================================================ 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] [FIND_MAXLENGTH] Your11176.1935 balance Accountid 109 !!! 2024-03-19 14:56:02.644150 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins! 2024-03-19 14:56:02.644150 [NOTICE] switch_cpp.cpp:1365 [ASTPP] FINDING LIMIT FOR RESELLER: 13 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "13" AND deleted = 0 limit 1 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^0710575002.*' OR blocked_patterns = '^071057500.*' OR blocked_patterns = '^07105750.*' OR blocked_patterns = '^0710575.*' OR blocked_patterns = '^071057.*' OR blocked_patterns = '^07105.*' OR blocked_patterns = '^0710.*' OR blocked_patterns = '^071.*' OR blocked_patterns = '^07.*' OR blocked_patterns = '^0.*' OR blocked_patterns ='--') AND accountid = 13 limit 1 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Reseller Information =================== 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] User id : 13 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Account code : 778509 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Balance : 10289.9683 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Ratecard id : 83 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 83 AND status = 0 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_RATES] call_direction :outbound 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 83 AND status = 0 2024-03-19 14:56:02.644150 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^0710575002.*' OR pattern = '^071057500.*' OR pattern = '^07105750.*' OR pattern = '^0710575.*' OR pattern = '^071057.*' OR pattern = '^07105.*' OR pattern = '^0710.*' OR pattern = '^071.*' OR pattern = '^07.*' OR pattern = '^0.*' OR pattern ='--') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 83 OR accountid=13) ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC,effective_date DESC LIMIT 1 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Call Direction : outbound 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Rates Information =================== 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 1426337 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Includedseconds : 0 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Cost : 0.29000 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Comment : D083-MTN 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Country Id : 0 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Accid : 13 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Trunk ID: 0 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Routing type: 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] ================================================================ 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] [FIND_MAXLENGTH] Your10289.9683 balance Accountid 13 !!! 2024-03-19 14:56:02.644150 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins! 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Reseller xml_user_rates : ID:2148435|CODE:^0710.*|DESTINATION:SOUTH AFRICA - MTN - MOBILE|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.44000|INC:1|INITIALBLOCK:1|RATEGROUP:93|MARKUP:0|CI:0|ACCID:109||ID:1426337|CODE:^0710.*|DESTINATION:D083-MTN|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.29000|INC:1|INITIALBLOCK:1|RATEGROUP:83|MARKUP:0|CI:0|ACCID:13 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] ======================================================== 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Lossless Routing Status : 1 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] Call Max Length Duration : 100 minutes 2024-03-19 14:56:02.644150 [INFO] switch_cpp.cpp:1365 [ASTPP] [DIALPLAN] User Rate ID : 2148435