Restoring from Nagios 2014 to Nagios 2016(latest release)

[sarfarosh]

Hi Team,

I have successfully installed Nagios 5.2.5 in "CentOS release 6.7". After that I have tried to restore nagios from oldersystem (which was using Nagios XI 2014R1.4). While restoring I am getting below error message :

Code: Select all

# /usr/local/nagiosxi/scripts/restore_xi.sh /tmp/1455259902.tar.gz 
TS=1456229486
Extracting backup to /store/backups/nagiosxi/1456229486-restore...
In /store/backups/nagiosxi/1456229486-restore/1455259902...
Backup files look okay.  Preparing to restore...
Shutting down services...
Stopping nagios:. done.
Stopping ndo2db: done.
NPCD Stopped.
Restoring directories to /...
Restoring Nagios Core...
Restoring Nagios XI...
Restoring NagiosQL...
Restoring NagiosQL backups...
Restoring MRTG...
Restoring MySQL databases...
Restoring PostgresQL databases...
psql: could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Error restoring PostgresQL database 'nagiosxi' !
You have new mail in /var/spool/mail/root

After that I have started all the required services. Now I am not getting anything in Nagios gui. Refer attached screenshot.

Please help me to resolve this issue.

[lmiltchev]

I have successfully installed Nagios 5.2.5 in "CentOS release 6.7"

Was this a clean, new install or an upgrade from an older XI version?

Please, show us the "/usr/local/nagiosxi/scripts/restore_xi.sh" file from this system (in code wraps).

Also, run the following command, and show the output:

Code: Select all

rpm -qa | grep postgres
tar -ztvf xxxxxxx.tar.gz | grep pgsql

where the "xxxxxxx.tar.gz" is the backup you restored from (the one that you copied over from the old server).

Run the following command on the old server, and show the output:

Code: Select all

echo '\d'|psql nagiosxi nagiosxi