Migration from 0.8.6j to 0.8.7b

[beno]

Hi,

I have migrated the applications from 0.8.6j to 0.8.7b. However, I encountered the following while upgrading in progress:

However, on the screen, I saw the following error:
Notice: Undefined variable: ldap_enable_db in /var/www/html/install/0_8_6j_to_0_8_7.php on line 79


Cacti Installation Guide
Upgrade results:

WARNING: One or more of the SQL queries needed to upgraded your Cacti installation has failed. Please see below for more details. Your Cacti MySQL user must have SELECT, INSERT, UPDATE, DELETE, ALTER, CREATE, and DROP permissions. You should try executing the failed queries as 'root' to ensure that you do not have a permissions problem.

0.8.6j -> 0.8.7

[Fail] ALTER TABLE `graph_templates_graph` ADD COLUMN `t_slope_mode` CHAR(2) DEFAULT 0 AFTER `vertical_label`, ADD COLUMN `slope_mode` CHAR(2) DEFAULT 'on' AFTER `t_slope_mode`;

[Success] ALTER TABLE `host` MODIFY COLUMN `status_last_error` VARCHAR(255);

[Success] ALTER TABLE `data_template_rrd` MODIFY COLUMN `rrd_maximum` VARCHAR(20) NOT NULL DEFAULT 0, MODIFY COLUMN `rrd_minimum` VARCHAR(20) NOT NULL DEFAULT 0

[Fail] ALTER TABLE `host` ADD INDEX `disabled`(`disabled`)

[Fail] ALTER TABLE `poller_item` ADD INDEX `rrd_next_step`(`rrd_next_step`)

Another question i have is that I do not wish to export the rrd files from the old box and wish to start afresh. How do i go about doing it?

Pse advise what the correction steps I need to take. Thanks.

[TheWitness]

Well, unless your architecture did not change, you don't have to do anything. However, the following scenarios require dump/import:

UNIX -> Linux,
Linux -> Windows,
Winodws -> LInux,
Linux 32 -> Linux 64,
Linux 64 -> Linux 32,
Unix (Any) -> Unix (Anything Else),

There is a nice utility that I wrote for doing this. It requires a shared file system, but is completely self sustaining. You run once script from the Old Server while at the same time running another from the other server. It's quite simple.

TheWitness