Spine + cacti 0.8.7e Mysql 1064 Error, Centos 5.4

[darcym]

Hi all,

I'm having a problem with Cacti and spine versions 0.8.7e.

first of all some reference info.

I've built a spine 0.8.7e rpm from the following spec file (basically just from the Dag Weirs Spec file but added the Cacti recommended patches - spec file available on request).

I've also install cacti 0.8.7e with the recommended patches, using mysql 5.1.6 as shipped by Centos 5.4 x86_64.

The polling of the local host is working fine, however polling a remote host is failing. I'm using spine to query the remote host.

Debugging this using the following command

Code: Select all

spine --verbosity=5 -H=10.11.216.10

I get the following results.

SPINE: Using spine config file [/etc/spine.conf]
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The path_php_server variable is /var/www/html/script_server.php
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The path_cactilog variable is /var/www/html/log/cacti.log
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The log_destination variable is 1 (FILE)
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The path_php variable is /usr/bin/php
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The availability_method variable is 2
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 3
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 2
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The ping_method variable is 2
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The ping_retries variable is 1
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 400
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The snmp_retries variable is 3
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 1
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The boost_redirect variable is 0
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The log_pstats variable is 1
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The threads variable is 2
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The polling interval is 300 seconds
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 1
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The script timeout is 25
12/21/2009 02:49:58 PM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 2
12/21/2009 02:49:58 PM - SPINE: Poller[0] FATAL: MySQL Error:'1064', Message:'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.99.10) LIMIT 1' at line 1' (Spine parent)

not sure what's going on - suggestions welcome.

[gandalf]

What are you trying to achive with the spine command you've posted?
R.

[darcym]

just a connection test, if there is a more correct way I'd be happy to be educated

[gandalf]

To poll a remote host, you need toknow the <host id> of that host. Then use spine like
spine <host id> <host id>
to poll that single host.
spine --help
should provide more information
R

[TheWitness]

The syntax is definitely not correct. I guess we should log a but on this one. If the user that posted, would please open a bug to have us perform more robust validation checks prior to accepting bad syntax, I would appreciate it: http://bugs.cacti.net

TheWitness

[MrRat]

I am getting syntax errors as well.

Code: Select all

02/04/2010 05:01:02 PM - SPINE: Poller[0] ERROR: SQL Failed! Error:'1064', Message:'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Ethernet0/6' interface' WHERE host_id='387' AND data_query_id='1' and arg1='.1.3' at line 1', SQL Fragment:'UPDATE poller_reindex SET assert_value='Adaptive Security Appliance 'Ethernet0/6' interface' WHERE host_id='387' AND data_query_id='1' and arg1='.1.3.6.1.2.1.2.2.1.2.10''
02/04/2010 05:01:27 PM - SPINE: Poller[0] ERROR: SQL Failed! Error:'1064', Message:'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Virtual254' interface' WHERE host_id='385' AND data_query_id='1' and arg1='.1.3.' at line 1', SQL Fragment:'UPDATE poller_reindex SET assert_value='Adaptive Security Appliance 'Virtual254' interface' WHERE host_id='385' AND data_query_id='1' and arg1='.1.3.6.1.2.1.2.2.1.2.10''
02/04/2010 05:01:27 PM - SPINE: Poller[0] ERROR: SQL Failed! Error:'1064', Message:'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Virtual254' interface' WHERE host_id='386' AND data_query_id='1' and arg1='.1.3.' at line 1', SQL Fragment:'UPDATE poller_reindex SET assert_value='Adaptive Security Appliance 'Virtual254' interface' WHERE host_id='386' AND data_query_id='1' and arg1='.1.3.6.1.2.1.2.2.1.2.10''

afaik the commands should be sent to mysql as

Code: Select all

UPDATE poller_reindex SET assert_value='Adaptive Security Appliance "Ethernet0/6" interface' WHERE host_id='387' AND data_query_id='1' and arg1='.1.3.6.1.2.1.2.2.1.2.10';

not

Code: Select all

UPDATE poller_reindex SET assert_value='Adaptive Security Appliance 'Ethernet0/6' interface' WHERE host_id='387' AND data_query_id='1' and arg1='.1.3.6.1.2.1.2.2.1.2.10';

[gandalf]

Correct find. Please open a bug
R.

[darcym]

has a bug been logged for this ?

if so any reference detail ? I can't see anything

Any sign of a patch ?

[darcym]

couldn't find a bug so I logged one myself now (thank you for the input debugging this)

the bug reference is 0001649

I'm ready to re-build the package with any fix to test this, it's a bit of a show stopper for me personally, so I've marked it as major.

First bug for cacti so sorry if I've got the priorities out of line.