Nagios Support Forum

We are trying to upgrade nagios xi through two different ways:

* Through the web, after many hours it finishes (attached screenshot), but it does not upgrade.
* And doing it through the console, the web does not take the new version, stops working the 'monitoring engine' and 'database backend'.

Thanks in advance

Hi

Please take a look at this document:
https://assets.nagios.com/downloads/nag ... ctions.pdf

I would try: If it bombs please send me /usr/local/nagiosxi/tmp/upgrade.log

Thanks

Hello,

We have followed the steps and we have next error:

[root@nagios-ko nagiosxi]# less /usr/local/nagiosxi/tmp/upgrade.log
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
/usr/local/nagiosxi/tmp/upgrade.log: No such file or directory
[root@nagios-ko nagiosxi]#


Monitoring Engine & Database Backend don't start.

We have just attached stdout for sh ./upgrade.sh command

May you please help us with this?

Thanks in advance
A. Rubio

Hi,

I am not seeing what errors (if any) you saw from: Please send them to me.

Also run: If you find any of these logs, and the time/date correspond to when you tried the update
please send them to me.

Thanks

Hello,

We can't find logs:

[root@nagios-ko ~]# cd /
[root@nagios-ko /]# find . -name update.log
[root@nagios-ko /]# find . -name install.log
[root@nagios-ko /]# find . -name installation.log
[root@nagios-ko /]#

We just have seen a message in web console that says it's necesary run /usr/local/nagiosxi/scripts/repair_databases.sh script:

===============
REPAIR COMPLETE
===============
Failed to restart ndo2db.service: Unit not found.

=======================
nagios database repair succeeded
nagiosql database repair succeeded
nagiosxi database repair succeeded

The service do2db doesn't exists:

[root@nagios-ko /]# systemctl -a | grep ndo
systemd-random-seed.service loaded active exited Load/Save Random Seed
[root@nagios-ko /]#


Thanks in advance,

A. Rubio

Sorry, we have senn as well:

[root@nagios-ko /]# tail /usr/local/nagios/var/nagios.log
[1623920056] NDO-3: ndo_return = 1 (Statement not prepared)
[1623920056] NDO-3: ndo_handle_service_status(ndo-handlers.c:1096): Unable to bind parameters
[1623920056] NDO-3: ndo_return = 1 (Statement not prepared)
[1623920056] NDO-3: ndo_handle_service_status(ndo-handlers.c:1096): Unable to bind parameters
[1623920056] NDO-3: ndo_return = 1 (Statement not prepared)
[1623920056] NDO-3: ndo_handle_service_status(ndo-handlers.c:1096): Unable to bind parameters
[1623920056] NDO-3: ndo_return = 1 (Statement not prepared)
[1623920056] NDO-3: ndo_handle_host_status(ndo-handlers.c:985): Unable to bind parameters
[1623920056] NDO-3: ndo_return = 1 (Statement not prepared)
[1623920056] NDO-3: ndo_handle_host_status(ndo-handlers.c:985): Unable to bind parameters
[root@nagios-ko /]#

regards,

more...

NDO-3: NDO 3.0.6RC1 (c) Copyright 2009-2020 Nagios - Nagios Core Development Team
[1623924015] NDO-3: Unable to connect to mysql. Configuration may be incorrect or database may have temporarily disconnected.
[1623924015] NDO-3: NDO was not able to initialize the database (main context) and will not start.
[1623924015] Event broker module '/usr/local/nagios/bin/ndo.so' initialized successfully.
[1623924022] Successfully launched command file worker with pid 9009
[1623924061] Caught SIGTERM, shutting down...
[1623924061] Successfully shutdown... (PID=8910)
[1623924061] NDO-3: Callbacks deregistered
[1623924061] NDO-3: NDO - Shutdown complete
[1623924061] Event broker module '/usr/local/nagios/bin/ndo.so' deinitialized successfully.

But:
[root@nagios-ko ~]# service mariadb status
Redirecting to /bin/systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: active (running) since Thu 2021-06-17 12:01:46 CEST; 3min 27s ago
Process: 1292 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
Process: 945 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 1291 (mysqld_safe)
CGroup: /system.slice/mariadb.service
├─1291 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─1825 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log -...

Jun 17 12:01:43 nagios-ko systemd[1]: Starting MariaDB database server...
Jun 17 12:01:44 nagios-ko mariadb-prepare-db-dir[945]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Jun 17 12:01:44 nagios-ko mariadb-prepare-db-dir[945]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Jun 17 12:01:45 nagios-ko mysqld_safe[1291]: 210617 12:01:45 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Jun 17 12:01:45 nagios-ko mysqld_safe[1291]: 210617 12:01:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jun 17 12:01:46 nagios-ko systemd[1]: Started MariaDB database server.
[root@nagios-ko ~]#

Hi

Please run these two commands and send me the output: Thanks

Hello,

We have just attached the output of the comands.

Thanks in advance,
A.Rubio

Hi,

I didn't receive the output, could you re-send please?

Thanks