<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><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>On Mar 27, 2010, at 5:44 AM, <a href="mailto:amaral8011@googlemail.com">amaral8011@googlemail.com</a> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">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">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">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 class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-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; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="font-family: 'Times New Roman'; font-size: 16px; "><span><br class="Apple-interchange-newline">Hi </span><div><span><br></span></div><div><span id="088eadc5-6fd9-48b6-a643-fe9c6700bf20">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 id="088eadc5-6fd9-48b6-a643-fe9c6700bf20"><br></span></div><div><span id="088eadc5-6fd9-48b6-a643-fe9c6700bf20">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 id="088eadc5-6fd9-48b6-a643-fe9c6700bf20"><br></span></div><div><span id="088eadc5-6fd9-48b6-a643-fe9c6700bf20">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 id="088eadc5-6fd9-48b6-a643-fe9c6700bf20"><br></span></div><div><span id="088eadc5-6fd9-48b6-a643-fe9c6700bf20">please note that the rrd file is created in the data folder</span></div><div><span id="088eadc5-6fd9-48b6-a643-fe9c6700bf20"><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 class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-style-span" style="font-size: medium; ">and have added the following in hobbitserver.cfg</span></font></pre><pre><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-style-span" style="font-size: medium; ">in TEST2RRD i added mysql=ncv</span></font></pre><pre><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-style-span" style="font-size: medium; ">and then added the following line </span></font></pre><pre><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-style-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 class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-style-span" style="font-size: medium; ">also in </span></font><span class="Apple-style-span" style="white-space: normal; "><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-style-span" style="font-size: medium; ">hobbitgraph.cfg i added the following</span></font></span></pre></div><div><span id="088eadc5-6fd9-48b6-a643-fe9c6700bf20">(i only have the first 2 instances of data for testing purposes)</span></div><div><span id="088eadc5-6fd9-48b6-a643-fe9c6700bf20"><br></span></div><div><span id="088eadc5-6fd9-48b6-a643-fe9c6700bf20"><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 id="088eadc5-6fd9-48b6-a643-fe9c6700bf20"><br><br>Regards<br><br>Nelson Amaral<br></span><br>----- Original Message -----<br>From: "thorsten erdmann" <<a href="mailto:thorsten.erdmann@daimler.com">thorsten.erdmann@daimler.com</a>><br>To:<span class="Apple-converted-space"> </span><a href="mailto:hobbit@hswn.dk">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 class="Apple-converted-space"> </span><br><br></font></font></div></span></span></blockquote></div><br></div>
</blockquote></div><br></body></html>