Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue

[Psihawk]

I am trying to upgrade to 2024.R1.1.1 from 2024.R1.0.1 and getting this error

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...

I have checked the file and see a password in there but I have no idea what the correct one is. Also not sure if it matters but I think our DB is a MariaDB. Is there a way to find this password it uses to connect to the SQL DB? We have a two system setup with the DB on another linux box.


Installed version

2024R1.0.1

OS - CentOS Linux 7
Kernel 3.10.0-1160.105.1.e17.x86_64

Thanks

[jmichaelson]

The root password should be the mysqlpass value in the xi-sys.cfg file. MariaDB is a fork of MySQL and the two are often used interchangeably. For this purpose they're equivalent.

Try using that value to log in to the database both from the mysql client on the XI system and the Database. IF not, you can try following the MySQL/MariaDB Instructions for resetting your root password and then update the mysqlpass value to reflect that password.

[Psihawk]

Thanks Jason. I do not see any instructions attached for resetting the password.

Also can you send instructions on how to log in via MYSQL client on the XI systems and the Database?

[bbahn]

@Psihawk,

You can reset your root password with How to reset your MySQL or MariaDB root password or Reset MariaDB password

[Psihawk]

OK so using the document you gave i am able to login to the MariaDB without issues as shown

mariadb.jpg

Any thoughts on why I still get the SQL password issue when trying to upgrade?

[sgardil]

What is the error given when trying to upgrade? From another post I saw that you are running a two server setup with your db on a separate server, this may create complications so if we cant figure it out quickly here it may be best to open an Answer Hub ticket.

[Psihawk]

I am getting this error

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...

[sgardil]

I am getting this error

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...

Ah have you tried the solutions in this post? I would rewrite it here however danderson and jsimon had a great write up on it already. Let us know if following those instructions fixes your issue.