<br clear="all"><meta charset="utf-8"><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 <span class="Object" id="OBJ_PREFIX_DWT319" style="color: rgb(0, 0, 139); text-decoration: none; cursor: pointer; ">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 class="Object" id="OBJ_PREFIX_DWT320" style="color: rgb(0, 0, 139); text-decoration: none; cursor: pointer; white-space: pre-line; ">2010-03-26</span> 14:54:26 </i> </pre>
<pre style="white-space: pre-line; "><font class="Apple-style-span" face="'times new roman', 'new york', times, serif" style="white-space: pre-line; "><span class="Apple-style-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 class="Apple-style-span" face="'times new roman', 'new york', times, serif" style="white-space: pre-line; "><span class="Apple-style-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 class="Apple-style-span" face="'times new roman', 'new york', times, serif" style="white-space: pre-line; "><span class="Apple-style-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 class="Apple-style-span" face="'times new roman', 'new york', times, serif" style="white-space: pre-line; "><span class="Apple-style-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 class="Apple-style-span" face="'times new roman', 'new york', times, serif" style="white-space: pre-line; "><span class="Apple-style-span" style="white-space: pre-line; 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" style="white-space: pre-line; "><span class="Apple-style-span" style="white-space: pre-line; 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></div></span>-- <br>Kind regards<br><br>Nelson Amaral<br>