[solved] need help for Bind stats

[chefchanyu]

Any one can help me why my graph not working?

C:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=1285728899 \
--end=1285815299 \
--title="qdns2 - BIND 9 |query_bindName| Statistics" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
COMMENT:"From 2010/09/29 12\:54\:59 To 2010/09/30 12\:54\:59\c" \
COMMENT:" \n" \
--vertical-label="queries per 5 minutes" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
CDEF:cdefa=a,300,* \
LINE1:cdefa#00CF00FF:"Successful Queries" \
GPRINT:cdefa:LAST:"Current\:%8.2lf%s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf%s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf%s\n" \
LINE1:cdefa#FF0000FF:"Failed Queries" \
GPRINT:cdefa:LAST:" Current\:%8.2lf%s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf%s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf%s\n" \
LINE1:cdefa#FF6044FF:"NXDOMAIN Queries" \
GPRINT:cdefa:LAST:" Current\:%8.2lf%s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf%s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf%s\n"

[BSOD2600]

please read/follow the links http://forums.cacti.net/viewtopic.php?f=3&t=11747

[chefchanyu]

Hi:

Here info from the debug. please let where went wrong.

Code: Select all

RRDTool Command:

C:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="qdns2 - BIND 9 |query_bindName| Statistics" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="queries per 5 minutes" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
CDEF:cdefa=a,300,* \
LINE1:cdefa#00CF00FF:"Successful Queries"  \
GPRINT:cdefa:LAST:"Current\:%8.2lf%s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf%s\n"  \
LINE1:cdefa#FF0000FF:"Failed Queries"  \
GPRINT:cdefa:LAST:"    Current\:%8.2lf%s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf%s\n"  \
LINE1:cdefa#FF6044FF:"NXDOMAIN Queries"  \
GPRINT:cdefa:LAST:"  Current\:%8.2lf%s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf%s\n" 

RRDTool Says:

ERROR: invalid rpn expression in: a,300,*

[BSOD2600]

There is no data source associated to that graph.

[chefchanyu]

I did setup data source.

Code: Select all

Data Source Debug

C:/rrdtool/rrdtool.exe create \
C:/Apache2/htdocs/cacti/rra/42/1023.rrd \
--step 300  \
DS:success:DERIVE:600:0:10000 \
DS:recursion:DERIVE:600:0:10000 \
DS:failure:DERIVE:600:0:10000 \
DS:nxrrset:DERIVE:600:0:10000 \
DS:referral:DERIVE:600:0:10000 \
DS:nxdomain:DERIVE:600:0:10000 \
RRA:AVERAGE:0.5:1:500 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MAX:0.5:1:500 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \

[chefchanyu]

Hi:

I manage to display the table.
But just not getting the graph working.

Code: Select all

C:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-14400 \
--end=-300 \
--title="qdns2 - BIND 9 |query_bindName| Statistics" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="queries per 5 minutes" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="C\:/Apache2/htdocs/cacti/rra/42/1023.rrd":nxrrset:AVERAGE \
DEF:b="C\:/Apache2/htdocs/cacti/rra/42/1023.rrd":failure:AVERAGE \
DEF:c="C\:/Apache2/htdocs/cacti/rra/42/1023.rrd":nxdomain:AVERAGE \
CDEF:cdefa=a,300,* \
CDEF:cdefe=b,300,* \
CDEF:cdefi=c,300,* \
LINE1:cdefa#00CF00FF:"Successful Queries"  \
GPRINT:cdefa:LAST:"Current\:%8.2lf%s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf%s\n"  \
LINE1:cdefe#FF0000FF:"Failed Queries"  \
GPRINT:cdefe:LAST:"    Current\:%8.2lf%s"  \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf%s\n"  \
LINE1:cdefi#FF6044FF:"NXDOMAIN Queries"  \
GPRINT:cdefi:LAST:"  Current\:%8.2lf%s"  \
GPRINT:cdefi:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefi:MAX:"Maximum\:%8.2lf%s\n" 

[BSOD2600]

As stated before, read through http://forums.cacti.net/viewtopic.php?f=3&t=11747 especially the debugging FAQ to find out where the script is breaking.

[chefchanyu]

Hi:

I tried to follow FAQ and I get no result from process Monitor.
And also run the debug on cacti I got this output.
I have no idea where went wrong.

Code: Select all

RRDTool Command:

C:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="QDNS2 - BIND 9 |query_bindName| Statistics" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="queries per 5 minutes" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="C\:/Apache2/htdocs/cacti/rra/43/1025.rrd":success:AVERAGE \
DEF:b="C\:/Apache2/htdocs/cacti/rra/43/1025.rrd":failure:AVERAGE \
DEF:c="C\:/Apache2/htdocs/cacti/rra/43/1025.rrd":nxdomain:AVERAGE \
CDEF:cdefa=a,300,* \
CDEF:cdefe=b,300,* \
CDEF:cdefi=c,300,* \
LINE1:cdefa#00CF00FF:"Successful Queries"  \
GPRINT:cdefa:LAST:"Current\:%8.2lf%s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf%s\n"  \
LINE1:cdefe#FF0000FF:"Failed Queries"  \
GPRINT:cdefe:LAST:"    Current\:%8.2lf%s"  \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf%s\n"  \
LINE1:cdefi#FF6044FF:"NXDOMAIN Queries"  \
GPRINT:cdefi:LAST:"  Current\:%8.2lf%s"  \
GPRINT:cdefi:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefi:MAX:"Maximum\:%8.2lf%s\n" 

RRDTool Says:

OK

[BSOD2600]

follow http://docs.cacti.net/manual:087:4_help.2_debugging

[chefchanyu]

Hi:

Here is cacti.log for this DNS.

Code: Select all

10/07/2010 09:55:07 AM - CMDPHP: Poller[0] Host[43] PING: UDP Ping Success (1 ms)
10/07/2010 09:55:07 AM - CMDPHP: Poller[0] Host[43] RECACHE: Processing 1 items in the auto reindex cache for 'qdns2.msg.in.telstra.com.au'.
10/07/2010 09:55:09 AM - CMDPHP: Poller[0] Host[43] DS[1025] WARNING: Result from CMD not valid.  Partial Result: U
10/07/2010 09:55:09 AM - CMDPHP: Poller[0] Host[43] DS[1025] CMD: perl C:/Apache2/htdocs/cacti/scripts/bind9-stats.pl getall GLOBAL, output: U

[BSOD2600]

Great, so when you manually run that perl script that cacti used, does it work?

[chefchanyu]

Great, so when you manually run that perl script that cacti used, does it work?

How can I manually run that perl script?

[BSOD2600]

From a command prompt.

If you don't know how to run a perl script, I'm afraid cacti is beyond your reach.

[chefchanyu]

From a command prompt.

If you don't know how to run a perl script, I'm afraid cacti is beyond your reach.

I know how to run the perl script but don't know which perl script you want me to run.
And sorry I have no much idea with cacti. that is first time dealing cacti. That why I need
the help.

[BSOD2600]

I know how to run the perl script but don't know which perl script you want me to run.

The perl script that cacti is failing to run properly....bind9-stats.pl. You're trying to troubleshoot the bind stats, remember?