0.8.8f Plugin Management problem

[MissAkiiki]

Hi, I just set up Cacti 0.8.8f and I am having trouble viewing plugins. Plugin Management is not displayed under Configuration. I know I've got a permissions issue but I'm not sure where to look

My /usr/share/cacti/site/plugins$

Code: Select all

drwxr-xr-x 13 root    root  4096 Sep 18 09:17 ..
drwxr-xr-x  2 root    root  4096 Sep 18 09:23 aggregate
drwxr-xr-x  3 root    root  4096 Sep 18 09:23 discovery
drwxr-xr-x  2     544   513 4096 Jul 21  2010 dsstats
drwxr-xr-x  5 root    root  4096 Sep 18 09:23 mactrack
drwxr-xr-x  4 root    root  4096 Sep 18 09:23 monitor
drwxrwxr-x  6 root    root  4096 Aug 28  2011 nectar
drwxr-xr-x  3 root    root  4096 Jul 30  2010 ntop
drwxr-xr-x  2 root    root  4096 Sep 18 09:19 realtime
drwxr-xr-x  5 root    root  4096 Dec  3  2011 syslog
drwxr-xr-x  5 root    root  4096 Dec  4  2011 ugroup
drwxr-xr-x  9 root    root  4096 Sep 18 09:19 weathermap

When I click the Weathermaps tab


include/config.php

Code: Select all

* make sure these values refect your actual database/host/user/password */
$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "cacti";
$database_password = "xxxxxxx";
$database_port = "3306";
$database_ssl = false;

/*
   Edit this to point to the default URL of your Cacti install
   ex: if your cacti install as at http://serverip/cacti/ this
   would be set to /cacti/
*/
$url_path = "/cacti/";

/* Default session name - Session name must contain alpha characters */
//$cacti_session_name = "Cacti";

$plugins = array();
$plugins[] = 'aggregate';
$plugins[] = 'monitor';
$plugins[] = 'weathermap';
$plugins[] = 'mactrack';
$plugins[] = 'realtime';
$plugins[] = 'syslog';
$plugins[] = 'ugroup';
$plugins[] = 'ntop';
$plugins[] = 'dsstats';
$plugins[] = 'discovery';
?>

From the Cacti log file

Code: Select all

09/18/2015 11:20:31 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'nav_login_after' AND ph.name IN ('snmpagent', 'settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'nav_login_after' AND ph.name NOT IN ('snmpagent', 'settings', 'boost', 'dsstats') ORDER BY id ASC"

Please help

[MissAkiiki]

Anyone? Anything? Something?

[jantram]

I'm seeing the same issue, it looks like the setup is attempting to detect plugins, but the select/join is failing. I'm looking into it further.

[jantram]

I think I have it solved.... missing tables in the database.

Code: Select all

CREATE TABLE `plugin_config` (
  `id` int(8) NOT NULL auto_increment,
  `directory` varchar(32) NOT NULL default '',
  `name` varchar(64) NOT NULL default '',
  `status` tinyint(2) NOT NULL default '0',
  `author` varchar(64) NOT NULL default '',
  `webpage` varchar(255) NOT NULL default '',
  `version` varchar(8) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `status` (`status`),
  KEY `directory` (`directory`)
) ENGINE=MyISAM;

CREATE TABLE `plugin_hooks` (
  `id` int(8) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `hook` varchar(64) NOT NULL default '',
  `file` varchar(255) NOT NULL default '',
  `function` varchar(128) NOT NULL default '',
  `status` int(8) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `hook` (`hook`),
  KEY `status` (`status`)
) ENGINE=MyISAM;

[MissAkiiki]

Oh My Word I'm just seeing this. Been fighting with it since and I just got it resolved today I feel like such a dweeb. Came back here to post and saw your response. Thank you. It's been a long September.

[anmomin1]

I am running 0.8.8h version of cacti and having issue with ntop plugins.

I tried above database tables creations and got message already exist. any other troubleshooting?