snmpgetnext Data Input Method?

Rodre · Joined: 22 Jul 2005 Posts: 29

Hello,

I don't know if this question has been asked before, I can't search the forums because it comes up with a "duplicate key" error. I need snmpgetnext as a Data Input method. I can see the binary is found under the Settings-> Paths -> snmpgetnext Binary Path area, but no snmpgetnext Data Input Method. I sifted through the source but couldn't find no simple method to enable it in the "Data Input Method" drop down when I go to add a new data template, but I am no programmer. Is there any native snmpgetnext support in Cacti? Is there anyway I can add it in, outside of writing a script? Has anyone done this before?

~Rodre

gandalf · Posted: Wed Oct 29, 2008 2:24 pm Post subject:

snmpgetnext is automatically used when calling snmpwalk. Please tell us about your use-case for snmpgetnext
Reinhard

Rodre · Joined: 22 Jul 2005 Posts: 29

HI,

My use case is the classic MS-SQL 2k counters. I realize that TheWitness created a perl script to do the same thing, but I couldn't get it to run. I was missing some perl lib and when I installed it, it still didn't work. I have since created my own script but although the values on the command line come back correct, they appear multiplied by 100k or more in the graphs.

~Rodre

gandalf · Posted: Mon Nov 03, 2008 4:10 pm Post subject:

So what about tackling that issue? A screenshot and the command output will help
Reinhard

Rodre · Joined: 22 Jul 2005 Posts: 29

Hello,

This is the script output:

OutstandingReads:0 OutstandingWrites:0 CacheHitRatio:0 FreeBuffers:0 UserConnections:172 TotalLocks:165 TotalBlockingLocks:0 UsersBlocked:0

Here is the graph. I have the Graph Template items GPrint Type set to exact numbers but it still doesn't help.

gandalf · Posted: Sun Nov 09, 2008 11:07 am Post subject:

Fine. Now I need "rrdtool info <rrd file>" from the rrd file in question
Reinhard

Rodre · Joined: 22 Jul 2005 Posts: 29

Hi,

I appreciate your help with this issue. Here is the rrdtool info from two of the .rra files in question:

filename = "db1_somehost_com_mssqltotallocks_116.rrd"
rrd_version = "0003"
step = 300
last_update = 1225182004
ds[mssqlTotalLocks].type = "GAUGE"
ds[mssqlTotalLocks].minimal_heartbeat = 600
ds[mssqlTotalLocks].min = 0.0000000000e+00
ds[mssqlTotalLocks].max = NaN
ds[mssqlTotalLocks].last_ds = "U"
ds[mssqlTotalLocks].value = NaN
ds[mssqlTotalLocks].unknown_sec = 4
rra[0].cf = "AVERAGE"
rra[0].rows = 500
rra[0].cur_row = 13
rra[0].pdp_per_row = 1
rra[0].xff = 5.0000000000e-01
rra[0].cdp_prep[0].value = NaN
rra[0].cdp_prep[0].unknown_datapoints = 0
rra[1].cf = "AVERAGE"
rra[1].rows = 600
rra[1].cur_row = 13
rra[1].pdp_per_row = 1
rra[1].xff = 5.0000000000e-01
rra[1].cdp_prep[0].value = NaN
rra[1].cdp_prep[0].unknown_datapoints = 0
rra[2].cf = "AVERAGE"
rra[2].rows = 700
rra[2].cur_row = 1
rra[2].pdp_per_row = 6
rra[2].xff = 5.0000000000e-01
rra[2].cdp_prep[0].value = NaN
rra[2].cdp_prep[0].unknown_datapoints = 4
rra[3].cf = "AVERAGE"
rra[3].rows = 775
rra[3].cur_row = 0
rra[3].pdp_per_row = 24
rra[3].xff = 5.0000000000e-01
rra[3].cdp_prep[0].value = NaN
rra[3].cdp_prep[0].unknown_datapoints = 4
rra[4].cf = "AVERAGE"
rra[4].rows = 797
rra[4].cur_row = 796
rra[4].pdp_per_row = 288
rra[4].xff = 5.0000000000e-01
rra[4].cdp_prep[0].value = NaN
rra[4].cdp_prep[0].unknown_datapoints = 100
rra[5].cf = "MAX"
rra[5].rows = 500
rra[5].cur_row = 13
rra[5].pdp_per_row = 1
rra[5].xff = 5.0000000000e-01
rra[5].cdp_prep[0].value = NaN
rra[5].cdp_prep[0].unknown_datapoints = 0
rra[6].cf = "MAX"
rra[6].rows = 600
rra[6].cur_row = 13
rra[6].pdp_per_row = 1
rra[6].xff = 5.0000000000e-01
rra[6].cdp_prep[0].value = NaN
rra[6].cdp_prep[0].unknown_datapoints = 0
rra[7].cf = "MAX"
rra[7].rows = 700
rra[7].cur_row = 1
rra[7].pdp_per_row = 6
rra[7].xff = 5.0000000000e-01
rra[7].cdp_prep[0].value = NaN
rra[7].cdp_prep[0].unknown_datapoints = 4
rra[8].cf = "MAX"
rra[8].rows = 775
rra[8].cur_row = 0
rra[8].pdp_per_row = 24
rra[8].xff = 5.0000000000e-01
rra[8].cdp_prep[0].value = NaN
rra[8].cdp_prep[0].unknown_datapoints = 4
rra[9].cf = "MAX"
rra[9].rows = 797
rra[9].cur_row = 796
rra[9].pdp_per_row = 288
rra[9].xff = 5.0000000000e-01
rra[9].cdp_prep[0].value = NaN
rra[9].cdp_prep[0].unknown_datapoints = 100

filename = "db1_somehost_com_mssqltotblocklocks_115.rrd"
rrd_version = "0003"
step = 300
last_update = 1225182004
ds[mssqlTotBlockLocks].type = "GAUGE"
ds[mssqlTotBlockLocks].minimal_heartbeat = 600
ds[mssqlTotBlockLocks].min = 0.0000000000e+00
ds[mssqlTotBlockLocks].max = NaN
ds[mssqlTotBlockLocks].last_ds = "U"
ds[mssqlTotBlockLocks].value = NaN
ds[mssqlTotBlockLocks].unknown_sec = 4
rra[0].cf = "AVERAGE"
rra[0].rows = 500
rra[0].cur_row = 13
rra[0].pdp_per_row = 1
rra[0].xff = 5.0000000000e-01
rra[0].cdp_prep[0].value = NaN
rra[0].cdp_prep[0].unknown_datapoints = 0
rra[1].cf = "AVERAGE"
rra[1].rows = 600
rra[1].cur_row = 13
rra[1].pdp_per_row = 1
rra[1].xff = 5.0000000000e-01
rra[1].cdp_prep[0].value = NaN
rra[1].cdp_prep[0].unknown_datapoints = 0
rra[2].cf = "AVERAGE"
rra[2].rows = 700
rra[2].cur_row = 1
rra[2].pdp_per_row = 6
rra[2].xff = 5.0000000000e-01
rra[2].cdp_prep[0].value = NaN
rra[2].cdp_prep[0].unknown_datapoints = 4
rra[3].cf = "AVERAGE"
rra[3].rows = 775
rra[3].cur_row = 0
rra[3].pdp_per_row = 24
rra[3].xff = 5.0000000000e-01
rra[3].cdp_prep[0].value = NaN
rra[3].cdp_prep[0].unknown_datapoints = 4
rra[4].cf = "AVERAGE"
rra[4].rows = 797
rra[4].cur_row = 796
rra[4].pdp_per_row = 288
rra[4].xff = 5.0000000000e-01
rra[4].cdp_prep[0].value = NaN
rra[4].cdp_prep[0].unknown_datapoints = 100
rra[5].cf = "MAX"
rra[5].rows = 500
rra[5].cur_row = 13
rra[5].pdp_per_row = 1
rra[5].xff = 5.0000000000e-01
rra[5].cdp_prep[0].value = NaN
rra[5].cdp_prep[0].unknown_datapoints = 0
rra[6].cf = "MAX"
rra[6].rows = 600
rra[6].cur_row = 13
rra[6].pdp_per_row = 1
rra[6].xff = 5.0000000000e-01
rra[6].cdp_prep[0].value = NaN
rra[6].cdp_prep[0].unknown_datapoints = 0
rra[7].cf = "MAX"
rra[7].rows = 700
rra[7].cur_row = 1
rra[7].pdp_per_row = 6
rra[7].xff = 5.0000000000e-01
rra[7].cdp_prep[0].value = NaN
rra[7].cdp_prep[0].unknown_datapoints = 4
rra[8].cf = "MAX"
rra[8].rows = 775
rra[8].cur_row = 0
rra[8].pdp_per_row = 24
rra[8].xff = 5.0000000000e-01
rra[8].cdp_prep[0].value = NaN
rra[8].cdp_prep[0].unknown_datapoints = 4
rra[9].cf = "MAX"
rra[9].rows = 797
rra[9].cur_row = 796
rra[9].pdp_per_row = 288
rra[9].xff = 5.0000000000e-01
rra[9].cdp_prep[0].value = NaN
rra[9].cdp_prep[0].unknown_datapoints = 100

gandalf · Posted: Tue Nov 11, 2008 3:28 pm Post subject:

Ok, it's a GAUGE as required. But definitely, the rrd file is broken. It contains two rra's using the same consolidation level. Two questions:
- Do you want to use 1 min polling or 5 min polling?
- Please visit graph management, select the graph and switch to debug. Post a screenshot. I need to know, whether you're using CDEFs
Reinhard

Rodre · Joined: 22 Jul 2005 Posts: 29

Hello,

I am currently using 5 min. polling.

I am not applying a CDEF function (CDEF = None). Did you still need me to post the graph debug screen shot? Thanks for your help.

~Rodre

gandalf · Posted: Wed Nov 12, 2008 3:48 pm Post subject:

Either do this or pm a databasedump along with your script
Reinhard

Rodre · Joined: 22 Jul 2005 Posts: 29

HI,

Here is the screenshot. I think you are right, it looks like a CDEF is being applied even though I have it set to "none"?

gandalf · Posted: Wed Nov 12, 2008 4:37 pm Post subject:

No CDEF issue here.
So I need the database, the script and this very rrd file (exported rrd file using rrdtool xport). Please pm
Reinhard