Nagios Support Forum

Posted: **Wed Nov 25, 2015 12:16 pm**

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.

Posted: **Wed Nov 25, 2015 12:57 pm**

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.

Posted: **Wed Nov 25, 2015 1:15 pm**

tgriep wrote: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.

Posted: **Wed Nov 25, 2015 1:30 pm**

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

Posted: **Wed Nov 25, 2015 1:38 pm**

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.

Posted: **Wed Nov 25, 2015 2:05 pm**

Just to clarify, did that fix it then?

Posted: **Wed Nov 25, 2015 2:17 pm**

I am not seeing any other issues at this time.

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

Posted: **Wed Nov 25, 2015 2:22 pm**

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.

Nagios Support Forum

XI 5.2.2 (Waiting for configuration verification)

XI 5.2.2 (Waiting for configuration verification)

Re: XI 5.2.2 (Waiting for configuration verification)

Re: XI 5.2.2 (Waiting for configuration verification)

Re: XI 5.2.2 (Waiting for configuration verification)

Re: XI 5.2.2 (Waiting for configuration verification)

Re: XI 5.2.2 (Waiting for configuration verification)

Re: XI 5.2.2 (Waiting for configuration verification)

Re: XI 5.2.2 (Waiting for configuration verification)