Thold on interface still multiply by 8 (#361)

[nicolapiazzi]

Hi
I am experiencing error 361 that is not solved for me
I installed this morning latest cacti 1.2.9 and latest develop thold from github into a centos8 fresh installation with latest stable php and mysql
values defined into thold are multiplied by 8 and if i introduce a cdef doing nothing thold value is correct but it divide by 8 device value

[netniV]

This is a known issue on Github.

[nicolapiazzi]

Yes, but on github is masked as RESOLVED and it is not so

[netniV]

I would suggest posting your above findings then and asking to reopen it.

[nicolapiazzi]

Already done but was no considered

[TheWitness]

This primarily impacts network interface graphs where the data stored in the RRD is in 'octets/bytes' and some people prefer representing the graphs in 'bits'.

[HorridFlyer]

In my case, for bytes-based graphs, I can make thresholds work properly by setting CDEF=Exact-Value and translating Hi/Low thresholds in bytes too; this can be ok for new thresholds, despite the fact it is odd to set hi/low thresholds in bytes for graphs that are represented in bits/s.
But what about imported threshold from older cacti versions? I have hundreds that are not working because of this, and I really don't want to modify all of them one by one! I'm now trying to do that directly in the DB, hope not to mess it up!

[HorridFlyer]

Ok I did it directly in the db.
Of course It would have been easier if I had my thresholds generated via template, in that case I would have modified that template and then performed the "Propagate Template" action on each threshold, but this was not the case. So this is what I did:

Code: Select all

UPDATE thold_data SET thold_hi=thold_hi/8, thold_low=thold_low/8, data_type=0 where data_type=1 and cdef=2;

I set data_type=0(Exact-Value) and divided by 8 actual hi/low values for all of those thresholds with data_type=1(CDEF) and cdef=2(Turn Bytes into Bits).

[HorridFlyer]

Please forget about what I wrote in the previous posts, that was not a solution to the problem, I apologize.
I reopened issue #416 on git, where at least I described a workaround that seems to be working for me at the moment.

[jinju]

Attn: HORRIDFLYER
Sir, I have an issue in Threshold in cacti 1.2.13. Here I'm getting warning/threshold alert immediately. I have posted an issue on forum. I didn't get the answer. Can you help me.

viewtopic.php?f=17&t=61304