ASTVDauto not working

[drycell95]

Hi,
Please help me, when the asterisk server starts up astvdauto is listed using screen -r, but when the agents started to make calls it stops working.

-Predictive dialer is not working
-auto calls do not automatically hangup, even after the dial timeout

Just tell what logfiles i need to post

Server Specs:
Kernel 2.6.18-4-686
3GB Ram
Quad core Xeon 3ghz
Asterisk 1.2.14
Vicidial 2.0.73

-Screen Output during calls:
There are several suitable screens on:
3895.ASTVDremote (Detached)
3889.ASTlisten (Detached)
3836.asterisk (Detached)
3886.ASTsend (Detached)
3901.ASTfastlog (Detached)
3898.ASTVDadapt (Detached)
3883.ASTupdate (Detached)
Type "screen [-d] -r [pid.]tty.host" to resume one of them.

[enjay]

Okay thats confusing "predictive dialer doesnt dial" yet "autodial calls dont hangup after timeout" which one is it?

When your agent login and select resume are you saying ASTVDauto isnt running at that point? Please provide additional details.

-Art

[drycell95]

sorry about that, what i mean is predictive dialer will not work because the auto dials made doesnt hang up, which leaves no room for new auto calls. this is probably caused by astvdauto, which is not running

heres what i noticed, the first time they dial predictive, it works fine, but if nobody answers the auto call, it will not hang up

[drycell95]

Maybe this could help?

TIME DEBUG: ||0| GMT: 19:11
2008-01-17 19:11:09|LOGGED INTO MYSQL SERVER ON 1 CONNECTION||
TIME DEBUG: ||0| GMT: 19:11
2008-01-17 19:11:09|LIVE AGENTS LOGGED IN: 21|
2008-01-17 19:11:09|FIDO 192.168.5.3: agents: 12 dial_level: 0|
2008-01-17 19:11:09|FIDO 192.168.5.3: Calls to place: -89 (0 - 89) |
2008-01-17 19:11:09|CAMPAIGN DIFFERENTIAL: 13 0 (0 - 0)|
2008-01-17 19:11:09|LOCAL TRUNK SHORTAGE: 0|0 (56 - 96)|
2008-01-17 19:11:09|10032 192.168.5.3: agents: 4 dial_level: 0|
2008-01-17 19:11:09|10032 192.168.5.3: Calls to place: -49 (0 - 22) MVT override
: 96 OTHER LIMIT override: 96|
2008-01-17 19:11:09|CAMPAIGN DIFFERENTIAL: 4 0 (0 - 0)|
2008-01-17 19:11:09|LOCAL TRUNK SHORTAGE: 27|27 (96 - 96)|
2008-01-17 19:11:09|10030 192.168.5.3: agents: 3 dial_level: 0|
2008-01-17 19:11:09|10030 192.168.5.3: Calls to place: -49 (0 - 15) MVT override
: 96 OTHER LIMIT override: 96|
2008-01-17 19:11:09|CAMPAIGN DIFFERENTIAL: 3 0 (0 - 0)|
2008-01-17 19:11:09|LOCAL TRUNK SHORTAGE: 34|33 (96 - 96)|
2008-01-17 19:11:09|10024 192.168.5.3: agents: 2 dial_level: 0|
2008-01-17 19:11:09|10024 192.168.5.3: Calls to place: -49 (0 - 19) MVT override
: 96 OTHER LIMIT override: 96|
2008-01-17 19:11:09|CAMPAIGN DIFFERENTIAL: 2 0 (0 - 0)|
2008-01-17 19:11:09|LOCAL TRUNK SHORTAGE: 30|29 (96 - 96)|
2008-01-17 19:11:09|FIDO 192.168.5.3: CALLING|
2008-01-17 19:11:09|10032 192.168.5.3: CALLING|
2008-01-17 19:11:09|10030 192.168.5.3: CALLING|
2008-01-17 19:11:09|10024 192.168.5.3: CALLING|
TIME DEBUG: ||0| GMT: 19:11
DBD::mysql::st execute failed: Table './asterisk/call_log' is marked as crashed
and last (automatic?) repair failed at /usr/share/astguiclient/AST_VDauto_dial.p
l line 799.
executing: SELECT end_epoch,uniqueid FROM call_log where caller_code='M011719023
8003505239' and server_ip='192.168.5.3' order by end_epoch, start_time desc limi
t 1; Table './asterisk/call_log' is marked as crashed and last (automatic?) repa
ir failed at /usr/share/astguiclient/AST_VDauto_dial.pl line 799.

[enjay]

yea that helps the call_log table is corrupt rebuild it..

[drycell95]

Can you please help me how to rebuild it? i dont know how

[ramindia]

Hi

just use some mysql fix commands to fix the table

or remove the data from mysql database and start from fresh

ram