NagiosXI-Upgrade with Remote DB

[maartin.pii]

Hi Guys,

I have the following scenario:

- 1 VM - NagiosXI 5.2.9
- 1 VM - Mysql (DB Offload)

And I want to update Nagios to its latest version - The question is if this is possible on this scenario where the DB resides on another server.

Thanks,

Regards,

[dwhitfield]

The simple answer is yes. You'll obviously want to test it first. If you run into any issues in your test, we can help you with those here.

[maartin.pii]

The simple answer is yes. You'll obviously want to test it first. If you run into any issues in your test, we can help you with those here.

But this is supported by Nagios? I will obviously test it first - However, I am not sure if the update change my configurations files of the offload or if it need to do any kind of work as root user on the db.

Regards,

[dwhitfield]

But this is supported by Nagios?

Yes. Sorry for the lack of clarity on that point. The major known complication is that if the MySQL version is upgraded you will need to upgrade the MySQL manually on the remote server. Otherwise, things should run smoothly.

[maartin.pii]

But this is supported by Nagios?

Yes. Sorry for the lack of clarity on that point. The major known complication is that if the MySQL version is upgraded you will need to upgrade the MySQL manually on the remote server. Otherwise, things should run smoothly.

Thanks! Do you know which version of MySQL is it upgraded to? Regardless of it, is there any kind of changes on the db instances or talbes of them?

Regards,

[dwhitfield]

I've got 5.5.50-MariaDB on Cent 7. It's going to depend on your OS, but I see from your other thread you have RHEL 7.2. Actual MySQL will work too. It's different on different OSes though, so it's just something you'll have to check each time you upgrade. For example, I've got 5.0.95 on Cent 5. I just ran yum update on both of them to make sure I was on the latest version.

Upgrades often present issues, but the offloaded db shouldn't really cause any more issues than a regular upgrade.

[maartin.pii]

Hi Guys,

I was wondering... may I better install a fresh new server with Nagios 5.3.3 and do an import of the config files rather than doing the upgrade?

What do you think about it?

Regards,

[dwhitfield]

I can't tell you that neither one of these will run into issues. We do offer consulting if you want us to do the migration. Both methods should work.

The biggest issues we have is with old postgres installations. As long as everything is MySQL, you really shouldn't run into problems.

You've not mentioned any postgres, but we've had so many people ask about it, that we came out with a migration document today: https://support.nagios.com/kb/article.php?id=560. If that 5.2.9 install was fresh, then you have nothing to worry about. If it is an upgrade from a 2014 or earlier version of Nagios (before we changed the naming scheme), then you'll want to go through the migration document.

[maartin.pii]

Hi Guys,

As I am migrating from the previous version I didn't have a postgres db - However, when trying to upadate I ran into the following error:

Code: Select all

Done!
Dashlets installed/updated OK
ERROR 2005 (HY000): Unknown MySQL server host 'IP:1971' (0)

I wanted to mention that the DB is configured on a non standard port, so the workaround that I found to it was configuring the connection to the db like this IP:PORT

My Config Files:

/usr/local/nagios/etc/ndo2db.cfg

db_servertype=mysql
db_host=IP
db_port=1971

/usr/local/nagiosxi/html/config.inc.php

"dbserver" => 'IP:1971',

/var/www/html/nagiosql/config/settings.php


[db]
server = IP
port = 1971
database = nagiosql
username = nagiosql
password = nagiosql


So in /usr/local/nagiosxi/var/xi-sys.cfg file the configuration is like this:


cfg__db_info__nagiosxi__dbserver='IP:1971'


Reference Case -> https://support.nagios.com/forum/viewto ... ad#p195608


Any ideas?

Regards,

[ssax]

Since you have created a ticket for this I will be locking this topic and we will continue support in the ticket.

Thank you