[SOLVED] Installing Spine 0.8.7a...

[Mark.]

did you update your spine.conf file?

[capmax]

replace ping.c from cacti-spine-0.8.7a with ping.c from cacti-spine-0.8.7. Its work for me even using icmp ping.

I've tested three different version of spine :
- 0.8.7a,
- 0.8.7a with 0.8.7 ping.c (following sizulku's advice),
- 0.8.7
Each time, I executed the following code :

Code: Select all

aclocal
libtoolize --force  (glibtoolize --force on Max OS)
autoheader
autoconf
automake
./configure
make
make install

...and each time, I had a new folder /usr/local/spine/ in which i had bin/spine and etc/spine.conf. And after changing spine.conf, in the three cases, I had the same behavior when I launched spine (see lasts posts) : nothing during 294sec.

Shouldn't it be very easy to install spine ?

[gandalf]

- In the cacti settings, 'Paths' tab : I entered in the field "Cactid Poller File Path" my path to spine.
- In the cacti settings, 'Poller' tab : I selected cactid instead of cmd.php
- It should work, shouldn't it ?

I'm a bit worried about this wording. cactid should not occur on any panel when running cacti 087(a). This make me think you may have a pre 087 cacti version
Reinhard

[capmax]

I've checked the tar.gz package I've downloaded, it's cacti-0.8.7a. Do you know how to check the version of cacti in the interface ?

However, for my problem, I don't think the cacti version matters : spine poller itself doesn't work when lauched with command line...

[frankfegert]

Try running spine with more verbosity:

Code: Select all

spine -R -S -V 5

or with strace/truss:

Code: Select all

strace spine -R -S -V 5

Post the output please.

[gandalf]

I've checked the tar.gz package I've downloaded, it's cacti-0.8.7a. Do you know how to check the version of cacti in the interface ?

Goto main page and select the cactus. spine does not work with cacti086 and cactid does not work with cacti087
Reinhard

[TheWitness]

For any others using spine that have the timeout issue, please run a wireshark capture while running "./spine" and attach the output. I will also need to know the ipaddress of your poller.

TheWitness

[capmax]

Try running spine with more verbosity:

Code: Select all

spine -R -S -V 5

or with strace/truss:

Code: Select all

strace spine -R -S -V 5

Post the output please.

Good idea, a debug mode : thanks to that, it seems spine is stuck on a request to the database (see at the end of the log). When I try to send this request directly in phpMyAdmin, it returns an error saying that the field snmp_auth_protocol doesn't exist (same thing for snmp_priv_passphrase, snmp_priv_protocol, snmp_context).
So do I have a bad database structure ?

See the log below :

Code: Select all

$ ./spine -R -S -V 5
SPINE: Using spine config file [../etc/spine.conf]
01/21/2008 10:22:40 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_webroot''
01/21/2008 10:22:40 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_cactilog''
01/21/2008 10:22:40 AM - SPINE: Poller[0] DEBUG: The path_php_server variable is /var/www/cacti/script_server.php
01/21/2008 10:22:40 AM - SPINE: Poller[0] DEBUG: The path_cactilog variable is /var/www/cacti/log/cacti.log
DEBUG: The log_destination variable is 4 (STDOUT)
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_php_binary''
DEBUG: The path_php variable is /usr/bin/php
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'availability_method''
DEBUG: The availability_method variable is 2
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_recovery_count''
DEBUG: The ping_recovery_count variable is 3
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_failure_count''
DEBUG: The ping_failure_count variable is 2
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_method''
DEBUG: The ping_method variable is 2
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_retries''
DEBUG: The ping_retries variable is 1
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_timeout''
DEBUG: The ping_timeout variable is 400
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_perror''
DEBUG: The log_perror variable is 1
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pwarn''
DEBUG: The log_pwarn variable is 0
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pstats''
DEBUG: The log_pstats variable is 0
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_threads''
DEBUG: The threads variable is 1
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'poller_interval''
DEBUG: The polling interval is the system default
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'concurrent_processes''
DEBUG: The number of concurrent processes is 1
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'script_timeout''
DEBUG: The script timeout is 25
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'php_servers''
DEBUG: The number of php script servers to run is 1
DEBUG: SQL:'SELECT action FROM poller_item WHERE action=2 LIMIT 1'
DEBUG: StartHost='-1', EndHost='-1', TotalPHPScripts='1'
DEBUG: The PHP Script Server is Required
DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_get_size''
DEBUG: The Maximum SNMP OID Get Size is 1
Version 0.8.7b starting
DEBUG: MySQL is Thread Safe!
SPINE: Initializing Net-SNMP API
DEBUG: SNMP Header Version is 5.3.1
DEBUG: SNMP Library Version is 5.3.1
SPINE: Initializing PHP Script Server(s)
DEBUG: SS[0] PHP Script Server Routine Starting
DEBUG: SS[0] PHP Script Server About to FORK Child Process
DEBUG: SS[0] PHP Script Server Child FORK Success
DEBUG: SS[0] Confirmed PHP Script Server running
DEBUG: SQL:'SELECT id FROM host WHERE disabled='' ORDER BY id'
DEBUG: Initial Value of Active Threads is 0
DEBUG: Valid Thread to be Created
DEBUG: The Value of Active Threads is 1
DEBUG: In Poller, About to Start Polling of Host
DEBUG: SQL:'SELECT snmp_port, count(snmp_port) FROM poller_item WHERE host_id=0 GROUP BY snmp_port'
DEBUG: SQL:'SELECT action, hostname, snmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path, arg1, arg2, arg3, local_data_id, rrd_num, snmp_port, snmp_timeout, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context  FROM poller_item WHERE host_id=0 ORDER BY snmp_port'
---
--- it stucks here for a long time
--- and then ...
ERROR: Spine Timed Out While Processing Hosts Internal
DEBUG: SQL:'replace into settings (name,value) values ('date',NOW())'
DEBUG: SQL:'insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())'
DEBUG: Thread Cleanup Complete
DEBUG: SS[0] Script Server Shutdown Started
DEBUG: PHP Script Server Pipes Closed
DEBUG: Allocated Variable Memory Freed
SPINE: Net-SNMP API Shutdown Completed
DEBUG: MYSQL Free & Close Completed
Time: 294.0004 s, Threads: 1, Hosts: 3

[TheWitness]

Definately. Spine is designed for Cacti 0.8.7++ and not designed for Cacti 0.8.6x. In Cacti 0.8.7, we introduced those NEW fields.

TheWitness

[capmax]

Oh my !...
The problem is closed : when clicking on the cactus icon, I can see 0.8.6h...
But I don't understand why : I kept my install pakage and it's the 0.8.7a !
Thanks to all posters