Please HELP - Almost 99% working

[koalatelecom]

Hello,

I can login and use vicidial and astguiclient well to make calls.

The problem is in queuing the calls.

If I have available agents in vicidial (not on a call) and someone calls the agi-VDADcloser_inboundCID.agi script then the call will go through fine.

However if all agents are on a call, it places the customer on hold as normal, however when an agent completes a call and becomes " READY " they do not get any calls. The customer just waits on hold.

The AGI is -
exten => 0290372002,3,AGI(agi-VDADcloser_inboundCID.agi,TECHRES-----0871232148-----${CALLERID}-----park-----LIVE-----101-----1)

I have no entries in live_inbound not sure if I am supposed to.

Here is what my screen looks like when there is one agent, however the other call is not in the queue in the below sample.

VICIDIAL: Agents Time On Calls 2006-08-16 14:01:59 REPORTS

+------------|--------+-----------+---------------------+--------+----------+---------+--------------+--------+
| STATION | USER | SESSIONID | CHANNEL | STATUS | CALLTIME | MINUTES | CAMPAIGN | FRONT |
+------------|--------+-----------+---------------------+--------+----------+---------+--------------+--------+
| SIP/1002 | 1002 | 8600052 | SIP/5060-b770e808 | INCALL | 13:34:51 | 27:08 | TECHRES | |
| SIP/1005 | 1005 | 8600051 | | READY | - WAIT - | 7:09 | | |
+------------|--------+-----------+---------------------+--------+----------+---------+--------------+--------+
2 agents logged in on server 203.122.248.64

----------------------------------------------------------------------------------------

VICIDIAL: Time On VDAD 2006-08-16 14:01:59

+---------------------+--------+--------------+--------------------+----------+---------+
| CHANNEL | STATUS | CAMPAIGN | PHONE NUMBER | CALLTIME | MINUTES |
+---------------------+--------+--------------+--------------------+----------+---------+
| SIP/5060-b770e808 | CLOSER | TECHRES | 10881278104 | 13:34:50 | 27:09 |
+---------------------+--------+--------------+--------------------+----------+---------+
1 calls being placed on server 203.122.248.64

- LIVE CALL WAITING

[mflorell]

live_inbound is for the astguiclient.php app, not vicidial so it should remain empty.

As for your issue, please post the Real Asterisk CLI output when you have a call that is still waiting after an agent becomes READY.

Also, post the contents of the vicidial_auto_calls table and the vicidial_live_agents table at this time.

[koalatelecom]

THIS IS THE ASTERISK OUTPUT

<b>Still no luck, I would love ANY help.</b>
It only does not work when a call goes into a queue system, it never arrives at the agent irrespective of how many agents later become available.

----+------------+--------------+---------------------+-----------+
| auto_call_id | server_ip | campaign_id | status | lead_id | uniqueid | callerid | channel | phone_code | phone_number | call_time | call_type |
+--------------+----------------+-------------+--------+---------+--------------------+----------------------+-------------------+------------+--------------+---------------------+-----------+
| 115 | 203.122.248.64 | CL_TECH | LIVE | 137 | 1156403621.5699999 | Y0824164342000000137 | SIP/5060-091e5ac8 | 1 | 0881278104 | 2006-08-24 16:43:42 | IN |
+--------------+----------------+-------------+--------+---------+--------------------+----------------------+---------------


+---------------+------+----------------+------------+-----------+--------+---------+-------------+-----------+----------+---------+-----------+---------------------+---------------------+---------------------+--------------------+----------------+------------+
| live_agent_id | user | server_ip | conf_exten | extension | status | lead_id | campaign_id | uniqueid | callerid | channel | random_id | last_call_time | last_update_time | last_call_finish | closer_campaigns | call_server_ip | user_level |
+---------------+------+----------------+------------+-----------+--------+---------+-------------+-----------+----------+---------+-----------+---------------------+---------------------+---------------------+--------------------+----------------+------------+
| 34 | 1010 | 203.122.248.64 | 8600051 | SIP/1010 | CLOSER | 0 | CLOSER | 0.0000000 | | | 11346395 | 2006-08-24 16:39:00 | 2006-08-24 16:45:15 | 2006-08-24 16:39:00 | CL_TECH TECHRES - | NULL | 8 |
+---------------+------+----------------+------------+-----------+--------+---------+-------------+-----------+----------+---------+-----------+---------------------+---------------------+---------------------+--------------------+----------------+------------+


-- Executing Answer("SIP/5060-091e5ac8", "") in new stack
-- Executing Wait("SIP/5060-091e5ac8", "1") in new stack
-- Executing AGI("SIP/5060-091e5ac8", "call_logCID.agi|0290372002-----"0881278104" <0881278104>-----0881278104-----0881278104") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/call_logCID.agi
+++++ CALL LOG START : |1156403621.57|SIP/5060-091e5ac8|0290372002|SIP|0881278104|2006-08-24 16:43:42
-- AGI Script call_logCID.agi completed, returning 0
-- Executing AGI("SIP/5060-091e5ac8", "agi-VDADcloser_inboundCID.agi|CL_TECH-----7275555134-----Closer-----park----------101-----1") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDADcloser_inboundCID.agi
Perl Environment Dump:
0|CL_TECH-----7275555134-----Closer-----park----------101-----1|
AGI Environment Dump:
-- accountcode =
-- callerid = 0881278104
-- calleridname = 0881278104
-- callingani2 = 0
-- callingpres = 0
-- callingtns = 0
-- callington = 0
-- channel = SIP/5060-091e5ac8
-- context = koala-ext-did
-- dnid = 0290372002
-- enhanced = 0.0
-- extension = 0290372002
-- language = en
-- priority = 4
-- rdnis = unknown
-- request = agi-VDADcloser_inboundCID.agi
-- type = SIP
-- uniqueid = 1156403621.57

INBOUND CALL VDCL STARTED
+++++ INBOUND CALL VDCL STARTED : |1156403621.57|CL_TECH|SIP/5060-091e5ac8|0290372002|SIP|0881278104-7275555134|2006-08-24 16:43:42
AGI Environment Dump: |1156403621.57|SIP/5060-091e5ac8|0290372002|SIP|0881278104|

INBOUND CALL RECEIVED IN FROM VDCL: 0881278104 SIP/5060-091e5ac8
+++++ INBOUND VDCL START : |1156403621.57|SIP/5060-091e5ac8|0290372002|SIP|2006-08-24 16:43:42

|INSERT INTO vicidial_list
(entry_date,modify_date,status,user,vendor_lead_code,source_id,list_id,called_since_last_reset,phone_code,phone_number,security_phrase,called_count,gmt_offset_now,comments) values('2006-08-24 16:43:42','20060824164342','INBND','7275555134','CL_TECH','VDCL','101','Y','1','0881278104','CL_TECH','1','-5.00','0881278104');|137|
FAIL (unexpected result '')
callerID changed: Y0824164342000000137

|INSERT INTO vicidial_auto_calls values('','203.122.248.64','CL_TECH','LIVE','137','1156403621.57','Y0824164342000000137','SIP/5060-091e5ac8','1','0881278104','2006-08-24 16:43:42','IN')|

|INSERT INTO vicidial_closer_log (lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('137','CL_TECH','2006-08-24 16:43:42','1156403622','QUEUE','1','0881278104','VDCL','N')|
-- VDCL : |137|insert to vicidial_closer_log


|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='203.122.248.64' and campaign_id = 'CL_TECH' and call_time < "2006-08-24 16:43:42" and lead_id != '137';|
-- VDAD get agent: |360|0|0|update of vla table: CL_TECH|203.122.248.64
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='137',uniqueid='1156403621.57', channel='SIP/5060-091e5ac8', callerid='Y0824164342000000137' where status IN('CLOSER','READY') and server_ip='203.122.248.64' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% CL_TECH %" and last_update_time > '19700101092955' order by random_id limit 1;|


|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='203.122.248.64' and campaign_id = 'CL_TECH' and call_time < "2006-08-24 16:43:42" and lead_id != '137';|
-- VDAD get agent: |360|1|0|update of vla table: CL_TECH|203.122.248.64
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='137',uniqueid='1156403621.57', channel='SIP/5060-091e5ac8', callerid='Y0824164342000000137' where status IN('CLOSER','READY') and server_ip='203.122.248.64' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% CL_TECH %" and last_update_time > '19700101092955' order by random_id limit 1;|


|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='203.122.248.64' and campaign_id = 'CL_TECH' and call_time < "2006-08-24 16:43:42" and lead_id != '137';|
-- VDAD get agent: |360|2|0|update of vla table: CL_TECH|203.122.248.64
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='137',uniqueid='1156403621.57', channel='SIP/5060-091e5ac8', callerid='Y0824164342000000137' where status IN('CLOSER','READY') and server_ip='203.122.248.64' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% CL_TECH %" and last_update_time > '19700101092955' order by random_id limit 1;|


|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='203.122.248.64' and campaign_id = 'CL_TECH' and call_time < "2006-08-24 16:43:42" and lead_id != '137';|
-- VDAD get agent: |360|3|0|update of vla table: CL_TECH|203.122.248.64
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='137',uniqueid='1156403621.57', channel='SIP/5060-091e5ac8', callerid='Y0824164342000000137' where status IN('CLOSER','READY') and server_ip='203.122.248.64' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% CL_TECH %" and last_update_time > '19700101092955' order by random_id limit 1;|


|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='203.122.248.64' and campaign_id = 'CL_TECH' and call_time < "2006-08-24 16:43:42" and lead_id != '137';|
-- VDAD get agent: |360|4|0|update of vla table: CL_TECH|203.122.248.64
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='137',uniqueid='1156403621.57', channel='SIP/5060-091e5ac8', callerid='Y0824164342000000137' where status IN('CLOSER','READY') and server_ip='203.122.248.64' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% CL_TECH %" and last_update_time > '19700101092955' order by random_id limit 1;|


|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='203.122.248.64' and campaign_id = 'CL_TECH' and call_time < "2006-08-24 16:43:42" and lead_id != '137';|
-- VDAD get agent: |360|5|0|update of vla table: CL_TECH|203.122.248.64
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='137',uniqueid='1156403621.57', channel='SIP/5060-091e5ac8', callerid='Y0824164342000000137' where status IN('CLOSER','READY') and server_ip='203.122.248.64' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% CL_TECH %" and last_update_time > '19700101092955' order by random_id limit 1;|


|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='203.122.248.64' and campaign_id = 'CL_TECH' and call_time < "2006-08-24 16:43:42" and lead_id != '137';|
-- VDAD get agent: |360|6|0|update of vla table: CL_TECH|203.122.248.64
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='137',uniqueid='1156403621.57', channel='SIP/5060-091e5ac8', callerid='Y0824164342000000137' where status IN('CLOSER','READY') and server_ip='203.122.248.64' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% CL_TECH %" and last_update_time > '19700101092955' order by random_id limit 1;|


|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='203.122.248.64' and campaign_id = 'CL_TECH' and call_time < "2006-08-24 16:43:42" and lead_id != '137';|
-- VDAD get agent: |360|7|0|update of vla table: CL_TECH|203.122.248.64
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='137',uniqueid='1156403621.57', channel='SIP/5060-091e5ac8', callerid='Y0824164342000000137' where status IN('CLOSER','READY') and server_ip='203.122.248.64' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% CL_TECH %" and last_update_time > '19700101092955' order by random_id limit 1;|


|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='203.122.248.64' and campaign_id = 'CL_TECH' and call_time < "2006-08-24 16:43:42" and lead_id != '137';|
-- VDAD get agent: |360|8|0|update of vla table: CL_TECH|203.122.248.64
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='137',uniqueid='1156403621.57', channel='SIP/5060-091e5ac8', callerid='Y0824164342000000137' where status IN('CLOSER','READY') and server_ip='203.122.248.64' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% CL_TECH %" and last_update_time > '19700101092955' order by random_id limit 1;|


|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='203.122.248.64' and campaign_id = 'CL_TECH' and call_time < "2006-08-24 16:43:42" and lead_id != '137';|
-- VDAD get agent: |360|9|0|update of vla table: CL_TECH|203.122.248.64
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='137',uniqueid='1156403621.57', channel='SIP/5060-091e5ac8', callerid='Y0824164342000000137' where status IN('CLOSER','READY') and server_ip='203.122.248.64' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% CL_TECH %" and last_update_time > '19700101092955' order by random_id limit 1;|
== Parsing '/etc/asterisk/manager.conf': Found
== Parsing '/etc/asterisk/manager_custom.conf': Found
== Manager 'sendcron' logged on from 203.122.248.64
== Parsing '/etc/asterisk/manager.conf': Found
== Parsing '/etc/asterisk/manager_custom.conf': Found
== Manager 'sendcron' logged on from 203.122.248.64
== Manager 'sendcron' logged off from 203.122.248.64
== Manager 'sendcron' logged off from 203.122.248.64

[mflorell]

I have tested MySQL 5.0.X but the only thing I can think of is that it may not like the date formatted as 19700101092955 for the last_update field although this wasn't a problem in my tests.

Try running the UPDATE query manually in your mysql command-line and see if changing things gets it to find your vicidial_live_agents record for the agent that is logged in.

[cervajs]

Hello,

I can login and use vicidial and astguiclient well to make calls.

The problem is in queuing the calls.

If I have available agents in vicidial (not on a call) and someone calls the agi-VDADcloser_inboundCID.agi script then the call will go through fine.

However if all agents are on a call, it places the customer on hold as normal, however when an agent completes a call and becomes " READY " they do not get any calls. The customer just waits on hold.

i have exactly same problem
centos4/asterisk1.2.11/mysql 4.1

[mflorell]

Can you post Asterisk CLI output?

Have you tried the new 2.0.1b1 release?