Upgrade encountered an error.

[ereut]

I tried to upgrade fusion using the command line and the web interface, both attempts were unsuccessful.
Any suggestions?

---- Starting Nagios Fusion Backup ----
Backing up Nagios Fusion directory...
tar: Removing leading `/' from member names
tar: /usr/local/nagiosfusion/var/log/sysstat_subsys.log: file changed as we read it
Backing up MySQL databases...
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
Backing up nagiosfusion cronjob...
Backing up cronjobs for Apache...
Backing up nagiosfusion sudoers.d file...
Backing up logrotate config files...
Backing up Apache config files...
Compressing backup...

===============
BACKUP COMPLETE
===============
Backup stored in /store/backups/nagiosfusion/autoupgrade_backup.1698247331.tar.gz

---- Starting Nagios Fusion Upgrade ----
Cleaning up temp directory...
/usr/local/nagiosfusion/tmp/nagiosfusion/setup /usr/local/nagiosfusion/tmp/nagiosfusion
/usr/local/nagiosfusion/tmp/nagiosfusion
Stopping cron, killing existing cron jobs
/usr/local/nagiosfusion/tmp/nagiosfusion/setup /usr/local/nagiosfusion/tmp/nagiosfusion
Running './06-sourceguardian.sh'...
Archive: sg/ixed4.lin.x86-64.zip
inflating: /usr/lib/php/20190902/ixed.7.4.lin
Sourceguardian extension found for PHP version 7.4
Sourceguardian extension already in php.ini
SourceGuardian installed OK
RESULT=0
/usr/local/nagiosfusion/tmp/nagiosfusion
/usr/local/nagiosfusion/tmp/nagiosfusion/setup/upgrades /usr/local/nagiosfusion/tmp/nagiosfusion
Configuring locale... this might take a minute...
Restarting Apache...
/usr/local/nagiosfusion/tmp/nagiosfusion
/usr/local/nagiosfusion/tmp/nagiosfusion/setup/upgrades /usr/local/nagiosfusion/tmp/nagiosfusion
Adding innodb_file_per_table in /etc/mysql/my.cnf...
Fusion files already broken into ibd files, skipping
/usr/local/nagiosfusion/tmp/nagiosfusion
PHP Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /usr/local/nagiosfusion/html/includes/components/fusioncore/fusioncore.inc.php on line 259
Upgrading database!
* Upgrading from version: 4200
* to version: 4200
* Migration files:
- 4100.sql
- 4102.sql
- 4108.sql
- 4200.sql
* Checking 4100.sql
** Is less than previous version, skipping
* Checking 4102.sql
** Is less than previous version, skipping
* Checking 4108.sql
** Is less than previous version, skipping
* Checking 4200.sql
* Executing: mysql -u fusion -h "localhost" --password="fusion" fusion < /usr/local/nagiosfusion/tmp/nagiosfusion/setup/db/migrations/4200.sql
mysql: [Warning] Using a password on the command line interface can be insecure.
* Updating db_version to 4200
Updating Fusion cronjobs...
Updating Fusion logrotate file...
Backing up current configuration...
Updating Fusion files...
tar: Removing leading `/' from member names
tar: /usr/local/nagiosfusion/var/log/sysstat_subsys.log: file changed as we read it

[ajcoil]

Hi @ereut, thanks for reaching out.

What OS are you using, and what version are you upgrading from?

[ereut]

Hi @ajcoil,

I tried upgrade Fusion 4.1.9 and the server is running Ubuntu 20.04.6.

Thank you

[ajcoil]

Hello @ereut,

It appears that the sysstat_subsys.log file had been changed during the upgrade. I would recommend disabling your cron jobs and running the update again.

Feel free to reach out if you are still having issues!

[ereut]

Thank you ajcoil,

Disabling cron and upgrade Fusion was successful. For those interested, history of commands below:

systemctl status cron.service
systemctl stop cron.service
wget https://assets.nagios.com/downloads/nag ... est.tar.gz
tar xzf fusion-latest.tar.gz
cd nagiosfusion/
sudo ./upgrade

[ajcoil]

Hey @ereut,

Glad to hear you got it working!

If you run into any more issues, feel free to reach out!

[ereut]

Hey guys, I'm trying to upgrade version 4.2.0 to fusion-2024R1 or fusion-2024R1.0.1 and getting this error.

# ./upgrade
/tmp/nagiosfusion/setup /tmp/nagiosfusion
/tmp/nagiosfusion

======================
Nagios Fusion Upgrader
======================

This script will perform an upgrade of Nagios Fusion by executing all necessary sub-scripts.

A complete backup will be created and be made available.

Do you want to continue? [Y/n] Y
Proceeding with installation...
Stopping cron, killing existing cron jobs
/tmp/nagiosfusion/setup /tmp/nagiosfusion
Running './06-sourceguardian.sh'...
SourceGuardian already installed - skipping...
RESULT=0
/tmp/nagiosfusion
/tmp/nagiosfusion/setup/upgrades /tmp/nagiosfusion

----------------------------------------------
Fusion 4 Incompatible with Installed Version
----------------------------------------------

In order to upgrade to Nagios Fusion 4, you'll first need to upgrade
your version of Nagios Fusion to 2014r1.1.

You can find previous versions of Nagios Fusion here:
https://assets.nagios.com/downloads/nag ... rsions.php

And don't you can reach out for help at the Nagios support forum:
https://support.nagios.com/forum/

[ereut]

I found issue was posted in viewtopic.php?t=66374, and I checked fusionversion.
# cat fusionversion
###################################
# DO NOT DELETE THIS FILE!
# Nagios Fusion version information
###################################
full=..
major=
minor=.
releasedate=2023-11-02
release=00

# ls --full-time fusionversion
-rw-r--r-- 1 nagios nagios 192 2023-11-02 18:20:07.810112333 +0000 fusionversion

2023-11-02 is the date I did last update Fusion to 4.2.0. I'll change the fusion version file and see how the next update goes.

[ajcoil]

Hello @ereut,

Thank you for reaching out!

I am sorry to hear you are running into this issue as well!

Just to verify, the only script you ran was the "./upgrade" one correct?