MySql Table Crashed.

Borin · Post by **Borin** » Wed Jul 29, 2009 12:30 am

Dear All,

I have installed and use Cacti version 0.8.7a. It was working for long time, but recently I have one problem with it. When I click on User Management in the left panel of Admin, I don't see any users in the list but actually, it has 4 users in it. And then I have checked further, I click on System Utilities -->Technical Support. I found one error in MySql Table Information Section that said, "user_log | Unknown | Unknown | Table './cacti/user_log' is marked as crashed and should be repaired ". I don't know how to repair user_log table. I think may be coz of this that make all the users are hidden when I clicked on User Management.

I have attached the files that related to my problem in this also.

Anybody can help me to fix it. All your help are very much appreciated.

thanks,

streaker69 · Post by **streaker69** » Wed Jul 29, 2009 7:30 am

http://dev.mysql.com/doc/refman/5.0/en/repair.html

Post by **gandalf** » Thu Jul 30, 2009 12:46 pm

Hmm, there should be a script in cli now. Or did I create it for 088. Getting older, memories .... ahhh
Reinhard

Borin · Post by **Borin** » Thu Jul 30, 2009 10:38 pm

Dear All,

Thanks for your kindly help. Now problem was gone away from me.

But I face one problem that I try to find solution to do but still no solution.
My problem is I want to remove graph that were not use from Graph Tree but not delete graph from Graph Management. I don't see any way to remove only graph that I don't need anymore in Graph Tree but still keep it in Graph Management.

Could you please advice me the way to do this?

Thanks,

Borin

Post by **gandalf** » Fri Jul 31, 2009 2:33 pm

You may remove any object from the tree using "Graph Tree" management. Removing a graph from the tree does NOT erase the graph itself from Cacti, only the tree entry is erased.
Reinhard

berbondac · Post by **berbondac** » Fri Apr 02, 2010 1:24 pm

Hello,

Like i said in my previous post, i have inherited some cacti servers.

On one of them i have the same problem stated here. In User Management tab i see no users listed but i have 6 lines that are not showed, just like the picture posted in the original complaint of my forum colleague.

But when i go to System Utilities -> Technical Support

there is no "user_log" line in the "MySQL Table Information" part of the report.
from "user_auth_realm" line it jumps to "version" lline and all the lines show as OK.

I would very much appreciate any help with this issue since i do not have MySQL skills.
Thank you

Post by **gandalf** » Fri Apr 02, 2010 2:21 pm

Please use ./cli/repair_database.php
R.

Borin · Post by **Borin** » Mon Apr 05, 2010 10:15 pm

You can try this coz this is the solution I found while I met this problem too and it is really work for me

[root@ns2 /]# mysqlcheck --user=root --password=xxxx -r cacti

[root@ns2 /]# mysqlcheck --user=root --password=xxxx --auto-repair=TRUE cacti user_log

Note: I deploy it on Fedora 9. So this CLI I applied on Terminal of Fedora.

Hope this help you.

berbondac · Post by **berbondac** » Mon Apr 12, 2010 2:35 am

thank you gandalf, that worked.

I did a ##php <cactipath>\cli\repair_database.php .
after it stayed a while at the user_log table it successfully fixed it.

Thank you once again

Thank you to you too Borin for your reply.

Cacti

MySql Table Crashed.

MySql Table Crashed.

Thanks

Same issue, but different observations

Who is online