all host pending

[lmiltchev]

On the offloaded mysql server, edit the "/etc/my.cnf" file by changing this line:

Code: Select all

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

to this:

Code: Select all

sql_mode=NO_ENGINE_SUBSTITUTION

Save, exit, restart mysqld, then restart nagios and ndo2db on the Nagios XI box. Let us know if this helped. Thank you!

[sangmin]

The configuration is already sql_mode = NO_ENGINE_SUBSTITUTION.

I tested it.
If you add STRICT_TRANS_TABLES, the number of hosts is 0
If STRICT_TRANS_TABLES is subtracted, it is set to 1 as in the existing problem, and the information of the host is changed from time to time.

[dwhitfield]

It probably makes sense at this point to submit a ticket so we can take a closer look. Please email [email protected] with a link to this ticket. A fresh profile would also be useful, if it is small enough to email.

[sangmin]

This issue has not been resolved yet.
I sent an email to [email protected], but I did not receive a reply.

[kyang]

You can try emailing [email protected] or PM me your email address so I can check if we ever received your email.