Problem with Aggregate Plugin mysql table

[jkukis]

I'm receiving this error in the logs for the aggregate plugin.I am using version .63. It looks like the table is not getting created, not sure why.

Code: Select all

10/15/2007 11:28:24 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select color_template_id, name from plugin_color_templates order by name"
10/15/2007 11:28:24 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO `plugin_color_templates_item` (`color_template_item_id`, `color_template_id`, `color_id`, `sequence`) VALUES (1, 1, 4, 1), (2, 1, 24, 2), (3, 1, 98, 3), (4, 1, 25, 4), (5, 2, 25, 1), (6, 2, 29, 2), (7, 2, 30, 3), (8, 2, 31, 4), (9, 2, 33, 5), (10, 2, 35, 6), (11, 2, 41, 7), (12, 2, 9, 8), (13, 3, 15, 1), (14, 3, 31, 2), (15, 3, 28, 3), (16, 3, 8, 4), (17, 3, 34, 5), (18, 3, 33, 6), (19, 3, 35, 7), (20, 3, 41, 8), (21, 3, 36, 9), (22, 3, 42, 10), (23, 3, 44, 11), (24, 3, 48, 12), (25, 3, 9, 13), (26, 3, 49, 14), (27, 3, 51, 15), (28, 3, 52, 16), (29, 4, 76, 1), (30, 4, 84, 2), (31, 4, 89, 3), (32, 4, 17, 4), (33, 4, 86, 5), (34, 4, 88, 6), (35, 4, 90, 7), (36, 4, 94, 8), (37, 4, 96, 9), (38, 4, 93, 10), (39, 4, 91, 11), (40, 4, 22, 12), (41, 4, 12, 13), (42, 4, 95, 14), (43, 4, 6, 15), (44, 4, 92, 16);"
10/15/2007 11:28:24 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "CREATE TABLE `plugin_color_templates_item` ( `color_template_item_id` int(12) unsigned NOT NULL auto_increment, `color_template_id` mediumint(8) unsigned NOT NULL default '0', `color_id` mediumint(8) unsigned NOT NULL default '0', `sequence` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`color_template_item_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0 COMMENT='Stores the actual aggregate item data.' AUTO_INCREMENT=48;"
10/15/2007 11:28:24 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO `plugin_color_templates` (`color_template_id`, `name`) VALUES (1, 'Yellow: light -> dark, 4 colors'), (2, 'Red: light yellow > dark red, 8 colors'), (3, 'Red: light -> dark, 16 colors'), (4, 'Green: dark -> light, 16 colors');"
10/15/2007 11:28:24 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "CREATE TABLE `plugin_color_templates` ( `color_template_id` mediumint(8) unsigned NOT NULL auto_increment COMMENT 'Index', `name` varchar(255) NOT NULL COMMENT 'Name of Template', PRIMARY KEY (`color_template_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Names of Aggregate Templates' AUTO_INCREMENT=5;"
10/15/2007 11:28:24 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT @@session.sql_mode;"
10/15/2007 11:28:24 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT @@global.sql_mode;"

Any ideas?

[gandalf]

Is mysql strict mode enabled?
Reinhard

[jkukis]

I was able to get past the sql errors by manually creating the DB through the MySql gui. Now I get these RRD errors, when in graph debug mode:

Code: Select all

RRDTool Command:

/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="VLAH Aggregate" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
CDEF:cdefa=a,8,* \
LINE1:cdefa#004359:"cat6500.cc.stevens-tech.edu Inbound"  \
GPRINT:cdefa:LAST:"Current\:%8.2lf %s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n"  \
LINE1:cdefa#EACC00:"cat6500.cc.stevens-tech.edu Outbound"  \
GPRINT:cdefa:LAST:"Current\:%8.2lf %s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s"  \
LINE1:cdefa#005D57:"cat6500.cc.stevens-tech.edu Inbound"  \
GPRINT:cdefa:LAST:"Current\:%8.2lf %s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n"  \
LINE1:cdefa#FFAB00:"cat6500.cc.stevens-tech.edu Outbound"  \
GPRINT:cdefa:LAST:"Current\:%8.2lf %s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s"  \
LINE1:cdefa#00694A:"cat6500.cc.stevens-tech.edu Inbound"  \
GPRINT:cdefa:LAST:"Current\:%8.2lf %s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n"  \
LINE1:cdefa#EAAF00:"cat6500.cc.stevens-tech.edu Outbound"  \
GPRINT:cdefa:LAST:"Current\:%8.2lf %s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s" 

RRDTool Says:

ERROR: invalid rpn expression in: a,8,*

I haven't done anything special that I know of, just selected a few graphs, clicked create aggregate, and thats what I have.

Ideas?

[gandalf]

There's not a single data item in there (DEF statement in rrdtool lingo). So sth went wrong when creating this graph
Reinhard