Rully's Blog

09 December 2006

Upgrade Cacti

Assalamu'alaikum Warahmatullahi Wabarakatuh


Coba upgrade cacti di notebook.

1. :~# apt-get install cacti

2. :~# adduser cacti

3. :~# mysql --user=root mysql

4. mysql> GRANT ALL ON cacti.* TO cacti@localhost IDENTIFIED BY 'cacti';

5. mysql> flush privileges;

6. mysql> exit

7. Edit file debian.php

:~# vim /etc/cacti/debian.php

$database_username='cacti';
$database_password='cacti';
$database_default='cacti';
$database_hostname='localhost';
$dbport='';
$dbtype='mysql';
?>


8. Browse ke: http://localhost/cacti/

- Next
- Please select the type of installation: Upgrade from cacti 0.8.x
- Next
- Upgrade results:
0.8.6f -> 0.8.6g
[Success] ALTER TABLE `host_snmp_cache` CHANGE `snmp_index` `snmp_index` VARCHAR( 255 ) NOT NULL;
[Success] ALTER TABLE `data_local` CHANGE `snmp_index` `snmp_index` VARCHAR( 255 ) NOT NULL;
[Success] ALTER TABLE `graph_local` CHANGE `snmp_index` `snmp_index` VARCHAR( 255 ) NOT NULL;
[Success] ALTER TABLE `graph_templates_graph` CHANGE `lower_limit` `lower_limit` VARCHAR ( 20 ) DEFAULT '0';
[Success] ALTER TABLE `graph_templates_graph` CHANGE `upper_limit` `upper_limit` VARCHAR ( 20 ) DEFAULT '0';
0.8.6g -> 0.8.6h
[Success] ALTER TABLE `host` MODIFY COLUMN `min_time` DECIMAL(10,5) DEFAULT 9.99999;
[Success] ALTER TABLE `host` MODIFY COLUMN `max_time` DECIMAL(10,5) DEFAULT 0.00000;
[Success] ALTER TABLE `host` MODIFY COLUMN `cur_time` DECIMAL(10,5) DEFAULT 0.00000;
[Success] ALTER TABLE `host` MODIFY COLUMN `avg_time` DECIMAL(10,5) DEFAULT 0.00000;
[Success] ALTER TABLE `user_log` MODIFY COLUMN `ip` VARCHAR(40);
[Success] UPDATE graph_templates_item SET text_format = '' WHERE local_graph_id <> 0 AND color_id = 0 AND graph_type_id IN(4,5,6,7,8) AND text_format <> '';
- Next
- Make sure all of these values are correct before continuing.
[FOUND] RRDTool Binary Path: The path to the rrdtool binary. -> /usr/bin/rrdtool
[FOUND] PHP Binary Path: The path to your PHP binary file (may require a php recompile to get this file). -> /usr/bin/php
[FOUND] snmpwalk Binary Path: The path to your snmpwalk binary. -> /usr/bin/snmpwalk
[FOUND] snmpget Binary Path: The path to your snmpget binary. -> /usr/bin/snmpget
[FOUND] snmpbulkwalk Binary Path: The path to your snmpbulkwalk binary. -> /usr/bin/snmpbulkwalk
[FOUND] snmpgetnext Binary Path: The path to your snmpgetnext binary. -> /usr/bin/snmpgetnext
[FOUND] Cacti Log File Path: The path to your Cacti log file. -> /usr/share/cacti/site/log/cacti.log
SNMP Utility Version: The type of SNMP you have installed. Required if you are using SNMP v2c or don't have embedded SNMP support in PHP. -> NET_SNMP 5.X
RRDTool Utility Version: The version of RRDTool that you have installed. -> RRDTool 1.2.x

- Finish


9. Login

Please enter your Cacti user name and password below:

User Name:

Password:


*waduh, lupa login yang lama*

10. Reset login

:~# mysql -u root cacti

mysql> update user_auth set password=md5('admin') where username='admin';

Query OK, 1 row affected (0.08 sec)

Rows matched: 1 Changed: 1 Warnings: 0


11. Browse ke: http://localhost/cacti/

12. Login

Please enter your Cacti user name and password below:

User Name: admin

Password: admin


13. Selesai


Wassalamu'alaikum Warahmatullahi Wabarakatuh