Nagios Support Forum

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

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.

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?

@Psihawk,

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

OK so using the document you gave i am able to login to the MariaDB without issues as shown Any thoughts on why I still get the SQL password issue when trying to upgrade?

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.

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

Psihawk wrote: ↑Mon Apr 15, 2024 5:42 pm 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.

I see the issue I think.. There is no password for this

MySQL dbmaint_nagiosxi password:

Its blank.. Do we know where I set this at? Which file?

That should be in /usr/local/nagiosxi/etc/xi-sys.cfg