dbcheck

Iain Conochie iain at shihad.org
Mon Nov 20 14:10:09 CET 2006


Morning,

	I have having a little issue getting the dbcheck script to check our
mysql database. I am running the script from the client side. Below is
the config for dbcheck.ini. Local config replaced with XXXXXXX

[default]
warningout              =send
conn                    = conn
include                 =
defaultgroup            =
timeoutdbconn           = 20s
timeoudbtselect         = 1h
fastcheck               = 30m
mediumcheck             = 2h
slowcheck               = 6h
bbdisplay               = XXXXXX.XXXXXXX.XXXXXXXXXXXX.XXXXXX
bbsendtype              = multi             # multi single or both
singlesendashost        = no
bbfulltestcolumn        = DBCheck
bbmysqlperfcolumn       = MySQLPerf
bbconncolumn            = ChkConn
bbauditcolumn           = Audit
bbtablespacecolumn      = TblSpace
bbextentcolumn          = Extent
bbhitcachecolumn        = HitCache
bbmemreqcolumn          = MemReq
bbrollbackcolumn        = RollBack
bbinvobjcolumn          = InvObj
bblockscolumn           = Locks
bbsessioncolumn         = Session
bbsessionuserlist       = yes
username                = XXXXXXXXXXXXXXXXX
password                = XXXXXXXXXXXXXXXXX
tblspcheck              = 90:95
tblspreportautoext      = 90:95
pinlibcheck             = 95:90
blbuffcheck             = 95:90
hitcachecheck           = 95:90
rowcachecheck           = 95:90
extentcheck             = 90:95
rollbackcheck           = 90:95
sessioncheck            = 90:95
processcheck            = 90:95
rb.SYSTEM               = 101:101 # don't report SYSTEM rollback problem
for all databases
invobjwarn              = ::: # Report all as yellow instead of red
invobjignore            =
dbtype                  = mysql


[XXXXXX.XXXXXXXXX.XXXXXXXXXX.XXX]
dbtype                  = mysql
hostname                = localhost
port                    = 3306
username                = XXXXXXXXXXXXXX
password                = XXXXXXXXXXXXXX

[CUSTOM testcheck]

[CUSTOM unumber]

The results I get back are:

Test Time    = 00:00:00
Host Checked = 0
Status Msg   = 0

No Colors

No Events

No Types

No Hosts

No Hosts

Errors
No General Errors
No Hosts Errors

Warnings
No General Warnings
No Hosts Warnings


dbcheck.pl version 1.07 - column dbcheck_fast lifetime 30m, tested in ~ 00:00:00 (max 00:01:00)

Can someone show me what I am missing here please?

Cheers

Iain






More information about the Xymon mailing list