[mrtg] Re: Monitoring SQL

[Adrian Mink]

I tried adding the trailing zeros, I have also loaded the mib file for MSSQL
using the loadmib 
directive. Here is a copy of the config I am using again. I am still getting
the "nosuchname" snmp error. If I understand the loadmib directive, you need
one statement per OID? Even if the two values are contained in the same mib
file? Thanks.


####################################################################
# MRTG CONFIG FILE - SQL INFORMATION
# SERVER: SiteServer
####################################################################

Title[^]: Page Reads and Writes on SQL Server on Siteserver:
PageTop[SITESERVER]: <div align="center"><center>

 <table border="1" width="98%" height="87">
  <tr>
    <td width="76%" height="52"><p align="center"><strong><font
face="Arial"><big>Page Reads   and Writes on SQL on
&quot;SITESERVER&quot;</big></font></strong></td>
    </tr>
  <tr>
    </tr>
 </table>
 </center></div>

NoMib2: Yes
LoadMIBs:
/usr/local/mrtg-2.9.7/mib/MSSQL.MIB,/usr/local/mrtg-2.9.7/mib/MSSQL.MIB
Target[SITESERVER]:1.3.6.1.4.1.311.1.4.1.1.2.1.4.0&
1.3.6.1.4.1.311.1.4.1.1.2.1.5.0:public at 192.168.35.27
MaxBytes[SITESERVER]: 1000
WithPeak[SITESERVER]: ymd
Title[SITESERVER]: SQL on Siteserver
Options[SITESERVER]: gauge, nopercent, growright
Unscaled[SITESERVER]: dwmy
#Supress[SITESERVER]:dwmy
XSize[SITESERVER]: 380
YSize[SITESERVER]: 100
YLegend[SITESERVER]: Page Reads and Writes
ShortLegend[SITESERVER]: Reads/Writes
Legend1[SITESERVER]: Page Reads
Legend2[SITESERVER]: Page Writes
Legend3[SITESERVER]: Maximal 5 Minute Reads 
Legend4[SITESERVER]: Maximal 5 Minute Writes
LegendI[SITESERVER]: Reads: 
LegendO[SITESERVER]: Writes: 

-----Original Message-----
From: cpt2 at daimlerchrysler.com [mailto:cpt2 at daimlerchrysler.com]
Sent: Monday, February 12, 2001 3:01 PM
To: mrtg at list.ee.ethz.ch
Subject: Re: [mrtg] Re: Monitoring SQL





Sent by:  mrtg-bounce at list.ee.ethz.ch


To:   "Mrtg (E-mail)" <mrtg at list.ee.ethz.ch>
cc:
Subject:  [mrtg] Re: Monitoring SQL


Adrian, try adding a trailing 0 to the to OIDs like this:

Target[SITESERVER]:1.3.6.1.4.1.311.1.4.1.1.2.1.4.0&1.3.6.1.4.1.311.1.4.1.1.2
.1

.5.0:public at 192.168.35.27



OK, doing a snmpwalk of the system and I do not see the value I want to
query. But I can query it with getif from a different system and get the
response. I did not see anything in the MRTG docs about having to compile
in
MIB's, do you have to? (Since this is not a standard value I am accessing.)
I did have to for getif. Thanks for you patience, this is driving me up a
wall.

-----Original Message-----
From: Paul C. Williamson [mailto:pwilliamson at MANDTBANK.COM]
Sent: Monday, February 12, 2001 2:23 PM
To: Adrian.Mink at fidata.com; mrtg at list.ee.ethz.ch
Subject: [mrtg] Re: Monitoring SQL



--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Archive     http://www.ee.ethz.ch/~slist/mrtg
FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi