your session is disable

[awaais]

i run the following command and i found this at the end....

[root@go ~] /usr/share/astguiclient/AST_reset_mysql_vars.pl --debugX

- conferences reset
- vicidial_conferences reset
- vicidial_manager delete
- vicidial_auto_calls delete
DBD::mysql::db do failed: Table './asterisk/vicidial_live_agents' is marked as crashed and should be repaired at /usr/share/astguiclient/AST_reset_mysql_vars.pl line 96.
- vicidial_live_agents delete
- vicidial__users delete
- vicidial_campaign_server_stats delete
- vicidial_hopper delete



please help me rebuild this file
this is what i am getting as soon i login as agent. it was working fine before i though it was Date and Time OR a IP issue but it is not so....





Please Help me

[emathis]

Based on the error messages, its talking about the database. Google around for how to repair mysql MyISAM tables.
If you need a GUI, try MySQL Administrator.

-Erik-

[rrb555]

use this

Code: Select all

mysqlcheck -u root -A --auto-repair

Code: Select all

reboot

Code: Select all

screen -ls

screen -ls output should be 9 sockets

[awaais]

i ran mysqlcheck at CLI but resulting this at the end

"mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect"

[awaais]

thanks

[awaais]

use this

Code: Select all

mysqlcheck -u root -A --auto-repair

Code: Select all

reboot

Code: Select all

screen -ls

screen -ls output should be 9 sockets

the following command works......

[root@go ~]#

Code: Select all

mysqlcheck -ucron -p1234 -A --auto-repair

[root@go ~]#

Code: Select all

screen -ls

There are screens on:
4433.ASTlisten (Detached)
4445.ASTfastlog (Detached)
3051.asterisk (Detached)
21560.ASTVDremote (Detached)
4442.ASTVDadapt (Detached)
2786.astshell20120405040847 (Detached)
4422.goautodial_d (Detached)
21557.ASTVDauto (Detached)
4427.ASTupdate (Detached)
4430.ASTsend (Detached)
10 Sockets in /var/run/screen/S-root.