Cycle Graphs Plugin

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
emericklaw
Posts: 21
Joined: Thu Jan 19, 2006 1:17 pm

Post by emericklaw »

I am going to get updating this plugin soon. I have not had much time to work on the plugin for the past few months. Just hope I can still remember what all the code means :roll:
emericklaw
Posts: 21
Joined: Thu Jan 19, 2006 1:17 pm

Post by emericklaw »

I have just updated this plugin to version 0.3 there are a few changes to the way it works and added custom graph support.

At the moment the custom graphs have to be setup in the Misc tab in the Settings page by entering the graph ID.

For example the URL to one of my graphs is http://example.com/graph.php?local_graph_id=73&rra_id=all

I would add the number 73 to the list.

The custom graph rotation will be changed in the future but I am either going to wait until cigamit adds a hook to the graph edit page or just create a new setup page where you can specify the graphs and the order. Your input on this would be appreciated.

If there are any problems or you have any more ideas to add to the TODO list then let me know!
jherrinike
Posts: 24
Joined: Wed May 10, 2006 2:46 pm
Location: Memphis, TN USA

Post by jherrinike »

I like the changes but there are three things that I can not figure out.

1. On the cycle screen it puts a line besides the graph instead of under it.

2. Even though I can see the cycle tab when logged in as admin when I go to user management I do not have a option to put this for the other users.

3. after running for a bit I get this:
undefined
| < Prev | Stop Start | Next > |
Next Update In 0 Seconds
Unknown column 'undefined' in 'where clause'



Any ideas?

Thanks
emericklaw
Posts: 21
Joined: Thu Jan 19, 2006 1:17 pm

Post by emericklaw »

jherrinike wrote:1. On the cycle screen it puts a line besides the graph instead of under it.
Fixed in the currect version for download on the first post (didn't bother to update version number as it was just some test code I forgot to remove).
jherrinike wrote:2. Even though I can see the cycle tab when logged in as admin when I go to user management I do not have a option to put this for the other users.
Don't you have the 'View Cycle Graphs' tick box? I think I will look into making another realm for editing the graphs and viewing them.
jherrinike wrote:3. after running for a bit I get this:
undefined
| < Prev | Stop Start | Next > |
Next Update In 0 Seconds
Unknown column 'undefined' in 'where clause'
I have noticed this now on my setup. It happens when it gets to the end of the list and tries to locate the first graph. I will look into this tomorrow.
jherrinike
Posts: 24
Joined: Wed May 10, 2006 2:46 pm
Location: Memphis, TN USA

Post by jherrinike »

Okay the new version fixed my first problem.

Yes, under my user management I do not have a selection box to view cycle tab for any user. The admin users has the cycle tab but no others.

Thanks
crackrocksteady
Posts: 45
Joined: Wed Dec 06, 2006 12:02 am
Location: Perth , Australia

Post by crackrocksteady »

3. after running for a bit I get this:
undefined
| < Prev | Stop Start | Next > |
Next Update In 0 Seconds
Unknown column 'undefined' in 'where clause'


I am also getting this after my first graph. I have several graphs in my cacti install yet it only shows one and then cycles to Undefined.

Any Ideas???
apperrault
Cacti User
Posts: 379
Joined: Fri Feb 16, 2007 11:37 am
Location: Emeryville, CA
Contact:

Post by apperrault »

Have there been any updates to this plugin recently? I am having some problems with it. When i go to the Cycle tab, i see the first graph, and then i get the

Code: Select all

undefined
| < Prev | Stop Start | Next > |
Next Update In 21 Seconds

Unknown column 'Label' in 'where clause'
error. Am i missing something?

I hope that this get's working. My boss just said we could mount our old flat panel in our NOC if we can get this working!!!

thanks

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]
jacauc
Posts: 34
Joined: Sun Sep 10, 2006 1:05 am

Post by jacauc »

apperrault wrote:Have there been any updates to this plugin recently? I am having some problems with it. When i go to the Cycle tab, i see the first graph, and then i get the

Code: Select all

undefined
| < Prev | Stop Start | Next > |
Next Update In 21 Seconds

Unknown column 'Label' in 'where clause'
error. Am i missing something?

I hope that this get's working. My boss just said we could mount our old flat panel in our NOC if we can get this working!!!

thanks

app
Also interested in this! :D:D Just what I was looking for!
emericklaw
Posts: 21
Joined: Thu Jan 19, 2006 1:17 pm

Post by emericklaw »

Just to update any users of this plugin that there should be an update out tomorrow (once I hear back from cigamit about a few things) that fixes the error messages that appeared and stopped the graphs from working.

The new version has a working custom graph list and has been running fine for the last few days with no errors.

Watch this space...
jnovicki@wfu.edu
Posts: 1
Joined: Tue Aug 28, 2007 3:20 pm

Still watching space

Post by jnovicki@wfu.edu »

Would love to know if anyone has found a solution to the problem:

Code: Select all

undefined
| < Prev | Stop Start | Next > |
Next Update In 21 Seconds

Unknown column 'Label' in 'where clause'
cmarticus
Posts: 18
Joined: Mon Apr 02, 2007 3:21 pm

Post by cmarticus »

Has anyone gotten cycle to work on 8.7? I get in an error in line 106 of setup when trying to install. Worked fine under 8.6
michelem
Posts: 34
Joined: Thu Mar 30, 2006 7:34 am

Post by michelem »

open the file:

/plugins/cycle/ajax.php

and add the line in bold:

chdir('../../');
include_once("./include/config.php");
include_once("./include/global.php");
lyudell
Posts: 9
Joined: Fri Sep 28, 2007 8:15 am

Post by lyudell »

I've added the reference to global.php, but I'm still getting the "unknown column 'undefined' in 'where clause'...

(Like most things with CACTI and plugins, I'm sure it is something I missed.)



:oops:
User avatar
chrisgapske
Cacti User
Posts: 278
Joined: Tue May 22, 2007 7:56 am
Location: Pensacola, Fl - Padacuh, Ky-Alpena, MI-Gulf Shores,AL

me too

Post by chrisgapske »

I still get this issue I get the first five or so graphs than same message.
lyudell wrote:I've added the reference to global.php, but I'm still getting the "unknown column 'undefined' in 'where clause'...

(Like most things with CACTI and plugins, I'm sure it is something I missed.)



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

Post by TheWitness »

I played with Cycle 0.3 tonight and made it compatible with Cacti 0.8.7 and fixed a few bugs as well. I have labeled it 0.4, but I will leave the final versioning to the Author. For now you have it.

TheWitness
Attachments
cycle-0.4.zip
(14.03 KiB) Downloaded 744 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?
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests