Unable to edit/create hosts following 0.8.7b upgrade

[AndrewRobinson]

Upgraded to 0.8.7b and now everytime I edit or create a host I get Error: Save Failed

All I can see in the log that MIGHT cause this:

02/13/2008 01:13:22 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO settings (name, value) VALUES ('url_path', 'cacti\')'

Any help please!!

[fmangeant]

Hi

do you use the Monitor plugin ?

[TheGrudge]

I also have problems upgrading from 0.8.7a->b.
I get the following error in the upgrade dialog:

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.7a -> 0.8.7b

[Fail] ALTER TABLE `graph_templates_item` ADD INDEX `task_item_id` ( `task_item_id` )

[Success] ALTER TABLE `data_input_data` ADD INDEX `t_value`(`t_value`)

I downloaded the 0.8.7b archive, unpacked it, copied the original database for running the new cacti in a testing environment, copied all RRD files, installed the plugin arch, installed the 4 plugins (settings,update,monitor,thold) and setup the config. But now I get the above error.
The database user has all privileges and is also able to alter tables.

[rony]

What if you run the query by hand, I suspect the index already exists.

If so, then that error is a non-issue.

[TheGrudge]

Oh one more thing: I installed all 3 patches for 0.8.7a before, so maybe these patches already changed some database tables?

[rony]

Patches never change the database. But, a plugin might have..

[fmangeant]

For the "Save Failed" error when saving a device, which seems to be Monitor 0.8.2 related, Jimmy posted that earlier :

Click the monitor tab (after giving yourself permissions) and then try to save a device. It seems the setup table function for it doesn't run until you click the tab, I've found that before and already have a fix for it, just haven't released it yet.

It worked for me.

[AndrewRobinson]

For the "Save Failed" error when saving a device, which seems to be Monitor 0.8.2 related, Jimmy posted that earlier :
It worked for me.

And it worked for me too, thank you

[TheGrudge]

Running the ALTER TABLE query gives me the following error:

#1061 - Duplicate key name 'task_item_id'

[rony]

Yep, index already exists, I would not worry about the upgrade error.

[TheGrudge]

Hmmm something is not working out here. Every URL in the new 0.8.7b install is mapped to something like

http://host/cacti-test/st/xxx.php

When I log into the new cacti installation, no CSS is loaded and if I click on Console, the above mapping is taking place, so I get a "file not found" error.

I set the

$config['url_path'] = '/cacti-test/';

varibale, but it is not working. What happened here? Never had problems when upgrading cacti. Maybe the plugin arch or a plugin is mapping those urls wrong?

[fmangeant]

Do you use plugin arch 2.0 ?

[TheGrudge]

yes...

[fmangeant]

See my other post

I had to add

Code: Select all

$config['url_path'] = '/cacti/';

at the bottom of include/plugins.php

[TheGrudge]

Ah ok, it's working now...