by chander.prakash » Tue May 29, 2007 3:34 pm
agi output (last 200 lines):
2007-05-29 15:47:30|VD_hangup.agi||SELECT lead_id,callerid FROM vicidial_auto_calls where uniqueid = '1180468022.360' limit 1;|
2007-05-29 15:47:30|VD_hangup.agi|-- VDAC record deleted: |1| |618857|1180468022.360|V0529154701000618857|192.168.1.210
2007-05-29 15:47:30|VD_hangup.agi||SELECT start_epoch,status FROM vicidial_log where uniqueid='1180468022.360' and lead_id='618857' limit 1;|
2007-05-29 15:47:30|VD_hangup.agi|no VDL record found: 1180468022.360 V0529154701000618857 618857 1180468022.360
2007-05-29 15:47:30|VD_hangup.agi||SELECT start_epoch,status,closecallid FROM vicidial_closer_log where lead_id = '618857' and call_date > "2007-05-29 09:47:30" order by call_date desc limit 1;|
2007-05-29 15:47:30|VD_hangup.agi|no VDL or VDCL record found: 1180468022.360 V0529154701000618857 618857 1180468022.360
2007-05-29 15:47:31|call_log.agi|Perl Environment Dump:
2007-05-29 15:47:31|call_log.agi|0|8367
2007-05-29 15:47:31|call_log.agi|AGI Environment Dump:
2007-05-29 15:47:31|call_log.agi| -- accountcode =
2007-05-29 15:47:31|call_log.agi| -- callerid = unknown
2007-05-29 15:47:31|call_log.agi| -- calleridname = V0529154707000821518
2007-05-29 15:47:31|call_log.agi| -- callingani2 = 0
2007-05-29 15:47:31|call_log.agi| -- callingpres = 0
2007-05-29 15:47:31|call_log.agi| -- callingtns = 0
2007-05-29 15:47:31|call_log.agi| -- callington = 0
2007-05-29 15:47:31|call_log.agi| -- channel = Local/912085233859@default-1556,1
2007-05-29 15:47:31|call_log.agi| -- context = default
2007-05-29 15:47:31|call_log.agi| -- dnid = unknown
2007-05-29 15:47:31|call_log.agi| -- enhanced = 0.0
2007-05-29 15:47:31|call_log.agi| -- extension = 8367
2007-05-29 15:47:31|call_log.agi| -- language = en
2007-05-29 15:47:31|call_log.agi| -- priority = 1
2007-05-29 15:47:31|call_log.agi| -- rdnis = unknown
2007-05-29 15:47:31|call_log.agi| -- request = call_log.agi
2007-05-29 15:47:31|call_log.agi| -- type = Local
2007-05-29 15:47:31|call_log.agi| -- uniqueid = 1180468027.375
2007-05-29 15:47:31|call_log.agi|AGI Variables: |1180468027.375|Local/912085233859@default-1556,1|8367|Local|V0529154707000821518|
2007-05-29 15:47:31|call_log.agi|+++++ CALL LOG START : 2007-05-29 15:47:31
2007-05-29 15:47:31|call_log.agi||INSERT INTO call_log (uniqueid,channel,channel_group,type,server_ip,extension,number_dialed,start_time,start_epoch,end_time,end_epoch,length_in_sec,length_in_min,caller_code) values('1180468027.375','Local/912085233859@default-1556,1','','Local','192.168.1.210','8367','','2007-05-29 15:47:31','1180468051','','','','','V0529154707000821518')|
2007-05-29 15:47:31|call_log.agi|AGI Environment Dump:
2007-05-29 15:47:31|call_log.agi| -- accountcode =
2007-05-29 15:47:31|call_log.agi| -- callerid = unknown
2007-05-29 15:47:31|call_log.agi| -- calleridname = V0529154707000821518
2007-05-29 15:47:31|call_log.agi| -- callingani2 = 0
2007-05-29 15:47:31|call_log.agi| -- callingpres = 0
2007-05-29 15:47:31|call_log.agi| -- callingtns = 0
2007-05-29 15:47:31|call_log.agi| -- callington = 0
2007-05-29 15:47:31|call_log.agi| -- channel = Local/912085233859@default-1556,2
2007-05-29 15:47:31|call_log.agi| -- context = default
2007-05-29 15:47:31|call_log.agi| -- dnid = unknown
2007-05-29 15:47:31|call_log.agi| -- enhanced = 0.0
2007-05-29 15:47:31|call_log.agi| -- extension = h
2007-05-29 15:47:31|call_log.agi| -- language = en
2007-05-29 15:47:31|call_log.agi| -- priority = 1
2007-05-29 15:47:31|call_log.agi| -- rdnis = unknown
2007-05-29 15:47:31|call_log.agi| -- request = call_log.agi
2007-05-29 15:47:31|call_log.agi| -- type = Local
2007-05-29 15:47:31|call_log.agi| -- uniqueid = 1180468027.376
2007-05-29 15:47:31|call_log.agi|AGI Variables: |1180468027.376|Local/912085233859@default-1556,2|h|Local|V0529154707000821518|
2007-05-29 15:47:31|call_log.agi||CALL HUNG UP|
2007-05-29 15:47:31|call_log.agi||1180468027.3759999|1180468027|
2007-05-29 15:47:31|call_log.agi|QUERY done: start time = 1180468027 | sec: 24 | min: 0.40 |
2007-05-29 15:47:31|call_log.agi||UPDATE call_log set end_time='2007-05-29 15:47:31',end_epoch='1180468051',length_in_sec=24,length_in_min=' 0.40' where uniqueid='1180468027.376'|
2007-05-29 15:47:31|call_log.agi||DELETE from live_inbound where uniqueid='1180468027.376' and server_ip='192.168.1.210'|
2007-05-29 15:47:31|call_log.agi|+++++ CALL LOG HUNGUP: |1180468027.376|Local/912085233859@default-1556,2|h|2007-05-29 15:47:31|min: 0.40|
2007-05-29 15:47:31|VD_hangup.agi|AGI Environment Dump:
2007-05-29 15:47:31|VD_hangup.agi| -- accountcode =
2007-05-29 15:47:31|VD_hangup.agi| -- callerid = unknown
2007-05-29 15:47:31|VD_hangup.agi| -- calleridname = V0529154707000821518
2007-05-29 15:47:31|VD_hangup.agi| -- callingani2 = 0
2007-05-29 15:47:31|VD_hangup.agi| -- callingpres = 0
2007-05-29 15:47:31|VD_hangup.agi| -- callingtns = 0
2007-05-29 15:47:31|VD_hangup.agi| -- callington = 0
2007-05-29 15:47:31|VD_hangup.agi| -- channel = Local/912085233859@default-1556,2
2007-05-29 15:47:31|VD_hangup.agi| -- context = default
2007-05-29 15:47:31|VD_hangup.agi| -- dnid = unknown
2007-05-29 15:47:31|VD_hangup.agi| -- enhanced = 0.0
2007-05-29 15:47:31|VD_hangup.agi| -- extension = h
2007-05-29 15:47:31|VD_hangup.agi| -- language = en
2007-05-29 15:47:31|VD_hangup.agi| -- priority = 2
2007-05-29 15:47:31|VD_hangup.agi| -- rdnis = unknown
2007-05-29 15:47:31|VD_hangup.agi| -- request = VD_hangup.agi
2007-05-29 15:47:31|VD_hangup.agi| -- type = Local
2007-05-29 15:47:31|VD_hangup.agi| -- uniqueid = 1180468027.376
2007-05-29 15:47:31|VD_hangup.agi|AGI Variables: |1180468027.376|Local/912085233859@default-1556,2|h|Local|V0529154707000821518|
2007-05-29 15:47:31|VD_hangup.agi|DEBUG:
2007-05-29 15:47:31|VD_hangup.agi|VD_hangup : V0529154707000821518 Local/912085233859@default-1556,2 2 821518
2007-05-29 15:47:31|VD_hangup.agi|-- VDhangup Local DEBUG: ||V0529154707000821518|||
2007-05-29 15:47:31|VD_hangup.agi|+++++ VDAD START LOCAL CHANNEL: EXITING- 2
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi|Perl Environment Dump:
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi|0|8367
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi|callerID changed: V0529154707000821518
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi|AGI Environment Dump:
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- accountcode =
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- callerid = unknown
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- calleridname = V0529154707000821518
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- callingani2 = 0
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- callingpres = 0
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- callingtns = 0
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- callington = 0
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- channel = IAX2/66.150.120.9:4569-29
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- context = default
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- dnid = unknown
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- enhanced = 0.0
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- extension = 8367
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- language = en
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- priority = 2
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- rdnis = unknown
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- request = agi-VDAD_LO_transfer.agi
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- type = IAX2
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi| -- uniqueid = 1180468027.375
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi|AGI Variables: |1180468027.375|IAX2/66.150.120.9:4569-29|8367|IAX2|V0529154707000821518|V0529154707000821518|2|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi|+++++ VDAD START : |821518|2007-05-29 15:47:31|1.2.18|2|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi||SELECT count(*) FROM vicidial_live_agents where callerid='V0529154707000821518';|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi||SELECT count(*) FROM vicidial_auto_calls where callerid='V0529154707000821518' and status IN('LIVE','XFER');|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi|-- VDAD : |1|update of vac table: V0529154707000821518
|UPDATE vicidial_auto_calls set uniqueid='1180468027.375', channel='IAX2/66.150.120.9:4569-29',status='LIVE',stage='LIVE-0' where callerid='V0529154707000821518' order by call_time desc limit 1;|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi||INSERT INTO vicidial_log (uniqueid,lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('1180468027.375','821518','1006','2007-05-29 15:47:31','1180468051','QUEUE','1','2085233859','VDAD','N')|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi|-- VDAD : |821518|821518|insert to vicidial_log: 1180468027.375
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.1.210' and campaign_id = '1006' and call_time < "2007-05-29 15:47:07" and lead_id != '821518';|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi||SELECT count(*) FROM vicidial_live_agents where server_ip='192.168.1.210' and campaign_id = '1006' and last_update_time > '20070529154726';|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (0)|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi|-- VDAD get agent: |0E0|update of vla table: 1006|192.168.1.210
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='821518',uniqueid='1180468027.375', channel='IAX2/66.150.120.9:4569-29', call_server_ip='192.168.1.210', callerid='V0529154707000821518' where status = 'READY' and server_ip='192.168.1.210' and campaign_id='1006' and last_update_time > '20070529154726' order by last_call_finish limit 1;|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi|NNNNNNNNNN No agent record found!!!
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip!='192.168.1.210' and campaign_id = '1006' and call_time < "2007-05-29 15:47:07" and lead_id != '821518';|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi||SELECT count(*) FROM vicidial_live_agents where server_ip!='192.168.1.210' and campaign_id = '1006' and last_update_time > '20070529154726';|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi||CONCURRENT TRANSFERS AUTO SETTING: 4 (27)|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi|-- VDAD get agent: |1|update of vla table: 1006|192.168.1.210
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='821518',uniqueid='1180468027.375', channel='IAX2/66.150.120.9:4569-29', call_server_ip='192.168.1.210', callerid='V0529154707000821518' where status = 'READY' and server_ip!='192.168.1.210' and campaign_id='1006' and last_update_time > '20070529154726' order by last_call_finish limit 1;|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi||SELECT conf_exten,user,extension,server_ip FROM vicidial_live_agents where status IN('QUEUE','INCALL') and server_ip!='192.168.1.210' and campaign_id='1006' and callerid='V0529154707000821518' and channel='IAX2/66.150.120.9:4569-29' order by last_call_time limit 1;|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi|-- VDAD XFER REMOTE: |1|update of vac table: V0529154707000821518
|UPDATE vicidial_auto_calls set status='XFER', stage='XFER-0' where callerid='V0529154707000821518';|
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi|exiting the VDAD app, transferring call to 192*168*001*198*8600070
2007-05-29 15:47:31|agi-VDAD_LO_transfer.agi|XXXXXXXXXX VDAD transferred: start|stop 2007-05-29 15:47:31|2007-05-29 15:47:31
2007-05-29 15:47:31|call_log.agi|Perl Environment Dump:
2007-05-29 15:47:31|call_log.agi|0|192*168*001*198*8600070
2007-05-29 15:47:31|call_log.agi|AGI Environment Dump:
2007-05-29 15:47:31|call_log.agi| -- accountcode =
2007-05-29 15:47:31|call_log.agi| -- callerid = unknown
2007-05-29 15:47:31|call_log.agi| -- calleridname = V0529154707000821518
2007-05-29 15:47:31|call_log.agi| -- callingani2 = 0
2007-05-29 15:47:31|call_log.agi| -- callingpres = 0
2007-05-29 15:47:31|call_log.agi| -- callingtns = 0
2007-05-29 15:47:31|call_log.agi| -- callington = 0
2007-05-29 15:47:31|call_log.agi| -- channel = IAX2/66.150.120.9:4569-29
2007-05-29 15:47:31|call_log.agi| -- context = default
2007-05-29 15:47:31|call_log.agi| -- dnid = unknown
2007-05-29 15:47:31|call_log.agi| -- enhanced = 0.0
2007-05-29 15:47:31|call_log.agi| -- extension = 192*168*001*198*8600070
2007-05-29 15:47:31|call_log.agi| -- language = en
2007-05-29 15:47:31|call_log.agi| -- priority = 1
2007-05-29 15:47:31|call_log.agi| -- rdnis = unknown
2007-05-29 15:47:31|call_log.agi| -- request = call_log.agi
2007-05-29 15:47:31|call_log.agi| -- type = IAX2
2007-05-29 15:47:31|call_log.agi| -- uniqueid = 1180468027.375
2007-05-29 15:47:31|call_log.agi|AGI Variables: |1180468027.375|IAX2/66.150.120.9:4569-29|192*168*001*198*8600070|IAX2|V0529154707000821518|
2007-05-29 15:47:31|call_log.agi|+++++ CALL LOG START : 2007-05-29 15:47:31
2007-05-29 15:47:31|call_log.agi||INSERT INTO call_log (uniqueid,channel,channel_group,type,server_ip,extension,number_dialed,start_time,start_epoch,end_time,end_epoch,length_in_sec,length_in_min,caller_code) values('1180468027.375','IAX2/66.150.120.9:4569-29','','IAX2','192.168.1.210','66.150.120.9:4569-29','192*168*001*198*8600070','2007-05-29 15:47:31','1180468051','','','','','V0529154707000821518')|
2007-05-29 15:47:37|call_log.agi|AGI Environment Dump:
2007-05-29 15:47:37|call_log.agi| -- accountcode =
2007-05-29 15:47:37|call_log.agi| -- callerid = unknown
2007-05-29 15:47:37|call_log.agi| -- calleridname = V0529154707000821518
2007-05-29 15:47:37|call_log.agi| -- callingani2 = 0
2007-05-29 15:47:37|call_log.agi| -- callingpres = 0
2007-05-29 15:47:37|call_log.agi| -- callingtns = 0
2007-05-29 15:47:37|call_log.agi| -- callington = 0
2007-05-29 15:47:37|call_log.agi| -- channel = IAX2/66.150.120.9:4569-29
2007-05-29 15:47:37|call_log.agi| -- context = default
2007-05-29 15:47:37|call_log.agi| -- dnid = unknown
2007-05-29 15:47:37|call_log.agi| -- enhanced = 0.0
2007-05-29 15:47:37|call_log.agi| -- extension = h
2007-05-29 15:47:37|call_log.agi| -- language = en
2007-05-29 15:47:37|call_log.agi| -- priority = 1
2007-05-29 15:47:37|call_log.agi| -- rdnis = unknown
2007-05-29 15:47:37|call_log.agi| -- request = call_log.agi
2007-05-29 15:47:37|call_log.agi| -- type = IAX2
2007-05-29 15:47:37|call_log.agi| -- uniqueid = 1180468027.375
2007-05-29 15:47:37|call_log.agi|AGI Variables: |1180468027.375|IAX2/66.150.120.9:4569-29|h|IAX2|V0529154707000821518|
2007-05-29 15:47:37|call_log.agi||CALL HUNG UP|
2007-05-29 15:47:37|call_log.agi||1180468027.3750000|1180468051|
2007-05-29 15:47:37|call_log.agi|QUERY done: start time = 1180468051 | sec: 6 | min: 0.10 |
2007-05-29 15:47:37|call_log.agi||UPDATE call_log set end_time='2007-05-29 15:47:37',end_epoch='1180468057',length_in_sec=6,length_in_min=' 0.10' where uniqueid='1180468027.375'|
2007-05-29 15:47:37|call_log.agi||DELETE from live_inbound where uniqueid='1180468027.375' and server_ip='192.168.1.210'|
2007-05-29 15:47:37|call_log.agi|+++++ CALL LOG HUNGUP: |1180468027.375|IAX2/66.150.120.9:4569-29|h|2007-05-29 15:47:37|min: 0.10|
2007-05-29 15:47:37|VD_hangup.agi|AGI Environment Dump:
2007-05-29 15:47:37|VD_hangup.agi| -- accountcode =
2007-05-29 15:47:37|VD_hangup.agi| -- callerid = unknown
2007-05-29 15:47:37|VD_hangup.agi| -- calleridname = V0529154707000821518
2007-05-29 15:47:37|VD_hangup.agi| -- callingani2 = 0
2007-05-29 15:47:37|VD_hangup.agi| -- callingpres = 0
2007-05-29 15:47:37|VD_hangup.agi| -- callingtns = 0
2007-05-29 15:47:37|VD_hangup.agi| -- callington = 0
2007-05-29 15:47:37|VD_hangup.agi| -- channel = IAX2/66.150.120.9:4569-29
2007-05-29 15:47:37|VD_hangup.agi| -- context = default
2007-05-29 15:47:37|VD_hangup.agi| -- dnid = unknown
2007-05-29 15:47:37|VD_hangup.agi| -- enhanced = 0.0
2007-05-29 15:47:37|VD_hangup.agi| -- extension = h
2007-05-29 15:47:37|VD_hangup.agi| -- language = en
2007-05-29 15:47:37|VD_hangup.agi| -- priority = 2
2007-05-29 15:47:37|VD_hangup.agi| -- rdnis = unknown
2007-05-29 15:47:37|VD_hangup.agi| -- request = VD_hangup.agi
2007-05-29 15:47:37|VD_hangup.agi| -- type = IAX2
2007-05-29 15:47:37|VD_hangup.agi| -- uniqueid = 1180468027.375
2007-05-29 15:47:37|VD_hangup.agi|AGI Variables: |1180468027.375|IAX2/66.150.120.9:4569-29|h|IAX2|V0529154707000821518|
2007-05-29 15:47:37|VD_hangup.agi|DEBUG:
2007-05-29 15:47:37|VD_hangup.agi|VD_hangup : V0529154707000821518 IAX2/66.150.120.9:4569-29 2 821518
2007-05-29 15:47:37|VD_hangup.agi||SELECT lead_id,callerid FROM vicidial_auto_calls where uniqueid = '1180468027.375' limit 1;|
2007-05-29 15:47:37|VD_hangup.agi|VD hangup: no VDAC record found: 1180468027.375 V0529154707000821518