RE [hobbit] R: [hobbit] RE [hobbit] Database test: dbcheck.pl on deadcat and sourceforge

[thomas.seglard.enata at cnp.fr]

Thanks for support !
Here is output when using bbcmd :

[hobbit at psi200 server]$ ./bin/bbcmd ext/dbcheck.pl 
2006-08-07 16:18:45 Using default environment file 
/Soft/HOBBIT-4.1.2p1/server/etc/hobbitserver.cfg
Environment checking
/Soft/HOBBIT-4.1.2p1/data/disabled

It's better ! But nothing appears on my Hobbit display... So I'm missing 
something. I've set up a section into dbcheck.ini like this :

[psu155] # hostname of one oracle server
dbtype                     = Oracle
hostname                = psu155
sid                        = HALSE1
username               = vantage
password               = vantage
port                       = 1521
tbl.SYSTEM           = 101:101

and added this line to my bb-hosts :

0.0.0.0         psu155  # noconn dbcheck

And still no new column on my display. I'm checking port and names.
Sincerly,

Thomas

"Francesco Duranti" <fduranti at q8.it> a écrit sur 07/08/2006 15:50:39 :

> The script will monitor all the database from a single host that 
> have access to the database and the database client installed. The 
> better thing to do is to run them on the server where you have all 
> the configuration of hobbit in a unique place but it can also be run
> on a client (not tested but should work). 
> To run them you can use the hobbitlaunch.cfg or clientlaunch.cfg (if
> you're running on a client).
> 
> To do all the check i use 2 section in the hobbitlaunch.cfg of the 
> hobbit server to check the database with different timing. 
> I use to launch a fast check every 5 minutes that will only check 
> for connection, audit table, tablespace, session and cache (because 
> i graph them and i want the 5 minutes data) and a slow test that do 
> the rest of the check (rollback and extent check on some of the 
> database I'm checking take 10-15 minutes to run so i prefer to run 
> them every 4 hour).
> 
> [dbfast]
>         ENVFILE /home/bbtest/server/etc/hobbitserver.cfg
>         NEEDS hobbitd
>         CMD $BBHOME/ext/dbcheck.pl fast
>         LOGFILE $BBSERVERLOGS/bb-dbfast.log
>         INTERVAL 5m
> [dbslow]
>         ENVFILE /home/bbtest/server/etc/hobbitserver.cfg
>         NEEDS hobbitd
>         CMD $BBHOME/ext/dbcheck.pl slow
>         LOGFILE $BBSERVERLOGS/bb-dbslow.log
>         INTERVAL 240m
> 
> I will check for the 2 problem you got. If you not did it try to run
> bbcmd dbcheck.pl instead of running directly the command (or launch 
> bbcmd bash and then run the ./dbcheck.pl). I also got a problem on 
> the extent check, a new version will be available during this week 
> to solve those problems and to add some documentation :D
> 
> Thanks for the report
> 
> Francesco
> 
> -----Messaggio originale-----
> Da: thomas.seglard.enata at cnp.fr [mailto:thomas.seglard.enata at cnp.fr] 
> Inviato: lunedì 7 agosto 2006 14.18
> A: hobbit at hswn.dk
> Oggetto: [hobbit] RE [hobbit] Database test: dbcheck.pl on deadcat 
> and sourceforge
> 
> Hello Francesco !
> 
> Thans for all your scripts and work ! It looks amazing... However I 
> don't understand the way it works. Sorry.... I'm talking about the 
> dbcheck test. Here are my questions :
> 
> - These scripts have to be executed on the hobbit server or on 
> Hobbit clients ?
> - In both cases,  have we to setup hobbitlaunch.cfg or clientlaunch.
> cfg to run the check ?
> - I'm running Hobbit v4.1.2p1 and when launching dbcheck.pl I got 
> this output : 
> 
>         [hobbit at psu155 ext]$ ./dbcheck.pl 
>         Use of uninitialized value in concatenation (.) or string at
> ./dbcheck.pl line 806.
>         Use of uninitialized value in concatenation (.) or string at
> ./dbcheck.pl line 78.
>         Could not open the disabled hosts directory: No such file 
ordirectory
>         Could not close the DISABLED directory handle: No such file 
> or director
> 
>  I commented out corresponding lines and these warnings disappear.
> 
> Thanks again for all your hard work !
> Best regards,
> 
> Thomas
> 
> "Francesco Duranti" <fduranti at q8.it> a écrit sur 06/08/2006 18:44:15 :
> 
> > Hello all,
> > I've just released the first version of a perl script to check 
> > oracle/informix/sqlserver databases.
> > It can be found on deadcat and at
> > http://sourceforge.net/projects/hobbit-perl-cl/
> > 
> > This perl script will get data from the Database Server using DBI/DBD > > Perl Library.
> > At this moment it will work with SQLServer,Oracle and Informix (I will 
> > add mysql in the near future).
> > For sqlserver and informix for now only connection and database space > > are checked. For oracle there are many tests done (mostly the same as > > the bb-roracle.ksh + some custom ones):Connection, Audit table report, 
> > Tablespace, Extent, PinLib/HitCache, Memory Request, Invalid Objects, > > Rollback, Locks, Sessions and Processes.
> > The program was fully tested under Hobbit but should work also on BB. > > The tests are not done if the connection test is failing. Sessions and 
> > Cache statistics are also gathered for graphs by hobbit.
> > 
> > Thanks all :D
> > 
> > Francesco
> > 
> > To unsubscribe from the hobbit list, send an e-mail to 
> > hobbit-unsubscribe at hswn.dk
> > 
> > 
> 
> 
> 
> Ce message (et toutes ses pieces jointes eventuelles) est 
> confidentiel et etabli a l'intention exclusive de ses destinataires.
> Toute utilisation de ce message non conforme a sa destination, toute
> diffusion ou toute publication, totale ou partielle, est interdite, 
> sauf autorisation expresse.
> L'internet ne permettant pas d'assurer l'integrite de ce message, 
> CNP Assurances et ses filiales declinent toute responsabilite au 
> titre de ce message, s'il a ete altere, deforme ou falsifie.
> 
> *****
> 
> This message and any attachments (the "message") are confidential 
> and intended solely for the addressees.
> Any unauthorised use or dissemination is prohibited.
> E-mails are susceptible to alteration.
> Neither CNP Assurances nor any of its subsidiaries or affiliates 
> shall be liable for the message if altered, changed or falsified.
> 
> 
> 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
> 
> 



Ce message (et toutes ses pieces jointes eventuelles) est confidentiel et etabli a l'intention exclusive de ses destinataires.
Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est
interdite, sauf autorisation expresse.
L'internet ne permettant pas d'assurer l'integrite de ce message, CNP Assurances et ses filiales declinent toute responsabilite
au titre de ce message, s'il a ete altere, deforme ou falsifie.

*****

This message and any attachments (the "message") are confidential and intended solely for the addressees.
Any unauthorised use or dissemination is prohibited.
E-mails are susceptible to alteration.
Neither CNP Assurances nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified.