Yes, i do think it should be integrated with the default release (like dns,smtp,etc)<div><br></div><div>I can write something for the wiki, not a problem, just let me know where it should be posted</div><div><br></div><div>
It is already in the hobbitgraph file but it could do with a bit of an upgrade.</div><div><br></div><div>Before I go ahead and write the wiki I would like to ask the sql "maestros" to point out what show be monitored in Mysql (ie, what information can we get in hobbit that will give us a very good an detailed picture of the mysql database).</div>
<div><br></div><div>waiting for sugestions, also with your sugestions could you please send the commands to find that information?</div><div><br></div><div>Nelson<br><div><br></div><div><br><div class="gmail_quote">On 27 March 2010 13:50, Jerald Sheets <span dir="ltr"><<a href="mailto:questy@gmail.com">questy@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div style="word-wrap:break-word"><div class="im"><div>This is something that would be outstanding for the wiki.</div>
<div><br></div><div>The MySQL stuff is actually already in my hobbtgraph file which initially puzzled me. After working through it a number of times, I was able to finally get it to work, but not without some difficulty.</div>
<div><br></div><div>Excellent work, Nelson.</div><div><br></div><div>--j</div><div><br></div><br></div><div><div class="im"><div>On Mar 27, 2010, at 5:44 AM, <a href="mailto:amaral8011@googlemail.com" target="_blank">amaral8011@googlemail.com</a> wrote:</div>
<br></div><div><div></div><div class="h5"><blockquote type="cite"><div style="word-wrap:break-word">Ehehe<br><br>Once again sorry for the spaming.<br><br>I got the graphs working for mysql, I will be posting all the steps in this thread later for everyone that has the same problem in the future.<br>
<br>Regards<br><br>Nelson<p>Sent from my BlackBerry® wireless device</p><hr><div><b>From: </b> Jerald Sheets <<a href="mailto:questy@gmail.com" target="_blank">questy@gmail.com</a>>
</div><div><b>Date: </b>Fri, 26 Mar 2010 12:05:23 -0400</div><div><b>To: </b><<a href="mailto:hobbit@hswn.dk" target="_blank">hobbit@hswn.dk</a>></div><div><b>Subject: </b>Re: [hobbit] Mysql Graphing</div><div><br>
</div><div>Methinks Nelson's mail server is burping...</div><div><br></div><div>--j</div><div><br></div><br><div><div>On Mar 26, 2010, at 8:59 AM, Nelson Amaral wrote:</div><br><blockquote type="cite"><span style="border-collapse:separate;font-family:Helvetica;font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="font-family:'Times New Roman';font-size:16px"><span><br>
Hi </span><div><span><br></span></div><div><span>I have used a mysql script from xymonton to collect data into xymon, i get the data in xymon OK but the problem is the graphs right now.</span></div><div><span><br></span></div>
<div><span>The graphs come up in the page but is not plotting, the problem is some where between hobbitserver.cfg and hobbitgraph.cfg </span></div><div><span><br></span></div><div><span>I am asking for help while i carry on looking for the answer (maybe i'm missing something in the configuration) </span></div>
<div><span><br></span></div><div><span>please note that the rrd file is created in the data folder</span></div><div><span><br></span></div><div>I get the data in xymon example:</div><div><br></div><div><h3> <i>Fri Mar 26 14:54:26 2010 MySQL Server OK</i></h3>
<pre><i>threads: 1
questions: 990691
slow queries: 0
opens: 7128
flush tables: 1
open tables: 64
queries per second avg: 0.402
maxcon: 100
Server version: 5.0.77 Source distribution
Uptime: 28 days 12 hours 19 min 1 sec
Server reports timestamp of 2010-03-26 14:54:26
</i>
</pre><pre><font face="'times new roman', 'new york', times, serif"><span style="font-size:medium">and have added the following in hobbitserver.cfg</span></font></pre><pre><font face="'times new roman', 'new york', times, serif"><span style="font-size:medium">in TEST2RRD i added mysql=ncv</span></font></pre>
<pre><font face="'times new roman', 'new york', times, serif"><span style="font-size:medium">and then added the following line </span></font></pre><pre><font face="'times new roman', 'new york', times, serif"><span style="font-size:medium">NCV_mysql="threads:GAUGE,questions:GAUGE,slow queries:GAUGE,opens:GAUGE,flush tables:GAUGE,open tables:GAUGE,queries per second avg:GAUGE"</span></font></pre>
<pre><font face="'times new roman', 'new york', times, serif"><span style="font-size:medium">also in </span></font><span style="white-space:normal"><font face="'times new roman', 'new york', times, serif"><span style="font-size:medium">hobbitgraph.cfg i added the following</span></font></span></pre>
</div><div><span>(i only have the first 2 instances of data for testing purposes)</span></div><div><span><br></span></div><div><span><div><i>[mysql]</i></div><div><i> TITLE mysql info</i></div><div><i> YAXIS #</i></div>
<div><i> DEF:threads=mysql.rrd:threads:AVERAGE </i></div><div><i> DEF:questions=mysql.rrd:questions:AVERAGE</i></div><div><i> LINE1:threads#00CCCC:threads</i></div><div><i> LINE2:questions#FF0000:questions</i></div>
<div><i> COMMENT:\n</i></div><div><i> GPRINT:threads:LAST:Threads \: %5.1lf (cur)</i></div><div><i> GPRINT:threads:MAX: \: %5.1lf (max)</i></div><div><i> GPRINT:threads:MIN: \: %5.1lf (min)</i></div>
<div><i> GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n</i></div><div><i> GPRINT:questions:LAST:Questions\: %5.1lf%s (cur)</i></div><div><i> GPRINT:questions:MAX: \: %5.1lf%s (max)</i></div><div><i> GPRINT:questions:MIN: \: %5.1lf%s (min)</i></div>
<div><i> GPRINT:questions:AVERAGE: \: %5.1lf%s (avg)\n </i></div><div><br></div></span></div><div><span><br><br>Regards<br><br>Nelson Amaral<br></span><br>----- Original Message -----<br>From: "thorsten erdmann" <<a href="mailto:thorsten.erdmann@daimler.com" target="_blank">thorsten.erdmann@daimler.com</a>><br>
To:<span> </span><a href="mailto:hobbit@hswn.dk" target="_blank">hobbit@hswn.dk</a><br>Sent: Friday, 26 March, 2010 11:27:32 AM<br>Subject: [hobbit] message filter and the DEFAULT section<br><br><br><font size="2" face="sans-serif">Hi</font><br>
<br><font size="2" face="sans-serif">I want to filter some messages from a specific server's message log. So I built a special rule in hobbit-clients.cfg to filter that message, but it is ignored. It seems Hobbit preferres the DEFAULT section. If I uncomment the DEFAULT LOG rule my special rule is used and the message is filtered.</font><br>
<br><font size="2" face="sans-serif">So how can I have a default rule including some IGNORE clauses which is used for all my servers and an additional set of rule specific to one or more servers.</font><br><br><font size="2" face="sans-serif">Here is my hobbit-client.cfg. The rule I currently playing with is marked with (***), it's the host s068c326. If I comment out the last two lines it works, if not the message "ntpd error" is detected as error.</font><br>
<br><font size="2" face="sans-serif">HOST=s068310i</font><br><font size="2" face="sans-serif"> DISK %^/platform.* IGNORE</font><br><br><font size="2" face="sans-serif">HOST=s068310b</font><br><font size="2" face="sans-serif"> DISK %^/platform.* IGNORE</font><br>
<br><font size="2" face="sans-serif">HOST=s068a300</font><br><font size="2" face="sans-serif"> LOG %.* %(fatal|error) COLOR=red IGNORE=%(smb_proc_readdir_long|peer)</font><br><font size="2" face="sans-serif"> LOG %.* warning COLOR=yellow</font><br>
<font size="2" face="sans-serif"># DISK * 10 15</font><br><br><font size="2" face="sans-serif">HOST=s068c327</font><br><font size="2" face="sans-serif"> DISK /mnt IGNORE</font><br><br><font size="2" face="sans-serif">#HOST=%s068c32.*</font><br>
<font size="2" face="sans-serif">HOST=s068c326</font><br><font size="2" face="sans-serif">#HOST=s068c320,s068c321,s068c322,s068c323,s068c324,s068c325,s068c326,s068c327</font><br><font size="2" face="sans-serif"> LOG %.* %(fatal|error) IGNORE=%ntpd COLOR=red #(***)</font><br>
<br><font size="2" face="sans-serif">HOST=s068c320,s068c321,s068c322</font><br><font size="2" face="sans-serif"> PROC "lmgrd -c" 1 1</font><br><font size="2" face="sans-serif"> PROC "pam_lmd" 1 1</font><br>
<br><font size="2" face="sans-serif">DEFAULT</font><br><font size="2" face="sans-serif"> # These are the built-in defaults.</font><br><font size="2" face="sans-serif"> UP 1h</font><br><font size="2" face="sans-serif"> LOAD 5.0 10.0</font><br>
<font size="2" face="sans-serif"> DISK * 90 95</font><br><font size="2" face="sans-serif"> DISK /media/cdrom 101 101</font><br><font size="2" face="sans-serif"> MEMPHYS 100 101</font><br><font size="2" face="sans-serif"> MEMSWAP 50 80</font><br>
<font size="2" face="sans-serif"> MEMACT 90 97</font><br><br><font size="2" face="sans-serif"> LOG %.* %(fatal|error) COLOR=red IGNORE=%(read_socket_data|peer)</font><br><font size="2" face="sans-serif"> LOG %.* warning COLOR=yellow IGNORE=40960</font><br>
<br><br><font size="2" face="sans-serif">Thank you for help</font><br><br><font size="2" face="sans-serif">Thorsten Erdmann<br></font><font face="sans-serif"><font face="sans-serif, Arial, Helvetica" size="-1" color="#808080"><br>
If you are not the intended addressee, please inform us immediately that you have received this e-mail in error, and delete it. We thank you for your cooperation.<span> </span><br><br></font></font></div></span></span></blockquote>
</div><br></div>
</blockquote></div></div></div><br></div></blockquote></div><br><br clear="all"><br>-- <br>Kind regards<br><br>Nelson Amaral<br>
</div></div>