Cactiquery 0.8.6g

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

User avatar
pestilence
Cacti User
Posts: 207
Joined: Fri Jul 25, 2003 10:37 am
Location: Athens/Greece
Contact:

Cactiquery 0.8.6g

Post by pestilence »

Cactiquery is a raw value query tool for cacti, it will query the rra files using the rrdtool and return the output (in human readable format) inside the browser, after querying you are provided with the option to dump the results in a csv formated file which can be manipulated by a spreadsheet program.
Enjoy.
Attachments
cactiquery-0.8.6g-1.tar.gz
New version
(42.56 KiB) Downloaded 1357 times
Last edited by pestilence on Tue Sep 27, 2005 4:53 am, edited 1 time in total.
/* * Oops. The kernel tried to access some bad page. We'll have to * terminate things with extreme prejudice. */ die_if_kernel("Oops", regs, error_code);
ioiioi
Cacti User
Posts: 52
Joined: Mon Mar 28, 2005 8:57 am

Post by ioiioi »

very nice plugin.
it is useful when I want to export a report including digital value, not only graph.
I wish it will be a part of offical cacti release. :D
by the way, could you give us a sample screen?
User avatar
pestilence
Cacti User
Posts: 207
Joined: Fri Jul 25, 2003 10:37 am
Location: Athens/Greece
Contact:

Post by pestilence »

I will include a screenshot tomorrow :) because currently i am really bussy :)
/* * Oops. The kernel tried to access some bad page. We'll have to * terminate things with extreme prejudice. */ die_if_kernel("Oops", regs, error_code);
User avatar
pestilence
Cacti User
Posts: 207
Joined: Fri Jul 25, 2003 10:37 am
Location: Athens/Greece
Contact:

Post by pestilence »

Ok i think i might have found the problem (the pointer to the file was opened inside the loop) try the new uploaded version and give me some feedback.
Regards.
/* * Oops. The kernel tried to access some bad page. We'll have to * terminate things with extreme prejudice. */ die_if_kernel("Oops", regs, error_code);
User avatar
pestilence
Cacti User
Posts: 207
Joined: Fri Jul 25, 2003 10:37 am
Location: Athens/Greece
Contact:

Post by pestilence »

roddie wrote:Works great.. Thank you for the quick fix!
Thanks for reporting this :)
/* * Oops. The kernel tried to access some bad page. We'll have to * terminate things with extreme prejudice. */ die_if_kernel("Oops", regs, error_code);
ioiioi
Cacti User
Posts: 52
Joined: Mon Mar 28, 2005 8:57 am

Post by ioiioi »

pestilence,
I have installed the cigamate's "plugin architecture addon", some original files had been replaced. when I am going to install "cactiquery0.8.6g", I found that the cigamate's files will be overwrited by yours, so do you have any good suggestion to install your plugins in the condition that it won't intefere with the "plugin architecture addon"?
User avatar
pestilence
Cacti User
Posts: 207
Joined: Fri Jul 25, 2003 10:37 am
Location: Athens/Greece
Contact:

Post by pestilence »

ioiioi wrote:pestilence,
I have installed the cigamate's "plugin architecture addon", some original files had been replaced. when I am going to install "cactiquery0.8.6g", I found that the cigamate's files will be overwrited by yours, so do you have any good suggestion to install your plugins in the condition that it won't intefere with the "plugin architecture addon"?
All changed code in the files is commented so that you can find out the differences from the original source code.
Just open the file and copy paste the according changes is my suggestion.
This is unofrtunately the only way to do this untill a plugin architecture is integraded inside cacti.
/* * Oops. The kernel tried to access some bad page. We'll have to * terminate things with extreme prejudice. */ die_if_kernel("Oops", regs, error_code);
knobdy
Cacti User
Posts: 495
Joined: Wed Sep 28, 2005 1:39 pm

Post by knobdy »

So now we have plugin architecture working, is this a go, has it been updated?
sg
Posts: 30
Joined: Tue Jun 01, 2004 12:55 pm

Post by sg »

I really like cactiquery; it's funcationality I need from Cacti.

Some issues/suggestions/requests:

1) I can't download the data -- the filename is always "/path/to/csvdir/-.csv" and the file is always empty
2) I have many combined graphs; I need all the datasources, not just the first one
3) Suggest that AVERAGE/MIN/MAX/LAST variable on line 524 of rrd.php be changed to either a setting (as with the csv export directory) or something you can pick on the export screen

Thanks,
sg
User avatar
pestilence
Cacti User
Posts: 207
Joined: Fri Jul 25, 2003 10:37 am
Location: Athens/Greece
Contact:

Post by pestilence »

sg wrote:I really like cactiquery; it's funcationality I need from Cacti.

Some issues/suggestions/requests:

1) I can't download the data -- the filename is always "/path/to/csvdir/-.csv" and the file is always empty
2) I have many combined graphs; I need all the datasources, not just the first one
3) Suggest that AVERAGE/MIN/MAX/LAST variable on line 524 of rrd.php be changed to either a setting (as with the csv export directory) or something you can pick on the export screen

Thanks,
sg
Sorry for the late reply

1) Hmm i have to check this, filenames are parsed from the graph title.

2) Combined graphs is something i will try to work on (implement cdef functions) it is a bit of trouble...but we are going to try our best :)
3) Yap i was planning to add this in this release...but i forgot...i will do so in the next release :)
/* * Oops. The kernel tried to access some bad page. We'll have to * terminate things with extreme prejudice. */ die_if_kernel("Oops", regs, error_code);
spignataro
Posts: 41
Joined: Mon Nov 07, 2005 11:21 pm

Post by spignataro »

it shows me the following error:

Code: Select all

Notice: Undefined variable: valine in C:\apache2\Apache2\htdocs\lib\rrd.php on line 905
i am running windows xp with apache. Thanks

edit:
also the cvs file is created....but the problem is there is nothing in it and it cant be read. Am i doing something wrong. I read the instructions. Thanks
User avatar
pestilence
Cacti User
Posts: 207
Joined: Fri Jul 25, 2003 10:37 am
Location: Athens/Greece
Contact:

Post by pestilence »

spignataro wrote:it shows me the following error:

Code: Select all

Notice: Undefined variable: valine in C:\apache2\Apache2\htdocs\lib\rrd.php on line 905
i am running windows xp with apache. Thanks

edit:
also the cvs file is created....but the problem is there is nothing in it and it cant be read. Am i doing something wrong. I read the instructions. Thanks
I am not sure if cactiquery works properly under Windows, i have to check it on a Windows box
/* * Oops. The kernel tried to access some bad page. We'll have to * terminate things with extreme prejudice. */ die_if_kernel("Oops", regs, error_code);
spignataro
Posts: 41
Joined: Mon Nov 07, 2005 11:21 pm

Post by spignataro »

i dont think it does...works fine under a linux box...but the place that im using it at is a windows environment.
sg
Posts: 30
Joined: Tue Jun 01, 2004 12:55 pm

Post by sg »

Thanks for the work on cactiquery.

Perhaps it would be more efficient to port it to the new plugin arch. :)
User avatar
ScOp3
Cacti User
Posts: 61
Joined: Wed Aug 03, 2005 4:14 am
Location: Cologne Germany
Contact:

Post by ScOp3 »

When i try to untar the file i get an error at the end.

tar: A lone zero block at 420

Can anyone confirm that?

Edit: No one with the same issue when untaring the file? Can anyone do a quick check plz?
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests