A strange problems after the upgrade!

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
huanhuan7777
Posts: 19
Joined: Thu Nov 07, 2013 12:05 am

A strange problems after the upgrade!

Post 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~~~
You do not have the required permissions to view the files attached to this post.
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: A strange problems after the upgrade!

Post 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
huanhuan7777
Posts: 19
Joined: Thu Nov 07, 2013 12:05 am

Re: A strange problems after the upgrade!

Post 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~~~
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: A strange problems after the upgrade!

Post 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
huanhuan7777
Posts: 19
Joined: Thu Nov 07, 2013 12:05 am

Re: A strange problems after the upgrade!

Post 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~~
You do not have the required permissions to view the files attached to this post.
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: A strange problems after the upgrade!

Post by slansing »

Is the web interface/nagios functional again?
huanhuan7777
Posts: 19
Joined: Thu Nov 07, 2013 12:05 am

Re: A strange problems after the upgrade!

Post 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~~~
You do not have the required permissions to view the files attached to this post.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: A strange problems after the upgrade!

Post 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...
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked