Aggregate, Color Templates & Mysql

[toast]

Hi
Using cacti-0.8.6j, plugin architecture 1.1 and aggregate-v0[1].63
The aggregate plugin works just fine with the exception of Color Templates which I can't make.

Get a mysql error in the log files.
11/15/2007 08:36:38 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
11/15/2007 08:36:36 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT plugin_color_templates.color_template_id, plugin_color_templates.name FROM plugin_color_templates WHERE (plugin_color_templates.name LIKE '%%%%') ORDER BY name ASC LIMIT 0,30"
11/15/2007 08:36:36 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT plugin_color_templates.color_template_id, plugin_color_templates.name FROM plugin_color_templates WHERE (plugin_color_templates.name LIKE '%%%%') ORDER BY name ASC LIMIT 0,30"
11/15/2007 08:36:36 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT COUNT(plugin_color_templates.color_template_id) FROM plugin_color_templates WHERE (plugin_color_templates.name LIKE '%%%%')"
11/15/2007 08:36:36 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT COUNT(plugin_color_templates.color_template_id) FROM plugin_color_templates WHERE (plugin_color_templates.name LIKE '%%%%')"

Not a major drama as I can easily change the colour in Graph Management anyway. But it would be nice if it worked.

Any ideas?.

[TheWitness]

Run this from inside of MySQL and tell me what it responds with:

Code: Select all

SELECT plugin_color_templates.color_template_id, plugin_color_templates.name FROM plugin_color_templates WHERE (plugin_color_templates.name LIKE '%%%%') ORDER BY name ASC LIMIT 0,30

TheWitness

[toast]

Yip. The table doesn't exist.
ERROR 1146: Table 'cacti.plugin_color_templates' doesn't exist

I thought that with this version of aggregate there was no need to import the sql.

[TheWitness]

Hmm, the detection logic may need some work. Try again. Import the SQL.

TheWitness

[toast]

It appears to be some sort of mysql error, possibly unique to me.
I got the aggregate.sql but that would't import. Then I tried adding the sql via command line. No go. I checked it against the sql in setup.php version 0.63 and it's the same. Since others aren't getting it I assume its in my setup.
Still not sure why - but investigating.

ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right synt
ax to use near 'DEFAULT CHARSET=latin1 COMMENT='Names of Aggregate Templates' A

[toast]

Solved.
The offender is DEFAULT CHARSET=latin1
Firstly I tried changing latin1 to utf8.
That never worked either.
Remove the two DEFAULT CHARSET=latin1 and hey presto - it works without any apparent problems so far.

We use aggregate for consolidating graphs (obviously) with lots of data sources, so far up to forty then adding up the sum of the different data source types and plotting each sum as a line. Will document it and post it up if anyone wants.

[TheWitness]

Fixed in SVN. I am sure it will be in the next release.

TheWitness

[toast]

Here is a how to for what we use Aggregate for. Its all possible without Aggregate but it's too much of a drag.

Hope somone benefits from it.