BIND 9 Statistics for Cacti

Templates, scripts for templates, scripts and requests for templates.

Moderators: Developers, Moderators

Post Reply
Rossco
Cacti User
Posts: 76
Joined: Sat Jan 15, 2005 4:52 pm
Location: London, England

Post by Rossco »

Hi tarpat1

Can you confirm if you are using cody's original script as per the start of this thread, the bayour script or the copy of Codys that I modified for pass_persist?

A few questions for you:

1) What OS are you running under?
2) Are you using snmp v1 ( I've seen occasional oddities with v2c)
3) Can you run bind9-stats-snmpd.pl from the command line?
4) Have you tried snmpwalk from the local machine?
5) Can you retireve any other values from the machine via snmp? system description, uptime etc.
6) Try running rndc stats manually and verify the file is created in the correct location you specified.

Cheers

Rossco
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

This OID must ne installed using the exec/pass option on the target's snmpd.conf. By doing so, you will create the .55 OID on your own and link it to the script that examines the DNS stuff
Reinhard
tarpat1
Posts: 17
Joined: Sun Jan 01, 2006 11:39 pm

Post by tarpat1 »

Thanks for the reply!

I am using Debian 4.0

With version 1 in the snmpwalk command line I get nothing.

Running /usr/local/bin/bind9-stats-snmpd.pl from the command line I get nothing

I am only testing from the local machine so all my results so far have been from the local machine.

I can get other variables from the local machine.

The named.stats file is where I and expecting it to be.
tarpat1
Posts: 17
Joined: Sun Jan 01, 2006 11:39 pm

Post by tarpat1 »

gandalf wrote:This OID must ne installed using the exec/pass option on the target's snmpd.conf. By doing so, you will create the .55 OID on your own and link it to the script that examines the DNS stuff
Reinhard
I have this line in my snmpd.conf

pass .1.3.6.1.4.1.2021.55 /usr/bin/perl /usr/local/bin/bind9-stats-snmpd.pl
tarpat1
Posts: 17
Joined: Sun Jan 01, 2006 11:39 pm

Post by tarpat1 »

tarpat1 wrote:Thanks for the reply!

I am using Debian 4.0

With version 1 in the snmpwalk command line I get nothing.

Running /usr/local/bin/bind9-stats-snmpd.pl from the command line I get nothing

I am only testing from the local machine so all my results so far have been from the local machine.

I can get other variables from the local machine.

The named.stats file is where I and expecting it to be.
Almost forgot, I am using the original script.
Rossco
Cacti User
Posts: 76
Joined: Sat Jan 15, 2005 4:52 pm
Location: London, England

Post by Rossco »

Hi, apologies for not replying sooner.

Thanks for the info - I'm running freebsd, but it shouldnt make any difference.

If you run the script with "-t" at the end it should dump all the information it finds in the rndc stats log you generated, along with the relevent OIDs to your screen, so you will see lots of details like a list of your domains and entries such as:

Dumping count_ids
failure: 4
index: 1
name: 2
nxdomain: 5
nxrrset: 6
recursion: 8
referral: 7
success: 3
Dumping indexes
0.0.127.IN-ADDR.ARPA: 2
<snip>
Getting next oid for: .1.3.6.1.4.1.2021.55.8.357
Checking oid: .1.3.6.1.4.1.2021.55.8.358
.1.3.6.1.4.1.2021.55.8.358
integer
<snip>

Can you confirm if you are getting a list of your domains etc? If you arent getting this I would guess that it isnt finding your rndc stats file - double check the variable $STAT_FILE is correct in the bind9-stats-snmpd.pl script.

If you are getting the expected output, then double check the permissions on the stats file as it may be the snmpd account doesnt have access to read the file, but *your* user a/c does.

Cheers

Rossco
User avatar
Maillon
Posts: 16
Joined: Wed Jul 04, 2007 4:34 am
Location: Paris

Post by Maillon »

Hi all ^^

I follow this link Bind9 Stats 1.0. I choise the SNMP method because my server snmp and cacti are installed on two different machine.

I have another graphs which run correctly.

Now my graph seems that :

Image


It's very strange because when i run snmpwalk i have this :

poseidon:/data/www/cacti/resource/snmp_queries# snmpwalk -ccerberemib -v2c cerbere.domain.net .1.3.6.1.4.1.2021.55
UCD-SNMP-MIB::ucdavis.55.1.1 = INTEGER: 1
UCD-SNMP-MIB::ucdavis.55.1.2 = INTEGER: 2
UCD-SNMP-MIB::ucdavis.55.1.3 = INTEGER: 3
UCD-SNMP-MIB::ucdavis.55.1.4 = INTEGER: 4
UCD-SNMP-MIB::ucdavis.55.2.1 = STRING: "GLOBAL"
UCD-SNMP-MIB::ucdavis.55.2.2 = STRING: "0.0.127.in-addr.arpa_inside"
UCD-SNMP-MIB::ucdavis.55.2.3 = STRING: "domain.net_inside"
UCD-SNMP-MIB::ucdavis.55.2.4 = STRING: "1.168.192.in-addr.arpa_inside"
UCD-SNMP-MIB::ucdavis.55.3.1 = INTEGER: 64866
UCD-SNMP-MIB::ucdavis.55.3.2 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.55.3.3 = INTEGER: 21630
UCD-SNMP-MIB::ucdavis.55.3.4 = INTEGER: 1146
UCD-SNMP-MIB::ucdavis.55.4.1 = INTEGER: 36
UCD-SNMP-MIB::ucdavis.55.4.2 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.55.4.3 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.55.4.4 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.55.5.1 = INTEGER: 21649
UCD-SNMP-MIB::ucdavis.55.5.2 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.55.5.3 = INTEGER: 3411
UCD-SNMP-MIB::ucdavis.55.5.4 = INTEGER: 9
UCD-SNMP-MIB::ucdavis.55.6.1 = INTEGER: 1836
UCD-SNMP-MIB::ucdavis.55.6.2 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.55.6.3 = INTEGER: 1378
UCD-SNMP-MIB::ucdavis.55.6.4 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.55.7.1 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.55.7.2 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.55.7.3 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.55.7.4 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.55.8.1 = INTEGER: 38827
UCD-SNMP-MIB::ucdavis.55.8.2 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.55.8.3 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.55.8.4 = INTEGER: 0


When i run "Verbose Query" in Device-->Machine-->Data Query Debug Information i have :

+ Running data query [17].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/data/www/cacti/resource/snmp_queries/bind9-stats-snmp.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.4.1.2021.55.1'
+ Located input field 'bindIndex' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.2021.55.1'
+ Located input field 'bindName' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.2021.55.2'
+ Found data query XML file at '/data/www/cacti/resource/snmp_queries/bind9-stats-snmp.xml'
+ Found data query XML file at '/data/www/cacti/resource/snmp_queries/bind9-stats-snmp.xml'
+ Found data query XML file at '/data/www/cacti/resource/snmp_queries/bind9-stats-snmp.xml'


Someone have an idea or can help me ?

Thank you
tarpat1
Posts: 17
Joined: Sun Jan 01, 2006 11:39 pm

Post by tarpat1 »

Thanks Rossco.

When I run the script with the -t I get a list of all of my zones as you said. I updated the permissions on the named.stats file and I am having the same result.
Rossco wrote:Hi, apologies for not replying sooner.

Thanks for the info - I'm running freebsd, but it shouldnt make any difference.

If you run the script with "-t" at the end it should dump all the information it finds in the rndc stats log you generated, along with the relevent OIDs to your screen, so you will see lots of details like a list of your domains and entries such as:

Dumping count_ids
failure: 4
index: 1
name: 2
nxdomain: 5
nxrrset: 6
recursion: 8
referral: 7
success: 3
Dumping indexes
0.0.127.IN-ADDR.ARPA: 2
<snip>
Getting next oid for: .1.3.6.1.4.1.2021.55.8.357
Checking oid: .1.3.6.1.4.1.2021.55.8.358
.1.3.6.1.4.1.2021.55.8.358
integer
<snip>

Can you confirm if you are getting a list of your domains etc? If you arent getting this I would guess that it isnt finding your rndc stats file - double check the variable $STAT_FILE is correct in the bind9-stats-snmpd.pl script.

If you are getting the expected output, then double check the permissions on the stats file as it may be the snmpd account doesnt have access to read the file, but *your* user a/c does.

Cheers

Rossco
Rossco
Cacti User
Posts: 76
Joined: Sat Jan 15, 2005 4:52 pm
Location: London, England

Post by Rossco »

Hi Maillon

Odd, your snmpwalk results look fine, I'm not sure why cacti isnt showing it. Can you confirm if you have set snmpv1 for the cacti host entry of this device? I presume it must have worked initially, because the first snmp query it has to perform is to list the domains you wish to graph - this involves an snmpwalk?

You could try running tcpdump on the linux box to confirm if cacti is successfully sending the snmp requests during its polling cycle?

Sorry, I cant think of much else right now - are there any errors showing in your logs? timeouts etc.

Cheers

Rossco
User avatar
Maillon
Posts: 16
Joined: Wed Jul 04, 2007 4:34 am
Location: Paris

Post by Maillon »

Hi Rossco ^^

When i click on Graph -> Cerbere Bind SNMP i have in log (in debug mode) :

Code: Select all

07/17/2007 05:47:49 PM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=-86400 --end=-300 --title="Cerbere BIND SNMP - 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 DEF:a="/data/www/cacti/rra/cerbere_bind_snmp_referral_1113.rrd":success:AVERAGE DEF:b="/data/www/cacti/rra/cerbere_bind_snmp_referral_1113.rrd":failure:AVERAGE DEF:c="/data/www/cacti/rra/cerbere_bind_snmp_referral_1113.rrd":nxdomain:AVERAGE CDEF:cdefa=a,300,* CDEF:cdefe=b,300,* CDEF:cdefi=c,300,* LINE1:cdefa#00CF00:"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#FF0000:"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#FF6044:"NXDOMAIN Queries" GPRINT:cdefi:LAST:" Current\:%8.2lf%s" GPRINT:cdefi:AVERAGE:"Average\:%8.2lf%s" GPRINT:cdefi:MAX:"Maximum\:%8.2lf%s\n"
This file "cerbere_bind_snmp_referral_1113.rrd" doesn't exist in /data/www/cacti/rra

When i click on properties' graph i have :

Code: Select all

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Cerbere BIND SNMP - 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 \
DEF:a="/data/www/cacti/rra/cerbere_bind_snmp_referral_1113.rrd":success:AVERAGE \
DEF:b="/data/www/cacti/rra/cerbere_bind_snmp_referral_1113.rrd":failure:AVERAGE \
DEF:c="/data/www/cacti/rra/cerbere_bind_snmp_referral_1113.rrd":nxdomain:AVERAGE \
CDEF:cdefa=a,300,* \
CDEF:cdefe=b,300,* \
CDEF:cdefi=c,300,* \
LINE1:cdefa#00CF00:"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#FF0000:"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#FF6044:"NXDOMAIN Queries"  \
GPRINT:cdefi:LAST:"  Current\:%8.2lf%s"  \
GPRINT:cdefi:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefi:MAX:"Maximum\:%8.2lf%s\n" 
The SNMP version in my device (as the others machine) is version 2 (i see that "Version 2" is check in Device -> Machine)

Can you tell me how can i launch tcpdump to confirm "if cacti is successfully sending the snmp resquests during its polling cycle ?" (I use Debian to cacti and red hat to snmp server)
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Please note the status of your device in the DEVICE list. Is it UP? What does your log show when running the poller in verbosity level 5?
Reinhard
Rossco
Cacti User
Posts: 76
Joined: Sat Jan 15, 2005 4:52 pm
Location: London, England

Post by Rossco »

Hi Maillon

Try "tcpdump -p udp port 161" as root - confirm you see the udp requests and replies for the .1.3.6.1.4.1.2021.55 range which should hold your bind stats.

You should also probably run your poller in debug mode once and see what the output says for the host these queries are directed at.

Cheers

Rossco
User avatar
Maillon
Posts: 16
Joined: Wed Jul 04, 2007 4:34 am
Location: Paris

Post by Maillon »

So when i launch tcpdump i have this :

Code: Select all

17:54:15.076918 IP poseidon.domain.net.2581 > cerbere.domain.net.snmp:  C=cerberemib GetNextRequest(28)  E:2021.55
17:54:15.118161 IP cerbere.domain.net.snmp > poseidon.domain.net.2581:  C=cerberemib GetResponse(31)  E:2021.55.1.1=1
17:54:15.119284 IP poseidon.domain.net.2581 > cerbere.domain.net.snmp:  C=cerberemib GetNextRequest(30)  E:2021.55.1.1
17:54:15.158201 IP cerbere.domain.net.snmp > poseidon.domain.net.2581:  C=cerberemib GetResponse(31)  E:2021.55.1.2=2
17:54:15.159098 IP poseidon.domain.net.2581 > cerbere.domain.net.snmp:  C=cerberemib GetNextRequest(30)  E:2021.55.1.2
17:54:15.198192 IP cerbere.domain.net.snmp > poseidon.domain.net.2581:  C=cerberemib GetResponse(31)  E:2021.55.1.3=3
17:54:15.198503 IP poseidon.domain.net.2581 > cerbere.domain.net.snmp:  C=cerberemib GetNextRequest(30)  E:2021.55.1.3
17:54:15.238197 IP cerbere.domain.net.snmp > poseidon.domain.net.2581:  C=cerberemib GetResponse(31)  E:2021.55.1.4=4
17:54:15.238544 IP poseidon.domain.net.2581 > cerbere.domain.net.snmp:  C=cerberemib GetNextRequest(30)  E:2021.55.1.4
17:54:15.278202 IP cerbere.domain.net.snmp > poseidon.domain.net.2581:  C=cerberemib GetResponse(36)  E:2021.55.2.1=[|snmp]
17:54:15.278578 IP poseidon.domain.net.2581 > cerbere.domain.net.snmp:  C=cerberemib GetNextRequest(30)  E:2021.55.2.1
17:54:15.318209 IP cerbere.domain.net.snmp > poseidon.domain.net.2581:  C=cerberemib GetResponse(57)  E:2021.55.2.2=[|snmp]
17:54:15.318572 IP poseidon.domain.net.2581 > cerbere.domain.net.snmp:  C=cerberemib GetNextRequest(30)  E:2021.55.2.2
17:54:15.358207 IP cerbere.domain.net.snmp > poseidon.domain.net.2581:  C=cerberemib GetResponse(49)  E:2021.55.2.3=[|snmp]
17:54:15.358550 IP poseidon.domain.net.2581 > cerbere.domain.net.snmp:  C=cerberemib GetNextRequest(30)  E:2021.55.2.3
17:54:15.398206 IP cerbere.domain.net.snmp > poseidon.domain.net.2581:  C=cerberemib GetResponse(59)  E:2021.55.2.4=[|snmp]
17:54:15.398558 IP poseidon.domain.net.2581 > cerbere.domain.net.snmp:  C=cerberemib GetNextRequest(30)  E:2021.55.2.4
17:54:15.438223 IP cerbere.domain.net.snmp > poseidon.domain.net.2581:  C=cerberemib GetResponse(33)  E:2021.55.3.1=69535
17:54:15.438590 IP poseidon.domain.net.2581 > cerbere.domain.net.snmp:  C=cerberemib GetNextRequest(30)  E:2021.55.3.1
17:54:15.478241 IP cerbere.domain.net.snmp > poseidon.domain.net.2581:  C=cerberemib GetResponse(31)  E:2021.55.3.2=0
17:54:15.478591 IP poseidon.domain.net.2581 > cerbere.domain.net.snmp:  C=cerberemib GetNextRequest(30)  E:2021.55.3.2
17:54:15.518235 IP cerbere.domain.net.snmp > poseidon.domain.net.2581:  C=cerberemib GetResponse(32)  E:2021.55.3.3=22848
17:54:15.518573 IP poseidon.domain.net.2581 > cerbere.domain.net.snmp:  C=cerberemib GetNextRequest(30)  E:2021.55.3.3
17:54:15.558240 IP cerbere.domain.net.snmp > poseidon.domain.net.2581:  C=cerberemib GetResponse(32)  E:2021.55.3.4=1242
17:54:15.558584 IP poseidon.domain.net.2581 > cerbere.domain.net.snmp:  C=cerberemib GetNextRequest(30)  E:2021.55.3.4
17:54:15.598234 IP cerbere.domain.net.snmp > poseidon.domain.net.2581:  C=cerberemib GetResponse(31)  E:2021.55.4.1=41
17:54:15.598571 IP poseidon.domain.net.2581 > cerbere.domain.net.snmp:  C=cerberemib GetNextRequest(30)  E:2021.55.4.1
17:54:15.638249 IP cerbere.domain.net.snmp > poseidon.domain.net.2581:  C=cerberemib GetResponse(31)  E:2021.55.4.2=0

... etc ... 

66 packets captured
66 packets received by filter
0 packets dropped by kernel


In DEVICE the machine is UP :
Cerbere BIND SNMP Up 192.168.1.249 1.5 2.6 100%


And for the poller in debug mode, i DEBUG -Statistics, ... in "Setting -> General -> Poller Specific Logging"
I click on my Machine in Device and the log show that :

Code: Select all

 07/17/2007 06:03:29 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
07/17/2007 06:03:29 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
07/17/2007 06:03:29 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
07/17/2007 06:03:29 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/17/2007 06:03:29 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_index from host_snmp_cache where host_id=44 and snmp_query_id=17 group by snmp_index"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_index from host_snmp_cache where host_id=44 and snmp_query_id=17"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=44) and (snmp_query_id=6))"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=44) and (snmp_query_id=2))"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=44) and (snmp_query_id=1))"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=44) and (snmp_query_id=9))"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=44) and (snmp_query_id=8))"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=44) and (snmp_query_id=7))"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=44) and (snmp_query_id=4))"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=44) and (snmp_query_id=3))"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=44) and (snmp_query_id=17))"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_query.id, snmp_query.name from snmp_query order by snmp_query.name"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_query.id, snmp_query.name, host_snmp_query.reindex_method from (snmp_query,host_snmp_query) where snmp_query.id=host_snmp_query.snmp_query_id and host_snmp_query.host_id=44 order by snmp_query.name"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from graph_local where graph_template_id=81 and host_id=44 limit 0,1"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=81 and host_id=44"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT graph_templates.id, graph_templates.name FROM snmp_query_graph RIGHT JOIN graph_templates ON (snmp_query_graph.graph_template_id = graph_templates.id) WHERE (((snmp_query_graph.name) Is Null)) ORDER BY graph_templates.name"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates.id, graph_templates.name from (graph_templates,host_graph) where graph_templates.id=host_graph.graph_template_id and host_graph.host_id=44 order by graph_templates.name"
07/17/2007 06:03:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id,name from host_template order by name" 
And this when i click in the graph :

Code: Select all

 07/17/2007 06:04:49 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
07/17/2007 06:04:49 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
07/17/2007 06:04:49 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
07/17/2007 06:04:49 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/17/2007 06:04:49 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/17/2007 06:04:49 PM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=-86400 --end=-300 --title="Cerbere BIND SNMP - 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 DEF:a="/data/www/cacti/rra/cerbere_bind_snmp_referral_1113.rrd":success:AVERAGE DEF:b="/data/www/cacti/rra/cerbere_bind_snmp_referral_1113.rrd":failure:AVERAGE DEF:c="/data/www/cacti/rra/cerbere_bind_snmp_referral_1113.rrd":nxdomain:AVERAGE CDEF:cdefa=a,300,* CDEF:cdefe=b,300,* CDEF:cdefi=c,300,* LINE1:cdefa#00CF00:"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#FF0000:"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#FF6044:"NXDOMAIN Queries" GPRINT:cdefi:LAST:" Current\:%8.2lf%s" GPRINT:cdefi:AVERAGE:"Average\:%8.2lf%s" GPRINT:cdefi:MAX:"Maximum\:%8.2lf%s\n"
Rossco
Cacti User
Posts: 76
Joined: Sat Jan 15, 2005 4:52 pm
Location: London, England

Post by Rossco »

Hi Maillon

The packet capture looks good - I'm assuming that this was the cacti machine that was polling and not a snmpwalk you did yourself?

With regards to the logs, we need to see the output of the poller logging for this specific host, so you may have to wait for your polling period/cron job to have occured, then check your logs and copy out the relevent entries.

Cheers

Rossco
gaansch
Posts: 7
Joined: Wed Jul 18, 2007 2:42 am

Post by gaansch »

Hi,

i've got a little problem with the script. I followed the install instructions but I don't get any results via snmp.

I've tried to find the failure. It seems that the snmp daemon doesn't pass the request to the perl script.

I uncommented the line

Code: Select all

`echo "Called snmpd handler: @ARGV">>/var/log/bind9-stats.log`;
so every call on the perl script will be logged. If I execute it manually it works fine but if I perform a snmpwalk on the OID there's no logging entry.

I reckon there is a problem with the net-snmp pass function.

If it helps, server is running:

Debian Etch

Code: Select all

# dpkg -l | grep snmp
ii  libnet-snmp-perl         5.2.0-1                         Script SNMP connections
ii  libsnmp-base             5.2.3-7                         NET SNMP (Simple Network Management Protocol
ii  libsnmp-perl             5.2.3-7                         NET SNMP (Simple Network Management Protocol
ii  libsnmp9                 5.2.3-7                         NET SNMP (Simple Network Management Protocol
ii  snmp                     5.2.3-7                         NET SNMP (Simple Network Management Protocol
ii  snmpd                    5.2.3-7                         NET SNMP (Simple Network Management Protocol
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests