Issue with Spine install on Centos 7

[vennerd]

Hi
I'm a bit of a novice when it comes to linux but learning as I go.
I have been able to install Cacti 1.1.7 with no problems but cannot get spine to install.
When running the make command I keep getting this error:
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/include/mysql -g -O2 -MT error.o -MD -MP -MF .deps/error.Tpo -c -o error.o error.c
mv -f .deps/error.Tpo .deps/error.Po
/bin/sh ./libtool --tag=CC --mode=link gcc -I/usr/include/mysql -g -O2 -L/usr/lib64 -lpthread -lssl -lm -o spine sql.o spine.o util.o snmp.o locks.o poller.o nft_popen.o php.o ping.o keywords.o error.o -lmysqlclient -lcrypto -lz -lpthread -lm
libtool: link: gcc -I/usr/include/mysql -g -O2 -o spine sql.o spine.o util.o snmp.o locks.o poller.o nft_popen.o php.o ping.o keywords.o error.o -L/usr/lib64 -lssl -lmysqlclient -lcrypto -lz -lpthread -lm
/usr/bin/ld: cannot find -lmysqlclient
collect2: error: ld returned 1 exit status
make: *** [spine] Error 1

I have used various posts and believe all necessary prerequisites(libraries) are installed but may be I'm missing something.

OS is Centos 7 and running mariadb(mysql) 10.2.x.

[izmenoff]

I have the same problem!
CentOS 7
MariaDB 10.2.6
All dependenses installed

When I used MariaDB 5.5, spine has been installed without any problem.
Can anyone help?
Thanks

[Rno]

did you have the mariadb-client package instaled ?
the mariadb-common dosen't give you the client package

[izmenoff]

yes
MariaDB-common-10.2.6-1.el7.centos.x86_64
MariaDB-client-10.2.6-1.el7.centos.x86_64
MariaDB-shared-10.2.6-1.el7.centos.x86_64
MariaDB-server-10.2.6-1.el7.centos.x86_64
MariaDB-compat-10.2.6-1.el7.centos.x86_64
MariaDB-devel-10.2.6-1.el7.centos.x86_64

[phalek]

I guess 10.2 doesn't ship that anymore ( see here ):

Code: Select all

libmysqlclient has been removed from the server. It has been replaced by MariaDB’s own Connector/C.
- See more at: https://mariadb.com/resources/blog/mariadb-102-beta#sthash.oEQ5t8c0.dpuf

[Rno]

I find this information:
libmariadbclient18 MariaDB shared client libraries (required)
libmysqlclient18 meta-package to satisfy external dependencies (required)

[djluko]

I have the same problem - CentOS 7, MariaDB 10.2 from the MaraiDB repo. Here is the output of rpm -qa | grep -i maria:

Code: Select all

MariaDB-server-10.2.6-1.el7.centos.x86_64
MariaDB-common-10.2.6-1.el7.centos.x86_64
MariaDB-client-10.2.6-1.el7.centos.x86_64
MariaDB-devel-10.2.6-1.el7.centos.x86_64
MariaDB-compat-10.2.6-1.el7.centos.x86_64

I noticed the gcc command points to /usr/lib64, so checking that directory I can see libmariadbclient.a, so I changed the gcc command so it ran against libmariadbclient but it doesn't work:

Code: Select all

[root@localhost cacti-spine-1.1.6]# gcc -I/usr/include/mysql -g -O2 -o spine sql.o spine.o util.o snmp.o locks.o poller.o nft_popen.o php.o ping.o keywords.o error.o  -L/usr/lib64 -lssl -lmariadbclient -lcrypto -lz -lpthread -lm
/usr/bin/ld: /usr/lib64/libmariadbclient.a(ma_client_plugin.c.o): undefined reference to symbol 'dlclose@@GLIBC_2.2.5'
/usr/lib64/libdl.so.2: error adding symbols: DSO missing from command line
collect2: error: ld returned 1 exit status

Is it possible to compile Cacti against MariaDB 10.2.6 at all? If not then might have to go back to CentOS 6 (or Cacti-EZ)

[cigamit]

Is it possible to compile Cacti against MariaDB 10.2.6 at all? If not then might have to go back to CentOS 6 (or Cacti-EZ)

I haven't tested against 10.2 just yet, but 10.1 works just fine.

[phalek]

You can also just go back to 10.1 using the repository provided here:
https://downloads.mariadb.org/mariadb/r ... rsion=10.1 :

Code: Select all

# MariaDB 10.1 CentOS repository list - created 2017-06-08 05:08 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

[jt555]

I had the same issue on RHEL 7 and MariaDB 10.2.6.

I uninstalled MariaDB 10.2.6 and installed MariaDB 10.1.24:

Code: Select all

rpm -qa | grep Maria
MariaDB-common-10.1.24-1.el7.centos.x86_64
MariaDB-server-10.1.24-1.el7.centos.x86_64
MariaDB-client-10.1.24-1.el7.centos.x86_64
MariaDB-compat-10.1.24-1.el7.centos.x86_64
MariaDB-devel-10.1.24-1.el7.centos.x86_64

Make stopped at the same spot:

Code: Select all

gcc -DHAVE_CONFIG_H -I. -I./config     -I/usr/include/mysql -g -O2 -MT error.o -MD -MP -MF .deps/error.Tpo -c -o error.o error.c
mv -f .deps/error.Tpo .deps/error.Po
/bin/sh ./libtool  --tag=CC   --mode=link gcc  -I/usr/include/mysql -g -O2  -L/usr/lib64 -lpthread -lssl -lm  -o spine sql.o spine.o util.o snmp.o locks.o poller.o nft_popen.o php.o ping.o keywords.o error.o  -lnetsnmp -lmysqlclient -lcrypto -lz -lpthread -lm
libtool: link: gcc -I/usr/include/mysql -g -O2 -o spine sql.o spine.o util.o snmp.o locks.o poller.o nft_popen.o php.o ping.o keywords.o error.o  -L/usr/lib64 -lssl -lnetsnmp -lmysqlclient -lcrypto -lz -lpthread -lm
/bin/ld: /usr/lib64/libmysqlclient.a(client_plugin.c.o): undefined reference to symbol 'dlclose@@GLIBC_2.2.5'
/bin/ld: note: 'dlclose@@GLIBC_2.2.5' is defined in DSO /lib64/libdl.so.2 so try adding it to the linker command line
/lib64/libdl.so.2: could not read symbols: Invalid operation
collect2: error: ld returned 1 exit status
make: *** [spine] Error 1

I don't have much experience with GCC. Any help would be appreciated.
Am I missing something or is there a problem with compiling with MariaDB or RHEL7?

[vennerd]

Yes I ran the command: rpm -qa | grep -i maria and could see the following installed.

MariaDB-server-10.2.6-1.el7.centos.x86_64
MariaDB-common-10.2.6-1.el7.centos.x86_64
MariaDB-client-10.2.6-1.el7.centos.x86_64
MariaDB-devel-10.2.6-1.el7.centos.x86_64
MariaDB-compat-10.2.6-1.el7.centos.x86_64

If there is an issue with 10.2.x then how do you change it to use 10.1.x?
Do you have to backup any DB's, remove 10.2.x and then install 10.1 or is it possible to do a downgrade using the repository specified in a previous comment?

[jt555]

This is a brand new server with no databases. I'm building it specifically as a new instance of Cacti.

I uninstalled MariaDB 10.2.6 with "yum remove" for server and other packages. Not sure if you can downgrade a database.

Is there anybody here that has successfully compiled spine 1.1.9 on RHEL 7, with MariaDB 10.x?

[paulgevers]

Is there anybody here that has successfully compiled spine 1.1.9 on RHEL 7, with MariaDB 10.x?

I believe this is not possible to compile with MariaDB 10.2 or higher without changes in the cacti code. Somebody will need to work out what needs to be changed and shape it is such a form that it still works with older versions and MySQL.

This thread already lead to a bug in the cacti tracker: https://github.com/Cacti/cacti/issues/806

[jt555]

paulgevers, thanks for the answer.

Given the switch from MySQL to MariaDB on so many Linux flavors, I hope this gets fixed fairly soon.

I'm going to continue building RHEL 7, MariaDB 10.2.6, and the latest Cacti and hope that by the time I need spine, it will compile.

[izmenoff]

still not working in a new spine 1.1.11 release

/usr/bin/ld: cannot find -lmysqlclient
collect2: error: ld returned 1 exit status
make: *** [spine] Error 1

Developer sent me a message about it issue:

Just verified with MariaDB that this issue will be fixed in 10.2.7. It's not a spine issue