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