A bit more information:
On my host I'm monitoring, in the logs I see
03/16/2007 02:29:43 PM - CMDPHP: Poller[0] Host[19] DS[587] SERVER: C:\wamp\www\Cacti\scripts\win_services.php win_services xxx.xxx.xxx.xxx xxxxxxxxxxx 1 19 get servstate 21.79.102.102.105.99.101.83.99.97.110.78.84.32.76.105.115.116.101.110.101.114 , output: 1
This service is running, and is being graphed. I removed the patch from Mories, and cleared the poller cache. The service still seems to be polled as running without the patch, so no problems there.
When I select the service in Manage, it tells me it's down - do you know of a fix for this problem ? I am successfully monitoring processes and ports using your plugin - this is the last part I need to fix !!!
Thanks Gilles for all your support.
Manage Plugin 0.6.2 for monitoring networks, servers...
Moderators: Developers, Moderators
-
apperrault
- Cacti User
- Posts: 379
- Joined: Fri Feb 16, 2007 11:37 am
- Location: Emeryville, CA
- Contact:
Hi all,
I have downloaded the SVN version of the Manage Plugin, and I am getting some odd results. The one that i find very odd is when i go to the Misc tab on the settings, and click the link that says Debug (Click here to verify your tables) i have 3 entries that are NOK.
Table 'manage_tcp',
Champ 'thresold_ref' from table 'manage_host', and
Champ 'thresold' from table 'manage_host'.
Also, i fixed the error so i can add a site, but when i try and create a group, i select the site that the group will belong to, then i click Add, and i get the following error:
Does anyone know how i can fix these problems?
Any assistance would be GREATLY appreciated.
Thanks much
app
I have downloaded the SVN version of the Manage Plugin, and I am getting some odd results. The one that i find very odd is when i go to the Misc tab on the settings, and click the link that says Debug (Click here to verify your tables) i have 3 entries that are NOK.
Table 'manage_tcp',
Champ 'thresold_ref' from table 'manage_host', and
Champ 'thresold' from table 'manage_host'.
Also, i fixed the error so i can add a site, but when i try and create a group, i select the site that the group will belong to, then i click Add, and i get the following error:
Code: Select all
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\cacti\plugins\manage\manage_groups.php on line 242
Any assistance would be GREATLY appreciated.
Thanks much
app
[b]Cacti Version[/b] - 0.8.7b
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]
-
mcutting
- Cacti Guru User
- Posts: 1884
- Joined: Mon Oct 16, 2006 5:57 am
- Location: United Kingdom
- Contact:
Hi Apperrault.
I had a similar issue. It seems to have something to do with the tables not getting created properly. To get around this, do the following
DROP all manage_* tables using:
ALTER TABLE `host` DROP `manage`;
DROP TABLE `manage_host`;
DROP TABLE `manage_method`;
DROP TABLE `manage_alerts`;
DROP TABLE `manage_tcp`;
DROP TABLE `manage_device_type`;
DROP TABLE `manage_templates`;
DROP TABLE `manage_groups`;
DROP TABLE `manage_services`;
DROP TABLE `manage_process`;
DROP TABLE `manage_poller_output`;
DROP TABLE `manage_sites`;
DELETE FROM `plugin_update_info` WHERE `plugin` = 'manage';
DELETE FROM `settings` WHERE `name` = 'manage_poller';
DELETE FROM `settings` WHERE `name` = 'manage_events';
DELETE FROM `settings` WHERE `name` = 'manage_method';
DELETE FROM `settings` WHERE `name` = 'manage_date';
DELETE FROM `settings` WHERE `name` = 'manage_use_patch';
DELETE FROM `settings` WHERE `name` = 'manage_send';
DELETE FROM `settings` WHERE `name` = 'manage_netsend_events';
DELETE FROM `settings` WHERE `name` = 'manage_netsend_method';
DELETE FROM `settings` WHERE `name` = 'manage_list';
DELETE FROM `settings` WHERE `name` = 'manage_list_2';
DELETE FROM `settings` WHERE `name` = 'manage_list_separator';
DELETE FROM `settings` WHERE `name` = 'manage_full_separator';
DELETE FROM `settings` WHERE `name` = 'manage_simple_separator';
DELETE FROM `settings` WHERE `name` = 'manage_legend';
DELETE FROM `settings` WHERE `name` = 'manage_poller_hosts';
DELETE FROM `settings` WHERE `name` = 'manage_cycle_delay';
DELETE FROM `settings` WHERE `name` = 'manage_cycle_refresh';
DELETE FROM `settings` WHERE `name` = 'manage_poller_plus';
DELETE FROM `settings` WHERE `name` = 'manage_perl';
DELETE FROM `settings` WHERE `name` = 'manage_order1';
DELETE FROM `settings` WHERE `name` = 'manage_order2';
DELETE FROM `settings` WHERE `name` = 'manage_order3';
DELETE FROM `settings` WHERE `name` = 'manage_order4';
DELETE FROM `settings` WHERE `name` = 'manage_order5';
DELETE FROM `settings` WHERE `name` = 'manage_theme';
DELETE FROM `settings` WHERE `name` = 'manage_sound';
Re-create all the tables by using
alter table host add manage char(3) default '' not null after disabled;
CREATE TABLE manage_host ( id mediumint(8) unsigned NOT NULL default '0', uptime bigint(20) default NULL, type mediumint(8) unsigned NOT NULL default '0', services text, statut text);
CREATE TABLE manage_method ( id mediumint(8) unsigned NOT NULL default '0', method text);
CREATE TABLE manage_alerts (idh mediumint(8) unsigned NOT NULL default '0', datetime datetime NOT NULL default '0000-00-00 00:00:00', ids mediumint(8) unsigned default '0', message text, note text, ida mediumint(9) unsigned NOT NULL auto_increment, PRIMARY KEY (ida));
CREATE TABLE manage_host_services ( id mediumint(8) unsigned NOT NULL default '0', services mediumint(8) unsigned NOT NULL default '0', statut text);
INSERT INTO settings VALUES ('manage_events', '5');
INSERT INTO settings VALUES ('manage_poller', '0');
INSERT INTO settings VALUES ('manage_method', '0');
INSERT INTO settings VALUES ('manage_date', '0');
ALTER TABLE manage_host ADD `force` MEDIUMINT(8) unsigned NOT NULL default '9';
CREATE TABLE manage_device_type ( id MEDIUMINT(8) NOT NULL AUTO_INCREMENT , name TEXT, image TEXT, PRIMARY KEY ( id ) );
INSERT INTO manage_device_type VALUES (1, 'Windows 2003 Host', 'win2003.png');
INSERT INTO manage_device_type VALUES (2, 'Windows XP Host', NULL);
INSERT INTO manage_device_type VALUES (3, 'Windows 2000 Host', 'win2000.png');
INSERT INTO manage_device_type VALUES (4, 'Windows NT4 Host', 'winnt.png');
INSERT INTO manage_device_type VALUES (5, 'Windows 9x Host', NULL);
INSERT INTO manage_device_type VALUES (6, 'Linux Host', 'linux.png');
INSERT INTO manage_device_type VALUES (7, 'Router', 'router.png');
INSERT INTO manage_device_type VALUES (8, 'Switch', 'switch.png');
INSERT INTO manage_device_type VALUES (9, 'Other', 'other.png');
CREATE TABLE manage_templates ( id MEDIUMINT(8) NOT NULL auto_increment, name TEXT, tcp_ports TEXT, PRIMARY KEY (id) );
INSERT INTO manage_templates VALUES (1, 'Mail Server (Basic)', '110;25');
INSERT INTO manage_templates VALUES (2, 'Mail Server (Enhanced)', '110;995;25;143;993;80;443');
INSERT INTO manage_templates VALUES (3, 'Switch/Router', '23');
INSERT INTO manage_templates VALUES (4, 'Web Server', '80;443');
INSERT INTO manage_templates VALUES (5, 'Windows 200x Domain Controler', '389');
INSERT INTO manage_templates VALUES (6, 'DNS Server', '53');
alter table manage_host add `group` MEDIUMINT(8) default '0';
CREATE TABLE manage_groups ( id MEDIUMINT(8) NOT NULL auto_increment, name TEXT, PRIMARY KEY (id) );
INSERT INTO manage_groups VALUES (1, 'Test');
CREATE TABLE manage_services ( id MEDIUMINT(8) NOT NULL, name TEXT, oid TEXT, statut TEXT );
CREATE TABLE manage_process ( id MEDIUMINT(8) NOT NULL, name TEXT, tag TEXT, statut TEXT );
ALTER TABLE `manage_alerts` ADD `oid` TEXT;
INSERT INTO settings VALUES ('manage_use_patch', '0');
INSERT INTO settings VALUES ('manage_send', '');
INSERT INTO settings VALUES ('manage_netsend_events', '5');
INSERT INTO settings VALUES ('manage_netsend_method', '1');
INSERT INTO settings VALUES ('manage_list', '0');
INSERT INTO settings VALUES ('manage_list_separator', '25');
INSERT INTO settings VALUES ('manage_full_separator', '6');
INSERT INTO settings VALUES ('manage_simple_separator', '12');
INSERT INTO settings VALUES ('manage_legend', 'on');
INSERT INTO settings VALUES ('manage_poller_hosts', '5');
CREATE TABLE manage_poller_output (local_data_id mediumint(8), output text)
CREATE TABLE manage_sites ( id MEDIUMINT(8) NOT NULL auto_increment, name TEXT, PRIMARY KEY (id) )
ALTER TABLE manage_host_services RENAME manage_tcp
ALTER TABLE manage_groups ADD site_id MEDIUMINT NOT NULL
ALTER TABLE manage_host ADD `thresold` MEDIUMINT(8) unsigned NOT NULL default '0'
ALTER TABLE manage_host ADD `thresold_ref` MEDIUMINT(8) unsigned NOT NULL default '1'
INSERT INTO settings VALUES ('manage_cycle_delay', '30')
INSERT INTO settings VALUES ('manage_cycle_refresh', '5')
INSERT INTO settings VALUES ('manage_poller_plus', '0')
INSERT INTO settings VALUES ('manage_thold', '1')
INSERT INTO settings VALUES ('manage_order1', '1')
INSERT INTO settings VALUES ('manage_order2', '2')
INSERT INTO settings VALUES ('manage_order3', '3')
INSERT INTO settings VALUES ('manage_order4', '0')
INSERT INTO settings VALUES ('manage_order5', '0')
INSERT INTO settings VALUES ('manage_list_2', '2')
INSERT INTO settings VALUES ('manage_theme', 'default')
INSERT INTO settings VALUES ('manage_sound', '0')
This should resolve the issues you have been experiencing.
BTW: Have you managed to get the Windows Services working in MANAGE ?
Regds
I had a similar issue. It seems to have something to do with the tables not getting created properly. To get around this, do the following
DROP all manage_* tables using:
ALTER TABLE `host` DROP `manage`;
DROP TABLE `manage_host`;
DROP TABLE `manage_method`;
DROP TABLE `manage_alerts`;
DROP TABLE `manage_tcp`;
DROP TABLE `manage_device_type`;
DROP TABLE `manage_templates`;
DROP TABLE `manage_groups`;
DROP TABLE `manage_services`;
DROP TABLE `manage_process`;
DROP TABLE `manage_poller_output`;
DROP TABLE `manage_sites`;
DELETE FROM `plugin_update_info` WHERE `plugin` = 'manage';
DELETE FROM `settings` WHERE `name` = 'manage_poller';
DELETE FROM `settings` WHERE `name` = 'manage_events';
DELETE FROM `settings` WHERE `name` = 'manage_method';
DELETE FROM `settings` WHERE `name` = 'manage_date';
DELETE FROM `settings` WHERE `name` = 'manage_use_patch';
DELETE FROM `settings` WHERE `name` = 'manage_send';
DELETE FROM `settings` WHERE `name` = 'manage_netsend_events';
DELETE FROM `settings` WHERE `name` = 'manage_netsend_method';
DELETE FROM `settings` WHERE `name` = 'manage_list';
DELETE FROM `settings` WHERE `name` = 'manage_list_2';
DELETE FROM `settings` WHERE `name` = 'manage_list_separator';
DELETE FROM `settings` WHERE `name` = 'manage_full_separator';
DELETE FROM `settings` WHERE `name` = 'manage_simple_separator';
DELETE FROM `settings` WHERE `name` = 'manage_legend';
DELETE FROM `settings` WHERE `name` = 'manage_poller_hosts';
DELETE FROM `settings` WHERE `name` = 'manage_cycle_delay';
DELETE FROM `settings` WHERE `name` = 'manage_cycle_refresh';
DELETE FROM `settings` WHERE `name` = 'manage_poller_plus';
DELETE FROM `settings` WHERE `name` = 'manage_perl';
DELETE FROM `settings` WHERE `name` = 'manage_order1';
DELETE FROM `settings` WHERE `name` = 'manage_order2';
DELETE FROM `settings` WHERE `name` = 'manage_order3';
DELETE FROM `settings` WHERE `name` = 'manage_order4';
DELETE FROM `settings` WHERE `name` = 'manage_order5';
DELETE FROM `settings` WHERE `name` = 'manage_theme';
DELETE FROM `settings` WHERE `name` = 'manage_sound';
Re-create all the tables by using
alter table host add manage char(3) default '' not null after disabled;
CREATE TABLE manage_host ( id mediumint(8) unsigned NOT NULL default '0', uptime bigint(20) default NULL, type mediumint(8) unsigned NOT NULL default '0', services text, statut text);
CREATE TABLE manage_method ( id mediumint(8) unsigned NOT NULL default '0', method text);
CREATE TABLE manage_alerts (idh mediumint(8) unsigned NOT NULL default '0', datetime datetime NOT NULL default '0000-00-00 00:00:00', ids mediumint(8) unsigned default '0', message text, note text, ida mediumint(9) unsigned NOT NULL auto_increment, PRIMARY KEY (ida));
CREATE TABLE manage_host_services ( id mediumint(8) unsigned NOT NULL default '0', services mediumint(8) unsigned NOT NULL default '0', statut text);
INSERT INTO settings VALUES ('manage_events', '5');
INSERT INTO settings VALUES ('manage_poller', '0');
INSERT INTO settings VALUES ('manage_method', '0');
INSERT INTO settings VALUES ('manage_date', '0');
ALTER TABLE manage_host ADD `force` MEDIUMINT(8) unsigned NOT NULL default '9';
CREATE TABLE manage_device_type ( id MEDIUMINT(8) NOT NULL AUTO_INCREMENT , name TEXT, image TEXT, PRIMARY KEY ( id ) );
INSERT INTO manage_device_type VALUES (1, 'Windows 2003 Host', 'win2003.png');
INSERT INTO manage_device_type VALUES (2, 'Windows XP Host', NULL);
INSERT INTO manage_device_type VALUES (3, 'Windows 2000 Host', 'win2000.png');
INSERT INTO manage_device_type VALUES (4, 'Windows NT4 Host', 'winnt.png');
INSERT INTO manage_device_type VALUES (5, 'Windows 9x Host', NULL);
INSERT INTO manage_device_type VALUES (6, 'Linux Host', 'linux.png');
INSERT INTO manage_device_type VALUES (7, 'Router', 'router.png');
INSERT INTO manage_device_type VALUES (8, 'Switch', 'switch.png');
INSERT INTO manage_device_type VALUES (9, 'Other', 'other.png');
CREATE TABLE manage_templates ( id MEDIUMINT(8) NOT NULL auto_increment, name TEXT, tcp_ports TEXT, PRIMARY KEY (id) );
INSERT INTO manage_templates VALUES (1, 'Mail Server (Basic)', '110;25');
INSERT INTO manage_templates VALUES (2, 'Mail Server (Enhanced)', '110;995;25;143;993;80;443');
INSERT INTO manage_templates VALUES (3, 'Switch/Router', '23');
INSERT INTO manage_templates VALUES (4, 'Web Server', '80;443');
INSERT INTO manage_templates VALUES (5, 'Windows 200x Domain Controler', '389');
INSERT INTO manage_templates VALUES (6, 'DNS Server', '53');
alter table manage_host add `group` MEDIUMINT(8) default '0';
CREATE TABLE manage_groups ( id MEDIUMINT(8) NOT NULL auto_increment, name TEXT, PRIMARY KEY (id) );
INSERT INTO manage_groups VALUES (1, 'Test');
CREATE TABLE manage_services ( id MEDIUMINT(8) NOT NULL, name TEXT, oid TEXT, statut TEXT );
CREATE TABLE manage_process ( id MEDIUMINT(8) NOT NULL, name TEXT, tag TEXT, statut TEXT );
ALTER TABLE `manage_alerts` ADD `oid` TEXT;
INSERT INTO settings VALUES ('manage_use_patch', '0');
INSERT INTO settings VALUES ('manage_send', '');
INSERT INTO settings VALUES ('manage_netsend_events', '5');
INSERT INTO settings VALUES ('manage_netsend_method', '1');
INSERT INTO settings VALUES ('manage_list', '0');
INSERT INTO settings VALUES ('manage_list_separator', '25');
INSERT INTO settings VALUES ('manage_full_separator', '6');
INSERT INTO settings VALUES ('manage_simple_separator', '12');
INSERT INTO settings VALUES ('manage_legend', 'on');
INSERT INTO settings VALUES ('manage_poller_hosts', '5');
CREATE TABLE manage_poller_output (local_data_id mediumint(8), output text)
CREATE TABLE manage_sites ( id MEDIUMINT(8) NOT NULL auto_increment, name TEXT, PRIMARY KEY (id) )
ALTER TABLE manage_host_services RENAME manage_tcp
ALTER TABLE manage_groups ADD site_id MEDIUMINT NOT NULL
ALTER TABLE manage_host ADD `thresold` MEDIUMINT(8) unsigned NOT NULL default '0'
ALTER TABLE manage_host ADD `thresold_ref` MEDIUMINT(8) unsigned NOT NULL default '1'
INSERT INTO settings VALUES ('manage_cycle_delay', '30')
INSERT INTO settings VALUES ('manage_cycle_refresh', '5')
INSERT INTO settings VALUES ('manage_poller_plus', '0')
INSERT INTO settings VALUES ('manage_thold', '1')
INSERT INTO settings VALUES ('manage_order1', '1')
INSERT INTO settings VALUES ('manage_order2', '2')
INSERT INTO settings VALUES ('manage_order3', '3')
INSERT INTO settings VALUES ('manage_order4', '0')
INSERT INTO settings VALUES ('manage_order5', '0')
INSERT INTO settings VALUES ('manage_list_2', '2')
INSERT INTO settings VALUES ('manage_theme', 'default')
INSERT INTO settings VALUES ('manage_sound', '0')
This should resolve the issues you have been experiencing.
BTW: Have you managed to get the Windows Services working in MANAGE ?
Regds
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b
-
mcutting
- Cacti Guru User
- Posts: 1884
- Joined: Mon Oct 16, 2006 5:57 am
- Location: United Kingdom
- Contact:
UPDATE: I now have MANAGE v 0.5 working....
I am able to see services up when they should be. To fix this, I chose the WMI (perl) based poller, which works well. However, as I'm currently monitoring servers based in other domains, the WMI script doesn't really fit the bill.
I noticed that there is an option for the data result to be taken from the poller using RRDTOOL. It seems that you need a modified poller:
QUOTE from readme
"You can choose between SNMP, WMI (Vbs or Perl) and that i name "rrdtool" (it's the output from the poller)."
In the MANAGE settings tab
Manage performance
To use 'Use rrdtool' choice, you will need the modified poller.
My question is, what is the modified poller ? In the .bat file, I can see a file called php-manage.exe, although this doesn't seem to exist anywhere.
If I use the RRDTOOL option, all the services show as up (GREAT), but if I take one down, and do another poll, it stays as up, when in fact it's down.
Am I missing something ?
Apart from that, if I down a running service with the WMI poller, this works fine, and shows the service as down. If I restart the service, run another poll (WMI), the service shows as up again.
I am able to see services up when they should be. To fix this, I chose the WMI (perl) based poller, which works well. However, as I'm currently monitoring servers based in other domains, the WMI script doesn't really fit the bill.
I noticed that there is an option for the data result to be taken from the poller using RRDTOOL. It seems that you need a modified poller:
QUOTE from readme
"You can choose between SNMP, WMI (Vbs or Perl) and that i name "rrdtool" (it's the output from the poller)."
In the MANAGE settings tab
Manage performance
To use 'Use rrdtool' choice, you will need the modified poller.
My question is, what is the modified poller ? In the .bat file, I can see a file called php-manage.exe, although this doesn't seem to exist anywhere.
If I use the RRDTOOL option, all the services show as up (GREAT), but if I take one down, and do another poll, it stays as up, when in fact it's down.
Am I missing something ?
Apart from that, if I down a running service with the WMI poller, this works fine, and shows the service as down. If I restart the service, run another poll (WMI), the service shows as up again.
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b
-
apperrault
- Cacti User
- Posts: 379
- Joined: Fri Feb 16, 2007 11:37 am
- Location: Emeryville, CA
- Contact:
hey mcutting,
Thanks for the help, but I think there is a problem with the SQL code. I am able to get the delete statements to work, and all of the tables drop the way they should, but when i run your create statements, i get the following error:
and the manage_sites table is not created. It appears that all of the other ones are created just fine. Do you have any thoughts on what is going on? Do i have a problem with my MySQL installation? I am having some other major problems with my Cacti (slow, not graphing, but still collecting the data and putting it in the DB) so i may have to start from scratch and then try and migrate the RRD data to the new installation. I would love to get this working before i do the switch though.
Thanks in advance for the help.
app
Thanks for the help, but I think there is a problem with the SQL code. I am able to get the delete statements to work, and all of the tables drop the way they should, but when i run your create statements, i get the following error:
Code: Select all
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'CREAT
E TABLE manage_sites ( id MEDIUMINT(8) NOT NULL auto_increment, name TEXT, ' at
line 2Thanks in advance for the help.
app
[b]Cacti Version[/b] - 0.8.7b
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]
-
apperrault
- Cacti User
- Posts: 379
- Joined: Fri Feb 16, 2007 11:37 am
- Location: Emeryville, CA
- Contact:
We are getting there. Now i am getting:
Thanks for all the help by the way. I really am not a MySQL admin, so this helps a lot.
app
Code: Select all
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'ALTER
TABLE manage_groups ADD site_id MEDIUMINT NOT NULL
ALTER TABLE manage_host' at line 2app
[b]Cacti Version[/b] - 0.8.7b
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]
-
mcutting
- Cacti Guru User
- Posts: 1884
- Joined: Mon Oct 16, 2006 5:57 am
- Location: United Kingdom
- Contact:
Hmm. Can you drop any manage tables again, and recreate them with the text a couple of posts back. Make sure that each line is appended with an ; as I think this is what is causing the problem.
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b
-
apperrault
- Cacti User
- Posts: 379
- Joined: Fri Feb 16, 2007 11:37 am
- Location: Emeryville, CA
- Contact:
I will try that in the morning. I had to take my son to the Dr this afternoon.
Thanks for all the help. I will let you know how it goes.
app
Thanks for all the help. I will let you know how it goes.
app
[b]Cacti Version[/b] - 0.8.7b
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]
-
apperrault
- Cacti User
- Posts: 379
- Joined: Fri Feb 16, 2007 11:37 am
- Location: Emeryville, CA
- Contact:
Now that is more like it. But now, when i go to add a group, after adding a site, i get a validation error. I have read the other posts about this, and someone mentioned removing the validation section, but there are multiple areas where there is, what looks to me, Validation.
What should i do now?
app
What should i do now?
app
[b]Cacti Version[/b] - 0.8.7b
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]
-
mcutting
- Cacti Guru User
- Posts: 1884
- Joined: Mon Oct 16, 2006 5:57 am
- Location: United Kingdom
- Contact:
Hi App,
Well done for getting this far (welcome to my world!)
Replace your manage_groups.php file with the one enclosed in this post (my modified version, thanks to Gilles) - let me know how you get on.
Regds
Well done for getting this far (welcome to my world!)
Replace your manage_groups.php file with the one enclosed in this post (my modified version, thanks to Gilles) - let me know how you get on.
Regds
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b
-
apperrault
- Cacti User
- Posts: 379
- Joined: Fri Feb 16, 2007 11:37 am
- Location: Emeryville, CA
- Contact:
That was it. Thanks so much for the help. Time to go start adding hosts to manage, and creating custom manage templates.
Thanks for all the help.
app
Thanks for all the help.
app
[b]Cacti Version[/b] - 0.8.7b
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]
-
mcutting
- Cacti Guru User
- Posts: 1884
- Joined: Mon Oct 16, 2006 5:57 am
- Location: United Kingdom
- Contact:
Glad it worked.
A couple of tips:
The SNMP poller seems to be a bit on the flaky side when monitoring services. The WMI poller works very well, but can only monitor machines that are on the same domain. I've also noticed issues when monitoring servers running Windows 2000 using the WMI poller.
Have fun
A couple of tips:
The SNMP poller seems to be a bit on the flaky side when monitoring services. The WMI poller works very well, but can only monitor machines that are on the same domain. I've also noticed issues when monitoring servers running Windows 2000 using the WMI poller.
Have fun
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b
Manage 0.42 has not worked for me since updating to the newest cacti and plugin architecture. I did have manage working and really enjoyed and relied on getting host up and down notifications as well as reviewing uptime at a glance. It has been a week or two since I lost the ability to use manage and I would it back! This plugin is a life saver!
I see the future is v0.5, so I pulled in the SVN version 0.5 from:
http://svn.cactiusers.net/plugins/manage
Is this the latest?
On UNIX, the first thing I noticed and adjusted was in:
manage/setup.php
There are a few references that UNIX cannot understand,
namely the backslashes in path names.
I changed a few items that were complaining from \themes to /themes etc.
A few other files referenced files via \ so I changed to / as I saw errors reported in the browser.
I also did a dos2unix on files that had a ^M at the end of each line.
I can add hosts to sites and dvices to groups.
I can run the SQL table checker on the Misc. settings and I see all my tables are version 0.5 OK.
When I click on the manage tab I get an ugly error:
Fatal error: Call to undefined function bcmod() in /usr/opt/apache/htdocs/cacti/plugins/manage/manage_ajax.php on line 619
bcmod function is broken for me
I can run the poller from the command line:
/usr/local/bin/php /opt/apache/htdocs/cacti/plugins/manage/check-manage.php
03/24/2007 02:46:50 PM - MANAGE: Poller[0] Checking Manage
nb pollers : 1
137 138 4 5 6 7 102 97 98 130 129 100 101 103 104 105 106 107 108 109 110 111 112 126 127 128 2 113 114 115 116 117 118 119 120 121 123 124 125 133 134 135 136 140 141 142 143 144 145 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 206 213 214 215 216 217 218 219 220 221 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298
count : 191
N : 191
reste : 0
exec 1 -> 191 137 138 4 5 6 7 102 97 98 130 129 100 101 103 104 105 106 107 108 109 110 111 112 126 127 128 2 113 114 115 116 117 118 119 120 121 123 124 125 133 134 135 136 140 141 142 143 144 145 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 206 213 214 215 216 217 218 219 220 221 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298
However, just like version 0.42, none of my uptimes are being updated.
I see the future is v0.5, so I pulled in the SVN version 0.5 from:
http://svn.cactiusers.net/plugins/manage
Is this the latest?
On UNIX, the first thing I noticed and adjusted was in:
manage/setup.php
There are a few references that UNIX cannot understand,
namely the backslashes in path names.
I changed a few items that were complaining from \themes to /themes etc.
A few other files referenced files via \ so I changed to / as I saw errors reported in the browser.
I also did a dos2unix on files that had a ^M at the end of each line.
I can add hosts to sites and dvices to groups.
I can run the SQL table checker on the Misc. settings and I see all my tables are version 0.5 OK.
When I click on the manage tab I get an ugly error:
Fatal error: Call to undefined function bcmod() in /usr/opt/apache/htdocs/cacti/plugins/manage/manage_ajax.php on line 619
bcmod function is broken for me
I can run the poller from the command line:
/usr/local/bin/php /opt/apache/htdocs/cacti/plugins/manage/check-manage.php
03/24/2007 02:46:50 PM - MANAGE: Poller[0] Checking Manage
nb pollers : 1
137 138 4 5 6 7 102 97 98 130 129 100 101 103 104 105 106 107 108 109 110 111 112 126 127 128 2 113 114 115 116 117 118 119 120 121 123 124 125 133 134 135 136 140 141 142 143 144 145 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 206 213 214 215 216 217 218 219 220 221 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298
count : 191
N : 191
reste : 0
exec 1 -> 191 137 138 4 5 6 7 102 97 98 130 129 100 101 103 104 105 106 107 108 109 110 111 112 126 127 128 2 113 114 115 116 117 118 119 120 121 123 124 125 133 134 135 136 140 141 142 143 144 145 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 206 213 214 215 216 217 218 219 220 221 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298
However, just like version 0.42, none of my uptimes are being updated.
Thank you,
Ernie
http://www.NMSWorld.com
[b]Dual Zeon Dual Core 2.6Ghz / 8GB RAM / 4x15k RPM SATA RAID5[/b]
[b]Cacti Version[/b] - 0.8.7b
[b]Poller Type[/b] - cactid 0.8.7 with Boost v1.7
[b]Server Info[/b] - FreeBSD 7.0-RELEASE
[b]Web Server[/b] - Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8g DAV/2 PHP/5.2.5 mod_perl/2.0.3 Perl/v5.8.8
[b]PHP[/b] - 5.2.6
[b]MySQL[/b] - 5.0.51b Mod: poller_output ENGINE = MEMORY
[b]RRDTool[/b] - 1.3.0
[b]SNMP[/b] - 5.4.1
[b]Plugins[/b] - Host Info (hostinfo - v0.2), Update Checker (update - v0.3), Network Tools (tools - v0.2), FlowView (flowview - v0.3), Read-only Devices Tab (devices - v0.4), Network Discovery (discovery - v0.8.3), Syslog Monitoring (syslog - v0.5.2), Thresholds (thold - v0.3.9), Device Monitoring (monitor - v0.8.2), PHP Network Weathermap (weathermap - v0.941), SuperLinks (superlinks - v0.72), Report Creator (reports - v0.1b)
Ernie
http://www.NMSWorld.com
[b]Dual Zeon Dual Core 2.6Ghz / 8GB RAM / 4x15k RPM SATA RAID5[/b]
[b]Cacti Version[/b] - 0.8.7b
[b]Poller Type[/b] - cactid 0.8.7 with Boost v1.7
[b]Server Info[/b] - FreeBSD 7.0-RELEASE
[b]Web Server[/b] - Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8g DAV/2 PHP/5.2.5 mod_perl/2.0.3 Perl/v5.8.8
[b]PHP[/b] - 5.2.6
[b]MySQL[/b] - 5.0.51b Mod: poller_output ENGINE = MEMORY
[b]RRDTool[/b] - 1.3.0
[b]SNMP[/b] - 5.4.1
[b]Plugins[/b] - Host Info (hostinfo - v0.2), Update Checker (update - v0.3), Network Tools (tools - v0.2), FlowView (flowview - v0.3), Read-only Devices Tab (devices - v0.4), Network Discovery (discovery - v0.8.3), Syslog Monitoring (syslog - v0.5.2), Thresholds (thold - v0.3.9), Device Monitoring (monitor - v0.8.2), PHP Network Weathermap (weathermap - v0.941), SuperLinks (superlinks - v0.72), Report Creator (reports - v0.1b)
-
mcutting
- Cacti Guru User
- Posts: 1884
- Joined: Mon Oct 16, 2006 5:57 am
- Location: United Kingdom
- Contact:
I'm not a linux guy, but had the same error as you in terms of ajax. Did you create any sites yet? I found that creating sites cleared this error. Also, on each manage host, did you force an snmp check, or is it set to none?
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b
Who is online
Users browsing this forum: No registered users and 2 guests