[mrtg] Re: Sql user connections

[Dijk, Sebastian van]

Hi Eric, 

Well that's what i've done first :)...if the small one doesnt work, try
the long one ;)

However, if i try that :

SNMP Error:
Received SNMP response with error code
  error status: noSuchName
  index 1 (OID:
1.3.6.1.4.1.311.1.4.1.1.2.1.16.12.83.81.76.95.83.69.82.86.69.82.
48.49)
SNMPv1_Session (remote host: "192.168.10.30" [192.168.10.30].161)
                  community: "read_vecozo"
                 request ID: 1270785581
                PDU bufsize: 8000 bytes
                    timeout: 2s
                    retries: 5
                    backoff: 1)
 at D:/BEHEER/MRTG/mrtg-2.11.1/bin\..\lib\mrtg2/SNMP_util.pm line 490
SNMPGET Problem for
.1.3.6.1.4.1.311.1.4.1.1.2.1.16.12.83.81.76.95.83.69.82.86.6
9.82.48.49
.1.3.6.1.4.1.311.1.4.1.1.2.1.16.12.83.81.76.95.83.69.82.86.69.82.48.4
9 sysUptime sysName on read_vecozo at 192.168.10.30::::::v4only
 at mrtg line 1849
ERROR: Target[sql_users_sql01][_IN_] ' $target->[0]{$mode} ' did not
eval into d efined data
ERROR: Target[sql_users_sql01][_OUT_] ' $target->[0]{$mode} ' did not
eval into defined data
 


Met vriendelijke groet, 
 
 
Sebastian van Dijk
Systeembeheer
 

-----Oorspronkelijk bericht-----
Van: mrtg-bounce at list.ee.ethz.ch [mailto:mrtg-bounce at list.ee.ethz.ch]
Namens Eric Brander
Verzonden: woensdag 21 september 2005 16:14
Aan: mrtg at list.ee.ethz.ch
Onderwerp: [mrtg] Re: Sql user connections

Dijk, Sebastian van wrote:

>As i am getting a bit more familiar with the "snmp troubles" i am now 
>trying to monitor our "SQL user connections" :)
> 
>With GETIF i found that i need to use ".1.3.6.1.4.1.311.1.4.1.1.2.1.16"
>to monitor the amount of "sql user connections'.
> 
>When i enter this ID in snmp walk i get a bit weird result (you should 
>only expect the value that's been read)
> 
>D:\snmpwalk>snmpwalk ipadres community .1.3.6.1.4.1.311.1.4.1.1.2.1.17
>--> ENTER
>.iso.3.6.1.4.1.311.1.4.1.1.2.1.17.12.83.81.76.95.83.69.82.86.69.82.48.4
>9
>= Gauge
>: 111
> 
>So it does work, it measures 111 SQL user connections.
>However what is that strange ID i get on the 2nd line ?
>If i use that one with snmp walk i get no result.
> 
>  
>
SNMPWalk "walks" the OID tree and reports everything below it.  SNMPGet
gets a specific OID, which is also what MRTG does. So, use that long OID
in your config file and MRTG should graph it just fine.

G'luck!

Eric Brander

--
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



--
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