Hunt-RDNIS: 23418870231
Hunt-Channel-Name: sofia/default/5760419167%40billing.delaphonegh.com
Hunt-Profile-Index: 2
Hunt-Profile-Created-Time: 1662550671773172
Hunt-Channel-Created-Time: 1662550671693128
Hunt-Channel-Answered-Time: 0
Hunt-Channel-Progress-Time: 0
Hunt-Channel-Progress-Media-Time: 0
Hunt-Channel-Hangup-Time: 0
Hunt-Channel-Transfer-Time: 0
Hunt-Channel-Resurrect-Time: 0
Hunt-Channel-Bridged-Time: 0
Hunt-Channel-Last-Hold: 0
Hunt-Channel-Hold-Accum: 0
Hunt-Screen-Bit: true
Hunt-Privacy-Hide-Name: false
Hunt-Privacy-Hide-Number: false


2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_value: 
2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] section: dialplan
2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_name: 
2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] tag_name: 
2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [DIALPLAN] OUTBOUND_service
2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Dialed number : 233553109295
2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '233553109295' AND status=0 limit 1
2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Caller Id name / number  : +233242436874 / +233242436874
2022-09-07 11:37:51.793140 [NOTICE] switch_cpp.cpp:1443 [ASTPP] DID global translation id: 1
2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1 
2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [DIALPLAN] OUTBOUND_service
2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Dialed number : 233209029456
2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '233209029456' AND status=0 limit 1
2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [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 ="233553109295" LIMIT 1
2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Caller Id name / number  : 5760419167 / 5760419167
2022-09-07 11:37:51.793140 [NOTICE] switch_cpp.cpp:1443 [ASTPP] DID global translation id: 1
2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1 
2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as  accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="233553109295" limit 1
2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [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 ="233209029456" LIMIT 1
2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Call direction : outbound
2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("54.172.60.3") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 -  SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1))  AND "233553109295"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as  accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="233209029456" limit 1
2022-09-07 11:37:51.813146 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Call direction : outbound
2022-09-07 11:37:51.813146 [INFO] switch_cpp.cpp:1443 [ASTPP] [Accountcode : 8320249953]
2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "8320249953" AND deleted = 0 limit 1
2022-09-07 11:37:51.813146 [INFO] switch_cpp.cpp:1443 [ASTPP] [Accountcode : 7969403565]
2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "7969403565" AND deleted = 0 limit 1
2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^233209029456.*' OR blocked_patterns = '^23320902945.*' OR blocked_patterns = '^2332090294.*' OR blocked_patterns = '^233209029.*' OR blocked_patterns = '^23320902.*' OR blocked_patterns = '^2332090.*' OR blocked_patterns = '^233209.*' OR blocked_patterns = '^23320.*' OR blocked_patterns = '^2332.*' OR blocked_patterns = '^233.*' OR blocked_patterns = '^23.*' OR blocked_patterns = '^2.*' OR blocked_patterns ='--') AND accountid = 1569 limit 1 
2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^233553109295.*' OR blocked_patterns = '^23355310929.*' OR blocked_patterns = '^2335531092.*' OR blocked_patterns = '^233553109.*' OR blocked_patterns = '^23355310.*' OR blocked_patterns = '^2335531.*' OR blocked_patterns = '^233553.*' OR blocked_patterns = '^23355.*' OR blocked_patterns = '^2335.*' OR blocked_patterns = '^233.*' OR blocked_patterns = '^23.*' OR blocked_patterns = '^2.*' OR blocked_patterns ='--') AND accountid = 1329 limit 1 
2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [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 ="233209029456" AND A.accountid = '1569' limit 1
2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [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 ="233553109295" AND A.accountid = '1329' limit 1
2022-09-07 11:37:51.813146 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 233209029456
2022-09-07 11:37:51.813146 [NOTICE] switch_cpp.cpp:1443 [ASTPP] DID global translation id: 1
2022-09-07 11:37:51.813146 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 233553109295
2022-09-07 11:37:51.813146 [NOTICE] switch_cpp.cpp:1443 [ASTPP] DID global translation id: 1
2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1 
2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1 
2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [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 ="233209029456" LIMIT 1
2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [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 ="233553109295" LIMIT 1
2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as  accoun