Nagios XI not displaying all the hosts

[chicjo01]

Talked with the team for that instance and they say is correct. Can we leave this open for a few days to ensure it stays in-sync.

[tgriep]

If you run

Code: Select all

ipcs -q

In the server and the Message Queue's continue to increase, then there is still a problem.
There are some settings we can adjust to see if this helps out on the Message Queue.
Can you post this file so we can review it for any changes that can be done in it?

Code: Select all

/etc/sysctl.conf

[chicjo01]

The requested information has been provided.

ipcs -q

------ Message Queues --------
key msqid owner perms used-bytes messages
0x50000002 7569408 nagios 600 12991488 12687
0x9d000002 7602177 nagios 600 0 0

# System default settings live in /usr/lib/sysctl.d/00-system.conf.
# To override those settings, enter new settings here, or in an /etc/sysctl.d/<name>.conf file
#
# For more information, see sysctl.conf(5) and sysctl.d(5).
kernel.msgmnb = 131072000
kernel.msgmax = 131072000
kernel.shmmax = 4294967295
kernel.shmall = 268435456

[chicjo01]

Our DBA team mentioned we are using MySQL version 5.6 with strict mode enabled. They think the DB errors posted earlier are being caused by:

Insert statements are missing the field and the expectation is for MySQL to use the default timestamp when adding to the MySQL server.

[tgriep]

Turn off strict mode in MYSQL. That does cause issues like you are seeing with Nagios XI.

[chicjo01]

I talked with our DBA team and per our company standards we currently can't disable it. What other options are there to correct that issue?

[tgriep]

There isn't any other options at this time. it has to be off.

[chicjo01]

Thanks for the information. I will put the request in and let my manager know. Will update for what ever happens.

[lmiltchev]

Noted. We will keep the thread open.

[chicjo01]

The DBA needs to know which restriction need to be removed? Can you provide the restrictions which need to be lifted to correct the issue?

mysql> select @@GLOBAL.sql_mode;
+------------------------------------------------------------------------------------------------------------------------------------------------------+
| @@GLOBAL.sql_mode |
+------------------------------------------------------------------------------------------------------------------------------------------------------+
| STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)