some service related links not returning

[jh129666]

When clicking on some of the service related links (e.g. service detail, all service problems, open service problems, service group summary) in nagios xi, the data isn't returned and it just spins.

When I click on the “servicegroup overview” or “servicegroup grid” it displays all the groups that are defined except for one, which just spins.

I've checked permissions, verified configuration and checked various logs but haven't found anything.

Any other suggestions?


Thanks,

Jeff

[rkennedy]

Could you show us a screenshot of what you're seeing? From the sounds of it, there may be internal calls not working properly. Could you also post these two items?
1. A screenshot of your Admin -> System Settings page
2. A copy of your /etc/hosts file

[jh129666]

The requested info is in the attached document.

We also rebooted the server but that didn't help.

[jh129666]

seeing segmentation faults in the proxy error log.

Is something hosed in the database? Is there a way to check that?

error_log:[Fri Jan 20 19:05:13 2017] [notice] child pid 22682 exit signal Segmentation fault (11)
error_log:[Fri Jan 20 19:05:21 2017] [notice] child pid 25170 exit signal Segmentation fault (11)
error_log:[Fri Jan 20 19:05:43 2017] [notice] child pid 27377 exit signal Segmentation fault (11)
error_log:[Fri Jan 20 19:05:53 2017] [notice] child pid 29646 exit signal Segmentation fault (11)
error_log:[Fri Jan 20 19:05:54 2017] [notice] child pid 22537 exit signal Segmentation fault (11)
error_log:[Fri Jan 20 19:05:54 2017] [notice] child pid 25072 exit signal Segmentation fault (11)
error_log:[Fri Jan 20 19:05:55 2017] [notice] child pid 29809 exit signal Segmentation fault (11)
error_log:[Fri Jan 20 19:05:56 2017] [notice] child pid 15317 exit signal Segmentation fault (11)
error_log:[Fri Jan 20 19:05:58 2017] [notice] child pid 22683 exit signal Segmentation fault (11)
error_log:[Fri Jan 20 19:05:59 2017] [notice] child pid 27538 exit signal Segmentation fault (11)
error_log:[Fri Jan 20 19:06:00 2017] [notice] child pid 30103 exit signal Segmentation fault (11)
error_log:[Fri Jan 20 19:06:13 2017] [notice] child pid 24835 exit signal Segmentation fault (11)

[tgriep]

You can check to see if there are any SQL errors in the following log files.
/var/log/messages
/var/log/mysqld.log
or
/var/log/mariadb/mariadb.log

That is if the MYSQL database is local to your server.

The Spinning AppOps issue, go in to the Admin > System Settings menu and change the Program URL to use the host name and not the IP address and see if that helps out.

[avandemore]

You can try some of the settings here regarding php.ini:

http://stackoverflow.com/questions/7745 ... e-error-lo

And here to generate a core dump:

http://sysadmin.carlusgg.com/?p=197

[jh129666]

Thanks for the suggestions.

I changed the program URL to use the host name but that didn't help.

I do see the below SQL errors in the messages file, and it looks like they happen once a day.

We're looking into the php.ini settings as well as generating a core dump.

messages:Jan 16 16:39:22 pmonnag001 ndo2db: Error: mysql_query() failed for 'UPDATE nagios_conninfo SET disconnect_time=NOW
(), last_checkin_time=NOW(), data_end_time=FROM_UNIXTIME(0), bytes_processed='0', lines_processed='0', entries_processed='0
' WHERE conninfo_id='0''
messages:Jan 16 16:39:22 pmonnag001 ndo2db: mysql_error: 'MySQL server has gone away'
messages:Jan 16 16:39:22 pmonnag001 ndo2db: Error: Connection to MySQL database has been lost!
messages:Jan 17 15:06:05 pmonnag001 ndo2db: Error: mysql_query() failed for 'UPDATE nagios_conninfo SET disconnect_time=NOW
(), last_checkin_time=NOW(), data_end_time=FROM_UNIXTIME(0), bytes_processed='0', lines_processed='0', entries_processed='0
' WHERE conninfo_id='0''
messages:Jan 17 15:06:05 pmonnag001 ndo2db: mysql_error: 'MySQL server has gone away'
messages:Jan 17 15:06:05 pmonnag001 ndo2db: Error: Connection to MySQL database has been lost!
messages:Jan 18 16:12:53 pmonnag001 ndo2db: Error: mysql_query() failed for 'UPDATE nagios_conninfo SET disconnect_time=NOW
(), last_checkin_time=NOW(), data_end_time=FROM_UNIXTIME(0), bytes_processed='0', lines_processed='0', entries_processed='0
' WHERE conninfo_id='0''
messages:Jan 18 16:12:53 pmonnag001 ndo2db: mysql_error: 'MySQL server has gone away'
messages:Jan 18 16:12:53 pmonnag001 ndo2db: Error: Connection to MySQL database has been lost!
messages:Jan 18 16:13:21 pmonnag001 nagios: ndomod: Please check remote ndo2db log, database connection or SSL Parameters
messages:Jan 19 22:55:52 pmonnag001 ndo2db: Error: mysql_query() failed for 'UPDATE nagios_conninfo SET disconnect_time=NOW
(), last_checkin_time=NOW(), data_end_time=FROM_UNIXTIME(0), bytes_processed='0', lines_processed='0', entries_processed='0
' WHERE conninfo_id='0''
messages:Jan 19 22:55:52 pmonnag001 ndo2db: mysql_error: 'MySQL server has gone away'
messages:Jan 19 22:55:52 pmonnag001 ndo2db: Error: Connection to MySQL database has been lost!

[avandemore]

The DB log may contain relevant information. Is the DB offloaded?

[avandemore]

Continuing in ticket.