File: sqlconn.monitor.README

package info (click to toggle)
mon-contrib 1.0%2Bdfsg-5
  • links: PTS, VCS
  • area: main
  • in suites: sid, trixie
  • size: 892 kB
  • sloc: perl: 5,510; sh: 383; python: 118; makefile: 72
file content (34 lines) | stat: -rw-r--r-- 1,106 bytes parent folder | download | duplicates (5)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
From duncanl@demon.net Mon Aug 23 06:51:17 1999
Date: Fri, 06 Aug 1999 15:59:30 +0100
From: Duncan Lawie <duncanl@demon.net>
To: mon@linux.kernel.org
Subject: sqlconn.monitor
 
Hi,
 
herewith a monitor which checks on sqlnet connections.  It uses DBI but,
as it stands, is coded in an Oracle-specific way.  The matching mon.cf
lines would look something like this
 
hostgroup first_db second_db
 
watch ora_dbs
    service sqlconnect
        interval 15m
        monitor sqlconn.monitor
        period wd {Mon-Fri} hr {9am-5pm}
            alert mail.alert duncanl@demon.net
            alertevery 1h
        period wd {Sat-Sun}
            alert mail.alert duncanl@demon.net
 
There is an element of hack in that the hostgroup is actually a list of
database names, not unix hosts.
 
I am a little uncomfortable (as yet) with GPL, but as I understand it I
can sidestep the issue by making this open source under the terms of
perl.  I also understand that if it were intergrated into mon it would
them be distributed under the GPL along with mon.  Can anyone offer me
enlightenment on this issue?
 
Duncan.