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
Nagios upgrade web console
Re: Nagios upgrade web console
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.
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:
Code: Select all
. /usr/local/nagiosxi/var/xi-sys.cfg
mysqlshow -h $cfg__db_info__nagiosxi__dbserver -u root -p"$mysqlpass"
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy
Re: Nagios upgrade web console
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
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