Nagios Support Forum

Code: Select all

[root@newnagiosxi nagiosxi]# /usr/local/nagiosxi/scripts/restore_xi.sh  /store/backups/nagiosxi/1505986286.tar.gz
WARNING: you are trying to restore a i386 backup on a x86_64 system
         Compiled plugins and other binaries will NOT be restored.

Are you sure you want to continue? [y/N] y
WARNING: you are trying to restore a OS 5 backup on a OS 7 system
         Compiled plugins and other binaries as well as httpd configurations
         will NOT be restored.

Are you sure you want to continue? [y/N] y
TS=1506241895
Extracting backup to /store/backups/nagiosxi/1506241895-restore...
In /store/backups/nagiosxi/1506241895-restore/1505986286...
Backup files look okay.  Preparing to restore...
Shutting down services...
Restoring directories to /...
Restoring Nagios Core...
Restoring Nagios XI...
Restoring NagiosQL...
Restoring NagiosQL backups...
Restoring NRDP backups...
Restoring MRTG...
Restoring Nagvis backups...
chown: cannot access â/usr/local/nagvisâ: No such file or directory
Restoring MySQL databases...
Redirecting to /bin/systemctl start  postgresql.service
Job for postgresql.service failed because the control process exited with error code. See "systemctl status postgresql.service" and "journalctl -xe" for details.
Restoring Nagios XI PostgresQL database...
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Error restoring PostgresQL database 'nagiosxi' !
You have new mail in /var/spool/mail/root

Code: Select all

yum install postgresql postgresql-devel postgresql-libs postgresql-server php-pgsql -y

Code: Select all

Extracting backup to /store/backups/nagiosxi/1506421212-restore...
In /store/backups/nagiosxi/1506421212-restore/1505986286...
Backup files look okay.  Preparing to restore...
Shutting down services...
Restoring directories to /...
Restoring Nagios Core...
Restoring Nagios XI...
Restoring NagiosQL...
Restoring NagiosQL backups...
Restoring NRDP backups...
Restoring MRTG...
Restoring Nagvis backups...
chown: cannot access â/usr/local/nagvisâ: No such file or directory
Restoring MySQL databases...
Redirecting to /bin/systemctl start  postgresql.service
Restoring Nagios XI PostgresQL database...
psql: FATAL:  Peer authentication failed for user "nagiosxi"
Error restoring PostgresQL database 'nagiosxi' !

Code: Select all

psql -c "create user nagiosxi with password 'n@gweb';"
psql -c "create database nagiosxi owner nagiosxi;"

Code: Select all

[root@newnagiosxi ~]# su - postgres
Last login: Tue Sep 26 21:09:45 AEST 2017 on pts/0
-bash-4.2$ psql -c "create user nagiosxi with password 'n@gweb';"
CREATE ROLE
-bash-4.2$ psql -c "create database nagiosxi owner nagiosxi;"
CREATE DATABASE
-bash-4.2$ exit
logout

Code: Select all

/var/lib/pgsql/data/pg_hba.conf

Code: Select all

local   all         all                               trust
host    all         all         127.0.0.1/32          trust
host    all         all         ::1/128               trust

Code: Select all

service postgresql restart

Code: Select all

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5

Code: Select all

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