Nagios Support Forum

Posted: **Thu May 05, 2016 2:45 pm**

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

sql-mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION

Changing it to this:

sql-mode = NO_ENGINE_SUBSTITUTION

solved the issue.

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

Posted: **Mon May 09, 2016 7:23 am**

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

Posted: **Mon May 09, 2016 9:07 am**

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

Nagios XI not displaying all the hosts