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
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