Change IP of offloaded DB host

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Change IP of offloaded DB host

Post by BanditBBS »

Ok, so I have NDO2DB and MySQLD both offloaded. I want to change the IP of the mysql server. I just tried and failed, I think I know where the issue lies, but want to verify before I try again.

On offloaded server:
Stop mysqld and ndo2db
Change IP of host
Change bind IP in /etc/my.cnf
No need to change IP on ndo configuration as it is set for "localhost"
restart services

On XI Host:
stop service nagiosxi, nagios, postgresql
Modify the IP in 2 spots in /usr/local/nagiosxi/html/config.inc.php
Modify IP of NDO server in /usr/local/nagiosxi/var/xi-sys.cfg (this is the part I missed)
start service nagiosxi, nagios, postgresql

Does that sound like everything?
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Change IP of offloaded DB host

Post by tgriep »

Take a look at this document for offloading the mysql database for XI.
https://assets.nagios.com/downloads/nag ... Server.pdf
It looks like you missed these files for the changes.
/usr/local/nagios/etc/ndo2db.cfg
/var/www/html/nagiosql/config/settings.php
Try that and let us know the outcome.
Be sure to check out our Knowledgebase for helpful articles and solutions!
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Re: Change IP of offloaded DB host

Post by BanditBBS »

yeah, doing everything I said plus what you said and I'm golden....everything working fine...now no hops between the servers :)

Close this up!
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
Locked