Spine Compile Issues Here

[TheWitness]

Hi all

I found out one script:
http://forums.cacti.net/viewtopic.php?t ... nmp+memory

cannot work in this 0.8.7 version due to the above application rely information from config.php. Now the 0.8.7 information is stored in global.php instead.

SH

Please edit the post and supply the fix. The author should be taking care of this.

TheWitness

[TheWitness]

"Solved" this error by symlinking libmysqlclient.a to libmysqlclient_r.a
and libmysqlclient.la to libmysqlclient_r.la.

TheWitness: I've configured an installed MySQL just as mentioned here: http://www.cacti.net/spine_install_wincyg.php, but is does not install the thread safe version of MySQL client libraries.
Normaly i use cactid with the native MySQL binary.

Will there be a Windows spine binary out anytime soon?
I don't like compiling/running net-snmp and MySQL-client in cygwin, when i have the native binaries also installed.

Edit, i'm using:

Code: Select all

$ uname -a
CYGWIN_NT-5.2 srvman 1.5.24(0.156/4/2) 2007-01-31 10:57 i686 Cygwin

(Windows 2003 SP1, with cygwin 1.5.24.

This method is not advised. Look in the README-WINDOWS file. You will find a reference to the mysql configure. Something like this. Don't symlink.

Code: Select all

./configure --without-server --enable-thread-safe-client

[YoMarK]

Allright, I think that you should include this (very useful) information for other users in the http://www.cacti.net/spine_install_wincyg.php howto.

Anyway, will there be a Windows spine binary released anytime soon?

Thanks for this great software!

[swinn]

Allright, I think that you should include this (very useful) information for other users in the http://www.cacti.net/spine_install_wincyg.php howto.

Anyway, will there be a Windows spine binary released anytime soon?

Thanks for this great software!

The README-WINDOWS file that is included with the source has the full set of commands to compile under Windows.

The compiled Spine 0.8.7 can be found in this thread: http://forums.cacti.net/viewtopic.php?t=23934

Edit: Changed to show thread where Win32 binary can be found.

[menardk]

It seems that updating the 'Maximum OID's Per Get Request' under the device configuration does not actually update the value. When you open the device's settings page again it remains the same. However if you go up a level and checkmark the device and select 'Change SNMP Options' from the action drop down and change it there for the device then that will update the 'Maximum OID's Per Get Request' option for the device in question.

[rony]

Is it ok to intermittently get this error:
ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id=Get Processor Utilization and snmp_query_graph_rrd.data_template_id=78 and data_template_rrd.local_data_id=50"

SH

Where on the utilities page? What action where you performing.

[Smux]

Hi,

How I do to solve this error with spine?

Code: Select all

root@svr03 [/home/sysmon/cacti-spine-0.8.7]# /usr/local/spine/bin/spine --conf /usr/local/spine/etc/spine.conf
SPINE: Using spine config file [/usr/local/spine/etc/spine.conf]
SPINE: Version 0.8.7 starting
10/25/2007 12:50:46 PM - SPINE: Poller[0] ERROR: SNMP Library Version Mismatch (5.4.1 vs 5.3) (Spine parent)
root@svr03 [/home/sysmon/cacti-spine-0.8.7]# snmpget --version
NET-SNMP version: 5.4

Thanks!

[super-hornet]

Hi all

I found out one script:
http://forums.cacti.net/viewtopic.php?t ... nmp+memory

cannot work in this 0.8.7 version due to the above application rely information from config.php. Now the 0.8.7 information is stored in global.php instead.

SH

Please edit the post and supply the fix. The author should be taking care of this.

TheWitness

I did a quick modification on the original php files and already uploaded to the original post.
Do u want me to upload to this thread also?

SH

[rony]

No, just the original post. This thread is getting ugly fast.

[super-hornet]

Is it ok to intermittently get this error:
ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id=Get Processor Utilization and snmp_query_graph_rrd.data_template_id=78 and data_template_rrd.local_data_id=50"

SH

Where on the utilities page? What action where you performing.

Hi. That error message I got from the cacti log. So far, I only do a normal SNMP queries. If u want to know more, please tell me where can I dig out more information or what information do u need in order to debug it?

SH

[rony]

Really, so it has no correspondence to the Utilities page?

Have you attempted to Rebuild your Poller Cache from the Utilities page?

[super-hornet]

Ok. I will try to rebuild it....once I got back to office
Will let u know later.

SH

[TheWitness]

Is it ok to intermittently get this error:
ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id=Get Processor Utilization and snmp_query_graph_rrd.data_template_id=78 and data_template_rrd.local_data_id=50"

SH

Where on the utilities page? What action where you performing.

Hi. That error message I got from the cacti log. So far, I only do a normal SNMP queries. If u want to know more, please tell me where can I dig out more information or what information do u need in order to debug it?

SH

Rony and I had a CC this evening. We identified the source. He will be posting a patch soon to address this.

TheWitness

[rony]

This is a bug...

http://bugs.cacti.net/view.php?id=1051

I have submitted it.

Working on it, will have patched files available in the bug reports for testing.

[rony]

Is it ok to intermittently get this error:
ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id=Get Processor Utilization and snmp_query_graph_rrd.data_template_id=78 and data_template_rrd.local_data_id=50"

SH

Where on the utilities page? What action where you performing.

Hi. That error message I got from the cacti log. So far, I only do a normal SNMP queries. If u want to know more, please tell me where can I dig out more information or what information do u need in order to debug it?

SH

Run the following query and attach to the bug report: http://bugs.cacti.net/view.php?id=1051

Code: Select all

select data_input_data.data_template_data_id, data_input_fields.type_code, data_input_data.value
from (data_input_fields,data_input_data)
where data_input_fields.id=data_input_data.data_input_field_id
and (data_input_fields.type_code='index_type' or data_input_fields.type_code='index_value' or data_input_fields.type_code='output_type');