0.8.7i version of Spine not compiling under CentOS

[johng7777777]

Hi all,

I downloaded the latest source for version 0.8.7i of Spine. I have 0.8.7i version of Cacti installed that already came with the 3.1 PIA bundled in.

Now I am trying to install Spine on this version of CentOS:

[root@sflow cacti-spine-0.8.7i]# cat /etc/redhat-release
CentOS release 5.6 (Final)
[root@sflow cacti-spine-0.8.7i]#

I have the MySQL development RPM installed:

[root@sflow cacti-spine-0.8.7i]# rpm -qa | grep -i mysql
MySQL-client-5.5.21-1.linux2.6
MySQL-devel-5.5.21-1.linux2.6
MySQL-server-5.5.21-1.linux2.6
php53-mysql-5.3.3-1.el5_7.6
MySQL-shared-compat-5.5.21-1.linux2.6
[root@sflow cacti-spine-0.8.7i]#

The Spine configure script dies with:

checking sys/capability.h usability... yes
checking sys/capability.h presence... yes
checking for sys/capability.h... yes
checking whether we are using Linux Capabilities... no
checking for mysql_init in -lmysqlclient_r... no
configure: error: MySQL libraries not found

That file is here:

[root@sflow cacti-spine-0.8.7i]# locate mysqlclient_r
/usr/lib/libmysqlclient_r.so.10
/usr/lib/libmysqlclient_r.so.10.0.0
/usr/lib/libmysqlclient_r.so.12
/usr/lib/libmysqlclient_r.so.12.0.0
/usr/lib/libmysqlclient_r.so.14
/usr/lib/libmysqlclient_r.so.14.0.0
/usr/lib/libmysqlclient_r.so.15
/usr/lib/libmysqlclient_r.so.15.0.0
/usr/lib/libmysqlclient_r.so.16
/usr/lib/libmysqlclient_r.so.16.0.0
/usr/lib/mysql/libmysqlclient_r.a
[root@sflow cacti-spine-0.8.7i]#

And I have:

[root@sflow cacti-spine-0.8.7i]# export LDFLAGS='-L/usr/lib'
[root@sflow cacti-spine-0.8.7i]# echo $LDFLAGS
-L/usr/lib
[root@sflow cacti-spine-0.8.7i]#

So... any ideas? Is MySQL 5.5 RPM (downloaded direct from Mysql website) too new for this version of Spine? Any thoughts, insight, etc would be AWEsome as I need to get this large install box of Cacti deployed asap.

thx
jg

[johng7777777]

Update--

I uninstalled the 5.5 versions of the MySQL RPMs and installed the 5.0 RPMs using YUM. Now I can get Spine to compile and it installed fine. Now what I am dealing with is that Spine is not running it seems. I have updated the poller in Cacti along with the binary path and it is not being spawned from what I can tell...

Any ideas? There is nothing in the log.

Thanks
jg

[noname]

checking for mysql_init in -lmysqlclient_r... no
configure: error: MySQL libraries not found

Try this:

Code: Select all

# LDFLAGS=-L/usr/lib/mysql ./configure --with-mysql=/usr/include/mysql

See also: http://forums.cacti.net/viewtopic.php?f=5&t=43212

[johng7777777]

Thanks... I have spine working now.

Cheers,
jg