Page 1 of 1

Configuration save issue

Posted: Thu Mar 14, 2013 6:56 am
by cvanleke
Hello,

I'm suddenly having trouble saving my configuration after adding hosts, editing and/or deleting services. Everything worked for weeks. Configurations failed to write to file.
All snapshots seem to be okay.

I have the following setup:

Code: Select all

System:
Nagios XI Version : 2012R1.5
nagios.dc-******** 2.6.32-279.5.1.el6.x86_64 x86_64
CentOS release 6.3 (Final)
Gnome is not installed
Apache Information
PHP Version: 5.3.3
Agent: Mozilla/5.0 (Windows NT 5.2; rv:19.0) Gecko/20100101 Firefox/19.0
Server Name: 192.168.25.250
Server Address: 192.168.25.250
Server Port: 443
Date/Time
PHP Timezone: America/Chicago
PHP Time: Thu, 14 Mar 2013 06:49:04 -0500
System Time: Thu, 14 Mar 2013 12:49:04 +0100
Nagios XI Data
nagios (pid 19441) is running...
NPCD running (pid 1679).
ndo2db (pid 7369) is running...
CPU Load 15: 4.74
Total Hosts: 33
Total Services: 747
Function 'get_base_uri' returns: https://192.168.25.250/nagiosxi/
Function 'get_base_url' returns: https://192.168.25.250/nagiosxi/
Function 'get_backend_url(internal_call=false)' returns: https://192.168.25.250/nagiosxi/includes/components/profile/profile.php
Function 'get_backend_url(internal_call=true)' returns: https://localhost/nagiosxi/backend/
Ping Test localhost
Running:

/bin/ping -c 3 localhost 2>&1 

PING localhost (127.0.0.1) 56(84) bytes of data.
From localhost (127.0.0.1) icmp_seq=1 Destination Host Prohibited
From localhost (127.0.0.1) icmp_seq=2 Destination Host Prohibited
From localhost (127.0.0.1) icmp_seq=3 Destination Host Prohibited

--- localhost ping statistics ---
3 packets transmitted, 0 received, +3 errors, 100% packet loss, time 2000ms

Test wget To locahost
WGET From URL: http://localhost/nagiosql/index.php
Running:

/usr/bin/wget http://localhost/nagiosql/index.php 

--2013-03-14 12:49:07-- http://localhost/nagiosql/index.php
Resolving localhost... 127.0.0.1, ::1
Connecting to localhost|127.0.0.1|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 5259 (5.1K) [text/html]
Saving to: `/tmp/nagiosql_index.tmp'

0K ..... 100% 325M=0s

2013-03-14 12:49:07 (325 MB/s) - `/tmp/nagiosql_index.tmp' saved [5259/5259]


A tail -f of cmdsubsys.log shows that it hangs on

Code: Select all

/usr/bin/wget --save-cookies nagiosql.cookies --keep-session-cookies http://localhost/nagiosql/index.php --no-check-certificate --post-data 'Submit=Login&tfUsername=nagiosxi&tfPassword=io9750' -O nagiosql.loginLOGIN SUCCESSFUL!
URL: http://localhost/nagiosql/admin/verify.php
CMDLINE:
/usr/bin/wget --load-cookies=nagiosql.cookies http://localhost/nagiosql/admin/verify.php --no-check-certificate --post-data 'writeMonitoring=Go' -O nagiosql.export.monitoring
--2013-03-14 12:33:59--  http://localhost/nagiosql/admin/verify.php
Resolving localhost... 127.0.0.1, ::1
Connecting to localhost|127.0.0.1|:80... connected.
HTTP request sent, awaiting response... tail: /usr/local/nagiosxi/var/cmdsubsys.log: file truncated
..........................................................tail: /usr/local/nagiosxi/var/cmdsubsys.log: file truncated
..
PROCESSED 0 COMMANDS
200 OK
Length: 4788 (4.7K) [text/html]
Saving to: `nagiosql.export.monitoring'

     0K ....                                                  100%  285M=0s

2013-03-14 12:35:32 (285 MB/s) - `nagiosql.export.monitoring' saved [4788/4788]

NAGIOSQL WRITE CONFIGS FAILED!\n
OUTPUT=NAGIOSQL WRITE CONFIGS FAILED!\n
RETURNCODE=5
I know that there is an entry on the FAQ about this problem, but it doesn't really help me. Same thing with extensive google searches.
What could be the problem?

Let me know if you need more info on this.

thanks

Christophe

Re: Configuration save issue

Posted: Thu Mar 14, 2013 8:46 am
by scottwilkerson
This could be a limit in /etc/php.ini max_execution_time being hit, see
http://support.nagios.com/wiki/index.ph ... _Completes

additionally I noticed that your timezones are not synced..
cvanleke wrote:

Code: Select all

PHP Time: Thu, 14 Mar 2013 06:49:04 -0500
System Time: Thu, 14 Mar 2013 12:49:04 +0100
There is a good guide on that here
http://support.nagios.com/forum/viewtop ... 962#p24962

Re: Configuration save issue

Posted: Thu Mar 14, 2013 9:09 am
by cvanleke
That seemed to work, many thanks!

Christophe

Re: Configuration save issue

Posted: Thu Mar 14, 2013 4:28 pm
by slansing
Great! Locking thread.