Upgrade CentOS 7.9 to 9 in 4 instances of Nagios XI server
Posted: Thu Feb 08, 2024 7:26 am
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)
2) It failed with the error:
3) Added skip-grant-tables in MySQL config file (/etc/my.cnf.d/mysql-server.cnf)
4) The next error message is:
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:
I even tried to import nagios.sql manually with the following command, but again, same error message:
Can you please let me know what else can I try?
Thank you!
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.gzCode: Select all
ERROR: Could not connect to localhost:3306 with root password supplied.
Please enter the MySQL root password: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'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=512MCode: Select all
cat /tmp/nagios.sql | mysql -u nagios -p'nagiosxi' -h "localhost" nagiosCode: Select all
ERROR 2013 (HY000) at line 494: Lost connection to MySQL server during queryThank you!