Dataquery (ex cactiquery) 1.0a released

Ahuber · **Posted:** Tue Nov 21, 2006 3:21 pm

TFC Are you sure there isn't an error message at the top of the page that shows nothing?

I'm assuming you did your $plugin []

double check to see if CSV export path exists. I don't think it self creates.
Also, enable viewing permission for the users which will use this.

TFC · **Posted:** Wed Nov 22, 2006 1:53 am

Ahuber wrote:

TFC Are you sure there isn't an error message at the top of the page that shows nothing?

I'm assuming you did your $plugin []

double check to see if CSV export path exists. I don't think it self creates.
Also, enable viewing permission for the users which will use this.

Ahuber wrote:

TFC Are you sure there isn't an error message at the top of the page that shows nothing?

I'm assuming you did your $plugin []

double check to see if CSV export path exists. I don't think it self creates.
Also, enable viewing permission for the users which will use this.

Here is the config.php output:

Quote:

$plugins = array();
//$plugins[] = 'thold';
$plugins[] = 'weathermap';
$plugins[] = 'hostinfo';
$plugins[] = 'thold';
$plugins[] = 'reports';
$plugins[] = 'devices';
$plugins[] = 'links';
$plugins[] = 'dataquery';

And plugins directory is:

Quote:

[root@citizen plugins]# ls -la
...
drwxr-xr-x 6 root nobody 4096 Nov 17 13:47 dataquery
...

this is the user that run httpd:

Quote:

[root@citizen plugins]# ps -ef |grep httpd
root 2110 1 0 Oct19 ? 00:00:03 /usr/sbin/httpd
apache 27523 2110 0 Nov21 ? 00:00:11 /usr/sbin/httpd
...
...
apache 23962 2110 0 Nov21 ? 00:00:02 /usr/sbin/httpd
apache 24065 2110 0 Nov21 ? 00:00:01 /usr/sbin/httpd
apache 24074 2110 0 Nov21 ? 00:00:01 /usr/sbin/httpd
...
...

And finally this is the csv directory permissions:

Quote:

[root@citizen dataquery]# ls -la
total 80
drwxr-xr-x 6 root nobody 4096 Nov 17 13:47 .
drwxr-xr-x 9 root root 4096 Nov 17 13:47 ..
-rw-r--r-- 1 root root 11604 Nov 3 16:57 class_cactiquery.php
drwxr-xr-x 2 root root 4096 Nov 17 13:47 css
drwxrwxr-x 2 root apache 4096 Nov 17 13:47 csv
-rw-r--r-- 1 root root 4052 Nov 3 16:58 dataquery.php
drwxr-xr-x 2 root root 4096 Nov 17 13:47 images
-rw-r--r-- 1 root root 26925 Jul 25 10:15 LICENSE
-rw-r--r-- 1 root root 3880 Nov 3 16:57 README
-rw-r--r-- 1 root root 5222 Nov 3 16:58 setup.php
drwxr-xr-x 2 root root 4096 Nov 17 14:02 view

As you see permission is adjusted as README describe.
But dataquery icon not shown. I can give the realm permissions thats all.

Ahuber · **Posted:** Wed Nov 22, 2006 3:26 pm

I don't know if this counts, but i'm using cacti 0.8.6i (on windows with apache)
Is there a dataquery tab in your settings page in cacti?
your other post makes it sound like you do..
when you veiw your graph, under the graphs tab, the icon does NOT show up, correct?

Also, what version of dataquery are you trying to install?

TFC · **Posted:** Thu Nov 23, 2006 1:06 am

Hi,
I give the permission for nobody to csv dir. also.
There is no dataquery tab (also there isno tab image in downloaded source)
And finally there is no icon shown.
The version of dataquery is Dataquery (dataquery - v0.1.2a)

TheWitness · **Posted:** Thu Nov 23, 2006 7:23 am

We have to audit all the plugin Id's and ask some of the authors to change theirs. It would appear that there is some overlap in the security information.

For each plugin, there is a Realm ID, each plugin must use a unique Realm ID in their setup.php. If they don't, they won't load properly. This topic will be handled separately, when I get a few cycles. Until then, please audit all of your plugin and verify that the realm ID's are unique.

TheWitness

fmangeant · **Posted:** Thu Nov 23, 2006 9:55 am

TFC wrote:

There is no dataquery tab (also there isno tab image in downloaded source)
And finally there is no icon shown.
The version of dataquery is Dataquery (dataquery - v0.1.2a)

Hi

can you try with version 0.1.4a ?

Did you add the "View Dataqueries" to your user ?

TFC · **Posted:** Fri Nov 24, 2006 2:01 am

To The Witness:
This plugin have realm id like this:

Code:

        $user_auth_realm_filenames['weathermap-cacti-plugin.php'] = 43;
        $user_auth_realm_filenames['weathermap-cacti-plugin-mgmt.php'] = 42;

To fmangeant:
I download and install new version and as admin I checked "view dataqueirs" box for me.
Nothing changed...

TFC · **Posted:** Fri Nov 24, 2006 2:50 am

opps wrong realm taken from code..
I took from setup.php of weathermap.
Correct one is:

Code:

        $user_auth_realm_filenames['dataquery.php'] = 33;
        $user_auth_realms[33]='View Dataqueries';

pestilence · **Posted:** Mon Nov 27, 2006 1:20 am

Hello everyone, i was away for 2 weeks due to work i am back going to check the issues and get back to everyone.
Regards

TFC · **Posted:** Tue Nov 28, 2006 2:22 am

Does anybody have an idea about my problem?

pestilence · **Posted:** Tue Nov 28, 2006 2:53 am

TFC wrote:

Does anybody have an idea about my problem?

Your cacti version is older than the cacti version the plugin was written under.
I will try though to check furthermore and see if i can find anything else.

TFC · **Posted:** Tue Nov 28, 2006 6:54 am

pestilence wrote:

TFC wrote:

Does anybody have an idea about my problem?

Your cacti version is older than the cacti version the plugin was written under.
I will try though to check furthermore and see if i can find anything else.

I think if there is a requirement part in each plugin and if this part contains min cacti version, it will be better.
Anyway, I need that plugin but i dont wanna upgrade my cacti

gru · **Joined:** Fri Jun 02, 2006 2:46 am **Posts:** 10

Hi,

the dataquery plugin is working. Installation on 0.8.6i cacti with plugin-arch 1.0 was no problem.
But I'm missing something.

I've got a loadaverage graph with three datasources (1,5,15min.) and when pressing the dataquery button I only get 1 rrd (load15min) as output.

Is it somehow possible to get a csv output of all three datasources (say the whole graph)?

Thanks in advance,
keep up the good work,
greetings,
Johannes

TheWitness · **Posted:** Wed Dec 20, 2006 7:28 pm

Pestilence,

I need to revise your plugin. Do you have an issue with that? Changes will be subtile but significant.

TheWitness

mreyes · **Joined:** Thu Dec 21, 2006 11:13 am **Posts:** 3

how make this at crontab ?

php dataquery.php action=dump local_graph_id=178 rra_id=0 view_type=AVERAGE graph_start=1166706906 graph_end=1166710506

i think first problem is the auth ??

Dataquery (ex cactiquery) 1.0a released

Who is online