Poller changed to Spine from CMD - perl queries not working

[cahonis]

I recently changed our poller from CMD to spine as it was taking longer than 5 minutes to run.

I'm now seeing my data queries that use perl fail.

cacti 0.8.7g
Windows 2003

The data input is as follows:

Code: Select all

c:/Perl/bin/perl.exe d:/cacti/scripts/w32_sql_query_connections.pl <hostname> get UserConnections,LoginsPersec,LogoutsPersec

I see the following in the log:

Code: Select all

06/28/2012 03:31:28 PM - SPINE: Poller[0] Host[323] ERROR: Empty result [lon-sqldb01]: 'c:/Perl/bin/perl.exe d:/cacti/scripts/w32_sql_query_connections.pl LON-SQLDB01 get UserConnections,LoginsPersec,LogoutsPersec'

If I run the perl script from the command line it works.

[BSOD2600]

The web service account have permissions on perl.exe and spine.exe? Did you run the script AS the web service user account? If not, try that and see what happens.

sysinternals process monitor might be required to track down where the permission failure resides.

[cahonis]

The web service account have permissions on perl.exe and spine.exe? Did you run the script AS the web service user account? If not, try that and see what happens.

sysinternals process monitor might be required to track down where the permission failure resides.

The account the poller scheduled task runs under has the correct permissions to those folders and returns correct values when run manually as the poller account.

Switched back to CMD poller & rebuilt the cache to test and the perl script is working.

[BSOD2600]

The data input method has the full path to perl.exe specified, right? Spine is picky about that.

Otherwise, sounds like everything is set up properly. Either you can try and figure out the cause for the failure with sysinternals process monitor or see if cacti 0.8.8a resolves the problem.