The previous posts were based on two test machines that I have setup to simulate a client's environment. The following is based on the real production servers that the client is actually using:
SERVER1 (196.37.34.216)
Configuration:
- Fedora Core 2
- MySQL 3.23.58
- Asterisk 1.2.11
- Apache + PHP + VICIDIAL pages
- /etc/astguiclient.conf: VARactive_keepalives => 1234567
- meetme.conf: conf => 8600001 to 8600200
screen -r:
- Code: Select all
32300.ASTVDauto (Detached)
32296.ASTsend (Detached)
32294.ASTupdate (Detached)
32302.ASTVDremote (Detached)
32298.ASTlisten (Detached)
23370.ASTfastlog (Detached)
18796.ASTVDadapt (Detached)
23372.ASTVDautoFILL (Detached)
SERVER2 (196.37.34.218)Configuration:
- Fedore Core 2
- Asterisk 1.2.11
- Apache + PHP + VICIDIAL pages (modified to connect to SERVER1's DB)
- /etc/astguiclient.conf: modified to connect to SERVER1's DB
- /etc/astguiclient.conf: VARactive_keepalives => 12346
- meetme.conf: conf => 8600001 to 8600200
screen -r:
- Code: Select all
32497.ASTupdate (Detached)
32509.ASTVDremote (Detached)
32500.ASTsend (Detached)
32506.ASTVDauto (Detached)
32503.ASTlisten (Detached)
31748.ASTfastlog (Detached)
Database setup
servers:
"server_id","server_description","server_ip","active","asterisk_version","max_vicidial_trunks","telnet_host","telnet_port","ASTmgrUSERNAME", "ASTmgrSECRET","ASTmgrUSERNAMEupdate","ASTmgrUSERNAMElisten","ASTmgrUSERNAMEsend","local_gmt", "voicemail_dump_exten","answer_transfer_agent","ext_context","sys_perf_log","vd_server_logs","agi_output","vicidial_balance_active", "balance_trunks_offlimits"
"mark1","Primary VICIDIAL Server","196.37.34.216","Y","1.2.11",96,"196.37.34.216",5038,"cron","secret","updatecron","listencron","sendcron","-5","85026666666666", "8365","default","N","Y", "BOTH","Y",0
"mark2","Secondary VICIDIAL Server","196.37.34.218","Y","1.2.11",96,"196.37.34.218",5038,"cron","secret","updatecron","listencron","sendcron","-5","85026666666666","8365","default","N","N", "NONE","Y",0
phones:
"extension","dialplan_number","voicemail_id","phone_ip","computer_ip","server_ip","login","pass","status","active","phone_type","fullname","company","picture", "messages","old_messages","protocol","local_gmt","ASTmgrUSERNAME","ASTmgrSECRET", "login_user","login_pass","login_campaign","park_on_extension","conf_on_extension","VICIDIAL_park_on_extension","VICIDIAL_park_on_filename", "monitor_prefix","recording_exten","voicemail_exten","voicemail_dump_exten","ext_context","dtmf_send_extension", "call_out_number_group","client_browser","install_directory","local_web_callerID_URL","VICIDIAL_web_URL","AGI_call_logging_enabled", "user_switching_enabled","conferencing_enabled","admin_hangup_enabled","admin_hijack_enabled","admin_monitor_enabled", "call_parking_enabled","updater_check_enabled","AFLogging_enabled","QUEUE_ACTION_enabled","CallerID_popup_enabled","voicemail_button_enabled", "enable_fast_refresh","fast_refresh_rate","enable_persistant_mysql","auto_dial_next_number", "VDstop_rec_after_each_call","DBX_server","DBX_database","DBX_user","DBX_pass","DBX_port","DBY_server","DBY_database","DBY_user","DBY_pass", "DBY_port","outbound_cid"
"cc02","2002","2002","","","196.37.34.218","cc02","1234","ACTIVE","Y","","","","",0,0,"SIP","-5","cron","secret","","","","8301","8302","8301","park","8612", "8309","8501","85026666666666","default","local/8500998@default","Zap/g2/","/usr/bin/mozilla", "/usr/local/perl_TK","http://astguiclient.sf.net/test_callerid_output.php","http://astguiclient.sf.net/test_VICIDIAL_output.php","1","1","1","0","0","0","1","1", "1","1","1","1","0",1000,"0","1","1","196.37.34.216","asterisk","cron","secret",3306,"","asterisk","cron","1234",3306,""
"cc01","2001","2001","","","196.37.34.216","cc01","1234","ACTIVE","Y","","","","",0,0,"SIP","-5","cron","secret","","","","8301","8302","8301","park","8612", "8309","8501","85026666666666","default","local/8500998@default","Zap/g2/","/usr/bin/mozilla", "/usr/local/perl_TK","http://astguiclient.sf.net/test_callerid_output.php","http://astguiclient.sf.net/test_VICIDIAL_output.php","1","1","1","0","0","0","1","1", "1","1","1","1","0",1000,"0","1","1","196.37.34.216","asterisk","cron","secret",3306,"","asterisk","cron","1234",3306,"2001"
(I will add more phones later, when I get this to work)
campaigns:
"campaign_id","campaign_name","active","dial_status_a","dial_status_b","dial_status_c","dial_status_d","dial_status_e","lead_order","park_ext", "park_file_name","web_form_address","allow_closers","hopper_level","auto_dial_level","next_agent_call","local_call_time", "voicemail_ext","dial_timeout","dial_prefix","campaign_cid","campaign_vdad_exten","campaign_rec_exten","campaign_recording", "campaign_rec_filename","campaign_script","get_call_launch","am_message_exten","amd_send_to_vmx","xferconf_a_dtmf", "xferconf_a_number","xferconf_b_dtmf","xferconf_b_number","alt_number_dialing","scheduled_callbacks","lead_filter_id","drop_call_seconds", "safe_harbor_message","safe_harbor_exten","display_dialable_count","wrapup_seconds","wrapup_message","closer_campaigns", "use_internal_dnc","allcalls_delay","omit_phone_code","dial_method","available_only_ratio_tally","adaptive_dropped_percentage", "adaptive_maximum_level","adaptive_latest_server_time","adaptive_intensity","adaptive_dl_diff_target"
"CLOSER","Inbound Campaign","Y","NEW","","","","","DOWN","","","","Y",1,"1.0","random","24hours","",60,"X","0000000000","8365","8309","ONDEMAND", "FULLDATE_CUSTPHONE","","NONE","","N","","","","","N","N","NONE",5,"N","8307","Y",0,"Wrapup Call"," default -","N",0,"Y","RATIO","N",3,"3.0","2100","0",0
conferences:
"conf_exten","server_ip","extension"
8600001,"196.37.34.216",""
8600002,"196.37.34.216",""
...
8600029,"196.37.34.216",""
8600001,"196.37.34.218",""
8600002,"196.37.34.218",""
...
8600029,"196.37.34.218",""
vicidial_conferences:
"conf_exten","server_ip","extension"
8600051,"196.37.34.216",""
8600052,"196.37.34.216",""
...
8600200,"196.37.34.216",""
8600051,"196.37.34.218",""
8600052,"196.37.34.218",""
...
8600200,"196.37.34.218",""
extensions.conf on SERVER1
[general]
static=yes
writeprotect=no
[globals]
CONSOLE=Console/dsp ; Console interface for demo
TRUNKIAX2=IAX2/Mark2Asterisk:mark2123@196.37.34.216:4569
[default]
; hang up
exten => h,1,DeadAGI(
agi://127.0.0.1:4577/call_log)
exten => h,2,DeadAGI(
agi://127.0.0.1:4577/VD_hangup--HVcause ... EBUG-----${HANGUPCAUSE}-----${DIALSTATUS}-----${DIALEDTIME}-----${ANSWEREDTIME}))
;Outbound calls
exten => _0XXXXXXXXX,1,AGI(
agi://127.0.0.1:4577/call_log)
exten => _0XXXXXXXXX,n,Dial(ZAP/g1/${EXTEN},,otT)
exten => _0XXXXXXXXX,n,Hangup
; quiet monitor extensions for meetme rooms (for room managers)
exten => _68600XXX,1,NoCDR
exten => _68600XXX,n,Meetme,${EXTEN:1}|mq
; quiet entry and leaving conferences for VICIDIAL
exten => _78600XXX,1,NoCDR
exten => _78600XXX,n,Meetme,${EXTEN:1}|q
; barge monitoring extension
exten => 8159,1,NoCDR
exten => 8159,n,ZapBarge
exten => 8159,n,Hangup
; prompt recording AGI script, ID is 4321
exten => 8168,1,NoCDR
exten => 8168,n,Answer
exten => 8168,n,AGI(agi-record_prompts.agi)
exten => 8168,n,Hangup
exten => 8300,1,NoCDR
exten => 8300,n,Hangup
; park channel for client GUI parking, hangup after 30 minutes
; create a GSM formatted audio file named "park.gsm" that is 30 minutes long
; and put it in /var/lib/asterisk/sounds
exten => 8301,1,NoCDR
exten => 8301,n,Answer
exten => 8301,n,AGI(park_CID.agi)
exten => 8301,n,Playback(park)
exten => 8301,n,Hangup
exten => 8303,1,NoCDR
exten => 8303,n,Answer
exten => 8303,n,AGI(park_CID.agi)
exten => 8303,n,Playback(conf)
exten => 8303,n,Hangup
; park channel for client GUI conferencing, hangup after 30 minutes
; create a GSM formatted audio file named "conf.gsm" that is 30 minutes long
; and put it in /var/lib/asterisk/sounds
exten => 8302,1,NoCDR
exten => 8302,n,Answer
exten => 8302,n,Playback(conf)
exten => 8302,n,Hangup
; default audio for safe harbor 2-second-after-hello message then hangup
; create a GSM formatted audio file complies with safe harbor rules
; and put it in /var/lib/asterisk/sounds then change filename below
exten => 8307,1,NoCDR
exten => 8307,n,Answer
exten => 8307,n,Playback(vm-goodbye)
exten => 8307,n,Hangup
; this is used for recording conference calls, the client app sends the filename
; value as a callerID recordings go to /var/spool/asterisk/monitor (WAV)
exten => 8309,1,NoCDR
exten => 8309,n,Answer
exten => 8309,n,Monitor(wav,${CALLERIDNAME})
exten => 8309,n,Wait,1800
exten => 8309,n,Hangup
; this is used for playing a message to an answering machine forwarded from AMD in VICIDIAL
; replace conf with the message file you want to leave
exten => 8320,1,NoCDR
exten => 8320,n,WaitForSilence(2000,2) ; AMD got machine. leave message after recording
exten => 8320,n,Playback(conf)
exten => 8320,n,AGI(VD_amd_post.agi,${EXTEN})
exten => 8320,n,Hangup
; VICIDIAL_auto_dialer transfer script for no-agent campaigns:
exten => 8364,1,NoCDR
exten => 8364,n,Playback(sip-silence)
exten => 8364,n,AGI(
agi://127.0.0.1:4577/call_log)
exten => 8364,n,AGI(agi-VDADtransferBROADCAST.agi,${EXTEN})
exten => 8364,n,AGI(agi-VDADtransferBROADCAST.agi,${EXTEN})
exten => 8364,n,Hangup
; VICIDIAL_auto_dialer transfer script:
exten => 8365,1,NoCDR
exten => 8365,n,Playback(sip-silence)
exten => 8365,n,AGI(
agi://127.0.0.1:4577/call_log)
exten => 8365,n,AGI(agi-VDADtransfer.agi,${EXTEN})
exten => 8365,n,AGI(agi-VDADtransfer.agi,${EXTEN})
exten => 8365,n,Hangup
; VICIDIAL_auto_dialer transfer script SURVEY at beginning:
exten => 8366,1,NoCDR
exten => 8366,n,Playback(sip-silence)
exten => 8366,n,AGI(
agi://127.0.0.1:4577/call_log)
exten => 8366,n,AGI(agi-VDADtransferSURVEY.agi,${EXTEN})
exten => 8366,n,AGI(agi-VDADtransferSURVEY.agi,${EXTEN})
exten => 8366,n,Hangup
; VICIDIAL_auto_dialer transfer script AMD with Load Balanced:
exten => 8369,1,NoCDR
exten => 8369,n,Playback(sip-silence)
exten => 8369,n,AGI(
agi://127.0.0.1:4577/call_log)
exten => 8369,n,AMD(3500|1500|300|5000|120|50|5|256)
exten => 8369,n,AGI(VD_amd.agi,${EXTEN})
exten => 8369,n,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
exten => 8369,n,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
exten => 8369,n,Hangup
; VICIDIAL auto-dial reminder script
exten => 8372,1,NoCDR
exten => 8372,n,Playback(sip-silence)
exten => 8372,n,AGI(
agi://127.0.0.1:4577/call_log)
exten => 8372,n,AGI(agi-VDADautoREMINDER.agi,${EXTEN})
exten => 8372,n,AGI(agi-VDADautoREMINDER.agi,${EXTEN})
exten => 8372,n,Hangup
; Give voicemail at extension 8500
exten => 8500,1,NoCDR
exten => 8500,n,VoicemailMain
exten => 8500,n,Goto(s,6)
; this is used for sending DTMF signals within conference calls, the client app
; sends the digits to be played in the callerID field
; sound files must be placed in /var/lib/asterisk/sounds
exten => 8500998,1,NoCDR
exten => 8500998,n,Answer
exten => 8500998,n,Macro(dtmf|${CALLERID})
; this is used to allow the GUI to send you directly into voicemail
; don't forget to set GUI variable $voicemail_exten to this extension
exten => 8501,1,NoCDR
exten => 8501,n,VoicemailMain(s${CALLERIDNUM})
exten => 8501,n,Hangup
; this is used to allow the GUI to send live calls directly into voicemail
; don't forget to set GUI variable $voicemail_dump_exten to this extension
exten => _85026666666666.,1,NoCDR
exten => _85026666666666.,n,Wait(2)
exten => _85026666666666.,n,Voicemail(${EXTEN:14})
exten => _85026666666666.,n,Hangup
; playback of recorded prompts
exten => _851XXXXX,1,NoCDR
exten => _851XXXXX,n,Answer
exten => _851XXXXX,n,Playback(${EXTEN})
exten => _851XXXXX,n,Hangup
; Extension 8600 + 8601 conference rooms
exten => 8600,1,NoCDR
exten => 8600,n,Meetme,8600
exten => 8601,1,NoCDR
exten => 8601,n,Meetme,8601
exten => _860XXXX,1,NoCDR
exten => _860XXXX,n,Meetme,${EXTEN}|q
; ZapBarge direct channel extensions
exten => _86120XX,1,NoCDR
exten => _86120XX,n,ZapBarge(${EXTEN:5})
exten => _X38600XXX,1,NoCDR
exten => _X38600XXX,n,MeetMeAdmin(${EXTEN:2},t,${EXTEN:0:1})
exten => _X38600XXX,n,Hangup
exten => _X48600XXX,1,NoCDR
exten => _X48600XXX,n,MeetMeAdmin(${EXTEN:2},T,${EXTEN:0:1})
exten => _X48600XXX,n,Hangup
;Load balancing
exten => _010*010*010*016*8600XXX,1,Dial(${TRUNKIAX2}/${EXTEN:16},55,o)
exten => _010*010*010*016*8600XXX,2,Hangup
; VICIDIAL_auto_dialer transfer script Load Balance Overflow:
exten => 8367,1,AGI(call_log.agi,${EXTEN})
exten => 8367,2,AGI(agi-VDAD_LO_transfer.agi,${EXTEN})
exten => 8367,3,AGI(agi-VDAD_LO_transfer.agi,${EXTEN})
exten => 8367,4,AGI(agi-VDAD_LO_transfer.agi,${EXTEN})
exten => 8367,5,Hangup
; VICIDIAL_auto_dialer transfer script Load Balanced:
exten => 8368,1,AGI(call_log.agi,${EXTEN})
exten => 8368,2,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
exten => 8368,3,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
exten => 8368,4,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
exten => 8368,5,Hangup
; parameters for agi-VDAD_LB_closer.agi (2 fields separated by five dashes "-----"):
; 1. the full extension formatted by VICIDIAL for internal transfers * separated
2. the word START to denote the beginning of the acceptance of the transfer
; inbound VICIDIAL transfer calls [INTERNAL TRANSFER]
exten => _90009.,1,Answer ; Answer the line
exten => _90009.,2,AGI(agi-VDAD_LB_closer.agi,${EXTEN}-----START)
exten => _90009.,3,Hangup
; parameters for agi-VDAD_LO_closer.agi (2 fields separated by five dashes "-----"):
; 1. the full extension formatted by VICIDIAL for internal transfers * separated
; 2. the word START to denote the beginning of the acceptance of the transfer
; inbound VICIDIAL transfer calls [LOCAL TRANSFER]
exten => _990009.,1,Answer ; Answer the line
exten => _990009.,2,AGI(agi-VDAD_LO_closer.agi,${EXTEN}-----START)
exten => _990009.,3,Hangup
; inbound VICIDIAL call with prompt for 4-digit fronter code
exten => 1234,1,Answer ; Answer the line
exten => 1234,2,AGI(agi-VDAD_LO_closer_inbound.agi,loadbalance-----${CALLERID(num)}-----${CALLERID(name)}-----park----------999-----00)
exten => 1234,3,Hangup
[inbound]
;Inbound calls transferred to the call center
exten => _17XX,1,Ringing
exten => _17XX,n,Wait(1)
exten => _17XX,n,Answer
exten => _17XX,n,AGI(agi-VDADcloser_inboundCIDlookup.agi,default-----${CALLERID(num)}-----${CALLERID(name)}---------------101-----00)
exten => _17XX,n,Hangup
[macro-dtmf]
;DTMF signal fix
exten => s,1,GosubIf(${LEN(${ARG1})}=0]?10)
exten => s,n,Hangup
exten => s,10,Playback(silence)
exten => s,n,Playback(${ARG1:0:1})
exten => s,n,Macro(dtmf|${ARG1:1})
[marketel1]
;VICIDIAL sessions
exten => _860XXXX,1,Goto(default,${EXTEN},1)
exten => 1777,1,Goto(inbound,1777,1)
extensions.conf on SERVER2
Is very similar, except for the load balancing extensions and IAX trunks
Problems I am experiencing:
1. When an agent logs in, e.g. cc00 on SERVER1, the server does not call the agent back. But when the agent dials the session id, the agent is logged in.
2. Inbound calls are not being transfered to the agents regardless whether it is on the same server or not.
After I (agent) log in:
Both live_channels and live_sip-channels are empty. Also no new entries in the agiout log file.
After I manually dialed the session id on the agent's phone to login:
live_channels:
"channel","server_ip","channel_group","extension","channel_data"
"Zap/pseudo-733310177","196.37.34.216","","ring","SIP/ring"
live_sip_channels:
"channel","server_ip","channel_group","extension","channel_data"
"SIP/cc01-0977cf58","196.37.34.216","","8600051","8600051|q"
agiout log:
Still nothing new.
After a client dials in using a SIP phone
live_channels: Still the same
live_sip_channels:
"channel","server_ip","channel_group","extension","channel_data"
"SIP/cc01-0979add8","196.37.34.216","","agi","agi-VDADcloser_inboundCIDlookup.agi|default-----cc01-----cc01---------------101-----00"
"SIP/cc01-0977cf58","196.37.34.216","","8600051","8600051|q"
agiout log file:
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi|Perl Environment Dump:
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi|0|default-----cc01-----cc01---------------101-----00
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- accountcode =
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- callerid = cc01
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- calleridname = cc01
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- callingani2 = 0
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- callingpres = 0
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- callingtns = 0
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- callington = 0
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- channel = SIP/cc01-0979add8
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- context = inbound
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- dnid = 1777
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- enhanced = 0.0
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- extension = 1777
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- language = en
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- priority = 4
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- rdnis = unknown
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- request = agi-VDADcloser_inboundCIDlookup.agi
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- type = SIP
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi| -- uniqueid = 1176804333.24891
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi|AGI Variables: |1176804333.24891|SIP/cc01-0979add8|1777|SIP|cc01|
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi|+++++ INBOUND CALL VDCL STARTED : |default|cc01-cc01|2007-04-17 12:05:34
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi||SELECT lead_id from vicidial_list where list_id='101' and phone_number='01' order by modify_date limit 1;|1|
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi|callerID changed: Y0417120534000000001
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi||INSERT INTO vicidial_auto_calls (server_ip,campaign_id,status,lead_id,uniqueid,callerid,channel,phone_code,phone_number,call_time,call_type,stage) values('196.37.34.216','default','LIVE','1','1176804333.24891','Y0417120534000000001','SIP/cc01-0979add8','00','01','2007-04-17 12:05:34','IN','LIVE-0')|
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi||INSERT INTO vicidial_closer_log (lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('1','default','2007-04-17 12:05:34','1176804334','QUEUE','00','01','VDCL','N')|
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi|-- VDCL : |1|insert to vicidial_closer_log
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='196.37.34.216' and campaign_id = 'default' and call_time < "2007-04-17 12:05:34" and lead_id != '1';|
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi|-- VDAD get agent: ||default|UPDATE vicidial_live_agents set status='QUEUE',lead_id='1',uniqueid='1176804333.24891', channel='SIP/cc01-0979add8', callerid='Y0417120534000000001' where status IN('CLOSER','READY') and server_ip='196.37.34.216' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% default %" and last_update_time > '19700101015955' order by last_call_finish limit 1;|
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi|NNNNN No available agent found
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='196.37.34.216' and campaign_id = 'default' and call_time < "2007-04-17 12:05:34" and lead_id != '1';|
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi|-- VDAD get agent: ||default|UPDATE vicidial_live_agents set status='QUEUE',lead_id='1',uniqueid='1176804333.24891', channel='SIP/cc01-0979add8', callerid='Y0417120534000000001' where status IN('CLOSER','READY') and server_ip='196.37.34.216' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% default %" and last_update_time > '19700101015955' order by last_call_finish limit 1;|
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi|NNNNN No available agent found
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='196.37.34.216' and campaign_id = 'default' and call_time < "2007-04-17 12:05:34" and lead_id != '1';|
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi|-- VDAD get agent: ||default|UPDATE vicidial_live_agents set status='QUEUE',lead_id='1',uniqueid='1176804333.24891', channel='SIP/cc01-0979add8', callerid='Y0417120534000000001' where status IN('CLOSER','READY') and server_ip='196.37.34.216' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% default %" and last_update_time > '19700101015955' order by last_call_finish limit 1;|
2007-04-17 12:05:34|agi-VDADcloser_inboundCIDlookup.agi|NNNNN No available agent found
...
The last few statements keeps on repeating for some time.