Manage Plugin 0.6.2 for monitoring networks, servers...

[gilles]

msw1970, in your cacti.log, you must have a sql failed on insert
try to run this insert in phpmyadmin and tell me the error message

[YoMarK]

Hi Gilles, first: thanks for your help and great work!
To answer you question: no tab of manage settings there(note: I don't have a /cacti/, my cacti is installed in the wwwroot of the server, thus: http://myserver.domain.local/settings.php is my settings.php file, could this be part of the problem? Other plugins are working fine).

My admin user has user id=1(but i have no manage settings tab to check).

Some more information, when i enable manage in plugin management i'm getting the following errors on top of my cacti page:

Code: Select all

Warning: in_array() [function.in-array]: Wrong datatype for second argument in C:\wamp\www\lib\plugins.php on line 46

Warning: in_array() [function.in-array]: Wrong datatype for second argument in C:\wamp\www\lib\plugins.php on line 46

Warning: in_array() [function.in-array]: Wrong datatype for second argument in C:\wamp\www\lib\plugins.php on line 46

Warning: in_array() [function.in-array]: Wrong datatype for second argument in C:\wamp\www\lib\plugins.php on line 46

Warning: in_array() [function.in-array]: Wrong datatype for second argument in C:\wamp\www\lib\plugins.php on line 46

Warning: in_array() [function.in-array]: Wrong datatype for second argument in C:\wamp\www\lib\plugins.php on line 46

Warning: in_array() [function.in-array]: Wrong datatype for second argument in C:\wamp\www\lib\plugins.php on line 46

There errors go away when i enable manage( by adding $plugins[] = 'manage'; ) in global.php(this should not be neccesairy, right ? ).

Disableling all other plugins but manage also does not make any difference.

Edit:
Also I have a lot of these errors in my cacti logfile:

Code: Select all

03/28/2008 06:41:21 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select thold_data.cdef, thold_data.rra_id, thold_data.data_id, thold_data.lastread, thold_data.oldvalue, data_template_rrd.data_source_name as name, data_template_rrd.data_source_type_id from thold_data LEFT JOIN data_template_rrd on (data_template_rrd.id = thold_data.data_id) WHERE data_template_rrd.data_source_name != '' AND "

[gilles]

have a CLEAN cacti/plugins directory
don't leave somethings like "old_manage", "xxxmanage"
it seems plugins are auto-discovered and you have a conflict with functions

[msw1970]

msw1970, in your cacti.log, you must have a sql failed on insert
try to run this insert in phpmyadmin and tell me the error message

Gilles

I've worked backwards through all of the SQL files contained within the manage directory and manually removed tables and the various records from the settings table and then re-ran the files in order from 1 thru 6. This generated no error messages at all. However the following tables are still reporting no index defined in phpMyAdmin

manage_host
manage_poller_output
manage_process
manage_services
manage_tcp

[msw1970]

Ok, I've just removed manage completely and installed from the 0.5.2 version through plugin management.

I've still got tables with no index defined and I'm now receiving the following error in cacti.log that I wasn't getting before...

03/31/2008 03:03:17 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select thold_data.cdef, thold_data.rra_id, thold_data.data_id, thold_data.lastread, thold_data.oldvalue, data_template_rrd.data_source_name as name, data_template_rrd.data_source_type_id from thold_data LEFT JOIN data_template_rrd on (data_template_rrd.id = thold_data.data_id) WHERE data_template_rrd.data_source_name != '' AND "

[YoMarK]

My problem that manage was only partially showing was solved by dropping the Plugin Architecture(plugin_) tables and recreating them by using the SQL file.

[lingping]

I why could not see here"Plugin Management"

My system environment is as follows:

Cacti Version 0.8.7b
Plugin Architecture 2.0
Poller Type Cactid v
Server Info Linux 2.6.18-8.el5
Web Server Apache/2.2.3 (CentOS)
PHP Version 5.1.6
PHP Extensions libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, standard, SimpleXML, sockets, SPL, shmop, session, Reflection, pspell, posix, mime_magic, iconv, hash, gmp, gettext, ftp, exif, date, curl, ctype, calendar, bz2, zlib, pcre, openssl, apache2handler, ldap, mysql, mysqli, odbc, PDO, pdo_mysql, PDO_ODBC, pdo_sqlite, snmp
MySQL Version 5.0.22
RRDTool Version 1.0.50
SNMP Version 5.4.1
Plugins Global Plugin Settings (settings - v0.3)
Thresholds (thold - v0.3.9)
Device Monitoring (monitor - v0.8.2)
Host Info (hostinfo - v0.2)
Syslog Monitoring (syslog - v0.5.2)
FlowView (flowview - v0.4)
Network Discovery (discovery - v0.8.3)
Documents (docs - v0.1)
Network Tools (tools - v0.2)
Update Checker (update - v0.4)

[eternal]

My problem that manage was only partially showing was solved by dropping the Plugin Architecture(plugin_) tables and recreating them by using the SQL file.

Did you remove all plugin_ or just the ones created in the sql file?

[YoMarK]

Just the ones in the SQL file(sorry for the incorrect statement).
The plugin_discover and plugin_thold tables are still there.

[eternal]

no go here. I have removed both. reinstalled both.

Cacti Version - 0.8.7b
Plugin Architecture - 2.1
Poller Type - CMD.php
Server Info - Linux 2.6.9-55.0.12.plus.c4
Web Server - Apache/2.0.59 (CentOS)
PHP - 5.1.6
PHP Extensions - libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, standard, SimpleXML, sockets, SPL, shmop, session, Reflection, pspell, posix, mime_magic, iconv, hash, gmp, gettext, ftp, exif, date, curl, ctype, calendar, bz2, zlib, pcre, openssl, apache2handler, bcmath, gd, mbstring, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, snmp, eAccelerator
MySQL - 5.0.58
RRDTool - 1.2.15
SNMP - 5.1.2
Plugins

• Global Plugin Settings (settings - v0.3)
  PHP Network Weathermap (weathermap - v0.95b)
  Thresholds (thold - v0.3.9)
  Device Monitoring (monitor - v0.8.2)
  Network Discovery (discovery - v0.8.3)
  Network Tools (tools - v0.2)
  Syslog Monitoring (haloe - v0.4)
  RRD Cleaner (rrdclean - v1.1)
  Update Checker (update - v0.4)
  FlowView (flowview - v0.4)
  Host Info (hostinfo - v0.2)
  Error Images (errorimage - v0.1)
  Report Creator (reports - v0.3)
  PHP Network Managing (PHP Network Managing - v0.5.2)
  Configuration manager (configmanager - v0.5f)
  ReportIt (ReportIt - v0.5.1)
  Create Aggregate Graphs (aggregate - v0.63)
  Cycle Graphs (Cycle Graphs - v0.3)
  Real-time statistics (zond - v0.3)
  Documents (docs - v0.1)
  Dataquery (dataquery - v0.1.2a)
  SuperLinks (superlinks - v0.72)
  IP subnet Calculator IPv4 IPv6 (ipsubnet - v.4c)
  Syslog Monitoring (syslog - v0.5.2)
  Network Management Inventory Database (nmid - v0.3.7g)
  NMID SmokePing Plugin (nmid_smokeping - v0.1)
  NMID NFTracker Plugin (nmid_nftracker - v0.1)
  NMID WebService Plugin (nmid_webservice - v0.1)
  NMID CiscoWorks Plugin (nmid_ciscoworks - v0.1)
  NMID phpIP Plugin (nmidPhpip - v0.3.8k)
  NMID TaskManager Plugin (nmidTaskManager - v0.3.8a)
  plugins

[phantom_rgs]

Hi! I have a fresh install of cacti 0.8.7b, with PA 2.1 and spine 0.8.7a.
I downloaded and installed settings and thold, added there in global.php, if i not added there not show in cacti, but the manage plugin is the question. Whe downloaded manage 0.5.2 in zip format extract to a folder manage in plugins folder, under plugin management the manage plugin are listed in uninstalled, when i click in install show image in attachment the cacti crashs, to work i have to drop the manage and pa tables and re run pa.sql to cacti work again. after that tha manage plugin show again in uninstalled session of plugin management. i think the problem is in pa or manage, but i can't find the problem in code, any help?

[eternal]

Make sure you have no extra *.php files in the root of plugins. one setup.php file that unziped astray caused me problems

[Piranha]

Hey guys, I got this running on my Cacti EZ .4 Setup...

I had some trouble as well, and after reading through this thread, dropping the plugin_ tables from the SQL database and reimporting the plugin arch. file solved my issue.

However, when I imported my old version of my cacti-backup data to get all my stuff running (on the fresh install) I had to do the above again.

Working fine so far, and I'm setting everything up, but Manage looks very promising.

Cacti Version - 0.8.7b
Plugin Architecture - 2.0
Poller Type - Cactid v
Server Info - Linux 2.6.9-67.0.4.plus.c4
Web Server - Apache/2.0.59 (CentOS)
PHP - 5.1.6
PHP Extensions - libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, standard, SimpleXML, sockets, SPL, shmop, session, Reflection, pspell, posix, mime_magic, iconv, hash, gmp, gettext, ftp, exif, date, curl, ctype, calendar, bz2, zlib, pcre, openssl, apache2handler, gd, ldap, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, snmp, eAccelerator
MySQL - 5.0.58
RRDTool - 1.2.23
SNMP - 5.1.2
Plugins

• Global Plugin Settings (settings - v0.3)
  Thresholds (thold - v0.3.9)
  Large Site Performane Booster for Cacti (boost - v1.5)
  Device Monitoring (monitor - v0.8.2)
  Network Tools (tools - v0.2)
  Syslog Monitoring (syslog - v0.5.2)
  RRD Cleaner (rrdclean - v1.1)
  Update Checker (update - v0.4)
  FlowView (flowview - v0.4)
  Host Info (hostinfo - v0.2)
  Error Images (errorimage - v0.1)
  Create Aggregate Graphs (aggregate - v0.63)
  Documents (docs - v0.1)
  report it! (report it! - v0.5.0)
  PHP Network Managing (PHP Network Managing - v0.5.2)

[fabian]

I just installed CactiEZ v4 and everything works ok but Manage.

I find strange problems with SQL tables.

Anyone with the same troubles?

Thanks in advance.
Fabian.

[gilles]

phantom_rgs, these errors happens when tables are not created properly.
(btw, your error message simply CAN'T happens...)
use the provided sql scripts (run uninstall.sql first) and try reinstall the plugin.
it could be usefull for me to have the errors in your cacti.log when you have run the installer previously.

deleting PA tables and recreate them seems too experimental for me.

all errors are logged in cacti.log.
answers are in this file.