fail to restore nagiosxi 5.2.3

[vy3734]

i'm having a server running 5.2.3 and trying to restore everything to another server so it has the exact copy.

1. install brand new version of 5.2.3 to new server.
2. make a back up from existing server.
3. move back up file to new server and doing restore.

got following errors.

./restore_xi.sh /www/backups/nagiosxi/1477340370.tar.gz
TS=1477403758
Extracting backup to /store/backups/nagiosxi/1477403758-restore...
In /store/backups/nagiosxi/1477403758-restore/1477340370...
Backup files look okay. Preparing to restore...
Shutting down services...
Stopping nagios:/etc/init.d/nagios: line 142: kill: (20594) - No such process
done.
ndo2db was not running... could not stop
NPCD was not running.
Restoring directories to /...
Restoring Nagios Core...
Restoring Nagios XI...
Restoring NagiosQL...
Restoring NagiosQL backups...
Restoring NRDP backups...
Restoring MRTG...
Restoring Nagvis backups...
Restoring MySQL databases...
Starting postgresql service: [ OK ]
Restoring Nagios XI PostgresQL database...
psql: FATAL: Ident authentication failed for user "nagiosxi"
Error restoring PostgresQL database 'nagiosxi' !

[rkennedy]

My guess, is your previous installation was probably running as an upgrade from a previous version. The newer versions of Nagios use MySQL moving forward, but in the past we used postgres.

Are you able to create a postgres username for nagiosxi on the new machine? You may need to do this manually.

[vy3734]

yes this works fine. thanks

[avandemore]

That's great, is it okay to lock this thread then?

[vy3734]

yes, thanks.