Poller.php times out?

[ernestcashstar]

When I run poller.php through the command prompt to see if its working correcly it pops up another window quickly and closes it and the primary window just sits there until the call to poller.php times out with a timeout message.

Not sure what to do now?

[BSOD2600]

1) read the README sticky
2) probably a user rights problem. Run: php poller.php under an admin account; does it work (i.e. is the log file updated along with the rrd files) ?

[ernestcashstar]

Went through the README sticky and setup File Monitor to check for permissions and couldnt find any permission issues.

MY SETUP>
Operating System: Windows 2003 Server
Webserver: Apache
Cacti: cacti-0.8.6h
Cactid: ver.0.8.6f
MySQL: 5.0
PHP: 5
RRDTool: 1.2.9
Net-SNMP: 5.3.0.1-1
Cygwin: 1005.19.0.0

This is a dump of what I get when I run poller.php from command prompt.
Its strange coz now i get more information after the maximum runtime exceeded message.

C:\>php c:\progra~1\apache~1\apache2\htdocs\monitor\cacti-0.8.6h\poller.php
05/11/2006 05:17:38 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceed
ed. Exiting.
05/11/2006 05:17:38 PM - SYSTEM STATS: Time:292.8933 Method:cmd.php Processes:1
Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0

Warning: pclose(): 44 is not a valid stream resource in c:\Program Files\Apache
Group\Apache2\htdocs\monitor\cacti-0.8.6h\lib\rrd.php on line 47

C:\>

[BSOD2600]

Alright, so following the README sticky, turn the cacti logging level to debug for a cycle and see what it's timing out on.

Cygwin is only up to 1.5.x so not sure where you're getting that from. Look at cygwin1.dll. Search your system, there should only be one copy.

[ernestcashstar]

Sorry my mistake, Cygwin version is - Cygwin 1005.19.0.0.

LOG DUMP:

05/12/2006 09:56:43 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
05/12/2006 09:56:43 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
05/12/2006 09:56:43 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','c:/Program Files/Apache Group/Apache2/htdocs/monitor/cacti-0.8.6h')"
05/12/2006 09:56:43 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
05/12/2006 09:56:43 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/program files/apache group/apache2/htdocs/monitor/cacti-0.8.6h/cmd.php 0 3]
05/12/2006 09:56:44 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
05/12/2006 09:56:44 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
05/12/2006 09:56:44 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)"

... repeats this over and over ...

05/12/2006 10:01:35 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)"
05/12/2006 10:01:36 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
05/12/2006 10:01:36 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)"
05/12/2006 10:01:36 AM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
05/12/2006 10:01:36 AM - SYSTEM STATS: Time:293.2565 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0
05/12/2006 10:01:36 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:293.2565 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0')"
05/12/2006 10:01:36 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"

[BSOD2600]

Hmm, not in debugging mode. Try setting it back to low, save. Then change back to debug, save.

You should be seeing a lot of different info when in debugging mode, not the same thing over and over again.

[ernestcashstar]

Nothing changed. Still the same results.

I see on the screen "Waiting on 1/1 pollers." over and over again.

I tried what was suggested in this Thread http://forums.cacti.net/post-63960.html and on "Off" creates more error messages whilst "On" just the waiting on 1/1 pollers message.

[ernestcashstar]

I think I found the problem. My Apache webroot folder was in "C:\Program files" and Cacti didnt like the non dos 8.3 file / directory names. So I moved the webroot folder out to the root drive and replugged Apache Conf settings to point to the new location and after a web server restart running the poller produced the following results:

C:\cacti>php c:\htdocs\monitor\cacti-0.8.6h\poller.php
05/12/2006 11:30:43 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces
s [CMD: c:/php/php.exe, ARGS: -q c:/htdocs/monitor/cacti-0.8.6h/cmd.php 0 3]
05/12/2006 11:30:44 AM - SYSTEM STATS: Time:1.0798 Method:cmd.php Processes:1 Th
reads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0

I presume this worked?

[BSOD2600]

Looking better. Did your cacti log file and *.rrd files update every 5 minutes? If so, you're golden.