Spine polling issue

[Ed_Howard]

Hello Everyone,

I have recently implemented Cacti and installed the newest version of Spine. Once I change the polling engine from cmd.php to Spine I start losing all the graphing information. I checked the logs and the only errors that I am receiving are the ones below.

01/13/2011 12:04:01 PM - SYSTEM THOLD STATS: Time:0.0088 Tholds:0 Hosts:0
01/13/2011 12:04:01 PM - SYSTEM STATS: Time:299.9283 Method:spine Processes:1 Threads:1 Hosts:2 HostsPerProcess:2 DataSources:7 RRDsProcessed:0
01/13/2011 12:04:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.


The Technical Support section is as follows:

Date Thu, 13 Jan 2011 12:10:50 -0800
Cacti Version 0.8.7g
Cacti OS unix
SNMP Version NET-SNMP version: 5.1.2
RRDTool Version RRDTool 1.2.x
Hosts 1
Graphs 6
Data Sources Script/Command: 6
Script - Script Server (PHP): 1
Total: 7
Poller Information
Interval 300
Type spine
Items Action[1]: 6
Action[2]: 1
Total: 7
Concurrent Processes 1
Max Threads 1
PHP Servers 1
Script Timeout 25
Max OID 10
Last Run Statistics Time:298.9272 Method:spine Processes:1 Threads:1 Hosts:2 HostsPerProcess:2 DataSources:7 RRDsProcessed:0
PHP Information
PHP Version 5.1.6
PHP OS Linux
PHP uname Linux localhost.localdomain 2.6.9-89.33.1.plus.c4smp #1 SMP Thu Dec 2 12:09:37 EST 2010 i686
PHP SNMP Installed
max_execution_time 30
memory_limit 32M

I really appreciate any help and if this is already covered in another post I do apologize.

[lizwire]

hi, i experienced this before. For my issue, it was because my mysql-devel is different version than the mysql-server installed.

also, make sure that your poller matches that runtime specified in your cacti settings.

thanks,

[Ed_Howard]

Hi Lizwire,

I appreciate the help I looked at the mysql version levels and they appear to be near the same level:

Installed Packages
Name : mysql
Arch : i386
Version: 5.0.82sp1
Release: 1.el4_8
Size : 4.4 M
Repo : installed
Summary: MySQL client programs and shared libraries

Description:
MySQL is a multi-user, multi-threaded SQL database server. MySQL is a
client/server implementation consisting of a server daemon (mysqld)
and many different client programs and libraries. The base package
contains the standard MySQL client programs and generic MySQL files.

[root@localhost ~]# yum info mysql-server
Setting up repositories
Reading repository metadata in from local files
Installed Packages
Name : mysql-server
Arch : i386
Version: 5.0.82sp1
Release: 1.el4_8
Size : 22 M
Repo : installed
Summary: The MySQL server and related files

Description:
MySQL is a multi-user, multi-threaded SQL database server. MySQL is a
client/server implementation consisting of a server daemon (mysqld)
and many different client programs and libraries. This package contains
the MySQL server and some accompanying files and directories.


[root@localhost ~]# yum info mysql-devel
Setting up repositories
Reading repository metadata in from local files
Installed Packages
Name : mysql-devel
Arch : i386
Version: 5.0.82sp1
Release: 1.el4_8
Size : 7.1 M
Repo : installed
Summary: Files for development of MySQL applications

Description:
MySQL is a multi-user, multi-threaded SQL database server. This
package contains the libraries and header files that are needed for
developing MySQL client applications.

I set my polling levels to 5 minutes under the console>Settings>Poller section. I am not sure if that is what you meant. I appreciate the help and if there is anything else please let me know.

[lizwire]

hi there you will also need to create a cron job that will run the poller.php every 5 min.

this is taken from the cacti website:

Add a line to your /etc/crontab file similar to:

*/5 * * * * cactiuser php /var/www/html/cacti/poller.php > /dev/null 2>&1

make sure that the path of php and your poller is correct
and the you are running the cron as the correct user (i.e root or cactiuser, depending on you set it up)

thanks

[Ed_Howard]

Hi Liz,

I got this up and working most of the way. I recompiled the latest spine and then moved the spine binary and the spine.conf.dist into my newly created /var/www/html/spine directory. I then changed the name of the spine.conf.dist to spine.conf and edited it to reflect the database entries. I then added the crontab entry, changed the poller times and rebuilt the poller cache. The messages stopped however the data was not graphing. I then set the pollers back to a minute and changed the crontab entry to 1 minute and now everything is flowing as I would expect. The only problem now is that I am stuck if I want to move the poller up to 5 minutes but I can live with it now. Thanks for all the help I really appreciate it.