UPDATED 2010-08-21 - Spine 0.8.7g for Windows

[TheWitness]

All,

Please find attached the most recent spine for Windows. There are a few usage notes that you need to know before using.

1) If you have Cygwin installed, it needs to be version 1.7-5.
2) If you have Cygwin installed, you do not need either the DLL files or the sh.exe found in the archive.
3) This version spine should work just fine with Windows paths and if you combine with the script_server.php in our SVN repository, you should be able to do WMI not only in spine but through the script server.
4) If you plan on using for versions of Cacti prior to 0.8.7g, there is a new setting in spine.conf that you need to be aware of.

Please report success or failure here.

TheWitness

Edit: Download now available on main cacti site.

[Vertigo]

Hey,

Tried this new version and same result as last time, no output

Code: Select all

D:\localapp\cacti\spine>spine.exe

D:\localapp\cacti\spine>

spine.conf is all ok and am using the dll's provided

[TheWitness]

Im in the process of building for Windows. I only have little blocks of time and getting a good build environment takes time since I am all 64bit windows now.

[TheWitness]

All,

I have updated for the latest spine patches. This version is much happier on Windows!!!

TheWitness

[enrique.belo]

Hi, please help. This works fine with cmd.php poller.
I tried using this spine with cacti0.8.7e (preg set to 1), at first I got a "cygz.dll is missing", copied the dll file from my other pc with cygwin installed. And got the following result when running spine :

C:\spine>spine -R -V 5
NOTE: The Shell Command Exists in the current directory
SPINE: Using spine config file [spine.conf]
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The path_php_server variable is c:/wamp/www/cacti/script_server.php
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The path_cactilog variable is C:/wamp/www/cacti/log/cacti.log
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The log_destination variable is 1 (FILE)
cygwin warning:
MS-DOS style path detected: C:/wamp/www/cacti/log/cacti.log
Preferred POSIX equivalent is: /wamp/www/cacti/log/cacti.log
CYGWIN environment variable option "nodosfilewarning" turns off this warning.
Consult the user's guide for more details about POSIX paths:
http://cygwin.com/cygwin-ug-net/using.h ... -pathnames
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The path_php variable is c:/wamp/bin/php/php5.2.9-2/php.exe
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The availability_method variable is 2
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 3
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 2
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The ping_method variable is 2
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The ping_retries variable is 1
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 400
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The snmp_retries variable is 3
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 0
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The boost_redirect variable is 0
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The log_pstats variable is 0
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The threads variable is 1
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The polling interval is 300 seconds
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 1
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The script timeout is 25
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 1
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: StartHost='-1', EndHost='-1', TotalPHPScripts='0'
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The PHP Script Server is Not Required
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 20
08/22/2010 12:12:13 PM - SPINE: Poller[0] Version 0.8.7g starting
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: MySQL is Thread Safe!
08/22/2010 12:12:13 PM - SPINE: Poller[0] SPINE: Initializing Net-SNMP API
08/22/2010 12:12:13 PM - SPINE: Poller[0] DEBUG: Issues with SNMP Header Version information, assuming old version of Net-SNMP.
No log handling enabled - turning on stderr logging
Cannot find module (NOTIFICATION-LOG-MIB): At line 1 in (none)
Cannot find module (NET-SNMP-AGENT-MIB): At line 1 in (none)
Cannot find module (NET-SNMP-PASS-MIB): At line 1 in (none)
Cannot find module (NET-SNMP-EXTEND-MIB): At line 1 in (none)
08/22/2010 12:12:14 PM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(s)
08/22/2010 12:12:14 PM - SPINE: Poller[0] NOTE: Spine did not detect multithreaded device polling.
08/22/2010 12:12:14 PM - SPINE: Poller[0] NOTE: Spine is behaving in a PRE 0.8.7g manner
08/22/2010 12:12:14 PM - SPINE: Poller[0] DEBUG: Initial Value of Active Threads is 0
08/22/2010 12:12:14 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
08/22/2010 12:12:14 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
08/22/2010 12:12:14 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
08/22/2010 12:12:14 PM - SPINE: Poller[0] Host[0] TH[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
08/22/2010 12:12:14 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
08/22/2010 12:12:14 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
08/22/2010 12:12:14 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
08/22/2010 12:12:14 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
08/22/2010 12:12:14 PM - SPINE: Poller[0] Host[2] SNMP Result: Host responded to SNMP
08/22/2010 12:12:14 PM - SPINE: Poller[0] Host[2] TH[1] RECACHE: Processing 1 items in the auto reindex cache for '10.100.254.11'
08/22/2010 12:12:14 PM - SPINE: Poller[0] Host[2] TH[1] NOTE: There are '48' Polling Items for this Host
08/22/2010 12:12:14 PM - SPINE: Poller[0] Host[2] DEBUG: The NIFTY POPEN returned the following File Descriptor 6
sh: c:\wamp\bin\php\php5.2.9-2\php.exe: command not found
08/22/2010 12:12:14 PM - SPINE: Poller[0] Host[2] ERROR: Empty result [10.100.254.11]: 'c:\wamp\bin\php\php5.2.9-2\php.exe -q C:\wamp\www\cacti\scripts\query_ecn2.php 10.100.254.11 2 1:161:500:1:10:public:::::: get ifin 2'
08/22/2010 12:12:14 PM - SPINE: Poller[0] Host[2] TH[1] DS[9] SCRIPT: c:\wamp\bin\php\php5.2.9-2\php.exe -q C:\wamp\www\cacti\scripts\query_ecn2.php 10.100.254.11 2 1:161:500:1:10:public:::::: get ifin 2, output: 0
08/22/2010 12:12:14 PM - SPINE: Poller[0] Host[2] DEBUG: The NIFTY POPEN returned the following File Descriptor 6
sh: c:\wamp\bin\php\php5.2.9-2\php.exe: command not found
08/22/2010 12:12:14 PM - SPINE: Poller[0] Host[2] ERROR: Empty result [10.100.254.11]: 'c:\wamp\bin\php\php5.2.9-2\php.exe -q C:\wamp\www\cacti\scripts\query_ecn2.php 10.100.254.11 2 1:161:500:1:10:public:::::: get ifout 2'
08/22/2010 12:12:14 PM - SPINE: Poller[0] Host[2] TH[1] DS[9] SCRIPT: c:\wamp\bin\php\php5.2.9-2\php.exe -q C:\wamp\www\cacti\scripts\query_ecn2.php 10.100.254.11 2 1:161:500:1:10:public:::::: get ifout 2, output: 0
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] DEBUG: The NIFTY POPEN returned the following File Descriptor 6
sh: c:\wamp\bin\php\php5.2.9-2\php.exe: command not found
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] ERROR: Empty result [10.100.254.11]: 'c:\wamp\bin\php\php5.2.9-2\php.exe -q C:\wamp\www\cacti\scripts\query_ecn2.php 10.100.254.11 2 1:161:500:1:10:public:::::: get ifin 3'
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] TH[1] DS[11] SCRIPT: c:\wamp\bin\php\php5.2.9-2\php.exe -q C:\wamp\www\cacti\scripts\query_ecn2.php 10.100.254.11 2 1:161:500:1:10:public:::::: get ifin 3, output: 0
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] DEBUG: The NIFTY POPEN returned the following File Descriptor 6
sh: c:\wamp\bin\php\php5.2.9-2\php.exe: command not found
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] ERROR: Empty result [10.100.254.11]: 'c:\wamp\bin\php\php5.2.9-2\php.exe -q C:\wamp\www\cacti\scripts\query_ecn2.php 10.100.254.11 2 1:161:500:1:10:public:::::: get ifout 3'
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] TH[1] DS[11] SCRIPT: c:\wamp\bin\php\php5.2.9-2\php.exe -q C:\wamp\www\cacti\scripts\query_ecn2.php 10.100.254.11 2 1:161:500:1:10:public:::::: get ifout 3, output: 0
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] DEBUG: The NIFTY POPEN returned the following File Descriptor 6
sh: c:\wamp\bin\php\php5.2.9-2\php.exe: command not found
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] ERROR: Empty result [10.100.254.11]: 'c:\wamp\bin\php\php5.2.9-2\php.exe -q C:\wamp\www\cacti\scripts\query_ecn2.php 10.100.254.11 2 1:161:500:1:10:public:::::: get ifin 1'
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] TH[1] DS[13] SCRIPT: c:\wamp\bin\php\php5.2.9-2\php.exe -q C:\wamp\www\cacti\scripts\query_ecn2.php 10.100.254.11 2 1:161:500:1:10:public:::::: get ifin 1, output: 0
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] DEBUG: The NIFTY POPEN returned the following File Descriptor 6
sh: c:\wamp\bin\php\php5.2.9-2\php.exe: command not found
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] ERROR: Empty result [10.100.254.11]: 'c:\wamp\bin\php\php5.2.9-2\php.exe -q C:\wamp\www\cacti\scripts\query_ecn2.php 10.100.254.11 2 1:161:500:1:10:public:::::: get ifout 1'
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] TH[1] DS[13] SCRIPT: c:\wamp\bin\php\php5.2.9-2\php.exe -q C:\wamp\www\cacti\scripts\query_ecn2.php 10.100.254.11 2 1:161:500:1:10:public:::::: get ifout 1, output: 0
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] DEBUG: The NIFTY POPEN returned the following File Descriptor 6
sh: c:\wamp\bin\php\php5.2.9-2\php.exe: command not found
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] ERROR: Empty result [10.100.254.11]: 'c:\wamp\bin\php\php5.2.9-2\php.exe -q C:\wamp\www\cacti\scripts\query_ecn2.php 10.100.254.11 2 1:161:500:1:10:public:::::: get ifin 4'
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] TH[1] DS[14] SCRIPT: c:\wamp\bin\php\php5.2.9-2\php.exe -q C:\wamp\www\cacti\scripts\query_ecn2.php 10.100.254.11 2 1:161:500:1:10:public:::::: get ifin 4, output: 0
08/22/2010 12:12:15 PM - SPINE: Poller[0] Host[2] DEBUG: The NIFTY POPEN returned the following File Descriptor 6
sh: c:\wamp\bin\php\php5.2.9-2\php.exe: command not found

[TheWitness]

Please use process monitor from SysInternals (now Microsoft) to 'watch' the following processes:

spine.exe, php.exe, sh.exe and attach the output.

TheWitness

Process Monitor Link -> http://technet.microsoft.com/en-us/sysi ... 96645.aspx

[enrique.belo]

hi, please see attached. original logfile took 100Mb. Attached is the first 50k events. Or please tell me what exactly you want to see like 'network activity' or 'file system activity'? So I can attach the whole log.
Hope this one helps. thanks!
Thanks!

[TheWitness]

1) open a command prompt
2) run 'php -v'
3) if that runs skip to step 5)
4) place c:\wamp\bin\php\php5.2.9-2 in your path
5) modify you data input methods and data queries to change 'c:\wamp\bin\php\php5.2.9-2\php.exe' to 'php.exe'
6) repopulate the poller cache.

Spine should not work.

TheWitness

[enrique.belo]

hi, both ways 'php -v' runs. Sorry, but i dont understand how to modify the path to php.exe on step 5.

I am using Get Script Data (indexed) as data input method.

here's the result of 'php -v' command:
C:\>php -v
PHP 5.2.9-2 (cli) (built: Apr 9 2009 08:23:19)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2009 Zend Technologies

C:\>cd wamp\bin\php\php5.2.9-2

C:\wamp\bin\php\php5.2.9-2>php -v
PHP 5.2.9-2 (cli) (built: Apr 9 2009 08:23:19)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2009 Zend Technologies

[TheWitness]

Edit the data input methods and remove the path. Afterwords, repopulate the poller cache

[enrique.belo]

hi, i dont see on where to edit the php.exe. please see attached.
Thanks!

[TheWitness]

For data quries, look in the xml file.

TheWitness

[enrique.belo]

hi! it seems spine is now working, graphs are updated but full of gaps.
08/26/2010 10:04:11 PM - SYSTEM THOLD STATS: Time:0.7794 Tholds:107 Hosts:0
08/26/2010 10:04:10 PM - SYSTEM STATS: Time:130.2525 Method:spine Processes:1 Threads:1 Hosts:15 HostsPerProcess:15 DataSources:219 RRDsProcessed:111
08/26/2010 10:04:10 PM - POLLER: Poller[0] CACTI2RRD: C:/rrdtool/rrdtool.exe update C:\wamp\www\cacti\rra\butuan-02_traffic_incoming_123.rrd --template traffic_outgoing:traffic_incoming 1282889048:3420273326:4221970255
08/27/2010 06:04:10 AM - SPINE: Poller[0] Time: 129.4210 s, Threads: 1, Hosts: 14
08/27/2010 06:04:10 AM - SPINE: Poller[0] DEBUG: MYSQL Free & Close Completed
08/27/2010 06:04:10 AM - SPINE: Poller[0] DEBUG: Allocated Variable Memory Freed
08/27/2010 06:04:10 AM - SPINE: Poller[0] DEBUG: PHP Script Server Pipes Closed
08/27/2010 06:04:10 AM - SPINE: Poller[0] DEBUG: Thread Cleanup Complete
08/27/2010 06:04:10 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
08/27/2010 06:04:10 AM - SPINE: Poller[0] Host[16] TH[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
08/27/2010 06:04:10 AM - SPINE: Poller[0] Host[16] TH[1] DS[123] SCRIPT: php.exe -q C:\wamp\www\cacti\scripts\query_ecn2.php 10.100.245.3 16 1:161:500:1:20:public:::::: get ifout 1, output: 3420273326

[TheWitness]

The gaps will go away over time. You might want to bump up your thread count.

TheWitness

[isse]

I just replaced all the files in the spine folder and updated the spine.conf, but the poller stopped working after this, the task hangs.
If i check my event manager i get this error:
Faulting application spine.exe, version 0.0.0.0, time stamp 0x4c6fc4a1, faulting module cygz.dll, version 6.0.6002.18005.

I dont have cygwin installed.
Any ideas of what could be wrong ?

Thanks