Mysql isn't installed since at some point in the past it was renamed to mariadb, but I'd expect the upgrade to still succeed. I upgraded a system in another environment yesterday to 5.8.3 from 5.6 or .7 something w/o errors.
I thought maybe this was an offline install, which might be the case, but from what I was told in the past about how to tell if it's an offline install conflicts somewhat with what I see when testing. Can you have a look at the output below and point me in the right direction?
Thanks!
# ./upgrade
IMPORTANT: Before upgrading, verify you have both a valid system backup as well as a configuration backup
of Nagios XI before continuing! More information about backing up and restoring Nagios XI can be found here:
https://assets.nagios.com/downloads/nag ... ios-XI.pdf
NOTICE: Your Nagios XI license includes a test environment instance that allows you to verify successful upgrade and configuration
changes before applying them to your production environment. As a best practice for ensuring the reliability of your monitoring systems,
we advise you to upgrade your test environment before upgrading any production instances. More information on licensing can be found here:
https://assets.nagios.com/handouts/nagi ... Policy.pdf
Are you sure you want to continue? [y/N] y
Proceeding with upgrade...
Nagios XI Upgrade Log
==========================
DATE: Fri Jun 11 19:48:33 UTC 2021
DISTRO INFO:
RedHatEnterpriseServer
7.8
x86_64
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
Checking required prereqs...
Please wait...
OLD VERSION: 5400
Loaded plugins: enabled_repos_upload, package_upload, product-id, search-
: disabled-repos, subscription-manager
Package php-imap-5.4.16-9.el7.x86_64 already installed and latest version
Nothing to do
Uploading Enabled Repositories Report
Loaded plugins: product-id, subscription-manager
Loaded plugins: enabled_repos_upload, package_upload, product-id, search-
: disabled-repos, subscription-manager
Package git-1.8.3.1-23.el7_8.x86_64 already installed and latest version
Nothing to do
Uploading Enabled Repositories Report
Loaded plugins: product-id, subscription-manager
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... /bin/install -c
checking how to run the C preprocessor... gcc -E
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /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... configure: error: Can't locate mysql headers
no
checking for mysql/mysql.h... no
# locate mysql.h
# find / -name mysql.h
find: ‘/proc/22009’: No such file or directory
find: ‘/proc/22384’: No such file or directory
find: ‘/proc/22385’: No such file or directory
find: ‘/proc/22392’: No such file or directory
find: ‘/proc/22393’: No such file or directory
# rpm -qa | grep nagiosxi
nagiosxi-nrpe-5-4.0.2.el7.x86_64
nagiosxi-nagiosql-5-4.0.2.el7.x86_64
nagiosxi-nagioscore-5-4.0.2.el7.x86_64
nagiosxi-nrds-5-4.0.2.el7.x86_64
nagiosxi-nagiosmobile-5-4.0.2.el7.x86_64
nagiosxi-nagiosplugins-5-4.0.2.el7.x86_64
nagiosxi-ndoutils-5-4.0.2.el7.x86_64
nagiosxi-mrtg-5-4.0.2.el7.x86_64
nagiosxi-wmic-5-4.0.2.el7.x86_64
nagiosxi-nagvis-5-4.0.2.el7.x86_64
nagiosxi-ajaxterm-5-4.0.2.el7.x86_64
nagiosxi-nsca-5-4.0.2.el7.x86_64
nagiosxi-wkhtmltox-5-4.0.2.el7.x86_64
nagiosxi-pnp-5-4.0.2.el7.x86_64
#
Upgrade from 5.4.0 to 5.8.4 fails on a mysql.h test
Re: Upgrade from 5.4.0 to 5.8.4 fails on a mysql.h test
You were on the right track, locating mysql/mysql.h, but in order to figure out which package provides that file, you'd use "yum provides"
Please try installing either mysql-devel or mariadb-connector-c-devel in order to proceed with the installation.
Code: Select all
# yum provides '*/mysql/mysql.h'
Last metadata expiration check: 3:37:41 ago on Thu 10 Jun 2021 10:12:48 PM CDT.
mariadb-connector-c-devel-3.1.11-2.el8_3.i686 : Development files for mariadb-connector-c
Repo : appstream
Matched from:
Filename : /usr/include/mysql/mysql.h
mariadb-connector-c-devel-3.1.11-2.el8_3.x86_64 : Development files for mariadb-connector-c
Repo : appstream
Matched from:
Filename : /usr/include/mysql/mysql.h
mysql-devel-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 : Files for development of MySQL applications
Repo : @System
Matched from:
Filename : /usr/include/mysql/mysql.h
mysql-devel-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 : Files for development of MySQL applications
Repo : appstream
Matched from:
Filename : /usr/include/mysql/mysql.h
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Re: Upgrade from 5.4.0 to 5.8.4 fails on a mysql.h test
The test for whether it's an offline or online install (from your support) is below. Since it shows more than deps, it's supposed to be offline. However, since nagiosxi-5-4.13.el7.x86_64 (disregarding the minor version) isn't included, and it was highlighted by support, I'm a bit confused.
My understanding is that an offline install can't be updated using the online process. Thus, I need to determine which procedure to use.
From support:
If you run this command:
If it only outputs the deps then it's a source install:
[root@xid ~]# rpm -qa | grep nagiosxi
nagiosxi-deps-el7-5.5.2-1.noarch
rpm -qa | grep nagios
And you see something like this:
[root@xid ~]# rpm -qa | grep nagiosxi
nagiosxi-nagiosmobile-5-4.13.el7.x86_64
nagiosxi-nagiosplugins-5-4.13.el7.x86_64
nagiosxi-mrtg-5-4.13.el7.x86_64
nagiosxi-nagiosql-5-4.13.el7.x86_64
nagiosxi-nrds-5-4.13.el7.x86_64
nagiosxi-wkhtmltox-5-4.13.el7.x86_64
nagiosxi-5-4.13.el7.x86_64 # This line is the bold one
nagiosxi-nagioscore-5-4.13.el7.x86_64
nagiosxi-ajaxterm-5-4.13.el7.x86_64
nagiosxi-ndoutils-5-4.13.el7.x86_64
nagiosxi-wmic-5-4.13.el7.x86_64
nagiosxi-nsca-5-4.13.el7.x86_64
nagiosxi-nrpe-5-4.13.el7.x86_64
nagiosxi-nagvis-5-4.13.el7.x86_64
nagiosxi-pnp-5-4.13.el7.x86_64
Then it's an offline install, the one in bold is the main XI package.
My understanding is that an offline install can't be updated using the online process. Thus, I need to determine which procedure to use.
From support:
If you run this command:
If it only outputs the deps then it's a source install:
[root@xid ~]# rpm -qa | grep nagiosxi
nagiosxi-deps-el7-5.5.2-1.noarch
rpm -qa | grep nagios
And you see something like this:
[root@xid ~]# rpm -qa | grep nagiosxi
nagiosxi-nagiosmobile-5-4.13.el7.x86_64
nagiosxi-nagiosplugins-5-4.13.el7.x86_64
nagiosxi-mrtg-5-4.13.el7.x86_64
nagiosxi-nagiosql-5-4.13.el7.x86_64
nagiosxi-nrds-5-4.13.el7.x86_64
nagiosxi-wkhtmltox-5-4.13.el7.x86_64
nagiosxi-5-4.13.el7.x86_64 # This line is the bold one
nagiosxi-nagioscore-5-4.13.el7.x86_64
nagiosxi-ajaxterm-5-4.13.el7.x86_64
nagiosxi-ndoutils-5-4.13.el7.x86_64
nagiosxi-wmic-5-4.13.el7.x86_64
nagiosxi-nsca-5-4.13.el7.x86_64
nagiosxi-nrpe-5-4.13.el7.x86_64
nagiosxi-nagvis-5-4.13.el7.x86_64
nagiosxi-pnp-5-4.13.el7.x86_64
Then it's an offline install, the one in bold is the main XI package.
Re: Upgrade from 5.4.0 to 5.8.4 fails on a mysql.h test
There's not really much distinction between an offline install and one installed using the online package repository at repo.nagios.com. They're pretty much alike in that upgrading the individual packages upgrades the system.
If you have the online repo set up and enabled, a simple "yum update" should pull and update the appropriate packages.
The source install (see Installing Nagios XI Manually on Linux) is a little different to upgrade. Use /usr/local/nagiosxi/scripts/upgrade_to_latest.sh (as root) to upgrade that.
/usr/local/nagiosxi/scripts/upgrade_to_latest.sh can be used to upgrade either. This is also the script called when upgrading the system thru the web interface.
See https://repo.nagios.com/ for instructions.
If you have the online repo set up and enabled, a simple "yum update" should pull and update the appropriate packages.
The source install (see Installing Nagios XI Manually on Linux) is a little different to upgrade. Use /usr/local/nagiosxi/scripts/upgrade_to_latest.sh (as root) to upgrade that.
/usr/local/nagiosxi/scripts/upgrade_to_latest.sh can be used to upgrade either. This is also the script called when upgrading the system thru the web interface.
See https://repo.nagios.com/ for instructions.
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Re: Upgrade from 5.4.0 to 5.8.4 fails on a mysql.h test
Ok,
I had to install a few things to get the upgrade to complete:
yum install mariadb-devel patch gd-devel
nrpe is disabled by the upgrade which seems odd, and I had a ghost nrpe running on each system that caused it to not start. Killing it and restarting solved that.
The only other odd thing was that check_vmware_api.pl complained about not finding Functions.pm after the upgrade. It was an issue w/ perl-Nagios-Monitoring-Plugin and perl-Nagios-Plugin. I had to revert to a version of the script using perl-Nagios-Plugin.
It's all good now, thanks!
I had to install a few things to get the upgrade to complete:
yum install mariadb-devel patch gd-devel
nrpe is disabled by the upgrade which seems odd, and I had a ghost nrpe running on each system that caused it to not start. Killing it and restarting solved that.
The only other odd thing was that check_vmware_api.pl complained about not finding Functions.pm after the upgrade. It was an issue w/ perl-Nagios-Monitoring-Plugin and perl-Nagios-Plugin. I had to revert to a version of the script using perl-Nagios-Plugin.
It's all good now, thanks!
-
scottwilkerson
- DevOps Engineer
- Posts: 19396
- Joined: Tue Nov 15, 2011 3:11 pm
- Location: Nagios Enterprises
- Contact:
Re: Upgrade from 5.4.0 to 5.8.4 fails on a mysql.h test
Locking threadgormank wrote:Ok,
I had to install a few things to get the upgrade to complete:
yum install mariadb-devel patch gd-devel
nrpe is disabled by the upgrade which seems odd, and I had a ghost nrpe running on each system that caused it to not start. Killing it and restarting solved that.
The only other odd thing was that check_vmware_api.pl complained about not finding Functions.pm after the upgrade. It was an issue w/ perl-Nagios-Monitoring-Plugin and perl-Nagios-Plugin. I had to revert to a version of the script using perl-Nagios-Plugin.
It's all good now, thanks!