Help upgrade from 0.8.7i to 0.8.7i-PIA on debian

[Rno]

Hello,
I had my cacti working with 0.8.7i, pooling 70 devices, and graph all OK.

But I decide I need plugins, so I download the 0.8.7i-PIA, move the old cacti to cacti.old
unzip the new version, rename the directory to cacti, copy the RRA,Log and config.php
adapt the config.php for the plug arch
insert all info I can find on cacti.sql into the DB (plugin_config, plugin_hooks, plugin_realms, plugin_db_change

So now my cacti is still working fine, but I can't see the plugins option under user management,
so I think something is wrong, how can I find what and how to fix it ?

So far I have downloaded the mactrack plugin.

any help is welcome.

[cigamit]

Check your realm permissions, to make sure you have access to the Plugin Management page.

[Rno]

Check your realm permissions, to make sure you have access to the Plugin Management page.

Sorry I don't understand can you explain a little bit more:
Which realm ?
How can I check ?

If you talk about the right on the user management part, well that's my problem I don't see plugin Management

[cigamit]

When you were grabbing stuff out of the cacti.sql, did you happen to grab the 2 inserts for plugin_hooks?

Run this SQL query.
SELECT * FROM `plugin_hooks`;

[Rno]

yes I did:
mysql> SELECT * FROM `plugin_hooks`;
+----+----------+----------------------+------+------------------------------+--------+
| id | name | hook | file | function | status |
+----+----------+----------------------+------+------------------------------+--------+
| 1 | internal | config_arrays | | plugin_c
onfig_arrays | 1 |
| 2 | internal | draw_navigation_text | | p
lugin_draw_navigation_text | 1 |
+----+----------+----------------------+------+------------------------------+--------+

[wdennis]

Having the same issue, different path to get there however... see post http://forums.cacti.net/viewtopic.php?f=21&t=46061 for details.

Thanks,
Will

[wdennis]

Look in User Management at the user's Realm Perm's, and see if "Plugin Management" is unchecked -- if so, just check the checkbox and save. This worked for me...

[Rno]

I don't see the plugin management under the user setting. that's th whole point !!

[Rno]

So the problem is on the Database, here is what I've done to find that:

Drop the actual cacti DB (after 3 different backup )
Create a empty DB
insert the script cacti.sql ( mysql -p cacti < cacti.sql)

then I can see the plugin management for every user, but then I loose all my device.

I try to do some export with PhpMyAdmin but I can't find the right way to export the data and import it again without loosing the plugin management option.

Anyone have a good information how I can dump my DB, create a new working one then import my data, without broking the plugin management option ?

[Rno]

Ok I find the problem !!!

On the table plugin_hooks, there was a new line after the first letter (cut and past of the plugin part of the script cacti.sql) and that where causing cacti not be able to interpret the function of the 2 entry

Removing the new line solve my problem