SNMP v3

Setup

To enable the SNMPv3 extension, go to the “Server”->“Server extensions” menu in the dbWatch Monitor. Here you will find an entry called “SNMP extension”, select this and click “Configure” on the toolbar.

This will bring up thefollowing configuration dialog

The values here are:

When you are satesfied with the settings, click OK.

Then select the SNMP extension again, and click Enable.

Test

If you click on Test the extention will attempt to send two Traps. A lost connection signal (for an instance called test database 1 and a warning for an alert called test check 2 on test database 2. Verify that you received these in your Trap receiver.

dbWatch MIB

DBWATCH DEFINITIONS ::= BEGIN

    IMPORTS
    	  IpAddress,
          MODULE-IDENTITY,
          OBJECT-TYPE,
          Integer32,
          snmpModules
              FROM SNMPv2-SMI  
          RowStatus,
          StorageType
              FROM SNMPv2-TC
          SnmpAdminString,
          SnmpEngineID
              FROM SNMP-FRAMEWORK-MIB
          SnmpTagValue,
          snmpTargetAddrEntry
              FROM SNMP-TARGET-MIB
          MODULE-COMPLIANCE,
          OBJECT-GROUP
              FROM SNMPv2-CONF;

dbwatch MODULE-IDENTITY 
     LAST-UPDATED "201104060000Z"   
     ORGANIZATION "dbWatch Software"
     CONTACT-INFO "email:   support@dbwatch.com"
     DESCRIPTION "dbWatch MIB"
 ::= { snmpModules 62349 }


dbwDatabaseName OBJECT-TYPE
	 SYNTAX  DisplayString (SIZE (0..255))
       ACCESS  read-only
       STATUS  mandatory
       DESCRIPTION
            "The name of a monitored database."
        ::= { dbwatch 10 }

dbwCheckName OBJECT-TYPE
	 SYNTAX  DisplayString (SIZE (0..255))
       ACCESS  read-only
       STATUS  mandatory
       DESCRIPTION
            "The name of a dbwatch check."
        ::= { dbwatch 11 }

dbwCheckDetails OBJECT-TYPE
	 SYNTAX  DisplayString (SIZE (0..1024))
       ACCESS  read-only
       STATUS  mandatory
       DESCRIPTION
            "The status details for a dbwatch check."
        ::= { dbwatch 12 }


databaseWarning NOTIFICATION-TYPE
   OBJECTS { dbwDatabaseName }
   STATUS       current
   DESCRIPTION
       "Database has status warning"
   ::= { dbwatch 200 }

databaseAlarm NOTIFICATION-TYPE
   OBJECTS { dbwDatabaseName }
   STATUS       current
   DESCRIPTION
       "Database has status alarm"
   ::= { dbwatch 201 }

databaseLostConnection NOTIFICATION-TYPE
   OBJECTS { dbwDatabaseName }
   STATUS       current
   DESCRIPTION
       "Lost connection to database"
   ::= { dbwatch 203 }

checkWarning NOTIFICATION-TYPE
   OBJECTS { dbwDatabaseName, dbwCheckName, dbwCheckDetails }
   STATUS       current
   DESCRIPTION
       "Check has status warning.
	First argument is database name.
	Second argument is check name.
	Third argument is check details."
   ::= { dbwatch 204}

checkAlarm NOTIFICATION-TYPE
   OBJECTS { dbwDatabaseName, dbwCheckName, dbwCheckDetails }
   STATUS       current
   DESCRIPTION
       "Check has status alarm.
	First argument is database name.
	Second argument is check name.
	Third argument is check details."
   ::= { dbwatch 205 }

END