Update to XI version 5.6.5

[rferebee]

Hello,

I tried to update my test server to version 5.6.5 this afternoon and I got some funky errors I haven't seen before:

2019-08-05 15:00:21 (42.4 MB/s) - ‘/tmp/xi-latest.tar.gz’ saved [58048805/58048805]

Running upgrade
Nagios XI Upgrade Log
==========================
DATE: Mon Aug 5 15:00:23 PDT 2019

DISTRO INFO:
CentOS
7.6.1810
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: 5603
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: mirrors.vcea.wsu.edu
* epel: mirrors.sonic.net
* extras: repo.ialab.dsu.edu
* updates: centos.mirror.ndchost.com
No packages marked for update
Loaded plugins: fastestmirror, langpacks
Examining /tmp/nagiosxi/nagiosxi-deps-el7-5.6.5-1.noarch.rpm: nagiosxi-deps-el7-5.6.5-1.noarch
Marking /tmp/nagiosxi/nagiosxi-deps-el7-5.6.5-1.noarch.rpm as an update to nagiosxi-deps-el7-5.6.3-1.noarch
Resolving Dependencies
--> Running transaction check
---> Package nagiosxi-deps-el7.noarch 0:5.6.3-1 will be updated
---> Package nagiosxi-deps-el7.noarch 0:5.6.5-1 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Updating:
nagiosxi-deps-el7 noarch 5.6.5-1 /nagiosxi-deps-el7-5.6.5-1.noarch 0.0

Transaction Summary
================================================================================
Upgrade 1 Package

Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Updating : nagiosxi-deps-el7-5.6.5-1.noarch 1/2
Cleanup : nagiosxi-deps-el7-5.6.3-1.noarch 2/2
Verifying : nagiosxi-deps-el7-5.6.5-1.noarch 1/2
Verifying : nagiosxi-deps-el7-5.6.3-1.noarch 2/2

Updated:
nagiosxi-deps-el7.noarch 0:5.6.5-1

Complete!
UPGRADE: NRDP is being upgraded...
UPGRADE: NRDP upgraded OK.
UPGRADE: NRDP is being upgraded...
UPGRADE: NRDP upgraded OK.
no crontab for nagios
no crontab for root
Copying over new XI directory...
Patching NDOUtils...
NDOUtils already patched at level 103
Updating sequences...
Nagios XI Postgres Database Sequence Information

OLD VALUES
--------------
xi_commands_command_id_seq = 38045
xi_events_event_id_seq = 2947115
xi_meta_meta_id_seq = 2947254
xi_options_option_id_seq = 309
xi_sysstat_sysstat_id_seq = 101
xi_usermeta_usermeta_id_seq = 10885
xi_users_user_id_seq = 282

NEW VALUES
--------------
xi_commands_command_id_seq = 38045
xi_events_event_id_seq = 2947115
xi_meta_meta_id_seq = 2947254
xi_options_option_id_seq = 309
xi_sysstat_sysstat_id_seq = 101
xi_usermeta_usermeta_id_seq = 10885
xi_users_user_id_seq = 282

Installing new PNP templates...
Enabling large install tweaks...
Fixing config file permissions...
chown: cannot access ‘/var/www/html/nagiosql/config’: No such file or directory
Fixing htpasswd permissions...
Checking group memberships...
Installing new XI templates...

--- reset_config_perms.sh ------------
> Setting script permissions
> Setting CCM script permissions
> Setting special script permissions
> Setting special component script permissions
> Setting configuration file/directory permissions
> Setting perfdata directory and RRD permissions
> Setting libexec directory permissions
> Setting Nagios XI config permissions
> Setting NOM checkpoint user:group permissions
> + Setting CCM configuration file user:group permissions
> + Setting Recurring Downtime file user:group permissions
> + Setting BPI configuration file user:group permissions
--------------------------------------

--- ccm_import.php -------------------
> Setting import directory: /usr/local/nagios/etc/import/
> Importing config files into the CCM
- Importing: /usr/local/nagios/etc/import/xi_timeperiod_24x7.cfg .. SUCCESS
--------------------------------------

--- ccm_export.php -------------------
> Writing CCM configuration to Nagios files
<p><pre>SQL Error [nagiosxi] : ERROR: syntax error at or near "successMessage"
LINE 1: ...successfully written!</span><br><br><span class=\'successMes...
^</pre></p>
Finished writing out configuraton
--------------------------------------

--------------------------------------
> Verifying configuration with Nagios Core
> Output:
Nagios Core 4.4.3
Copyright (c) 2009-present Nagios Core Development Team and Community Contributors
Copyright (c) 1999-2009 Ethan Galstad
Last Modified: 2019-01-15
License: GPL

Website: https://www.nagios.org
Reading configuration data...
Read main config file okay...
Warning: Duplicate definition found for service 'OWA HTTPS' on host 'ccexch04.state.nv.us' (config file '/usr/local/nagios/etc/services/ccexch04.state.nv.us.cfg', starting on line 84)
Warning: Duplicate definition found for service 'Check Avail Mem' on host 'cbtapprod' (config file '/usr/local/nagios/etc/services/cbtapprod.cfg', starting on line 16)
Warning: Duplicate definition found for service 'Ping' on host 'petra' (config file '/usr/local/nagios/etc/services/petra.cfg', starting on line 241)
Warning: Duplicate definition found for service 'Disk Check /u01/dbs' on host 'sage' (config file '/usr/local/nagios/etc/services/sage.cfg', starting on line 136)
Warning: Duplicate definition found for service 'Disk Check /' on host 'sage' (config file '/usr/local/nagios/etc/services/sage.cfg', starting on line 46)
Warning: Duplicate definition found for service 'OWA HTTPS' on host 'ccexch02.state.nv.us' (config file '/usr/local/nagios/etc/services/ccexch02.state.nv.us.cfg', starting on line 84)
Warning: Duplicate definition found for service 'Ping' on host 'neatse2.state.nv.us' (config file '/usr/local/nagios/etc/services/neatse2.state.nv.us.cfg', starting on line 147)
Warning: Duplicate definition found for service 'Ping' on host 'adaud' (config file '/usr/local/nagios/etc/services/adaud.cfg', starting on line 31)
Warning: Duplicate definition found for service 'Ping' on host 'sql12' (config file '/usr/local/nagios/etc/services/rogue.cfg', starting on line 256)
Warning: Duplicate definition found for service 'Ping' on host 'sage' (config file '/usr/local/nagios/etc/services/rogue.cfg', starting on line 256)
Warning: Duplicate definition found for service 'Ping' on host 'newjubilee' (config file '/usr/local/nagios/etc/services/rogue.cfg', starting on line 256)
Warning: Duplicate definition found for service 'Ping' on host 'lotus' (config file '/usr/local/nagios/etc/services/rogue.cfg', starting on line 256)
Warning: Duplicate definition found for service 'Ping' on host 'ektronprod1a.web' (config file '/usr/local/nagios/etc/services/rogue.cfg', starting on line 256)
Warning: Duplicate definition found for service 'Ping' on host 'ektrondev2' (config file '/usr/local/nagios/etc/services/rogue.cfg', starting on line 256)
Warning: Duplicate definition found for service 'Ping' on host 'ektrondev1' (config file '/usr/local/nagios/etc/services/rogue.cfg', starting on line 256)
Error: Contact 'xi_default_contact' is not defined anywhere!
Error: Could not add contact 'xi_default_contact' to host (config file '/usr/local/nagios/etc/hosts/doberman.cfg', starting on line 16)
Error processing object config files!


***> One or more problems was encountered while processing the config files...

Check your configuration file(s) to ensure that they contain valid
directives and data definitions. If you are upgrading from a previous
version of Nagios, you should be aware that some variables/definitions
may have been removed or modified in this version. Make sure to read
the HTML documentation regarding the config files, as well as the
'Whats New' section to find out what has changed.
> Return Code: 1
--------------------------------------
/usr/local/nagiosxi/nom/checkpoints/nagioscore/errors /usr/local/nagiosxi/scripts
tar: Removing leading `/' from member names
/usr/local/nagiosxi/scripts
LATEST NOM SNAPSHOT: /usr/local/nagiosxi/nom/checkpoints/nagioscore/1565037842.tar.gz
/ /usr/local/nagiosxi/scripts
RESTORING NOM SNAPSHOT : /usr/local/nagiosxi/nom/checkpoints/nagioscore/1565037842.tar.gz
/usr/local/nagiosxi/scripts

--- reset_config_perms.sh ------------
> Setting script permissions
> Setting CCM script permissions
> Setting special script permissions
> Setting special component script permissions
> Setting configuration file/directory permissions
> Setting perfdata directory and RRD permissions
> Setting libexec directory permissions
> Setting Nagios XI config permissions
> Setting NOM checkpoint user:group permissions
> + Setting CCM configuration file user:group permissions
> + Setting Recurring Downtime file user:group permissions
> + Setting BPI configuration file user:group permissions
--------------------------------------
root@nagiostest:/root>

We recently upgraded our test server from CentOS 6 to CentOS 7. I did this by restoring a backup of XI from the CentOS 6 server to a freshly installed CentOS 7 server and then running the restore repair. Could that be the cause of these errors?

Thank you.

[eloyd]

Ick. CentOS 6 and 7 are dramatically different. selinux comes to mind with this sort of operation. I'd check that it's disabled, first (selinux and Nagios do not get along).

Second, my personal approach (and this is not a professional opinion) is that the easier way to do this operation, ignoring plugins and custom code for a minute, is to take the config files from the old version and use the import functionality on the new version, rather than backup/restore. This way, you're dealing with straight text files for config file import. However, you'll lose history information this way, which may not be acceptable for your situation.

[rferebee]

Ick. CentOS 6 and 7 are dramatically different. selinux comes to mind with this sort of operation. I'd check that it's disabled, first (selinux and Nagios do not get along).

Second, my personal approach (and this is not a professional opinion) is that the easier way to do this operation, ignoring plugins and custom code for a minute, is to take the config files from the old version and use the import functionality on the new version, rather than backup/restore. This way, you're dealing with straight text files for config file import. However, you'll lose history information this way, which may not be acceptable for your situation.

Thanks for your reply. SELinux shows it's disabled on the server.

root@nagiostest:/root>getenforce
Disabled
root@nagiostest:/root>

Any other ideas? I have two more XI servers I need to upgrade and losing historical information isn't an option, but if there's a better way to do the upgrade than a backup/restore I'm all ears.

[mbellerue]

Error: Contact 'xi_default_contact' is not defined anywhere!
Error: Could not add contact 'xi_default_contact' to host (config file '/usr/local/nagios/etc/hosts/doberman.cfg', starting on line 16)
Error processing object config files!

I would look at this first. It may be that you can clear up this undefined contact, and move the upgrade forward.

Aside from that, there are a couple of other useful commands.

Verify your configuration files.

Code: Select all

/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg

Check to make sure you have space for the upgrade.

Code: Select all

df -h && df -i

And make sure you don't have any crashed tables in the database.

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -uroot -pnagiosxi --table | grep NULL

[rferebee]

I have the 'xi_default_contact' set to inactive on all my Nagios XI servers. It's not causing any problems on my two other boxes.

The config files all come back okay.


Nagios Core 4.4.3
Copyright (c) 2009-present Nagios Core Development Team and Community Contributors
Copyright (c) 1999-2009 Ethan Galstad
Last Modified: 2019-01-15
License: GPL

Website: https://www.nagios.org
Reading configuration data...
Read main config file okay...
Warning: Duplicate definition found for service 'Ping' on host 'adaud' (config file '/usr/local/nagios/etc/services/adaud.cfg', starting on line 31)
Warning: Duplicate definition found for service 'Ping' on host 'sql12' (config file '/usr/local/nagios/etc/services/rogue.cfg', starting on line 256)
Warning: Duplicate definition found for service 'Ping' on host 'sage' (config file '/usr/local/nagios/etc/services/rogue.cfg', starting on line 256)
Warning: Duplicate definition found for service 'Ping' on host 'newjubilee' (config file '/usr/local/nagios/etc/services/rogue.cfg', starting on line 256)
Warning: Duplicate definition found for service 'Ping' on host 'lotus' (config file '/usr/local/nagios/etc/services/rogue.cfg', starting on line 256)
Warning: Duplicate definition found for service 'Ping' on host 'ektronprod1a.web' (config file '/usr/local/nagios/etc/services/rogue.cfg', starting on line 256)
Warning: Duplicate definition found for service 'Ping' on host 'ektrondev2' (config file '/usr/local/nagios/etc/services/rogue.cfg', starting on line 256)
Warning: Duplicate definition found for service 'Ping' on host 'ektrondev1' (config file '/usr/local/nagios/etc/services/rogue.cfg', starting on line 256)
Read object config files okay...

Running pre-flight check on configuration data...

Checking objects...
Warning: Service 'CPU Load NT' on host 'DHHSISD045' has no default contacts or contactgroups defined!
Warning: Service 'Free Space on C Drive' on host 'DHHSISD045' has no default contacts or contactgroups defined!
Warning: Service 'Memory Check' on host 'DHHSISD045' has no default contacts or contactgroups defined!
Warning: Service 'CPU Load NT' on host 'DHHSISD046' has no default contacts or contactgroups defined!
Warning: Service 'Free Space on C Drive' on host 'DHHSISD046' has no default contacts or contactgroups defined!
Warning: Service 'CPU Load NT' on host 'DHHSISD101' has no default contacts or contactgroups defined!
Warning: Service 'Free Space on C Drive' on host 'DHHSISD101' has no default contacts or contactgroups defined!
Warning: Service 'Free Space on D Drive' on host 'DHHSISD101' has no default contacts or contactgroups defined!
Warning: Service 'Free Space on C Drive' on host 'OOM-GC1.adjgencc-ad' has no default contacts or contactgroups defined!
Warning: Service 'Memory Check' on host 'OOM-GC1.adjgencc-ad' has no default contacts or contactgroups defined!
Warning: Service 'Check Load' on host 'cbtapprod' has no default contacts or contactgroups defined!
Warning: Service 'Free Space on C Drive' on host 'ccsharepntprod' has no default contacts or contactgroups defined!
Warning: Service 'Free Space on D Drive' on host 'ccsharepntprod' has no default contacts or contactgroups defined!
Warning: Service 'SQL Server Agent Service ESAINODS' on host 'doe_esainods01' has no default contacts or contactgroups defined!
Warning: Service 'SQL Server Analysis Service ESAINODS' on host 'doe_esainods01' has no default contacts or contactgroups defined!
Warning: Service 'SQL Server Service ESAINODS' on host 'doe_esainods01' has no default contacts or contactgroups defined!
Warning: Service 'SQL Server Agent Service ESAINRPT' on host 'doe_esainrpt01' has no default contacts or contactgroups defined!
Warning: Service 'SQL Server Analysis Service ESAINRPT' on host 'doe_esainrpt01' has no default contacts or contactgroups defined!
Warning: Service 'SQL Server Service ESAINRPT' on host 'doe_esainrpt01' has no default contacts or contactgroups defined!
Warning: Service 'Free Space on C Drive' on host 'dpslvfs1' has no check time period defined!
Warning: Service 'Free Space on C Drive' on host 'ektrondev2' has no check time period defined!
Warning: Service 'Free Space on D Drive' on host 'ektrondev2' has no check time period defined!
Warning: Service 'Free Space on C Drive' on host 'ent-sdcs' has no check time period defined!
Warning: Service 'Free Space on D Drive' on host 'ent-sdcs' has no check time period defined!
Warning: Service 'Free Space on E Drive' on host 'ent-sdcs' has no check time period defined!
Warning: Service 'CPU Load NT' on host 'ent-sdcslab' has no default contacts or contactgroups defined!
Warning: Service 'Free Space on C Drive' on host 'ent-sdcslab' has no default contacts or contactgroups defined!
Warning: Service 'Free Space on D Drive' on host 'ent-sdcslab' has no default contacts or contactgroups defined!
Warning: Service 'Free Space on E Drive' on host 'ent-sdcslab' has no default contacts or contactgroups defined!
Warning: Service 'Memory Check' on host 'ent-sdcslab' has no default contacts or contactgroups defined!
Warning: Service 'Ping' on host 'ent-sdcslab' has no default contacts or contactgroups defined!
Warning: Service 'Free Space on C Drive' on host 'ent-smplab2' has no default contacts or contactgroups defined!
Warning: Service 'Free Space on D Drive' on host 'ent-smplab2' has no default contacts or contactgroups defined!
Warning: Service 'Ping' on host 'entaltirissmp' has no default contacts or contactgroups defined!
Warning: Service 'CPU Load NT' on host 'gc1-pi' has no default contacts or contactgroups defined!
Warning: Service 'Memory Check' on host 'gc1-pi' has no default contacts or contactgroups defined!
Warning: Service 'Current Load' on host 'localhost' has no default contacts or contactgroups defined!
Warning: Service 'Current Users' on host 'localhost' has no default contacts or contactgroups defined!
Warning: Service 'Date Check' on host 'localhost' has no default contacts or contactgroups defined!
Warning: Service 'HTTP' on host 'localhost' has no default contacts or contactgroups defined!
Warning: Service 'PING' on host 'localhost' has no default contacts or contactgroups defined!
Warning: Service 'Root Partition' on host 'localhost' has no default contacts or contactgroups defined!
Warning: Service 'SSH' on host 'localhost' has no default contacts or contactgroups defined!
Warning: Service 'Total Processes' on host 'localhost' has no default contacts or contactgroups defined!
Warning: Service 'Disk Check /apps' on host 'nagiostest' has no default contacts or contactgroups defined!
Warning: Service 'Disk Check /home' on host 'nagiostest' has no default contacts or contactgroups defined!
Warning: Service 'Disk Check /var' on host 'nagiostest' has no default contacts or contactgroups defined!
Warning: Service 'Disk Check /apps' on host 'nagiosxi' has no default contacts or contactgroups defined!
Warning: Service 'Disk Check /home' on host 'nagiosxi' has no default contacts or contactgroups defined!
Warning: Service 'Disk Check /var' on host 'nagiosxi' has no default contacts or contactgroups defined!
Warning: Service 'Ping' on host 'nagiosxi' has no default contacts or contactgroups defined!
Warning: Service 'SSH' on host 'nagiosxi' has no default contacts or contactgroups defined!
Warning: Service 'Disk Check /apps' on host 'nagiosxi-lv' has no default contacts or contactgroups defined!
Warning: Service 'Disk Check /home' on host 'nagiosxi-lv' has no default contacts or contactgroups defined!
Warning: Service 'Disk Check /var' on host 'nagiosxi-lv' has no default contacts or contactgroups defined!
Warning: Service 'HTTP' on host 'nagiosxi-lv_monitor' has no default contacts or contactgroups defined!
Warning: Service 'I/O Wait' on host 'nagiosxi-lv_monitor' has no default contacts or contactgroups defined!
Warning: Service 'Load' on host 'nagiosxi-lv_monitor' has no default contacts or contactgroups defined!
Warning: Service 'NRPE' on host 'nagiosxi-lv_monitor' has no default contacts or contactgroups defined!
Warning: Service 'Nagios XI Daemons' on host 'nagiosxi-lv_monitor' has no default contacts or contactgroups defined!
Warning: Service 'Nagios XI Jobs' on host 'nagiosxi-lv_monitor' has no default contacts or contactgroups defined!
Warning: Service 'Ping' on host 'nagiosxi-lv_monitor' has no default contacts or contactgroups defined!
Warning: Service 'CPU Load NT' on host 'ns1out' has no default contacts or contactgroups defined!
Warning: Service 'Free Space on C Drive' on host 'ns1out' has no default contacts or contactgroups defined!
Warning: Service 'Memory Check' on host 'ns1out' has no default contacts or contactgroups defined!
Warning: Service 'CPU Load NT' on host 'ns2out' has no default contacts or contactgroups defined!
Warning: Service 'Free Space on C Drive' on host 'ns2out' has no default contacts or contactgroups defined!
Warning: Service 'Memory Check' on host 'ns2out' has no default contacts or contactgroups defined!
Warning: Service 'CPU Load NT' on host 'ns4' has no default contacts or contactgroups defined!
Warning: Service 'Memory Check' on host 'ns4' has no default contacts or contactgroups defined!
Warning: Service 'CPU Load NT' on host 'ns5' has no default contacts or contactgroups defined!
Warning: Service 'Memory Check' on host 'ns5' has no default contacts or contactgroups defined!
Warning: Service 'DNS IP Match' on host 'nv.gov' has no default contacts or contactgroups defined!
Warning: Service 'DNS Resolution' on host 'nv.gov' has no default contacts or contactgroups defined!
Warning: Service 'HTTP' on host 'nv.gov' has no default contacts or contactgroups defined!
Warning: Service 'Blacklist Status' on host 'peb' has no default contacts or contactgroups defined!
Warning: Service 'SMTP' on host 'peb' has no default contacts or contactgroups defined!
Warning: Service 'Ping' on host 'silverflume' has no default contacts or contactgroups defined!
Checked 3667 services.
Warning: Host 'DHHSISD045' has no default contacts or contactgroups defined!
Warning: Host 'DHHSISD046' has no default contacts or contactgroups defined!
Warning: Host 'DHHSISD101' has no default contacts or contactgroups defined!
Warning: Host 'OOM-GC1.adjgencc-ad' has no default contacts or contactgroups defined!
Warning: Host 'adfs.state.nv.us' has no default contacts or contactgroups defined!
Warning: Host 'caucc' has no default contacts or contactgroups defined!
Warning: Host 'doe_esainods01' has no default contacts or contactgroups defined!
Warning: Host 'doe_esainrpt01' has no default contacts or contactgroups defined!
Warning: Host 'doe_esainsql03' has no default contacts or contactgroups defined!
Warning: Host 'edbop07cc.nvdps' has no default contacts or contactgroups defined!
Warning: Host 'edbstsqllab' has no default contacts or contactgroups defined!
Warning: Host 'ent-sdcslab' has no default contacts or contactgroups defined!
Warning: Host 'entaltirissmp' has no default contacts or contactgroups defined!
Warning: Host 'gfcreports' has no default contacts or contactgroups defined!
Warning: Host 'gs1.web' has no default contacts or contactgroups defined!
Warning: Host 'localhost' has no default contacts or contactgroups defined!
Warning: Host 'lvcvcs' has no default contacts or contactgroups defined!
Warning: Host 'mail_mail' has no default contacts or contactgroups defined!
Warning: Host 'nagiosxi-lv_monitor' has no default contacts or contactgroups defined!
Warning: Host 'nv.gov' has no default contacts or contactgroups defined!
Warning: Host 'peb' has no default contacts or contactgroups defined!
Warning: Host 'prodexweb' has no default contacts or contactgroups defined!
Warning: Host 'silverflume' has no default contacts or contactgroups defined!
Checked 551 hosts.
Checked 181 host groups.
Checked 13 service groups.
Checked 207 contacts.
Checked 48 contact groups.
Checked 228 commands.
Checked 228 time periods.
Checked 1105 host escalations.
Checked 7364 service escalations.
Checking for circular paths...
Checked 551 hosts
Checked 0 service dependencies
Checked 0 host dependencies
Checked 228 timeperiods
Checking global event handlers...
Checking obsessive compulsive processor commands...
Checking misc settings...

Total Warnings: 101
Total Errors: 0

Things look okay - No serious problems were detected during the pre-flight check

There is plenty of space on the server.

root@nagiostest:/root>df -h && df -i
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/centos7-root 130G 8.2G 117G 7% /
devtmpfs 16G 0 16G 0% /dev
tmpfs 16G 0 16G 0% /dev/shm
tmpfs 16G 485M 16G 4% /run
tmpfs 16G 0 16G 0% /sys/fs/cgroup
/dev/mapper/centos7-usr 39G 15G 23G 39% /usr
/dev/sda1 477M 232M 216M 52% /boot
/dev/mapper/centos7-tmp 4.8G 231M 4.4G 5% /tmp
/dev/mapper/centos7-var 24G 1.8G 21G 8% /var
/dev/mapper/centos7-simpana 4.3G 18M 4.0G 1% /opt/sw
/dev/mapper/centos7-home 4.8G 33M 4.5G 1% /home
tmpfs 3.2G 0 3.2G 0% /run/user/987
tmpfs 3.2G 0 3.2G 0% /run/user/6603
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/mapper/centos7-root 8650752 4856 8645896 1% /
devtmpfs 4091052 437 4090615 1% /dev
tmpfs 4095232 1 4095231 1% /dev/shm
tmpfs 4095232 1520 4093712 1% /run
tmpfs 4095232 16 4095216 1% /sys/fs/cgroup
/dev/mapper/centos7-usr 2555904 259911 2295993 11% /usr
/dev/sda1 128016 369 127647 1% /boot
/dev/mapper/centos7-tmp 327680 4681 322999 2% /tmp
/dev/mapper/centos7-var 1572864 12743 1560121 1% /var
/dev/mapper/centos7-simpana 288000 11 287989 1% /opt/sw
/dev/mapper/centos7-home 327680 529 327151 1% /home
tmpfs 4095232 1 4095231 1% /run/user/987
tmpfs 4095232 1 4095231 1% /run/user/6603

I don't get anything returned for this:

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -uroot -pnagiosxi --table | grep NULL

[mbellerue]

Okay, great, if the query didn't return anything, that means you don't have any crashed tables. So that much is good.

Could you PM me your system profile? I'll take a look on my side and see if I can nail down exactly what's stopping the upgrade.

Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.

[rferebee]

So, it looks like the update actually went through despite the errors. The console is showing version 5.6.5 installed.

If you wouldn't mind taking a look at the system profile regardless that would be great. Just to make sure nothing is hosed after the CentOS 7 upgrade.

Thank you!

[mbellerue]

Excellent, I was just about to reply! Yes, I am seeing in the profile that you are running 5.6.5. After a quick look at the profile, everything seems to be good. If you go to the Admin section, and Check For Updates, does it show 5.6.5 there?

[rferebee]

Yes, it's showing 5.6.5 there as well. I could have swore it wasn't showing the update in the console, but I must have been mistaken.

[mbellerue]

Excellent! We'll call this a surprisingly smooth upgrade. I'll go ahead and lock this thread.