Cactiquery 0.8.6e

pestilence · Post by **pestilence** » Mon Jul 04, 2005 2:44 am

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

Post by **TheWitness** » Mon Jul 04, 2005 7:08 am

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 · Post by **pestilence** » Mon Jul 04, 2005 7:30 am

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 · Post by **FIacusso** » Tue Jul 05, 2005 7:52 am

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 · Post by **pestilence** » Tue Jul 05, 2005 8:38 am

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

pestilence · Post by **pestilence** » Tue Jul 05, 2005 8:41 am

FIacusso wrote: 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

It seems like nothing is passed to the function.
Could you paste the url and describe what kind of graph you are trying to query?

FIacusso · Post by **FIacusso** » Tue Jul 05, 2005 10:10 am

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 ... --

Cacti

Cactiquery 0.8.6e

Cactiquery 0.8.6e

Still can't quite get cactiquery to work...

Re: Still can't quite get cactiquery to work...

Who is online