Nagiosxi Upgrade failed from 5.10.0 to 5.11.2

[ram.bhatta]

Hi Team,

We are getting below error while upgrading nagiosxi from 5.10 to 5.11
I have tried troubleshooting provided in your community portal but no luck.
I have followed DB repaire script also no luck
https://assets.nagios.com/downloads/nag ... tabase.pdf

Please help us to resolve this issue.

version.ndo.c: In function ‘ndo_process_ndo_config_line’:
ndo.c:858:35: error: ‘SSL_MODE_REQUIRED’ undeclared (first use in this function)
*mysql_opt_ssl_mode = SSL_MODE_REQUIRED;
^
ndo.c:858:35: note: each undeclared identifier is reported only once for each function it appears in
ndo.c:862:35: error: ‘SSL_MODE_DISABLED’ undeclared (first use in this function)
*mysql_opt_ssl_mode = SSL_MODE_DISABLED;
^
ndo.c:865:35: error: ‘SSL_MODE_PREFERRED’ undeclared (first use in this function)
*mysql_opt_ssl_mode = SSL_MODE_PREFERRED;
^
ndo.c:868:35: error: ‘SSL_MODE_VERIFY_CA’ undeclared (first use in this function)
*mysql_opt_ssl_mode = SSL_MODE_VERIFY_CA;
^
ndo.c:871:35: error: ‘SSL_MODE_VERIFY_IDENTITY’ undeclared (first use in this function)
*mysql_opt_ssl_mode = SSL_MODE_VERIFY_IDENTITY;
^
ndo.c: In function ‘ndo_connect_database’:
ndo.c:975:36: error: ‘MYSQL_OPT_SSL_MODE’ undeclared (first use in this function)
mysql_options(q_ctx->conn, MYSQL_OPT_SSL_MODE, mysql_opt_ssl_mode);
^
ndo.c:980:36: error: ‘MYSQL_OPT_TLS_CIPHERSUITES’ undeclared (first use in this function)
mysql_options(q_ctx->conn, MYSQL_OPT_TLS_CIPHERSUITES, mysql_opt_tls_ciphersuites);
^
ndo.c:985:36: error: ‘MYSQL_OPT_TLS_VERSION’ undeclared (first use in this function)
mysql_options(q_ctx->conn, MYSQL_OPT_TLS_VERSION, mysql_opt_tls_version);

[danderson]

Can you provide more information on which distribution this is on and which packages are installed?

[ram.bhatta]

OS :
Oracle Linux Server release 7.9
Kernel - 5.4.17-2136.324.5.3.el7uek.x86_64 #2 SMP Tue Oct 10 12:44:19 PDT 2023 x86_64 x86_64 x86_64 GNU/Linux
NagiosXI - 5.10.0

[danderson]

Is the package "mariadb-devel" installed? You can check with yum list installed mariadb-devel

[ram.bhatta]

Please find details below .
[root@XXXXXXXXX1 ~]# yum list installed mariadb-devel
Loaded plugins: rhnplugin
This system is receiving updates from Spacewalk server.
Installed Packages
MariaDB-devel.x86_64 10.2.7-1.el7.centos @maria_db_rhel7_x86_64

[danderson]

Those errors you posted are not a result of something wrong with your database, but it seems to be missing dependencies. I assumed that "mariadb-devel" would be the missing package, but I do not know how your server is configured. I would ensure that all the required dependencies are installed on the system.

[ram.bhatta]

This server is running from more than 2 years, and we have upgraded XI multiple times never face any challenges.
This is first time, when we are seeing this weired error while applying new updates released - 5.11.2.
If it would have dependencies missing, we would not have able to upgrade last version which was from 5.9.* to 5.10.*.

Is there any specific changes happened in this version, which is making DB to check SSL secure. - Just a thought.

Do we need any specific pre-requisite? for 5.11.* version.

[danderson]

We upgraded NDO in 5.11.0 to version 3.1.0. I'm guessing there's some issue with that. I will investigate and try to replicate this issue. If I can't replicate it then there isn't much I can do.

[ram.bhatta]

Thanks for update but I guess issue is with NDO only this is what breaking every time during the upgrade.
Will wait for your update.

[ram.bhatta]

Hello Team,
DO you have any update.