Unable to add Host or Hostgroup to service

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
noweda
Posts: 52
Joined: Fri Dec 06, 2013 2:47 am

Unable to add Host or Hostgroup to service

Post by noweda »

Hello support,

we are running a new NagiosXI installation to migrate our production system from CentOS 6 to CentOS 8.

Nagios XI - System Info
System
Nagios XI version: 5.7.5
Release info: ux010163.noweda.de 4.18.0-193.14.2.el8_2.x86_64 x86_64
CentOS Linux release 8.2.2004 (Core)
Gnome is not installed

Apache Information
PHP Version: 7.2.24
Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36

In the new installation we are unable to add hosts or hostgroups to services. We can choose and assign them as usual, but when we save the service, the assignments are gone. When we change other things, like the service name for example, this is saved, but all host or hostgroup assignments to services are not.

Do you have any ideas?

If you need a profile.zip, please provide me a PM.

Best regards
Christoph
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: Unable to add Host or Hostgroup to service

Post by dchurch »

Sounds like there might be a database error.

If you PM me a system profile I can diagnose further. Get one by going to Admin (top menu) => System Profile (in the left menu), then clicking the blue button.

In the meantime, you can try running the database repair script
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.

Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
noweda
Posts: 52
Joined: Fri Dec 06, 2013 2:47 am

Re: Unable to add Host or Hostgroup to service

Post by noweda »

Sorry, for the delay in this case.

I executed the script "/usr/local/nagiosxi/scripts/repair_databases.sh" with success:

Code: Select all

===============
REPAIR COMPLETE
===============

=======================
nagios database repair succeeded
nagiosql database repair succeeded
nagiosxi database repair succeeded
Unfortunately, the issue still persists. System profile sent via pm.

Sincerely,
Pasqual
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: Unable to add Host or Hostgroup to service

Post by dchurch »

Next thing you could try is clearing the objects.cache file:

Code: Select all

rm /usr/local/nagios/var/objects.cache
service nagios restart
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.

Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
noweda
Posts: 52
Joined: Fri Dec 06, 2013 2:47 am

Re: Unable to add Host or Hostgroup to service

Post by noweda »

Hello dchurch,

I cleared the cache, but the issue persists.

Did you find any issues in the profile, Pasqual sent you? What can we do now? The system is not usable at the moment!

Best regards,
Christoph
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: Unable to add Host or Hostgroup to service

Post by dchurch »

The default settings for MySQL server in CentOS 8 changed. Refer to this doc to check/update the necessary setting.

https://support.nagios.com/kb/article/n ... s-780.html
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.

Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
noweda
Posts: 52
Joined: Fri Dec 06, 2013 2:47 am

Re: Unable to add Host or Hostgroup to service

Post by noweda »

Hello dchurch,

thank you for your reply. I tried that, but now I'm not able to open CCM "Services" nor "Hosts" anymore. When I click on Services or Hosts, the site does not open, but the browser stucks at "waiting for ux010163". I waited 1 hour, but the site does not open.

The same happens, when I try to download Nagios system profile...

Any ideas?

Best regards
Christoph
noweda
Posts: 52
Joined: Fri Dec 06, 2013 2:47 am

Re: Unable to add Host or Hostgroup to service

Post by noweda »

Hello dchurch,

sorry, the "waiting for" problem was related to an http and certificate problem. Now it works and with the mysql changes I'm able to attach hosts again.

Thank you for your help.

Best regards
Christoph
Locked