Update in progress message stuck

[Psihawk]

Hello. I have been able to upgrade Nagios via manual methods.. but via the GUI I always have UPDATE IN PROGRESS message.
How is this cleared? I have followed the information here:
https://support.nagios.com/kb/article/n ... e-851.html

But when running this: mysql -u'nagiosxi' -p'n@gweb' nagiosxi -e "update xi_commands set status_code = '2' where command = '1120';"
(My password is different than above)
I get the message
Error 1045 (28000): Access denied for user 'nagiosxi'@'localhost'

Any thoughts?

[benjaminsmith]

Hi,

Some systems do not seem to have issues with the GUI upgrade but others do. In your case, I would recommend using the manual upgrade.

Regarding the error message, it's either the password or perhaps the database is offloaded. In that same kb article, there are instructions on how to check the passwords on your system. Did you check those settings? Is the dbserver for nagiosxi localhost?

https://support.nagios.com/kb/article/n ... e-851.html

--Benjamin

[Psihawk]

I get the error when following the article you posted that says

ERROR 1045 (28000): Access denied for user 'nagiosxi'@'localhost' (using password: YES)

I am logged in as root and at a # sign. Got password from the config file.

[Psihawk]

Also the DB is not local host but on another linux host

[benjaminsmith]

Hi,

Okay, we'll have to update the command to communicate with the offloaded database server. For example:

Code: Select all

mysql -u nagios -p'nagiosP@ssw0rd' -h <IP_ADDRESS_OF_MYSQL_OR_MARIADB_SERVER> -e "update xi_commands set status_code = '2' where command = '1120';"

Alternatively, you could log into the system and run that query on the nagiosxi database if that's easier.

Reference:
Nagios XI Offloading MySQL to Remote Server

[Psihawk]

Running that query via the SSH window on Nagios pointing at IP of DB server we get


[root@prin-mo-0 ~]# mysql -u nagiosxi -p'nagiosxi' -h XXX.XXX.XXX.XXX -e "update xi_commands set status_code = '2' where command
= '1120';"
ERROR 1046 (3D000) at line 1: No database selected
[root@prin-mo-0 ~]#

[Psihawk]

Or running it directly on the server hosting the MYSQL DB

root@prin-mo-1 ~]# mysql -u nagiosxi -p'nagiosxi' -h XXX.XXX.XXX.XXX -e "update xi_commands set status_code = '2' where command = '1120';"
ERROR 1130 (HY000): Host 'prin-mo-1.mistras.local' is not allowed to connect to this MariaDB server
[root@prin-mo-1 ~]#

[ssax]

Please use this:

Code: Select all

mysql -u nagiosxi -p'nagiosxi' -h XXX.XXX.XXX.XXX nagiosxi -e "update xi_commands set status_code = '2' where command
= '1120';"

[Psihawk]

Same error

[root@prin-mo-1 ~]# mysql -u nagiosxi -p'nagiosxi' -h xxx.xxx.xxx.xxx nagiosxi -e "update xi_commands set status_code = '2' where command = '1120';"
ERROR 1130 (HY000): Host 'prin-mo-1.mistras.local' is not allowed to connect to this MariaDB server
[root@prin-mo-1 ~]#

[Psihawk]

Nevermind.. ran that command on the SSH terminal from within Nagios and it worked!

Thank you