[mrtg] Re: Sql user connections

[Dijk, Sebastian van]

Hi Marcus, 

Tnx for your suggestion but it does not work here :(

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)
SNMPv2c_Session (remote host: "192.168.10.30" [192.168.10.30].161)
                   community: "read_vecozo"
                  request ID: 158604867
                 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
.1.3.6.1.4.1.311.1.4.1.1.2.1
.16 sysUptime sysName on read_vecozo at 192.168.10.30:::::2: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

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

I have a very similar problem yesterday, I used the Snmpv2 switch and it
fixed it..

Target[SQL_USERS_SQL01]:.1.3.6.1.4.1.311.1.4.1.1.2.1.16&.1.3.6.1.4.1.311
.1.4
.1.1.2.1.16:read_vecozo at 192.168.10.30:::::2

Try that.

-----Original Message-----
From: mrtg-bounce at list.ee.ethz.ch [mailto:mrtg-bounce at list.ee.ethz.ch]
On Behalf Of Dijk, Sebastian van
Sent: Wednesday, September 21, 2005 8:54 AM
To: mrtg at list.ee.ethz.ch
Subject: [mrtg] Sql user connections

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.49
= 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.
 
I tried to use the "good ID" in MRTG : 
 
Target[SQL_USERS_SQL01]:
.1.3.6.1.4.1.311.1.4.1.1.2.1.16&.1.3.6.1.4.1.311.1.4.1.1.2.1.16:read_vec
ozo at 192.168.10.30 
 
Then i started it :
D:\BEHEER\MRTG\mrtg-2.11.1\bin>perl mrtg test.txt This gave me this
result : 
 
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.0) SNMPv1_Session (remote
host: "192.168.10.30" [192.168.10.30].161)
                  community: "read_vecozo"
                 request ID: 1624282877
                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.0
.1.3.6.1.4.1.311.1.4.1.1.2
.1.16.0 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
 
What is wrong ??
 
 
 
 
 
Met vriendelijke groet, 
 
 
Sebastian van Dijk
Systeembeheer

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



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