Chappy
Joined: 22 Aug 2008 Posts: 3
|
Posted: Fri Aug 22, 2008 12:48 pm Post subject: Xaprb MySQL Templates Not Graphing |
|
|
I have dowloaded and installed the Xaprb MySQL templates, installed them and attached a graph to a host running MySQL (the Cacti server).
However, I'm getting the nan values in resulting graph. I am able to run the ss_get_mysql_stats.php from the command line and receive valid output:
| Code: | php ss_get_mysql_stats.php 127.0.0.1
a0:6589951 a1:2504 a2:893687 a3:222190 a4:0 a5:0 a6:0 a7:0 a8:0 a9:0 aa:0 ab:0 ac:0 ad:0 ae:0 af:0 ag:0 ah:0 ai:0 aj:0 ak:0 al:0 am:0 an:0 ao:0 ap:0 aq:0 ar:0 as:0 at:0 au:0 av:0 aw:0 ax:0 ay:0 az:0 b0:0 b1:0 b2:0 b3:0 b4:1282 b5:1616819 b6:0 b7:112 b8:64 b9:4258 ba:300 bb:1024 bc:64 bd:10 be:4422 bf:35 bg:2 bh:0 bi:12 bj:32428 bk:1 bl:100 bm:0 bn:32429 bo:0 bp:0 bq:0 br:0 bs:0 bt:0 bu:0 bv:0 bw:0 bx:0 by:0 bz:0 c0:0 c1:0 c2:1433087 c3:63327 c4:36568 c5:1129279 c6:124386 c7:17653 c8:0 c9:0 ca:0 cb:0 cc:0 cd:8109 ce:0 cf:10136 cg:0 ch:20749 ci:0 cj:85881 ck:544851 cl:31212 cm:27922 cn:339 co:0 cp:360679263 cq:173425126 cr:1048576 cs:0 ct:0 cu:0 cv:0 cw:32768 cx:0 cy:0 cz:0cacti@hostname |
A stats file is being written to /tmp every 5 minutes, again with valid data but no graphs.
The following is written to the Cacti Log File:
08/22/2008 01:50:05 PM - SPINE: Poller[0] Host[6] DS[97] SS[0] WARNING: Result from SERVER not valid. Partial Result: ...
Any ideas?
CentOS 5.2
Cacti 0.8.7b
Xaprb Cacti MySQL Templates 1.0.0
| Description: |
|
| Filesize: |
16.09 KB |
| Viewed: |
735 Time(s) |

|
|
|