[hobbit] dbcheck

[Iain Conochie]

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
>