AST_VDauto_dial.pl

[roche]

Hello,

I have the following problem with AST_VDauto_dial.pl script.

It suddently stop to work when I ran it manually this is the outcome

TIME DEBUG: ||0| GMT: 08:55
2006-07-26 08:55:47|PROGRAM STARTED|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2006-07-26 08:55:47|LOGGED INTO MYSQL SERVER ON 1 CONNECTION||
TIME DEBUG: -6|-6|0| GMT: 14:55
2006-07-26 08:55:47|LIVE AGENTS LOGGED IN: 0 |
2006-07-26 08:55:47|HLPA 10.10.61.17: agents: 0 dial_level: 0|
2006-07-26 08:55:47|HLPA 10.10.61.17: Calls to place: 0 (0- 0) |

mysql> select count(*) from vicidial_live_agents;
+----------+
| count(*) |
+----------+
| 5 |
+----------+
1 row in set (0.00 sec)


select auto_dial_level from vicidial_campaigns where campaign_id='HLPA';
+-----------------+
| auto_dial_level |
+-----------------+
| 3.0 |
+-----------------+
1 row in set (0.00 sec)


Well I tryed to trace the problem in the source code but I am not a Perl Fan .

These is part of the code that I saw is having the problems.

The second While was never executed .

but I really don't know Why? Any help

I had to reboot and everithing is working again :S

$dbhA->query("SELECT user,server_ip,campaign_id,conf_exten FROM vicidial_live_agents where status IN('READY','QUEUE','INCALL','DONE') and server_ip='$server_ip' and last_update_time > '$BDtsSQLdate' order by last_call_time");
if ($dbhA->has_selected_record)
{
$iter=$dbhA->create_record_iterator;
while ( $record = $iter->each)
{
$DBlive_user[$user_counter] = "$record->[0]";
$DBlive_server_ip[$user_counter] = "$record->[1]";
$DBlive_campaign[$user_counter] = "$record->[2]";
$DBlive_conf_exten[$user_counter] = "$record->[3]";

if ($user_campaigns !~ /\|$DBlive_campaign[$user_counter]\|/i)
{
$user_campaigns .= "$DBlive_campaign[$user_counter]|";
$DBcampaigns[$user_campaigns_counter] = $DBlive_campaign[$user_counter];
$user_campaigns_counter++;
}
if ($user_campaignIP !~ /\|$DBlive_campaign[$user_counter]__$DBlive_server_ip[$user_counter]\|/i)
{
$user_campaignIP .= "$DBlive_campaign[$user_counter]__$DBlive_server_ip[$user_counter]|";
$DBIPcampaign[$user_CIPct] = "$DBlive_campaign[$user_counter]";
$DBIPaddress[$user_CIPct] = "$DBlive_server_ip[$user_counter]";
$user_CIPct++;
}
$user_counter++;
}
}

$event_string="LIVE AGENTS LOGGED IN: $user_counter";

[mflorell]

The number of records in your vicidial_live_agents table doesn't really mean much. It's the number of status READY agents that matters. What is the status of your agents?

Do you have more than one server in your installation? If so are they all time syncd to the same time server with ntp?

[roche]

The number of records in your vicidial_live_agents table doesn't really mean much. It's the number of status READY agents that matters. What is the status of your agents?

Do you have more than one server in your installation? If so are they all time syncd to the same time server with ntp?

Yes I have two servers:

The First with Asterisk, Apache and Vicidial
The other with Mysql

The agents had status ready in that moment, RT report show all agents ready and waiting for calls

both server are sync with ntp. I checked that.

[mflorell]

Please post the results of these queries at the same time:

SELECT * from vicidial_live_agents;
SELECT * from server_updater;
SELECT * from vicidial_auto_calls;

[roche]

Please post the results of these queries at the same time:

SELECT * from vicidial_live_agents;
SELECT * from server_updater;
SELECT * from vicidial_auto_calls;

Well right now the server is working because of reboot, Problably will be helpfull when the issue will happend again.

mysql> SELECT * from vicidial_live_agents;
+---------------+-------+-------------+------------+-----------+--------+---------+-------------+--------------------+----------------------+-------------------+-----------+---------------------+---------------------+---------------------+------------------+----------------+------------+
| 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 |
+---------------+-------+-------------+------------+-----------+--------+---------+-------------+--------------------+----------------------+-------------------+-----------+---------------------+---------------------+---------------------+------------------+----------------+------------+
| 3222 | 10014 | 10.10.61.17 | 8600053 | SIP/2002 | PAUSED | 0 | HLPA | 0.0000000 | | | 17409715 | 2006-07-26 09:17:05 | 2006-07-26 09:31:45 | 2006-07-26 09:29:19 | | | 4 |
| 3223 | 10048 | 10.10.61.17 | 8600054 | SIP/2004 | READY | 0 | HLPA | 0.0000000 | | | 13599694 | 2006-07-26 09:31:13 | 2006-07-26 09:31:45 | 2006-07-26 09:31:35 | | | 3 |
| 3228 | 10022 | 10.10.61.17 | 8600051 | SIP/2006 | INCALL | 213506 | HLPA | 1153927845.4147999 | V0726093044000213506 | IAX2/binfone00-12 | 12094015 | 2006-07-26 09:31:01 | 2006-07-26 09:31:46 | 2006-07-26 09:30:55 | | 10.10.61.17 | 5 |
| 3225 | 10015 | 10.10.61.17 | 8600052 | SIP/2016 | INCALL | 213515 | HLPA | 1153927871.4175000 | V0726093111000213515 | IAX2/binfone00-18 | 13667690 | 2006-07-26 09:31:24 | 2006-07-26 09:31:45 | 2006-07-26 09:31:18 | | 10.10.61.17 | 4 |
| 3227 | 10000 | 10.10.61.17 | 8600055 | SIP/2003 | PAUSED | 0 | HLPA | 0.0000000 | | | 17270392 | 2006-07-26 09:25:09 | 2006-07-26 09:31:46 | 2006-07-26 09:30:59 | | | 7 |
+---------------+-------+-------------+------------+-----------+--------+---------+-------------+--------------------+----------------------+-------------------+-----------+---------------------+---------------------+---------------------+------------------+----------------+------------+
5 rows in set (0.00 sec)

mysql> SELECT * from server_updater;
+-------------+---------------------+
| server_ip | last_update |
+-------------+---------------------+
| 10.10.61.17 | 2006-07-26 09:31:46 |
+-------------+---------------------+
1 row in set (0.00 sec)

mysql> SELECT * from vicidial_auto_calls;
+--------------+-------------+-------------+--------+---------+--------------------+----------------------+-------------------+------------+--------------+---------------------+-----------+
| auto_call_id | server_ip | campaign_id | status | lead_id | uniqueid | callerid | channel | phone_code | phone_number | call_time | call_type |
+--------------+-------------+-------------+--------+---------+--------------------+----------------------+-------------------+------------+--------------+---------------------+-----------+
| 502291 | 10.10.61.17 | HLPA | SENT | 213520 | NULL | V0726093134000213520 | NULL | 1 | 2014600990 | 2006-07-26 09:31:34 | OUT |
| 502289 | 10.10.61.17 | HLPA | XFER | 213518 | 1153927881.4184000 | V0726093121000213518 | IAX2/binfone00-28 | 1 | 7328468154 | 2006-07-26 09:31:21 | OUT |
| 502292 | 10.10.61.17 | HLPA | SENT | 213521 | NULL | V0726093139000213521 | NULL | 1 | 7182348178 | 2006-07-26 09:31:39 | OUT |
| 502293 | 10.10.61.17 | HLPA | SENT | 213522 | NULL | V0726093139000213522 | NULL | 1 | 9734922177 | 2006-07-26 09:31:39 | OUT |
| 502277 | 10.10.61.17 | HLPA | XFER | 213506 | 1153927845.4147999 | V0726093044000213506 | IAX2/binfone00-12 | 1 | 9086201191 | 2006-07-26 09:30:44 | OUT |
| 502286 | 10.10.61.17 | HLPA | XFER | 213515 | 1153927871.4175000 | V0726093111000213515 | IAX2/binfone00-18 | 1 | 8454251312 | 2006-07-26 09:31:11 | OUT |
| 502290 | 10.10.61.17 | HLPA | SENT | 213519 | NULL | V0726093131000213519 | NULL | 1 | 7183453550 | 2006-07-26 09:31:31 | OUT |
| 502294 | 10.10.61.17 | HLPA | SENT | 213523 | NULL | V0726093139000213523 | NULL | 1 | 5183816592 | 2006-07-26 09:31:39 | OUT |
| 502295 | 10.10.61.17 | HLPA | SENT | 213524 | NULL | V0726093142000213524 | NULL | 1 | 6098180645 | 2006-07-26 09:31:42 | OUT |
+--------------+-------------+-------------+--------+---------+--------------------+----------------------+-------------------+------------+--------------+---------------------+-----------+
9 rows in set (0.00 sec)

[roche]

The thing happend again

I checked the date the tiime seems to be the same in both machines

but thes tiime I ran ntd and ntpdate -u

it works, thanks