XI 5.2.2 (Waiting for configuration verification)

[Waynej]

Our Nagios XI server is running and successfully collecting check data.
But administrative operations are not completing.

Lots of problems in Apache log

Code: Select all

[Tue Nov 24 14:49:58.105826 2015] [:error] [pid 32650] [client :50084] PHP Warning:  simplexml_load_string():     SQL:     SQL Error [nagiosxi] :</b> ERROR:  invalid input syntax for integer in /usr/local/nagiosxi/html/includes/utils-backend.inc.php on line 54, referer: http://nagios.production.com/nagiosxi/includes/components/nagioscorecfg/applyconfig.php?cmd=confirm
[Tue Nov 24 14:53:38.439276 2015] [:error] [pid 22768] [client ::1:46208] PHP Notice:  Undefined index: ccm_language in /usr/local/nagiosxi/html/includes/components/ccm/includes/common_functions.inc.php on line 719
[Tue Nov 24 14:53:38.439332 2015] [:error] [pid 22768] [client ::1:46208] PHP Notice:  Undefined index: language in /usr/local/nagiosxi/html/includes/components/ccm/includes/common_functions.inc.php on line 719
[Tue Nov 24 17:40:07.564342 2015] [:error] [pid 9969] [client :65510] PHP Warning:  mysql_pconnect(): Link to server lost, unable to reconnect in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://nagios.production.com/nagiosxi/admin/main.php?&=
[Tue Nov 24 17:40:07.597902 2015] [mpm_prefork:notice] [pid 22603] AH00170: caught SIGWINCH, shutting down gracefully

Nagios XI 5.2.2

Linux Distribution and version?
CentOS 7.1.1503 64bit
Manual install in vmware

Full profile attached

Before I saw the sql errors:
I did run repair_databases with no issues.
I increased the Resource Limits in /etc/php.ini.

I have a backup from the 22nd and a config from the 23rd.

*Edit* Some of these errors appear to be caused by me not updating the hosts file with all of the aliases.

[tgriep]

One thing that looks wrong is that the crond daemon isn't running correctly so can you run the following as root on the XI system?

Code: Select all

killall -9 crond
service crond start

Then run this tail command on the system, Apply the Configuration and post the output from the tail.

Code: Select all

tail -f /usr/local/nagiosxi/var/cmdsubsys.log

This should provide more information on why the Apply isn't running.

[Waynej]

One thing that looks wrong is that the crond daemon isn't running correctly so can you run the following as root on the XI system?

Code: Select all

killall -9 crond
service crond start

Then run this tail command on the system, Apply the Configuration and post the output from the tail.

Code: Select all

tail -f /usr/local/nagiosxi/var/cmdsubsys.log

This should provide more information on why the Apply isn't running.

Code: Select all

[var]$ tail -f /usr/local/nagiosxi/var/cmdsubsys.log
............................................................
PROCESSED 0 COMMANDS

The changes I made through ccm did apply, but the "Waiting for configuration verification......." page is still showing as loading.

I really appreciate your assistance, thank you.

[tgriep]

Can you restart the Apache web server by running the following as root?

Code: Select all

service httpd restart

Lets try and run the reconfigure as the nagios used and see if this generates any errors.
Run this in a shell on the XI system and post the output.

Code: Select all

cd /usr/local/nagiosxi/scripts
su nagios
./reconfigure_nagios.sh

Thanks

[Waynej]

That went through lickety split.

Code: Select all

Total Errors:   0

Things look okay - No serious problems were detected during the pre-flight check
RET: 0

The XI UI apply command seems to be functioning as well now.

[rkennedy]

Just to clarify, did that fix it then?

[Waynej]

I am not seeing any other issues at this time.

Thank you and have a nice holiday if you celebrate it.

[bwallace]

Thanks, and you have a good holiday as well. We'll go ahead and close this thread out now since you are no longer seeing any issues.