Page 1 of 1

Change IP of offloaded DB host

Posted: Thu Jun 16, 2016 1:53 pm
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?

Re: Change IP of offloaded DB host

Posted: Thu Jun 16, 2016 2:07 pm
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.

Re: Change IP of offloaded DB host

Posted: Thu Jun 16, 2016 4:35 pm
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!