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

[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!

[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.

[ignacio.sanchez]

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.

[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!

[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!