[hobbit] dbcheck

[Francesco Duranti]

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:iain at shihad.org] 
> Sent: Monday, November 20, 2006 2:27 PM
> To: hobbit at hswn.dk
> 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:iain at shihad.org]
> > > Sent: Monday, November 20, 2006 8:10 AM
> > > To: hobbit at hswn.dk
> > > 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
> > > 
> > > 
> > > 
> > > 
> > > To unsubscribe from the hobbit list, send an e-mail to 
> > > hobbit-unsubscribe at hswn.dk
> > > 
> > > 
> > > 
> > 
> > To unsubscribe from the hobbit list, send an e-mail to 
> > hobbit-unsubscribe at hswn.dk
> > 
> 
> 
> To unsubscribe from the hobbit list, send an e-mail to 
> hobbit-unsubscribe at hswn.dk
> 
> 
>