Cactiquery 0.8.6e

pestilence · Posted: Mon Jul 04, 2005 2:44 am Post subject: Cactiquery 0.8.6e

Initial release for 0.8.6e version.
Tested and found working.

About Cactiquery:
Cactiquery is a query tool for cacti it will query graphs for raw values (formated in human readable format) and return them into columns, from there you can dump the results into a csv formated file which can be processed with a spreadsheet program.
Note that cactiquery does NOT SUPPORT cdef functions inside graphs, this means that you can query standalone graphs and get the proper values, combined graphs or graphs that make use of CDEF functions will not produce proper values since we don't parse yet CDEF functions.

Screenshot of the script follows

TheWitness · Posted: Mon Jul 04, 2005 7:08 am Post subject:

Pestilence,

I was thinking of suggesting to Ian and Tony to integrate cactiquery as a part of GraphZooming feature in 0.9. Are you okay with that?

Larry

pestilence · Posted: Mon Jul 04, 2005 7:30 am Post subject:

As per Readme

i would love to see it integraded

Go ahead

I am currently working on finding a solution for implementing CDEF functions inside the query tool

If you can suggest any solutions for that i think we would be creating a perfect query tool.

FIacusso · Joined: 17 Jun 2005 Posts: 25

Hello All,

Thanks for the heads up with the new release...but i am still struggling...

I modified the rrd.php to "AVERAGE" and i still get a blank screen with a link to dump to csv... here are my details:

Notice: Undefined variable: fp_index in C:\apache\Apache2\htdocs\cacti\lib\rrd.php on line 886

Notice: Undefined variable: valine in C:\apache\Apache2\htdocs\cacti\lib\rrd.php on line 886

Warning: fwrite(): supplied argument is not a valid stream resource in C:\apache\Apache2\htdocs\cacti\lib\rrd.php on line 886

Notice: Undefined variable: fp_index in C:\apache\Apache2\htdocs\cacti\lib\rrd.php on line 887

Warning: fclose(): supplied argument is not a valid stream resource in C:\apache\Apache2\htdocs\cacti\lib\rrd.php on line 887

Any ideas?

Thanks a bunch!!

~Fab

pestilence · Posted: Tue Jul 05, 2005 8:38 am Post subject:

New zip file uploaded i founded a line inside the rrd.php lib file that needed to change.

pestilence

FIacusso · Joined: 17 Jun 2005 Posts: 25

Still no luck... this time around errors on line 902...

I am graphing a 3Com Total Control Modem box which displays how many active users are on....

With this cacti-query... my graphs work for a few mins...then they will not load again, they just get stuck... so i have to reload the cacti software without the cacti-query to get back in business...

Thanks

--the only thing i havent tried is an updated rrd tool-- the only luck i've had is with 1.0x not the 1.2x ... --