DBD::mysql::db do failed:

[Bentfinger]

Please allow me to apologize first for being such a a noob to AST and SQL and Linux and all else
The power at my shop browned-out, my dialer didn't go down but my workstations did, and somehow when they rebooted one of my agents was showing 4 instances of being in the campaign (she logged in/out that many x b4 I stopped her). I had everyone reboot their comps, thinking that it might be a browser problem. When they tried to log back in, same issue so I re-booted my dialer....and then noone can log in, they get booted to the light blue screen, "call agent again or go back". When the dialer rebooted, I got the error message: "Table './asterisk/vicidial_live_agents' is marked as crashed and should be repaired at /usr/share/astguiclient/AST_reset_mysql_vars.pl line 96."
I could log into the admin screens, so I first tried to rebuild the conferences in the server settings, but;of course; that didn't work, so I
searched the forums and tried "/usr/share/astguiclient/AST_reset_mysql_vars.pl" by itself and rebooted - no dice
searched again and tried "mysqlcheck -u root -A --auto-repair" and rebooted - no dice
searched further tried "mysqlcheck -ucron p1234 -A --auto-repair" and rebooted - no dice
thought I was smart and tried "/usr/share/astguiclient/AST_reset_mysql_vars.pl --debug96 - my dialer actually laughed at me
ok, not really but I am stuck, it is my understanding that .../asterisk/vicidial_live_agents' is marked as crashed and should be repaired but I don't know how to do it, I know that I should rebuild line 96, but I don't know enough to do so myself, or to have it fix itself.
my error message now reads: "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."
Can anyone guide me in the right direction? - Thanks.

OpenSuSE / ViciBox Redux v.3.1.14 release / HP Proliant DL

[DomeDan]

Hi, try to repair the specific table:
mysqlcheck -u root -p --auto-repair --check --optimize asterisk vicidial_live_agents
(remove -p if you aint got no password on root)
does it return anything else but "OK"?

[Bentfinger]

mysqlcheck: Got error: 1044: Access denied for user ''@'localhost' to database 'asterisk' when selecting the database

[DomeDan]

ok, then try without -p (password)
mysqlcheck -u root --auto-repair --check --optimize asterisk vicidial_live_agents

[Bentfinger]

sorry dude, the first time I forget the "check"
When I did it right, (your first reply) i get :
mysqlcheck: Got error: 1044: Access denied for user ''@'localhost' to database 'asterisk' when selecting the database

[Bentfinger]

without -p i get:
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect

[DomeDan]

sorry dude, the first time I forget the "check"
When I did it right, (your first reply) i get :
mysqlcheck: Got error: 1044: Access denied for user ''@'localhost' to database 'asterisk' when selecting the database

''@'localhost' -seams like you forgot "-u root"
try again and post exactly what command you type and the response

without -p i get:
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect

ok, then you should use -p and write your password, do you write the correct password?

[Bentfinger]

yes
mysqlcheck -u root -p --auto-repair --check --optimize asterisk vicidial_live_agents
Enter password: (I entered my password here)
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

[Bentfinger]

When I enter password, is it my root password, or one of the other ones?

[DomeDan]

It is the root password for mysql (not the password for linux root user)

Maybe you can use the cron user or some other user to repair the table:
mysqlcheck -u cron -p --auto-repair --check --optimize asterisk vicidial_live_agents

[Bentfinger]

used password for mysql root:

mysqlcheck -u root -p --auto-repair --check --optimize asterisk vicidial_live_agents
Enter password:
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
You have new mail in /var/mail/root

[Bentfinger]

It is the root password for mysql (not the password for linux root user)

Maybe you can use the cron user or some other user to repair the table:
mysqlcheck -u cron -p --auto-repair --check --optimize asterisk vicidial_live_agents

BTW, thank you for your time so far DomeDan.
I have the password for cron as well, but I dont know what cron is.
I've never logged into my phpMyAdmin webpage, I don't know if that means anything.
I'm starting to believe the weasels did eat my system!

[DomeDan]

Your welcome, the cron-user in mysql take care of automatic jobs and other stuff.
test to use that user, I tried myself and it seams to work:
mysqlcheck -u cron -p --auto-repair asterisk vicidial_live_agents
the cron password can be obtained from this file /etc/astguiclient.conf

[Bentfinger]

mysqlcheck -u -p --auto-repair asterisk vicidial_live_agents
mysqlcheck: Got error: 1044: Access denied for user ''@'localhost' to database 'asterisk' when selecting the database

[DomeDan]

thank you for posting the command!
you forgot to write "cron" after "-u"

[Bentfinger]

yep, saw that and re-enetered, it worked
I copied the "success story" and pasted here so all could see, but forgot to hit submit b4 I tested it live, but it worked. Many thanks DomeDan - u r awesome!