CMD Poller SQL Assoc Failed!, many

[morgentau]

Hello, so i setup my new cacti installation... working and graphing.... but im left with an error message.

They appear to be generated several times per second...

05/27/2011 07:42:23 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 = 'draw_navigation_text' AND ph.name IN ('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 = 'draw_navigation_text' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

What does it mean?

[noname]

Probably you have applied plugin patch, but not imported 'pa.sql'..

[morgentau]

Well yes, i applied the patches yesterday... but i also got some "hunk" errors which i do not understand... so i do not know the status of some of the patches.

Is it possible to correct this manually?

[noname]

If you already applied plugin patch and got 'Hunk' errors,
then overwrite that files with pre-patched file.
See http://docs.cacti.net/manual:087:1_installation.9_pia

FYI:
If you want to use PIA 2.9 on Cacti0.8.7g, please apply official patches for Cacti before installing PIA.
Then, plugin patch will be successfully applied.

[morgentau]

Well, i applied patches but only those here... the offical patches for cacti http://www.cacti.net/download_patches.php i did not install any plugins yet.

I've not added anything else to cacti except for some hosts to graph...

[noname]

>> Well, i applied patches but only those here... the offical patches for cacti http://www.cacti.net/download_patches.php
>> i did not install any plugins yet.

What file (or patch) you got 'Hunk' error?

[morgentau]

I reapplied the patches and got no errors from "patch" as far as i could see....

Cacti seems to work ok... otherwise. So what causes the red error log?

[noname]

The error query in your first post is only included in plugin patch (and pre-patched file), not included in original Cacti package.
So I thought you have failed to install it (=Plugin Architecture)...

Code: Select all

% cat cacti-plugin-0.8.7g-PA-v2.8.diff
...
--- cacti-0.8.7g-old/include/plugins.php        1969-12-31 19:00:00.000000000 -0500
+++ cacti-0.8.7g/include/plugins.php    2010-07-09 18:34:11.000000000 -0400
@@ -0,0 +1,38 @@
+<?php
+
+/*
+ * Copyright (c) 1999-2005 The SquirrelMail Project Team (http://squirrelmail.org)
+ * Licensed under the GNU GPL. For full terms see the file COPYING.
+ */
+
+global $plugin_hooks, $plugins_system;
+$plugin_hooks = array();
+$plugins_system = array('settings', 'boost', 'dsstats');
+
...

[morgentau]

But why do i get this error? Everything is new, it is a clean installation... or then, perhaps not?

It is suprising how fast the log fills... about 10 times per second this same entry....