Device has Status Unknown

vuvuzela · Post by **vuvuzela** » Thu Jul 15, 2010 7:05 am

Hello,

I want to make use of cacti's 64-bit counters, because I have to monitor ATM-Interfaces with 155 mbit/s. But whatever I try, this new device stays in 'Status Unknown'. For reference I added a different device, which successfully reaches 'Status Up' and creates graphs, so my Debian cacti 0.8.7e-4 installation should work generally.

I guess one reason is, that the rrd isn't created. I do not find it in the path of the Data Source Debug:

/usr/bin/rrdtool create \
/var/lib/cacti/rra/erx2_traffic_in_20.rrd \
--step 300 \
DS:traffic_in:COUNTER:600:0:100000000 \
DS:traffic_out:COUNTER:600:0:100000000 \
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:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \

So the Graph Debug Mode says consequently "No such file or directory
":
RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="erx2 - Traffic - AT2/3" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/var/lib/cacti/rra/erx2_traffic_in_20.rrd":traffic_in:AVERAGE \
DEF:b="/var/lib/cacti/rra/erx2_traffic_in_20.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefe=b,8,* \
AREA:cdefa#00CF00FF:"Inbound" \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefe#002A97FF:"Outbound" \
GPRINT:cdefe:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s\n"

RRDTool Says:

ERROR: opening '/var/lib/cacti/rra/erx2_traffic_in_20.rrd': No such file or directory

But it should not be a permission problem, because my other reference device is created without any problems and the right permissions:
-rw-r--r-- 1 www-data www-data 94668 Jul 15 13:15 ua_hamm_traffic_in_16.rrd

And it shouldn't be snmp related, because I get the SNMP Information output in the upper left corner of the Devices-window. Further the Data Query [SNMP-Interface Statistics] has generated the list of ca. 15070(!) interfaces. I selected one of the ATM-interfaces, chose In/Out Bits (64-bit Counters) and klicked create, which seemed to be successful at this point "+ Created graph:erx2 - Traffic - AT2/3".

But the entries in the Data Source window seem to be wrong IMHO:

Output Type ID: Data query data sources must be created through New Graphs.
Index Value: A blank field!
Index Type: Data query data sources must be created through New Graphs.

I would have expected the interface-index (or a OID) in the Index Value field and not being empty/blank.

And aren't the Maximum Values for traffic_in and traffic_out not wrong being 100000000 and not 155000000 (for stm-1 ATM)?

I have no idea, why I am not able to collect the 64-bit counter with cacti, because with a plain snmpget I receive values:
snmpget -v 2c -c <my-community> <my-host> .1.3.6.1.2.1.31.1.1.1.6.150994948
IF-MIB::ifHCInOctets.150994948 = Counter64: 4986291805771

Please help, it is my first post in this forum and cacti seems to be so promising.

Kind regards,
oz

vuvuzela · Post by **vuvuzela** » Sun Jul 18, 2010 2:52 am

Hi,

it seems, nobody in this forum has faced the problem before. I consider it to be an unknown bug in cacti version 0.8.7e-4 of my linux-distri, because I can't see any reason, why the .rrd is not created from the snmp indexed interface. While it can be created from commandline (as user www-data), but obviously not from the web-gui.

/usr/bin/rrdtool create \
/var/lib/cacti/rra/erx2_traffic_in_26.rrd \
--step 300 \
DS:traffic_in:COUNTER:600:0:100000000 \
DS:traffic_out:COUNTER:600:0:100000000 \
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:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \

- oz

mcutting · Post by **mcutting** » Mon Jul 19, 2010 2:11 am

Erm, no.

Check to see what sort of uptime detection you are using for this host.

vuvuzela · Post by **vuvuzela** » Mon Jul 19, 2010 3:00 am

@mcutting: I have Downed Device Detection set to the default 'SNMP' and I see SNMP Information of that device on the top of that page, so it should be ok. The Availability of that device is shown with 100(%).

Now I tried a fresh install of 0.8.7g from cacti-0.8.7g.tar.gz on a Debian/lenny. Puh, hard work, the installation manual is not good - but that's another subject. The result is disappointing, the Localhost graphs were created, but the device, that is most important to me, has still 'Status Unknown' and its rra is NOT created.
In the Data Sources window of that device the Custom Data fields are still empty, as described in my first post. Why? I searched my SNMP cache for the interface index, that I want to monitor, these are the results:

Host: erx2 , SNMP Query: SNMP - Interface Statistics
Index: 150994948 , Field Name: ifAlias , Field Value:
OID: .1.3.6.1.2.1.31.1.1.1.18.150994948
Host: erx2 , SNMP Query: SNMP - Interface Statistics
Index: 150994948 , Field Name: ifDescr , Field Value: ATM2/3
OID: .1.3.6.1.2.1.2.2.1.2.150994948
Host: erx2 , SNMP Query: SNMP - Interface Statistics
Index: 150994948 , Field Name: ifHwAddr , Field Value:
OID: .1.3.6.1.2.1.2.2.1.6.150994948
Host: erx2 , SNMP Query: SNMP - Interface Statistics
Index: 150994948 , Field Name: ifIndex , Field Value: 150994948
OID: .1.3.6.1.2.1.2.2.1.1.150994948
Host: erx2 , SNMP Query: SNMP - Interface Statistics
Index: 150994948 , Field Name: ifName , Field Value: AT2/3
OID: .1.3.6.1.2.1.31.1.1.1.1.150994948
Host: erx2 , SNMP Query: SNMP - Interface Statistics
Index: 150994948 , Field Name: ifOperStatus , Field Value: Up
OID: .1.3.6.1.2.1.2.2.1.8.150994948
Host: erx2 , SNMP Query: SNMP - Interface Statistics
Index: 150994948 , Field Name: ifSpeed , Field Value: 155520000
OID: .1.3.6.1.2.1.2.2.1.5.150994948
Host: erx2 , SNMP Query: SNMP - Interface Statistics
Index: 150994948 , Field Name: ifType , Field Value: atm(37)
OID: .1.3.6.1.2.1.2.2.1.3.150994948

... that looks ok for me or is there something missing? Is it normal, that the 64-bit counter is not listed in the SNMP Cache? For example .1.3.6.1.2.1.31.1.1.1.6.150994948 or MIB-translated IF-MIB::ifHCInOctets.150994948 = Counter64?

The cacti.log is not showing errors:
07/19/2010 09:25:01 AM - SYSTEM STATS: Time:0.3994 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:5 RRDsProcessed:5
07/19/2010 09:20:02 AM - SYSTEM STATS: Time:0.3957 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:5 RRDsProcessed:5
[...]
... but I have 6 DataSources and not 5, one has the rra not created.

I'm near the point to give up and thinking cacti is useless for me. Is there anything else I can try to graph the 64-bit counters from an SNMP Indexed interface? Is it possible at all? Do any success-stories exist?

Sorry, my english is lousy.

Greetings

vuvuzela · Post by **vuvuzela** » Wed Jul 21, 2010 2:52 am

Anybody?

vuvuzela · Post by **vuvuzela** » Wed Jul 21, 2010 7:32 am

To make the problem more clear, I made two screenshots to compare the data source of a device with Status UP and the device with Status Unknown (both devices are monitored from my cacti 0.8.7g server).

In the first picture everything is ok, the rra of that device is created with the first polling cycle and the graph is drawn).

In the second picture you can see the entries of the device, that never creates a rra. Do you notice, that the 'Index Value' is empty? Is this the reason, why the initial rra is never populated?

But these Custom Data fields should be populated at the moment I select the interface from the interface statistics table and click create graph. What goes wrong in this transformation? - I tried 64-bit In/Out Bits with SNMP v2 and also standard In/Out Bits with SNMP v1, but never receive a correct looking data sources of that special device and my assumption is, that therefore no rra is created and the Status of that device remains 'Unknown'.

Any chance to debug, what fails in the moment, when create graph is clicked for that interface?

Pableus · Post by **Pableus** » Wed Jul 21, 2010 4:37 pm

Â¡I've got the same problem!
My Cacti says "status Unknown" for all the devices except for localhost and I have the same message "No such file or directory" about the .rrd files. I checked the rra folder and the .rrd files are missing.

vuvuzela · Post by **vuvuzela** » Thu Jul 22, 2010 10:25 am

@Pableus: But your problem seems to be of another kind. I have the problem of 'Status Unknown' just with one of my devices, not with every device.

What I do not understand is, that the maximum speeds of the interface of 155520000 (bit/s) obviously were picked up from the according Data Query [SNMP - Interface Statistics]:

Index 150994948
Status Up
Description ATM2/3
Name(IF-MIB) AT2/3
Alias(IF-MIB)
Type atm(37)
Speed 155520000
Hardware Address
IP Address

... but the Output Type ID, Index Value and Index Type were not. I would have expected them to have values like In/Out Bits, 150994948 and ifIndex. What goes wrong there?

It would be nice, if a developer could chime in.

Thanks

Post by **gandalf** » Thu Jul 22, 2010 1:58 pm

Your description is quite correct.
Are you sure, that the device does report MIB2 64 bit COUNTER values? Did you run snmpwalk once against that device?
There is no obvious reason (to me) why this does not work.
R.

vuvuzela · Post by **vuvuzela** » Thu Jul 22, 2010 2:45 pm

[quote="gandalf"]Your description is quite correct.
Are you sure, that the device does report MIB2 64 bit COUNTER values? Did you run snmpwalk once against that device?
There is no obvious reason (to me) why this does not work.
R.[/quote]

Hallo gandalf,

thanks for reading. I checked it several times and always get values from the counter:

# snmpget -v 2c -c <my-community> <my-device> .1.3.6.1.2.1.31.1.1.1.6.150994948
IF-MIB::ifHCInOctets.150994948 = Counter64: 5633139891520
# snmpget -v 2c -c <my-community> <my-device> .1.3.6.1.2.1.31.1.1.1.6.150994948
IF-MIB::ifHCInOctets.150994948 = Counter64: 5633146300177
# snmpget -v 2c -c <my-community> <my-device> .1.3.6.1.2.1.31.1.1.1.6.150994948
IF-MIB::ifHCInOctets.150994948 = Counter64: 5633149359802

As you can see, the counter increases. I can do the same command with snmpwalk and snmpbulkwalk and both work.

If you mean with 'snmpwalk' the Data Query of all interfaces - yes, I repeated that several times and it always echoes Success:

1) SNMP - Interface Statistics (Verbose Query) Uptime Goes Backwards Success [113815 Items, 14484 Rows]

However it is a Juniper erx and has thousands of interfaces, so it always lasts several minutes. Are that too much Items and rows, is there a bottleneck somewhere? The other device, that has no problems has a far smaller interface table --> Success [346 Items, 50 Rows]. But this is just speculation, I have no implication for that.

Thanks,
oz

Post by **gandalf** » Thu Jul 22, 2010 2:53 pm

vuvuzela wrote:However it is a Juniper erx and has thousands of interfaces, so it always lasts several minutes. Are that too much Items and rows, is there a bottleneck somewhere? The other device, that has no problems has a far smaller interface table --> Success [346 Items, 50 Rows]. But this is just speculation, I have no implication for that.

That might happen. What are you bulkwalk settings for that device?
R.

Hold on. I missed the topic. Your device still has "unkown" status? Please run a "spine --verbosity=5 <id> <id>", where <id> represents the id of that system. Please delete credentials and superfluous SNMP* request/results. I'm interested most in the "header" lines before the target is queried.
R.

vuvuzela · Post by **vuvuzela** » Thu Jul 22, 2010 3:01 pm

I guess you mean the devices SNMP Option:

Maximum OID's Per Get Request
Specified the number of OID's that can be obtained in a single SNMP Get request.

It has the default 10.

vuvuzela · Post by **vuvuzela** » Thu Jul 22, 2010 4:55 pm

To your second question, gandalf.

I have no spine on my 0.8.7g source install, but I use a little workaround and hope it is ok. I fetched the cacti-spine_0.8.7a-2.3_i386.deb for my Debian/lenny and extracted just the spine binary. Because it requires a spine.conf, I created a /etc/cacti/spine.conf with ...

DB_Host localhost
DB_Database cacti
DB_User <my-user>
DB_Pass <my-pass>

... to be able to the command you suggested: 'spine --verbosity=5 2 2'

After that the device changed from Status Unknown to Status UP (uh !!!!?). But alas the rest of the situation remains the same. I tried deletion and recreation of the graph with no success ;-(.

Here ist the output of the single spine command (sorry, it is complete):

./spine --verbosity=5 2 2
SPINE: Using spine config file [/etc/cacti/spine.conf]
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_webroot''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_cactilog''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The path_php_server variable is /usr/local/src/cacti-0.8.7g/script_server.php
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The path_cactilog variable is /usr/local/src/cacti-0.8.7g/log/cacti.log
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_destination''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The log_destination variable is 1 (FILE)
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_php_binary''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The path_php variable is /usr/bin/php
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'availability_method''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The availability_method variable is 0
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_recovery_count''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 0
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_failure_count''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 0
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_method''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The ping_method variable is 0
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_retries''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The ping_retries variable is 0
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_timeout''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 0
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_perror''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pwarn''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 0
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pstats''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The log_pstats variable is 0
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_threads''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The threads variable is 5
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'poller_interval''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The polling interval is the system default
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'concurrent_processes''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 1
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'script_timeout''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The script timeout is 25
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'php_servers''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 2
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT action FROM poller_item WHERE action=2 AND host_id BETWEEN 2 AND 2 LIMIT 1'
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: StartHost='2', EndHost='2', TotalPHPScripts='0'
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The PHP Script Server is Not Required
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_get_size''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 25
07/22/2010 11:02:06 PM - SPINE: Poller[0] Version 0.8.7b starting
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: MySQL is Thread Safe!
07/22/2010 11:02:06 PM - SPINE: Poller[0] SPINE: Initializing Net-SNMP API
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SNMP Header Version is 5.4.1
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SNMP Library Version is 5.4.1
07/22/2010 11:02:06 PM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(s)
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT id FROM host WHERE disabled='' AND id BETWEEN 2 AND 2 ORDER BY id'
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: Initial Value of Active Threads is 0
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT snmp_port, count(snmp_port) FROM poller_item WHERE host_id=0 GROUP BY snmp_port'
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT action, hostname, snmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path, arg1, arg2, arg3, local_data_id, rrd_num, snmp_port, snmp_timeout, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context FROM poller_item WHERE host_id=0 ORDER BY snmp_port'
07/22/2010 11:02:06 PM - SPINE: Poller[0] Host[0] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT id, hostname, snmp_community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, snmp_port, snmp_timeout, max_oids, availability_method, ping_method, ping_port, ping_timeout, ping_retries, status, status_event_count, status_fail_date, status_rec_date, status_last_error, min_time, max_time, cur_time, avg_time, total_polls, failed_polls, availability FROM host WHERE id=2'
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 2
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
07/22/2010 11:02:06 PM - SPINE: Poller[0] Host[2] SNMP Result: Host responded to SNMP
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'UPDATE host SET status='3', status_event_count='0', status_fail_date='0000-00-00 00:00:00', status_rec_date='0000-00-00 00:00:00', status_last_error='', min_time='4.529950', max_time='11.800050', cur_time='4.529950', avg_time='7.013003', total_polls='3', failed_polls='0', availability='100.0000' WHERE id='2''
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT data_query_id, action, op, assert_value, arg1 FROM poller_reindex WHERE host_id=2'
07/22/2010 11:02:06 PM - SPINE: Poller[0] Host[2] Host has no information for recache.
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT snmp_port, count(snmp_port) FROM poller_item WHERE host_id=2 GROUP BY snmp_port'
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT action, hostname, snmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path, arg1, arg2, arg3, local_data_id, rrd_num, snmp_port, snmp_timeout, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context FROM poller_item WHERE host_id=2 ORDER BY snmp_port'
07/22/2010 11:02:06 PM - SPINE: Poller[0] Host[2] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'replace into settings (name,value) values ('date',NOW())'
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: SQL:'insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())'
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: Thread Cleanup Complete
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: PHP Script Server Pipes Closed
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: Allocated Variable Memory Freed
07/22/2010 11:02:06 PM - SPINE: Poller[0] SPINE: Net-SNMP API Shutdown Completed
07/22/2010 11:02:06 PM - SPINE: Poller[0] DEBUG: MYSQL Free & Close Completed
07/22/2010 11:02:06 PM - SPINE: Poller[0] Time: 0.0786 s, Threads: 5, Hosts: 2

Greets

vuvuzela · Post by **vuvuzela** » Thu Jul 22, 2010 6:40 pm

... I don't know, if it makes a big difference - but I compiled now the version 0.8.7g of spine and repeated your suggested command:

# ./spine --verbosity=5 2 2
SPINE: Using spine config file [../etc/spine.conf]
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The path_php_server variable is /usr/local/src/cacti-0.8.7g/script_server.php
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The path_cactilog variable is /usr/local/src/cacti-0.8.7g/log/cacti.log
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The log_destination variable is 1 (FILE)
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The path_php variable is /usr/bin/php
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The availability_method variable is 0
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 0
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 0
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The ping_method variable is 0
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The ping_retries variable is 0
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 0
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The snmp_retries variable is 3
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 0
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The boost_redirect variable is 0
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The log_pstats variable is 0
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The threads variable is 5
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The polling interval is the system default
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 1
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The script timeout is 25
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 2
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: StartHost='2', EndHost='2', TotalPHPScripts='0'
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The PHP Script Server is Not Required
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 25
07/23/2010 01:34:59 AM - SPINE: Poller[0] Version 0.8.7g starting
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: MySQL is Thread Safe!
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: Spine is running asroot.
07/23/2010 01:34:59 AM - SPINE: Poller[0] SPINE: Initializing Net-SNMP API
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: Issues with SNMP Header Version information, assuming old version of Net-SNMP.
07/23/2010 01:34:59 AM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(s)
07/23/2010 01:34:59 AM - SPINE: Poller[0] NOTE: Spine did not detect multithreaded device polling.
07/23/2010 01:34:59 AM - SPINE: Poller[0] NOTE: Spine is behaving in a 0.8.7g manner
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: Initial Value of Active Threads is 0
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
07/23/2010 01:34:59 AM - SPINE: Poller[0] Host[0] TH[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is -1
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
07/23/2010 01:34:59 AM - SPINE: Poller[0] Host[2] SNMP Result: Host responded to SNMP
07/23/2010 01:34:59 AM - SPINE: Poller[0] Host[2] TH[1] Host has no information for recache.
07/23/2010 01:34:59 AM - SPINE: Poller[0] Host[2] TH[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: Thread Cleanup Complete
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: PHP Script Server Pipes Closed
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: Allocated Variable Memory Freed
07/23/2010 01:34:59 AM - SPINE: Poller[0] DEBUG: MYSQL Free & Close Completed
07/23/2010 01:34:59 AM - SPINE: Poller[0] Time: 0.0867 s, Threads: 5, Hosts: 2

Kind regards

vuvuzela · Post by **vuvuzela** » Fri Jul 23, 2010 7:20 am

Another observation, not sure, if it has any relevance. For debugging I clicked on '(Verbose Query)' in the Interface Statistics query. I receive NO debugging infos as expected, the browser tab just says "Loading ..." with a spinning symbol and the status line of the browser says "Waiting for <my-cacti-server> ..."

I'm quite sure that this loading goes ad infinitum. However no reason to worry, I guess, because the same behavior I have doing 'Reload Data Query' or when the snmpcache is filled the first time. When I open another tab after an hour or so, the data-query always seems to have been successful in the background --> Success [111589 Items, 16239 Rows]. These updated last values are from the mentioned Verbose-Query run.

Device has Status Unknown

Device has Status Unknown

Who is online