-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
sean finney wrote:
> this may be a silly question, but have you tried changing the rrdtool
> version to 1.3.x? does the "working" system also use 1.2.x? i believe
> that 1.3.x should be the version available in lenny, maybe it's just that
> after upgrading this wasn't detected and the old value was retained?
Hello, tried that but it didn't work. I had however bypassed some
information about the upgrade. Ran the upgrade script this morning after
switching to lenny packages, i am getting a substantial amount of errors :
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.6k -> 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`)
[Fail] ALTER TABLE `poller_item` ADD INDEX `action`(`action`)
[Fail] ALTER TABLE `user_auth` ADD INDEX `username`(`username`)
[Fail] ALTER TABLE `user_auth` ADD INDEX `realm`(`realm`)
[Fail] ALTER TABLE `user_log` ADD INDEX `username`(`username`)
[Fail] ALTER TABLE `data_input` ADD INDEX `name`(`name`)
[Fail] ALTER TABLE `user_auth` ADD COLUMN `enabled` CHAR(2) DEFAULT 'on'
[Fail] ALTER TABLE `user_auth` ADD INDEX `enabled`(`enabled`)
[Fail] ALTER TABLE `host` ADD COLUMN `availability_method` SMALLINT(5)
UNSIGNED NOT NULL default '2' AFTER `snmp_timeout`
[Fail] ALTER TABLE `host` ADD COLUMN `ping_method` SMALLINT(5) UNSIGNED
default '0' AFTER `availability_method`
[Fail] ALTER TABLE `host` ADD COLUMN `ping_port` INT(12) UNSIGNED
default '0' AFTER `ping_method`
[Fail] ALTER TABLE `host` ADD COLUMN `ping_timeout` INT(12) UNSIGNED
default '500' AFTER `ping_port`
[Fail] ALTER TABLE `host` ADD COLUMN `ping_retries` INT(12) UNSIGNED
default '2' AFTER `ping_timeout`
[Fail] ALTER TABLE `host` ADD COLUMN `max_oids` INT(12) UNSIGNED default
'10' AFTER `ping_retries`
[Fail] ALTER TABLE `host` ADD COLUMN `notes` TEXT AFTER `hostname`
[Fail] ALTER TABLE `host` ADD COLUMN `snmp_auth_protocol` CHAR(5)
default '' AFTER `snmp_password`
[Fail] ALTER TABLE `host` ADD COLUMN `snmp_priv_passphrase` varchar(200)
default '' AFTER `snmp_auth_protocol`
[Fail] ALTER TABLE `host` ADD COLUMN `snmp_priv_protocol` CHAR(6)
default '' AFTER `snmp_priv_passphrase`
[Fail] ALTER TABLE `host` ADD COLUMN `snmp_context` VARCHAR(64) default
'' AFTER `snmp_priv_protocol`
[Fail] ALTER TABLE `poller_item` ADD COLUMN `snmp_auth_protocol` CHAR(5)
default '' AFTER `snmp_password`
[Fail] ALTER TABLE `poller_item` ADD COLUMN `snmp_priv_passphrase`
varchar(200) default '' AFTER `snmp_auth_protocol`
[Fail] ALTER TABLE `poller_item` ADD COLUMN `snmp_priv_protocol` CHAR(6)
default '' AFTER `snmp_priv_passphrase`
[Fail] ALTER TABLE `poller_item` ADD COLUMN `snmp_context` VARCHAR(64)
default '' AFTER `snmp_priv_protocol`
[Fail] INSERT INTO settings VALUES ('auth_method','1')
[Success] UPDATE `settings` SET name = 'user_template' WHERE name =
'ldap_template'
[Success] DELETE FROM `settings` WHERE name = 'global_auth'
[Success] DELETE FROM `settings` WHERE name = 'ldap_enabled'
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=1
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=6
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=10
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=11
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=12
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=14
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=15
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=27
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=32
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=33
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=30
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=35
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=36
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=37
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=38
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=39
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=40
[Success] UPDATE host SET availability_method=1, ping_method=2,
ping_port=33439, ping_timeout=400, ping_retries=1 WHERE id=41
[Success] INSERT INTO data_input_fields VALUES (DEFAULT,
'20832ce12f099c8e54140793a091af90',1,'SNMP Authenticaion Protocol
(v3)','snmp_auth_protocol','in','',0,'snmp_auth_protocol','','')
[Success] INSERT INTO data_input_fields VALUES (DEFAULT,
'c60c9aac1e1b3555ea0620b8bbfd82cb',1,'SNMP Privacy Passphrase
(v3)','snmp_priv_passphrase','in','',0,'snmp_priv_passphrase','','')
[Success] INSERT INTO data_input_fields VALUES (DEFAULT,
'feda162701240101bc74148415ef415a',1,'SNMP Privacy Protocol
(v3)','snmp_priv_protocol','in','',0,'snmp_priv_protocol','','')
[Success] INSERT INTO data_input_fields VALUES (DEFAULT,
'2cf7129ad3ff819a7a7ac189bee48ce8',2,'SNMP Authenticaion Protocol
(v3)','snmp_auth_protocol','in','',0,'snmp_auth_protocol','','')
[Success] INSERT INTO data_input_fields VALUES (DEFAULT,
'6b13ac0a0194e171d241d4b06f913158',2,'SNMP Privacy Passphrase
(v3)','snmp_priv_passphrase','in','',0,'snmp_priv_passphrase','','')
[Success] INSERT INTO data_input_fields VALUES (DEFAULT,
'3a33d4fc65b8329ab2ac46a36da26b72',2,'SNMP Privacy Protocol
(v3)','snmp_priv_protocol','in','',0,'snmp_priv_protocol','','')
[Success] INSERT INTO rra VALUES
(DEFAULT,'283ea2bf1634d92ce081ec82a634f513','Hourly (1 Minute
Average)',0.5,1,500,14400)
[Success] INSERT INTO `rra_cf` VALUES (9,1), (9,3)
[Success] UPDATE settings SET name='path_spine' WHERE name='path_cactid'
0.8.7 -> 0.8.7a
[Fail] ALTER TABLE `graph_templates_item` ADD COLUMN `alpha` CHAR(2)
DEFAULT 'FF' AFTER `color_id`;
[Fail] ALTER TABLE `graph_templates_graph` ADD COLUMN
`t_scale_log_units` CHAR(2) DEFAULT 0 AFTER `auto_scale_log`, ADD COLUMN
`scale_log_units` CHAR(2) DEFAULT '' AFTER `t_scale_log_units`;
0.8.7a -> 0.8.7b
[Fail] ALTER TABLE `graph_templates_item` ADD INDEX `task_item_id` (
`task_item_id` )
[Fail] ALTER TABLE `data_input_data` ADD INDEX `t_value`(`t_value`)
> * check the contents of /var/log/cacti, particularly poller-error.log
> to see if there's anything out of the ordinary showing up in these
> files.
Bingo, i got a lot of these:
06/18/2009 01:42:41 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!,
Error:'1060', SQL:"ALTER TABLE `host` ADD COLUMN `snmp_context`
VARCHAR(64) default '' AFTER `snmp_priv_protocol`'
06/18/2009 01:42:41 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!,
Error:'1060', SQL:"ALTER TABLE `poller_item` ADD COLUMN
`snmp_auth_protocol` CHAR(5) default '' AFTER `snmp_password`'
06/18/2009 01:42:41 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!,
Error:'1060', SQL:"ALTER TABLE `poller_item` ADD COLUMN
`snmp_priv_passphrase` varchar(200) default '' AFTER `snmp_auth_protocol`'
I am still investigating how to fix the DB. Sorry for the time it took
me to get back to you.
Cheers,
Steph
- --
Stephane Dudzinski - IT Manager
DIAS - http://www.dias.ie -
Phone : VoIP +353-1-4406656 x 335
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iEYEARECAAYFAko6N6IACgkQxCVslAry32D4oACeLazKD4gF90u2yo2qRe4twiTb
ggcAnjjYmZznAIx19qLQHNU7JiQqOtS9
=qg0L
-----END PGP SIGNATURE-----
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
