NagiosXI Redirecting to install.php w/o install or upgrade

[crnelson]

Scenario
NagiosXI landing page redirecting to install.php, though no upgrade has been ran. There were no changes between 6pm yesterday and 8am this morning. Nagios Core still accessible and fully functional. No impact to notifications.

Host Details
Linux Distribution and version?
CentOS release 5.11 (Final)

32 or 64bit?
32bit

VMware Image or Manual Install of XI?
VMware Image

Special configurations?
Yes, using SSL with self-signed certificate

Other

Code: Select all

tail -f /var/log/httpd/error_log
[Tue Sep 29 09:50:52 2015] [error] [client *.*.*.*] PHP Warning:  The first parameter of bindtextdomain must not be empty in /usr/local/nagiosxi/html/includes/utils.inc.php on line 330
[Tue Sep 29 09:50:52 2015] [error] [client *.*.*.*] PHP Warning:  The first parameter of bindtextdomain must not be empty in /usr/local/nagiosxi/html/includes/utils.inc.php on line 330
[Tue Sep 29 09:50:52 2015] [error] [client *.*.*.*] script '/usr/local/nagiosxi/html/install.php' not found or unable to stat
[Tue Sep 29 09:51:03 2015] [error] [client *.*.*.*] script '/usr/local/nagiosxi/html/install.php' not found or unable to stat
[Tue Sep 29 09:51:05 2015] [error] [client *.*.*.*] PHP Warning:  The first parameter of bindtextdomain must not be empty in /usr/local/nagiosxi/html/includes/utils.inc.php on line 330, referer: https://hostname.domain.org/nagiosxi/install.php
WARNING:  database "postgres" must be vacuumed within 2280215 transactions
HINT:  To avoid a database shutdown, execute a full-database VACUUM in "postgres".
[Tue Sep 29 09:51:08 2015] [error] [client *.*.*.*] PHP Warning:  The first parameter of bindtextdomain must not be empty in /usr/local/nagiosxi/html/includes/utils.inc.php on line 330
[Tue Sep 29 09:51:09 2015] [error] [client *.*.*.*] PHP Warning:  The first parameter of bindtextdomain must not be empty in /usr/local/nagiosxi/html/includes/utils.inc.php on line 330

[hsmith]

What happens if you try to access https://x.x.x.x/nagiosxi ?

[crnelson]

https://x.x.x.x/nagiosxi redirects to https://x.x.x.x/nagiosxi/install.php

[crnelson]

Instead of redirecting to install.php, it started showing this error in the browser

Code: Select all

DB Connect Error [nagiosxi]: Database connection failed DB Connect Error [nagiosxi]: Database connection failed

I checked everything in https://support.nagios.com/forum/viewto ... 16&t=22283. There were no issues with space or inodes, so I restarted postgresql. It started OK.

Now I'm seeing this error in the httpd error.log

Code: Select all

[Tue Sep 29 10:58:17 2015] [error] [client *.*.*.*] PHP Warning:  pg_pconnect() [<a href='function.pg-pconnect'>function.pg-pconnect</a>]: PostgreSQL link lost, unable to reconnect in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-postgres64.inc.php on line 682
[Tue Sep 29 10:58:28 2015] [error] [client *.*.*.*] File does not exist: /usr/local/nagios/share/images/logos/snmptrap.png, referer: https://host.domain.org/nagios/cgi-bin/status.cgi?host=all
[Tue Sep 29 10:59:58 2015] [error] [client *.*.*.*] File does not exist: /usr/local/nagios/share/images/logos/snmptrap.png, referer: https://host.domain.org/nagios/cgi-bin/status.cgi?host=all
[Tue Sep 29 11:01:05 2015] [error] [client *.*.*.*] PHP Warning:  pg_pconnect() [<a href='function.pg-pconnect'>function.pg-pconnect</a>]: Unable to connect to PostgreSQL server: FATAL:  database is not accepting commands to avoid wraparound data loss in database "postgres"\nHINT:  Stop the postmaster and use a standalone backend to vacuum database "postgres". in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-postgres64.inc.php on line 682, referer: https://fwapp003.wvus.org/nagiosxi/install.php
[Tue Sep 29 11:01:05 2015] [error] [client *.*.*.*] PHP Warning:  pg_pconnect() [<a href='function.pg-pconnect'>function.pg-pconnect</a>]: Unable to connect to PostgreSQL server: FATAL:  database is not accepting commands to avoid wraparound data loss in database "postgres"\nHINT:  Stop the postmaster and use a standalone backend to vacuum database "postgres". in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-postgres64.inc.php on line 682, referer: https://fwapp003.wvus.org/nagiosxi/install.php

[crnelson]

I've followed https://support.nagios.com/forum/viewto ... 83&p=92511 - no fix.

This line didn't work, so reused the earlier statement from the post.

Code: Select all

postgres --single -D /var/lib/pgsql/data/ -O nagiosxi

[tmcdonald]

What XI version is this?

[crnelson]

Is there a quick way to do this from the CLI?

[crnelson]

Code: Select all

backend> bash-3.2$ echo "VACUUM FULL;" | postgres -D /var/lib/pgsql/data/ template1

PostgreSQL stand-alone backend 8.1.23
backend> backend> bash-3.2$ echo "VACUUM FULL;" | postgres -D /var/lib/pgsql/data/ nagiosxi

PostgreSQL stand-alone backend 8.1.23

Looks like this method worked. I started postgresql and I'm not redirected to a login page