vicidial.org

In webmin, I am getting this error :

Edit Database
asterisk


SQL show index from `recording_log` failed : Table './asterisk/recording_log' is marked as crashed and should be repaired

then you should repair that table.

in phpmyadmin you can repair and optimize that table.

if you do not have phpmyadmin or know how to use it you can also do it with mysql on the command line. but phpmyadmin is easier.

also: i've noted that many people who report that error have filled their hard drive with astguiclient log files

/var/log/astguiclient

if your drive is full, clean it out.

from the command line: (you can do all tables or just one, i like to do both more than once until it reports no failures)
mysqlcheck --auto-repair asterisk -p
mysqlcheck --auto-repair asterisk [insert table name here] -p

1) I changed the password from Webmin for mysql.
2) I logge din to my server as root.
3) I tried mysqlcheck --auto-repair asterisk -p command
4)

Code: Select all

[root@vicidialnow ~]# mysqlcheck --auto-repair asterisk -p
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/spool/mail/root
[root@vicidialnow ~]#




I am getting error as

Got error: 1045: Access denied for user 'root'@'localhost'

How to run this command ?

I am sure that I entered the password correct.

Code: Select all


[root@vicidialnow ~]# mysqladmin --no-defaults -u root version
mysqladmin  Ver 8.41 Distrib 5.0.22, for redhat-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.0.22
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 3 hours 36 min 33 sec

Threads: 9  Questions: 374532  Slow queries: 0  Opens: 0  Flush tables: 1  Open tables: 46  Queries per second avg: 28.826
You have new mail in /var/spool/mail/root
[root@vicidialnow ~]#




I tried above command ...

Outputs are as follow....

if you "changed the root password for mysql in webmin" you may not have done what you think you did. to log in to mysql as "root" in webmin, you need the root mysql password.

this is not the "root" password, it is the "mysql root" password ... they are not the same thing (just making sure you are aware of this).

also, if you put the password after -p (-ppassword) you can do it without the password prompt (this makes the password visible, so remember to mask it when you post this line here unless you subsequently CHANGE the password)

mysqlcheck --auto-repair asterisk -ppassword

but to do this, you must already have the password.

did you log into mysql in webmin and/or from the command line with the password to be sure it is right?

from the command line:
mysql -p

in webmin, go to servers, mysql

I changed the password from Webmin for mysql.

did you log into mysql in webmin and/or from the command line with the password to be sure it is right?

from the command line:
mysql -p

in webmin, go to servers, mysql

Awesome.

Worked.