Did you add the dbcheck flag to the device entry in the bb-hosts file ?
-----Original Message-----
From: Iain Conochie [mailto:user-c784e16a5170@xymon.invalid] Sent: Monday, November 20, 2006 8:10 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] dbcheck
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