Fresh Windows Install - Poller Issues

[Diggit2001]

Hello. With the arrival of Cacti v1, I thought this would be a good time to start fresh with Cacti. I loaded up a new Windows 10 box and installed BSOD2600s Windows Installer on it. Once that completed successfully, I downloaded Cacti v1.0.3 and installed that per the upgrade instructions. I ran through the upgrade process and after a few minutes, I was in to my newly upgraded fresh installation of Cacti. I added a few graphs to localhost and then waited for the poller to run to see if everything was running. I found that it was not. The poller didn't appear to be running at all for some reason. I still had my old Cacti installation running (also on Windows) so I mirrored its poller settings onto the new box. This didn't help. When I run the scheduled task manually, It never seems to complete. Run I run the poller from the command line, I get "Waiting on 1 of 1 pollers" that repeats for a while. Here's my current log:

Code: Select all

2017-02-16 16:04:35 - POLLER: Poller[1] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '60' seconds, with a maximum of a '60' second Scheduled Task, but 818.5 seconds have passed since the last poll!
2017-02-16 16:04:35 - POLLER: Poller[1] NOTE: Poller Int: '60', Scheduled Task Int: '60', Time Since Last: '818.54', Max Runtime '58', Poller Runs: '1'
2017-02-16 15:51:56 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(C:\inetpub\wwwroot\cacti\lib\functions.php: 4280 cacti_debug_backtrace)
2017-02-16 15:51:56 - ERROR PHP ERROR: Maximum execution time of 59 seconds exceeded in file: C:\inetpub\wwwroot\cacti\poller.php on line: 553
2017-02-16 15:50:57 - POLLER: Poller[1] NOTE: Poller Int: '60', Scheduled Task Int: '60', Time Since Last: '62.19', Max Runtime '58', Poller Runs: '1'
2017-02-16 15:50:54 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(C:\inetpub\wwwroot\cacti\lib\functions.php: 4280 cacti_debug_backtrace)
2017-02-16 15:50:54 - ERROR PHP ERROR: Maximum execution time of 59 seconds exceeded in file: C:\inetpub\wwwroot\cacti\lib\database.php on line: 285
2017-02-16 15:50:54 - SYSTEM STATS: Time:58.9679 Method:spine Processes:4 Threads:15 Hosts:2 HostsPerProcess:1 DataSources:2 RRDsProcessed:0
2017-02-16 15:50:54 - POLLER: Poller[1] Maximum runtime of 58 seconds exceeded. Exiting.
2017-02-16 15:49:55 - POLLER: Poller[1] NOTE: Poller Int: '60', Scheduled Task Int: '60', Time Since Last: '60.24', Max Runtime '58', Poller Runs: '1'
2017-02-16 15:49:54 - SYSTEM DSSTATS STATS: Type:HOURLY, Time:0.0015
2017-02-16 15:49:54 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(C:\inetpub\wwwroot\cacti\lib\functions.php: 4280 cacti_debug_backtrace)
2017-02-16 15:49:54 - ERROR PHP ERROR: Maximum execution time of 59 seconds exceeded in file: C:\inetpub\wwwroot\cacti\lib\poller.php on line: 125
2017-02-16 15:49:54 - SYSTEM STATS: Time:58.8938 Method:spine Processes:4 Threads:15 Hosts:2 HostsPerProcess:1 DataSources:2 RRDsProcessed:0
2017-02-16 15:49:54 - POLLER: Poller[1] Maximum runtime of 58 seconds exceeded. Exiting.
2017-02-16 15:48:55 - POLLER: Poller[1] NOTE: Poller Int: '60', Scheduled Task Int: '60', Time Since Last: '60.19', Max Runtime '58', Poller Runs: '1'
2017-02-16 15:48:54 - SYSTEM DSSTATS STATS: Type:HOURLY, Time:0.0014
2017-02-16 15:48:54 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(C:\inetpub\wwwroot\cacti\lib\functions.php: 4280 cacti_debug_backtrace)
2017-02-16 15:48:54 - ERROR PHP ERROR: Maximum execution time of 59 seconds exceeded in file: C:\inetpub\wwwroot\cacti\lib\poller.php on line: 125
2017-02-16 15:48:54 - SYSTEM STATS: Time:58.8070 Method:spine Processes:4 Threads:15 Hosts:2 HostsPerProcess:1 DataSources:2 RRDsProcessed:0
2017-02-16 15:48:54 - POLLER: Poller[1] Maximum runtime of 58 seconds exceeded. Exiting.
2017-02-16 15:47:55 - POLLER: Poller[1] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '60' seconds, with a maximum of a '60' second Scheduled Task, but 94.6 seconds have passed since the last poll!
2017-02-16 15:47:55 - POLLER: Poller[1] NOTE: Poller Int: '60', Scheduled Task Int: '60', Time Since Last: '94.64', Max Runtime '58', Poller Runs: '1'
2017-02-16 15:46:25 - SYSTEM DSSTATS STATS: Type:DAILY, Time:0.2126
2017-02-16 15:46:24 - DSSTATS WARNING: File 'C:/inetpub/wwwroot/cacti/rra/localhost_proc_7.rrd' Does not exist
2017-02-16 15:46:24 - DSSTATS WARNING: File 'C:/inetpub/wwwroot/cacti/rra/localhost_users_6.rrd' Does not exist
2017-02-16 15:46:24 - DSSTATS WARNING: File 'C:/inetpub/wwwroot/cacti/rra/localhost_load_1min_5.rrd' Does not exist
2017-02-16 15:46:24 - DSSTATS WARNING: File 'C:/inetpub/wwwroot/cacti/rra/localhost_mem_swap_4.rrd' Does not exist
2017-02-16 15:46:24 - DSSTATS WARNING: File 'C:/inetpub/wwwroot/cacti/rra/localhost_mem_buffers_3.rrd' Does not exist
2017-02-16 15:46:24 - SYSTEM DSSTATS STATS: Type:HOURLY, Time:0.0229
02/16/2017 03:46:24 PM - SPINE: Poller[1] Time: 2.0579 s, Threads: 15, Hosts: 1
2017-02-16 15:46:24 - SYSTEM STATS: Time:2.2922 Method:spine Processes:4 Threads:15 Hosts:2 HostsPerProcess:1 DataSources:2 RRDsProcessed:1
02/16/2017 03:46:24 PM - SPINE: Poller[1] Host[2] TH[1] Total Time: 0.21 Seconds
02/16/2017 03:46:24 PM - SPINE: Poller[1] Host[2] TH[1] DS[8] Graphs['localhost - Used Space - C: Label:OSDisk Serial Number a63e7bf1'] SS[1] SERVER: C:\inetpub\wwwroot\cacti\scripts\ss_host_disk.php ss_host_disk localhost 2 2:161:500:1:10:mrtghbi%375:::::: get total "1", output: 499582496768
02/16/2017 03:46:24 PM - SPINE: Poller[1] Host[2] TH[1] DS[8] Graphs['localhost - Used Space - C: Label:OSDisk Serial Number a63e7bf1'] SS[0] SERVER: C:\inetpub\wwwroot\cacti\scripts\ss_host_disk.php ss_host_disk localhost 2 2:161:500:1:10:mrtghbi%375:::::: get used "1", output: 23705096192
02/16/2017 03:46:24 PM - SPINE: Poller[1] Host[2] TH[1] NOTE: There are '2' Polling Items for this Host
02/16/2017 03:46:24 PM - SPINE: Poller[1] Host[2] TH[1] NOTICE: Spike Kill in Effect for 'localhost'
02/16/2017 03:46:24 PM - SPINE: Poller[1] Host[2] TH[1] ASSERT: '362883' .lt. '156437' failed. Recaching host 'localhost', data query #8
02/16/2017 03:46:24 PM - SPINE: Poller[1] Host[2] TH[1] Recache DataQuery[8] OID: .1.3.6.1.2.1.1.3.0, output: 156437
02/16/2017 03:46:24 PM - SPINE: Poller[1] Host[2] TH[1] NOTICE: Spike Kill in Effect for 'localhost'
02/16/2017 03:46:24 PM - SPINE: Poller[1] Host[2] TH[1] ASSERT: '362883' .lt. '156437' failed. Recaching host 'localhost', data query #1
02/16/2017 03:46:24 PM - SPINE: Poller[1] Host[2] TH[1] Recache DataQuery[1] OID: .1.3.6.1.2.1.1.3.0, output: 156437
02/16/2017 03:46:24 PM - SPINE: Poller[1] Host[2] SNMP Result: Host responded to SNMP
02/16/2017 03:46:23 PM - SPINE: Poller[1] NOTE: Spine will support multithread device polling.
02/16/2017 03:46:22 PM - SPINE: Poller[1] Time: 0.3800 s, Threads: 15, Hosts: 0
02/16/2017 03:46:22 PM - SPINE: Poller[1] NOTE: Spine will support multithread device polling.
2017-02-16 15:46:21 - POLLER: Poller[1] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '60' seconds, with a maximum of a '60' second Scheduled Task, but 2.0 K seconds have passed since the last poll!
2017-02-16 15:46:21 - POLLER: Poller[1] NOTE: Poller Int: '60', Scheduled Task Int: '60', Time Since Last: '2039.94', Max Runtime '58', Poller Runs: '1'
2017-02-16 15:23:45 - WEBUI: Cacti Log Cleared from Web Management Interface

The task never appears to launch on its own. I have to manually launch it from the scheduled task to get it to run for some reason. Here's my system info:

Technical Support [Summary]
General Information
Date Thu, 16 Feb 2017 16:08:14 -0500
Cacti Version 1.0.3
Cacti OS win32
RSA Fingerprint 96:92:c6:29:ed:f3:73:38:6c:93:b4:b6:e5:2a:8f:2f
NET-SNMP Version NET-SNMP version: 5.5
RRDtool Version RRDTool 1.4.x
Devices 1
Graphs 4
Data Sources Script/Command: 5
SNMP Query: 1
Script Query - Script Server: 3
Total: 9
Poller Information
Interval 60
Type SPINE 0.8.8h Copyright 2002-2016 by The Cacti Group
Items Action[0]: 2
Action[2]: 6
Total: 8
Concurrent Processes 4
Max Threads 15
PHP Servers 5
Script Timeout 25
Max OID 10
Last Run Statistics Time:1.2400 Method:cmd.php Processes:4 Threads:N/A Hosts:2 HostsPerProcess:1 DataSources:2 RRDsProcessed:1
System Memory
FreePhysicalMemory 6.48 K MB
FreeSpaceInPagingFiles 1.92 K MB
FreeVirtualMemory 4.89 K MB
SizeStoredInPagingFiles 1.92 K MB
TotalVirtualMemorySize 10.02 K MB
TotalVisibleMemorySize 8.10 K MB
PHP Information
PHP Version 5.6.14
PHP OS WINNT
PHP uname Windows NT CACTI 10.0 build 14393 (Windows 10) AMD64
PHP SNMP Installed
max_execution_time 30
memory_limit 128M

I'm not sure what's going on here. I'd appreciate any assistance that can be provided.
Thanks.

[westsyde]

How did you get past the mySql timezone error? I cant get thru the pre-install page myself.

For your error, look to your php.ini modules, I think it might that one is missing and needs to be uncommented.

Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.
;
;extension=php_bz2.dll
extension=php_gd2.dll
extension=php_gmp.dll
extension=php_ldap.dll
extension=php_mbstring.dll
extension=php_mysql.dll
extension=php_mysqli.dll
extension=php_openssl.dll
extension=php_pdo_mysql.dll
extension=php_snmp.dll
extension=php_sockets.dll
extension=php_com_dotnet.dll
fastcgi.impersonate=1
fastcgi.logging=0
cgi.fix_pathinfo=1
cgi.force_redirect=0
error_log=C:\php\php_errors.txt

[Diggit2001]

Thanks for the info, I will mess around with that a bit. As far a the timezone stuff goes, this page helped me out: https://dev.mysql.com/downloads/timezones.html

Assuming that you're using MySQL 5.6, download the file called, "timezone_2016j_posix.zip - POSIX standard". Stop the MySql service, and extract the contents of that zip to c:\ProgramData\MySQL\MySQL Server 5.6\data\mysql overwriting the stuff that's in there. Start your MySql service back up and you should be good to go.

Hope that helps.

[Diggit2001]

I checked my php.ini file and I have all the correct stuff un-commented. Here's what I have:

; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.
;
;extension=php_bz2.dll
extension=php_gd2.dll
extension=php_gmp.dll
extension=php_ldap.dll
extension=php_mbstring.dll
extension=php_mysql.dll
extension=php_mysqli.dll
extension=php_com_dotnet.dll
extension=php_openssl.dll
extension=php_pdo_mysql.dll
extension=php_snmp.dll
extension=php_sockets.dll
fastcgi.impersonate=1
fastcgi.logging=0
cgi.fix_pathinfo=1
cgi.force_redirect=0
error_log=C:\php\php_errors.txt

;extension=php_curl.dll
;extension=php_fileinfo.dll
;extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_gmp.dll
;extension=php_intl.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
;extension=php_exif.dll ; Must be after mbstring as it depends on it
;extension=php_mysql.dll
;extension=php_mysqli.dll
;extension=php_oci8_12c.dll ; Use with Oracle Database 12c Instant Client
;extension=php_openssl.dll
;extension=php_pdo_firebird.dll
;extension=php_pdo_mysql.dll
;extension=php_pdo_oci.dll
;extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
;extension=php_pdo_sqlite.dll
;extension=php_pgsql.dll
;extension=php_shmop.dll

After playing with on Friday for a while, I do have it working but only when using cmd.php as the poller. (I've always preferred spine) When I change any poller settings, I have found that it stops completely and I have to create a brand new scheduled task to get it to start polling again. I have been using Cacti for over 10 years and haven't run into any issues like this with the poller. It really has me stumped. I am hesitant to start adding any hosts to my cacti install until I get this figured out.

[lownoise]

The latest binary of spine 0.8.8.a isn't compatible with cacti 1.0.0 and newer.
The spine binary lags the option --mibs whitch is send from the poller.php
a simple workaround is to change line 164 in the poller.php

Code: Select all

$mibs = true;

to
$mibs = false;

After that spine as poller will work

[Diggit2001]

That did the trick! Thanks very much.

[BSOD2600]

The task never appears to launch on its own. I have to manually launch it from the scheduled task to get it to run for some reason.

did you follow the post-install instructions?

Here's my current log:

The various backtrace are code errors. See if they're already been reported at https://github.com/Cacti/cacti/issues and/or pull the latest repository and see if they still occur.

[lownoise]

I've compiled the latest spine sourcecode (version 1.0.3) with cygwin.
after that i've changed the $mibs setting back to $mibs=true
Spine is working fine now and no sourcecode modification is needed anymore

[Diggit2001]

The task never appears to launch on its own. I have to manually launch it from the scheduled task to get it to run for some reason.

did you follow the post-install instructions?

Yes, I changed the task to run as a domain account with necessary privileges.

Here's my current log:

The various backtrace are code errors. See if they're already been reported at https://github.com/Cacti/cacti/issues and/or pull the latest repository and see if they still occur.

OK. I wiped by server again and started over using the latest Windows installer that you made. If I ever figure out how to get and keep the poller running I'll post any issues on github.

Thanks.