Nagios Support Forum

Have tried the upgrade from 5.8.4 to 5.8.5 twice through the GUI on our staging server, and both times failed.

I grabbed what was in the upgrade window the second time:

---- Starting Nagios XI Backup ----
No entry for terminal type "unknown";
using dumb terminal settings.
\nStarting new backup....\n
Backing up Nagios Core...
tar: Removing leading `/' from member names
tar: /usr/local/nagios/var/rw/nagios.qh: socket ignored
Backing up Nagios XI...
tar: Removing leading `/' from member names
Backing up MRTG...
tar: Removing leading `/' from member names
Backing up the SNMP directories
tar: Removing leading `/' from member names
tar: Removing leading `/' from member names
Backing up NRDP...
tar: Removing leading `/' from member names
Backing up Nagvis...
tar: Removing leading `/' from member names
Backing up nagios user home dir...
tar: Removing leading `/' from member names
Backing up MySQL databases...
Backing up cronjobs for Apache...
Backing up logrotate config files...
Backing up Apache config files...
Compressing backup...

===============
BACKUP COMPLETE
===============
Backup stored in /store/backups/nagiosxi/autoupgrade_backup.1626876665.tar.gz

---- Starting Nagios XI Upgrade ----
Cleaning up temp directory...
No entry for terminal type "unknown";
using dumb terminal settings.
Nagios XI Upgrade Log
==========================
DATE: Wed Jul 21 10:12:25 EDT 2021

DISTRO INFO:
RedHatEnterpriseServer
7.9
x86_64


No entry for terminal type "unknown";
using dumb terminal settings.
Archive: sourceguardian/ixed4.lin.x86-64.zip
inflating: /usr/lib64/php/modules/ixed.5.4.lin
Sourceguardian extension found for PHP version 5.4
Sourceguardian extension already in php.ini
No entry for terminal type "unknown";
using dumb terminal settings.
Checking required prereqs...
Please wait...

OLD VERSION: 5804
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-
: manager
No packages marked for update
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-
: manager
Package php-imap-5.4.16-7.el7.x86_64 already installed and latest version
Nothing to do
UPGRADE: NDO is being upgraded...
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for a BSD-compatible install... /usr/bin/install -c
checking how to run the C preprocessor... gcc -E
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for stdlib.h... (cached) yes
checking stdio.h usability... yes
checking stdio.h presence... yes
checking for stdio.h... yes
checking for string.h... (cached) yes
checking mysql/mysql.h usability... no
checking mysql/mysql.h presence... no
checking for mysql/mysql.h... no
configure: error: Can't locate mysql headers

Server has been up 29 days
Red Hat Enterprise Linux Server release 7.9 (Maipo)
Nagios XI version: 5.8.4

The manual upgrade may work, I normally ask for a snapshot prior, but I'd like to do upgrades through the GUI, especially in Prod.

Unless this version is a security fix, I can wait to upgrade...

Thanks,

Craig

Hi Craig,

There are quite a few security updates in this release, so it's a good idea to get your main system upgraded. Here's the changelog.

https://www.nagios.com/downloads/nagios-xi/change-log/

I reached to the team here and that error means the mysql/mariadb devel packages are not available on this system. Are you using a custom setup or what type of installation is this?

Please run the following command and post the output to check the installed database packages. Thanks, Ben

I believe the original installation was from an offline install package, 5.7.2, if I recall correctly...

Results from yum installed:

mariadb.x86_64 1:5.5.68-1.el7 @rhel-7-server-rpms
mariadb-libs.x86_64 1:5.5.68-1.el7 @rhel-7-server-rpms
mariadb-server.x86_64 1:5.5.68-1.el7 @rhel-7-server-rpms

Checked yum available 64 bit:

mariadb-bench.x86_64 1:5.5.68-1.el7 rhel-7-server-rpms
mariadb-devel.x86_64 1:5.5.68-1.el7 rhel-7-server-rpms
mariadb-embedded.x86_64 1:5.5.68-1.el7 rhel-7-server-optional-rpms
mariadb-embedded-devel.x86_64 1:5.5.68-1.el7 rhel-7-server-optional-rpms
mariadb-test.x86_64 1:5.5.68-1.el7 rhel-7-server-rpms

So which ones do we need installed to resolve the patch install fail?

Thanks,

Craig

Hi

Please install mariadb-devel.x86_64 1:5.5.68-1.el7 rhel-7-server-rpms,
that will provide the mysql headers.

Once installed run the upgrade again and let us knos how it works out.

Thanks

That did it, curious why the missing module wasn't included in the offline installation package?

Thanks for the resolution and quick response!

Craig

Hi,

Glad it's working! I will talk to the dev guys about including that maria-db-devel
package in the future.

Locking this.

Thanks!