vicidial.org

by **enjay** » Tue Sep 12, 2006 6:31 pm

Im looking for some more advanced reporting capabilities. Here is my Scenario.

The lists I purchase are 100% home owners, and only home owners (obviously theres a few stragglers but you get my drift).

Of those lists 2/3 of those are day calls.

I would like to have reporting capabilities to have better visibility into who I am connecting with and who I am not connecting with based on Zip Code this way I can remove Zip codes during the day that obviously do not get hit very often.

Does anyone or has anyone developed any custom database queries that can help facilitate this.

I feel as though Im blind when it comes to the calls I can watch my wait average jump between 1.5 minutes to 3 minutes and then down to 15-30 seconds at any given time but I have 0 visibility into why or who Im calling when the wait average is low (15-30 seconds). These are obviously the areas I want to target during the day.

Any help would be appreciated.

-enjay

by **mflorell** » Tue Sep 12, 2006 10:28 pm

Do you usually get just a few zip codes at once?

You could try just calling one zipcode by using a filter:
postal_code IN('60532','60723')

And then just see what zipcodes get good contact rates at different times of day.

Other than something like this, it would be quite a bit of work to do some customized reports for lead analysis although it is a very interesting idea for a future feature to add.

by **enjay** » Tue Sep 12, 2006 10:50 pm

Matt,

In the agent detail performance when it shows total calls that would be total connected calls correct? Cause I know Im dialing more than the total calls in a given day just assuming the once that end up with CANCEL, CONGESTION, or just blank are not showing up as "calls". Is it possible to get a total calls as well?

Im typically calling a whole town or multiple towns for that matter and because I pull leads by last name Im trying to figure out how I can delineate between zip codes by lead.

FYI I will be working on a advanced reporting engine not exactly sure how its gonna go at this point I need to dig into the database more and find out what analytics I can get. Look for stuff on Mantis in the next couple weeks on this.

-enjay

by **mflorell** » Tue Sep 12, 2006 11:06 pm

The vicidial_agent_log will only show calls delivered to agents. For every call you need to look in the vicidial_log, or the VDAD report.

Looking forward to your code on the tracker.

by **enjay** » Tue Sep 12, 2006 11:39 pm

---------- AUTO-DIAL NO ANSWERS
Total NA calls -Busy,Disconnect,BTvoicemail: 0 0%
Average Call Length for NA Calls in seconds: 0

that is showing up in my vdad report, hardly possible that every call was answered In fact I know they werent.. why would this be?

-enjay

by **mflorell** » Wed Sep 13, 2006 1:20 am

what release is this with?

post results of these queries:
SELECT status,count(*) from vicidial_log where call_date >"2006-09-12 00:00:00" group by status;

SELECT status,count(*) from vicidial_list where modify_date > "2006-09-12 00:00:00" group by status;

by **enjay** » Wed Sep 13, 2006 11:55 am

vicidial_log:

Code: Select all: +--------+----------+ | status | count(*) | +--------+----------+ | A | 826 | | APT | 301 | | B | 1 | | BUS | 153 | | CBHOLD | 98 | | DC | 62 | | DNC | 92 | | DROP | 88 | | INCALL | 14 | | IRATE | 32 | | L | 16 | | N | 29 | | NA | 16 | | NI | 498 | | NS | 619 | | QUEUE | 17 | | RD | 3621 | | SB | 290 | +--------+----------+

vicidial_list

Code: Select all: +--------+----------+ | status | count(*) | +--------+----------+ | A | 1402 | | APT | 367 | | B | 154 | | BUS | 213 | | CALLBK | 3 | | CBHOLD | 90 | | DC | 96 | | DNC | 144 | | DNCL | 4286 | | DROP | 222 | | IRATE | 37 | | L | 21 | | N | 46 | | NA | 28 | | NEW | 17978 | | NI | 718 | | NS | 666 | | RD | 4594 | | SB | 350 | +--------+----------+

by **mflorell** » Wed Sep 13, 2006 12:31 pm

I am amazed that your NAs are so low. You must have very good leads to call. As for how the VDAD report is not seeming to show them, try adding &DB=1 to the end of the URL for the VDAD report and post the SQL statement that it prints before the NA section:

...../AST_VDADstats.php?query_date=2006-09-13&group=TESTCAMP&SUBMIT=SUBMIT&DB=1

Also, try running that query in your MySQL and see if the results are different in any way.

by **enjay** » Wed Sep 13, 2006 1:01 pm

I dont see how my NA's can be so low I watch the CLI and see hundreds of cancels or blanks i.e.

Code: Select all: -- Executing DeadAGI("Local/1520xxxxxxx@default-795b,2", "VD_hangup.agi|PRI-----NODEBUG-----0-----CANCEL----------") in new stack -- Launched AGI Script /var/lib/asterisk/agi-bin/VD_hangup.agi -- AGI Script call_log.agi completed, returning 0 -- Executing DeadAGI("Local/1520xxxxxxx@default-67d4,2", "VD_hangup.agi|PRI-----NODEBUG-----0-----CANCEL----------") in new stack -- Launched AGI Script /var/lib/asterisk/agi-bin/VD_hangup.agi -- AGI Script call_log.agi completed, returning 0 -- Executing DeadAGI("Local/8500998@default-201f,1", "VD_hangup.agi|PRI-----NODEBUG-----0---------------") in new stack -- Executing DeadAGI("Local/1520xxxxxxx@default-3ea9,2", "VD_hangup.agi|PRI-----NODEBUG-----0-----CANCEL----------") in new stack -- Launched AGI Script /var/lib/asterisk/agi-bin/VD_hangup.agi -- Hungup 'Zap/59-1' == Spawn extension (default, 1520xxxxxxx, 1) exited non-zero on 'Local/1520xxxxxxx@default-ce83,2' -- Executing DeadAGI("Local/1520xxxxxxx@default-ce83,2", "call_log.agi|h") in new stack -- Launched AGI Script /var/lib/asterisk/agi-bin/call_log.agi == Manager 'sendcron' logged off from 127.0.0.1 -- AGI Script VD_hangup.agi completed, returning 0 -- AGI Script call_log.agi completed, returning 0 -- Executing DeadAGI("Local/1520xxxxxxx@default-0666,2", "VD_hangup.agi|PRI-----NODEBUG-----0-----CANCEL----------") in new stack -- Launched AGI Script /var/lib/asterisk/agi-bin/VD_hangup.agi -- AGI Script VD_hangup.agi completed, returning 0 -- AGI Script call_log.agi completed, returning 0 -- Executing DeadAGI("Local/1520xxxxxxx@default-ce83,2", "VD_hangup.agi|PRI-----NODEBUG-----0-----CANCEL----------") in new stack

sit

wouldnt all of these constitute NA's? I know my NA's cannot be this low.

adding &DB=1 made no difference..

-enjay

by **mflorell** » Wed Sep 13, 2006 1:14 pm

turn on your AGI output lokking and take a look at some of the VDhangup output for these calls that are CANCEL and CONGESTION. Then look them up in the vicidial_list and see what status they are put as.

Post anything that doesn't look right.

by **enjay** » Wed Sep 13, 2006 1:31 pm

Code: Select all: -- AGI Script VD_hangup.agi completed, returning 0 -- AGI Script call_log.agi completed, returning 0 -- Executing DeadAGI("Local/15202070010@default-0666,2", "VD_hangup.agi|PRI-----NODEBUG-----0-----CANCEL----------") in new stack -- Launched AGI Script /var/lib/asterisk/agi-bin/VD_hangup.agi -- AGI Script VD_hangup.agi completed, returning 0 -- AGI Script call_log.agi completed, returning 0 -- Executing DeadAGI("Local/15203273738@default-ce83,2", "VD_hangup.agi|PRI-----NODEBUG-----0-----CANCEL----------") in new stack -- Launched AGI Script /var/lib/asterisk/agi-bin/VD_hangup.agi -- AGI Script VD_hangup.agi completed, returning 0

I tried looking up these phone numbers in the vicidial_log and they are not showing up at all, I know I have dialed them but they are not being put into the database. I tried looking up about 15 others and none of those showed up as well.

Additionally I tried looking up some with the ANSWER and those do show up.

-enjay

NOTE: Im using the phone number as a reference in the vicidial_log to look up.

by **mflorell** » Wed Sep 13, 2006 2:40 pm

If you turn the AGI output(in the servers table) to BOTH or FILE. what does the VDhangup output show for these NA calls?

by **enjay** » Wed Sep 13, 2006 2:46 pm

Where do I look for that output ifI have it set to FILE

there is nothing in the /var/log/astguiclient that would resemble vdhangup-date.log

by **mflorell** » Wed Sep 13, 2006 2:50 pm

in the /var/log/astguiclient you should see an agiout.2006-09-13 file that will have all AGI script output in it.

by **enjay** » Wed Sep 13, 2006 3:21 pm

It doesnt exist

Code: Select all: +------------+---------------------+-------------+--------+------------------+---------------------+-------------+-------------+----------------+--------------+----------------------+----------------------+--------------------+-----------+----------------------+-----------------------+-------------+--------------+----------------+------------+ | 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 | +------------+---------------------+-------------+--------+------------------+---------------------+-------------+-------------+----------------+--------------+----------------------+----------------------+--------------------+-----------+----------------------+-----------------------+-------------+--------------+----------------+------------+ | AsteriskOn | COB Asterisk server | 192.168.0.5 | Y | 1.2 | 90 | localhost | 5038 | cron | 1234 | updatecron | listencron | sendcron | -5 | 85026666666666 | 8365 | default | Y | Y | FILE | | AsteriskTw | COB Asterisk server | 192.168.0.6 | Y | 1.2 | 30 | LOCALHOST | 5038 | cron | 1234 | updatecron | listencron | sendcron | -5 | 85026666666666 | 8365 | default | Y | Y | FILE | +------------+---------------------+-------------+--------+------------------+---------------------+-------------+-------------+----------------+--------------+----------------------+----------------------+--------------------+-----------+----------------------+-----------------------+-------------+--------------+----------------+------------+

should be there but isnt.

by **mflorell** » Wed Sep 13, 2006 3:25 pm

cat /etc/astguiclient.conf

what do you see for the PATHlogs => value?

by **enjay** » Wed Sep 13, 2006 3:33 pm

PATHlogs => /var/log/astguiclient

and I have plenty of logs in there

action_full.date
action_process.date
action_send.date
listen.date
remoteagent.date
update.date
VDAD_DUPLICATE.date
vdautodial.date

by **mflorell** » Wed Sep 13, 2006 3:59 pm

can you vi into your VDhangup.agi script and paste the last changelog from it?

by **enjay** » Wed Sep 13, 2006 6:18 pm

# changes:
# 60203-1218 - fixed calleridname issue with 1.2 tree for custom CID
# 60314-1250 - Altered to allow for ignoring of AGI-defined status
# 60612-1500 - Added option for text log of hangup codes
# - Added option for PRI hangup code dispositions: BUSY, DISCONNECT
# 60615-1101 - Fixed log updates for CLOSER transfer from fronter calls
# 60719-1118 - changed to use DBI-DBD::mysql
# - changed to use /etc/astguiclient.conf for configs
#

by **mflorell** » Wed Sep 13, 2006 6:44 pm

That's an older version, about a month old, and it does not have AGI logging option in it. You should consider upgrading all of your scripts to 2.0.1b2. If you do, make sure you have the new queue_seconds field in the vicidial_closer_log table. That's the only MySQL change from 2.0.1b1.

by **enjay** » Wed Sep 13, 2006 7:32 pm

alrighty my man, will do this evening and letcha know what comes of it.

Can I just use the latest SVN or should I use 2.0.1b2?

-Art

by **mflorell** » Wed Sep 13, 2006 8:16 pm

They are basically the same, only a few minor changes to docs and CLI lead loader. I don't think I've changed anything in the agi folder since 2.0.1b2

by **enjay** » Thu Sep 14, 2006 12:20 pm

Ok all set, so I see many cancels and here is what Im seeing in the AGIout

Code: Select all: 2006-09-14 10:17:45|VD_hangup.agi|DEBUG: NODEBUG 2006-09-14 10:17:45|VD_hangup.agi|VD_hangup : V0914101705000621807 Local/6024945482@default-47f9,2 2 621807 2006-09-14 10:17:45|VD_hangup.agi|-- VDhangup Local DEBUG: |PRI|V0914101705000621807|CANCEL|0| 2006-09-14 10:17:45|VD_hangup.agi|+++++ VDAD START LOCAL CHANNEL: EXITING- 2 2006-09-14 10:17:48|call_log.agi|AGI Environment Dump: 2006-09-14 10:17:48|call_log.agi| -- accountcode = 2006-09-14 10:17:48|call_log.agi| -- callerid = 16233888899 2006-09-14 10:17:48|call_log.agi| -- calleridname = V0914101725000610469 2006-09-14 10:17:48|call_log.agi| -- callingani2 = 0 2006-09-14 10:17:48|call_log.agi| -- callingpres = 0 2006-09-14 10:17:48|call_log.agi| -- callingtns = 0 2006-09-14 10:17:48|call_log.agi| -- callington = 0 2006-09-14 10:17:48|call_log.agi| -- channel = Local/6024045794@default-d971,2 2006-09-14 10:17:48|call_log.agi| -- context = default 2006-09-14 10:17:48|call_log.agi| -- dnid = unknown 2006-09-14 10:17:48|call_log.agi| -- enhanced = 0.0 2006-09-14 10:17:48|call_log.agi| -- extension = h 2006-09-14 10:17:48|call_log.agi| -- language = en 2006-09-14 10:17:48|call_log.agi| -- priority = 1 2006-09-14 10:17:48|call_log.agi| -- rdnis = unknown 2006-09-14 10:17:48|call_log.agi| -- request = call_log.agi 2006-09-14 10:17:48|call_log.agi| -- type = Local 2006-09-14 10:17:48|call_log.agi| -- uniqueid = 1158254245.1440 2006-09-14 10:17:48|call_log.agi|AGI Variables: |1158254245.1440|Local/6024045794@default-d971,2|h|Local|V0914101725000610469| 2006-09-14 10:17:48|call_log.agi||CALL HUNG UP| 2006-09-14 10:17:48|call_log.agi||DELETE from live_inbound where uniqueid='1158254245.1440' and server_ip='192.168.0.5'| 2006-09-14 10:17:48|call_log.agi|+++++ CALL LOG HUNGUP: |1158254245.1440|Local/6024045794@default-d971,2|h|2006-09-14 10:17:48|min: |

I am not seeing anything in the database stating NA for that number in fact it shows there was no call to that number at all regardless of "status".

-enjay

by **mflorell** » Thu Sep 14, 2006 12:47 pm

try commenting out the part of the VDhangup code that exits on Local channels and see if that helps.

by **enjay** » Thu Sep 14, 2006 1:13 pm

So out of:

Code: Select all: if ($AGILOG) {$agi_string = "VD_hangup : $callerid $channel $priority $CIDlead_id"; &agi_output;} #if ($channel =~ /^Local/) #{ if ( ($PRI =~ /^PRI$/) && ($callerid =~ /\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d/) && ( ($dialstatus =~ /BUSY/) || ( ($dialstatus =~ /CHANUNAVAIL/) && ($hangup_cause =~ /^1$|^28$/) ) ) ) { if ($dialstatus =~ /BUSY/) {$VDL_status = 'B'; $VDAC_status = 'BUSY';} if ($dialstatus =~ /CHANUNAVAIL/) {$VDL_status = 'DC'; $VDAC_status = 'DISCONNECT';} $stmtA = "UPDATE vicidial_auto_calls set status='$VDAC_status' where callerid = '$callerid';"; if ($AGILOG) {$agi_string = "|$stmtA|"; &agi_output;} $affected_rows = $dbhA->do($stmtA); if ($AGILOG) {$agi_string = "-- VDAC update: |$affected_rows|$CIDlead_id"; &agi_output;} $stmtA = "UPDATE vicidial_list set status='$VDL_status' where lead_id = '$CIDlead_id';"; if ($AGILOG) {$agi_string = "|$stmtA|"; &agi_output;} $affected_rows = $dbhA->do($stmtA); if ($AGILOG) {$agi_string = "-- VDAD vicidial_list update: |$affected_rows|$CIDlead_id"; &agi_output;} $stmtA = "UPDATE vicidial_log set status='$VDL_status' where uniqueid = '$uniqueid';"; if ($AGILOG) {$agi_string = "|$stmtA|"; &agi_output;} $affected_rows = $dbhA->do($stmtA); if ($AGILOG) {$agi_string = "-- VDAD vicidial_log update: |$affected_rows|$uniqueid|"; &agi_output;} $dbhA->disconnect(); } else { if ($AGILOG) {$agi_string = "-- VDhangup Local DEBUG: |$PRI|$callerid|$dialstatus|$hangup_cause|"; &agi_output;} } if ($AGILOG) {$agi_string = "+++++ VDAD START LOCAL CHANNEL: EXITING- $priority"; &agi_output;} if ($priority > 2) {sleep(1);} exit; }

remove the whole thing or just a portion?

by **mflorell** » Thu Sep 14, 2006 1:35 pm

actually, just move the "exit;" to right below that " $dbhA->disconnect(); " line. That should do it. Let us know if that fixes it for you.

by **enjay** » Thu Sep 14, 2006 1:46 pm

Not not making a difference I still only see 2 NA's in the database for today and have seen hundreds of cancels.

by **mflorell** » Thu Sep 14, 2006 9:58 pm

Can you post the agi output from VDhangup one of these CANCELs?

by **enjay** » Thu Sep 14, 2006 10:16 pm

Code: Select all: 2006-09-14 19:27:07|VD_hangup.agi|Perl Environment Dump: 2006-09-14 19:27:07|VD_hangup.agi|0|PRI-----NODEBUG-----34-----CANCEL---------- 2006-09-14 19:27:07|VD_hangup.agi|AGI Environment Dump: 2006-09-14 19:27:07|VD_hangup.agi| -- accountcode = 2006-09-14 19:27:07|VD_hangup.agi| -- callerid = 6233888899 2006-09-14 19:27:07|VD_hangup.agi| -- calleridname = V0914192638000622684 2006-09-14 19:27:07|VD_hangup.agi| -- callingani2 = 0 2006-09-14 19:27:07|VD_hangup.agi| -- callingpres = 0 2006-09-14 19:27:07|VD_hangup.agi| -- callingtns = 0 2006-09-14 19:27:07|VD_hangup.agi| -- callington = 0 2006-09-14 19:27:07|VD_hangup.agi| -- channel = Local/6024822673@default-f9a1,2 2006-09-14 19:27:07|VD_hangup.agi| -- context = default 2006-09-14 19:27:07|VD_hangup.agi| -- dnid = unknown 2006-09-14 19:27:07|VD_hangup.agi| -- enhanced = 0.0 2006-09-14 19:27:07|VD_hangup.agi| -- extension = h 2006-09-14 19:27:07|VD_hangup.agi| -- language = en 2006-09-14 19:27:07|VD_hangup.agi| -- priority = 2 2006-09-14 19:27:07|VD_hangup.agi| -- rdnis = unknown 2006-09-14 19:27:07|VD_hangup.agi| -- request = VD_hangup.agi 2006-09-14 19:27:07|VD_hangup.agi| -- type = Local 2006-09-14 19:27:07|VD_hangup.agi| -- uniqueid = 1158287204.72064 2006-09-14 19:27:07|VD_hangup.agi|AGI Variables: |1158287204.72064|Local/6024822673@default-f9a1,2|h|Local|V0914192638000622684| 2006-09-14 19:27:07|VD_hangup.agi|DEBUG: NODEBUG 2006-09-14 19:27:07|VD_hangup.agi|VD_hangup : V0914192638000622684 Local/6024822673@default-f9a1,2 2 622684 2006-09-14 19:27:07|VD_hangup.agi|-- VDhangup Local DEBUG: |PRI|V0914192638000622684|CANCEL|34| 2006-09-14 19:27:07|VD_hangup.agi|+++++ VDAD START LOCAL CHANNEL: EXITING- 2

Code: Select all: 2006-09-14 19:27:07|VD_hangup.agi|Perl Environment Dump: 2006-09-14 19:27:07|VD_hangup.agi|0|PRI-----NODEBUG-----34-----CANCEL---------- 2006-09-14 19:27:07|VD_hangup.agi|AGI Environment Dump: 2006-09-14 19:27:07|VD_hangup.agi| -- accountcode = 2006-09-14 19:27:07|VD_hangup.agi| -- callerid = 6233888899 2006-09-14 19:27:07|VD_hangup.agi| -- calleridname = V0914192638000530318 2006-09-14 19:27:07|VD_hangup.agi| -- callingani2 = 0 2006-09-14 19:27:07|VD_hangup.agi| -- callingpres = 0 2006-09-14 19:27:07|VD_hangup.agi| -- callingtns = 0 2006-09-14 19:27:07|VD_hangup.agi| -- callington = 0 2006-09-14 19:27:07|VD_hangup.agi| -- channel = Local/6233228745@default-82b4,2 2006-09-14 19:27:07|VD_hangup.agi| -- context = default 2006-09-14 19:27:07|VD_hangup.agi| -- dnid = unknown 2006-09-14 19:27:07|VD_hangup.agi| -- enhanced = 0.0 2006-09-14 19:27:07|VD_hangup.agi| -- extension = h 2006-09-14 19:27:07|VD_hangup.agi| -- language = en 2006-09-14 19:27:07|VD_hangup.agi| -- priority = 2 2006-09-14 19:27:07|VD_hangup.agi| -- rdnis = unknown 2006-09-14 19:27:07|VD_hangup.agi| -- request = VD_hangup.agi 2006-09-14 19:27:07|VD_hangup.agi| -- type = Local 2006-09-14 19:27:07|VD_hangup.agi| -- uniqueid = 1158287202.72014 2006-09-14 19:27:07|VD_hangup.agi|AGI Variables: |1158287202.72014|Local/6233228745@default-82b4,2|h|Local|V0914192638000530318| 2006-09-14 19:27:07|VD_hangup.agi|DEBUG: NODEBUG 2006-09-14 19:27:07|VD_hangup.agi|VD_hangup : V0914192638000530318 Local/6233228745@default-82b4,2 2 530318 2006-09-14 19:27:07|VD_hangup.agi|-- VDhangup Local DEBUG: |PRI|V0914192638000530318|CANCEL|34| 2006-09-14 19:27:07|VD_hangup.agi|+++++ VDAD START LOCAL CHANNEL: EXITING- 2

Code: Select all: 2006-09-14 19:27:06|VD_hangup.agi|Perl Environment Dump: 2006-09-14 19:27:06|VD_hangup.agi|0|PRI-----NODEBUG-----0-----CANCEL---------- 2006-09-14 19:27:06|VD_hangup.agi|AGI Environment Dump: 2006-09-14 19:27:06|VD_hangup.agi| -- accountcode = 2006-09-14 19:27:06|VD_hangup.agi| -- callerid = 6233888899 2006-09-14 19:27:06|VD_hangup.agi| -- calleridname = V0914192638000700486 2006-09-14 19:27:06|VD_hangup.agi| -- callingani2 = 0 2006-09-14 19:27:06|VD_hangup.agi| -- callingpres = 0 2006-09-14 19:27:06|VD_hangup.agi| -- callingtns = 0 2006-09-14 19:27:06|VD_hangup.agi| -- callington = 0 2006-09-14 19:27:06|VD_hangup.agi| -- channel = Local/6235360134@default-09cd,2 2006-09-14 19:27:06|VD_hangup.agi| -- context = default 2006-09-14 19:27:06|VD_hangup.agi| -- dnid = unknown 2006-09-14 19:27:06|VD_hangup.agi| -- enhanced = 0.0 2006-09-14 19:27:06|VD_hangup.agi| -- extension = h 2006-09-14 19:27:06|VD_hangup.agi| -- language = en 2006-09-14 19:27:06|VD_hangup.agi| -- priority = 2 2006-09-14 19:27:06|VD_hangup.agi| -- rdnis = unknown 2006-09-14 19:27:06|VD_hangup.agi| -- request = VD_hangup.agi 2006-09-14 19:27:06|VD_hangup.agi| -- type = Local 2006-09-14 19:27:06|VD_hangup.agi| -- uniqueid = 1158287201.71975 2006-09-14 19:27:06|VD_hangup.agi|AGI Variables: |1158287201.71975|Local/6235360134@default-09cd,2|h|Local|V0914192638000700486| 2006-09-14 19:27:06|VD_hangup.agi|DEBUG: NODEBUG 2006-09-14 19:27:06|VD_hangup.agi|VD_hangup : V0914192638000700486 Local/6235360134@default-09cd,2 2 700486 2006-09-14 19:27:06|VD_hangup.agi|-- VDhangup Local DEBUG: |PRI|V0914192638000700486|CANCEL|0| 2006-09-14 19:27:06|VD_hangup.agi|+++++ VDAD START LOCAL CHANNEL: EXITING- 2

here are a few dumps of the cancels..

by **mflorell** » Thu Sep 14, 2006 11:16 pm

try deleting the exit completely, it is exiting for some reason, or else there would be more output from VDhangup

by **enjay** » Fri Sep 15, 2006 11:08 am

Ok I removed the 'exit;' all together and notta.. This is really wierd..

At no point does an INSERT happen when the call returns a cancel

Code: Select all: -- Executing DeadAGI("Local/15056320132@default-9700,2", "VD_hangup.agi|PRI-----NODEBUG-----0-----CANCEL----------")

When I look for that in MySQL

Code: Select all: mysql> select * from vicidial_log WHERE phone_number="5056320132" && call_date LIKE "2006-09-15 ________"; Empty set (0.36 sec) mysql>

Though the answers do put data into vicidial_log for instance

Code: Select all: mysql> select * from vicidial_log WHERE phone_number="5056328523" && call_date LIKE "2006-09-15 ________"; +--------------------+---------+---------+-------------+---------------------+-------------+------------+---------------+--------+------------+--------------+------+----------+-----------+ | uniqueid | lead_id | list_id | campaign_id | call_date | start_epoch | end_epoch | length_in_sec | status | phone_code | phone_number | user | comments | processed | +--------------------+---------+---------+-------------+---------------------+-------------+------------+---------------+--------+------------+--------------+------+----------+-----------+ | 1158336722.3810101 | 886527 | 81 | 1003 | 2006-09-15 09:12:23 | 1158336743 | 1158336752 | 9 | RD | | 5056328523 | 205 | AUTO | N | +--------------------+---------+---------+-------------+---------------------+-------------+------------+---------------+--------+------------+--------------+------+----------+-----------+ 1 row in set (0.36 sec)

for:

Code: Select all: -- Executing DeadAGI("Local/15056328523@default-050f,2", "VD_hangup.agi|PRI-----NODEBUG-----16-----ANSWER-----20-----0") in new stack

-enjay

by **mflorell** » Fri Sep 15, 2006 2:21 pm

Are you sure you're updating the right script? It seems like nothing you do changes the output, can you put some print statements in there and see if it changes anything?

by **enjay** » Fri Sep 15, 2006 2:33 pm

Yup definately modifying the right file /var/lib/asterisk/agi-bin/VD_hangup.agi I added some stuff into it and I see it being put out in the agiout-2006-09-15 file in /var/log/astguiclient

for some reason that INSERT is just never happening for calls with CANCEL.

-enjay

by **mflorell** » Fri Sep 15, 2006 2:39 pm

That is very odd, I've never run into that. All I can suggest is just playing around with the code since I cannot duplicate your problem here.

by **enjay** » Fri Sep 15, 2006 4:25 pm

Which file actually does the INSERT into the vicidial_log for calls that return a CANCEL?

the VD_hangup.agi appears to only provide updates, though an UPDATE will only take affect if the INSERT happens correct?

-enjay

by **mflorell** » Fri Sep 15, 2006 4:55 pm

The AST_VDauto_dial.pl script is the one that is supposed to insert entries that are Dead calls(like CANCELs) when it does it's validation of the vicidial_auto_calls table to check whether the calls are alive or not.

by **enjay** » Fri Sep 15, 2006 5:49 pm

interesting that the AST_VDauto_dial script doesnt do an INSERT INTO vicidial_logs at all in the vdautodial.2006-09-15 log plenty into vicidial_managers but nothing in vicidial_log...

-enjay

by **enjay** » Fri Sep 15, 2006 6:23 pm

if anyone does a:

'grep vicidial_log vdautodial.2006-0*'

do you get anything back?

by **mflorell** » Fri Sep 15, 2006 9:43 pm

The query isn't logged, you need to look for "dead NA call added to log" which logs information about the call and denotes an insertion into vicidial_log.

by **enjay** » Mon Sep 18, 2006 10:59 am

yea I have like 6 of those for 2006-09-16 but there are thousands of CANCELS via the command line.. I'll keep looking though nothing has changed other than upgrading from 2.0.1 to 2.0.1b2.

What SHOULD the agiout-date look like if a CANCEL or any other NA call comes in?

additionally here are the cron entries I use can you tell me if this is correct.

Asterisk/VICIDIAL Server

Code: Select all: ### keepalive script for Asterisk updaters * * * * * /usr/share/astguiclient/ADMIN_keepalive_AST_update.pl ### keepalive script for Asterisk manager queue system * * * * * /usr/share/astguiclient/ADMIN_keepalive_AST_send_listen.pl ### keepalive script for Asterisk VICIDIAL autodial system * * * * * /usr/share/astguiclient/ADMIN_keepalive_AST_VDautodial.pl ### keepalive script for VICIDIAL remote agents * * * * * /usr/share/astguiclient/ADMIN_keepalive_AST_VDremote_agents.pl ### kill Hangup script for Asterisk updaters * * * * * /usr/share/astguiclient/AST_manager_kill_hung_congested.pl ### updater for voicemail * * * * * /usr/share/astguiclient/AST_vm_update.pl ### updater for conference validator * * * * * /usr/share/astguiclient/AST_conf_update.pl ## adjust time on the server with ntp 30 * * * * /usr/sbin/ntpdate -u 18.145.0.30

Web Server / Database Server

Code: Select all: ### updater for VICIDIAL hopper * * * * * /usr/share/astguiclient/AST_VDhopper.pl -q ### fix the vicidial_agent_log once every hour 33 * * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl ### adjust the GMT offset for the leads in the vicidial_list table 1 1 * * * /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --debug ### keepalive script for VICIDIAL predictive script * * * * * /usr/share/astguiclient/ADMIN_keepalive_AST_VDadapt.pl ### optimize the database tables within the asterisk database 3 1 * * * /usr/share/astguiclient/AST_DB_optimize.pl ## adjust time on the server with ntp 30 * * * * /usr/sbin/ntpdate -u 18.145.0.30

vicidial.org

Report Queries.

Report Queries.

Who is online