[mrtg] tracking a MIB with words in it?

[Michael W. Lucas]

Hello,

I recently installed the SNMP-informant.com SQL server pack, and found
the info I need to track with MRTG.  Unfortunately, these MIBs have
words in them.  A snmpwalk shows:

INFORMANT-SQLSERVER::ssdActiveTransactions.1."msdb" = Gauge32: 0
INFORMANT-SQLSERVER::ssdActiveTransactions.1."pubs" = Gauge32: 0
INFORMANT-SQLSERVER::ssdActiveTransactions.1."model" = Gauge32: 0
INFORMANT-SQLSERVER::ssdActiveTransactions.1."_Total" = Gauge32: 0
INFORMANT-SQLSERVER::ssdActiveTransactions.1."master" = Gauge32: 0
INFORMANT-SQLSERVER::ssdActiveTransactions.1."tempdb" = Gauge32: 0
INFORMANT-SQLSERVER::ssdActiveTransactions.1."Northwind" = Gauge32: 0

I can pull individual values using net-snmp simply enough:

# snmpwalk -v 1 -c <community> <hostname> .1.3.6.1.4.1.9600.1.3.27.1.2.1.\"msdb\"
INFORMANT-SQLSERVER::ssdActiveTransactions.1."msdb" = Gauge32: 0

How can I enter this in a MRTG configuration?

For example, to pick on the "msdb" database, using either "msdb" or
msdb without quotes generates a MRTG error:

ERROR: Target[mshost.ssdacttransmsdb][_OUT_] '.1.3.6.1.4.1.9600.1.3.27.1.2.1.msdb&.1.3.6.1.4.1.9600.1.3.27.1.2.1.msdb:idthosting at mshost' (warn): Array found where operator expected at (eval 40) line 1, at end of line

Trying a backslash-escape on the quotes gives me a different error:

WARNING: Could not match host:'community at mshost' ref:'Descr' key:'"msdb\"'
ERROR: Target[mshost.ssdacttransmsdb][_IN_] '.1.3.6.1.4.1.9600.1.3.27.1.2.1.\"msdb\"&.1.3.6.1.4.1.9600.1.3.27.1.2.1. $target->[15]{$mode} ' (kill): Can't find string terminator '"' anywhere before EOF at (eval 39) line 1.

Surely someone has dealt with this before?

Any suggestions would be appreciated.

Thanks,
==ml

-- 
Michael W. Lucas	mwlucas at FreeBSD.org, mwlucas at BlackHelicopters.org
		http://www.BlackHelicopters.org/~mwlucas/

"The cloak of anonymity protects me from the nuisance of caring." -Non Sequitur

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