Page 1 of 1
A strange problems after the upgrade!
Posted: Tue Jan 14, 2014 3:28 am
by huanhuan7777
After the upgrade,I visit the url
http://nagios server IP/nagiosxi/,the interface is still point to Check for updates.
I choose Check for updates，it is "Your installation of Nagios XI (2012R2.7) is up-to-date, so no upgrade is required. The latest version of Nagios XI is 2012R2.7, which was released on 2013-11-26. "
The interface like this:[img]
nagios.jpg
[/img]
Help me!
Thank you very much~~~
Re: A strange problems after the upgrade!
Posted: Tue Jan 14, 2014 11:58 am
by slansing
Please log out, and then log back into the interface, also show the output of the following:
Code: Select all
service nagios status
service mysqld status
service postresql status
service npcd status
tail -100 /var/log/httpd/error_log
Re: A strange problems after the upgrade!
Posted: Wed Jan 15, 2014 2:06 am
by huanhuan7777
slansing wrote:Please log out, and then log back into the interface, also show the output of the following:
Code: Select all
service nagios status
service mysqld status
service postresql status
service npcd status
tail -100 /var/log/httpd/error_log
Thank you for your help~~~
My /var/log/messages has a error like this:
Code: Select all
Jan 15 15:01:58 sms01 ndo2db:Error: mysql_query() failed for 'INSERT INTO nagios_programstatus SET instance_id='1', status_update_time=FROM_UNIXTIME(1389769318), program_start_time=FROM_UNIXTIME(1389763102), is_currently_running='1', process_id='29609', daemon_mode='1', last_command_check=FROM_UNIXTIME(1389769318), last_log_rotation=FROM_UNIXTIME(0), notifications_enabled='1', active_service_checks_enabled='1', passive_service_checks_enabled='1', active_host_checks_enabled='1', passive_host_checks_enabled='1', event_handlers_enabled='1', flap_detection_enabled='1', failure_prediction_enabled='1', process_performance_data='1', obsess_over_hosts='0', obsess_over_services='0', modified_host_attributes='0', modified_service_attributes='0', global_host_event_handler='xi_host_event_handler', global_service_event_handler='xi_service_event_handler' ON DUPLICATE KEY UPDATE instance_id='1', status_update_time=FROM_UNIXTIME(1389769318), program_start_time=FROM_UNIXTIME(1389763102), is_currently_running='1', process_id='29609', daemon_mode='1', last_command_check=FROM_UNIXTIME(1389769318), last_log_rotation=FROM_UNIXTIME(0), notifications_enabled='1', active_service_checks_enabled='1', passive_service_checks_enabled='1', active_host_checks_enabled='1', passive_host_checks_enabled='1', event_handlers_enabled='1', flap_detection_enabled='1', failure_prediction_enabled='1', process_performance_data='1', obsess_over_hosts='0', obsess_over_services='0', modified_host_attributes='0', modified_service_attributes='0', global_host_event_handler='xi_host_event_handler', global_service_event_handler='xi_service_event_handler''
Jan 15 15:01:58 sms01 ndo2db: mysql_error: 'MySQL server has gone away'
Jan 15 15:01:58 sms01 ndo2db: Error: Connection to MySQL database has been lost!
Jan 15 15:25:12 sms01 ndo2db: Error: Could not connect to MySQL database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I find the reason all day,but I still don't know the reason~~~
I am sorry～～～
Can you help me again？
Thank you for you help~~~
Re: A strange problems after the upgrade!
Posted: Wed Jan 15, 2014 11:08 am
by slansing
Can you run through the following document and check the web interface? We also need to know if you actually ran the commands I gave you, lets restart them now, share the output they throw out.
http://assets.nagios.com/downloads/nagi ... tabase.pdf
Code: Select all
service nagios restart
service mysqld restart
service postresql restart
service npcd restart
service ndo2db restart
tail -100 /var/log/httpd/error_log
Re: A strange problems after the upgrade!
Posted: Wed Jan 15, 2014 10:53 pm
by huanhuan7777
slansing wrote:Can you run through the following document and check the web interface? We also need to know if you actually ran the commands I gave you, lets restart them now, share the output they throw out.
http://assets.nagios.com/downloads/nagi ... tabase.pdf
Code: Select all
service nagios restart
service mysqld restart
service postresql restart
service npcd restart
service ndo2db restart
tail -100 /var/log/httpd/error_log
Hi~slansing,Thanks for your help.
(1) I operated the section of "Repairing MySQL Tables" on the document(
http://assets.nagios.com/downloads/nagi ... tabase.pdf)
nagios1.jpg
nagios2.jpg
(2)I Executed those commands you gave：
nagios3.jpg
Thanks for your time~~
Re: A strange problems after the upgrade!
Posted: Thu Jan 16, 2014 10:58 am
by slansing
Is the web interface/nagios functional again?
Re: A strange problems after the upgrade!
Posted: Sun Jan 19, 2014 9:25 pm
by huanhuan7777
slansing wrote:Is the web interface/nagios functional again?
No,it is still doesn't work!
nagios.jpg
I think it is the red question mark who caused this error.
When I put the mouse on the red question mark,the page footer displayed "192.168.0.50/nagiosxi//includes/page-default-splash.php#".
But it is why??
Thank you slansing~~~
Re: A strange problems after the upgrade!
Posted: Mon Jan 20, 2014 8:56 am
by scottwilkerson
The red question mark is supposed to be there, that is not the issue.
Is this machine behind a proxy?
Do you have more than 7 hosts configured? I ask because looking at the banner, you do not have a licensed copy of XI...