Spine version 1.2.22

[Lalbee99]

I attempted to install spine version 1.2.22 and got the following when running the make

[root@XXXXXXXXX cacti-spine-1.2.22]# make
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2 -MT sql.o -MD -MP -MF .deps/sql.Tpo -c -o sql.o sql.c
sql.c: In function ‘db_connect’:
sql.c:353:6: error: ‘ssl_key’ undeclared (first use in this function)
if (ssl_key != NULL) {
^
sql.c:353:6: note: each undeclared identifier is reported only once for each function it appears in
sql.c:357:6: error: ‘ssl_ca’ undeclared (first use in this function)
if (ssl_ca != NULL) {
^
sql.c:361:6: error: ‘ssl_cert’ undeclared (first use in this function)
if (ssl_cert != NULL) {
^
make: *** [sql.o] Error 1

[Lalbee99]

Do not use Spine version 1.2.22 it has bugs. Just use the previous version 1.2.21

[TheWitness]

What bugs? To my knowledge the only issue with spine 1.2.22 is with compiling on real old MySQL/OS versions which has already been fixed. It's not a functional issue.

[Lalbee99]

There appears to be some type of typo/error in the spine code. It does not compile like previous versions

sql.c: In function ‘db_connect’:
sql.c:353:6: error: ‘ssl_key’ undeclared (first use in this function)
if (ssl_key != NULL) {

[ZBRR]

Hi, I'm using spine 1.2.22 and when i create a new graph or when i add a new device from automation gives me this error.

Error when i create a new graph:

2022-09-16 09:12:22 - CMDPHP PHP ERROR WARNING Backtrace: (/graphs_new.php[42]:form_save(), /graphs_new.php[172]:host_new_graphs_save(), /graphs_new.php[274]:create_save_graph(), /lib/template.php[2157]:push_out_host(), /lib/utility.php[794]:update_poller_cache(), /lib/utility.php[361]:api_poller_cache_item_add(), /lib/api_poller.php[97]:get_data_source_path(), /lib/functions.php[2634]:generate_data_source_path(), /lib/functions.php[2965]:CactiErrorHandler())
2022-09-16 09:12:22 - ERROR PHP WARNING: Undefined array key "id" in file: /var/www/cacti/lib/functions.php on line: 2965


Error when i add a new device from automation:

2022-09-15 10:18:05 - CMDPHP PHP ERROR WARNING Backtrace: (/poller_automation.php[367]:discoverDevices(), /poller_automation.php[696]:automation_add_device(), /lib/api_automation.php[3016]:api_device_save(), /lib/api_device.php[1108]:api_device_update_host_template(), /lib/api_device.php[1266]:run_data_query(), /lib/data_query.php[390]:automation_execute_data_query(), /lib/api_automation.php[2236]:create_dq_graphs(), /lib/api_automation.php[2663]:push_out_host(), /lib/utility.php[794]:update_poller_cache(), /lib/utility.php[361]:api_poller_cache_item_add(), /lib/api_poller.php[97]:get_data_source_path(), /lib/functions.php[2634]:generate_data_source_path(), /lib/functions.php[2965]:CactiErrorHandler())
2022-09-15 10:18:05 - ERROR PHP WARNING: Undefined array key "id" in file: /var/www/cacti/lib/functions.php on line: 2965

What i'm doing wrong?

[macan]

please report this on cacti github.

[TheWitness]

This is now fixed in the 1.2.x branch and will be a part of the 1.2.23 release.

[xandew]

Hello,

After adding 06 new servers (we have over 170) to our Cacti 1.2.22 and creating all their graphs, we hit that same issue for 01 of the graphs (among 24).
Is there a workaround I could follow, before 1.2.23 is released, to have that one missing graph fixed/plotted?

Thanks a lot,

Alex

[TheWitness]

Edit that file goto that line and change "id" to "host_id".

[Lalbee99]

Just to be clear hear is another issue brought up a while ago and no direction. I just downloaded the 1.2.22 spine just in case there was a fix implemented that was not published and attempted to install Same results:

[cacti-spine-1.2.22]# make
gcc -DHAVE_CONFIG_H -I. -I./config -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2 -MT sql.o -MD -MP -MF .deps/sql.Tpo -c -o sql.o sql.c
sql.c: In function ‘db_connect’:
sql.c:353:6: error: ‘ssl_key’ undeclared (first use in this function)
if (ssl_key != NULL) {
^
sql.c:353:6: note: each undeclared identifier is reported only once for each function it appears in
sql.c:357:6: error: ‘ssl_ca’ undeclared (first use in this function)
if (ssl_ca != NULL) {
^
sql.c:361:6: error: ‘ssl_cert’ undeclared (first use in this function)
if (ssl_cert != NULL) {
^
make: *** [sql.o] Error 1

[cacti-spine-1.2.22]# rpm -qa | grep -i maria
mariadb-server-5.5.68-1.el7.x86_64
mariadb-5.5.68-1.el7.x86_64
mariadb-devel-5.5.68-1.el7.x86_64
mariadb-libs-5.5.68-1.el7.x86_64

[Lalbee99]

So spine 1.2.22 will compile under RHEL 8 with no errors (although the help2man pre-req has changed repo location between RHEL7 and RHEL8. It is now located in the codeready-builder-for-rhel-8-x86_64-rpms repo.

[TheWitness]

@netniv just did a critical fix in the 1.2.x branch. Be forewarned.

[xandew]

Edit that file goto that line and change "id" to "host_id".

Hi there,

Sorry for the delay in replying, too many things going on on the same time...

Yup, as you expected, that resolved the issue.
Thanks a lot for your quick reply...!

Alex