Manage Plugin 0.6.2 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.

Cacti Version - 0.8.7b
Plugin Architecture - 2.1
Poller Type - Cactid v
Server Info - Windows NT 5.1
Web Server - Microsoft-IIS/5.1
PHP - 5.2.5
PHP Extensions - bcmath, calendar, com_dotnet, ctype, session, filter, ftp, hash, iconv, json, odbc, pcre, Reflection, date, libxml, standard, tokenizer, zlib, SimpleXML, dom, SPL, wddx, xml, xmlreader, xmlwriter, ISAPI, msql, mssql, mysql, snmp, sockets
MySQL - 5.0.51a-community-nt
RRDTool - 1.2.15
SNMP - At line 1 in (none)
Cannot find module (NET-SNMP-AGENT-MIB): At line 1 in (none)
Cannot find module (DISMAN-EVENT-MIB): At line 1 in (none)
No hostname specified.
USAGE: snmpwalk [OPTIONS] AGENT [OID]

Version: 5.4.1
Web: http://www.net-snmp.org/
Email: net-snmp-coders@lists.sourceforge.net

OPTIONS:
-h, --help display this help message
-H display configuration file directives understood
-v 1|2c|3 specifies SNMP version to use
-V, --version display package version number
SNMP Version 1 or 2c specific
-c COMMUNITY set the community string
SNMP Version 3 specific
-a PROTOCOL set authentication protocol (MD5|SHA)
-A PASSPHRASE set authentication protocol pass phrase
-e ENGINE-ID set security engine ID (e.g. 800000020109840301)
-E ENGINE-ID set context engine ID (e.g. 800000020109840301)
-l LEVEL set security level (noAuthNoPriv|authNoPriv|authPriv)
-n CONTEXT set context name (e.g. bridge1)
-u USER-NAME set security name (e.g. bert)
-x PROTOCOL set privacy protocol (DES)
-X PASSPHRASE set privacy protocol pass phrase
-Z BOOTS,TIME set destination engine boots/time
General communication options
-r RETRIES set the number of retries
-t TIMEOUT set the request timeout (in seconds)
Debugging
-d dump input/output packets in hexadecimal
-D TOKEN[,...] turn on debugging output for the specified TOKENs
(ALL gives extremely verbose debugging output)
General options
-m MIB[:...] load given list of MIBs (ALL loads everything)
-M DIR[:...] look in given list of directories for MIBs
-P MIBOPTS Toggle various defaults controlling MIB parsing:
u: allow the use of underlines in MIB symbols
c: disallow the use of "--" to terminate comments
d: save the DESCRIPTIONs of the MIB objects
e: disable errors when MIB symbols conflict
w: enable warnings when MIB symbols conflict
W: enable detailed warnings when MIB symbols conflict
R: replace MIB symbols from latest module
-O OUTOPTS Toggle various defaults controlling output display:
0: print leading 0 for single-digit hex characters
a: print all strings in ascii format
b: do not break OID indexes down
e: print enums numerically
E: escape quotes in string indices
f: print full OIDs on output
n: print OIDs numerically
q: quick print for easier parsing
Q: quick print with equal-signs
s: print only last symbolic element of OID
S: print MIB module-id plus last element
t: print timeticks unparsed as numeric integers
T: print human-readable text along with hex strings
u: print OIDs using UCD-style prefix suppression
U: don't print units
v: print values only (not OID = value)
x: print all strings in hex format
X: extended index format
-I INOPTS Toggle various defaults controlling input parsing:
b: do best/regex matching to find a MIB node
h: don't apply DISPLAY-HINTs
r: do not check values for range/type legality
R: do random access to OID labels
u: top-level OIDs must have '.' prefix (UCD-style)
s SUFFIX: Append all textual OIDs with SUFFIX before parsing
S PREFIX: Prepend all textual OIDs with PREFIX before parsing
-L LOGOPTS Toggle various defaults controlling logging:
e: log to standard error
o: log to standard output
n: don't log at all
f file: log to the specified file
s facility: log to syslog (via the specified facility)

(variants)
[EON] pri: log to standard error, output or /dev/null for level 'pri' and above
[EON] p1-p2: log to standard error, output or /dev/null for levels 'p1' to 'p2'
[FS] pri token: log to file/syslog for level 'pri' and above
[FS] p1-p2 token: log to file/syslog for levels 'p1' to 'p2'
-C APPOPTS Set various application specific behaviours:
p: print the number of variables found
i: include given OID in the search range
I: don't include the given OID, even if no results are returned
c: do not check returned OIDs are increasing
t: Display wall-clock time to complete the request
Plugins

• PHP Network Managing (PHP Network Managing - v0.6)
  Host Info (hostinfo - v0.2)

[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? :

Code: Select all

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

If the above query does not give errors, you could drop al the manage tables in the database, and re-insert them using the manage SQL files.

[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:

Cacti Version - 0.8.7b
Plugin Architecture - 2.1
Poller Type - Cactid v
Server Info - Linux 2.6.16.21-0.8-smp
Web Server - Apache/2.2.0 (Linux/SUSE)
PHP - 5.1.2
PHP Extensions - libxml, xml, standard, SimpleXML, SPL, session, Reflection, date, pcre, apache2handler, gd, ldap, mysql, mysqli, snmp, sockets
MySQL - 5.0.18
RRDTool - 1.2.12
SNMP - 5.3.0.1
Plugins

• Thresholds (thold - v0.3.9)
  Network Discovery (discovery - v0.8.3)
  Network Tools (tools - v0.2)
  Device Monitoring (monitor - v0.8.2)
  PHP Network Weathermap (weathermap - v0.95b)
  Update Checker (update - v0.4)
  Host Info (hostinfo - v0.2)
  PHP Network Managing (PHP Network Managing - v0.6)
  RRD File Cleaner (RRD Cleaner - v0.31)
  ReportIt (ReportIt - v0.5.1)
  Global Plugin Settings (settings - v0.4)

[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 ?