Sure, @david551…here you go
logs on OtherPBX (getting 603):
Connected to Asterisk 1.8.9.0 currently running on sip (pid = 2907)
Verbosity is at least 9
== Using UDPTL TOS bits 184
== Using UDPTL CoS mark 5
== Using SIP RTP TOS bits 184
== Using SIP RTP CoS mark 5
-- Executing [8610@default:1] AGI("SIP/1*6611-00000192", "agi.php") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/agi.php
agi.php: Callerid 6611 not blacklisted
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:1237 - uniqueid:1725644518.442 - check_auth_account Username 6611, CustID 1 , AccountID 111 Source : 6611test <6611>, Destination :8610
agi.php: file:/var/lib/asterisk/agi-bin/agi.php - line:583 - uniqueid:1725644518.442 - [EXTEN to OUTBOUND number Routing]
agi.php: file:/var/lib/asterisk/agi-bin/agi.php - line:635 - uniqueid:1725644518.442 - [Account Balance : 9118.64102]
agi.php: app is 'EXTEN': Setting dst_account_id to
agi.php: file:/var/lib/asterisk/agi-bin/agi.php - line:649 - uniqueid:1725644518.442 - [EXTEN info CustomerID : 1, AccountID : ]
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:1313 - uniqueid:1725644518.442 - [Add Dialpattern Prefix : ; Remove Dialpattern Prefix : ]
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:1317 - uniqueid:1725644518.442 - [New dst after dial pattern process : 8610]
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:1328 - uniqueid:1725644518.442 - [New dst after internal Prefix rate management process : 8610]
agi.php: file:/var/lib/asterisk/agi-bin/agi.php - line:676 - uniqueid:1725644518.442 - [Dialled number has not modified via dial pattern; Old Number 8610 and Return Number : 8610]
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:1131 - uniqueid:1725644518.442 - get_rates Function
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:936 - uniqueid:1725644518.442 - get_minutes PBX2PBX = 1
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:937 - uniqueid:1725644518.442 - get_minutes Credit = 9118.64102
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:938 - uniqueid:1725644518.442 - get_minutes Sale Rate = 0.00001
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:939 - uniqueid:1725644518.442 - get_minutes Total Time = 15197735 hours 1 minute 59 seconds
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:940 - uniqueid:1725644518.442 - get_minutes MaxCall Time = 7200 Sec
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:1014 - uniqueid:1725644518.442 - get_trunk Function
agi.php: BEFORE 8610,
agi.php: AFTER 8610,
agi.php: app is 'EXTEN': Setting dst_account_id to
agi.php: app is 'EXTEN': Setting dst_account_id to
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:661 - uniqueid:1725644518.442 - Max outbound calls : 1
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:643 - uniqueid:1725644518.442 - *************** CALLERID NUMBER: ***************
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:645 - uniqueid:1725644518.442 - *************** CALLERID NUMBER: DNID LENGTH IS 4 for 8610***************
-- AGI Script Executing Application: (SIPRemoveHeader) Options: (Alert-Info:Ring Answer)
-- AGI Script Executing Application: (SIPRemoveHeader) Options: (Call-Info:<uri>;answer-after=0)
agi.php: Dialing with parameters: SIP/inehtrunknew/8610,30,rRwL(54711846120000:60000)M(recording^^1725644518.442^)
-- AGI Script Executing Application: (DIAL) Options: (SIP/inehtrunknew/8610,30,rRwL(54711846120000:60000)M(recording^^1725644518.442^))
-- Setting call duration limit to 54711846120.000 seconds.
== Using UDPTL TOS bits 184
== Using UDPTL CoS mark 5
== Using SIP RTP TOS bits 184
== Using SIP RTP CoS mark 5
-- Called SIP/inehtrunknew/8610
-- Got SIP response 603 "Declined" back from 10.10.6.253:5060
-- SIP/inehtrunknew-00000193 is busy
== Everyone is busy/congested at this time (1:1/0/0)
-- <SIP/1*6611-00000192>AGI Script agi.php completed, returning 4
== Spawn extension (default, 8610, 1) exited non-zero on 'SIP/1*6611-00000192'
-- Executing [h@default:1] AGI("SIP/1*6611-00000192", "agi.php,CDR") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/agi.php
agi.php,CDR: Callerid 6611 not blacklisted
agi.php,CDR: app is 'EXTEN': Setting dst_account_id to
agi.php,CDR: --value of cmdstring is: SIP/inehtrunknew-00000193
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:2569 - uniqueid:1725644518.442 - cmdstring: SIP/inehtrunknew-00000193
-- Remote UNIX connection
-- Remote UNIX connection disconnected
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:1237 - uniqueid:1725644518.442 - check_auth_account Username 6611, CustID 1 , AccountID 111 Source : 6611test <6611>, Destination :h
agi.php,CDR: file:/var/lib/asterisk/agi-bin/agi.php - line:2910 - uniqueid:1725644518.442 - CDR clid 6611test <6611> src 6611 dst 8610 dcontext default channel SIP/1*6611-00000192 dstchannel SIP/inehtrunknew-00000193 lastapp AGI lastdata HANGUP starttime 2024-09-06 21:41:58 answertime endtime duration billduration disposition BUSY Stotime 2024-09-06 21:41:58
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:1131 - uniqueid:1725644518.442 - get_rates Function
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:762 - uniqueid:1725644518.442 - get_billcost Sale Cost: Buy Cost:
agi.php,CDR: file:/var/lib/asterisk/agi-bin/agi.php - line:2982 - uniqueid:1725644518.442 - CDR Query INSERT INTO `tp_cdr` (`customer_id`, `account_id`, `trunk_id`, `rate_id`, `rateplan_id`, `callplan_id`, `trunkgroup_id`, `uniqueid`, `starttime`, `stoptime`, `answertime`, `ringduration`, `billsec`, `callduration`, `destination`, `src`, `terminatecause`, `sale_rate`, `sale_cost`, `buy_rate`, `buy_cost`, `sipiax`, `recording_file`, `call_type`,`app_billsec`,`last_app`, `dst`,`last_credit`,`bill_level`,`provider_id`, `destination_name`,bill_account_id) VALUES ('1', '111', '19', '9109', '5', '1', '3', '1725644518.442', '2024-09-06 21:41:58', '2024-09-06 21:41:58', '', '0', '0', '0','8610', '6611', 'BUSY', '0.00001', '0', '0.00000', '0', '', '', 'OUTBOUND','0','AGI','8610','9118.64102','1','1','P2P','111')
-- <SIP/1*6611-00000192>AGI Script agi.php completed, returning 0
-- Remote UNIX connection
-- Remote UNIX connection disconnected
-- Remote UNIX connection
-- Remote UNIX connection disconnected
Logs on NewPBX (sending 603):
Using SIP VIDEO CoS mark 6
== Using SIP RTP TOS bits 184
== Using SIP RTP CoS mark 5
> 0x7f751415b900 -- Strict RTP learning after remote address set to: 10.10.9.254:13848
> 0x7f7514162150 -- Strict RTP learning after remote address set to: 10.10.9.254:10404
[Sep 6 21:38:43] ERROR[4594]: cdr.c:3397 ast_cdr_getvar: Unable to find CDR for channel SIP/ehtrunknew-00000036
[Sep 6 21:38:43] ERROR[4594]: cdr.c:3397 ast_cdr_getvar: Unable to find CDR for channel SIP/ehtrunknew-00000036
[Sep 6 21:38:43] ERROR[4594]: cdr.c:3397 ast_cdr_getvar: Unable to find CDR for channel SIP/ehtrunknew-00000036
-- Executing [8610@default:1] AGI("SIP/ehtrunknew-00000036", "agi.php") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/agi.php
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - set_serverid QUERY : select server_id FROM `blf_serverlist` WHERE islocal = '1'
agi.php: cdrsrc is:
agi.php: Callerid 6611 not blacklisted
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - check_auth_account QUERY : SELECT `tp_account`.`hosted`,`tp_account`.`voicemail_passwd`, `tp_account`.`ringtime` as exten_ringtime, `tp_customer`.`trunk_accountcode`, `tp_account`.`dialpatterngroup_id`, `tp_account`.`hidecallerid`, `tp_account`.`trunk_exten`, `tp_account`.`agentexten_type`, `tp_customer`.`email` AS customer_email, `tp_customer`.`commoncredit` AS customer_commoncredit , `tp_customer`.`recording_override` AS customer_recording_override, `tp_account`.`account_id`, `tp_account`.`name`, `tp_account`.`username`, `tp_account`.`accountcode`, `tp_account`.`customer_id`, `tp_account`.`credit`, `tp_account`.`callplan_id`, `tp_account`.`calleridlocal`, `tp_account`.`calleridexternal`, `tp_account`.`musiconhold`, `tp_account`.`voicemail`, `tp_account`.`fax`, `tp_account`.`inuse`, `tp_account`.`sipuser`, `tp_account`.`iaxuser`, `tp_account`.`billing_type`, `tp_account`.`failover_app`, `tp_account`.`failover_appnumber`, `tp_account`.`recording`, `tp_customer`.`dial_option`, `tp_customer`.`ringtime`, `tp_customer`.`recording_path` , `tp_account`.`extennumber` , `tp_customer`.`maxcallduration` FROM `tp_account` INNER JOIN `tp_customer` ON `tp_account`.`customer_id` = `tp_customer`.`customer_id` WHERE `tp_account`.`activated` = 't' AND `tp_account`.`status` = '1' AND `tp_customer`.`status` = '1' AND `accountcode` = 'ehtrunk'
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:1208 - uniqueid:sip.tt-1725644323.88 - check_auth_account Username ehtrunk, CustID 1 , AccountID 21 Source : 6611test <6611>, Destination :8610
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - GetSystemCode QUERY : SELECT code,code_name FROM `tp_featurecode` where customer_id='1' order by length(code) DESC
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - check_numberinfo QUERY : SELECT `table_id`, `app` from `tp_numberinfo` where `customer_id` = '1' AND `number_info` = '8610'
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:1370 - uniqueid:sip.tt-1725644323.88 - check_numberinfo; Table ID: 125 Application : EXTEN
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - get_blacklist QUERY : select `customer_id`, `account_id`, `phonenumber` from `tp_blacklist` where `phonenumber` = '6611' AND `customer_id` = '1' AND ( `account_id`='' OR `account_id` is NULL OR `account_id` = '125')
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:2424 - uniqueid:sip.tt-1725644323.88 - CALLTABLEQUERY: CALLTABLEQUERY
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - livecall QUERY : INSERT INTO `tp_livecall` (`server_id`,`dst_account_id`, `customer_id`, `account_id`, `trunk_id`, `uniqueid`, `starttime`, `dst`, `destination`, `src`, `channel`, `dstchannel`, `call_type`, `app`,`call_status`,`uniqueid2`,last_updated,queue_name,account_name,dst_account_name)VALUES ('2','125', '1', '21', NULL, 'sip.tt-1725644323.88', now(), '8610', '8610', '6611', 'SIP/ehtrunknew-00000036', NULL, 'INTERNAL','EXTEN','RINGING','sip.tt-1725644323.88',now(),'','ehtrunk','') ON DUPLICATE KEY UPDATE `dst` = '8610', `call_type` = 'INTERNAL',`trunk_id` = NULL, `app` = 'EXTEN', `dst_account_id` = '125', last_updated = now(),queue_name = '', account_name = 'ehtrunk', dst_account_name = ''
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - livecall QUERY : INSERT INTO `tp_livecall` (`server_id`,`dst_account_id`, `customer_id`, `account_id`, `trunk_id`, `uniqueid`, `starttime`, `dst`, `destination`, `src`, `channel`, `dstchannel`, `call_type`, `app`,`call_status`,`uniqueid2`,last_updated,queue_name,account_name,dst_account_name)VALUES ('2','125', '1', '21', NULL, 'sip.tt-1725644323.88', now(), '8610', '8610', '6611', 'SIP/ehtrunknew-00000036', NULL, 'INTERNAL','EXTEN','RINGING','sip.tt-1725644323.88',now(),'','ehtrunk','') ON DUPLICATE KEY UPDATE `dst` = '8610', `call_type` = 'INTERNAL',`trunk_id` = NULL, `app` = 'EXTEN', `dst_account_id` = '125', last_updated = now(),queue_name = '', account_name = 'ehtrunk', dst_account_name = ''
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - check_numberinfo QUERY : SELECT `table_id`, `app` from `tp_numberinfo` where `customer_id` = '1' AND `number_info` = '8610'
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:1370 - uniqueid:sip.tt-1725644323.88 - check_numberinfo; Table ID: 125 Application : EXTEN
agi.php: file:/var/lib/asterisk/agi-bin/agi.php - line:955 - uniqueid:sip.tt-1725644323.88 - [Caller Account ID : 125]
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - check_local_dst QUERY : SELECT `tp_account`.`ringtime` as exten_ringtime, `tp_account`.`trunk_exten`, `tp_account`.`custom_status`, `tp_customer`.`recording_override` AS customer_recording_override, `tp_account`.`account_id`, `tp_account`.`name`, `tp_account`.`username`, `tp_account`.`customer_id`, `tp_account`.`credit`, `tp_account`.`callplan_id`, `tp_account`.`calleridlocal`, `tp_account`.`calleridexternal`, `tp_account`.`musiconhold`, `tp_account`.`voicemail`, `tp_account`.`fax`, `tp_account`.`inuse`, `tp_account`.`sipuser`, `tp_account`.`iaxuser`, `tp_account`.`failover_app`, `tp_account`.`failover_appnumber`, `tp_account`.`callforward`, `tp_account`.`followme`, `tp_account`.`recording`, `tp_customer`.`dial_option`, `tp_customer`.`ringtime`, `tp_customer`.`recording_path` FROM `tp_account` INNER JOIN `tp_customer` ON `tp_account`.`customer_id` = `tp_customer`.`customer_id` WHERE (`tp_account`.`sipuser` = '1' or `tp_account`.`iaxuser` = '1') and `tp_account`.`activated`='t' AND `tp_account`.`status` = '1' AND `tp_account`.`customer_id` = '1' AND `tp_account`.`account_id` = '125' AND `tp_customer`.`status` = '1'
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:1343 - uniqueid:sip.tt-1725644323.88 - check_local_dst IAX 0 SIP 1
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:2424 - uniqueid:sip.tt-1725644323.88 - CALLTABLEQUERY: CALLTABLEQUERY
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - livecall QUERY : INSERT INTO `tp_livecall` (`server_id`,`dst_account_id`, `customer_id`, `account_id`, `trunk_id`, `uniqueid`, `starttime`, `dst`, `destination`, `src`, `channel`, `dstchannel`, `call_type`, `app`,`call_status`,`uniqueid2`,last_updated,queue_name,account_name,dst_account_name)VALUES ('2','125', '1', '21', NULL, 'sip.tt-1725644323.88', now(), '8610', '8610', '6611', 'SIP/ehtrunknew-00000036', NULL, 'INTERNAL','EXTEN','RINGING','sip.tt-1725644323.88',now(),'','ehtrunk','8610test') ON DUPLICATE KEY UPDATE `dst` = '8610', `call_type` = 'INTERNAL',`trunk_id` = NULL, `app` = 'EXTEN', `dst_account_id` = '125', last_updated = now(),queue_name = '', account_name = 'ehtrunk', dst_account_name = '8610test'
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - livecall QUERY : INSERT INTO `tp_livecall` (`server_id`,`dst_account_id`, `customer_id`, `account_id`, `trunk_id`, `uniqueid`, `starttime`, `dst`, `destination`, `src`, `channel`, `dstchannel`, `call_type`, `app`,`call_status`,`uniqueid2`,last_updated,queue_name,account_name,dst_account_name)VALUES ('2','125', '1', '21', NULL, 'sip.tt-1725644323.88', now(), '8610', '8610', '6611', 'SIP/ehtrunknew-00000036', NULL, 'INTERNAL','EXTEN','RINGING','sip.tt-1725644323.88',now(),'','ehtrunk','8610test') ON DUPLICATE KEY UPDATE `dst` = '8610', `call_type` = 'INTERNAL',`trunk_id` = NULL, `app` = 'EXTEN', `dst_account_id` = '125', last_updated = now(),queue_name = '', account_name = 'ehtrunk', dst_account_name = '8610test'
agi.php: file:/var/lib/asterisk/agi-bin/agi.php - line:1561 - uniqueid:sip.tt-1725644323.88 - Recoding file:
agi.php: file:/var/lib/asterisk/agi-bin/agi.php - line:1567 - uniqueid:sip.tt-1725644323.88 - Dial starting 8610
agi.php: file:/var/lib/asterisk/agi-bin/agi.php - line:1599 - uniqueid:sip.tt-1725644323.88 - Dial starting SIP/1*8610,30,kXwM(recording^^sip.tt-1725644323.88)
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:658 - uniqueid:sip.tt-1725644323.88 - *************** CALLERID NUMBER: ***************
agi.php: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:661 - uniqueid:sip.tt-1725644323.88 - *************** CALLERID NUMBER: DNID LENGTH IS 4 for 8610***************
-- <SIP/ehtrunknew-00000036>AGI Script agi.php completed, returning 0
-- Executing [8610@default:2] Hangup("SIP/ehtrunknew-00000036", "") in new stack
== Spawn extension (default, 8610, 2) exited non-zero on 'SIP/ehtrunknew-00000036'
-- Executing [h@default:1] AGI("SIP/ehtrunknew-00000036", "agi.php,CDR") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/agi.php
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - set_serverid QUERY : select server_id FROM `blf_serverlist` WHERE islocal = '1'
agi.php,CDR: cdrsrc is:
agi.php,CDR: Callerid 6611 not blacklisted
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:2424 - uniqueid:sip.tt-1725644323.88 - CALLTABLEQUERY: CALLTABLEQUERY
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - livecall QUERY : select recording,account_id, dst_account_id FROM `tp_livecall` WHERE `uniqueid` = 'sip.tt-1725644323.88' or `uniqueid2` = 'sip.tt-1725644323.88' AND server_id = '2'
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:2565 - uniqueid:sip.tt-1725644323.88 - cmdstring:
-- Remote UNIX connection
-- Remote UNIX connection disconnected
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - livecall QUERY : update blf_livestatus set exten_status_update = now() where account_id = '21' or account_id = '125'
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - livecall QUERY : DELETE FROM `tp_livecall` WHERE `uniqueid` = 'sip.tt-1725644323.88' or `uniqueid2` = 'sip.tt-1725644323.88' AND server_id = '2'
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - check_auth_account QUERY : SELECT `tp_account`.`hosted`,`tp_account`.`voicemail_passwd`, `tp_account`.`ringtime` as exten_ringtime, `tp_customer`.`trunk_accountcode`, `tp_account`.`dialpatterngroup_id`, `tp_account`.`hidecallerid`, `tp_account`.`trunk_exten`, `tp_account`.`agentexten_type`, `tp_customer`.`email` AS customer_email, `tp_customer`.`commoncredit` AS customer_commoncredit , `tp_customer`.`recording_override` AS customer_recording_override, `tp_account`.`account_id`, `tp_account`.`name`, `tp_account`.`username`, `tp_account`.`accountcode`, `tp_account`.`customer_id`, `tp_account`.`credit`, `tp_account`.`callplan_id`, `tp_account`.`calleridlocal`, `tp_account`.`calleridexternal`, `tp_account`.`musiconhold`, `tp_account`.`voicemail`, `tp_account`.`fax`, `tp_account`.`inuse`, `tp_account`.`sipuser`, `tp_account`.`iaxuser`, `tp_account`.`billing_type`, `tp_account`.`failover_app`, `tp_account`.`failover_appnumber`, `tp_account`.`recording`, `tp_customer`.`dial_option`, `tp_customer`.`ringtime`, `tp_customer`.`recording_path` , `tp_account`.`extennumber` , `tp_customer`.`maxcallduration` FROM `tp_account` INNER JOIN `tp_customer` ON `tp_account`.`customer_id` = `tp_customer`.`customer_id` WHERE `tp_account`.`activated` = 't' AND `tp_account`.`status` = '1' AND `tp_customer`.`status` = '1' AND `accountcode` = 'ehtrunk'
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:1208 - uniqueid:sip.tt-1725644323.88 - check_auth_account Username ehtrunk, CustID 1 , AccountID 21 Source : 6611test <6611>, Destination :h
agi.php,CDR: file:/var/lib/asterisk/agi-bin/agi.php - line:2910 - uniqueid:sip.tt-1725644323.88 - CDR clid 6611test <6611> src 6611 dst 8610 dcontext default channel SIP/ehtrunknew-00000036 dstchannel lastapp Hangup lastdata starttime 2024-09-06 21:38:43 answertime disposition FAILED Stotime 2024-09-06 21:38:43
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - cdr QUERY : INSERT INTO `tp_cdr` (`customer_id`, `account_id`, `trunk_id`, `rate_id`, `rateplan_id`, `callplan_id`, `trunkgroup_id`, `uniqueid`, `starttime`, `stoptime`, `answertime`, `ringduration`, `billsec`, `callduration`, `destination`, `src`, `terminatecause`, `sale_rate`, `sale_cost`, `buy_rate`, `buy_cost`, `sipiax`, `recording_file`, `call_type`,`app_billsec`,`last_app`, `dst`) VALUES ('1', '21', '', '', '', '', '', 'sip.tt-1725644323.88', '2024-09-06 21:38:43', '2024-09-06 21:38:43', '', '0', '0', '0','8610', '6611', 'FAILED', '', '', '', '', '', '', 'INTERNAL','0','Hangup','')
agi.php,CDR: file:/var/lib/asterisk/agi-bin/agi.php - line:3001 - uniqueid:sip.tt-1725644323.88 - CDR Query INSERT INTO `tp_cdr` (`customer_id`, `account_id`, `trunk_id`, `rate_id`, `rateplan_id`, `callplan_id`, `trunkgroup_id`, `uniqueid`, `starttime`, `stoptime`, `answertime`, `ringduration`, `billsec`, `callduration`, `destination`, `src`, `terminatecause`, `sale_rate`, `sale_cost`, `buy_rate`, `buy_cost`, `sipiax`, `recording_file`, `call_type`,`app_billsec`,`last_app`, `dst`) VALUES ('1', '21', '', '', '', '', '', 'sip.tt-1725644323.88', '2024-09-06 21:38:43', '2024-09-06 21:38:43', '', '0', '0', '0','8610', '6611', 'FAILED', '', '', '', '', '', '', 'INTERNAL','0','Hangup','')
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - cdr QUERY : delete from `tp_call_status` where `dead_call` = '1' AND `callId` = 'sip.tt-1725644323.88' AND `status` = 'NEW' AND `callerId` = ''
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - missedcall_count QUERY : UPDATE blf_livestatus SET missed_call = ifnull(missed_call,0) + 1, exten_status_update = now() where customer_id = '1' AND extension IN ('' , '8610') AND account_id<> '21'
agi.php,CDR: file:/var/lib/asterisk/agi-bin/agi.php - line:3011 - uniqueid:sip.tt-1725644323.88 - CDR Query UPDATE blf_livestatus SET missed_call = ifnull(missed_call,0) + 1, exten_status_update = now() where customer_id = '1' AND extension IN ('' , '8610') AND account_id<> '21'
agi.php,CDR: file:/var/lib/asterisk/agi-bin/Class.TpadPBX.php - line:190 - uniqueid:sip.tt-1725644323.88 - cdr QUERY : SELECT email from as_voicemail where mailbox = ''
-- <SIP/ehtrunknew-00000036>AGI Script agi.php completed, returning 0
-- Executing [h@default:2] Hangup("SIP/ehtrunknew-00000036", "") in new stack
== Spawn extension (default, h, 2) exited non-zero on 'SIP/ehtrunknew-00000036'