Upgrade to 2024r2 fails

[DIS UNIX]

Trying to upgrade from 5.10.0 to 2024r2, and can't get past

Enter the MySQL root password to continue...
MySQL Root Password:

Entered the proper password multiple times - have run the script a handful of times, and it eventually fails with
Password failed.
Warning: Stored or entered MySQL root password does not work.
Make sure the "mysqlpass" value in "/usr/local/nagiosxi/etc/xi-sys.cfg" and
"/usr/local/nagiosxi/var/xi-sys.cfg" is up to date and accurate
or enter in the up to date password when upgrading without the "-n" option.
Skipping updates to MySQL user permissions...

Those two files were edited to reflect the proper password - no change, still fails.

Running RHEL 8.10, updated/rebooted yesterday without issues. Not sure how to get past this, and not sure how to decipher
"...enter in the up to date password when upgrading without the "-n" option." when we're only running the recommended
./upgrade
with no options.

Not sure how to proceed - is there a fix for this?

[lgute]

Hi @DIS UNIX,

Thanks for reaching out.

Have you been able to login with mysql using the mysql root password?

Code: Select all

mysql -u root -p

...and then enter the password when prompted.

Here are a couple of threads about problems with upgrading that may help.

• Upgrade 5.x to 2024.x
• Problem upgrading from Nagios XI 2024R1 to 2024R1.1 or beyond

[lgute]

Hi @DIS UNIX,

After discussing your situation with colleagues, your best option is likely to be opening a support ticket at https://support.nagios.com/, so our support team can help you.

[StevenBeauchemin]

I also have had challenges getting into MySQL after installs.

Since I'm not smart enough to figure out the old password, I scripted a way to change the password to something I know.
I scripted this so I would not have to remember the process.

The password is in the script => IDENTIFIED BY 'nagiosxi';" <= so change this to what you prefer.

I hope this helps everyone.
see attached. If not attached there, then PM me and I'll get it to you somehow.
Steve B

[StevenBeauchemin]

attaching as a zip file...