Cacti

spine代替cmd.php提高运行效率

yum -y install libtool.x86_64 libtool-ltdl-devel.x86_64 mysql-devel.x86_64 net-snmp-devel.x86_64
 
wget http://www.cacti.net/downloads/spine/cacti-spine-0.8.7e.tar.gz
 
tar -zxvf  cacti-spine-0.8.7e.tar.gz
 
./configure && make && make install
 
### TEST
/usr/local/spine/bin/spine

每分钟数据更新

１、更改cron.d设置
２、cacti管理界面中刷新时间更改为1分种
３、数据库中template也需要更新,也可以修改Management -> date source -> RRAs
 
DELETE FROM rra; -- 4 rows affected;
INSERT INTO rra VALUES (1,'c21df5178e5c955013591239eb0afd46','Daily (1 Minute Average)',0.5,1,8000,86400);
INSERT INTO rra VALUES (2,'0d9c0af8b8acdc7807943937b3208e29','Weekly (30 Minute Average)',0.5,30,1600,604800);
INSERT INTO rra VALUES (3,'6fc2d038fb42950138b0ce3e9874cc60','Monthly (2 Hour Average)',0.5,120,1600,2678400);
INSERT INTO rra VALUES (4,'e36f3adb9f152adfa5dc50fd2b23337e','Yearly (1 Day Average)',0.5,1440,1600,33053184);
 
UPDATE data_template_data SET rrd_step=60 WHERE rrd_step=300;
UPDATE data_template_rrd SET rrd_heartbeat=120 WHERE rrd_heartbeat=600;
UPDATE poller_item SET rrd_step = 60 WHERE rrd_step = 300;

reset password
 
shell> mysql -u root -p cacti
Now execute the following SQL:
 
mysql> update user_auth set password=md5('admin') where username='admin';