no host available when adding to tree

[den707]

Hi,

We have a cacti v0.8.8a. About couple months ago I added some devices. Recently some weird things happen, all my graphs are missing. I went ahead and search for it and there i found all my devices still in "Data Source". I tried to re-add them back to the tree and I notice that the drop down menu for "adding the host to tree is empty".


Appreciate any help.

Thanks
Den707

[netniV]

Check your cacti.log file for errors. Unfortunately, 0.8.8a is quite old so there will be little support for it.

[den707]

Thanks for the reply. I have attached the Cacti.log file. Please see attached file.

[netniV]

Can you do a SHOW TABLES; at MySQL prompt??

[den707]

Sorry, I'm new to Cacti. Could you please give me the steps to get the "Show Table" at my SQL prompt?

Thanks
den707

[netniV]

Steps are:

Code: Select all

$ mysql -u <cacti_sql_user> -p <cacti_db>
Enter password: <cacti_sql_password>
mysql> use <cacti_db>;
mysql> SHOW TABLES;

The output from that last statement is what I'm after. Also, I've seen a couple of users on here reporting mysql database issues, you may wish to check that they aren't in a failed state but I'm not sure how you do that off the top of my head. Google will probably have the answer.