Nagios Support Forum

It looks like I needed to restart mysql for the change, i.e. changing sql-mode to an empty string, to fully take affect. I am no longer seeing that error on the home page and can apply configuration.

my.cnf: [mysql] # CLIENT # port = 3306 [mysqld] # GENERAL # user = mysql default-storage-engine = InnoDB lower_case_table_names = 1 pid-file = /var/mysql/mysql.pid # MyISAM # key-buffer-size = 32M myisam-recover = FORCE,BACKUP # SAFETY # max-allowed-packet = 32M max-connect-errors = 1000000 skip-nam...

Output from /usr/local/nagiosxi/scripts/reconfigure_nagios.sh URL: http://localhost/nagiosxi/includes/components/ccm/ CMDLINE /usr/bin/wget --save-cookies nagiosql.cookies --keep-session-cookies http://localhost/nagiosxi/includes/components/ccm/ --no-check-certificate --post-data 'submit=Login&h...

I followed the steps at https://assets.nagios.com/downloads/nagiosxi/docs/Offloading_MySQL_to_Remote%20Server.pdf to offload MySQL to a remote server on a fresh install of nagiosxi. After migrating data, updating config files, and restarting ndo2db and nagios the following occurs: * Attempting to &q...