Nagios backupstipt and remote db's

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: Nagios backupstipt and remote db's

Post by tmcdonald »

Let us know, yo, bro!
Former Nagios employee
User avatar
benhank
Posts: 1264
Joined: Tue Apr 12, 2011 12:29 pm

Re: Nagios backupstipt and remote db's

Post by benhank »

Boink!

A looooong time ago there was a doc that detailed performing a manual restore of nagios. Does anyone have the link? or is thier an updated version available?
Proudly running:
NagiosXI 5.4.12 2 node Prod Env 2500 hosts, 13,000 services
Nagiosxi 5.5.7(test env) 2500 hosts, 13,000 services
Nagios Logserver 2 node Prod Env 500 objects sending
Nagios Network Analyser
Nagios Fusion
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: Nagios backupstipt and remote db's

Post by rkennedy »

Former Nagios Employee
User avatar
benhank
Posts: 1264
Joined: Tue Apr 12, 2011 12:29 pm

Re: Nagios backupstipt and remote db's

Post by benhank »

How do I restore an XI backup that had an offloaded database to another XI server that has a different offloaded database server?

Additionally if I was restoring for testing purposes and my test server I am restoring to doesn't have an offloaded database server how do I restore the original backup to the test server?
Proudly running:
NagiosXI 5.4.12 2 node Prod Env 2500 hosts, 13,000 services
Nagiosxi 5.5.7(test env) 2500 hosts, 13,000 services
Nagios Logserver 2 node Prod Env 500 objects sending
Nagios Network Analyser
Nagios Fusion
jdalrymple
Skynet Drone
Posts: 2620
Joined: Wed Feb 11, 2015 1:56 pm

Re: Nagios backupstipt and remote db's

Post by jdalrymple »

benhank wrote:How do I restore an XI backup that had an offloaded database to another XI server that has a different offloaded database server?
Untar the backup, modify the config, retar. - that's a guess and would have to be tested in a lab, but I know of no reason why it wouldn't work.
benhank wrote:Additionally if I was restoring for testing purposes and my test server I am restoring to doesn't have an offloaded database server how do I restore the original backup to the test server?
Same process, just 'localhost' instead of 'offloaded dbhost'
User avatar
Box293
Too Basu
Posts: 5126
Joined: Sun Feb 07, 2010 10:55 pm
Location: Deniliquin, Australia
Contact:

Re: Nagios backupstipt and remote db's

Post by Box293 »

jdalrymple wrote:
benhank wrote:How do I restore an XI backup that had an offloaded database to another XI server that has a different offloaded database server?
Untar the backup, modify the config, retar. - that's a guess and would have to be tested in a lab, but I know of no reason why it wouldn't work.
benhank wrote:Additionally if I was restoring for testing purposes and my test server I am restoring to doesn't have an offloaded database server how do I restore the original backup to the test server?
Same process, just 'localhost' instead of 'offloaded dbhost'
I think the restore scripts need to be more accommodating for these situations. I tried exactly what you suggested last week and it was a real headache and I couldn't get it to work.

Feature request or bug report?
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
User avatar
Box293
Too Basu
Posts: 5126
Joined: Sun Feb 07, 2010 10:55 pm
Location: Deniliquin, Australia
Contact:

Re: Nagios backupstipt and remote db's

Post by Box293 »

I think I have found something that will be causing some issues with backups and restores.

In this file on your source server:

/usr/local/nagiosxi/var/xi-sys.cfg

Does it have a bunch of lines starting with:

cfg__
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
pkarr
Posts: 58
Joined: Fri Oct 05, 2012 1:01 pm

Re: Nagios backupstipt and remote db's

Post by pkarr »

Hi Box 293,

benhank is out sick so I am taking over for him on this.

yes, there is xi-sys.cfg in /usr/local/nagiosxi/var on the source server
with a bunch of lines starting with cfg__

Interesting. What is it? I don't recall editing it.

I've included it as an attachment

Thanks,
Penny Karr | IT Infrastructure Monitoring
Harvard Vanguard Medical Associates, an Affiliate of Atrius Health
254 Second Avenue | Needham, MA 02494
P (781) 292-1853 | F (781 292-1980 | http://www.harvardvanguard.org
Email: [email protected]
Last edited by pkarr on Fri Dec 04, 2015 3:03 pm, edited 1 time in total.
User avatar
Box293
Too Basu
Posts: 5126
Joined: Sun Feb 07, 2010 10:55 pm
Location: Deniliquin, Australia
Contact:

Re: Nagios backupstipt and remote db's

Post by Box293 »

This file gets created/updated during a full install or upgrade. We've recently found with the newer versions of XI that it is being populated with all of these cfg__ values and this in turn is affecting the backup and restore process (it won't be affecting your current backups though, don't be alarmed).

I'm doing some testing on a beta version of XI so once I get my head around this I'll get back to you and Ben once I've got a better idea.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Locked