Cannot graph MSSQL -SNMP Query returns "U"

[axelilly]

I am trying to graph the following OID on a MS SQL server:
.1.3.6.1.4.1.311.1.4.1.1.2.1.16

I have turned on DEBUG in the log file and see the following entries:

08/04/2005 12:22:24 PM - CMDPHP: Poller[0] Host[2] DS[625] SNMP: v1: sql2, dsname: mssqlopenuser, oid: .1.3.6.1.4.1.311.1.4.1.1.2.1.16, output: U

I know that this means that the response was invalid, but I can't figure out why it is being considered invalid. When I run it using SNMPWALK, I get a response that says:
GAUGE32: 188

Can anyone help me out on this one? I'm really stumped.

Thanks in advance.

[BSOD2600]

Run snmpget on that OID, it won't return anything. Pay attention to the OID snmpwalk got. You're likely missing another number.

[axelilly]

Ok, you are right:

I can get data back if using snmpwalk but if I query the same OID with snmpget, I get an error: Error in Packet, Reason: There is no such variable name in this MIB.

But now I'm really confused...

Why does it work in walk but not with get? What is the difference? Also, in the MIB it states that it is a "TABULAR" OID, what does that mean and could that be causing this? Here is the URL to my MIB reference so that you can see it yourself:

http://www.mibdepot.com/cgi-bin/xsearch ... gi?id=9217

Is there a way to get this to work within Cacti?

Thanks for your help on this issue. I look forward to not being confused any more

[BSOD2600]

Once again, snmpwalk starts with .1.3.6.1.4.1.311.1.4.1.1.2.1.16 and keeps increasing the last OID number. snmpget simply fetches the single OID you gave it. I suggest you use GetIF and take a look what OIDs are valid, since the output of snmpwalk confuses you.

[adrian]

and the oid is right.
cacti creates the rrd, but on the graph is "nan"
and in the cacti log is "U"

did anybody have problems with MSSQL and CACTI?
has anybody notice incompatibilities?


thank you,
Adrian

[BSOD2600]

Turn the polling level in cacti to debug (Settings | Polling level) for one cycle and paste the output of the actual log file (./cacti/log/cacti.log). If it contains WEBLOG entries, then don't bother posting since they just clutter up the log. Turn off WEBEVENTS logging and try again.

The only 'incompatability' with cacti and mysql is that newer php versions no longer include the newer mysql client libraries. one must use the 'old password trick', which is outlined in the guide in my signature to make it work.

[Frodoger]

does anyone has help ?

The OID is: .1.3.6.1.4.1.311.1.4.1.1.2.1.17

GetIf says:

Code: Select all

.iso.org.dod.internet.private.enterprises.microsoft.software.apps.mssqlServer.mssqlServerObjects.mssqlSrvInfoTable.mssqlSrvInfoEntry.mssqlSrvInfoTotalLocks

or:

Code: Select all

.1.3.6.1.4.1.311.1.4.1.1.2.1.17.11.82.90.45.90.45.83.81.76.45.48.49

SNMPWALK says:

Code: Select all

snmpwalk  -v2c -cXXXX XXX.XXX.XXX.XXX .1.3.6.1.4.1.311.1.4.1.1.2.1.17.11.82.90.45
SNMPv2-SMI::enterprises.311.1.4.1.1.2.1.17.11.82.90.45.90.45.83.81.76.45.48.49 = Gauge32: 10

SNMPGET says:

Code: Select all

 snmpget  -v2c -cXXXX XXX.XXX.XXX.XXX .1.3.6.1.4.1.311.1.4.1.1.2.1.17.11.82.90.45
Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
Failed object: SNMPv2-SMI::enterprises.311.1.4.1.1.2.1.17.11.82.90.45

What must i do to get a graph in cacti????

Like adrian i also get only an "nan" or "0" in my MSSQL Server graphs

PLZ help.

[BSOD2600]

And like Adrian, you must use the correct OID for cacti. In this case it appears .1.3.6.1.4.1.311.1.4.1.1.2.1.17.11.82.90.45.90.45.83.81.76.45.48.49 is valid.

What OID are you having cacti use?
What error in the cacti log?

[Frodoger]

the cacti log says:

Code: Select all

03/27/2006 08:01:33 PM - CACTID: Poller[0] Host[34] SNMP: v2: 172.22.1.50, dsname: snmp_oid, oid: .1.3.6.1.4.1.311.1.4.1.1.2.1.17.11.82.90.45.90.45.83.81.76.45.48, value: U  
03/27/2006 08:01:33 PM - CACTID: Poller[0] Host[34] WARNING: Result from SNMP not valid. Partial Result: U...  
03/27/2006 08:01:33 PM - CACTID: Poller[0] Host[34] SNMP: v2: 172.22.1.50, dsname: snmp_oid, oid: .1.3.6.1.4.1.311.1.4.1.1.2.1.17.11.82.90.45.90.45.83.81.76.45.48.49, value: U  

greetings
Frodoger

[BSOD2600]

the cacti log says:

Code: Select all

03/27/2006 08:01:33 PM - CACTID: Poller[0] Host[34] SNMP: v2: 172.22.1.50, dsname: snmp_oid, oid: .1.3.6.1.4.1.311.1.4.1.1.2.1.17.11.82.90.45.90.45.83.81.76.45.48, value: U  
03/27/2006 08:01:33 PM - CACTID: Poller[0] Host[34] WARNING: Result from SNMP not valid. Partial Result: U...  
03/27/2006 08:01:33 PM - CACTID: Poller[0] Host[34] SNMP: v2: 172.22.1.50, dsname: snmp_oid, oid: .1.3.6.1.4.1.311.1.4.1.1.2.1.17.11.82.90.45.90.45.83.81.76.45.48.49, value: U  

Well that doesn't make any sense because thats the OID which snmpwalk returned valid data on. You polling the same device you posted the snmpwalk from? You tell cacti to use snmpv2 for that device?

[@L1 g]

I'm actually having the same exact problem on 2 MS SQL servers. I can do both a "snmpwalk" and a "snmpgetnext" and get data back, but when I do an "snmpget" I get the "Error in packet" error. I've seen people on other sites say that Microsoft never fully implemented the SNMP for SQL correctly, but I'm not sure if that's true or not. If anyone has a solution for this I would definitely appreciate it. I'm guessing that if someone could write a script using "snmpgetnext" it might work... but just a thought.

[Cylindric]

I'm getting exactly the same problem. Even copy'n'pasting the OIDs from snmpwalk into snmpget doesn't work.
(http://forums.cacti.net/viewtopic.php?t=22437)

[Cylindric]

Oops, sorry, didn't mean to necro-post this, it's a bit old. I found it from a Google search. Feel free to delete my 2 posts, I'm not sure what the policy is regarding moderation

[TFC]

Altough I dont use snmp i get "U" value as result. i saw in log file.
Anf it occurs for some specific server.

12/14/2011 05:20:08 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/tsantalya2_disk_total_732.rrd --template disk_total:disk_used 1323876002:U:U
12/14/2011 05:20:08 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/tsantalya2_disk_total_733.rrd --template disk_total:disk_used 1323876002:U:U

i need an idea.
bec i dont know what does "U" mean..

[BSOD2600]

With 700+ posts here, you haven't run across what U means yet? Refer to the rrdtool update manual - http://oss.oetiker.ch/rrdtool/doc/rrdupdate.en.html for the definition.