{"id":72,"date":"2021-07-09T14:12:33","date_gmt":"2021-07-09T14:12:33","guid":{"rendered":"http:\/\/www.iam8up.com\/?p=72"},"modified":"2021-07-13T14:08:39","modified_gmt":"2021-07-13T14:08:39","slug":"unbound-stats-graphed-with-xymon","status":"publish","type":"post","link":"https:\/\/www.iam8up.com\/?p=72","title":{"rendered":"Unbound stats graphed with Xymon"},"content":{"rendered":"

Refer to this overall guide for a master overview and below is an example hopefully others can find useful.\u00a0 This is for the Unbound stats we wanted to monitor initially and it may change.<\/p>\n

Script to collect data<\/p>\n

On the Xymon client:<\/p>\n

touch ~xymon\/ext\/unboundstats.sh && chown xymon:xymon unboundstats.sh && chmod 744 unboundstats.sh<\/p><\/blockquote>\n

unboundstatsh.sh:<\/p>\n

#!\/bin\/sh<\/p>\n

\/usr\/sbin\/unbound-control stats | \\
\ngrep -E “^total.num.queries|^total.num.queries_ip_ratelimited|^total.num.cachehits|^total.num.cachemiss|^total.recursion.time.avg|num.query.tcp|^unwanted.queries|^unwanted.replies” | \\
\nawk -F= -v OFS=: ‘{gsub(\/\\.\/, “”, $1); print}’ > \/tmp\/unbound.stats<\/p>\n

#sed would remove decimal in the recursion time value
\n#sed s,=,:, | sed s,\\\\.,,g > \/tmp\/unbound.stats<\/p>\n

$XYMON $XYMSRV “status $MACHINE.unboundstats green `date`<\/p>\n

`cat \/tmp\/unbound.stats`
\n”<\/p>\n

exit 0<\/p><\/blockquote>\n

You need to restart the Xymon server!\u00a0 Generally this is systemctl restart xymon <\/strong>or \/etc\/init.d\/xymonlaunch.cfg restart<\/strong><\/p>\n

I’m not sure if this is the right way of going about the permissions issue, but the Xymon user needs to be able to read the SSL key\/pem…<\/p>\n

chgrp xymon\u00a0\/etc\/unbound\/unbound_control.pem\u00a0\/etc\/unbound\/unbound_control.key\u00a0\/etc\/unbound\/unbound_server.pem\u00a0\/etc\/unbound\/unbound_server.key<\/p><\/blockquote>\n

Now make the Xymon client run the above script in ~xymon\/etc\/clientlaunch.cfg:<\/p>\n

#this collects unbound stats
\n[unboundstats]
\nENVFILE $XYMONCLIENTHOME\/etc\/xymonclient.cfg
\nCMD $XYMONCLIENTHOME\/ext\/unboundstats.sh
\nINTERVAL 5m<\/p><\/blockquote>\n

On the Xymon server you will want to turn this test submission data into RRD.\u00a0 In ~xymon\/server\/etc\/xymonserver.cfg:<\/p>\n

TEST2RRD=”cpu=la,defaultdefaultdefault,unboundstats=ncv<\/strong>”<\/p>\n

SPLITNCV_unboundstats=”totalnumqueries:GAUGE,totalnumqueries_ip_ratelimited:GAUGE,totalnumcachehits:GAUGE,totalnumcachemiss:GAUGE,totalrecursiontimeavg:GAUGE,numquerytcp:GAUGE,numquerytcpout:GAUGE,unwantedqueries:GAUGE,unwantedreplies:GAUGE”<\/strong><\/p>\n

GRAPHS=”defaultdefaultdefault”<\/p>\n

GRAPHS_unboundstats=”unboundstats,unboundstats1″ #note this requires xymon 4.3.20 https:\/\/lists.xymon.com\/archive\/2017-April\/044560.html<\/strong><\/p><\/blockquote>\n

After a few minutes you should see RRD files<\/p>\n

# ls \/var\/lib\/xymon\/rrd\/HOST.FOOBAR.COM\/unboundstats,*
\n\/var\/lib\/xymon\/rrd\/HOST.FOOBAR.COM\/unboundstats,numquerytcpout.rrd
\n…<\/p><\/blockquote>\n

Add the graph definition (this translates from the RRD files to pretty graphs and once the file is edited\/saved you can refresh the test page on Xymon\/unboundstats for live viewing) in\u00a0~xymon\/server\/etc\/graphs.cfg:<\/p>\n

[unboundstats]
\nTITLE Unbound Stats
\nYAXIS Num
\nDEF:numqueries=unboundstats,totalnumqueries.rrd:lambda:AVERAGE
\nDEF:numqueriesiprate=unboundstats,totalnumqueries_ip_ratelimited.rrd:lambda:AVERAGE
\nDEF:numcachehits=unboundstats,totalnumcachehits.rrd:lambda:AVERAGE
\nDEF:totalnumcachemiss=unboundstats,totalnumcachemiss.rrd:lambda:AVERAGE<\/p>\n

LINE2:numqueries#00CCCC:Total Queries
\nLINE2:numqueriesiprate#00FF00:Queries IP Rate
\nLINE2:numcachehits#FF0000:Total Cache Hits
\nLINE2:totalnumcachemiss#0000FF:Total Cache Miss<\/p>\n

COMMENT:\\n
\nGPRINT:numqueries:LAST:Total Queries \\: %5.1lf%s (cur)
\nGPRINT:numqueries:MAX: \\: %5.1lf%s (max)
\nGPRINT:numqueries:MIN: \\: %5.1lf%s (min)
\nGPRINT:numqueries:AVERAGE: \\: %5.1lf%s (avg)\\n<\/p>\n

GPRINT:numqueriesiprate:LAST:IP Rate Queries \\: %5.1lf%s (cur)
\nGPRINT:numqueriesiprate:MAX: \\: %5.1lf%s (max)
\nGPRINT:numqueriesiprate:MIN: \\: %5.1lf%s (min)
\nGPRINT:numqueriesiprate:AVERAGE: \\: %5.1lf%s (avg)\\n<\/p>\n

GPRINT:numcachehits:LAST:Cache Hits\\: %5.1lf%s (cur)
\nGPRINT:numcachehits:MAX: \\: %5.1lf%s (max)
\nGPRINT:numcachehits:MIN: \\: %5.1lf%s (min)
\nGPRINT:numcachehits:AVERAGE: \\: %5.1lf%s (avg)\\n<\/p>\n

GPRINT:totalnumcachemiss:LAST:Cache Miss\\: %5.1lf%s (cur)
\nGPRINT:totalnumcachemiss:MAX: \\: %5.1lf%s (max)
\nGPRINT:totalnumcachemiss:MIN: \\: %5.1lf%s (min)
\nGPRINT:totalnumcachemiss:AVERAGE: \\: %5.1lf%s (avg)\\n<\/p>\n

[unboundstats1]
\nTITLE Unbound Stats
\nYAXIS Num
\nDEF:totalrecursiontimeavg=unboundstats,totalrecursiontimeavg.rrd:lambda:AVERAGE
\nDEF:numquerytcp=unboundstats,numquerytcp.rrd:lambda:AVERAGE
\nDEF:numquerytcpout=unboundstats,numquerytcpout.rrd:lambda:AVERAGE
\nDEF:unwantedqueries=unboundstats,unwantedqueries.rrd:lambda:AVERAGE
\nDEF:unwantedreplies=unboundstats,unwantedreplies.rrd:lambda:AVERAGE<\/p>\n

LINE2:totalrecursiontimeavg#AAA1AA:Average Recusion Time
\nLINE2:numquerytcp#C6913B:Queries w TCP
\nLINE2:numquerytcpout#8BBFFF:Queries out w TCP
\nLINE2:unwantedqueries#FF69B4:Unwanted Queries
\nLINE2:unwantedreplies#FFFF00:Unwanted Replies<\/p>\n

COMMENT:\\n
\nGPRINT:totalrecursiontimeavg:LAST:Recursion Time Avg\\: %5.1lf%s (cur)
\nGPRINT:totalrecursiontimeavg:MAX: \\: %5.1lf%s (max)
\nGPRINT:totalrecursiontimeavg:MIN: \\: %5.1lf%s (min)
\nGPRINT:totalrecursiontimeavg:AVERAGE: \\: %5.1lf%s (avg)\\n<\/p>\n

GPRINT:numquerytcp:LAST:TCP Queries\\: %5.1lf%s (cur)
\nGPRINT:numquerytcp:MAX: \\: %5.1lf%s (max)
\nGPRINT:numquerytcp:MIN: \\: %5.1lf%s (min)
\nGPRINT:numquerytcp:AVERAGE: \\: %5.1lf%s (avg)\\n<\/p>\n

GPRINT:numquerytcpout:LAST:TCP Queries Out\\: %5.1lf%s (cur)
\nGPRINT:numquerytcpout:MAX: \\: %5.1lf%s (max)
\nGPRINT:numquerytcpout:MIN: \\: %5.1lf%s (min)
\nGPRINT:numquerytcpout:AVERAGE: \\: %5.1lf%s (avg)\\n<\/p>\n

GPRINT:unwantedqueries:LAST:Unwanted Queries\\: %5.1lf%s (cur)
\nGPRINT:unwantedqueries:MAX: \\: %5.1lf%s (max)
\nGPRINT:unwantedqueries:MIN: \\: %5.1lf%s (min)
\nGPRINT:unwantedqueries:AVERAGE: \\: %5.1lf%s (avg)\\n<\/p>\n

GPRINT:unwantedreplies:LAST:Unwanted Replies\\: %5.1lf%s (cur)
\nGPRINT:unwantedreplies:MAX: \\: %5.1lf%s (max)
\nGPRINT:unwantedreplies:MIN: \\: %5.1lf%s (min)
\nGPRINT:unwantedreplies:AVERAGE: \\: %5.1lf%s (avg)\\n<\/p>\n

 <\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

Refer to this overall guide for a master overview and below is an example hopefully others can find useful.\u00a0 This is for the Unbound stats we wanted to monitor initially and it may change. Script to collect data On the Xymon client: touch ~xymon\/ext\/unboundstats.sh && chown xymon:xymon unboundstats.sh && chmod 744 unboundstats.sh unboundstatsh.sh: #!\/bin\/sh \/usr\/sbin\/unbound-control … Continue reading “Unbound stats graphed with Xymon”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-72","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.iam8up.com\/index.php?rest_route=\/wp\/v2\/posts\/72","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.iam8up.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iam8up.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iam8up.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iam8up.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=72"}],"version-history":[{"count":8,"href":"https:\/\/www.iam8up.com\/index.php?rest_route=\/wp\/v2\/posts\/72\/revisions"}],"predecessor-version":[{"id":80,"href":"https:\/\/www.iam8up.com\/index.php?rest_route=\/wp\/v2\/posts\/72\/revisions\/80"}],"wp:attachment":[{"href":"https:\/\/www.iam8up.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=72"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iam8up.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=72"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iam8up.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=72"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}