Cycle Graphs Plugin

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
eschoeller
Cacti User
Posts: 234
Joined: Mon Dec 13, 2004 3:03 pm

Post by eschoeller »

Could someone please give me brief instructions on how to obtain the SVN copy of this plugin? 0.4 does not work with 0.8.7b from what I can see.
incudie
Posts: 21
Joined: Thu Mar 06, 2008 12:03 pm

Post by incudie »

Using Cycle 0.4 and it works just fine except, I am receiving two notices:


Notice: Undefined index: index.php: in /usr/share/cacti/lib/functions.php on line 1644

Notice: Undefined index: index.php: in /usr/share/cacti/lib/functions.php on line 1663
-> Cycling

Cacti: 0.8.7b with PA 2.0

Any thoughts?
super-hornet
Cacti User
Posts: 175
Joined: Sun May 27, 2007 5:42 pm

Post by super-hornet »

To all

I encounter this:
;parent.startTime();parent.refreshTime();parent.getnext();">

as well. I'm using openSUSE 10.3

After digging, I found out that the Cycle pluging (0.4) uses mixture of "Short Open Tag" and "Standard Open Tag" for the php script. (Standard open tag is "<?php" Short open Tag is "<?")

In openSUSE, the default PHP configuration ONLY accept Standard open tag (or long open) tag.

To solve this, modify your php.ini setting and look for:
short_open_tag = Off

Change it to:
short_open_tag = On

After that, restart your apache daemon.

In openSUSE, the php.ini is in:
/etc/php5/cli
AND
/etc/php5/apache2

SH
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

SH, file and line please :)

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Never mind. v0.50 attached.

TheWitness
Attachments
cycle-0.50.tar.gz
(13.21 KiB) Downloaded 658 times
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
super-hornet
Cacti User
Posts: 175
Joined: Sun May 27, 2007 5:42 pm

Post by super-hornet »

Hi TheWitness

Correct me if I'm wrong, for PHP, the beginning of php script start with:
<?php or <?
and it end with:
?>

If the php.ini setting was set to:
short_open_tag = Off

Then the apache/php will reject/ignore <? as the beginning of php script. It only accept <?php for each beginning of php script.

This is what the comment stated inside php.ini for openSUSE 10.3
; - short_open_tag = Off [Portability]
; Using short tags is discouraged when developing code meant for redistribution


If u look at the cycle plugin on "cycle.php", u will notice there is a mixture of <? and <?php

Thus, to fix this problem, we either change the cycle.php or relax the php configuration.


EDIT: Ah... I notice for 0.50 version, u have updated the "<?php"
Thanks!

SH
minmei
Posts: 16
Joined: Thu Sep 28, 2006 1:02 pm

Change Graph Duration

Post by minmei »

Loved the plugin! But we wanted to see last 4 hours, or last day. So I added a change to have a new setting variable for the graph duration in seconds.

Enjoy at your leisure. Full disclaimers apply. The changes were based on 0.5.0. Replace the appropriate files in the cycle directory. Then change the duration in the cycle section of the settings menu from the console tab.

Chad
Attachments
duration.tar.gz
ajax.php and setup.php
(2.68 KiB) Downloaded 440 times
joshbaity
Posts: 4
Joined: Wed Nov 14, 2007 11:55 am

cycle graphs working

Post by joshbaity »

Thanks SH for the tip and Witness for the updated plugin. Seems to be working just fine now.

Thanks again!
juge
Posts: 4
Joined: Tue Aug 12, 2008 3:07 am

Post by juge »

Hello, I wish to show 4 graphs at a time,
as anyone tried to do so before ? (if not, I will try to set something up for this WE)

This add on is really useful for datacenters.
drexon
Posts: 2
Joined: Fri Sep 26, 2008 11:35 am

Tree View Mode Added

Post by drexon »

All,

I had the need to show multiple graphs at one time and to have them cycle through "groups" of graphs for display on our monitors. To that extent I've modified the cycle plugin to support cacti tree - leaf cycling.

Basically, under settings you set the Cycle Mode to "Tree Mode" then specific the tree you want cycle to walk. It will pull all leaf or header sections from that tree and walk them one at a time (between cycle events). The name of the header is displayed at the top and all of the graphs out of that leaf/header are displayed on the screen at once. Also supported are displaying the graphs in a column layout where up to 5 columns of graphs can be displayed at once.

I also fixed a number of little bugs here and there. Hopefully I didn't create any ;)

I hope that makes sense and please let me know if you have any problems using it or questions. I'm marking this version 0.6.

Thanks,
Drex


** Update **
Updated on 10/5/08 to fix a bug when switching between Tree and List mode.
Attachments
cycle-0.6.tar.gz
Cycle v0.6 with Tree Walking Support
(14.55 KiB) Downloaded 468 times
Last edited by drexon on Sun Oct 05, 2008 10:53 am, edited 1 time in total.
kjohnsoncda
Posts: 4
Joined: Wed Oct 01, 2008 11:30 am

Post by kjohnsoncda »

Drexon,

Installed .6 Cycle on Cacti 8.7b

getting this when clicking on the cycle tab:
With cycle set to a custom list that was working in .4.

Code: Select all

Notice: Undefined index: title in C:\cacti\plugins\cycle\ajax.php on line 89

Switching to Tree mode:
All I get is a large Number at top, and the controls prev, stop next. No graph though.
drexon
Posts: 2
Joined: Fri Sep 26, 2008 11:35 am

Fixed

Post by drexon »

kjohnsoncda wrote:Drexon,

Installed .6 Cycle on Cacti 8.7b

getting this when clicking on the cycle tab:
With cycle set to a custom list that was working in .4.

Code: Select all

Notice: Undefined index: title in C:\cacti\plugins\cycle\ajax.php on line 89

Switching to Tree mode:
All I get is a large Number at top, and the controls prev, stop next. No graph though.
Thanks for the heads up on this one. I found the problem and got it corrected. The 0.6 download now has the fixed code. Let me know if you have any other problems.
apperrault
Cacti User
Posts: 379
Joined: Fri Feb 16, 2007 11:37 am
Location: Emeryville, CA
Contact:

Post by apperrault »

Morning all,
I just downloaded the Cycle plugin from the SVN and i am having a problem. It is the same problem i am having with the version posted here a few threads back. I can install the plugin just fine. I add the user permissions, and setup the tree that i want it to cycle. Then, when i go to the cycle tab, i get the headers at the top of the page, but the graphics are missing, and then when i go to the Cacti log i get the following errors in the log:

Code: Select all

10/06/2008 08:55:10 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:10 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:10 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:10 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:09 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:09 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:09 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:09 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:09 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:09 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:09 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:09 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:09 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:09 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:08 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:08 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:08 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:08 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:08 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:08 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:07 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:07 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:07 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:07 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:07 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:07 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:07 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:07 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:07 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:07 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:05 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:05 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id= group by graph_templates_graph.local_graph_id"
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:05 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:05 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:05 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:05 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:05 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:05 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:05 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:05 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:05 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:05 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:05 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:05 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:05 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:04 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:04 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:04 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:04 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:04 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:04 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:04 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:04 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:03 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:03 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:03 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:03 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:03 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:03 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:03 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:03 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:03 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:03 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:02 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:02 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:02 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:02 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:02 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:02 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:01 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
10/06/2008 08:55:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
10/06/2008 08:55:01 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id=" 
I would love to have this plugin working, but for now i need to leave it disabled.

app
[b]Cacti Version[/b] - 0.8.7b
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]
mcutting
Cacti Guru User
Posts: 1884
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:

Post by mcutting »

Same issue here - it looks like various table entries are missing ?
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b
apperrault
Cacti User
Posts: 379
Joined: Fri Feb 16, 2007 11:37 am
Location: Emeryville, CA
Contact:

Post by apperrault »

The interesting thing is, i don't see a .sql file so i assumed that there were no changes being made to SQL with it. Hopefully this will get updated soon.

app
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest