Upgrade from 5.6.0 to 5.6.3 does not progress

[Sampath.Basireddy]

Hi There,

I am trying to upgrade NagiosXI from 5.6.0 to 5.6.3.

I am trying the manual download method. Each time I execute "upgrade" script, nothing happens.

Package download via link https://assets.nagios.com/downloads/nag ... 1546973582

It just sits there without any progress even after waiting for more than 15mins.

Please suggest.

Thank You,
Sampath

[benjaminsmith]

Hi Sampath,

It just sits there without any progress even after waiting for more than 15mins.

I just tested this without any issues using the upgrade script (below). What method are you using to upgrade?

Code: Select all

wget -O upgrade.sh https://assets.nagios.com/downloads/nagiosxi/upgrade.sh
sh ./upgrade.sh

[Sampath.Basireddy]

Am running ./upgrade.

I don't see a upgrade.sh file.

Here are the complete list of files from the zip:

Code: Select all

root@nagios1:[/tmp/nagiosxi]: ls -l
total 520
-rwxr-xr-x  1 root root   8532 Jun 10 16:06 0-repos
-rwxr-xr-x  1 root root    498 Jun 10 16:06 11-sourceguardian
-rwxr-xr-x  1 root root   1228 Jun 10 16:06 13-phpini
-rwxr-xr-x  1 root root   9451 Jun 10 16:06 1-prereqs
-rwxr-xr-x  1 root root   1540 Jun 10 16:06 2-usersgroups
-rwxr-xr-x  1 root root    787 Jun 10 16:06 3-dbservers
-rwxr-xr-x  1 root root    396 Jun 10 16:06 4-services
-rwxr-xr-x  1 root root    377 Jun 10 16:06 5-sudoers
-rwxr-xr-x  1 root root   1842 Jun 10 16:06 6-firewall
-rwxr-xr-x  1 root root    438 Jun 10 16:06 8-selinux
-rwxr-xr-x  1 root root    547 Jun 10 16:06 9-dbbackups
-rwxr-xr-x  1 root root    618 Jun 10 16:06 A0-mrtg
-rwxr-xr-x  1 root root    495 Jun 10 16:06 A-subcomponents
-rwxr-xr-x  1 root root   8374 Jun 10 16:06 B-installxi
-rwxr-xr-x  1 root root    878 Jun 10 16:06 C-cronjobs
-rw-r--r--  1 root root 176489 Jun 10 16:06 CHANGELOG.txt
-rw-r--r--  1 root root    408 Jun 10 16:06 components.txt
-rw-r--r--  1 root root     44 Jun 10 16:06 dashlets.txt
-rwxr-xr-x  1 root root   1287 Jun 10 16:06 D-chkconfigalldaemons
-rwxr-xr-x  1 root root    228 Jun 10 16:06 debianmods
-rwxr-xr-x  1 root root   2993 Jun 10 16:06 E-importnagiosql
-rwxr-xr-x  1 root root    373 Jun 10 16:06 F-startdaemons
-rwxr-xr-x  1 root root   5380 Jun 10 16:06 fullinstall
-rwxr-xr-x  1 root root   2139 Jun 10 16:06 functions.sh
-rwxr-xr-x  1 root root   1999 Jun 10 16:06 get-os-info
-rwxr-xr-x  1 root root    146 Jun 10 16:06 get-version
-rwxr-xr-x  1 root root    933 Jun 10 16:06 init-auditlog
-rwxr-xr-x  1 root root   3710 Jun 10 16:06 init-mysql
-rwxr-xr-x  1 root root   4330 Jun 10 16:06 init.sh
-rwxr-xr-x  1 root root    928 Jun 10 16:06 init-xidb
-rwxr-xr-x  1 root root   3522 Jun 10 16:06 install-html
-rwxr-xr-x  1 root root    414 Jun 10 16:06 install-pnptemplates
-rwxr-xr-x  1 root root   1097 Jun 10 16:06 install-sourceguardian-extension.sh
-rwxr-xr-x  1 root root   1004 Jun 10 16:06 install-sudoers
-rwxr-xr-x  1 root root    646 Jun 10 16:06 install-templates
drwxr-xr-x  2 root root   4096 Jun 10 16:06 licenses
drwxr-xr-x  4 root root   4096 Jun 10 16:06 nagiosxi
-rw-r--r--  1 root root   3092 Jun 10 16:06 nagiosxi-deps-5.6.3-1.noarch.rpm
-rw-r--r--  1 root root   3184 Jun 10 16:06 nagiosxi-deps-el7-5.6.3-1.noarch.rpm
-rw-r--r--  1 root root   3208 Jun 10 16:06 nagiosxi-deps-el8-5.6.3-1.noarch.rpm
-rw-r--r--  1 root root   2916 Jun 10 16:06 nagiosxi-deps-suse11-5.6.3-1.noarch.rpm
-rw-r--r--  1 root root   2916 Jun 10 16:06 nagiosxi-deps-suse12-5.6.3-1.noarch.rpm
drwxr-xr-x  2 root root   4096 Jun 10 16:06 packages
-rwxr-xr-x  1 root root   5664 Jun 10 16:06 rpminstall
-rwxr-xr-x  1 root root  17602 Jun 10 16:06 rpmupgrade
drwxr-xr-x  2 root root   4096 Jun 10 16:06 sourceguardian
drwxr-xr-x 19 root root   4096 Jun 10 16:06 subcomponents
-rwxr-xr-x  1 root root    445 Jun 10 16:06 susemods
drwxr-xr-x  2 root root   4096 Jun 10 16:06 tools
-rwxr-xr-x  1 root root     11 Jun 10 16:06 ubuntumods
-rwxr-xr-x  1 root root    674 Jun 10 16:06 uninstall-crontab-nagios
-rwxr-xr-x  1 root root    701 Jun 10 16:06 uninstall-crontab-root
-rwxr-xr-x  1 root root  49434 Jun 10 16:06 upgrade
-rw-r--r--  1 root root  12817 Jun 10 16:06 verify-prereqs.php
drwxr-xr-x  3 root root   4096 Jun 10 16:06 vmsetup
-rw-r--r--  1 root root    781 Jun 10 16:06 wizards.txt
-rw-r--r--  1 root root    915 Jun 18 02:28 xi-sys.cfg
-rwxr-xr-x  1 root root    610 Jun 10 16:06 xivar
-rwxr-xr-x  1 root root    437 Jun 10 16:06 Z-webroot

[benjaminsmith]

Hi Sampeth,

The upgrade.sh script is for the quick method. See: Nagios XI Upgrade Instructions

Can you run ./upgrade as root from the terminal and then post the full output so we can review the errors?

[Sampath.Basireddy]

@benjaminsmith,

When I run "./upgrade", nothing happens. It just stays there forever without any progress or error and am running this as root.

Code: Select all

root@nagios1:[/tmp/nagiosxi]: ls
0-repos            5-sudoers        C-cronjobs             F-startdaemons  init.sh                              licenses                                 packages        ubuntumods                xi-sys.cfg
11-sourceguardian  6-firewall       CHANGELOG.txt          fullinstall     init-xidb                            nagiosxi                                 rpminstall      uninstall-crontab-nagios  xivar
13-phpini          8-selinux        components.txt         functions.sh    install-html                         nagiosxi-deps-5.6.3-1.noarch.rpm         rpmupgrade      uninstall-crontab-root    Z-webroot
1-prereqs          9-dbbackups      dashlets.txt           get-os-info     install-pnptemplates                 nagiosxi-deps-el7-5.6.3-1.noarch.rpm     sourceguardian  upgrade
2-usersgroups      A0-mrtg          D-chkconfigalldaemons  get-version     install-sourceguardian-extension.sh  nagiosxi-deps-el8-5.6.3-1.noarch.rpm     subcomponents   verify-prereqs.php
3-dbservers        A-subcomponents  debianmods             init-auditlog   install-sudoers                      nagiosxi-deps-suse11-5.6.3-1.noarch.rpm  susemods        vmsetup
4-services         B-installxi      E-importnagiosql       init-mysql      install-templates                    nagiosxi-deps-suse12-5.6.3-1.noarch.rpm  tools           wizards.txt
root@nagios1:[/tmp/nagiosxi]: ./upgrade

[benjaminsmith]

Hi Sampeth,

Typically the upgrade script will either execute or fail with an error. Have you tried using the web interface to upgrade. Go to Admin > System Information > Check For Updates and select the button Upgrade to Latest Version.

upgrade.png

Also, please upload the upgrade log at /usr/local/nagiosxi/tmp/upgrade.log if it fails again.

Thanks.

[Sampath.Basireddy]

Tried to upgrade from web console, but it was failing with error:

Code: Select all

Copying ramdisk configuration...
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...
mysqldump: Got errno 28 on write
Error backing up MySQL database 'nagios' - check the password in this script!

I am suspecting this error could be due to low on space in /store dir, but I do see about 12gigs of free space. Not sure if that is enough or not.

Is there a way I can run this upgrade without running backup from web console as I have taken backup last night only?

[benjaminsmith]

Hi Sampath,

I am suspecting this error could be due to low on space in /store dir, but I do see about 12gigs of free space. Not sure if that is enough or not.

The backup archive can be large as it saves everything. You can try to clear out older backups to save space. They are located in /store/backups/nagiosxi/.

Also, can you PM your system profile for us to review.

To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message or upload it to the post/ticket.

[Sampath.Basireddy]

Yep deleted already. There are this few other "ibd" files which are consuming a lot of space, please see below:

Can you please suggest what these files are and can they be deleted?

Code: Select all

root@nagios1:[/store/mysql/nagiosxi]: ls -lhartS
total 12G
-rw-rw---- 1 mysql mysql   65 Jun 28  2017 db.opt
drwxr-xr-x 7 mysql mysql 4.0K Jun 18 17:35 ..
drwx------ 2 mysql mysql 4.0K Jun 18 18:13 .
-rw-rw---- 1 mysql mysql 8.5K Jun 18 18:13 xi_options.frm
-rw-rw---- 1 mysql mysql 8.5K Jun 18 18:13 xi_sysstat.frm
-rw-rw---- 1 mysql mysql 8.6K Jun 18 18:13 xi_usermeta.frm
-rw-rw---- 1 mysql mysql 8.6K Jun 18 18:12 xi_meta.frm
-rw-rw---- 1 mysql mysql 8.6K Feb 23 11:42 #sql-5825_11f.frm
-rw-rw---- 1 mysql mysql 8.6K Feb 23 11:36 #sql-4008_18f.frm
-rw-rw---- 1 mysql mysql 8.6K Feb 23 02:52 #sql-3d6e_d6.frm
-rw-rw---- 1 mysql mysql 8.6K Feb  2 07:25 #sql-3ac3_1eb.frm
-rw-rw---- 1 mysql mysql 8.6K Feb 23 02:45 #sql-2392_7ac71.frm
-rw-rw---- 1 mysql mysql 8.6K Feb 23 11:24 #sql-1f31_3fd.frm
-rw-rw---- 1 mysql mysql 8.6K Feb  2 07:20 #sql-16b5_12a996.frm
-rw-rw---- 1 mysql mysql 8.6K Oct 15  2018 xi_eventqueue.frm
-rw-rw---- 1 mysql mysql 8.6K Jun 18 18:13 xi_mibs.frm
-rw-rw---- 1 mysql mysql 8.6K Jun 18 18:12 xi_events.frm
-rw-rw---- 1 mysql mysql 8.6K Feb 23 03:11 #sql-4f13_17a.frm
-rw-rw---- 1 mysql mysql 8.6K Feb  2 07:30 #sql-4a91_219.frm
-rw-rw---- 1 mysql mysql 8.6K Feb 23 11:46 #sql-4a31_d6.frm
-rw-rw---- 1 mysql mysql 8.6K Feb 23 02:57 #sql-4409_be.frm
-rw-rw---- 1 mysql mysql 8.6K Feb 23 03:01 #sql-1692_133.frm
-rw-rw---- 1 mysql mysql 8.7K Jun 18 18:12 xi_auditlog.frm
-rw-rw---- 1 mysql mysql 8.7K Feb 23 03:06 #sql-6897_180.frm
-rw-rw---- 1 mysql mysql 8.7K Jun 28  2017 xi_incidents.frm
-rw-rw---- 1 mysql mysql 8.8K Jun 18 18:13 xi_auth_tokens.frm
-rw-rw---- 1 mysql mysql 8.8K Jun 18 18:13 xi_sessions.frm
-rw-rw---- 1 mysql mysql 9.0K Jun 18 18:12 xi_commands.frm
-rw-rw---- 1 mysql mysql 9.1K Jun 18 18:13 xi_users.frm
-rw-rw---- 1 mysql mysql 9.2K Jun 18 18:13 xi_cmp_trapdata.frm
-rw-rw---- 1 mysql mysql 9.3K Jun 18 18:13 xi_cmp_trapdata_log.frm
-rw-rw---- 1 mysql mysql  96K Jun 28  2017 xi_incidents.ibd
-rw-rw---- 1 mysql mysql  96K Jun 18 18:12 xi_commands.ibd
-rw-rw---- 1 mysql mysql 105K Jun 18 18:30 xi_eventqueue.MYI
-rw-rw---- 1 mysql mysql 112K Jun 18 18:13 xi_sysstat.ibd
-rw-rw---- 1 mysql mysql 112K Jun 18 18:13 xi_sessions.ibd
-rw-rw---- 1 mysql mysql 112K Jun 18 18:13 xi_cmp_trapdata_log.ibd
-rw-rw---- 1 mysql mysql 112K Jun 18 18:13 xi_cmp_trapdata.ibd
-rw-rw---- 1 mysql mysql 112K Jun 18 18:13 xi_auth_tokens.ibd
-rw-rw---- 1 mysql mysql 128K Jun 18 18:13 xi_mibs.ibd
-rw-rw---- 1 mysql mysql 144K Jun 18 18:13 xi_options.ibd
-rw-rw---- 1 mysql mysql 192K Feb 23 03:06 #sql-6897_180.ibd
-rw-rw---- 1 mysql mysql 256K Jun 18 18:13 xi_users.ibd
-rw-rw---- 1 mysql mysql 656K Jun 18 18:12 xi_auditlog.ibd
-rw-rw---- 1 mysql mysql 880K Feb  2 07:48 #sql-4a91_219.ibd
-rw-rw---- 1 mysql mysql 3.0M Feb 23 11:09 #sql-4f13_17a.ibd
-rw-rw---- 1 mysql mysql 4.0M Feb 23 11:46 #sql-4a31_d6.ibd
-rw-rw---- 1 mysql mysql 9.6M Jun 18 18:30 xi_eventqueue.MYD
-rw-rw---- 1 mysql mysql  16M Feb 23 02:59 #sql-4409_be.ibd
-rw-rw---- 1 mysql mysql  30M Feb 23 03:04 #sql-1692_133.ibd
-rw-rw---- 1 mysql mysql  31M Jun 18 18:13 xi_usermeta.ibd
-rw-rw---- 1 mysql mysql  64M Jun 18 18:23 xi_events.ibd
-rw-rw---- 1 mysql mysql 432M Feb  2 07:48 #sql-3ac3_1eb.ibd
-rw-rw---- 1 mysql mysql 442M Feb 23 11:41 #sql-4008_18f.ibd
-rw-rw---- 1 mysql mysql 829M Feb 23 11:45 #sql-5825_11f.ibd
-rw-rw---- 1 mysql mysql 867M Feb  2 07:28 #sql-16b5_12a996.ibd
-rw-rw---- 1 mysql mysql 1.7G Feb 23 11:27 #sql-1f31_3fd.ibd
-rw-rw---- 1 mysql mysql 1.7G Feb 23 02:56 #sql-3d6e_d6.ibd
-rw-rw---- 1 mysql mysql 1.7G Jun 18 18:30 xi_meta.ibd
-rw-rw---- 1 mysql mysql 4.3G Feb 23 02:50 #sql-2392_7ac71.ibd
root@nagios1:[/store/mysql/nagiosxi]:

I will PM you the system profile:

[benjaminsmith]

Hi Sampeth,

That folder should just contain the backup archives, so I'm not sure why those files are there. Before proceeding, I highly recommend you make a backup using the FTP or SSH option under Admin > System Backups > Scheduled Backups.

See: Backing Up And Restoring Your Nagios XI System

Once you have a current backup saved to another systeem, then proceed with removing the remaining files in /store/backups/nagiosxi/.

Also, is this a VM? Is is possible to increase to the amount of drive space?

Thanks.