Nagios Support Forum

Hello
Upgrade from web console ending 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...

I've checked connection and password from app server to db server, and it works ok.
What am'i missing here ?

Latest Available Version: 2024R1.0.2
Installed Version: 2024R1.0.1

Hi @wmalcus,

This upgrade process isn't using the application server's own database connection details - it's using a bash script that relies on the information in /usr/local/nagiosxi/etc/xi-sys.cfg. The upgrade script specifically needs to be able to access the database as the root user, so mysqlpass will need to be set to the database's root password to perform the upgrade.

If you want to test this on the command line, you should be able to run: Hopefully that helps - please let us know if you have any further questions or concerns.

Hello
Sorry for the delay.
I forrgot about search function.
That's solve the problem.

viewtopic.php?t=66302&start=10

"If you have an offloaded databases, the root user also needs to have the grant option granted. It sounds goofy but when you grant all permissions to a user, the grant option is not included. So on the machine with the mysql database, you would log into mysql and do something like GRANT ALL ON *.* to root@`[Your XI IP address/hostname]` WITH GRANT OPTION;"

case closed