SQL Server 2000

[gymv]

I have been trying to monitor the SQL Server Status via SNMP (i'll write its IP as xxx.xxx.xxx.xxx).
In order to do that I have created a new Item, gave mssqlSrvState as description, set SNMP version to 2, set SNMP community to public, set the SNMP OID to 1.3.6.1.4.1.311.1.4.1.1.1.1.5, and set Type of information as Numeric

However when Zabbix tries to check SQL Status it always shows the message Not supported. I have checked Zabbix log file and I receive the following message:

003896:20061104:153213 SNMP [[email protected]:161:161]
003896:20061104:153213 OID [1.3.6.1.4.1.311.1.4.1.1.1.1.5]
003896:20061104:153213 In get_value_SNMP() 0.2
003896:20061104:153213 In get_value_SNMP() 0.3
003896:20061104:153213 Status send [0]
003896:20061104:153213 In get_value_SNMP() 0.4
003896:20061104:153213 In get_value_SNMP() 1
003896:20061104:153213 SNMP error in packet. Reason: (noSuchName) There is no such variable name in this MIB.

003896:20061104:153213 SNMP error [(noSuchName) There is no such variable name in this MIB.]

Besides that message, when I run snmpwalk to check that MIB, I receive the following output:

$ snmpwalk -v2c -c public xxx.xxx.xxx.xxx 1.3.6.1.4.1.311.1.4.1.1.1.1.5
SNMPv2-SMI::enterprises.311.1.4.1.1.1.1.5.21.77.105.99.11 4.111.115.111.102.116.32.67.111.114.112.111.114.97 .116.105.111.110 = INTEGER: 1

I think that the SNMPWALK output means that the MIB exists and is running, besides the message I receive from Zabbix.

Can anyone help with this problem?

Gus

[cameronsto]

When you set the SNMP OID do you have a period at the beginning like '.1.3.6.1.4'?

-cameron

[gymv]

SQL Server 2000

I have tried both formats (with a "." and without a ".") in both programs (zabbix and snmpwalk).
I have got the same results in both programs.

[gymv]

It's been almost 3 months since my last post in this subject.

I have noticed that if I use the command snmpget instead of snmpwalk, I receive the same message that zabbix receives:
snmpget -v2c -c public x.x.x.x 1.3.6.1.4.1.311.1.4.1.1.1.1.5
Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
Failed object: SNMPv2-SMI::enterprises.311.1.4.1.1.1.1.5

However if I use snmpgetnext, I receive a response from SQL MIB:
snmpgetnext -v2c -c public x.x.x.x 1.3.6.1.4.1.311.1.4.1.1.1.1.5
SNMPv2-SMI::enterprises.311.1.4.1.1.1.1.5.21.77.105.99.11 4.111.115.111.102.116.32.67.111.114.112.111.114.97 .116.105.111.110 = INTEGER: 1

I think that it is related to the method used by Zabbix to get the value from the MIB. Is it possible to change the method from "get" to "getnext" (method that snmpwalk uses)?


In order to solve this problem, I had to do the following steps:
- I have installed zabbix_agentd on my server
- than I have created a script that runs snmpwalk to get the status from my SQL Server
- extended the zabbix_agentd, by adding a new key on zabbix_agentd.conf to run my script
- Now I check SQL Status when zabbix server asks zabbix agent to run my script.

[Alexei]

I guess getnext will require more resources. I don't know why snmpget doesn't work while snmpget does. Unfortunately I do not have a SNMP device available which behaves like this.