Graph Previews show, but not graphs themselves....

[Necrisrex]

OK, I have a possibly a unique problem, I have not had to deal with this before and could find nothing in the forums.

I manage a rather large cacti installation, and have recently upgraded it to 0.8.6.f in the middle of trying to figure out a problem in which the "outbound" data source was lost from the original template file. I wound up creating a second installation of cacti on the same server and have been attempting to re-create the original scope of the installation.

I am not really trained as a system administrator, and kind of inherited the "care and feeding" of cacti as a monitoring system at our site quite a while ago, and as such I didn't think to add any rotation scheme to the log files, nor did I realize I had full binary logging turned on in MySQL. I have since corrected both of these issues. Only after they had filled up my drive and cacti had quit working.

In the process of debugging them, I changed a couple of settings in cacti for one or two of my graphs (in the newer installation with working outbound traffic data ).

Since then I have been unable to view any graph in graph.php. They draw just fine in the graph_view.php, they look fine in graphs.php. BUT they will not draw in graph.php. I am at a loss as to why. I added action=properties to one of the URL's and got the rrdtool command and cut and pasted, putting output into an external image. When I loaded this image it had the proper values identified and hte correct scale, etc... but it was completely devoid of data.

They still work fine in the original install. Although I think that may have to do with the fact that I did not change any settings in that installation while the drive was full and mysql couldn't properly function (nor rrdtool for that matter...)

Does anyone have ANY ideas?

Thanks in advance,
Necris Rex

[Necrisrex]

OK, after debugging for a bit longer I have discovered that when I capture the rrdtool commands from the "action=properties" page load IF I change the start and end times (which appear to be start 5 minutes in the future and end now) I do get a five minute graph, and manipulating these values does appear to give me the graph I was attempting to create.

I really don't want to have to start a third installation all over again because I have already managed to add 200+ machines to this one.

Please let me know if you can think of ANYTHING.

Thanks again,
Necris Rex

[rony]

Settings -> RRDTool Version

[Necrisrex]

The RRDTool version is 1.0.x same as the working (well, differently broken) installation on the same box.

Is this a problem?

Thanks again,
Necris Rex

[rony]

Nope, just wanted you to confirm the setting is the version that you have on the box.

[Necrisrex]

I'm pretty sure that I managed to screw up a database table while the drive was full. I had to force kill MySQL once or twice, I was just hoping that someone may have some advice to restore it. Especially since it's mainly working, the data are being collected and everything seems happy, except for display on graph.php.

Thanks again for your help,
Necris Rex

[rony]

Have you attempted to check/repair the mysql cacti database?

If that doesn't work, you can dump it and reload it?

[Necrisrex]

BRILLIANT!!!!

Thank you so much rony!

myisamchk on the data_template_data_rra.MYI caused a full recovery.

Sorry to have been such a dunderhead, I don't have a whole lot of experience as an admin, and didn't even realise the tables were reparable until you mentioned it. A quick look through the MySQL documentation and BAM!

myisamchk to the rescue.

Much appreciation is sent your way, this just saved me redoing two weeks worth of data entry and moving (export/import) template files.

Thanks again,
Necris Rex.