Nagios Support Forum

I removed this component and 2 others earlier this week, following instructions here, https://support.nagios.com/forum/viewto ... 16&t=61205

rm -rf /usr/local/nagiosxi/html/includes/components/nagiosim
rm -rf /usr/local/nagiosxi/html/includes/components/active_directory
rm -rf /usr/local/nagiosxi/html/includes/components/ldapauth

Removing these had no affect on the api issue.

Changing mysql sql_mode to "" has corrected this issue.

I modified the systemd unit file and set sql mode here ...

ExecStart=/usr/libexec/mysqld --basedir=/usr --log-error --sql-mode=""

Mode now shows empty string ...
$ mysql -u root -p'nagiosxi' -e "SELECT @@GLOBAL.sql_mode;"
+-------------------+
| @@GLOBAL.sql_mode |
+-------------------+
| |
+-------------------+

---------------------------------

I am now able to add hosts via the api and they appear on disk, in xi and in core. This change appears to have corrected the api issue.

This thread and thread https://support.nagios.com/forum/viewto ... 246#334218
have been combined to one ticket https://support.nagios.com/tickets/scp/ ... p?id=15264