<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>CURRENT:
</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>I have written
a custom script that is a COMBO TEST that works out if any of the
tablespaces are close to full and submits either the Green/red or Yellow status
messages along with a comment containing a multi column text report
containing each tablespace name and a variety of data on it including
total_size, amount used and percentage used. This has been working well for
quite a while now on 2 servers with a column name of "otsp".</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>Recently I wanted to
Graph the total sizes of the tablespaces to see trends in either there growth or
fluctuation.</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>I wrote a script to
capture the data and put it into .rrd files, this was then added to the
[larrdstatus] and [larrddata] sections of the hobbitlaunch.cfg file. using
</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>CMD hobbitd_channel
--channel=status --log=$BBSERVERLOGS/larrd-status.log ho<BR>bbitd_larrd
--rrddir=$BBVAR/rrd
--extra-script=/usr/local/hobbit/server/ext/grap<BR>h_otsp.sh
--extra-tests=otsp</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>CMD hobbitd_channel
--channel=data --log=$BBSERVERLOGS/larrd-data.log hobb<BR>itd_larrd
--rrddir=$BBVAR/rrd
--extra-script=/usr/local/hobbit/server/ext/grap<BR>h_otsp.sh
--extra-tests=otsp</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>This seems to be
working fine and I can see that under ~/data/rrd/hostname directories for the 2
hosts in question I can see .rrd files that reflect the naming convention i have
used "otsp.*.rrd"</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>I queried one
of the .rrd files using :</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005>rrdtool fetch $your.rrd AVERAGE</SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>This returned the
sort of results that I would expect for the data stored (this was installed when
we were using BB originally before switching to Hobbit).</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>So far all seemed
good.</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>Then I tried to get
the graphs to appear on the appropriate detail view of the otsp page for the
hosts in question:</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>and added otsp to
both LARRDS and GRAPHS in hobbitserver.cfg:</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2>LARRDS="cpu=la,disk,memory,conn=tcp,fping=tcp,ftp=tcp,ftps=tcp,ssh=tcp,ssh1=tcp,<BR>ssh2=tcp,telnet=tcp,telnets=tcp,smtp=tcp,smtps=tcp,pop-2=tcp,pop2=tcp,pop-3=tcp,<BR>pop3=tcp,pop=tcp,pop3s=tcp,imap=tcp,imap2=tcp,imap3=tcp,imap4=tcp,imaps=tcp,nntp<BR>=tcp,nntps=tcp,ldap=tcp,ldaps=tcp,rsync=tcp,bbd=tcp,clamd=tcp,oratns=tcp,qmtp=tc<BR>p,qmqp=tcp,http=tcp,dns=tcp,dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperatu<BR>re,apache,bind,sendmail,nmailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,h<BR>obbitd,otsp"</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2>GRAPHS="la,disk:disk_part:5,memory,users,vmstat,iostat,tcp.http,tcp,netstat,temp<BR>erature,ntpstat,apache,bind,sendmail,nmailq,socks,bea,iishealth,citrix,bbgen,bbt<BR>est,bbproxy,hobbitd,otsp"</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>Also I tried to
write the graph definitions in hobbitgraph.cfg</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2>[otsp]<BR> FNPATTERN otsp(.*).rrd<BR>
TITLE Oracle Tablespace Used<BR> YAXIS MB
Used<BR>
DEF:p@RRDIDX@=@RRDFN@:used:AVERAGE<BR>
LINE2:p@RRDIDX@#@COLOR@:@RRDPARAM@<BR> -u
16000<BR> -l 0<BR> GPRINT:p@RRDIDX@:LAST: :
%5.1lf (cur)<BR> GPRINT:p@RRDIDX@:MAX: : %5.1lf
(max)<BR> GPRINT:p@RRDIDX@:MIN: : %5.1lf
(min)<BR> GPRINT:p@RRDIDX@:AVERAGE: : %5.1lf
(avg)<BR></FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>Then I restarted
hobbit but alas no graphs.</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>After much searching
I found something about changing the entries in the in hobbitserver.cfg from
what I had above to the following and I was clutching at straws here trying to
get it to work:</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial size=2>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2>LARRDS="cpu=la,disk,memory,conn=tcp,fping=tcp,ftp=tcp,ftps=tcp,ssh=tcp,ssh1=tcp,<BR>ssh2=tcp,telnet=tcp,telnets=tcp,smtp=tcp,smtps=tcp,pop-2=tcp,pop2=tcp,pop-3=tcp,<BR>pop3=tcp,pop=tcp,pop3s=tcp,imap=tcp,imap2=tcp,imap3=tcp,imap4=tcp,imaps=tcp,nntp<BR>=tcp,nntps=tcp,ldap=tcp,ldaps=tcp,rsync=tcp,bbd=tcp,clamd=tcp,oratns=tcp,qmtp=tc<BR>p,qmqp=tcp,http=tcp,dns=tcp,dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperatu<BR>re,apache,bind,sendmail,nmailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,h<BR>obbitd,otsp::1"</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2>GRAPHS="la,disk:disk_part:5,memory,users,vmstat,iostat,tcp.http,tcp,netstat,temp<BR>erature,ntpstat,apache,bind,sendmail,nmailq,socks,bea,iishealth,citrix,bbgen,bbt<BR>est,bbproxy,hobbitd,otsp::1"</FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005>But this also failed to provide a
solution.</SPAN></DIV>
<DIV><SPAN class=687435003-13122005></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005>I am running Hobbit Monitor 4.0.3 on
Solaris 9</SPAN></DIV>
<DIV><SPAN class=687435003-13122005></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005>Can anyone give me some tips on what to try
next to get my graph to appear ? Suggested further reading ?</SPAN></DIV>
<DIV><SPAN class=687435003-13122005></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005>Regards</SPAN></DIV>
<DIV><SPAN class=687435003-13122005></SPAN> </DIV>
<DIV><SPAN class=687435003-13122005>Paul</SPAN></DIV></FONT></SPAN></DIV>
<DIV><SPAN class=687435003-13122005><FONT face=Arial
size=2> </DIV></FONT></SPAN></BODY></HTML>