Nagios Support Forum

That fixed it. Thanks for your help

I sent 2 PMs because it said I could only attach 1 file at a time. The first is the log results and the second is the profile.

You were able to successfully duplicate the issue where hosts cannot be added to services? When I try to add a host (any host, admin-dr or otherwise) to any service (not limited to the Tomcat example services I've been using to demonstrate) or even If I try to remove 1 host from a service that has m...

I re-added the example TOMCAT service and this is the output (The service is temporarily disabled so that the verification check passes) mysql> select * from tbl_service where id = 1815; +------+-------------+-----------+----------------------+----------------+---------------------------+-----------...

mysql -u root -p'nagiosxi' -e "SELECT @@GLOBAL.sql_mode;" had extra output (I would paste what it was but my scrollback buffer ate it.) now it is set only to: +--------------------------------------------+ | @@GLOBAL.sql_mode | +--------------------------------------------+ | STRICT_TRANS...

I went through the database repair documentation and I didn't see any errors in the output. That didn't seem to fix anything, though. The problem remains

I just realized that "database repair" was a link to documentation on a database repair process. I'll run through that and let you know where that lands us.

I ran through the steps you provided, but the issue still persists. Unfortunately, now there are new problems: The *Apply Configuration button in the CCM no longer works and instead outputs "SQL Error [nagiosxi] : Incorrect datetime value: '0000-00-00 00:00:00' for column 'processing_time' at r...

I tried your suggestions, but the issue persists. I sent you a PM with the profile attached.

Hosts cannot be added to services in NagiosXI 5.8.5 see nag1. This is an example service. see nag2. I add 8 hosts to the service and click "save". see nag3. Changes cannot be applied because service has no hosts. see nag4. I go back to confirm that the recently added hosts are indeed there...