[hobbit] dbcheck

[Aiello, Steve (GE, Corporate, consultant)]

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

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