Unable to upgrade to latest version

[markmerchant]

Was not able to upgrade to the latest. Tried first from the UI , received DB
error. Ran the DB maintenance and tried again, different error.

Next tried a manual upgrade, got compile errors. Pls. advise, Thx.

Code: Select all

Ver
	Nagios XI 5.4.7
	
uname -a
	Linux cvglqnagios01.xxx.xxx 3.10.0-957.5.1.el7.x86_64 #1 SMP Wed Dec 19
	10:46:58 EST 2018 x86_64 x86_64 x86_64 GNU/Linux

1st UI try:
	mysqldump: Got error: 144: "Table './nagios/nagios_processevents' is marked
	as crashed and last (automatic?) repair failed" when using LOCK TABLES
	Error backing up MySQL database 'nagios' - check the password in this script!
	
2nd UI try:
	mysqldump: Got error: 1034: "Incorrect key file for table
	'nagios_systemcommands'; try to repair it" when using LOCK TABLES

	Error backing up MySQL database 'nagios' - check the password in this
	script!
	
1st manual try
	db.c:569:32: error: ‘ndo2db_dbconninfo’ has no member named ‘mysql_result’
	   mysql_free_result(idi->dbinfo.mysql_result);
									^
	db.c:570:14: error: ‘ndo2db_dbconninfo’ has no member named ‘mysql_result’
	   idi->dbinfo.mysql_result=NULL;
				  ^
	make[2]: *** [db.o] Error 1
	make[2]: Leaving directory `/tmp/nagiosxi/subcomponents/ndoutils/ndoutils-2.1.3/src'
	make[1]: *** [ndo2db] Error 2
	make[1]: Leaving directory `/tmp/nagiosxi/subcomponents/ndoutils/ndoutils-2.1.3/src'
	make: *** [all] Error 2

[tgriep]

First, lets make sure the MYSQL databases are repaired.
Run the following as root to repair all of the databases.

Code: Select all

mysqlcheck -f -r -u root -pnagiosxi --all-databases --use_frm

The compile error leads me to beleave that the mysql-devel package is not installed on the server.
Run the following as root to install it.

Code: Select all

yum install -y mysql-devel

Then try the Manual XI upgrade again.
If it fails, get the upgrade.log file from the /tmp/nagiosxi folder and upload it to the post.

[markmerchant]

Manual upgrade appears to have worked. Will test for a week or so before proceeding
to the prod environment.

Thx.

[tgriep]

Thanks for the update. Let us know if you have any further questions.