Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
mcutting wrote:Gilles - I have found that using a "," instead of ";" to seperate email addresses works - please diregard my previous post, although you may want to change the wording in settings.Regds
logical since "," is the separator in thold settings
but ";" should work too, and it does for me...
Last edited by gilles on Mon Apr 23, 2007 11:31 am, edited 1 time in total.
I tried the modified poller, but the results are no different:
id : 41 , statut was : prob , method : 0 , result : 140620779
Host : hostname.domain.co.uk (hostname), old uptime is : 140617670, new is : 140620779
+ mail or netsend demande : mcutting@domain.co.uk
+ OK up
+ service gfi languard s.e.l.m. 5.0 alerter agent service , was down -> no change
+ service gfi languard s.e.l.m. 5.0 archiver agent service , was down -> no change
+ service gfi languard s.e.l.m. 5.0 collector agent service , was down -> no change
+ service print spooler , was down -> no change
2007-4-25, at 6:30:58
Putting the poller back to WMI (PERL) or WMI (VBS) makes it work again
Cacti Version 0.8.8b Cacti OS Ubuntu LTS RRDTool Version RRDTool 1.4.7 Poller Information Type SPINE 0.8.8b
select data_input_data.value, data_local.snmp_index from data_input_data, data_template_data, data_local, data_template where data_input_data.data_input_field_id=(SELECT distinct(data_input_fields.id) FROM data_input, data_input_fields where data_input.type_id = 6 and data_input_fields.data_input_id=data_input.id and data_input_fields.name='Index Value') and data_input_data.data_template_data_id=data_template_data.id and data_template_data.local_data_id=data_local.id and data_template_data.data_template_id=data_template.id and data_template.name='Win Services' and data_local.host_id='37'
replace data_local.host_id='37' with your id host
output will be like this :
Audio Windows
1.13.65.117.100.105.111.32.87.105.110.100.111.119.115
Tried the above. All the results seem to check out. However, I am concerned by your statement "beware : the oid must start at the 2nd position (for me, i don't use 1.13.65...)"
Is it a possibility that this is the reason as to why the services are showing as down when using the snmp poller ?
I am recieving these errors after I have installed Manage 5.1... When I click on the Manage Tab, I get:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\cacti\plugins\Manage\manage_ajax.php on line 349
Notice: Undefined offset: 4 in C:\Inetpub\wwwroot\cacti\plugins\Manage\manage_ajax.php on line 1428
Last poll date :
Legend
Up Waiting Alert Tresholded Down
Host
TCP Port NA NA
Windows Service NA NA
Windows Process NA NA
Powered by PHP Network Managing version 0.5.1 Settings
Notice: Undefined offset: 1 in C:\Inetpub\wwwroot\cacti\plugins\Manage\manage_ajax.php on line 1469
Notice: Undefined offset: 1 in C:\Inetpub\wwwroot\cacti\plugins\Manage\manage_ajax.php on line 1469
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\cacti\plugins\Manage\manage_ajax.php on line 1578
Notice: Undefined offset: 1 in C:\Inetpub\wwwroot\cacti\plugins\Manage\manage_ajax.php on line 1595
Notice: Undefined offset: 0 in C:\Inetpub\wwwroot\cacti\plugins\Manage\manage_ajax.php on line 1598
Notice: Undefined offset: 0 in C:\Inetpub\wwwroot\cacti\plugins\Manage\manage_ajax.php on line 1603
Looks like you are either some tables missing, or you have not yet defined any sites.
Go to the Manage tab, click settings, then click the Debug link shown at the top of the page. this should tell you what tables are there, and what is missing. If all the tables say ok, try adding a site to see if that resolves your issue.
Judging by the poller date and time being missing, I'd say you have an incomplete table setup.
Cacti Version 0.8.8b Cacti OS Ubuntu LTS RRDTool Version RRDTool 1.4.7 Poller Information Type SPINE 0.8.8b
This is the debug info for Manage Plugin. I verified I am missing those tables, but there is no .sql file to import those tables, and I'm not sure how to do it. And I have no idea what those CHAMP things are that are missing?? Thanks!
And oh yeah, I tried to define some sites, but it doesn't seem to save them.
Attachments
ManageTables.JPG (163.95 KiB) Viewed 7196 times
Last edited by Dacob9906 on Thu Apr 26, 2007 11:07 am, edited 1 time in total.
Jacob Bergman
Pullman School District
jbergman@psd267.wednet.edu
After 5 snmp polls - no change - the services are still shown as down...
id : 41 , statut was : prob , method : 0 , result : 153053101
Host : hostname.domain.co.uk (hostname), old uptime is : 153048919, new is : 153053101
+ mail or netsend demande : mcutting@domain.co.uk
+ OK up
+ service gfi languard s.e.l.m. 5.0 alerter agent service , was down
executing : -c:/wamp/php/php.exe -q c:/wamp/www/cacti/scripts/win_services.php hostname.domain.co.uk <snmp_community> 2 41 get servstate 47.71.70.73.32.76.65.78.103.117.97.114.100.32.83.46.69.46.76.46.77.46.32.53.46.48.32.65.108.101.114.116.101.114.32.97.103.101.110.116.32.115.101.114.118.105.99.101-
result is : -0-
-> no change
+ service gfi languard s.e.l.m. 5.0 archiver agent service , was down
executing : -c:/wamp/php/php.exe -q c:/wamp/www/cacti/scripts/win_services.php hostname.domain.co.uk <snmp_community> 2 41 get servstate 48.71.70.73.32.76.65.78.103.117.97.114.100.32.83.46.69.46.76.46.77.46.32.53.46.48.32.65.114.99.104.105.118.101.114.32.97.103.101.110.116.32.115.101.114.118.105.99.101-
result is : -0-
-> no change
+ service gfi languard s.e.l.m. 5.0 collector agent service , was down
executing : -c:/wamp/php/php.exe -q c:/wamp/www/cacti/scripts/win_services.php hostname.domain.co.uk <snmp_community> 2 41 get servstate 49.71.70.73.32.76.65.78.103.117.97.114.100.32.83.46.69.46.76.46.77.46.32.53.46.48.32.67.111.108.108.101.99.116.111.114.32.97.103.101.110.116.32.115.101.114.118.105.99.101-
result is : -0-
-> no change
+ service print spooler , was down
executing : -c:/wamp/php/php.exe -q c:/wamp/www/cacti/scripts/win_services.php hostname.domain.co.uk <snmp_community> 2 41 get servstate 13.80.114.105.110.116.32.83.112.111.111.108.101.114-
result is : -0-
-> no change
2007-4-26, at 17:3:9
Cacti Version 0.8.8b Cacti OS Ubuntu LTS RRDTool Version RRDTool 1.4.7 Poller Information Type SPINE 0.8.8b
1. Drop all MANAGE_ tables from the CACTI database, using the below from phpMyAdmin (execute as SQL - watch out for forum line wrapping)
ALTER TABLE `host` DROP `manage`;
ALTER TABLE `host` DROP `manage_group`;
DROP TABLE `manage_host`;
DROP TABLE `manage_method`;
DROP TABLE `manage_alerts`;
DROP TABLE `manage_host_services`;
DROP TABLE `manage_device_type`;
DROP TABLE `manage_templates`;
DROP TABLE `manage_groups`;
DROP TABLE `manage_services`;
DROP TABLE `manage_process`;
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_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';
2. Insert the following code into the database, again, using SQL
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');
Give the MANAGE plugin another try. Hopefully, this may help.
Cacti Version 0.8.8b Cacti OS Ubuntu LTS RRDTool Version RRDTool 1.4.7 Poller Information Type SPINE 0.8.8b
