Server reboot and now all hosts are missing!!

jengstro · Post by **jengstro** » Thu Jan 12, 2006 11:33 am

Someone rebooted the server running Cacti and now there are no hosts in the graph trees or in the device list! Please help!!

jengstro · Post by **jengstro** » Thu Jan 12, 2006 11:48 am

It appears that mysql cant open file host.MYI but the file exists!

Post by **rony** » Thu Jan 12, 2006 11:51 am

That is a mysql problem.

Do you have a backup? Have you run a check/repair in mysql on the cacti database?

jengstro · Post by **jengstro** » Thu Jan 12, 2006 11:52 am

The backup is on tape...

Where might I find the check/repair utility?

Thanks!

BSOD2600 · Post by **BSOD2600** » Thu Jan 12, 2006 12:50 pm

mysqlcheck --auto-repair --databases cacti

jengstro · Post by **jengstro** » Thu Jan 12, 2006 12:57 pm

Now I am getting...

"The system cannot find the path specified."

BSOD2600 · Post by **BSOD2600** » Thu Jan 12, 2006 3:12 pm

When you do what exactly.

jengstro · Post by **jengstro** » Thu Jan 12, 2006 3:38 pm

I ran the repair and now I get windows that pop up on the server with the message above over and over.

BSOD2600 · Post by **BSOD2600** » Thu Jan 12, 2006 6:30 pm

umm, maybe you don't have c:\mysql\bin in your system path so it couldn't find mysqlcheck?

jengstro · Post by **jengstro** » Fri Jan 13, 2006 11:28 am

No... these are cactiplus command windows.

BSOD2600 · Post by **BSOD2600** » Fri Jan 13, 2006 2:13 pm

ah, ok. So there is something cacti is trying to use and it can't find. Make sure the paths to applications in cacti's settings are correct.

Turn the polling level in cacti to debug (Settings | Polling level) for one cycle and paste the output of the actual log file (./cacti/log/cacti.log). If it contains WEBLOG entries, then don't bother posting since they just clutter up the log. Turn off WEBEVENTS logging and try again.

jengstro · Post by **jengstro** » Fri Jan 13, 2006 4:36 pm

I am trying to grab the data from the log file but the darn thing fills up so fast. I wish I could filter to only get errors... why do you have to have all the normal data as well? bah I say!

I cannot find any problem with paths or any errors to link to the post above...

Once the log is managable enough to post it here I will upload it.

Thanks.

BSOD2600 · Post by **BSOD2600** » Fri Jan 13, 2006 6:27 pm

The default path would likely be: c:\inetpub\wwwroot\cacti\log\cacti.log

jengstro · Post by **jengstro** » Fri Jan 13, 2006 6:59 pm

Here is the log after a few minutes...

BSOD2600 · Post by **BSOD2600** » Fri Jan 13, 2006 7:37 pm

Looks like all your perl scripts are failing. Do you have c:\perl\bin (or whereever you installed it) in your system path?

Server reboot and now all hosts are missing!!

Server reboot and now all hosts are missing!!

Who is online