Graphs are gone after CentOS updates and Cacti upgrade

Rusalka · Post by **Rusalka** » Wed Mar 14, 2007 12:32 pm

I could use some help please (limited Linux knowledge).

Situation:
After applying 500+ patches/upgrades to CentOS v4.4, I noticed that the data acquisitions had stopped (note: still had graphs, just data had stopped).

So, boss tells me to reload Cacti. I did an upgrade from h to j and i followed the upgrade instructions religiously (thanks for those by the way!!!). I even applied the four patches while i was at it (again, thanks for suppling directions). Logged into Cacti and it seemed ok until i clicked on the Graphs tab, NOTHING, blank page!! had to click the back arrow then "view graphs". Tree view is empty, list view shows devices, preview only shows text, NO graphs. So, back in the Console tab>Graph Tree, i see the four trees that i set up but now they are empty.

HELP what did i do wrong?

PS, i also had the poller problem listed in another post but fixed by moving cactid into the cacti root directory.

Post by **gandalf** » Thu Mar 15, 2007 2:12 pm

Hopefully, you created a mysqldump before upgrading?
Please check, whether the graph_* tables of database cacti contains any items. Please verify, that table tree_items contains entries as well.
Reinhard

Rusalka · Post by **Rusalka** » Fri Mar 16, 2007 9:53 am

yes, i did create a dump.

ok, all the tables graph_* appear to have data. Now for the other table, did you mean graph_tree_items because it shows having 12 rows. I did not find a tree_items table.

Also, when in graph management and i click debug, i see "RRDTOOL" in bold and that's it at the bottom.

Post by **gandalf** » Fri Mar 16, 2007 10:20 am

Please post a screenshot
Reinhard

Rusalka · Post by **Rusalka** » Fri Mar 16, 2007 11:04 am

As you requested, i have added the screen shot as an attachment. Seems i could not paste it into message body.

Note: On purpose, I removed the ip address from the host field.

Post by **gandalf** » Sat Mar 17, 2007 5:44 am

Never seen this before. Did you already run a repair on all mysql tables belonmgig to db cacti
Reinhard

Rusalka · Post by **Rusalka** » Mon Mar 19, 2007 9:24 am

No, how do i do a repair?

I am new to a lot of this so any help is greatly appreciated.

Post by **gandalf** » Mon Mar 19, 2007 12:24 pm

I always use phpmyadmin. Select all tables and choose "repair" option. Takes some seconds and whoosh ...
You may of course use native sql; sth like "repair table <table name>"; but not sure ..
Reinhard

Rusalka · Post by **Rusalka** » Mon Mar 19, 2007 1:13 pm

OK, i used MYSQL admin and ran the repair (extended) on the tables. Results came back as "OK" for all the tables.

No changes, now what should i try?

Post by **TheWitness** » Tue Mar 20, 2007 7:47 pm

Dump your db and PM to me or send to my e-mail. Also, create a file in our cacti web root called "phpinfo.php". Add the following to that file. Post the output when you point your browser at it.

Code: Select all

<?php phpinfo(); ?>

TheWitness

Rusalka · Post by **Rusalka** » Thu Mar 22, 2007 2:22 pm

As you requested, I am sent you the sql dump.

As for the phpinfo.php, when I point a browser

Rusalka · Post by **Rusalka** » Thu Mar 22, 2007 2:23 pm

As you requested, I am sent you the sql dump.

As for the phpinfo.php, when I point a browser

Rusalka · Post by **Rusalka** » Thu Mar 22, 2007 2:23 pm

As you requested, I have sent you the sql dump.

As for the phpinfo.php, when I point a browser (firefox) from my machine, I just get a blank page. When I try from the cacti server, same thing.

Graphs are gone after CentOS updates and Cacti upgrade

Graphs are gone after CentOS updates and Cacti upgrade

Who is online