Upgrade CentOS 7.9 to 9 in 4 instances of Nagios xi server

This support forum board is for support questions relating to Nagios xi, our flagship commercial network monitoring solution.
User avatar
ignacio.sanchez
Posts: 22
Joined: Thu Jun 25, 2020 4:46 am

Upgrade CentOS 7.9 to 9 in 4 instances of Nagios xi server

Post by ignacio.sanchez »

Hi all,

As you may know, CentOS 7 EOL will be on June 30, 2024, so we will need to upgrade our actual Nagios xi instances.

I already read the forums, and basically, an upgrade is not recommended and/or supported, so the better way of doing it is creating a new server.

And that's the point where I'm at.

I already created a new server using a Nagios xi OVA (nagiosxi-2024R1.0.1-64.ova), and then I followed the instructions in Nagios KB, that is:

https://assets.nagios.com/downloads/nag ... ios-xi.pdf

The backup was completed successfully, but the import in the new server is failing every time.

1)

Code: Select all

/usr/local/nagiosxi/scripts/restore_xi.sh /tmp/1707214089.tar.gz
2) It failed with the error:

Code: Select all

ERROR: Could not connect to localhost:3306 with root password supplied.
Please enter the MySQL root password:
3) Added skip-grant-tables in MySQL config file (/etc/my.cnf.d/mysql-server.cnf)
4) The next error message is:

Code: Select all

ERROR 2013 (HY000) at line 2244: Lost connection to MySQL server during query
Error restoring MySQL database 'nagios'
No matter what I do, it always fails with the same message (different line)

I tried adding the following to the MySQL config with no luck:

Code: Select all

[mysqld]
connect_timeout=300
net_read_timeout=7200
net_write_timeout=7200
max_allowed_packet=512M
I even tried to import nagios.sql manually with the following command, but again, same error message:

Code: Select all

cat /tmp/nagios.sql | mysql -u nagios -p'nagiosxi' -h "localhost" nagios

Code: Select all

ERROR 2013 (HY000) at line 494: Lost connection to MySQL server during query
Can you please let me know what else can I try?

Thank you!
Top
gwesterman
Posts: 258
Joined: Wed Aug 23, 2023 11:29 am

Re: Upgrade CentOS 7.9 to 9 in 4 instances of Nagios xi server

Post by gwesterman »

Hi @ignacio.sanchez,

Is the version of xi you are restoring from the same as the one you are restoring to (i.e. is the server on CentOS 7 also 2024R1.0.1)? In order for the backup and restore process to work properly, the two versions need to be the same and you can upgrade xi once the restore has been completed.
Top
User avatar
ignacio.sanchez
Posts: 22
Joined: Thu Jun 25, 2020 4:46 am

Re: Upgrade CentOS 7.9 to 9 in 4 instances of Nagios xi server

Post by ignacio.sanchez »

gwesterman wrote: ↑Thu Feb 08, 2024 10:12 am Hi @ignacio.sanchez,

Is the version of xi you are restoring from the same as the one you are restoring to (i.e. is the server on CentOS 7 also 2024R1.0.1)? In order for the backup and restore process to work properly, the two versions need to be the same and you can upgrade xi once the restore has been completed.
Hi @gwesterman,

Yes, both servers are in 2024R1.0.1, and the backup was made on that version too.
Top
User avatar
ignacio.sanchez
Posts: 22
Joined: Thu Jun 25, 2020 4:46 am

Re: Upgrade CentOS 7.9 to 9 in 4 instances of Nagios xi server

Post by ignacio.sanchez »

Hi all,

Do you know if there is a better method to migrate the servers or should I open a support ticket directly?

Thank you!
Top
gwesterman
Posts: 258
Joined: Wed Aug 23, 2023 11:29 am

Re: Upgrade CentOS 7.9 to 9 in 4 instances of Nagios xi server

Post by gwesterman »

Hi @ignacio.sanchez,

Sorry for the delay. I have not seen this error during migration before and I cannot find another instance of it happening to someone else. For quick resolution, I would suggest opening a support ticket at the Answer Hub. But, I will leave this thread open if I or someone else can find something helpful in the meantime.

Thank you!
Top
bekean23
Posts: 12
Joined: Sat Jul 01, 2023 11:39 pm

Re: Upgrade CentOS 7.9 to 9 in 4 instances of Nagios xi server

Post by bekean23 »

gwesterman wrote: ↑Wed Feb 14, 2024 10:03 am Hi @ignacio.sanchez,

Sorry for the delay. I have not seen this error during migration before and I cannot find another instance of it happening to someone else. For quick resolution, I would suggest opening a support ticket at the But, I will leave this thread open if I or someone else can find something helpful in the meantime.

Thank you!
I got it, thanks!
Top
willie34
Posts: 10
Joined: Wed Jul 05, 2023 8:34 pm

Re: Upgrade CentOS 7.9 to 9 in 4 instances of Nagios xi server

Post by willie34 »

you must migrate to a fresh installation of CentOS Stream 9 Geometry Dash Lite (or an alternative like Rocky Linux 9 or AlmaLinux 9) and then reinstall/configure Nagios xi.
Top

Return to “Nagios xi”