Sql Queries Script

tetu_024 · Joined: 20 Jun 2007 Posts: 31

Hi,

I have a problem with the sqlqueries script. When i want to create a graph with Mysql 5 count queries the field host name isn't being displayed. I'm attaching screen shots.

Et

web_rene · Joined: 20 Apr 2007 Posts: 21

Hi and sorry for the Late reply.

The Hostname is taken from the Host you create the Graph for.

Means, if you create a graph for

db1.yourdomain.com he will use this hostname in the mysql-connect string as targethost.

tetu_024 · Joined: 20 Jun 2007 Posts: 31

Thanks for the reply. is the query good for postgres sql server?

web_rene · Joined: 20 Apr 2007 Posts: 21

Up to know, it only supports mysql.

But if you have some experience with scripting in php with databaseconnects to pg, I think it should be no Problem.

dass_ba · Joined: 31 Mar 2008 Posts: 2

can you post this SQLquery script and any xml template if one available ?

Thanks

web_rene · Joined: 20 Apr 2007 Posts: 21

There is another Post which holds the files you are looking for:

http://forums.cacti.net/about20757.html&highlight=SQLQueries

dass_ba · Joined: 31 Mar 2008 Posts: 2

Thank you web_ren - I think this sqlquery is very close to what I'm looking for. I need to make a template and produce the graph for sql 2005 transaction query - hope this one will serve the purpose.

Thanks

ceyounger · Joined: 10 Feb 2006 Posts: 35 Location: San Jose, CA USA

web_rene · Joined: 20 Apr 2007 Posts: 21

Actually the PHP Script uses MySQL Connect, so I guess it won't work with SQL2005 Server...

TheWitness · Posted: Wed Apr 02, 2008 4:51 am Post subject:

The correct approach here is to use a Script Server script that contains the SQL and the connect logic. That script would use PHP's internal database functions to execute your queries inside of your Script Server scripts.

PHP Supports connectivity to Postgress and Microsoft SQL Server without issue. By default, Cacti's API does not. I would suggest that the aformentioned template was designed specifically for MySQL.

From my perspective this is not the best approach, although a creative one, and something to think about for future enhancements to Cacti.

There are several examples of Script Server scripts that have been written to obtain information from a database. If you need help, I would goto the PHP.Net website and look at the various database connectors for examples.

Regards,

TheWitness