SWick - A player in the Stallman Team

OpenNMS konkurriert nicht mit Software zur Überwachung weniger Server.

Man kann mit Nagios schnell eine kleine Anzahl von Servern sehr spezifisch überwachen.
Mit mehr oder weniger komplexen Perl Skripten
können sehr stark angepasste Anfragen geschrieben werden - allerdings um den Preis
einer weniger guten Skalierbarkeit und eines höheren Ressourcenverbrauchs.

# snmpd.conf
 
extend dbautogrowth cmd /c "C:\Program Files\IronPython 2.6\ipy.exe" e:\monitoring_scripts\check_dbautogrowth.py

# E:\monitoring_scripts\check_dbautogrowth.py
 
# Configuration
# DBNAME ist the one you see in Management Studio NOT the actual filename
DBNAME="YourDataBase"
 
# Don't change anything below this line
 
import sys
import clr
 
INFOSTRING="DBAutogrowth_" + DBNAME
 
sys.path.append(r"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE")
clr.AddReferenceToFile('Microsoft.SqlServer.Express.Smo.dll')
clr.AddReferenceToFile('Microsoft.SqlServer.Express.ConnectionInfo.dll')
 
from Microsoft.SqlServer.Management.Smo import *
from Microsoft.SqlServer.Management.Common import *
import Microsoft.SqlServer.Management.Smo as SMO
import Microsoft.SqlServer.Management.Common as Common
 
clr.AddReference("System")
from System import *
 
 
def main():
 
    server      = Server("localhost\SQLEXPRESS")
    db          = server.Databases[DBNAME]
 
    growth_raw      =  db.FileGroups["PRIMARY"].Files[0].Growth
    growth_type_raw =  db.FileGroups["PRIMARY"].Files[0].GrowthType
 
    growth          = int(growth_raw)                 # Casting 'float' type to 'int' type
    growth_type     = str(growth_type_raw).lower()    # Casting 'FileGroup' type to 'str' type
 
 
    if growth_type == 'percent' and growth > 5:
 
        #Printing a String for the SNMP client to have an idea what this value stands for
        print INFOSTRING
        sys.exit(2)
    else:
 
        #Printing a String for the SNMP client to have an idea what this value stands for
        print INFOSTRING
        sys.exit(0)
 
 
if __name__ == "__main__":
    main()

<!-- /etc/opennms/poller-configuration.xml -->
 
...
<package name="example1">
...
        <service name="MSSQL-DB-Autogrowth" interval="300000" user-defined="false" status="on">
            <parameter key="retry" value="2"/>
            <parameter key="timeout" value="3000"/>
            <parameter key="port" value="1161"/>
            <parameter key="oid" value=".1.3.6.1.4.1.8072.1.3.2.3.1.4.12.100.98.97.117.116.111.103.114.111.119.116.104"/>
            <parameter key="operator" value="="/>
            <parameter key="operand" value="0"/>
            <parameter key="reason-template" value="The value of automatic database growth changed \ 
                                                    from a fixed value to a percent value greater than 5.\
                                                    Expected value should be 50 MB fixed or lower"/>
        </service>
...
</package>
...
<monitor service="MSSQL-DB-Autogrowth" class-name="org.opennms.netmgt.poller.monitors.SnmpMonitor"/>
...

#!/usr/bin/env python
 
import sys
 
filename = "/proc/net/ip_vs_stats"
 
try:
    f = open(filename,'r')
 
except IOError:
    print "Sorry, could not read file " + "'" + filename + "'"
    sys.exit()
 
data = f.read()
 
 
def hex2dec(s):
    """return the integer value of a hexadecimal string s"""
    return int(s, 16)
 
# first create a list of lists
data_list = [line.split()  for line in data.split('\n')]
 
stats = {}
 
stats['total_conns_sec']    = hex2dec(data_list[5][0])
stats['incoming_pkts_sec']  = hex2dec(data_list[5][1])
stats['outgoing_pkts_sec']  = hex2dec(data_list[5][2])
stats['incoming_bytes_sec'] = hex2dec(data_list[5][3])
stats['outgoing_bytes_sec'] = hex2dec(data_list[5][4])
 
if __name__ == '__main__':
 
    if len(sys.argv) < 2:
        print "\nError:\tNo arguments given.\n"
        print "Try:"
 
        for argument in stats:
            print "\t", sys.argv[0], argument
        sys.exit()
 
 
    if sys.argv[1] == 'total_conns_sec':
        print stats['total_conns_sec']
 
    if sys.argv[1] == 'incoming_pkts_sec':
        print stats['incoming_pkts_sec']
 
    if sys.argv[1] == 'outgoing_pkts_sec':
        print stats['outgoing_pkts_sec']
 
    if sys.argv[1] == 'incoming_bytes_sec':
        print stats['incoming_bytes_sec']
 
    if sys.argv[1] == 'outgoing_bytes_sec':
        print stats['outgoing_bytes_sec']

# Monitoring IPVS
 
extend total_conns_sec    /opt/ipvs_stats.py total_conns_sec
extend incoming_bytes_sec /opt/ipvs_stats.py incoming_bytes_sec
extend incoming_pkts_sec  /opt/ipvs_stats.py incoming_pkts_sec

snmpwalk -v 2c -c <community> <IP> nsExtendOutline

NET-SNMP-EXTEND-MIB::nsExtendOutLine."total_conns_sec".1 = STRING: 3
NET-SNMP-EXTEND-MIB::nsExtendOutLine."incoming_pkts_sec".1 = STRING: 62
NET-SNMP-EXTEND-MIB::nsExtendOutLine."incoming_bytes_sec".1 = STRING: 31928

snmpwalk -On -v 2c -c <community> <IP> nsExtendOutline

.1.3.6.1.4.1.8072.1.3.2.4.1.2.15.116.111.116.97.108.95.99.111.110.110.115.95.115.101.99.1 = STRING: 4
.1.3.6.1.4.1.8072.1.3.2.4.1.2.17.105.110.99.111.109.105.110.103.95.112.107.116.115.95.115.101.99.1 = STRING: 74
.1.3.6.1.4.1.8072.1.3.2.4.1.2.18.105.110.99.111.109.105.110.103.95.98.121.116.101.115.95.115.101.99.1 = STRING: 33322

...
...
...
 
      <group name="ipvs" ifType="ignore">
        <mibObj oid=".1.3.6.1.4.1.8072.1.3.2.4.1.2.15.116.111.116.97.108.95.99.111.110.110.115.95.115.101.99" 
                instance="1" alias="ipvsTotalConnsSec" type="octetstring" />
        <mibObj oid=".1.3.6.1.4.1.8072.1.3.2.4.1.2.17.105.110.99.111.109.105.110.103.95.112.107.116.115.95.115.101.99" 
                instance="1" alias="ipvsPktsSecIn" type="octetstring" />
        <mibObj oid=".1.3.6.1.4.1.8072.1.3.2.4.1.2.18.105.110.99.111.109.105.110.103.95.98.121.116.101.115.95.115.101.99" 
                instance="1" alias="ipvsBytesSecIn" type="octetstring" />
      </group>
...
...
...
 
      <systemDef name="Net-SNMP">
        <sysoidMask>.1.3.6.1.4.1.8072.3.</sysoidMask>
        <collect>
          <includeGroup>mib2-host-resources-system</includeGroup>
          <includeGroup>mib2-host-resources-memory</includeGroup>
          <includeGroup>mib2-X-interfaces</includeGroup>
          <includeGroup>net-snmp-disk</includeGroup>
          <includeGroup>openmanage-coolingdevices</includeGroup>
          <includeGroup>openmanage-temperatureprobe</includeGroup>
          <includeGroup>openmanage-powerusage</includeGroup>
          <includeGroup>ucd-loadavg</includeGroup>
          <includeGroup>ucd-memory</includeGroup>
          <includeGroup>ucd-sysstat</includeGroup>
          <includeGroup>ucd-sysstat-raw</includeGroup>
          <includeGroup>ucd-sysstat-raw-more</includeGroup>
          <!-- <ipvs> -->
          <includeGroup>ipvs</includeGroup>
          <!-- </ipvs> -->
        </collect>
      </systemDef>
...
...
...

...
...
...
 
reports=...\
..., \
ipvs, ipvs.incoming.bytes, ipvs.incoming.packets \
...
...
...
report.ipvs.name=IPVS Stats
report.ipvs.columns=ipvsTotalConnsSec
report.ipvs.type=nodeSnmp
report.ipvs.command=--title="IPVS Stats" \
 DEF:totalconns={rrd1}:ipvsTotalConnsSec:AVERAGE \
 LINE2:totalconns#DE0056:"Total Connections/sec" \
 GPRINT:totalconns:AVERAGE:"Avg \\: %10.2lf %s" \
 
report.ipvs.incoming.bytes.name=IPVS Stats Incoming Bytes
report.ipvs.incoming.bytes.columns=ipvsBytesSecIn
report.ipvs.incoming.bytes.type=nodeSnmp
report.ipvs.incoming.bytes.command=--title="IPVS Stats - Incoming Bytes" \
 DEF:bytes={rrd1}:ipvsBytesSecIn:AVERAGE \
 LINE2:bytes#DE0056:"Bytes/sec" \
 GPRINT:bytes:AVERAGE:"Avg \\: %10.2lf %s" \
 
report.ipvs.incoming.packets.name=IPVS Stats Incoming Packets
report.ipvs.incoming.packets.columns=ipvsPktsSecIn
report.ipvs.incoming.packets.type=nodeSnmp
report.ipvs.incoming.packets.command=--title="IPVS Stats - Incoming Packets" \
 DEF:packets={rrd1}:ipvsPktsSecIn:AVERAGE \
 LINE2:packets#DE0056:"Packets/sec" \
 GPRINT:packets:AVERAGE:"Avg \\: %10.2lf %s" \
 
...
...
...

#!/usr/bin/python
 
import optparse
import pymssql
import sys
 
def main():
 
    #Connect to MSSQL Server
    try:
        con = pymssql.connect(host=host, user=user, password=password, database=database)
        cur = con.cursor()
 
    except TypeError:
        print 
        print "Could not connect to SQL Server"
        print 
        sys.exit(1)
 
    # Execute Query which checks if database is mirrored
    query="""SELECT d.name, m.mirroring_role_desc, m.mirroring_state_desc
             FROM sys.database_mirroring m
             JOIN sys.databases d ON m.database_id = d.database_id
             WHERE mirroring_state_desc IS NOT NULL AND name = """ + "'" + database + "'"
 
    cur.execute(query)
 
    results = cur.fetchall()
 
    for row in results:
        name  = row[0]
        role  = row[1]
        state = row[2]
 
    exit_val = 2
 
    if cur.rowcount > 0:
        if (role == "PRINCIPAL") and (state == "SYNCHRONIZED"):
            exit_val = 0
 
    if exit_val == 0:
        print "OK", "-", name, "-", role, "-", state
    else:
        print "CRITICAL - Check the mirrored database"
 
    con.close()
 
 
if __name__ == "__main__":
 
    # Command line Options
    parser = optparse.OptionParser()
 
    parser.add_option("-H", "--host",     dest="host",     metavar="HOST", help="IP or hostname with the mirrored database")
    parser.add_option("-d", "--database", dest="database", metavar="DB",   help="Name of the mirrored database")
    parser.add_option("-u", "--user",     dest="user",     metavar="USER", help="User to login")
    parser.add_option("-p", "--password", dest="password", metavar="PW",   help="Password of the user")
 
    if (len(sys.argv) < 2):
        args=["-h"]
        (options, args) = parser.parse_args(args)
 
    (options, args) = parser.parse_args()
 
    host     = options.host
    user     = options.user
    password = options.password
    database = options.database
 
    # Main function 
    main()