Centos 5.5 + Cacti + Spine = Spine not working

[iDen]

Hello everybody.
Here is my setup:

php-snmp-5.1.6-27.el5
net-snmp-libs-5.3.2.2-9.el5_5.1
net-snmp-utils-5.3.2.2-9.el5_5.1
net-snmp-5.3.2.2-9.el5_5.1
rrdtool-1.4.4-1.el5.rf
perl-rrdtool-1.4.4-1.el5.rf
cacti-0.8.7g-2.el5.rf
cacti-docs-0.8.7g-2.el5.rf
2.6.18-194.26.1.el5 i686 i386 GNU/Linux

whole setup done with yum
base setup with cmd.php works fine, but i want to configure cacti with spine
first time yum installed this version of spine and i got error like:
cacti-spine-0.8.7a

Code: Select all

11/26/2010 10:35:01 PM - SPINE: Poller[0] ERROR: SNMP Library Version Mismatch (5.3.1 vs 5.3.2.2) (Spine parent)

After that i've tried to find newer version of spine rpm on internet. Found this one:

Code: Select all

cacti-spine-0.8.7g-1.el5.pp

Installed and getting new error:

Code: Select all

11/26/2010 11:00:03 PM - SYSTEM STATS: Time:1.1288 Method:spine Processes:1 Threads:1 Hosts:5 HostsPerProcess:5 DataSources:21 RRDsProcessed:19
]11/26/2010 11:00:02 PM - SPINE: Poller[0] Host[4] ERROR: Empty result [127.0.0.1]: '/usr/bin/php -q /var/www/cacti/scripts/cacti_user_stats.php'
11/26/2010 11:00:02 PM - SPINE: Poller[0] Host[4] ERROR: Empty result [127.0.0.1]: '/usr/bin/php -q /var/www/cacti/scripts/cacti_user_stats.php'
11/26/2010 11:00:02 PM - SPINE: Poller[0] Host[4] ERROR: Empty result [127.0.0.1]: '/usr/bin/php -q /var/www/cacti/scripts/cacti_user_stats.php'

I've configured spine with proper mysql db data. The only thing i've added to cacti from internet was "Cacti Poller Host Statistics".

Please, whats the problem ? How to make it run ?

Waiting for feedback.
Thanks in advance.

[gandalf]

The "empty result" issue simply tells you, that there was no data found. That's quite a valid response (e.g. in this case, no user may have logged in during the polling interval). See 2nd link of my sig for more debugging hints
R.

[iDen]

Tell me, And this issue with empty file stops Spine to get any other data which cacti should process ?????
When i'm on spine, cacti stops drawing graphs. cmd.php is ok.
I can't see any other problems.
Maybe someone knows what can i do else?

[gandalf]

The snmp library mismatch makes me worry more.
Did you compile spine on your own?
R.

[iDen]

after this failures i've compiled spine by my own from source.
found some tutorials on internet about spine + cacti instalation
you better add some more strings in spine config on cacti-wiki,
about MySQL rrd fields update and rra directory refresh............................................hm.

i've one more question. Do i have to use crontab with spine or crontab is useless with spine combination ?

[iDen]

Sorry, but it's still not working. i had cmd.php previously.
Please how should i configure spine in cacti ?
I did fresh setup of cacti 0.8.7g
installed all patches for 0.8.7g
compiled spine 0.8.7g from tarball (installed mysql, snmp and openssl devel packages)

Also as i understood i shouldn't touch crontab for Spine method or i should ?
I didn't understand, different sites describe process differently. One site says make it 1 minute interval other one 5 minute interval.
Plus suggest to do such changes

Code: Select all

mysql> update data_template_data set rrd_step='60';
mysql> update data_template_rrd set rrd_heartbeat='120';

What should i do? now i have absolutely clean setup of cacti and spine with cacti patches. nothing in sql touched.
Spine shows no errors. connects to db and "polls" info shows its messages:

Code: Select all

# spine
SPINE: Using spine config file [/etc/spine.conf]
SPINE: Version 0.8.7g starting
SPINE: Time: 0.1710 s, Threads: 5, Hosts: 2

or i should use crontab to start each time it has to poll new data and synchronize cacti timer to poll new graphs in proper time ?
can i do everything in gui, without changing sql (like it was config for old version suggested )?

[gandalf]

Sorry, but it's still not working. i had cmd.php previously.
Please how should i configure spine in cacti ?
I did fresh setup of cacti 0.8.7g
installed all patches for 0.8.7g
compiled spine 0.8.7g from tarball (installed mysql, snmp and openssl devel packages)

Also as i understood i shouldn't touch crontab for Spine method or i should ?

You shouldn't.

I didn't understand, different sites describe process differently. One site says make it 1 minute interval other one 5 minute interval.
Plus suggest to do such changes

Code: Select all

mysql> update data_template_data set rrd_step='60';
mysql> update data_template_rrd set rrd_heartbeat='120';

Something like this is required only when running 1 min polling. I do NOT advertise to use this, at least not at this point. There are many pitfalls on the way ahead for this (not yet officially supported) ...

What should i do? now i have absolutely clean setup of cacti and spine with cacti patches. nothing in sql touched.
Spine shows no errors. connects to db and "polls" info shows its messages:

Code: Select all

# spine
SPINE: Using spine config file [/etc/spine.conf]
SPINE: Version 0.8.7g starting
SPINE: Time: 0.1710 s, Threads: 5, Hosts: 2

That looks fine

or i should use crontab to start each time it has to poll new data and synchronize cacti timer to poll new graphs in proper time ?
can i do everything in gui, without changing sql (like it was config for old version suggested )?

You only run "poller.php" from crontab. This guy selects between "cmd.php" or "spine"
R.

[becketts]

i need to chime in on this one a bit gandalf,

There is something "iffy" with spine at the moment and i cant seem to find the root cause.
Some graphs will stop populating when spine is used, while others keep working, cmd shows no such problem and all graphs work with no problems.
It seems that it is around how spine handles script output, despite rendering correctly one the command line and with cmd, polling with spine produces 0.

i found this spine was the cause by following your debugging advice but cant find the root cause and a resolution (how do you debug spine itself??)

[gandalf]

Then it comes down to contacting TheWitness. He's THE spine guy
R.

[becketts]

excellent... well i'll start pestering him then, go put your feet up and have a beer.