[rrd-users] Re: [OT] - Get versus Getnext

Simon Mullis Simon.Mullis at equinoxsolutions.com
Thu Feb 20 18:46:13 MET 2003


Thomas,

Well spotted!

The OID in the response in incremented by 1 for every getnext I do but the
only meaningful result come from a getnext on .16. (which gives .17. in the
response).
I am unable to do a successful GET on any of the OIDs.

Is there something specifically weird with this MIB?  Has anyone come across
anything similar?


FYI - 
.16. = .1.3.6.1.4.1.311.1.4.1.1.2.1.16.8.72.69.65.84.95.83.81.76
.17. = .1.3.6.1.4.1.311.1.4.1.1.2.1.17.8.72.69.65.84.95.83.81.76

>From the MIB (mssql.mib.txt)

  MssqlSrvInfoEntry ::=
      SEQUENCE {
          mssqlSrvInfoServerName          
              DisplayString,
          mssqlSrvInfoStartupTime         
              DisplayString,
          mssqlSrvInfoTrans               
              Gauge,
          mssqlSrvInfoPageReads           
              Counter,
          mssqlSrvInfoSinglePageWrites    
              Counter,
          mssqlSrvInfoBatchWrites         
              Counter,
          mssqlSrvInfoLazyWrites          
              Counter,
          mssqlSrvInfoLogWrites           
              Counter,
          mssqlSrvInfoOutstandingReads
              Counter,
          mssqlSrvInfoOutstandingWrites
              Counter,
          mssqlSrvInfoCacheHitRatio       
              Gauge,
          mssqlSrvInfoFreeBuffers         
              Gauge,
          mssqlSrvInfoNetworkReads        
              Counter,
          mssqlSrvInfoNetworkWrites       
              Counter,
          mssqlSrvInfoRAPhysicalReads        
              Counter,
          mssqlSrvInfoUserConnections     
              Gauge,
          mssqlSrvInfoTotalLocks          
              Gauge,
          mssqlSrvInfoTotalBlockingLocks  
              Gauge,
          mssqlSrvInfoUsersBlocked        
              Gauge
      }

<snip>

  mssqlSrvInfoUserConnections OBJECT-TYPE
      SYNTAX Gauge
      ACCESS read-only
      STATUS mandatory
      DESCRIPTION
           "The number of open user connections."                      
      ::= { mssqlSrvInfoEntry 16 }

<snip>


(I know this is getting more off-topic with every mail.  I thank you all for
your patience)

Thanks

SM

-----Original Message-----
From: Thomas Erskine [mailto:thomas.erskine at sympatico.ca]
Sent: 20 February 2003 17:29
To: Simon Mullis; rrd-users at list.ee.ethz.ch
Subject: Re: [rrd-users] [OT] - Get versus Getnext


At 11:52 2003-02-20, Simon Mullis wrote:
 >
 >Afternoon, all...
 >
 >Apologies for the slightly off-topic post...
 >
 >Using MRTG I would like to query the MSSQL mssqlSrvInfoUserConnections OID
 >(.1.3.6.1.4.1.311.1.4.1.1.2.1.16)
 >
 >Doing a walk / getnext on the above OID using (insert your favourite MIB
 >browser here) I get a reponse along with a system specific OID:
 >
 >[user at host]$ snmpgetnext -v2c <hostname> <community>
 >.1.3.6.1.4.1.311.1.4.1.1.2.1.16
 >enterprises.311.1.4.1.1.2.1.17.8.72.69.65.84.95.83.81.76 = Gauge32: 43

16 != 17  Look again at the response.

 >Using the OID in the reponse, I assume that I should be able to perform a
 >simple snmp get on it to get the data I require.
 >
 >BUT:
 >
 >[user at host]$ snmpget -v2c <hostname> <community>
 >.1.3.6.1.4.1.311.1.4.1.1.2.1.16.8.72.69.65.84.95.83.81.76

Try it with the actual OID you got in the response.

 >Error in packet
 >Reason: (noSuchName) There is no such variable name in this MIB.
 >Failed object: enterprises.311.1.4.1.1.2.1.16.8.72.69.65.84.95.83.81.76
 >
 >
 >Two questions:
 >
 >1. Does anyone have any idea as to why this is the case?
 >
 >2. Can I make MRTG do a getnext instead of a get? (I think I know that
this
 >is a no).
 >
 >I have tried both SNMPv1 and v2c.
 >I have tried appending .0 .1 .2 etc to the end of the OID.
 >
 >Please help!!
 >
 >Many thanks in advance for any insight anyone may give me.
 >
 >Kind Regards,
 >
 >SM
 >
 >
 >
 
>---------------------------------------------------------------------------
-
 >--------------
 >Equinox Converged Solutions Limited.
 >Tel: +44 (0)1252 405 600
 >http://www.equinoxsolutions.com
 >
 >IMPORTANT NOTICE:
 >This message is intended solely for the use of the Individual or
 >organisation to whom it is addressed. It may contain privileged or
 >confidential information.  If you have received this message in error,
 >please notify the originator immediately.
 >If you are not the intended recipient, you should not use, copy, alter, or
 >disclose the contents of this message.  All information or opinions
 >expressed in this message and/or any attachments are those of the author
and
 >are not necessarily those of Equinox Converged Solutions Limited.
 >Equinox Converged Solutions Limited accepts no responsibility  for loss or
 >damage arising from its use, including damage from virus.
 
>---------------------------------------------------------------------------
-
 >--------------
 >
 >--
 >Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
 >Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
 >Archive     http://www.ee.ethz.ch/~slist/rrd-users
 >WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi

Thomas Erskine <thomas.erskine at sympatico.ca> +1.613.591.8490



------------------------------------------------------------------------------------------
Equinox Converged Solutions Limited.
Tel: +44 (0)1252 405 600
http://www.equinoxsolutions.com

IMPORTANT NOTICE:
This message is intended solely for the use of the Individual or organisation to whom it is addressed. It may contain privileged or confidential information.  If you have received this message in error, please notify the originator immediately.
If you are not the intended recipient, you should not use, copy, alter, or disclose the contents of this message.  All information or opinions expressed in this message and/or any attachments are those of the author and are not necessarily those of Equinox Converged Solutions Limited.
Equinox Converged Solutions Limited accepts no responsibility  for loss or damage arising from its use, including damage from virus.
------------------------------------------------------------------------------------------

--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi



More information about the rrd-users mailing list