设为首页收藏本站

LinuxTone | 运维专家网论坛 - 最棒的Linux运维与开源架构技术交流社区!

 找回密码
 注册

QQ登录

只需一步,快速开始

#公告#抱歉,网站将关闭,不再开放。由于PC时代已远逝 。在这个后移动互联网时代,我们继续携手前行,保持对技术的热情。共同构建linuxtone知识星球欢迎加入,一起讨论技术、招聘人才、分享资源。请新老linuxtone人 扫码移步到 知识星球:linuxtone

学习是一种信仰!分享是一种快乐!能力= 心态 * 沟通 * 知识 (你的每一天需要正能量!)

 网站的发展需要你贡献一份力量!希望你能每天坚持看贴1小时,并回答网友的问题!祝你在浏览论坛的过程中取得进步!谢谢!linuxtone加油!大家加油! 友情提示: 你今天学习了吗?你今天进步了吗?少一点抱怨!多一点进步!Life is short ! Why not linuxtone ?  

网站的发展、感谢每位坛友的努力!

查看: 5647|回复: 2

[others] 刚部署的cacti,想让它监控mysql,但mysql有图无数据, [复制链接]

Rank: 8Rank: 8

签到
255
注册时间
2011-12-20
最后登录
2016-1-13
在线时间
103 小时
阅读权限
90
积分
25269
帖子
53
主题
9
精华
0
UID
16781
发表于 2012-7-21 15:18:33 |显示全部楼层
本帖最后由 启动→渴望 于 2012-7-21 16:47 编辑

系统版本 centos6.2 86_64
php version   5.2.6
mysql  version 5.5.25
apache  version  2.2.22
cacti  version  0.8.7h
net-snmp  version 5.5
导入的mysql的的监控模板是 better-cacti-templates-1.1.8 ,现在是cacti能监控到系统的信息
如图:

不能监控到mysql的的数据, 有图形但是均为nan
如图:

大家看看是神马情况??
这是cacti的日志一直有警告:

07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[116] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[114] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[112] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[110] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[118] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[120] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[122] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[124] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[126] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[128] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[130] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[132] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[134] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[136] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[138] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[140] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[142] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[144] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[146] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[148] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[150] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[152] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[154] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[156] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[158] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[160] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[162] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[164] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[166] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[168] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[170] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[172] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[174] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[176] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[178] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[180] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[182] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[184] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[186] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[188] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[190] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - CMDPHP: Poller[0] Host[6] DS[192] WARNING: Result from CMD not valid.  Partial Result: U
07/21/2012 03:20:01 PM - SYSTEM STATS: Time:0.4721 Method:cmd.php Processes:1 Threads:N/A Hosts:5 HostsPerProcess:5 DataSources:102 RRDsProcessed:98
07/21/2012 03:20:01 PM - SYSTEM THOLD STATS: Time:0.0011 Tholds:0 DownHosts:0
07/21/2012 03:20:01 PM - SYSTEM SYSLOG STATS:Time:0.06 Deletes:0 Incoming:0 Removes:0 XFers:0 Alerts:1 Alarms:0 Reports:0

在补充一点,在手动执行/usr/local/php/bin/php /usr/local/apache/htdocs/cacti/poller.php --debug --force
会这 错误:
sh: path_php_binary: command not found
Waiting on 1 of 1 pollers.
ERROR: Not enough arguments
sh: path_php_binary: command not found
Waiting on 1 of 1 pollers.
ERROR: Not enough arguments
sh: path_php_binary: command not found
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
ERROR: Not enough arguments
sh: path_php_binary: command not found
Waiting on 1 of 1 pollers.
ERROR: Not enough arguments
sh: path_php_binary: command not found
Waiting on 1 of 1 pollers.
ERROR: Not enough arguments
07/21/2012 04:44:03 PM - SYSTEM STATS: Time:0.5165 Method:cmd.php Processes:1 Threads:N/A Hosts:5 HostsPerProcess:5 DataSources:102 RRDsProcessed:98
Loop  Time is: 0.52
Sleep Time is: 299.48
Total Time is: 0.52
07/21/2012 04:44:03 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/local/php/bin/php, ARGS:  -q /usr/local/apache/htdocs/cacti/plugins/syslog/syslog_process.php]

Rank: 8Rank: 8

注册时间
2011-12-20
最后登录
2016-1-13
在线时间
103 小时
阅读权限
90
积分
25269
帖子
53
主题
9
精华
0
UID
16781
发表于 2012-7-21 16:12:26 |显示全部楼层
mojie126 发表于 2012-7-21 16:08
给mysql设置用户了么...?

这个当然有过了, 赋予了  all privileges的全新

使用道具 举报

Rank: 8Rank: 8

注册时间
2009-8-16
最后登录
2017-2-22
在线时间
82 小时
阅读权限
90
积分
24656
帖子
83
主题
4
精华
0
UID
4811
发表于 2012-7-22 14:30:23 |显示全部楼层
仔细看看那个模版吧。可能模版里调用的命令和你的路径不匹配

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

IT运维专家网感谢您的支持

合作联系: QQ:67888954/MSN:cnseek@msn.com/mail:netseek@linuxtone.org

Archiver|手机版|感谢所有关心和支持过LinuxTone的朋友们 转载本站内容请注明原作者名及出处 ( 京ICP备08103151 )   |

GMT+8, 2019-10-15 06:40 , Processed in 0.021534 second(s), 14 queries , Apc On.

Powered by Discuz! X2 Licensed

© 2001-2011 Comsenz Inc.

回顶部