Hello, i recently install Cacti with Xampp in W7, and i want to graph a sql query.
The query give me time and value, wich is the most usefull template and how to use to resolve my graph.
Thanks...
Graph MS SQL Query
Moderators: Developers, Moderators
Re: Graph MS SQL Query
Start by reading the examples in http://docs.cacti.net/
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
Re: Graph MS SQL Query
well i reading some how to`s and information, i create a php scrip to conect MS SQL and follow that steps
Create a Data Input Method to tell Cacti how to call the script and what to expect from it.
Create a Data Source to tell cacti how and where the data will be stored.
Create a Graph to tell cacti how the data will be presented in graph form.
Add Graph to Graph View so you can view the graph.
View the Graph
but, i have an error in graph manager create a new graph, tur on debug mode and cati say:
RRDTool Command:
c:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="VALUES GRAPH" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--units-exponent="0" \
--vertical-label="value" \
--slope-mode \
--font TITLE:10: \
--font AXIS:7: \
--font LEGEND:8: \
--font UNIT:7: \
DEF:a="C\:/xampp/htdocs/cacti/rra/values_9.rrd":values:AVERAGE \
LINE2:a#FF0000FF:"" \
GPRINTLAST:"%8.2lf %s"
RRDTool Says:
ERROR: opening 'C:/xampp/htdocs/cacti/rra/values_9.rrd': No such file or directory
who i did wrong????
thank a lot!!!
Create a Data Input Method to tell Cacti how to call the script and what to expect from it.
Create a Data Source to tell cacti how and where the data will be stored.
Create a Graph to tell cacti how the data will be presented in graph form.
Add Graph to Graph View so you can view the graph.
View the Graph
but, i have an error in graph manager create a new graph, tur on debug mode and cati say:
RRDTool Command:
c:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="VALUES GRAPH" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--units-exponent="0" \
--vertical-label="value" \
--slope-mode \
--font TITLE:10: \
--font AXIS:7: \
--font LEGEND:8: \
--font UNIT:7: \
DEF:a="C\:/xampp/htdocs/cacti/rra/values_9.rrd":values:AVERAGE \
LINE2:a#FF0000FF:"" \
GPRINTLAST:"%8.2lf %s"
RRDTool Says:
ERROR: opening 'C:/xampp/htdocs/cacti/rra/values_9.rrd': No such file or directory
who i did wrong????
thank a lot!!!
Re: Graph MS SQL Query
You need to start with the basics and find where the process has broken down.
1) does your script return data when ran under the Scheduled task user's account?
2) Is cacti able to execute the script and returns data? Debug logging of cacti.log is very useful...
Once those questions are answered, then you can proceed to why this specific graph isnt working.
1) does your script return data when ran under the Scheduled task user's account?
2) Is cacti able to execute the script and returns data? Debug logging of cacti.log is very useful...
Once those questions are answered, then you can proceed to why this specific graph isnt working.
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
Who is online
Users browsing this forum: No registered users and 4 guests