Nagios Support Forum

The update screen is stuck updating and nothing I've tried will release or finish that update. Kindly assist

PLEASE SEE => Attached is my System profile.

]# uname -a
Linux keondc2ng002 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux


]# cat /etc/yum.repos.d/epel.repo
[epel]
name=Extra Packages for Enterprise Linux 6 - $basearch
#baseurl=http://download.fedoraproject.org/pub/epel/6/$basearch
mirrorlist=https://mirrors.fedoraproject.org/metal ... =$basearch
failovermethod=priority
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-6

[epel-debuginfo]
name=Extra Packages for Enterprise Linux 6 - $basearch - Debug
#baseurl=http://download.fedoraproject.org/pub/e ... arch/debug
mirrorlist=https://mirrors.fedoraproject.org/metal ... =$basearch
failovermethod=priority
enabled=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-6
gpgcheck=1

[epel-source]
name=Extra Packages for Enterprise Linux 6 - $basearch - Source
#baseurl=http://download.fedoraproject.org/pub/epel/6/SRPMS
mirrorlist=https://mirrors.fedoraproject.org/metal ... =$basearch
failovermethod=priority
enabled=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-6
gpgcheck=1

I'm going to recommend you follow the Manual upgrade instructions
https://assets.nagios.com/downloads/nag ... ctions.pdf

then, once the upgrade completes you can clear the GUI upgrade screen following this doc:
https://support.nagios.com/kb/article/n ... e-851.html

I have followed the link be to upgrade my system, but am getting the errors below, kindly advise what might I be missing
https://assets.nagios.com/downloads/nag ... ctions.pdf

[root@k nagiosxi]# ./upgrade
Nagios XI Upgrade Log
==========================
DATE: Fri Mar 27 13:26:51 EAT 2020

DISTRO INFO:
CentOS
6.5
x86_64


Archive: sourceguardian/ixed4.lin.x86-64.zip
inflating: /usr/lib64/php/modules/ixed.5.3.lin
Sourceguardian extension found for PHP version 5.3
Sourceguardian extension already in php.ini
Stopping httpd: [ OK ]
Starting httpd: httpd: Could not reliably determine the server's fully qualified domain name, using 10.x.x.x for ServerName
[ OK ]
Checking required prereqs...
Please wait...

OLD VERSION: 5413
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: mirror.aptus.co.tz
* epel: epel.mirror.liquidtelecom.com
* extras: mirror.aptus.co.tz
* updates: mirror.aptus.co.tz
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package nagios-repo.noarch 0:6-2.el6 will be updated
---> Package nagios-repo.noarch 0:6-4.el6 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Updating:
nagios-repo noarch 6-4.el6 nagios-base 6.0 k

Transaction Summary
================================================================================
Upgrade 1 Package(s)

Total size: 6.0 k
Downloading Packages:
warning: rpmts_HdrFromFdno: Header V4 RSA/SHA1 Signature, key ID c62934a0: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-NAGIOS


The GPG keys listed for the "Nagios" repository are already installed but they are not correct for this package.
Check that the correct key URLs are configured for this repository.
[root@k nagiosxi]#

Can you run the following
then try again

Thanks! I was able to resolve this by running the command below: attached is my profile file

[root@knagiosxi]# ./upgrade -f

Set up the snmptt daemon to start automatically on boot
as well as starting it now


Set up the snmptrapd daemon to start automatically on boot
as well as starting it now

Stopping snmptrapd: [FAILED]
Starting snmptrapd: [ OK ]

========================================
SNMP Trap Support Installation Complete!
========================================
Checking for existing snmptt.conf file
No existing snmptt.conf.nxti file was found, or the file was empty
Adding snmptt.conf.nxti to snmptt.ini
Changing permissions for snmptt.conf
Editing snmptt.ini
Creating a test file for NXTI Test Events to write to

Modifying permissions

Restarting snmptt
Stopping snmptt: [FAILED]
Starting snmptt: [ OK ]
Restarting snmptrapd
PHP Warning: Invalid argument supplied for foreach() in /usr/local/nagiosxi/html/includes/components/nagiosim/nagiosim.inc.php on line 491

Nagios XI Upgrade Complete!
---------------------------

You can access the Nagios XI web interface by visiting:
http://10.x.x.x/nagiosxi/

[root@k nagiosxi]#

BUT now I have a new problem Database maintenance Color Red Kindly assist what could be wrong now

Can you show the output of the following

Please check on the output of my dbmaint.log and advise:

[root@k]# tail -50 /usr/local/nagiosxi/var/dbmaint.log
LOCKFILE '/usr/local/nagiosxi/var/dbmaint.lock' EXISTS - EXITING!
LOCKFILE '/usr/local/nagiosxi/var/dbmaint.lock' EXISTS - EXITING!
LOCKFILE '/usr/local/nagiosxi/var/dbmaint.lock' EXISTS - EXITING!
LOCKFILE '/usr/local/nagiosxi/var/dbmaint.lock' EXISTS - EXITING!
LOCKFILE '/usr/local/nagiosxi/var/dbmaint.lock' EXISTS - EXITING!
LOCKFILE '/usr/local/nagiosxi/var/dbmaint.lock' EXISTS - EXITING!
LOCKFILE '/usr/local/nagiosxi/var/dbmaint.lock' IS OLD - REMOVING
CREATING: /usr/local/nagiosxi/var/dbmaint.lock
CLEANING ndoutils TABLE 'commenthistory'...
SQL: DELETE FROM nagios_commenthistory WHERE entry_time < FROM_UNIXTIME(1522248601)
CLEANING ndoutils TABLE 'processevents'...
SQL: DELETE FROM nagios_processevents WHERE event_time < FROM_UNIXTIME(1553784601)
CLEANING ndoutils TABLE 'externalcommands'...
SQL: DELETE FROM nagios_externalcommands WHERE entry_time < FROM_UNIXTIME(1584715801)
CLEANING ndoutils TABLE 'logentries'...
SQL: DELETE FROM nagios_logentries WHERE logentry_time < FROM_UNIXTIME(1577544601)
CLEANING ndoutils TABLE 'notifications'...
SQL: DELETE FROM nagios_notifications WHERE start_time < FROM_UNIXTIME(1577544601)
CLEANING ndoutils TABLE 'contactnotifications'...
SQL: DELETE FROM nagios_contactnotifications WHERE start_time < FROM_UNIXTIME(1577544601)
CLEANING ndoutils TABLE 'contactnotificationmethods'...
SQL: DELETE FROM nagios_contactnotificationmethods WHERE start_time < FROM_UNIXTIME(1577544601)
CLEANING ndoutils TABLE 'statehistory'...
SQL: DELETE FROM nagios_statehistory WHERE state_time < FROM_UNIXTIME(1522248601)
CLEANING ndoutils TABLE 'timedevents'...
SQL: DELETE FROM nagios_timedevents WHERE event_time < FROM_UNIXTIME(1585320301)
CLEANING ndoutils TABLE 'systemcommands'...
SQL: DELETE FROM nagios_systemcommands WHERE start_time < FROM_UNIXTIME(1585320301)
CLEANING ndoutils TABLE 'servicechecks'...
SQL: DELETE FROM nagios_servicechecks WHERE start_time < FROM_UNIXTIME(1585320301)
CLEANING ndoutils TABLE 'hostchecks'...
SQL: DELETE FROM nagios_hostchecks WHERE start_time < FROM_UNIXTIME(1585320301)
CLEANING ndoutils TABLE 'eventhandlers'...
SQL: DELETE FROM nagios_eventhandlers WHERE start_time < FROM_UNIXTIME(1585320301)
LASTOPT: 1585318501
INTERVAL: 60
NOW: 1585320601
OPTTIME: 1585322101
CLEANING nagiosxi TABLE 'commands'...
SQL: DELETE FROM xi_commands WHERE processing_time < 1585291801::abstime::timestamp without time zone AND status_code = 2
CLEANING nagiosxi TABLE 'events'...
SQL: DELETE FROM xi_events WHERE processing_time < 1585291801::abstime::timestamp without time zone AND status_code = 2
CLEANING nagiosxi TABLE 'auth_tokens'...
SQL: DELETE FROM xi_auth_tokens WHERE auth_valid_until < 1585234201::abstime::timestamp without time zone
CLEANING nagiosxi TABLE 'cmp_trapdata_log'...
SQL: DELETE FROM xi_cmp_trapdata_log WHERE trapdata_log_datetime < 1577544601::abstime::timestamp without time zone
SQL1: SELECT xi_meta.meta_id FROM xi_meta LEFT JOIN xi_events ON xi_meta.metaobj_id=xi_events.event_id WHERE metatype_id='1' AND event_id IS NULL
LOCKFILE '/usr/local/nagiosxi/var/dbmaint.lock' EXISTS - EXITING!
LOCKFILE '/usr/local/nagiosxi/var/dbmaint.lock' EXISTS - EXITING!
LOCKFILE '/usr/local/nagiosxi/var/dbmaint.lock' EXISTS - EXITING!
[root@k]#

Lets run the following If it doesn't turn green after 15 minutes come back and we can dig further

I have ran the command below:

#rm -f /usr/local/nagiosxi/var/dbmaint.lock

But the Database Maintenance color is still RED kindly assist on this

Can you show the output of the following