dbcheck

To run it on the client you've to change 2 variables at the start of
dbcheck.pl file:
$Hobbit_fd_lib::HOBBIT = 1; $Hobbit_fd_lib::USEBBHGREP = 0; 
Can you run a dbcheck.pl -dd (it should create some debugging data that
could be usefull) and send it to me ? It's possible that the "client" part that don't use bbhostgrep is not
working right for some reason, I didn't tested it really much because I
use dbcheck.pl on the hobbit server from which I monitor all the
databases with just one script.

Francesco

-----Original Message-----
From: Iain Conochie [mailto:user-c784e16a5170@xymon.invalid] Sent: Monday, November 20, 2006 2:27 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] dbcheck

On Mon, 2006-11-20 at 08:19 -0500, Aiello, Steve (GE, Corporate,
consultant) wrote:

Did you add the dbcheck flag to the device entry in the bb-hosts file ?

This is the bb-hosts file on the client

192.168.1.87    breed.int.servista.com  # noconn dbcheck


Iain

-----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