Page 1 of 1

nagiosql write configs failed

Posted: Wed Aug 15, 2012 10:46 am
by mcwhorts
I just finished upgrading nagios xi from 2.1 to 3.2 and I think there might be a problem with the upgrade. I got the error "NAGIOSQL WRITE CONFIGS FAILED" at the end of the process. I logged into nagios and finished the upgrade but the status icon for the system is red for monitoring engine not running. When I try to start it from the gui, I get an error "An error occurred processing your request." I've attached my system profile.
profile.txt
Any ideas?

Re: NAGIOSQL WRITE CONFIGS FAILED

Posted: Wed Aug 15, 2012 11:04 am
by lmiltchev
Try following the steps outlined here:

http://support.nagios.com/wiki/index.ph ... n_Problems

Also, run the following command and post the output:

Code: Select all

ll /usr/local/nagiosxi/scripts

Re: NAGIOSQL WRITE CONFIGS FAILED

Posted: Wed Aug 15, 2012 11:19 am
by mcwhorts
Here are the outputs you asked for.

Thanks
cmd.txt
reconfig.txt
scripts.txt

Re: nagiosql write configs failed

Posted: Wed Aug 15, 2012 11:37 am
by scottwilkerson
This looks like it may be caused by php reaching a max execution time

Increasing this is outlined here
http://support.nagios.com/wiki/index.ph ... _Completes

Re: nagiosql write configs failed

Posted: Wed Aug 15, 2012 11:59 am
by mcwhorts
I believe that was the problem. I am able to write configs now and do apply configurations. Thanks for all your help.

Re: nagiosql write configs failed

Posted: Wed Aug 15, 2012 12:35 pm
by scottwilkerson
Glad to hear you got it working.