Unknown results, but only with Spine

[Cylindric]

Hello,

I am monitoring Windows hosts, some of which are remote and locked behind firewalls etc, so have a custom utility to retrieve stats for these from an intermediary database.

When I run the command as a data source through CMD, it works fine, but through Spine I get "U".

For example, here's the logfile output for one server's disks through CMD:

Code: Select all

09/04/2012 11:58:15 PM - CMDPHP: Poller[0] Host[4] DS[340] CMD: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe disks servername get Size c, output: 42842714112
09/04/2012 11:58:19 PM - CMDPHP: Poller[0] Host[4] DS[340] CMD: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe disks servername get FreeSpace c, output: 7759368192
09/04/2012 11:58:22 PM - CMDPHP: Poller[0] Host[4] DS[340] CMD: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe disks servername get FreePercent c, output: 18.1112899890407
09/04/2012 11:58:22 PM - POLLER: Poller[0] CACTI2RRD: D:/Cacti/rrdtool-1.4.5/rrdtool.exe update D:\Cacti\cacti-0.8.8a\rra\servername_size_340.rrd --template size:free_space:free_percent 1346799478:42842714112:7759368192:18.1112899890407

Here's the equivalent data item in Spine:

Code: Select all

09/04/2012 11:54:51 PM - SPINE: Poller[0] Host[19] ERROR: Empty result [servername]: 'D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe disks servername get Size c'
09/04/2012 11:54:51 PM - SPINE: Poller[0] Host[19] TH[1] DS[378] SCRIPT: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe disks servername get Size c, output: U
09/04/2012 11:54:51 PM - SPINE: Poller[0] Host[19] ERROR: Empty result [servername]: 'D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe disks servername get FreeSpace c'
09/04/2012 11:54:51 PM - SPINE: Poller[0] Host[19] TH[1] DS[378] SCRIPT: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe disks servername get FreeSpace c, output: U
09/04/2012 11:54:51 PM - SPINE: Poller[0] Host[19] ERROR: Empty result [servername]: 'D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe disks servername get FreePercent c'
09/04/2012 11:54:51 PM - SPINE: Poller[0] Host[19] TH[1] DS[378] SCRIPT: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe disks servername get FreePercent c, output: U

The command always works when run from the command line or from CMD, just not from Spine. I'm not sure what I can try next to diagnose the problem.

[artagel]

Just off the top of my head, I'd check permissions to make sure if spine can actually run the exe. Also, why don't you run spine manually with high verbosity so you can maybe see what it's doing.
-Dan

[Cylindric]

Thanks for that, I'm not very familiar with the way Spine works.

It seems to be a problem with the way Spine uses sh in a to get things done.

Code: Select all

D:\Cacti\cacti-spine-0.8.8a-win32>spine -f 2 -l 2 -V 5
cygwin warning:
  MS-DOS style path detected: D:/Cacti/cacti-0.8.8a/log/cacti.log
  Preferred POSIX equivalent is: /cacti-0.8.8a/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.html#using-pathnames
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found
sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found

I'll try with more sh-friendly paths using forward-slashes...

[Cylindric]

I'll try with more sh-friendly paths using forward-slashes...

Ah, they already are in the XML it seems:

Code: Select all

<interface>
	<name>Get PerfMon Disks</name>
	<script_path>|path_cacti|/scripts/query_mssql_counters.exe disks</script_path>

If I just paste the command into a cygwin shell as it is in the config file, it works - it seems to be the clever path-fixing causing an issue.

Code: Select all

username@cactiserver ~
$ D:/Cacti/cacti-0.8.8a/scripts/query_mssql_counters.exe disks servername num_indexes
7

[artagel]

So are you saying you fixed it;)?
Definitely looks like an sh pathing issue.
-Dan

[Cylindric]

Unfortunately not. It works if I run the command manually with forward-slashes as I've put in the xml, but Spine seems to 'fix' them to Windows-style path-separators, even though that doesn't work in Cygwin.

[BSOD2600]

1) Using Spine 0.8.8a?
2) Why is disks in the <script_path>?
3) Sure NTFS permission aren't the issue? Sysinternals process monitor will show what's really going on. Especially for the "sh: D:\Cacti\cacti-0.8.8a\scripts\query_mssql_counters.exe: command not found" error.

[Bl00dsoul]

I'm having this exact same problem..
Have you found a solution yet?