Nagios Support Forum

Code: Select all

tail -f /var/log/httpd/error_log
[Wed Jan 13 18:20:05 2016] [error] [client 10.10.83.91] PHP Notice:  Undefined variable: result in /usr/local/nagiosxi/html/includes/db.inc.php on line 249
[Wed Jan 13 18:20:05 2016] [error] [client 10.10.83.91] PHP Warning:  pg_pconnect(): Unable to connect to PostgreSQL server: could not connect to server: No such file or directory\n\tIs the server running locally and accepting\n\tconnections on Unix domain socket "/tmp/.s.PGSQL.5432"? in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-postgres64.inc.php on line 682
[Wed Jan 13 18:20:05 2016] [error] [client 10.10.83.91] PHP Notice:  Undefined variable: result in /usr/local/nagiosxi/html/includes/db.inc.php on line 249
[Wed Jan 13 18:20:05 2016] [error] [client 10.10.83.91] PHP Warning:  pg_pconnect(): Unable to connect to PostgreSQL server: could not connect to server: No such file or directory\n\tIs the server running locally and accepting\n\tconnections on Unix domain socket "/tmp/.s.PGSQL.5432"? in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-postgres64.inc.php on line 682
[Wed Jan 13 18:20:05 2016] [error] [client 10.10.83.91] PHP Notice:  Undefined variable: result in /usr/local/nagiosxi/html/includes/db.inc.php on line 249
[Wed Jan 13 18:20:05 2016] [error] [client 10.10.83.91] PHP Warning:  pg_pconnect(): Unable to connect to PostgreSQL server: could not connect to server: No such file or directory\n\tIs the server running locally and accepting\n\tconnections on Unix domain socket "/tmp/.s.PGSQL.5432"? in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-postgres64.inc.php on line 682
[Wed Jan 13 18:20:05 2016] [error] [client 10.10.83.91] PHP Notice:  Undefined variable: result in /usr/local/nagiosxi/html/includes/db.inc.php on line 249
[Wed Jan 13 18:20:05 2016] [error] [client 10.10.83.91] PHP Warning:  pg_pconnect(): Unable to connect to PostgreSQL server: could not connect to server: No such file or directory\n\tIs the server running locally and accepting\n\tconnections on Unix domain socket "/tmp/.s.PGSQL.5432"? in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-postgres64.inc.php on line 682

Code: Select all

Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.

Run the following from the CLI as root to attempt to repair the DB

/usr/local/nagiosxi/scripts/repair_databases.sh

Code: Select all

service postgresql stop
su postgres
echo "VACUUM FULL;" > /tmp/fix.sql
postgres -D /var/lib/pgsql/data nagiosxi < /tmp/fix.sql
postgres -D /var/lib/pgsql/data postgres < /tmp/fix.sql
postgres -D /var/lib/pgsql/data template1 < /tmp/fix.sql
exit
service postgresql start

Code: Select all

service postgresql stop
Stopping postgresql service:                               [FAILED]
[root@lcnhkpnagiosxi00 nagiosxi]# service postgresql start
Starting postgresql service:                               [  OK  ]
[root@lcnhkpnagiosxi00 nagiosxi]# service postgresql stop
Stopping postgresql service:                               [FAILED]

Code: Select all

[root@lcnhkpnagiosxi00 nagiosxi]# su postgres
bash-4.1$ echo "VACUUM FULL;" > /tmp/fix.sql
bash-4.1$ postgres -D /var/lib/pgsql/data nagiosxi < /tmp/fix.sql
postgres: invalid argument: "nagiosxi"
Try "postgres --help" for more information.
bash-4.1$ postgres -D /var/lib/pgsql/data postgres < /tmp/fix.sql
postgres: invalid argument: "postgres"
Try "postgres --help" for more information.
bash-4.1$ postgres -D /var/lib/pgsql/data template1 < /tmp/fix.sql
postgres: invalid argument: "template1"
Try "postgres --help" for more information.

Code: Select all

After todays' remote we identified the mysql Nagios database needed to be restored due to some corrupted tables.

After doing this we found that we also needed to reset the permissions on the postgres data folder.

Once this was done everything started working as expected.