Restore from RHEL 5 to RHEL 7: Broken Database Backend

[christiandunn1]

RHEL 7.1
64-bit
Manual install

1. After running ./fullinstall on a fresh RHEL7.1 system everything seemed to be up and running correctly and the installation completed without issue.

2. When I run ./restore_xi for a backup created on RHEL 5 (same Nagios XI version) it correctly loads all the configs but the database backend fails to start. The message on the XI System Status page says "ndo2db is not running but subsystem locked". All other services seem be running without issue.

3. After following the restore doc https://assets.nagios.com/downloads/nag ... ios-XI.pdf and executing these commands

cd /tmp/nagiosxi
rm -f installed.subcomponents
./A-subcomponents

I receive a 403 Forbidden error on the XI login page. I receive the same error after running ./build-perms-bin as well.

I'm assuming this may have something to do with the switch to mariadb in RHEL but that is just a guess. I'll restore the system to the state at point 2 and await help!

Output from the end of the restore script:

Restarting database servers...
./restore_xi.sh: line 187: /etc/init.d/mysqld: No such file or directory
./restore_xi.sh: line 188: /etc/init.d/postgresql: No such file or directory
Restoring logrotate config files...
Restoring Apache config files...
./restore_xi.sh: line 216: /etc/init.d/httpd: No such file or directory
NPCD started.
Starting ndo2db (via systemctl): [ OK ]
Starting nagios (via systemctl): [ OK ]

===============
RESTORE COMPLETE
===============

[jdalrymple]

The HUGEST problem is that our backup and restore script copes /usr/local/nagios/bin and all of its contents, so your ndo binaries get moved even though they were created on a separate platform. If after the restore you re-untar then run ./upgrade it will probably resolve your problem. For other customers I've alternatively just modified the backup script to *NOT* include that bin directory.

[christiandunn1]

Thanks, that seems to have fixed it!

Running ./upgrade gave me back the forbidden issue (I'll have to make a separate post for that) but just manually removing the /usr/local/nagios/bin directory from the backup tarfile before restoring worked like a charm.

EDIT: FYI, the forbidden is caused by having and older version of Apache on RHEL 5 compared to RHEL 7.

2.2 configuration:

Order allow,deny
Allow from all

2.4 configuration:

Require all granted

[lmiltchev]

christiandunn1, is it OK to lock this topic?

[christiandunn1]

Yes, this has been resolved and can be locked.