[SOLVED] Lower limit and upper limit variable support

llow · Cacti User Joined: 05 Oct 2007 Posts: 88

It would be nice to be able to dynamicaly set the lower and upper limits through query or other variables.

The database structure would probably need to change lower_limit and upper_limit to a varchar(255).

I can work up a patch for 0.8.7 for this if anyone else thinks its a good idea.

rony · Posted: Fri Oct 12, 2007 3:20 pm Post subject:

Yep, it would be nice.

The only problem, and the reason it has yet to be implemented, is that updates to the RRDTool file are not made by Cacti once the file is created.

But to be honest, if you are going have dynamic variables, I would only want to apply them to the graph output.

Let's think of this, what if a max value where to be passed and applied to the data source, then the RRDTool file was updated, but this value was below past maximum values in the RRDtool file. Would those maximum values be retained or trimmed in the RRDtool file?

FYI, I want you to write this patch, I want to see what you come up with.

But I want you to think about the above issues.

Thanks for reading my ramblings!

llow · Cacti User Joined: 05 Oct 2007 Posts: 88

I'll put something together. I am only planning on such functionality for the graphing portion as I would think most people would be using them for thresholds.

llow · Cacti User Joined: 05 Oct 2007 Posts: 88

Here is the patch.

Will need to increase varchar size as well to be useful...
ALTER TABLE graph_templates_graph MODIFY lower_limit VARCHAR(255);
ALTER TABLE graph_templates_graph MODIFY upper_limit VARCHAR(255);

rony · Posted: Sat Oct 13, 2007 11:48 am Post subject:

Please post a bug/feature for this, it easier for us to track.

gandalf · Posted: Mon Feb 04, 2008 10:47 am Post subject:

Implemented in SVN, targeted release is 088
Reinhard