AST_VDauto_dial.pl

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

AST_VDauto_dial.pl

Postby roche » Wed Jul 26, 2006 10:04 am

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";

roche
 
Posts: 38
Joined: Fri Jun 16, 2006 5:26 pm

Postby mflorell » Wed Jul 26, 2006 10:10 am

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?
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby roche » Wed Jul 26, 2006 10:15 am

mflorell wrote: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.
roche
 
Posts: 38
Joined: Fri Jun 16, 2006 5:26 pm

Postby mflorell » Wed Jul 26, 2006 10:27 am

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;
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby roche » Wed Jul 26, 2006 10:33 am

mflorell wrote: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
 
Posts: 38
Joined: Fri Jun 16, 2006 5:26 pm

Postby roche » Tue Aug 01, 2006 10:27 am

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
roche
 
Posts: 38
Joined: Fri Jun 16, 2006 5:26 pm


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 75 guests

cron