H,<div><br></div><div><br></div><div>Apologies in advance for all the emails.</div><div><br></div><div>I had a problem with the server and without wanting 3 messages went out (well 4 with this one :) )</div><div><br></div>
<div>I'm kind of new to hobbit so if you point me in the right direction i can probably find the solution.</div><div><br></div><div><br></div><div><br><div class="gmail_quote">On 26 March 2010 15:46, Nelson Amaral <span dir="ltr"><<a href="mailto:amaral8011@googlemail.com">amaral8011@googlemail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><br clear="all"><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 <span style="color:rgb(0, 0, 139);text-decoration:none">Mar</span> 26 14:54:26 2010 MySQL Server OK</i></h3><pre style="white-space:pre-line"><i style="white-space:pre-line">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 <span style="color:rgb(0, 0, 139);text-decoration:none;white-space:pre-line">2010-03-26</span> 14:54:26 </i> </pre>
<pre style="white-space:pre-line"><font face="'times new roman', 'new york', times, serif" style="white-space:pre-line"><span style="white-space:pre-line;font-size:medium">and have added the following in hobbitserver.cfg</span></font></pre>
<pre style="white-space:pre-line"><font face="'times new roman', 'new york', times, serif" style="white-space:pre-line"><span style="white-space:pre-line;font-size:medium">in TEST2RRD i added mysql=ncv</span></font></pre>
<pre style="white-space:pre-line"><font face="'times new roman', 'new york', times, serif" style="white-space:pre-line"><span style="white-space:pre-line;font-size:medium">and then added the following line</span></font></pre>
<pre style="white-space:pre-line"><font face="'times new roman', 'new york', times, serif" style="white-space:pre-line"><span style="white-space:pre-line;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 style="white-space:pre-line"><font face="'times new roman', 'new york', times, serif" style="white-space:pre-line"><span style="white-space:pre-line;font-size:medium">also in </span></font><span style="white-space:normal"><font face="'times new roman', 'new york', times, serif" style="white-space:pre-line"><span style="white-space:pre-line;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></div></span>-- <br>Kind regards<br><font color="#888888"><br>Nelson Amaral<br>
</font></blockquote></div><br><br clear="all"><br>-- <br>Kind regards<br><br>Nelson Amaral<br>
</div>