SQL Queries Result Graphs (Plugin + Templates + Script)

web_rene · Post by **web_rene** » Fri Apr 20, 2007 5:48 am

Hi there,

I'm quite new to Cacti and the Plugin Architecture and have just created my first complete Plugin which I wanted to share with you.

The Idea was, to Manage a set of files with a number of Queries from within Cacti to use them as a Datasource combined with a fitting Script and some fitting templates.

Before Setting up a new Graph, you can create a Queryfile with several Database Queries. In my Case I have some count(*) selects, to get the number of entries in specific tables.
When Setting up the Graph you can choose, which Queryfile to use, and how the Single Fields should be Called in the Graphs' description.

Please be aware that this is my first Plugin and that there is no warranty at all, but please also don't hesitate to post your comments.

-- Open Points --
The Update Plugin from Cactiusers.org always shows that there is an update available... don't have a clue why...

Post by **TheWitness** » Fri Apr 20, 2007 9:08 pm

I strongly suggest that you look at things like Reinhard's poller statistics Template for accessing arbitrary data in SQL. I think it fit's better into that model.

TheWitness

Post by **gandalf** » Sat Apr 21, 2007 7:14 am

TheWitness wrote:I strongly suggest that you look at things like Reinhard's poller statistics Template for accessing arbitrary data in SQL.

Find it at http://forums.cacti.net/viewtopic.php?t ... statistics
Reinhard

Post by **TheWitness** » Sat Apr 21, 2007 1:25 pm

I have rethought my position. However, I want this to be core. Are you prepared to take development direction and are you prepared to sign off on GPL?

Regards,

TheWitness

web_rene · Post by **web_rene** » Thu May 03, 2007 4:36 am

Thanks for your offer.
Since I received no reply on my PM I guess you have rethought your position again!?

Anyways, I hope that there are some people out there who can make a use of this plugin.

Post by **TheWitness** » Thu May 03, 2007 7:28 am

Sorry, I am so busy, I have lost track of things. Let me collect my thoughts. What is your locality (time zone)?

Larry

web_rene · Post by **web_rene** » Thu May 03, 2007 8:16 am

My Timezone is GMT+1.

Greetings from Germany.

Post by **TheWitness** » Thu May 03, 2007 2:58 pm

So, how's your noonish tomorrow sound. That would be about 7:00am my time? I would like to conduct a meeting using preferably Skype (I am TheWitness there too), or I can call Germany via Vonage pretty cheap.

PM me with your availability and contact information.

Larry

web_rene · Post by **web_rene** » Thu Nov 08, 2007 8:32 am

Updated Versio
n
Now also compatible with Cacti 0.8.7

Could perhaps someone tell be how the Update-Plugin works, since it keeps telling me that there is an update available for my plugin!?

Post by **TheWitness** » Fri Nov 09, 2007 1:23 am

I have updated the Rosetta with your information thanks!!

http://forums.cacti.net/viewtopic.php?t=14985

TheWitness

billporte · Post by **billporte** » Thu Nov 22, 2007 12:33 pm

Hello, I tried your plugin, but I've got errors:
Nothing come on graph and cacti log give me

11/22/2007 06:15:06 PM - CMDPHP: Poller[0] Host[11] DS[384] CMD: c:/php/php.exe -q C:/Inetpub/wwwroot/cacti/scripts/mysql_query.php localhost 3306 'user' 'pw' 'example.sql', output: U
11/22/2007 06:15:06 PM - CMDPHP: Poller[0] Host[11] DS[384] WARNING: Result from CMD not valid. Partial Result: File does not exist

The example.sql is under C:\Inetpub\wwwroot\cacti\plugins\sqlqueries\queries

Everything seems goog, I tried to passed on cactid, but it's the same

Thanks for help

billporte · Post by **billporte** » Fri Nov 23, 2007 7:46 am

It work now, but I've maid some modifications :
in the 4 template.xml, I remove the ' character which were on
'<username>' '<password>' '<query_file>'
<username> <password> <query_file>

and In the mysql_query.php I had to hardcode the path for my queries
$cacti_queries_path = "C:/Inetpub/wwwroot/cacti/plugins/sqlqueries/queries/";

aboyz · Post by **aboyz** » Sat Jan 19, 2008 1:38 am

Hi,

On top left under console. I don't see SQL Query? Know why its not showing up?

aboyz · Post by **aboyz** » Sat Jan 19, 2008 5:15 pm

Anyone know what I am doing wrong? I tried to install the Plugin Architecture
Stable
: 1.4

I added a plugins into that folder but its now showing up in my CONSOLE. Anyone know what I'm doing wrong? Here is the step I did.

Clean installation of the Cacti 0.8.7a , and the new Plugin Architechture 1.4 which have the 0.8.7a, So basically I just drag plugin architechture into the cacti main folder and overwrite it. The plugin architureture say to edit the includes/config.php but it doesn't have the new one. It is cacit old config.php . Anyone know if I'm missing any step? Please advise.

Is there some stuff I'm missing?
Thanks!!

aboyz · Post by **aboyz** » Sun Jan 20, 2008 2:46 am

Ok,

I got the plugins to show up, I created a sql queries, and graph it, but the graph is not showing up.

Anyway to test this.? or troubleshoot this?

Can someone help me out. Why my graph is not showing up here is my example.sql data.

select count(*) "WHERE customer_id != 0" from oscom.whos_online;
select count(*) "WHERE customer_id = 0" from oscom.whos_online;

Thanks!!

Cacti

SQL Queries Result Graphs (Plugin + Templates + Script)

SQL Queries Result Graphs (Plugin + Templates + Script)

Update

I am not gettin SQL Query on Console

Help.!

got it working

Who is online