一.数据库相关的常见问题
1.在安装php时或者Cactid/Spine/Cacti时出现
checking for mysql_init in -lmysqlclient_r... no
configure: error: MySQL libraries not found
解决办法:由于在编译php时没有加上--with-mysql=/usr/local/mysql 导致无法管理php开发api
2.在做php 连接数据库时出现 not defined mysql_connect()
解决办法:php没有关联php api, 检查php编译时是否加上了--with-mysql=/usr/local/mysql
3.在安装时,加入了--with-mysql=/usr/local/mysql
出现:whith "configure: error: MySQL libraries not found"
解决办法: 确定mysql可以正常运行的情况下,不要使用二进制的安装方式,自己手工编译,问题解决,
网上所谓的奖--with-mysql 改为--with-mysql-dir这种是错误,它编译通过的原因是由于,这种配置是错误的,./configure将其忽略了。
二.其他错误
错误一:
11/15/2010 07:34:42 PM - SPINE: Poller[0] FATAL: Unable to read configuration file! (Spine init)
11/15/2010 07:44:43 PM - SPINE: Poller[0] FATAL: MySQL Error:'1146', Message:'Table 'cacti.settings' doesn't exist' (Spine init)
解决:
检查你的spine 配置文件,或重新安装spine
错误二:编辑spine 时错误
checking if UCD-SNMP needs crypto support... no
checking if Net-SNMP needs crypto support... yes
checking for snmp_timeout in -lnetsnmp... no
Cannot find NET-SNMP libraries(snmp)... checking UCD-SNMP
checking for snmp_timeout in -lsnmp... no
configure: error: Cannot find UCD-SNMP libraries(snmp)
解决:
configure 时 加上--with-snmp=/usr/local/net-snmp/ 你的net-snmp路径
或不加或加上这个参数--with-static=/usr/local/lib
./configure --with-static=/usr/local/lib
错误三:
/usr/local/spine/spine
SPINE: Version 0.8.7b starting
11/15/2010 05:19:46 PM - SPINE: Poller[0] ERROR: SNMP Library Version Mismatch (5.3.1 vs 5.3.2.2) (Spine parent)
11/15/2010 05:00:01 PM - SPINE: Poller[0] ERROR: SNMP Library Version Mismatch (5.3.1 vs 5.3.2.2) (Spine parent)
此spine 和net-snmp的版本有问题
解决:
先卸载以前安装的net-snmtp 和spine
先安装net-snmp 然后再编译安装spine 此时你可以指定你的net-snmp 也可以不指定,都可以的。
错误四
11/15/2010 05:00:01 PM - POLLER: Poller[0] WARNING: Cron is out of sync with the Poller Interval! The Poller Interval is '60' seconds, with a maximum of a '300' second Cron, but 300 seconds have passed since the last poll!
11/15/2010 04:56:00 PM - SYSTEM STATS: Time:59.2263 Method:spine Processes:1 Threads:1 Hosts:2 HostsPerProcess:2 DataSources:21 RRDsProcessed:0
11/15/2010 04:56:00 PM - POLLER: Poller[0] Maximum runtime of 58 seconds exceeded. Exiting.
解决:
因为cron的时间与poller.php的时间差别有关
一般poller.php的跟新时间为60s,所以cron里边也要设置成每分钟跟新一次
如:
*/1 * * * * /usr/bin/php /var/www/html/cacti/poller.php > /dev/null 2>&1
错误五
##########
11/16/2010 01:10:03 PM - SYSTEM STATS: Time:1.1319 Method:spine Processes:1 Threads:1 Hosts:2 HostsPerProcess:2 DataSources:8 RRDsProcessed:7
11/16/2010 01:10:02 PM - SPINE: Poller[0] Host[4] ERROR: Empty result [127.0.0.1]: '/usr/bin/php -q /var/www/html/cacti/plugins/syslog/syslog_counter.php'
11/16/2010 01:09:11 PM - SYSTEM STATS: Time:1.1314 Method:spine Processes:1 Threads:1 Hosts:2 HostsPerProcess:2 DataSources:8 RRDsProcessed:7
11/16/2010 01:09:10 PM - SPINE: Poller[0] Host[4] ERROR: Empty result [127.0.0.1]: '/usr/bin/php -q /var/www/html/cacti/plugins/syslog/syslog_counter.php'
解决:
暂时的
delete from settings where name = 'syslog_last_incoming' ;
本文链接:https://www.kinber.cn/post/1281.html 转载需授权!
推荐本站淘宝优惠价购买喜欢的宝贝: