Nagios XI not displaying all the hosts

[lmiltchev]

I've seen similar issues in the past when users had the following line in the "/etc/my.cnf":

Code: Select all

sql-mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION

Changing it to this:

Code: Select all

sql-mode = NO_ENGINE_SUBSTITUTION

solved the issue.

I believe you need to remove "STRICT_TRANS_TABLES", and possibly "STRICT_ALL_TABLES".

[chicjo01]

Thank you for the information. I will pass this along to the DBA and see if there is a way to get this adjusted.

[lmiltchev]

Sounds good. We will keep this thread open for a while. Let us know if you have any more questions.