Manage Plugin 0.6 for monitoring networks, servers...

[YoMarK]

Tnx gilles!
It seems to be working great(better then older versions).

However I have a problem with the win_services template(since cacti 0.8.7 i did not use it), but I will post that in the other topic
Edit:
"solved".

Edit2:
Also there are some minor problems with the tree view. It seems that there are some images missing when unfolding the tree(the + and - images).

[chimpooooo]

Upgraded to 0.6 but unfortunately still cant add a site/group.

Cacti log:

04/18/2008 09:30:44 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1366', SQL:"INSERT INTO manage_sites ( id , name ) VALUES ('', 'lab')'

Manage Debug:

Everything is ok except

Plugin Thold : NOK Install Plugin Thold.
User settings : NOK Save your settings (0).

It is interesting to note that when i uninstall the plugin in get the following errors

04/18/2008 09:56:18 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"DELETE FROM `plugin_update_info` WHERE `plugin` = 'manage''
04/18/2008 09:56:18 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1051', SQL:"DROP TABLE `manage_host_services`'
04/18/2008 09:56:18 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1051', SQL:"DROP TABLE `manage_device_type`'
04/18/2008 09:56:18 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1051', SQL:"DROP TABLE `manage_method`'


I checked in mysql and the manage tables were NEVER updated. Please help!

[gilles]

chimpooooo, can you use phpmyadmin and type the sql commands ?

is there errors ?

[YoMarK]

chimpooooo: you should try to drop the Plugin Architecture tables in the database, and import pa.sql included in the PA zipfile.

[hboogz]

I'm not seeing a "manage" tab ? I have it enabled on the user admin and have all the NTFS permissions set up correctly.

Also, my hostinfo looks a little off.

[hboogz]

you can disregard te above post, i've opened a separate thread. I received the manage thread!

[chimpooooo]

gilles

SQL query:
INSERT INTO manage_sites ( id , name ) VALUES ('', 'lab')

MySQL said:
#1366 - Incorrect integer value: '' for column 'id' at row 1

Well that was pretty obvious. I entered an integer in SQL and it added the site. Had to do the same thing to add a group.

But if i try to manage the device i see errors coming up in the log. Tried running the same query in SQL

SELECT count( id )
FROM data_local
WHERE data_template_id =
AND snmp_index =23
AND host_id =11

for some weird reasons its missing all the integers id's in ALL the sql commands its trying to run

[YoMarK]

chimpooooo: those id-fields should be auto_increment(automatic value given), somehow this is not the case with your tables.

Could you give the output of the following query? :

[gilles]

yes, some tables need to be created with the keyword auto-increment
you can verify it with phpmyadmin and the provided sql files

[chimpooooo]

YoMarK and gilles

The following code did not give any error.

ALTER TABLE manage_sites CHANGE id id MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT


Which sql files do i use to reinsert the tables? do i delete the tables and then just import 1-manage-0.1.sql through mysql ? where do i enter the keyword auto-increment?

Thanks for your help guys

[gilles]

if the alter table code don't work (there is a typo in it "id id"), you can try to delete the table and recreate it with the right sql code (whatch for "create table manage_sites" in the sql files)

phpmyadmin is a good way to verify your installation

what is your version of mysql ?

[MagicOneXXX]

I too am having difficulty getting the plugin installed. I just upgraded from 0.8.6i to 0.8.7b with PIA 2.1

I've cleaned up my database of all manage_ tables, as well as the hosts and settings table for any manage references. I then re-added all of the sql files (no errors reported). I tried this procedure numerous time with both 0.5.2 and 0.6 (fresh, upgrades, etc)

When I go to Plugin Management -> uninstalled, manage does not show up.

Host info:

[chimpooooo]

gilles i am a newbie with this so can you give me an example of how to correctly add the table through mysql with the auto incerement parameter

[YoMarK]

chimpooooo: do you have phpmyadmin or something like that installed? In phpmyadmin it's easy to see if a table has a autoincrement field(they should be installed automatically).

[chrisgapske]

I am I the only one that when the manage plugin is enabled my threshold will no longer poll ?