Dataquery (ex cactiquery) 1.0a released

[pestilence]

Its my joy to announce you the initial release of the dataquery plugin.
Dataquery is the predecesor of the old cactiquery addon, it has been ported to the plugin architecture for easy installation and troubleshooting.

[pestilence]

Forgot to include the link:
http://cactiusers.org/forums/viewtopic.php?p=2215#2215

[egarnel]

Cool, thanks for bringing this back. It is an awesome util

One quick fix, however:

In the file queryview.php under <cacti dir>/plugins/dataquery/view

Line 169 needs a trailing slash after csv

before:

Code: Select all

$filename = $config['url_path'] . 'plugins/dataquery/csv

after:

Code: Select all

$filename = $config['url_path'] . 'plugins/dataquery/csv[b]/[/b]

Took me a little bit to figure out how to use the plugin until I realized that there was a new icon next to the graphs

[pestilence]

Thanks for mentioning, i have uploaded an updated version.

[pestilence]

Site for cactiquery:

http://pestilence.insert.gr

The webdev.insert.gr is not yet online.

[Exo7]

Hi Pestilence. Thanks for your work on pluginizing cactiquery!

I have found it actually requires plugin architecture 1.0 : I had Plugin Architecture 0.9, and as soon as I enable dataquery in config.php, I have this little error showing up in each page of cacti :

Code: Select all

Notice: Undefined index: graph.php:zoom in /usr/share/cacti/site/lib/functions.php on line 1357

which is

Code: Select all

 /* find the current page in the big array */
        $current_array = $nav{$current_page . ":" . $current_action};

the part "graph.php:zoom" of the error change depending on the page I am browsing in Cacti, but the error is always located in this line 1357 of function.php. The tab "dataquery" next to the "misc" tab in the settings page was ok.

When upgraded to plugin arch 1.0, the error vanish and the little icon for querying graph appear I think you use one of the few hooks added between 0.9 and 1.0.
Well, it was time for to upgrade to 1.0 anyway

[pestilence]

Gonna check your reportings.
Thanks for the feedback.

[pestilence]

New version has been uploaded (0.1.2a)

[pestilence]

Hi Pestilence. Thanks for your work on pluginizing cactiquery!

I have found it actually requires plugin architecture 1.0 : I had Plugin Architecture 0.9, and as soon as I enable dataquery in config.php, I have this little error showing up in each page of cacti :

Code: Select all

Notice: Undefined index: graph.php:zoom in /usr/share/cacti/site/lib/functions.php on line 1357

which is

Code: Select all

 /* find the current page in the big array */
        $current_array = $nav{$current_page . ":" . $current_action};

the part "graph.php:zoom" of the error change depending on the page I am browsing in Cacti, but the error is always located in this line 1357 of function.php. The tab "dataquery" next to the "misc" tab in the settings page was ok.

When upgraded to plugin arch 1.0, the error vanish and the little icon for querying graph appear I think you use one of the few hooks added between 0.9 and 1.0.
Well, it was time for to upgrade to 1.0 anyway

Yes indeed the plugin makes use from one of the new hooks that where added to the graph page

[torstentfk]

Hi,

I have plugin arch V1. and the newest dataquery:
Error:
On the graph Page at the top:
Notice: Undefined index: graph_view.php:tree in /var/www/html/cacti/lib/functions.php on line 1420
"
1419 /* find the current page in the big array */
1420 $current_array = $nav{$current_page . ":" . $current_action};
1421 $current_mappings = split(",", $current_array["mapping"]);
1422 $current_nav = "";
"

and:

After clicking the arrow near the graph to get into the query, I get serveral times:
Notice: A non well formed numeric value encountered in /var/www/html/cacti/plugins/dataquery/class_cactiquery.php on line 226
"
225 $this->_set_date_format();
226 $timestamp = date($this->graph_date, $timestamp);
227 $data = ($matches[1][$j] * (pow(10,(float)$matches[2][$j])));
228 if (isset($timestamp)
"
But the query works.

Where can I configure the timerange the query is using?

Torsten

[torstentfk]

Hi,

at the point to export to csv I get:

Notice: A non well formed numeric value encountered in /var/www/html/cacti/plugins/dataquery/class_cactiquery.php on line 226
class_cactiquery::_open_buffer: Could not open file: /var/www/html/cacti/csvdcimgt21-UnixProcesses.csv for writting
Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/cacti/plugins/dataquery/class_cactiquery.php on line 354

Warning: fclose(): supplied argument is not a valid stream resource in /var/www/html/cacti/plugins/dataquery/class_cactiquery.php on line 377

The CSV directory is empty.

Torsten

[pestilence]

Hmm i will try to debug, allthough its working correctly on 2 boxes...

[egarnel]

Hi,

at the point to export to csv I get:

Notice: A non well formed numeric value encountered in /var/www/html/cacti/plugins/dataquery/class_cactiquery.php on line 226
class_cactiquery::_open_buffer: Could not open file: /var/www/html/cacti/csvdcimgt21-UnixProcesses.csv for writting
Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/cacti/plugins/dataquery/class_cactiquery.php on line 354

Warning: fclose(): supplied argument is not a valid stream resource in /var/www/html/cacti/plugins/dataquery/class_cactiquery.php on line 377

The CSV directory is empty.

Torsten

This sounds like a permissions issue. your web user (apache, nobody,etc) should have ownership & group on the dir typically 755

[torstentfk]

Hi,

....
The CSV directory is empty.

Torsten

This sounds like a permissions issue. your web user (apache, nobody,etc) should have ownership & group on the dir typically 755

Hi,
ls -al
drwxrwxr-x 2 apache apache 4096 Nov 2 10:24 csv/

so the apache has all rights to do so.

Torsten

[egarnel]

Hi,

....
The CSV directory is empty.

Torsten

This sounds like a permissions issue. your web user (apache, nobody,etc) should have ownership & group on the dir typically 755

Hi,
ls -al
drwxrwxr-x 2 apache apache 4096 Nov 2 10:24 csv/

so the apache has all rights to do so.

Torsten

what are the perms for the dataquery above csv?