bulk conversion of 32 bit counters into 64 bit counters

kekti · Post by **kekti** » Mon Jun 22, 2009 4:16 am

Hi Forumusers,

I have a large number of data sources which currently use 32 bit counters and should use 64 bit counters instead.

Does anyone of you know a quick way to convert a huge number of data sources into 64 bit?

I googled around and found one method to convert into 64bit below:
Step1: Modify all traffic data sources: change "Maximum Value" to 1000000000
and change the "Output Type ID" to "In/Out Bits (64-bit Counters)"

Step2: Change maximum values in the rrds using rrdtool:

rrdtool tune <file.rrd> -a traffic_out:1.0e+09 -a traffic_in:1.0e+09

Step2, can easily be done for a lot of data sources in one go. Step1 on the other hand takes a lot of manual work. I browsed through the sql database of cacti to find the corresponding values. Unfortunately I couldn't find the output type ID and max value. Is this something that is registered in mysql?

Any help on automating the conversion is greatly appreciated.

thanks!

BSOD2600 · Post by **BSOD2600** » Mon Jun 22, 2009 12:27 pm

Step 3: 32bit and 64bit counters use different OIDs. ifInOctets vs ifHCInOctets, etc.

kekti · Post by **kekti** » Tue Jun 23, 2009 12:25 am

@BSOD2600: Do you know where (in mysql?) the value's are kept for step 1 and 3?

I hope to change them via another way than cacti. This can save me a huge pile of mouse clicks.

Post by **gandalf** » Tue Jun 23, 2009 3:01 pm

I understand your problem. Surely, this is doable. I tried so about a year ago. You won't want to here the full story on how I had to backout my broken change. And I _was_ under the false assumption to understand what I was doing.
Again. This _is_ doable.
But there will be no official support for that. You will have to figure out on your own. Sorry for that
Reinhard

kekti · Post by **kekti** » Tue Jul 14, 2009 7:28 am

I really don't care about the historical data anymore at this point of time. I just want to bulk change all 32-bit counters to 64-bit. The cacti setup overhere is a mess. I have to dive into each data source just to check if it's a 32 or 64 bit counter and change them by hand.

Is there at least a way of selecting all 32 bit counters so I know which one to change and which one not to change?

thanks

bpowers7 · Post by **bpowers7** » Fri Sep 18, 2009 2:46 pm

I too am looking to make this change to about 800 items in my cacti config.
Would really love to understand an easy way to assocaite the "Output Type ID" of "In/Out Bits (64-bit Counters)" to these 800+ interfaces that currently are set to use the 32-bit version.

RRDTool will update the .rrd files, but what about the UI configuraiton?
Anyone had any luck crafting a SQL statement?

kekti · Post by **kekti** » Mon Sep 21, 2009 1:57 am

I have searched through the mysql database structure but unfrotunately can not find the correct field which contains the counter type.

What would happen if I would change all the 32bit counters via the UI to 64 and leave the rest alone? I don't mind that the historical data is not accurate, I just want the data in the future to be correct.

borrows123 · Post by **borrows123** » Thu May 06, 2010 2:14 am

It not a big deal...
You should have to contact with your service provider...
They will give you the best solution.....
Consult them and solve it..

Sirup · Post by **Sirup** » Thu May 06, 2010 2:36 am

borrows123 wrote:It not a big deal...
You should have to contact with your service provider...
They will give you the best solution.....
Consult them and solve it..

Just delete this fake user please.

Nevertheless that this is a old topic: http://forums.cacti.net/viewtopic.php?t=36120

Cacti

bulk conversion of 32 bit counters into 64 bit counters

bulk conversion of 32 bit counters into 64 bit counters

Any update?

Who is online