dbcheck
list Iain Conochie
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
list Steve Aiello
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
list 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:user-c784e16a5170@xymon.invalid] > Sent: Monday, November 20, 2006 8:10 AM To: user-ae9b8668bcde@xymon.invalid Subject: [hobbit] dbcheckMorning,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:00Host Checked = 0 Status Msg = 0No Colors No Events No Types No Hosts No Hosts ErrorsNo General Errors No Hosts ErrorsWarningsNo General Warnings No Hosts Warningsdbcheck.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