Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
I have this problem later upgrade to CACTI 0.8.6f from 0.8.6d, when I use graph_edit it don't show inbound and outbound datasource but my graphs follow there, if I save then my graph disappears
Can you export and send me your database in email?
Please refer to this post in your email to me.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
For this particular user, he had problem with corrupted indexes in mysql. You need to run a check/repair on the cacti database. That will probably resolve your issues.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
Yes, looks like I have the very same problem. CHECK on all tables in the cacti database gives me "OK", but OPTIMIZE returned OK for all tables except the following two:
graph_templates_item: Found block that points outside data file at 52644
graph_tree_items: Found block that points outside data file at 1416
However the problem persists, I still have no data sources listed for a graph.
Reindex those tables after you run a repair on them.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
I still have the same problem... Even installing cacti 0.8.6g didn't help. I even completely erased the database, deinstalled cacti and then made a fresh install, but problem is still there!
cacti 0.8.6g (fresh install)
MySQL 4.1.15
PHP 4.4.0
As you can see on the screenshot I've attached, even default graph which comes with new install has this problem. Please help, I do not know what to do, if even installing from scratch doesn't help.
RU Backing up your database? If so, you may have to restore a previous version to recover. I'll leave this one to Tony for now as he should be receiving a database dump.
TheWitness
True understanding begins only when we realize how little we truly understand...
Ok, guys, problem solved! The problem was in MySQL. I restored default MySQL configuration and everything returned to normal. After that it wasn't hard to track configuration changes. I do not know why or how, but here's the MySQL configuration line that causes problems:
When I remove this line, everything works perfect. It seems, that cacti versions prior to 0.8.6f were not prone to this problem. Perhaps developers could comment on this?
