No Data in Graph

smite · Post by **smite** » Tue Jan 29, 2008 6:04 am

Hello, I´m a German user of cacti.
I have got a few problems with the Software. I downloaded cacti and installed it on my lokal pc with xampp an Windows XP Professional.
But I have 2 problems.
My first Problem is, when I create or edit a host and will change the Host template, I geht an error:

Code: Select all

Notice: Undefined variable: snmp_auth in C:\xampp\htdocs\cacti\lib\snmp.php on line 317

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\cacti\lib\snmp.php:317) in C:\xampp\htdocs\cacti\host.php on line 162

My second Problem is, I have only Graphes without any Data:

My cacti log is

The poller is running. I used the cmd.php poller and the spine.
The poller is running all 5 minutes and I have got *.rrd files in the rra directory. The *.rrd file are upgrading every 5 minutes.

Here are a few pictures:

Debug poller cmd.php

Debug RRD Tool:

The spine poller says this:

Code: Select all

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

H:\>c:

C:\>cd C:\xampp\htdocs\cacti\spine

C:\xampp\htdocs\cacti\spine>spine
SPINE: Using spine config file [spine.conf]
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'path_webroot''
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'path_cactilog''
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: The path_php_server variable is
 c:/xampp/htdocs/cacti/script_server.php
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: The path_cactilog variable is c
:/xampp/htdocs/cacti/log/cacti.log
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'log_destination''
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: The log_destination variable is
 1 (FILE)
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'path_php_binary''
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: The path_php variable is c:/xam
pp/php/php.exe
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'availability_method''
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: The availability_method variabl
e is 1
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'ping_recovery_count''
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: The ping_recovery_count variabl
e is 3
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'ping_failure_count''
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: The ping_failure_count variable
 is 2
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'ping_method''
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: The ping_method variable is 3
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'ping_retries''
01/29/2008 09:39:41 AM - SPINE: Poller[0] DEBUG: The ping_retries variable is 1
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'ping_timeout''
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 40
0
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'log_perror''
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'log_pwarn''
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 1
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'log_pstats''
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The log_pstats variable is 1
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'max_threads''
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The threads variable is 1
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'poller_interval''
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The polling interval is 300 sec
onds
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'concurrent_processes''
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The number of concurrent proces
ses is 1
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'script_timeout''
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The script timeout is 25
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'php_servers''
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The number of php script server
s to run is 1
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT action FROM poller_
item WHERE action=2 LIMIT 1'
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: StartHost='-1', EndHost='-1', T
otalPHPScripts='0'
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The PHP Script Server is Not Re
quired
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings
 WHERE name = 'max_get_size''
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size i
s 10
01/29/2008 09:39:42 AM - SPINE: Poller[0] Version 0.8.7a starting
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: MySQL is Thread Safe!
01/29/2008 09:39:42 AM - SPINE: Poller[0] SPINE: Initializing Net-SNMP API
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: Issues with SNMP Header Version
 information, assuming old version of Net-SNMP.
01/29/2008 09:39:42 AM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(
s)
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT id FROM host WHERE
disabled='' ORDER BY id'
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: Initial Value of Active Threads
 is 0
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polli
ng of Host
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is
1
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT snmp_port, count(sn
mp_port) FROM poller_item WHERE host_id=0 AND rrd_next_step < 0 GROUP BY snmp_po
rt'
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT action, hostname, s
nmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path, a
rg1, arg2, arg3, local_data_id, rrd_num, snmp_port, snmp_timeout, snmp_auth_prot
ocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context  FROM poller_item W
HERE host_id=0 and rrd_next_step <=0 ORDER by snmp_port'
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd
_next_step=rrd_next_step-300 WHERE host_id=0'
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd
_next_step=rrd_step-300 WHERE rrd_next_step < 0 and host_id=0'
01/29/2008 09:39:42 AM - SPINE: Poller[0] Host[0] DEBUG: HOST COMPLETE: About to
 Exit Host Polling Thread Function
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is
0
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polli
ng of Host
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is
1
01/29/2008 09:39:42 AM - 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, s
tatus, 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=1'
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: UDP Ping return_code was -1, er
rno was 104, total_time was 999.9275
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: UDP Ping return_code was -1, er
rno was 104, total_time was 0.0000
01/29/2008 09:39:42 AM - SPINE: Poller[0] Host[1] PING Result: UDP: Ping timed o
ut
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE host SET status='1'
, status_event_count='4', status_fail_date='2008-01-29 09:35:00', status_rec_dat
e='0000-00-00 00:00:00', status_last_error='UDP: Ping timed out', min_time='0.00
0000', max_time='9.999990', cur_time='0.540000', avg_time='0.581430', total_poll
s='165', failed_polls='4', availability='97.5758' WHERE id='1''
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT snmp_port, count(sn
mp_port) FROM poller_item WHERE host_id=1 AND rrd_next_step < 0 GROUP BY snmp_po
rt'
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT action, hostname, s
nmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path, a
rg1, arg2, arg3, local_data_id, rrd_num, snmp_port, snmp_timeout, snmp_auth_prot
ocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context  FROM poller_item W
HERE host_id=1 and rrd_next_step <=0 ORDER by snmp_port'
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd
_next_step=rrd_next_step-300 WHERE host_id=1'
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd
_next_step=rrd_step-300 WHERE rrd_next_step < 0 and host_id=1'
01/29/2008 09:39:42 AM - SPINE: Poller[0] Host[1] DEBUG: HOST COMPLETE: About to
 Exit Host Polling Thread Function
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is
0
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polli
ng of Host
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is
1
01/29/2008 09:39:42 AM - 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, s
tatus, 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=5'
01/29/2008 09:39:42 AM - SPINE: Poller[0] Host[5] No Host Availability Method Se
lected
01/29/2008 09:39:42 AM - 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_dat
e='2008-01-28 13:54:50', status_last_error='TCP ping timed out', min_time='0.000
000', max_time='0.000000', cur_time='0.000000', avg_time='0.000000', total_polls
='51', failed_polls='4', availability='92.1569' WHERE id='5''
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT data_query_id, acti
on, op, assert_value, arg1 FROM poller_reindex WHERE host_id=5'
01/29/2008 09:39:42 AM - SPINE: Poller[0] Host[5] Host has no information for re
cache.
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT snmp_port, count(sn
mp_port) FROM poller_item WHERE host_id=5 AND rrd_next_step < 0 GROUP BY snmp_po
rt'
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT action, hostname, s
nmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path, a
rg1, arg2, arg3, local_data_id, rrd_num, snmp_port, snmp_timeout, snmp_auth_prot
ocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context  FROM poller_item W
HERE host_id=5 and rrd_next_step <=0 ORDER by snmp_port'
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd
_next_step=rrd_next_step-300 WHERE host_id=5'
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd
_next_step=rrd_step-300 WHERE rrd_next_step < 0 and host_id=5'
01/29/2008 09:39:42 AM - SPINE: Poller[0] Host[5] DEBUG: The POPEN returned the
following File Descriptor 6
/bin/sh: perl: command not found
01/29/2008 09:39:42 AM - SPINE: Poller[0] Host[5] ERROR: Empty result [192.168.1
00.207]: 'perl C:/xampp/htdocs/cacti/scripts/ping.pl 192.168.100.207'
01/29/2008 09:39:42 AM - SPINE: Poller[0] Host[5] DS[11] WARNING: Result from SC
RIPT not valid. Partial Result: ...
01/29/2008 09:39:42 AM - SPINE: Poller[0] Host[5] DS[11] SCRIPT: perl C:/xampp/h
tdocs/cacti/scripts/ping.pl 192.168.100.207, output: U
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: SQL:'INSERT INTO poller_output
(local_data_id, rrd_name, time, output) VALUES (11,'ping','2008-01-29 09:39:42',
'U')'
01/29/2008 09:39:42 AM - SPINE: Poller[0] Host[5] DEBUG: HOST COMPLETE: About to
 Exit Host Polling Thread Function
01/29/2008 09:39:42 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is
0
01/29/2008 09:39:43 AM - SPINE: Poller[0] DEBUG: SQL:'replace into settings (nam
e,value) values ('date',NOW())'
01/29/2008 09:39:43 AM - SPINE: Poller[0] DEBUG: SQL:'insert into poller_time (p
oller_id, start_time, end_time) values (0, NOW(), NOW())'
01/29/2008 09:39:43 AM - SPINE: Poller[0] DEBUG: Thread Cleanup Complete
01/29/2008 09:39:43 AM - SPINE: Poller[0] DEBUG: PHP Script Server Pipes Closed
01/29/2008 09:39:43 AM - SPINE: Poller[0] DEBUG: Allocated Variable Memory Freed

01/29/2008 09:39:43 AM - SPINE: Poller[0] SPINE: Net-SNMP API Shutdown Completed

01/29/2008 09:39:43 AM - SPINE: Poller[0] DEBUG: MYSQL Free & Close Completed
01/29/2008 09:39:43 AM - SPINE: Poller[0] Time: 1.1280 s, Threads: 1, Hosts: 3

My logfile is here: http://bene1990.be.funpic.de/sonstiges/cacti/cacti.zip

I know that my English isn´t very well, because I´m a german pupil. But I hope you can help me with my prolems.
Greetings smite

BSOD2600 · Post by **BSOD2600** » Tue Jan 29, 2008 3:15 pm

1) read my installation guide in my signature.
2) read http://forums.cacti.net/viewtopic.php?t=11747
3) those default graphs are for LINUX systems, which is why they don't work on windows.
4) I wouldnt suggest switching to spine until your cacti installation is fully functional.

smite · Post by **smite** » Tue Jan 29, 2008 4:12 pm

Thank you four your answer.
How can I change the graph, that it is a graph for windows pcs? Must I change the host template? Because when I change the host template, I get an error.
I read you links, but I can be that I get something from, because I´m german.
Greetings smite

BSOD2600 · Post by **BSOD2600** » Tue Jan 29, 2008 7:16 pm

Delete that host and associated graphs.

Create a new one using the Windows host template. Re-create your graphs.

smite · Post by **smite** » Wed Jan 30, 2008 3:26 am

When I will add a host, I get an error in file \lib\snmp.php, because undefinied variable.
Because that I add these to lines in my code:

$temp_array=0;
$snmp_auth=0;

But when the poller is running I doesn´t get some *.rrd files in my rra directory.
What does I do wrong?
Greetings smite

BSOD2600 · Post by **BSOD2600** » Wed Jan 30, 2008 2:43 pm

You MUST re-read my installation guide since you have missed critual steps on the setup. Your NTFS permissions are not correct, which is why you're getting that error in snmp.php.

Read through the documentation site on how to properly make scripts/templates.

Cacti

No Data in Graph

No Data in Graph

Who is online