pooler is runnig. folder permission ok. but graph is empty

[yccheok]

I ensure my pooler is running.

Code: Select all

tail -f /var/log/cacti/cacti.log

06/30/2009 04:00:03 AM - SYSTEM STATS: Time:2.0192 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:0
06/30/2009 04:05:04 AM - SYSTEM STATS: Time:2.0215 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:0
06/30/2009 04:10:03 AM - SYSTEM STATS: Time:2.0202 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:6 RRDsProcessed:0

I ensure my folders permission are OK.

Code: Select all

yanchengclean:/tmp/cacti-0.8.7e# ls -al /var/log/cacti
total 192
drwxr-xr-x 2 cactiuser www-data   4096 Jun 30 03:48 .
drwxr-xr-x 8 root      root       4096 Jun 30 03:13 ..
-rw-r----- 1 cactiuser www-data 181856 Jun 30 04:55 cacti.log
-rw-r--r-- 1 cactiuser www-data      0 Jun 30 03:45 poller-error.log
-rw-r----- 1 cactiuser www-data      0 Jun 29 03:52 rrd.log
yanchengclean:/tmp/cacti-0.8.7e# ls -al /var/lib/cacti/rra
total 344
drwxrwx--- 2 cactiuser www-data   4096 Jun 30 03:50 .
drwxr-xr-x 3 cactiuser root       4096 Jun 29 03:43 ..
-rw-r--r-- 1 cactiuser www-data 141488 Jun 30 03:20 localhost_load_1min_5.rrd
-rw-r--r-- 1 cactiuser www-data  47840 Jun 30 03:20 localhost_mem_buffers_3.rrd
-rw-r--r-- 1 cactiuser www-data  47840 Jun 30 03:20 localhost_mem_swap_4.rrd
-rw-r--r-- 1 cactiuser www-data  47840 Jun 30 03:20 localhost_proc_7.rrd
-rw-r--r-- 1 cactiuser www-data  47840 Jun 30 03:20 localhost_users_6.rrd
yanchengclean:/tmp/cacti-0.8.7e#

If you compare timestamp for localhost_load_1min_5.rrd and cacti.log, localhost_load_1min_5.rrd is not being updated at all.

May I know what else I need to look into it?

I further turn the logging mode even to DEBUG:

Code: Select all

cactiuser@yanchengclean:/$ php /usr/share/cacti/site/poller.php
07/01/2009 02:54:58 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /usr/share/cacti/site/cmd.php 0 1]
Waiting on 1/1 pollers.
07/01/2009 02:55:00 AM - SYSTEM STATS: Time:2.0252 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:14 RRDsProcessed:0
cactiuser@yanchengclean:/$

Is the poller running correctly? Is this what the output should be?

[TheWitness]

Is your path to RRDtool working? Is RRDtool segfaulting on you? If you run the following from the commandline you should see a series of "OK"'s.

Code: Select all

php -q poller.php --force

TheWitness

[yccheok]

I try your advice :

Code: Select all

yanchengclean:/# su cactiuser


cactiuser@yanchengclean:/$ php /usr/share/cacti/site/poller.php
07/02/2009 07:18:37 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /usr/share/cacti/site/cmd.php 0 1]
Waiting on 1/1 pollers.
07/02/2009 07:18:39 AM - SYSTEM STATS: Time:2.0267 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:14 RRDsProcessed:0


cactiuser@yanchengclean:/$ php -q /usr/share/cacti/site/poller.php --force
07/02/2009 07:18:48 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /usr/share/cacti/site/cmd.php 0 1]
Waiting on 1/1 pollers.
07/02/2009 07:18:51 AM - SYSTEM STATS: Time:2.0248 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:14 RRDsProcessed:0


cactiuser@yanchengclean:/$ vi /var/log/cacti/cacti.log

When I check the log file, I get the following message :

Code: Select all

07/02/2009 07:18:37 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
07/02/2009 07:18:37 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
07/02/2009 07:18:37 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','/usr/share/cacti/site')"
07/02/2009 07:18:37 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
07/02/2009 07:18:37 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /usr/share/cacti/site/cmd.php 0 1]
07/02/2009 07:18:37 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from host where (disabled = '' and id >= 0 and id <= 1) ORDER by id"
07/02/2009 07:18:37 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * from poller_item WHERE (host_id >= 0 and host_id <= 1) ORDER by host_id"
07/02/2009 07:18:37 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) from poller_item WHERE (action=2 AND (host_id >= 0 and host_id <= 1))"
07/02/2009 07:18:38 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
07/02/2009 07:18:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
07/02/2009 07:18:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  LIMIT 10000"
07/02/2009 07:18:38 AM - CMDPHP: Poller[0] Host[1] SNMP: Host did not respond to SNMP
07/02/2009 07:18:38 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set  status = '1',  status_event_count = '479',  status_fail_date = '2009-06-30 03:25:02',  status_rec_date = '0000-00-00 00:00:00',  status_last_error = 'Host did not respond to SNMP',  min_time = '0.04000',  max_time = '0.06000',  cur_time = '0.04000',  avg_time = '0.05000',  total_polls = '481',  failed_polls = '479',  availability = '0.4158004158'  where hostname = '127.0.0.1'"

Seem like my SNMP server is not running properly? How can I start my SNMP server?

[TheWitness]

Google this site for snmp.conf.

TheWitness

[bhav]

i have the following error in my cacti..

"This data query returned 0 rows, perhaps there was a problem executing this data query. You can run this data query in debug mode to get more information."

the picture that is suppose to appear is shown on pic 1
the picture that is currently appearing on my screen is shown on pic 2

what am i supposed to do?

[BSOD2600]

bhav: your issue is different from the OP. Start your own thread after reading http://docs.cacti.net/manual:087:4_help ... #debugging.