Page 3 of 3
Re: all host pending
Posted: Tue Oct 17, 2017 11:08 am
by 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:
Save, exit, restart mysqld, then restart nagios and ndo2db on the Nagios XI box. Let us know if this helped. Thank you!
Re: all host pending
Posted: Sun Oct 22, 2017 8:54 pm
by 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.
Re: all host pending
Posted: Mon Oct 23, 2017 1:04 pm
by 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.
Re: all host pending
Posted: Wed Oct 25, 2017 8:51 pm
by sangmin
This issue has not been resolved yet.
I sent an email to
[email protected], but I did not receive a reply.
Re: all host pending
Posted: Thu Oct 26, 2017 9:18 am
by kyang
You can try emailing
[email protected] or PM me your email address so I can check if we ever received your email.